Sales Update & Exchange rate

[jdecoder]

We have client which is 100% Export oriented now the client wants to create single invoice number (to save custom Duty) for the whole shipment for a customer which comprises of different sales orders now these sales orders are placed on different dates hence the exchange rate on the header are different so the standard JDE invoice generation report generates multiple invoices because of the different exchange rate. We recommended keeping it 1 and fetch from exchange rate table for reporting requirements. Everything was fine.

Till one fine day the finance guy wanted to do Sales Update

now Sales Update is referring to the SO Header for exchange rate which is 1 now. But it must refer to the exchange rate corresponding to the invoice date

Any Ideas are appreciated… Thanks in Advance…

 

[HW_EpicConsulting]

Have you checked to see if the functionality in Cycle Billing might address the whole problem? That functionality is specifically designed to batch multiple sales orders into a single invoice. Good Luck!

 

[JdeInNJ]

Have you explored the functionality of processing options 1 (Update Cost) and 2 (Version) on the Cost/Price Update Tab of the Print Invoices program (R42565)? This runs the Sales Order Batch Price/Cost Update program (R42950). A value of 1 in processing option 2 (Exchange Rate) on the Process tab causes domestic prices and foreign costs to be recalculated with the current exchange rate.

I have never used this functionality, so you need to test it carefully. Please let me know if this meets your client's needs.

Brad