FIFO Stock Status Report
Frank Hamelly | MVP...
46,532
Super User 2025 Season 1
Like
Share
ReportWant a FIFO Stock Status report that ties back to your GL balance? Modify the Purchase Receipts report to subtotal the quantity fields, then insert a calculated field to subtract the ‘Sold’ from the ‘Received’ quantities to arrive at the On Hand quantity. Although this won’t work as well if you’re using multi-bin, it makes a great inventory sub-ledger if you’re just tracking at the Site level.
This was originally posted here.
*This post is locked for comments