Posted Purchase Order with wrong exchange rate - pls help!

ykcheong
ykcheong Member Posts: 32
edited 2008-04-08 in NAV/Navision Classic Client
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ykcheong
    ykcheong Member Posts: 32
    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
    AdamRoue Member Posts: 1,283
    You will need to use a revaluation journal to correct the LCY cost, presuming the vendor liability is correct.
    The art of teaching is clarity and the art of learning is to listen
  • ykcheong
    ykcheong Member Posts: 32
    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

Categories