Skip to main content
Solved

BOM Cost Roll Automation

  • February 17, 2022
  • 15 replies
  • 890 views

Forum|alt.badge.img

Two of our customers are using specific costs because of the highly variable cost of their materials. I’ve shown them how to do a cost roll but they receive materials on a daily basis and find the roll tedious.

I tried to setup an automation schedule to do the roll and update pending but the automation screen will not accept the screen id.

  1. Is it possible to to automate this?
  2. If so, what are the basic steps to do this?
  3. If not, is there a reason it shouldn’t be?
  4. Is there a setting to make BOMS pick up last costs whenever a production order is created?

I understand that the variance is important to see differences and track back what went wrong. Unfortunately the materials variance information becomes basically useless if frequent cost rolls are not done when using specific costs because, if I understand correctly, the production planned costs are based on the BOM while the actual costs are based on the last cost of the materials released.

Please feel free to disabuse me of any mistakes in my understanding of how costing works.

Thank you.

 

Best answer by angierowley75

Automation Schedules for Cost Roll are not supported as part of the standard product deliverable.  I believe this is because the screen currently performs multiple funcitons.  Please create an Idea if you would like to see this supported in the future.

I am moving this request to the customization forum in hopes someone can assist you on how to alter the system to behave as your customers desire.

15 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • February 21, 2022

When the Production Order is created, you can perform the “Update Planned Cost” menu action to pull in the latest cost values.

What is the cost valuation of the items?

What cost method are you using on the Production Orders?


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • February 21, 2022

Hi Angie!

I enjoyed meeting you and your colleagues at summit.

Our client uses specific costing because they are in food and every shipment has a different cost.

I am aware of the Update Planned Cost function but am trying to eliminate that step by automating the BOM Cost Roll in the same way I can for the Regenerate MRP function.

I tried multiple ways but I can’t even assign an automation to that screen.

Thanks!


angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • Answer
  • February 22, 2022

Automation Schedules for Cost Roll are not supported as part of the standard product deliverable.  I believe this is because the screen currently performs multiple funcitons.  Please create an Idea if you would like to see this supported in the future.

I am moving this request to the customization forum in hopes someone can assist you on how to alter the system to behave as your customers desire.


jdobish
Pro III
Forum|alt.badge.img+2
  • Pro III
  • August 31, 2022

I was just looking for a way to automate this as well, as people using average costing with variable material products are regularly doing cost rolls… 


martingaxiola
Varsity I
Forum|alt.badge.img

Is there an ide for this outthere? I will like it so hard. 


angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • August 31, 2022

It does not look like any one has create a Community Idea for this enhancement as of yet.


martingaxiola
Varsity I
Forum|alt.badge.img

 

Idea has been created.


Forum|alt.badge.img
  • Semi-Pro II
  • August 9, 2023

A long-winded but workable solution is to prepare an Import Scenario for the Cost Roll screen with your preferred parameters. Then, you schedule an Automation Schedule for Process Import Scenarios with condition Name = (import scenario name).


Forum|alt.badge.img
  • Jr Varsity II
  • July 19, 2024

@kokjietan Can you please provide an example your import scenario? Thank you.


Forum|alt.badge.img
  • Jr Varsity II
  • July 19, 2024

I was able to make it work. Here is a screenshot of the import scenario…

 


Forum|alt.badge.img
  • Freshman II
  • October 31, 2024

Hi, We are trying to create an import scenario as suggested, however Cost Roll screen is not shown under screens to add. Any idea?

 


Forum|alt.badge.img
  • Jr Varsity II
  • October 31, 2024

@uma47 I show the Cost Roll Screen as selectable.

Screen AM.50.80.00


Forum|alt.badge.img
  • Freshman II
  • October 31, 2024

@bthomas24 which version is it? I am using 23R2


Forum|alt.badge.img
  • Jr Varsity II
  • October 31, 2024

@uma47 

I am using 24r2.


Forum|alt.badge.img+1
  • Jr Varsity II
  • January 31, 2025

I was able to create a Business Event Triggered by Schedule that uses an Import Scenario to perform the Cost Roll in this case Weekly. Most of the Source Field / Values are just True/False.