This error (“can’t find file”) can occur when applying a new update in AccountsMate. From our investigation this seems to be a permission issue related to the security set up of Windows on the computer.
To get around this, you need to run the AccountsMate executable program directly from the installation folder instead of a shortcut (i.e. from the desktop or task bar). You can do this as follows.
Locate the correct folder in Windows File Explorer this is normally “C:\Program Files (x86)\PTServices\AccountsMate”.
Click on the application executable file AccountsMate.exe (it maybe just displayed as AccountsMate) – see below
This will run the AccountsMate program with the correct full permissions to apply the update.
Follow the instructions to apply the update.
Once the update is applied AccountsMate will close, from that point on you can run AccountsMate as normal (i.e. form the desktop or task bar shortcuts, etc.).
There may be issues downloading the AccountsMate installation, these are normally due to browser or computer security settings.
The following may help:
Microsoft Edge Browser
The download may be blocked as shown below
To release this, click on the 3 dots (…) and select “Keep” and continue as instructed.
Chrome Browser
Chrome often will not even prompt you about a blocked file. It just seems to do nothing. In this case, try clicking on the 4 dots in the chrome bar to bring up the menu and select “Downloads”
This should show the AccountsMate blocked download, click this and the “Windows Protected your PC” screen should appear.
Other Issues
If you have further problems, try using a different browser. you can copy and paste the download link.
If you can, try disabling your firewall and/or any anti-virus temporarily which may be blocking the download.
Finally, consult with your IT provider and ask them to allow the download.
AccountsMate is Pimbrooks enhanced query tool for Sage 50 and is available free of charge as part of our Sage 50 support service, for more details including a demonstration video see this link -> AccountsMate For Sage 50 Overview
A new version of AccountsMate has been released. This is the 2nd release and is another significant update that will allow you to
age debtors and creditors by different methods (i.e. due date),
look at your sales despatches and purchase deliveries (which is not easy in Sage 50)
drill into related data on your products, such as sales, purchases, despatches, deliveries and adjustments.
sort your nominal information in “chart of account” order and view by quarter or week (as well as year and month).
The following Highlights section summarises the release features and for more information see the Details section.
Highlights
The main changes in this release are:
Overview, Customer and Supplier Enquiries improved to allow multiple aged debt methods (e.g. by period, transaction date or due date) and a selected aging date. Also added an Overdue column.
Nominal Data Analysis Enquiry improved by adding Quarter and Week columns.
New Sales Despatch Enquiries – under Sales Order Enquiry to show despatches for a sales order and from the menu to enquire on all Sales Despatches.
New Purchase Delivery Enquiries – under Purchase Order Enquiry to show deliveries for a purchase order and from the menu to enquire on all Purchase Deliveries.
Product Enquiry enhanced to show associated sales, purchase, delivery, despatch and adjustment information.
Nominal Enquiries enhanced to allow sorting of nominal accounts in chart of accounts sequence (i.e. P& L – Sales, Cost, Overheads, etc.).
A number of performance enhancements and fixes (e.g. faster handling of larger data sets)..
Management improvements (e.g. restricting new companies in roles).
The new version of AccountsMate will be downloaded automatically the next time a user opens the application, just accept all questions and the software update will be installed (note, you will have to have administrator permissions for the PC).
Versions
To check if you are using the new software, check the versions under Help – About, they should be as follows.
AccountsMate Console 1.4.0
AccountsMate Plugin 1.7.0
Technical List of Changes
AccountsMate Console 1.4.0
Role Maintenance
When adding new roles all existing companies are excluded from users by default, they must be manually added via Menu configuration maintenance.
Company Maintenance Each new company is now excluded by default from existing roles.
General
Change control of System Administrator mode.
AccountsMate Plugin 1.7.0
Overview/Customer/Supplier Enquiries
Now displays Ageing of the current debt via two new Current/Future columns.
To calculate where the debt resides, Ageing Criteria has been added that calculates it based on Account Terms which is as seen in Sage50 or Due Date or Transaction Date.
Now displays an Overdue column showing values of accumulated unpaid transactions whose due date has passed based on the ageing date.
Customer Sales Orders Enquiry
New Despatch tab added to the details panel that shows despatch details for the Sales order selected.
Customer Transaction Enquiry
Fixed bug where if a large number of transactions where requested it slowed the loading of data into the data grid.
Supplier Transaction Enquiry
Fixed bug where if a large number of transactions where requested it slowed the loading of data into the data grid.
Customer Sales Order Despatch Enquiry
New form created to enquire on Customer Despatches.
Product Enquiry
Now shows associated data for sales/purchase/delivery/despatch/adjustment in a details panel at the bottom of the form.
Supplier Purchase Order Delivery
New form created to enquire on Supplier Deliveries.
Nominal Transactions Enquiry
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.
Nominal Codes Enquiry
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.
Nominal Transaction Analysis
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.
Two new columns Quarter and Week columns have been added that enable the user to review data over those time periods.
General
Fixed bug in all forms where saving a new layout could over writing existing layouts in certain circumstances.
Fixed bug in all forms that displays an account balance, where when the cell is selected the formatting was lost.
Fixed bug in all forms where the columns where not having “Best Fit” applied to detail grids.
Fixed bug in all forms where it was always prompting the user to save layout even if the layout had not been changed.
In all forms with grids, when a column is sorted now makes sure the first grid line is always visible.
The new version will be downloaded automatically the next time a user opens AccountsMate, just accept all questions and the software update will be installed.
Versions
To check if you are using the new software, check the versions under Help – About, they should be as follows.
AccountsMate Console 1.3.0
AccountsMate Plugin 1.5.0
Technical List of Changes
AccountsMate Console v1.3.0
About Form
Now shows the Sage50 version.
Only displays single version entry for AccountsMate plugin, rather than by function.
Company Change Form
To change the existing Company working on no other forms can be open.
License Maintenance Form
If not an application/organisation administrator, then block access to the form.
Form loading speeded up.
Can now import license details.
Can now copy licenses.
Summary added that shows a count of current licenses.
When creating an installation string Accounts Type is now defaulted to Sage50
Fixed bug where changes to data in property sheet were not being reflected in the grid.
Can now filter/sort and export data if in System Administrator mode
Fields Account Ref, Type, Reference added.
Application Start-up
Changed so that if the current license is going to expire in 30 days, indicate if there is a new license that is going to become active or if the software will become un-usable.
Message changed when prompting the user if they are Organisation Administrator where one does not exist.
General
Change system administration mode access.
Fixed bug that now clears Menu Security locks for the current user when they enter menu mode.
System Options Form
Fixed bug where if prompted for administrator password it would still save the details entered even if the user selected ‘Cancel’.
User Maintenance Form
Fixed bug where a System Administrator could not update the expiry date.
Fixed bug where the ‘force logout’ option should only be enabled if System/Organisation Administrator.
Fixed bug where changes to data in property sheet were not being reflected in the grid.
Company Maintenance Form
Fixed bug where an Organisation Administrator could not add/delete Companies.
Fixed bug where changes to data in property sheet were not being reflected in the grid.
AccountsMate Plugin v1.5.0
Customer Transactions
New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
Customer Name now part of default layout.
Quotation Form
New form showing Customer quotations.
Sales Analysis Form
Type criteria now defaults to include credits rather than excluding.
New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
Fixed bug where Profit was being calculated incorrectly.
Supplier Transactions Form
New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
Purchases Analysis Form
New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
Nominal Form
New function that allows a user to enquire on Nominal account data.
Nominal Transaction Form
New function that allows a user to enquire on Nominal Transactions.
Nominal Data Analysis Form
New function that allows a user to analyse Nominal Transactions by COA.
Customer Sales Invoices and Credits Form
New function that allows a user to enquire on a Customer’s Invoices and Credits
Supplier Purchase Order Form
New function that allows a user to enquire on a Supplier’s Purchase Orders
Initial Installation
The installer can now change the Sage50 user/name password at Company level if required when setting up Companies.
To install AccountsMate you will need the following
1. An email from Pimbrook Software with the AccountsMate installation string.
2. If this is the first installation of AccountsMate in the organisation a set up will run to link to Sage 50 and you will need to ensure the following:
AccountsMate is run for the first time on a computer that has Sage 50 installed in order to complete its initial setup.
You have a Sage 50 login (user & password), it is recommended to use the “manager” login details to give full access.
3. It is recommended that your Sage 50 should be the latest version for the best compatibility, but it must be at least version 24 or higher.
Installing the Software
To install the AccountsMate software application, follow these steps;
2. Copy and paste the install string from your installation email into the Enter Install String box when prompted,
3. Click Install and confirm the organisation details.
3. The installer will download the application software and prompt for the install folder,
4. Accept the default folder (or change if required) and click Next to confirm the installation.
5. The installer will display a screen to indicate when the installation is complete.
6. Click Close.
7. There should be an AccountsMate Console icon on the desktop, click this to start AccountsMate.
Setting Up the Software (at first run only)
When AccountsMate is run for the first time, it will start a Set Up process to link with Sage 50.
The following steps are involved.
1. AccountsMate requires at least one administrator user to complete its set up. The system will ask if you want to be the administrator.
2. Click Yes to become an administrator.
3. The system will prompt to set up a link to the Sage 50 companies.
4. Click Yes.
5. The system will display the Company Creation screen (see below) and scan for Sage 50 companies.
6. When it finds them it will display the available Sage 50 companies.
7. Enter the Sage 50 login User & Password (t is recommend to use the “manager” login for full access).
8. Press the Test button in the top toolbar.
9. AccountsMate will test the connection to each company included and return the Test Result. If unsuccessful, the login details are probably incorrect, try a valid Sage 50 login and test again. When AccountsMate successfully connects to a company it will display the Company Name from Sage 50, as shown in the screen sample below.
10. Ensure the companies required are ticked under the Included column, as shown above.
There may be issues with the installation depending on a users system environment and set up. Below are the common ones we have seen and how to address them.
Problem Finding Sage 50 Companies
AccountsMate may not be able to find the Sage 50 companies at the Company Creation screen (step 5-6 in the Setting Up section above). If this is the case the user will be allowed to browse the system to find the Company.UNC or Company file on the computer. Please ensure that AccountsMate is being run the first time on a computer that has Sage 50 installed. The user may also need to enter the version number in this case.
Setting Up AccountsMate to Run on a Computer With No Sage 50
AccountsMate can be set up to run on a PC that does not have a Sage 50 client installed. This is useful if you wish to give access to users that do not have full access to Sage 50. The following link gives instructions on this set up
AccountsMate for Sage 50 is an enhanced query tool supplied by Pimbrook Software to allow clients to open up their Sage 50 data by:
Giving current users better ways to enquire on the Sage 50 information.
Allowing staff that currently do not have Sage 50 access to view key information (e.g. customer service can view account information, sales reps can see product and prices or warehouse staff can lookup stock details).
Exposing Sage 50 information to remote staff.
It is easily installed and set up with no extra Sage 50 licences needed or no need to have Sage 50 installed on the PC.
See the links below for more information on AccountsMate: