web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Report to roll up Unit costs

(0) ShareShare
ReportReport
Posted on by
Some of my Items created are showing negative margins.
I have had a look at a couple of these and I believe that this is down to when newly created items are copied from an existing item and the Unit cost & Last Direct cost values have not been updated.

In my previous employment using a different system (efacs) after I had created a product, I would run a report that rolled up current costs. This updated the cost values on the newly created product. 
 
At month end I ran this report to update all current costs and then a report to roll over all cost sets from current costs to standard costs.
  1. How can I run a report showing the cost of a new unit I have created?
  2. Is there a report I can run that will update the Unit cost / Last direct cost?
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    98,675 Super User 2026 Season 1 on at
    Hi, sorry I'm not sure what your cost method is, you can try running the following batch in a Sandbox environment.
     
    Hope this helps.
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,670 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 772 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans