Skip to main content
Solved

Labour costs from BOMs

  • 6 February 2024
  • 4 replies
  • 100 views

Forum|alt.badge.img+7
  • Captain II
  • 295 replies

Hi Guys,

Hope you are all having a great day!!!

I have been using a GI to calculate our weekly labour costs.

I have encountered an issue where if a BOM Cost is calculated, from the BOM, a fair few BOM costs disappear from my GI and i have to roll the costs, we have near 60000 InventoryIDs, and this is quite a lengthy process.

My GI is attached and our VARs are unfortunately unable to see anything wrong.

Am I using the wrong table? Should I use BOMCostHistory rather than BOMCost?

Any help is greatly apreciated,

Thanks,

Aleks!

Best answer by lauraj46

Hi @aiwan,

It sounds like you are not capturing or backflushing labor on production orders? 

The AMBOMCost table should be populated when you run the cost roll.  Also, if you archive the results of the Cost Roll then you can use the AMBOMCostHistory DAC to see the cost as of a specific date.  Depending on your settings in preferences, you may need to update the pending cost before you can archive.

Archive Archives the results of the cost calculation to the Cost Roll History (AM408000) form. You can archive the results after the cost rollup process.
If the Allow Archive without Update Pending check box is selected on the BOM Preferences (AM101000) form, you can archive the cost rollup results without updating the pending costs. If the check box is cleared, you must update pending costs first by clicking Update Pending.
The system archives BOM records for the current date. If you archive the results multiple times on the same date, the system overrides the previous data for this date.

Hope this helps!

Laura

View original
Did this topic help you find an answer to your question?

4 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • February 9, 2024

Hi @aiwan,

Maybe I’m misunderstanding, but for calculating the actual BOM costs we often use the table AMMTran.  You can filter on the TranType to include just the Labor transactions.

Hope this helps!

Laura


Forum|alt.badge.img+7
  • Author
  • Captain II
  • 295 replies
  • February 9, 2024

Hi @lauraj46 

I have investigated this route but our labour transactions are blank.

Thanks

Aleks

 


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • February 9, 2024

Hi @aiwan,

It sounds like you are not capturing or backflushing labor on production orders? 

The AMBOMCost table should be populated when you run the cost roll.  Also, if you archive the results of the Cost Roll then you can use the AMBOMCostHistory DAC to see the cost as of a specific date.  Depending on your settings in preferences, you may need to update the pending cost before you can archive.

Archive Archives the results of the cost calculation to the Cost Roll History (AM408000) form. You can archive the results after the cost rollup process.
If the Allow Archive without Update Pending check box is selected on the BOM Preferences (AM101000) form, you can archive the cost rollup results without updating the pending costs. If the check box is cleared, you must update pending costs first by clicking Update Pending.
The system archives BOM records for the current date. If you archive the results multiple times on the same date, the system overrides the previous data for this date.

Hope this helps!

Laura


Forum|alt.badge.img+7
  • Author
  • Captain II
  • 295 replies
  • February 12, 2024

Thank you for you help @lauraj46, using the AMBOMCostHistory table worked!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings