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

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
    1,025 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
    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
    1,025 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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 691

#2
YUN ZHU Profile Picture

YUN ZHU 646 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 495

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans