Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to change the unit...
Small and medium business | Business Central, N...
Answered

How to change the unit cost in sales order?

(1) ShareShare
ReportReport
Posted on by Manuel Lozada 465
Hi Community,
 
I have a requirement from a user.
 
The problem is in my item card the unit cost varies according to the purchase and average cost.
 
For example, this is my costing & posting item, usually the unit cost is $3000, but, I had a discount and bought 2 for $0, now changed for $1000.
 
 
This is my current average cost
 
If I want to buy more, my purchase order brings the unit cost to $3000, and that is ok
 
My inquiry is how can I bring in a sales order my unit cost $3000 and not the average cost $1000.
 
If Do you know how? I would appreciate it.
 
Thanks
 
 
 
 
 
Categories:
Business Central
Business Central
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    How to change the unit cost in sales order?
    Hi, just adding a Microsoft document that I thought would help understanding.
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,793 Super User 2024 Season 2 on at
    How to change the unit cost in sales order?
    Ben is correct - essentially you don't have to do anything, as the system will take care of it for you. Your sales line will display the unit cost from the item card which is the average cost. But the adjust cost item entries routine the system runs will re-adjust this to the accurate costing based on your costing method which is FIFO. 
     
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    How to change the unit cost in sales order?
    Since you are using FIFO, when the Adjust Cost process runs it will apply the oldest cost to your sale.  So even though it shows $1000 on the line, the adjust cost process will change that to $3000 using value entries (either at the time of posting or whenever you have your Adjust Cost process set to run).
     
    Run some test transactions in your Sandbox and ensure your Adjust Cost process is run after to see the results.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

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 us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans