Skip to main content

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!

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

Hi @lauraj46 

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

Thanks

Aleks

 

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

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

Reply


Terms & ConditionsCookie settings