Sage Accpac Sales Data in Excel Pivot Tables
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.
