We have always had an issue with the pricing of our materials. Recently I went under the supplier parts list and put in the prices for each part from each supplier. When we add material from stock to the job, we select purchase direct and then fixed quantity. Once purchased direct is selected the unit cost changes to the price i entered into the Supplier Part List. However, when we run the Production Detail Report, under estimated cost the price shows up correctly. When you look at the Actual job cost the price shows up incorrectly. It shows up with the average price for the part that is completely incorrect. Is there any way to fix these prices?
In Company Configuration Modules | All Modules | General, what is the costing method selected? I think Prod Detail pulls based on that. Not positive, though.
I believe that when you choose purchase direct, that ALL the charges from the PO go directly into the job, and it ignores the standard cost of the part. There is no purchase price variance on a purchase direct. (unless something has changed). While the estimate in the Production Detail report might show the standard, the actual amount in the transaction is what is reported in the actuals.
If you want the cost to flow through inventory, why don’t you leave it as a regular receipt to inventory, and then issue to job?
When the company i work for started using epicor no one was trained on how to use it. They also didn’t have it set up correctly so our inventory is never correct. When we purchase material for a job it is directly added to the job when we create a PO. However we have certain materials we stock and we charge out from stock so we don’t have a PO to pull from. We were told to always select purchase direct even before we had a supplier price list set. No one in my company seems to know how to fix the price issue so when i discovered the supplier price list and added prices it seemed to work at first until we ran the production detail report and discovered that the cost was not being pulled over.
Sounds like a little training would go a long way. Epicor’s inventory, Job management, and Purchase management are very flexible. Purchase Direct is typically used for “Special” materials that are one-time buys, or have a special modification.
The production detail report Actual Cost for Purchase Direct items should pull the price that is on the PO at the time the PO is received.
1 Like