Working with 12-Inventory > 12-2 Inventory Allocation > About inventory allocation

About inventory allocation

Note: This functionality is available only if you have the Inventory Add-On Module.

Inventory moves into the control system through payable invoices, service receivables credits, inventory allocation, or purchase order receipts. After the inventory is entered into the system, you can use the 12-2 Inventory Allocation window to track movement among locations and to place stock on hold. You can also post transactions to the general ledger for the consumption of stock items by your company, the loss or shrinkage of stock items, and the revaluation of stock.

The grid contains Source and Destination columns.

The grid also contains an Account column. If the transaction affects the general ledger, you must enter the account number.

On a single grid line, you can provide information in only two of these three columns and the type of transaction determines which columns to use. For example, to move inventory to a different location, enter where the inventory is coming from in the Source cell and where the inventory is moving to in the Destination cell. Or if you want to adjust the quantity for a particular item for shrinkage, enter the quantity lost to shrinkage in the Quantity cell, the location of the quantity that was lost in the Source cell, and then enter the overhead expense account in the Account cell.

Note: Inventory allocations always use the weighted average cost for items, regardless of the inventory valuation method specified for the general ledger. If you use the LIFO or FIFO valuation method for general ledger, you can print the General Ledger Cost Comparison report (using the 2-3 Income Statement menu) to view inventory variances created by allocations. For more information, see About inventory variance reconciliation..

Links to more information . . .

More resources

For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.

For additional training on Sage products, visit Sage University.