Re: Total Cost of a BIll of Materials
Dan, we have a situation where we have a raw material that we purchase from external supplier - CONAL1 - and a second raw material - CONHI00 - Both have current cost values entered, as well as Standard costs. Both are set up FIFO and Sales Inventory
CONAL1 is used at 14400 units per for each 1 of 13110010 - Sales Inventory, FIFO
CONHI00 is used at 14400 units per each 1 of 12112920 - Sales Invnetory, FIFO
13110010 and 12112920 are used at 1 unit per each 14111007 - Sales Inventory, FIFO
The BOM's for each FG and Assembly are set - BUILD AS NECESSARY -
Each of the component items is set to Per Unit (Cost Type)
What is interesting is that if I build 100 of 13110010 it generates a current cost based on the single input from the CONAL1 - which is mathamatically correct. This is repeated for the build of the 12112920 item.
However, when I assemble 100 of the 14111007 item, it completes the build, puts the 100 units into the inventory file for the location defined, however, it does not update the current cost of the item 14111007.
I built each of the BOM documents manually and have done so many times to see if changes to build as or stock seems to matter.
Any suggestions? I can be reached directly at billc@misltd.ca if you would like to take this off the forum.