Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Sales Order Unit cost Exchange Rate issues

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dear All,

I had  a few drop shipment sales order where it is created in end of November and it is to be posted in December.

In December when we do a check on these sales order before to ship and invoice we discover issues on unit cost.

For same customer with 2 different order in End of November, and purchase the same item quote but in different quantity,

We had discover that sales order 1 unit cost was updated with December exchange rate, while sales order 2 (with same product) was still stuck at November exchange rate.

1. How do we rectify this, so that the exchange rate is correct for SO2? we had tried to delete the SO & PO item line and relink the PO, but the exchange rate was still November exchange rate

2. If we ignore the unit cost shown on SO2, when we post the SO2 will it shown December exchange rate?

3. We can't delete the SO as we had given the SO number to client

4. temporarily measure is, on the SO, we go to the currency field, click the 3 dot to bring up the edit exchange rate function. but this is very inconvenience as we need to check and verify every SO create in the month end if it was to be posted in next month. 

 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Sales Order Unit cost Exchange Rate issues

    Be aware that depending on your costing method, the unit cost you see on your sales order might be a temporary one and that can change as your sales order and purchase orders are posted.  So what you see on a sales order might often be the calculated cost and when everything is posted the system will adjust that into actual cost.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Unit cost Exchange Rate issues

    Yes, in the drop shipment scenario, the purchase order is supplying the goods for the sales order.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Sales Order Unit cost Exchange Rate issues

    Are the purchase invoices posted for the PO's that will supply your sales orders?

    If not you should make sure that your PO's have the same posting date.

    When you change posting date on a document the system will give you the chance to update your currency exchange rates.

    Inge

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,356 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans