Sage Accpac Accounting Software Vancouver Blog - Unisoft

Using Excel to retrieve sales information from Sage Accpac is quite simple and powerful.  In both the Order Entry and Inventory Control Modules there is a table that includes sales statistics. ICSTATI is the name of the table that includes the sales details for the inventory module. Essentially this is is a table that includes records per accounting period for the quantity sold, sales amount, return amounts and cost of goods sold.  By importing this table into Excel you can easily create a pivot table/report that shows your net sales (sales - returns) for a range of periods and/or years as shown below.

Sales by Period for 2009/2010

Preparing such reports can be accomplished with the help of our consultants, 604-926-3398.

New Sage Accpac ERP and CRM webcasts were released on unisoft’s website. Unisoft will be adding more webcasts on an ongoing basis so make sure to check back often.  There will be webcasts focusing severa categories.  Current Sage Accpac ERP and CRM users will be provided with webcasts on tips and tricks on how to use more of their business software and accounting system. There will also be a section for users on the new features in each version to keep you up to date on the lastest product developments. Finally, there will be a general business level section for managers and desicion makers to see how ERP and CRM software systems can help advance their business.

I wrote an article a while back about how to use the Sage Accpac data integrity check tool but did not include anything about how to analyze the reports generated from the data integrity check. As a consultant I have been asked many times from very worried customers why their data integrity check report is showing errors. In data integrity checks reports their are two different types of errors:

• Type 1 errors are data errors and need to be dealt with immediately as the represent damage or corrupted data. An example would be an corrupted data file that can’t be accessed by your data engine.
• Type 2 errors are accounting errors and can be quite normal but you should pay attention to these types of errors. An example of a type 2 error would be missing item number or order number.

It should be quite obvious to tell the difference between the two.  Again type 1 are almost alyways serious and should be dealt with immediately while type 2 can be serious but most times can be left alone or attended to at a later date. At Unisoft, we find it good practice to run the data integrity check once a month and try to fix any errors on an ongoing basis.