Skip to main content

Notifications

Announcements

Just out! June 2024 Dynamics 365 Community Newsletter
Community forum and blog attachments are now available!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / How to change the unit...
Business Central forum
Suggested answer

How to change the unit cost in sales order?

(1) ShareShare
ReportReport
Posted on by Manuel Lozada 344
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:
Project management
Development
Data Migrations
Documentation
Administration and permissions
Sales
Other
Inventory and warehouse management
Purchasing
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,013 Super User 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 6,365 Super User 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,198 Super User 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

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter
Community forum and blog attachments are now available!

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans