Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Chris Harrison]

Hello AX Experts,

Something happened, or was changed, the weekend of April 11-12 that has caused our Rates to have disappeared from our BOM Calculation.  Please see attachment for an example of what our Cost overview looked before the weekend of April 11-12 and now.  Any thoughts on what would have caused the Rates to disappear?  We are on AX 2012 R2 and are running a Planned Cost.

Thoughts?

Thanks!

——————————
Chris Harrison
IT Integration Manager
Fort Wayne Metals
Fort Wayne IN
——————————

[Ian Gorman]

Chris,

Attached is a great document that reviews all of the R2 costing issues and their respective KBs.

Could you go to the AOT > Data dictionary > Tables > RouteCostCategoryPrice & CostSheetCalculationFactor table and attach the data in that table to this post?

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

[Chris Harrison]

Hi Ian,

Thank you for the quick response.  I’ll review the attached document but it would be strange to me that over a weekend something would just break.  We’ve been on AX 2012 R2 for almost 5 years now, and it has been working fine and just now stopped…  I’m really thinking someone changed a setting somewhere over the weekend, I just don’t know what they changed.

In regards to providing data, I would need to get permission to post data to a public forum as we have some strict legal regulations about the type of data we can provide.  For now, could you tell me what you would be looking for in the RouteCostCategoryPrice and CostSheetCalculationFactor tables where I might be able to have a look?

Thanks,

Chris

——————————
Chris Harrison
IT Integration Manager
Fort Wayne Metals
Fort Wayne IN
——————————
——————————————-

[Ian Gorman]

Chris,

No worries on providing the table data.

For RouteCostCategoryPrice, I am aiming to see if you catch any cost categories that should be in use with a CostVersionStatus of ‘Previous active’.

For CostSheetCalculationFactor, I am looking to confirm if you are seeing your cost sheet nodes with proper rates populated throughout the table.

If you look at BomCalcTrans and sort by your missing rates or by your item number, do you see the rates appearing in this table? You may need to sort by calculation number instead, screenshots below on how to identify this value on your active cost:

The before/after screenshots – are these showing the same cost breakdown on the active price for the item? If they are, can you do another cost calculation for the item in your screenshots and confirm that the rates still aren’t pulling through via the pending price?

If all checks out on the above recommendation, give this document a review and see if you identify any areas where something may have been altered in your environment:

https://www.microsoft.com/en-us/download/details.aspx?id=30128

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

[Chris Harrison]

Hi Ian,

Appreciate all your help.  As mentioned in my first post, the BOM calculation is working fine in our Sandbox AX 2012 Environment (TR) but not working fine in our PROD AX 2012 Environment.  I compared the RouteCostCategoryPrice and CostSheetCalculationFactor between TR and PROD and they are exactly the same.  So I’m going to assume these are setup fine.  In regards to the BOMCalcTrans, I have attached an extract of the file from our TR and PROD environments so you can see the difference in the two.

Thank you for the document.  I’ll review and see if I can find any setup that is changed/missing in our PROD environment.

Thanks,

Chris

——————————
Chris Harrison
IT Integration Manager
Fort Wayne Metals
Fort Wayne IN
——————————
——————————————-