Skip to main content

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: TEKOA software


Do you have large volumes of A/R History Invoices in your Sage 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 Sage 100 AR Invoice History in SQL and speed up MAS inquiries by purging, contact TEKOA today.

TEKOA erp software
www.TekoaSoftware.com
Labels:

Comments

Post a Comment

Popular posts from this blog

How To Connect Sage 100 to Excel

Pull data directly from Sage 100 into Microsoft Excel for business intelligence analysis without any 3rd Party Add-Ins. By: Tekoa Software Sage 100 ERP MAS90 MAS200 data can easily be pulled directly into Excel.  Excel can perform this functionality without any third-party add-ins or tools.  Use the Excel built-in data tools to pull live Sage 100 ERP data into a spreadsheet, then analyzed the data and write reports using Excel. This allows you to use Excel to: Create Pivot Tables of Sage MAS data Quickly Filter and Sort Sage 100 data Easily Analyze data Build Excel Worksheets that reference live Sage 100 ERP data 1. Open a new Excel spreadsheet and go to the Data tab.  Select the From Other Sources dropdown and select From Data Connection Wizard. 2. Select ODBC DSN. 3. Select SOTAMAS90, which is the Sage 100 ERP ODBC driver name. 4. Login to Sage 100 using credentials that have access to the ODBC files you want. 5. Select any Sa...
Post a Comment
Read more

Digital Tools and Digital Practices for Success

It has become somewhat obvious in recent years that technology is essential for the advancement of businesses. However, what's the best way to advance? A study recently conducted by Google and Deloitte Surveying, affectionately called, "The Study," found that online advertising and digital business tools have done a lot to improve the productivity of small business across the globe. In most cases the tools increased productivity by 300% . Deloitte surveyed businesses that implement Facebook, Twitter, YouTube, Instagram, and Pinterest to see if there was any difference in their productivity. This entailed the social media side of the survey. The other side of the survey analyzed the effects of things such as websites, analytics, online marketing, cloud-based communication, and other digital channels. Before diving into Deloitte's study, it would be a good idea to separate the alternate realities of social media and digital tools. According to the Meriam ...
Post a Comment
Read more

Remote Desktop and Sage 100 Explained

Essential Insights Into Remote Desktop Terminal Services and Sage 100 By: Tekoa Software Cloud Enable Your Enterprise Sage 100 MAS 90 and MAS 200 from Sage Software are two of the most widely used mid size business management and accounting applications in service today. Both MAS 90 (standard) and MAS 200 (advanced) share the same end-user capability and functionality. The primary difference between MAS 90 and MAS 200 is the back-end technology. MAS 200 is a client-server application which works more efficiently than MAS 90 on wide area networks and large user counts. One method gaining popularity among business that own Sage ERP 100 MAS 90 and MAS 200 is the use of Sage 100 Remote Desktop . There are a number of benefits to using Remote Desktop Services for Sage ERP 100 MAS 90/200. Here is a list of some of the benefits: 1. Improved Security Something your MAS consultant may not tell you is that Sage MAS 90 and MAS 200 require Full Access network security ri...
Post a Comment
Read more