Please note that my client has requested for down payment to be configured in their current system.
Suppose the customer makes 5 advance payments against a sales order eg. 50000 x 5=250000 is the total advance made against a particular sales order.
Now they want that if the Basic Price+Excise=600000 then the following should be shown during billing
Less 2% against advance for Basic Price+Freight=2% x 2500000=50000
Less 5% against advance for Freight and Packing=5% x 2500000=125000
And the total payable should be 600000-125000=475000
How to display the same in the invoice.
I have created a dummy scenario for testing and have created, posted and cleared an advance of 100000 but the same is not showing in invoice i.e. if total invoice value is 200000 the pricing should show
I have assigned calculation type 48 against condition type 48 but no result
Can someone please help.
I am attaching the format required by the client.