Skip to main content

Notifications

Business Central forum
Suggested answer

Report to roll up Unit costs

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?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,029 Super User 2024 Season 2 on at
    Report to roll up Unit costs
    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

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,954 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans