Posted Purchase Order with wrong exchange rate - pls help!

ykcheong

Hello,

I am using Navision version 3.70 (financial, inventory and manufacturing).

I have posted some PO this month with wrong exchange rate. Now the total purchase amount in LCY is not correct.

How to adjust the above transactions?

Thank you very much.

Best regards,
YK Cheong

ara3n

Have you invoiced the PO or just received it? If you have invoiced it, then all you can do is update AP periodic activity to update the exchange rate and hit you gain or loss GL acctount.

If you havent invoiced it, then reopen the po and validate (F2) currency code field.

ykcheong

Thank you for yuor reply.

All the PO have been invoiced. Some of the items have been sold or used in the Production.

How to adjust the inventory (using Average Costing Method) and production?

Please advice.

Thank you very much.

Best regards,
YK Cheong

AdamRoue

You will need to use a revaluation journal to correct the LCY cost, presuming the vendor liability is correct.

ykcheong

The PO was invoiced with wrong currency rate. When you check the vendor ledger entry, the amount LCY wrong. I cannot use the "Adjust Exchange Rate" in the General Ledger -> Periodic Activities because within the same posting date and same currency code, the posted purchase invoices have different currency exchange rate.

For example: Posting Date = 04/03/08; Currency Code = USD; exchange rate = 3.189 or 3.182 or 3.823.


Thank you.

Best regards,
Cheong