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.
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.