Inventory Reconciliation of Sage ACCPAC ERP

By | May 24, 2011

Do you know that inspite of Physical Inventory stock equals with the Count in Inventory module, the GL value of Inventory does not match with Inventory Movement Report Value?

The answer is “Yes it is true” and the common reason it can happen provided someone has posted entries directly through GL. There is another reason for it too.

Accpac allows to change Inventory Account Set even if the inventory balance is not 0.

So for e.g say there are 2 sets for Inventory that you maintain say Stationeries and Accessories and you have 2 different G/L codes for them respectively.

At the time of creation of an Item Code, user selected it as Stationary where as it should have been Accessory. Now the user receives 10 QTY at the rate of $200. So the inventory Valuation is 2000 for Stationary. If at this time if you take inventory movement report and match it with G/L inventory. This will match. Now say you run day end process and change the Item Account set to Accessory. And now if you print the inventory movement report and try to match it with G/L for accessory it won’t match.

The Accessory in G/L will show 0 value. The reason behind this is ERP won’t change your accounting entries already passed when one changes the master.

So one should take care that he either defines the master well or make sure that change the account set only once the inventory balance is of both in GL and Inventory module.In the above scenario, if the user wants to change the account set before shipping the inventory out, he can do one of the following

  1. Pass a reversal entry of the inventory inwards. Run dayend. Change the Account set and then Inward the inventory again.
  2. Pass an Inventory adjustment with Both Decrease such that your inventory balance nullifies in the specific period required. Run day End and then change the account set.

Once the account set is changed Pass another Adjustment Entry with Both Increase such that your Inventory balance is re-instated.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.