web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Problem with PO in wro...
Small and medium business | Business Central, N...
Suggested answer

Problem with PO in wrong currency/cannot undo posted receipts

(0) ShareShare
ReportReport
Posted on by Chris Maske 35

Hi guys!

We purchase items from multiple foreign vendors in different currencies, and some times the same vendor sells in multiple currencies. Because of this sometimes purchase orders are created in wrong currency, and we find out about this when we receive the purchase invoice. Then normally the items are received and already sold and shipped. Because purchase orders and purchase invoices is not in the same currency it is not possible to match PI lines with PO lines. Therefore I have to change the currency of the PO, and to do that I have to undo the receipt. But because the items are sold it is not possible to undo the receipt, so I cannot change currency in PO and match PI lines with PO lines.

Does anyone have any suggestions how to best fix this? Is there an effective way to undo receipts, or is there an effective way to match the lines even if there is different currencies?
Thanks!

I have the same question (0)
  • Suggested answer
    CarmenNunes Profile Picture
    CarmenNunes on at
    RE: Problem with PO in wrong currency/cannot undo posted receipts

    Hi Chris,

    Good to hear that you were able to manage using other workaround, in fact that would be also another way to overpass the issue, I didn't mentioned before once I though your case were related with real Items Stocks.

    At least now here's mentioned the two ways of overpass this kind of issue.

    Wish you a nice day.

  • Chris Maske Profile Picture
    Chris Maske 35 on at
    RE: Problem with PO in wrong currency/cannot undo posted receipts

    Hi Carmen,

    Thank you again, and please do not excuse yourself as you have been of major help.

    Unfortunality, all of these are special items without stock, so that solution did not work in my case eighter, but I think it can benefit a lot of people with similar problems later reading this.

    I have now solved the issue. What I did was to post the PO without costs, and then posted the PI against a GL account (an account for manual posting of COGS). After that I used "Item Revaluation Journals" to increase the Unit Cost of the items that was posted without unit cost similar to the amount that I manually posted on the G/L account.

    Thank you!

  • Suggested answer
    CarmenNunes Profile Picture
    CarmenNunes on at
    RE: Problem with PO in wrong currency/cannot undo posted receipts

    Hello Chris,

    Sorry for my late reply.

    You are right when posting the Purchase receipts with some Currency code system is filtering the data at Invoice document per Currency Code and we aren't able to get posted receipts unless we set same currency code as mentioned at posted receipts documents.

    I would say that your case isn't so simple, in fact the only way that I can see that you might be able to proceed and undo the posted receipts already linked to a sales flow is via Item card "Application Worksheet" and unapplied those Sales to the Posted Receipts entries in order to have those Item quantities available at Stock and then proceed  with the Undo Receipts.

    Be aware that you will need to manually apply those Sales entries to others Items entries,  which mean this only works in case you have stock.

    Once you have done this process you will be able to proceed with the PReceipts undo and PO currency changes and post the document with the current currency code.

    In case you want to link again those posted Sales to these PReceipts you just need to repeat the steps at Application Worksheet, in order to unapplied the sales  entries temporary applied to others item  entries and apply to these new entries.

    System performs always a cost adjustment whenever each time we made some manual apply or unapplied entries at Application Worksheet.

    This task will require some additional work from your side but is the only way I can see to overpass your issue.

    Hope this can help you to move forward.

  • Chris Maske Profile Picture
    Chris Maske 35 on at
    RE: Problem with PO in wrong currency/cannot undo posted receipts

    Hi Carmen,

    Thank you for your reply.

    I am not sure that I follow you. When you say " I would suggest you to create an PI with the right Currency" do you then mean the currency from the vendor invoice? If so, I have created a PI in the correct currency, but the problem is that it is not possible to use the function "Get receipt lines" in the PI because it only shows receipts from POs with the same currency as the PI. Or did you mean some other way?

    Thank you.
    Christian

  • Suggested answer
    CarmenNunes Profile Picture
    CarmenNunes on at
    RE: Problem with PO in wrong currency/cannot undo posted receipts

    Hello Chris,

    In case I had a fully understanding of your case it looks you receive the goods and ship them before you get your supplier Invoice and only at the moment you get the supplier Invoice you notice the currency initially set at PO isn't the same that is set at PI.

    If it's the case I would suggest you to create an PI with the right Currency and then get the Receipt Lines for that Invoice, in this way you will be able to post the final cost with the right currency and the system will automatically perform an adjustment between the initially cost considered at goods received and at PI posting plus the costs affected to posted Sales Invoices.

    Working in this way you will ensure your Items costs are properly updated with the right currency and you won't need to undo the posted receipts, besides the fact that for the goods you have already sold you won't be able to do it once the goods are no longer available

    Recall that when getting the Receipts Lines to an Purchase Invoice you are also able to delete part of the lines, just in case part of receipt goods are related with PI invoices that needs to be posted in different currencies.

    Hope this can help you to move forward.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,119

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,902

#3
Sumit Singh Profile Picture

Sumit Singh 3,021

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans