FIFO & LIFO inventory system

[Hareshvalani]

hello everyone

this is my 1st post here
i want to create inventory which i want to use fifo & lifo system,
i have 6 table likes open stock, purchase, sales, purchase return, sales return, dead stock, now i want to implement fifo & lifo method inventory with valuation of closing stock or current stock



experts please guide me how to implement this

[ArviLaanemets]

You have to register all goods movements in stock log, along with movement time, type, and amount. This log table will allow to calculate anything you need to know at any given time moment, or over any given time period.

NB! The stock log is for registering of goods movements only. All ordering, invoicing, paying etc. info is usually kept in their own tables!

[orange]

Search FIFO LIFO in the forum. See Similar Threads at bottom of the page.
Is this a new, development project or an enhancement to an existing application.
A description of the business and some sample data will help you get focused advice.
Good luck.

[Hareshvalani]

thank you for your good idea i do the same

i found one excel file which have fifo system and i used that code for my project
most of my needs will end after i full use that code & implement as per my needs

once again thanks for replay

[xkhid17]

Hi would you mind sharing the code or the solution here? I have the same problem I am looking on how to create a FIFO system inside the MS Access

[orange]

xkhid,

Better to start your own thread than attach your question to thread marked SOLVED.

See this thread, there are example MS Access databases showing FIFO.