Set Up Posting by Warehouse in Inventory Management

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

The multi-warehouse capability of the Inventory Management module allows the Inventory, Cost of Goods Sold, Adjustment, and Purchases Clearing accounts to be posted to the General Ledger module by warehouse. When a transaction is processed for the warehouse, the warehouse ID (segment value) is assigned to the general ledger account number to be posted.

Use this procedure to set up the system to post by warehouse.

 

To set up posting by warehouse in Inventory Management

  1. Select Inventory Management Setup menu > Inventory Management Options.

  2. Select the Require Multiple Warehouse check box. For more information, see Inventory Management Options - Fields.

  3. In the G/L Segment for Whse Postings field, select Department or Location.

  4. The department is the second segment of the account number. For example, ###-##-#### where ## is the department.

  5. The location is the third segment of the account number. For example, ###-##-#### where #### is the location.

  1. Click Accept.

  2. Select Inventory Management Setup menu > Warehouse Code Maintenance.

  3. In the Post to Location field, enter an alphanumeric value for each warehouse. The number of characters is determined by the size of the General Ledger segment assigned to the warehouse posting. For more information, see Warehouse Code Maintenance - Fields.

  4. Click Accept.

  5. Select Inventory Management Setup menu > Product Line Maintenance.

  6. IFor each product line and account, select the Post by Whse check box to use the segments specified in Warehouse Code Maintenance based on which warehouse the product is pulled from when invoicing. For more information, see Product Line Maintenance - Fields.

  7. Select General Ledger Main menu > Account Maintenance.

  8. Create account numbers which include all the segment values. For more information, see Create and Maintain Accounts in Account Maintenance.

  9. Select Sales Order Setup menu > Sales Order Options.

  10. Set the Post Sales to General Ledger by Division to Warehouse. For more information, see Sales Order Options - Fields.

  11. Click Accept.

The Inventory Management module has been set up to post by warehouse.