Hi,
We have created sales agreement for a customer 'A' and set price per unit say USD1000 ea. effective from 01-03-2019.
Sales Order is created on 01-03-2019 for the customer 'A' for 10 unit, the system fetch the sale price of 1000.
On 05-03-2019, the trade agreement is revised, the previous trade agreement is set active to 04-03-2019 and new rate of USD 1500 entered with effect from 05-03-2019.
Actual shipment is made on 05-03-2019.
We want that system should generate sales invoice using new rate of USD 1500. But system is generated invoice @ USD 1000.
Please suggest how system can update sales rate while generating sales invoices.