How to change the unit cost in sales order?

(1) Share

Report

Posted on by Manuel Lozada

371

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Ben Baxter 6,835 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,052 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,507 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, just adding a Microsoft document that I thought would help understanding.

https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-costing-methods?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No