The Analyse Inventory [Summary] report shows the following columns:
- On Hand
- Committed
- On Order
- Available (Available = On Hand - Committed + On Order)
Can we CUSTOMIZE a report with the columns and FORMULAS as follows?
- On Hand (1)
- Committed (2)
- Available (3); --- [with the formula: (3) = (1) - (2)]
- On Order (4)
- Available After Order (5); --- [with the formula: (5) = (3) + (4)]
Please see the attachments for more clearly.
Anyone can help me about this?
(My boss asks me to check if some Inventory functions of MYOB can meet our company requirements before deciding using officially this software)
I am looking forward to your soonest support.
Thank you very much.
Kenny