Sunday, February 19, 2017
How To Speed Up Invoice History in Sage ERP 100 MAS
How To Speed Up Invoice History in Sage ERP 100 MAS
How you can purge Accounts Receivable Invoice History in Sage ERP 100 MAS90 MAS200 and still be able to access to the data.
By: Kevin Conlin
Do you have large volumes of A/R History Invoices in your Sage ERP 100 files? Does the lookup cause delays for your MAS users? But you don’t want to lose the ability to be able to view and print history invoices.
Here’s what we’ve done at Tekoa Software to make this a reality.
The Accounts Receivable / Sales Order invoice history tables are updated nightly to an external SQL database [a non-MAS table] automatically [via a SQL script]. A Crystal Report has been designed along with parameter fields to select customer invoices to be viewed or printed from the SQL database. Older A/R invoice history can then be purged using the Account Receivable Utilities. This speeds up the lookup process for Invoice History Inquiry and allows users to print and email more recent invoices from the MAS interface.
For example, the external SQL database maintains a perpetual invoice history table, while within MAS we purge invoice history leaving only the most recent 2 years of data. For older invoices, they can be printed from either an option on the MAS task menu, or a simple user interface, retrieving the desired invoice from the external SQL history tables. The user interface is easily modified to add selection options by customer number, invoice number, and invoice date [or additional search fields].No changes or modifications to the Sage code, and access to needed history transactions with the speed and reliability of SQL. In addition, the Express versions of Microsoft SQL are free of charge and can perform this functionality without any additional software cost.
For more information about how to save MAS90 and MAS200 AR Invoice History in SQL and speed up MAS inquiries by purging, contact Tekoa today.
Author: Kevin Conlin
Sage ERP 100 Business Analyst and Software Consultant
www.TekoaSoftware.com
Available link for download
