HI there,
I need to create a report on $ material COGS for the materials contributing to the finished good parts and not the finish goods. I pulled the BAQ data from the PartTran table but it wasn’t aligning with our material COGS $ amount per the GL. Can you help me mapping the formula.
Thank you
All of the JobTracker costs tab data is in JobAsmbl. It should match the MTL-STK transactions also. I use that to create a wip dashboard that aligns with Epicor’s wip report.
Do you have the Enable Mfg Cost elements checked in company configuration?
Without this checked the “materials” of higher assemblies is all of the costs of the lower assemblies.
1 Like
Thank you, Greg, for your comment.
I couldn’t find the Mfg Cost check box, could you help me where I can get my hand on it, please?
For the fields on the jobassmbl table, are you referring to the following:
Correct me if I am wrong;
The table shows labor, material and burden cost for each assembly, considering all the parts being used in the assembly. If so, I need one lower level, the turnover of the materials itself.
Thank you
The jobs costs will be in the TL This Level and if there are any sub assemblies their costs will be in LL Lower Level. If you make and stock sub assemblies they will be in LLAMfg. I use Job Tracker to match up to what values I was needing.
1 Like
Thanks Greg, let me review and I’ll back to you on this soon.