FIFO Inventory Valuation

M

Matchu

I am attempting to create a detailed Ending Inventory Report for the FIFO
method. I have a beginning inventory table, a puchases table, and a sales
table. How do i get the daily sales to be "used up" against the next layer
of purcheses. I tried a "FindNext" function as a macro, but that does not
work. Has anyone created a FIFO ending inventory report in access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIFO HELP! 1
LIFO Inventory DB 3
INVENTORY FIFO 1
Workbook code to Module Code 4
PIVOT TABLES 1
Inventory Help 3
3 queries into 1 8
HELP! with Inventory DB Template 1

Top