Skip to main content

Notifications

Announcements

No record found.

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

Total cost field on custom report not populating when prod. order generated from planning worksheet

(1) ShareShare
ReportReport
Posted on by 4
Good morning, 
 
We are experiencing an issue which I am liaising with a consultant on but wanted to reach out and sense check if anyone has experienced something similar when using the planning worksheet. 
 
Little bit of background on the setup: We use some of the work centres where there is a fixed cost and we keep the ‘Specific Unit Cost’ field unchecked (this is for inhouse production work) but where we do have a specific cost, this field is checked, and it pulls the costing from the routing. We can't have individual homework work centers as this can change based on the product, not the homeworker. 
 
We have a custom production order report which has a 'Total cost' field, this is populated by the cost either on the work center or the routing based on what product is being produced. 
 
We have found that when manually creating a firm planned production order and refreshing to pull lines, components and routings through - the total cost field on the report is being populated. 
However, when we generate firm planned production orders through the planning worksheet, the order is generated and lines/components are pulled through but the total cost field is not populated. 
We find this odd as this is standard functionality and not entirely sure why one method would populate the cost and the other wouldn't. 
 
We have been advised that: It appears that it is standard functionality that when creating a Production Order from the PW it does not refresh the "Expected Operation Cost Amt." field on the Routings line. When you read the comments for the field description it says: "Specifies the total cost of operations. It is automatically calculated from the capacity need, when a production order is refreshed or replanned."
Which I take it to mean that this *only* refreshes when a Refresh or Replan is run. Which the planning worksheet doesn't appear to do automatically.
 
I would just like to check if anyone has had similar issues when generating production orders via planning worksheet and if it is correct that the planning worksheet doesn't pull costs automatically. 
 
Thank you in advance!
Sarah
 
  • Tech_BC_Gokul Profile Picture
    Tech_BC_Gokul 331 on at
    Total cost field on custom report not populating when prod. order generated from planning worksheet
    Hi 
     
    Firm planned is something for a planning level order to meet our demand it’s created ideal scenario would be all the released production order will have the actual cost values in the report as well as the table information 
     
    so I recommend you to convert this as a release production order and check the values are okay 
     
    thanks 
    gokul

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans