LinkBack URL
About LinkBacks
Actually I would like to ask for help about making the FIFO Inventory. I have almost 1000+ Items. In excel I have 2 sheets. the first is called universal index card. It serves like an index card which holds the information like date, charged to, quantity, description, account number, reference number and cost, the first sheet is where all the transactions happens, restocking of inventory and charging of items, and the second sheets is called inventory.So let me give you some example of transaction.
(CHARGING OF ITEM)
On day1 in the inventory sheet I have 10 pcs pens at $2 reference number 10 and 10 pcs pens at $3 on reference 11. in universal index card sheet, I charged 12 pens to costumer A, so all I need to type is 10 (tab) pcs (tab) pens (tab) after pressing tab other information should automatically fill the column d,e,f,g etc. but remember that in reference 10 I only have 10pcs then again charge 2pcs on reference 11 based on the inventory sheet. and the remaining in the inventory of pens should be 0 on reference 10 and 8 on reference 11. then example the costumer returned 3 of them so I just edit the charges delete the entire row that has the 2 charges then edit the above row, change 10 to 9 pcs pens. so the final inventory should be 1pc on reference 10 and 10pcs on the reference 11. this must be automatic when adding or subtracting.
(RESTOCKING OF ITEM)
On that day, in sheet1 I would input the necessary information for it is the index card. Its okay for me to add a command button or something button that will serves as if I click on it, it will have a copy to the inventory below the last "Pen". that's why it is called a FiFO inventory.
Please send me a reply if you need more explanation. I will try my best to explain clearly.
Register To Reply
Bookmarks