The following user guide will get you started using AccountsMate and provide a reference to help you use all of its features.
The link below is to a brief tutorial video which shows you the main features of AccountsMate.
A new version of AccountsMate (Pimbrook’s enhanced Sage 50 enquiry tool) has been released and provides the following features:
AccountsMate is available free of charge to our clients as part of our Sage 50 support service. For more details, including a demonstration video, see this link -> AccountsMate For Sage 50 Overview
Once the new version of AccountsMate is available it 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 be connected to the internet and have administrator permissions for the PC).
To confirm that you are using the new software, check the versions under Help – About, they should be as follows.
New Sales/Purchase Order and Invoice Line Enquires have been provided. This allows users to enquire from the line detail perspective making information like customer and product sales/purchases much easier to get.
The cost at the time of a sale has been added. This is not currently available in standard Sage 50 and so allows AccountsMate users to report more accurate cost of sales and profit figures. The application uses the product audit transaction list in Sage 50 to find the nearest cost price to the date of the sale for a product.
The following fields have been added to the Supplier and Customer Transaction Enquiries.
Also the Line Type (i.e. Stock/Service) have been added to Sales/Purchase Order, Invoice & Analysis Enquiries.
AccountsMate will now display the Custom Field Labels from Sage 50 (e.g. for Customer/Supplier Analysis Codes & Address Lines and Product Categories). This will make enquiries more readable.
The latest versions of Sage 50 are now fully supported.
Support for Sage 50 v27 including the following new fields
Support for Sage 50 v28 including the following new fields
Support for Sage 50 v29 including the following new fields
When changing companies the application will now allow users to test the connection to the new company before trying to load data. This allows quicker confirmation of the connection to the new company.
Improved Refreshing of Data across all enquiries. This is done by loading the data in batches and shows the progress of the refresh. It also allows the user to cancel. The total records are displayed when a refresh is complete.
The following fixes have been included in this release.
a. Correct the error when displaying Product details from another enquiry.
b. Load Customer details when called from the Quote Enquiry.
c. Show the correct related data (e.g. customer communications, etc.) when clicking on the first row of an enquiry.
d. Sales Invoice Enquiry – show the lines of a sales invoice when only one invoice is loaded. Also show the invoice number first and sort by this in the default layout.
e. Remove the error when an extra Product field is added to the Order & Quote Enquiry.
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.
The AccountsMate application holds configuration information in its own cloud data storage. This is accessed via a webservice over the internet. Connection to this can be lost for various reasons which will cause issues when trying to run the application. The details of some of the common errors and their causes are listed below
1. …The request failed with the HTTP status 403: Forbidden….
2. Please not the application is offline….
1. No internet access – If the computer on which AccountsMate is running does not have connection to the internet these issues will occur. To resolve this ensure the computer is connected to the internet.
2. The application or its webservice connection is being blocked. This can be due to security measures on the network or systems on which AccountsMate is trying to run. Follow the troubleshooting steps below to resolve this.
a. Check the connection to the webservice.
b. Ensure that the application (AccountsMate.exe) is not blocked by a firewall or antivirus.
Tip: To quickly eliminate blocking by anti-virus and/or firewall, try temporarily turning off these components one at a time for a very short period while you run the application. If the application runs successfully, then configure the component that is blocking the application so that it can be active but will allow AccountsMate to operate. This normally involves setting up permissions in your anti-virus to allow the AccountsMate executable (AccountsMate.exe) to run and the webservice connection to pass through your firewall.
There may be issues downloading the AccountsMate installation, these are normally due to browser or computer security settings.
The following may help:
The download may be blocked as shown below
To release this, click on the 3 dots (…) and select “Keep” and continue as instructed.
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.
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
The following Highlights section summarises the release features and for more information see the Details section.
The main changes in this release are:
The following short video shows these -> AccountsMate May 2021 Release
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).
To check if you are using the new software, check the versions under Help – About, they should be as follows.
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.
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.
A new version of AccountsMate has been released. This includes the following main changes.
A video showing these highlights with ideas on how to use them can be seen here -> AccountsMate March 2021 Release Highlights
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.
To check if you are using the new software, check the versions under Help – About, they should be as follows.
About Form
Company Change Form
License Maintenance Form
Application Start-up
General
System Options Form
User Maintenance Form
Company Maintenance Form
Customer Transactions
Quotation Form
Sales Analysis Form
Supplier Transactions Form
Purchases Analysis Form
Nominal Form
Nominal Transaction Form
Nominal Data Analysis Form
Customer Sales Invoices and Credits Form
Supplier Purchase Order Form
Initial Installation
AccountsMate can be installed and run on a PC without the Sage 50 client application, this is done as follows.
1. Install AccountsMate as normal – see AccountsMate For Sage 50 – Installation Instructions
2. As part of the installation, if Sage 50 is not installed on the PC the user will be prompted to enter the version of the ODBC driver required for their Sage 50, see a sample screen shot below.
3. Enter the correct version and click Install, the ODBC driver will be installed.
4. This ODBC driver should now allow access to the Sage 50 data.
