Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Moving Average and using cost rollups

Posted on by Microsoft Employee

Hello everyone,

My client is switching from standard cost to moving average for most of their items. They use SSRS reports for miscellaneous reporting, but one in particular may have an issue. That particular report shows the cost rollups on items (Labor, overhead costs, etc..), and that information is retrieved from table InventItemCostGroupRollup.

If the client updates the costs, the only way to update table InventItemCostGroupRollup (that I'm aware of) is to create a new price (fform InventItemPrice), run the calculation, and then activate that price.After I run the calculation, and check the "Cost rollup by cost group" of the item after switching to moving average, there is only 1 cost group and it seems to be a summation of the other cost groups. I'm not sure why it doesn't get the sub level cost groups, but since it doesnt, the values end up blank in the SSRS report since there are no entries in table InventItemCostGroupRollup

The images show the different between before and after switching to moving average. This is the same item and costing version (which is standard) used in both images.

Cost rollup before moving average:

pastedimage1590092126444v1.png

Cost rollup after switching to moving average:

pastedimage1590092133819v2.png

The other part I find interesting though is if I check the complete specs (Complete button in action pane), I see the cost rollups there. So it seems like the information is there, but the system is process it differently because of the item being moving average. I'm not sure why this is the case or if I need or missed some configuration. I don't know the cost rollup process very well, so I may be way off base.

Anyways, here are my questions:

1) Is it possible to show or get the sub level cost rollups with an item that is moving average?

2) Is there a way to update the cost rollups with out having to use the item price form/BOM Calculation and still update table InventItemCostGroupRollup? If so, how? This would probably be the more ideal solution if possible.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Thanks for the quick reply.

    This form looks like it may be what I need. The information seems to be what I'm searching for. I'm going to run a couple of tests to play around with it and take a deeper look on the back end to get a better understanding of the form.

    Hopefully this is what my client is looking for.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Hi, 

    In the overview costing tab you can compare planned and actual costs. 

    That's the same as in the costing sheet tab but there is no specific summary. 

    2705.costing.png

    The data and information should, however be the same.

    Best regards, 

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Sorry for the long delay Ludwig my apologies. There were some other tasks ended up taking priority over this one, but I did get a bit further on this.

    What I ended up finding out that there was indeed something on the backend that causing the difference between a standard vs moving average item. In method updateInventItemPriceSim on line 68, of class BOMCalcUpdateItem, the code checks if item's model type is standard cost. Which in turn can cause the cost rollup to be calculated differently. The image below is the method I found.

    baseCodeIssue.png

    I did end up adding logic to the above that would also check if the item's model type was moving average. After doing that, the cost rollups were calculated just like the stand cost items. You could also see the values reflected in the SSRS report. However, I'm not the biggest fan of doing this change (possible down stream affects), but it seems to work with what was needed. My client does not want to go through with this change however. 

    What I ended up taking from my last discussion with the client is the following. Is is possible to perform a BOM cost estimate (still showing cost rollups) on a moving average item without having to use the BOM calculation process. The reason they want this is because if the BOM calculation is performed, you are still maintaining a standard cost and they don't want to do that.

    My question at this point is then is it possible to perform a BOM cost estimate on a moving average item that doesn't involve using the BOM calculation form?  On top of that, the client wants to specifically use base AX functions/processes/code. I've tried looking into this, but I'm not really finding much information. More often than not, what I am finding seems to lead back to the BOM calculation. I'm not sure if there is another process in AX that I could use that can perform a BOM cost estimate.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Hello CandyIune,

    Just thought about another thing.

    Can you check the field 'cost group' in the released product form?

    I wonder whether some changes have been made here and if those groups are still correctly assigned.

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Good morning CandyIune,

    If you open the 'costing overview' tab instead of the costing sheet tab/rollup, do you see a breakdown of the different elements included in this production order?

    The cost roll up basically just summarizes the different elements that you see in the costing overview tab.

    Can you share a screenprint what you see there?

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Well I reran the process but I'm still getting the same results on the cost rollups. However, now the overhead and labor costs are going through so I was missing a checkbox on that side of things.

    I'll have to step through the debugger on this calculation process because it seems to me that all the information is there, but for some reason the system doesn't show the sub level items for the cost rollups for an item that is moving average. I just don't know why that would be the case though.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Hi Ludwig,

    I'll try to answer your questions the best I can.

    So the two images on my first post are actually the same product/itemid. The first image is what the cost rollup looked like when it was still using standard cost for it's model group. The second image is when the item was moved to moving average and the price was recalculated and activated (using the same price that it was using when it was standard cost).

    Since this is the same item, there's really nothing to compare on the BOM lines. The only thing that changed between those images was only the item's model group. The cost version was also the same between each run, and the cost version type being used is Standard cost. This may also be part of the issue, but I went through the process with my client and it looks like I may have missed a checkbox or two during my testing. So I'm going to go through this process again making sure I use the correct options and I'll report back my findings.

    As for the switch to moving average, I don't know the specifics of why my client chose go that route vs standard cost since I was brought in pretty late into the project, but it seems like they move quite a bit of inventory each day, as well as the pricing seems to also change on a daily bases.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Moving Average and using cost rollups

    Hi,

    I assume that you setup a new product for your cost rollup comparison.

    Can you please compare how the different BOMs/BOM lines are setup for those two products?

    Is there any difference that you can identify?

    Just wondering, why is it that you switch to moving average?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans