Small and medium business | Business Central, N...

Update standard cost prices based on purchase price list

(1) Share

Report

Posted on by Morten_DK

Normally I update standard cost prices in BC by using Standard Cost Worksheet and then exporting the items to Excel. In Excel I merge the Worksheet with values from the Purchae Price List on each item. This just seems like a cumbersome way to do it. Can BC not itself somehow pick up the prices from the Purchase Price List and if in another currency then use the currency table to convert to local currency?

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

Update standard cost prices based on purchase price list

Like Valentin thought, this needs to be custom if you don't want to handle it outside the system.
Please contact your partner to discuss specific requirements.

Thanks

ZHU
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Update standard cost prices based on purchase price list

for your reference on standard cost. Since the stand cost includes several components including material cost, capacity cost, possibly subcontractor cost, user needs to manually calculate and decide on the standard cost.

https://learn.microsoft.com/en-ca/dynamics365/business-central/finance-about-calculating-standard-cost
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (1)

Report

Update standard cost prices based on purchase price list

I don’t believe this functionality is available out of the box. This is likely because the standard cost is usually a more comprehensive calculation than comparing it to the purchase cost. However, a developer could customize a report, such as the 'Adjust Item Costs/Prices,' to adjust the standard cost based on the cost in the purchase price list.

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