Hi Hetal,
I do assume the PO would have a lumpsum and you will receive invoices based on e.g. the progress. Is my understanding correct that you may have a PO for 10000 and have the next invoices?
- 2000, 2000, 3000, 3000? (just an example)?
In that case, you can switch the quantity and the amount. Order 10000 quantity with a price $1. (or what ever currency). When receiving the first invoice you post 2000 quantity with $1, leaving 8000 open. Etcetera. In this way, you can manage also amounts with 2 decimals.
In the past, I also had created a customization for a customer where the original fields for quantity and price were replaced by edit methods. The edit methods did then decide where to put the quantity and the price in the database table. So, it looked like an order of 1 times $10000, but actually it managed 10000 as quantity and $1 as price in the background. This was based on a setting per item.
