July 20, 2009

FIFO/LIFO Perpetual Stock Status Report

Using FIFO or LIFO Perpetual to value your inventory? Want a Stock Status report that ties back to your GL balance?

Modify the Purchase Receipts report to sum the quantity fields in the Site Footer, then insert calculated fields in the Site Footer and Item Footer to subtract the ‘Sold’ from the ‘Received’ quantities to arrive at the 'On Hand' quantity. The total 'Value Remaining' is what your Inventory account balance should tie to.

Although this won’t work as well if you’re using multi-bin because the Purchase Receipts report only reports at the Site level, it makes a great inventory sub-ledger if you only need a Site level report.