pcsoft.us.windevCopyright 2026, PC SOFT30 Oct 2015 06:10:00 Z28 Oct 2015 06:42:00 ZHello, This is not a WX problem. I don't know as to how to explain this. I hope you all will be able to understand what I am trying to say.... I am developing a small inventory solution for a canteen. Here there is a need to implement FIFO based inventory management and costing (calculated on per menu item based on amount of raw material used in preparing). I am not able to understand as to how I should do this. Can someone with experience on inventory management help me here please. Here is what I want to achieve for raw material: 01/10 OB 68 units @ $15.00 per unit 05/10 Purchase 140 units @ $15.50 per unit 09/10 Issue 94 units 11/10 Purchase 40 units @ $16.00 per unit 16/10 Purchase 78 units @ $16.50 per unit 20/10 Issue 116 units 29/10 Issue 62 units Here I have to calculate the cost of an item based on which prices raw materials are used in preparing a plate. TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54730/read.awp30 Oct 2015 06:10:00 ZThanks everyone for your suggestion. I will sit on all ideas suggested here and hope to work out something soon. TIA Yo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54730/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54730/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54726/read.awp29 Oct 2015 18:22:00 ZYes, people make mistakes (all the time). My solution is to have a live inventory file that tracks transactions as they occur…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54726/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54726/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54706/read.awp29 Oct 2015 07:01:00 ZHello Yogi The only way it can work is to use transaction records so that adjustments are by made posting a plus or minus tra…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54706/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54706/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54704/read.awp29 Oct 2015 06:41:00 ZMark & Aelfassi, Thanks for your inputs. I will try out what you have suggested. But from my first look I feel if I follow th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54704/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54704/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54700/read.awp28 Oct 2015 23:29:00 ZHi Yogi, I will add just one point to Mark's explanation. You need to use Lots (Lot1, Lot2, etc...) for every new purchase …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54700/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54700/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54684/read.awp28 Oct 2015 10:44:00 ZHi Yogi To get your cost based on Fifo, you need to allocate your stock issues against an purchase. ie Purchase ID 1 = …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54684/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54684/read.awp[WX17] - Help for Calculation of Inventory using FIFOguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54681/read.awp28 Oct 2015 09:40:00 ZHi, maybe this helps you: moving averagehttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54681/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54677-wx17-help-for-calculation-inventory-using-fifo-54681/read.awp[WX17] - Help for Calculation of Inventory using FIFO