How to set up Posting by Warehouse to General Ledger in Sage 100

The multi-warehouse capability of the Inventory Management module allows the accounts setup in Product Line Maintenance to be posted to General Ledger accounts by sub-accounts representing the warehouse. Whenever a transaction is processed for the warehouse, the warehouse identification (segment value) is assigned to the General Ledger account number to be posted.

1. Open Inventory Management, Setup menu, Inventory Management Options,
2. Click Main tab
3. Select Require Multiple Warehouses check box
4. Click G/L Segment for Whse Postings drop-down box, and select the sub-account segment to use.
   • Note: The account structure, segment type, size, and description are set up in General Ledger, Setup menu, Account Structure Maintenance.
5. Open Inventory Management, Setup menu, Warehouse Code Maintenance.
6. For each Warehouse Code, enter the “Post to ” value for each warehouse
   • Note: The number of characters is determined by the size of the General Ledger segment assigned to the warehouse posting The characters can be alphanumeric if the segment tyep allows
     Example: If “LA2” is entered as the segment value for Warehouse 002, and the second segment of the G/L account is being used, the account number posted for inventory might look like “115-LA2-000”. When an invoice is updated from the Sales Order module and the item entered is pulled from Warehouse 002, the credit to Inventory uses G/L account “115-LA2-000”.
7. Open Inventory Management, Setup menu, Product Line Maintenance.
8. Select Product Line (the following steps should be completed for each product line to be affected)
9. Click Accounts tab
10. Select Post by Whse checkbox for each GL accounts that will be flagged to use the segments specified in Warehouse Code Maintenance based on which warehouse the item will be put into or pulled from
11. Open General Ledger, Main menu, Account Maintenance
12. Verify as existing, or create each General Ledger account that will need to exist, to include every segment value.
    • Note: For every G/L account type set in Product Line Maintenance for each Product Line and segment created for by warehouse code, a General Ledger account must exist.
      Example: If the segment value for Warehouse 002 is “LA2”, then General Ledger accounts must be created to include “LA2”, such as “115-LA2-000” for Inventory, “450-LA2-000” for Cost of Goods Sold, etc.
    • Note: If the warehouse segment value assigned to an account number results in an undefined (non-existent) account number, postings are made to the original account number specified for the Product Line.
13. Open Sales Order, Setup menu, Sales Order Options
14. Click Post Sales to General Ledger by Division drop-down box
15. Select Warehouse