We are a make to order company, meaning the parts that are shipped to the customer have the “Non-Stock” & “Quantity Bearing” checkboxes set as TRUE. The parts are also setup as AVG costing method. We are backflushing parts from primary bins set on the resource groups (I know, it’s not preferred). Our issue is that AVG & LAST costing are not populating. We have found that by over producing on jobs and having the excess parts go to stock this actually populates the AVG and LAST costing. Any ideas how we can still be a Make to order company and populate AVG & LAST costing? Any advice helps!
So when you ship a job from WIP and invoice, the average cost doesn’t populate?
Brad
Correct. Any indication as to why this is occurring? Or is it actually functioning correctly?
My perception of base functionality has always been that unless you receive parts into stock it should NOT populate those. It makes those calculations from parttran i believe. If you are shipping from WIP all your costs are contained on the job and transferred to the invoice. You can easily make a simple dashboard for tracking average costs on ship from WIP items. Additionally you can manually populate those if it provides some value for you.
i wanted to add, that if you manually populated those values, the system will not DO anything with them, they would be for your reference only.
1 Like
The Average and Last costs are only populated when there is an inventory transaction.
Shipping from a job (as Make To Order does) will not hit inventory, so it never updates the cost fields. Instead the cost moves directly from the JOB to COGS and skips inventory.
No it doesn’t. The system uses the actual costs on the job.