Hi all, first time starting a thread, sorry if this has been asked before, I searched but can’t seem to find the right keyword or this hasn’t been asked yet.
As the title said, is there anyway for me to look at the current balance of items that used FIFO costing method, but grouped by cost / rate.
For example if I made a purchase in this sequence
- 100 pcs Item A @ $10.00
- 100 pcs Item A @ $10.50
and then I sold 50 Pcs of Item A
I would like to see the following report:
- 50 pcs Item A @ $10.00
- 100 pcs Item A @ $10.50
If the report doesn’t exist, is it possible that I can customized a report myself? I’m not asking for step-by-step solutions, just wondering if this customization is feasible…
Thank you!