Sage 50 Integration: Working with Inventory


Now that you've completed the wizard, the integration will mostly take care of itself. Remember to always have the ESC Accounting Server open and connected. Below you will find more information on how the integration functions and how information is transferred.

Inventory Management
ESC handles the inventory quantity control, while Sage 50 maintains the inventory ledger balances. Thus, ESC tracks the quantity, inflows, and outflows of an individual part, while Sage 50 tracks the movement in value of the inventory asset accounts. When an item is added into ESC, it is not automatically added into Sage 50. However, when a Sales Invoice in ESC is posted to Sage 50, the items listed on the invoice are added to the Item List in Sage 50. You will see the item appear with an "S_" prefix.

Example: The "MAT" billing code will appear in Sage 50 as "S_MAT". An inventory item with a Part Number of "0000408100" will appear as "S_0000408100".

Inventory Adjustments
An inventory adjustment entered into ESC will create a general journal entry in Sage 50 for the value of the adjustment, increasing the Inventory Asset account if parts are added in ESC, and reducing the value of inventory if the quantities are lowered. The Adjust Inventory screen asks for a Credit Account; this is referring to the account that will be used to create the transaction. The other side of the transaction is always the Inventory Account of the part being adjusted. Thus, if you wanted to create a wash transaction (where the ledger balances do not change as a result of the adjustment), you would enter the same account number in the Credit Account field that is in the Inventory Account field for that part.

Sage 50 Integration: Working with Jobs and Job Costing

0 people found this helpful



Please sign in to leave a comment.