This is driving me crazy. We have many parts that are Vender Managed. We do not want to hold quantities in inventory, but want to be able to have them on BOMS and backflush them so we can track usage without the burdon of cycle counting or them holding value. Strictly for production purposes. I have tried unclicking QTY bearing and clicking Non-Stock. I have tried setting to just NON-QTY Bearing. Nothing is getting me what I need. I cannot imagine this is not possible in Epicor. Has anyone figured out how to do this?
Is the vendor managed inventory coming in on a PO or paid as an expense?
are you wanting the cost of those parts to hit WIP and then COGS when they are added to the job and shipped?
Hey Craig, currently the parts are coming in as an expense (not on a PO). In a perfect world, we would like to be able to add a STD cost to the so the jobs are being costed as close to exact as possible, but for now we would love to just have them backflush so we can review our usage on jobs thoughout the year, as well as transfer to other plants as repair parts.
For those parts, you can set as Non quantity bearing and you can still put a quantity on the Job. so even if you cant backflush you could build a report that shows jobs completed during a time period and sum the JobMtl quantity for the non-quantity bearing parts.
I tested something like this before for the company I am at now. these are my test notes.
Part setting:
Non-Quantity and backflush are true.
Non-Stock is FALSE
Job shows an estimated mtl cost and when backflush takes place, no inventory is transacted and actual cost is posted to the job (at a standard cost of the part). Ran the Inv / WIP Rec and everything seems to be going to the correct account.
We should set up a new part class and Ledger account (and GL control code) for the non-quantity parts to reconcile Inventory against GL.
Non-quantity bearing parts will not show on the stock status report.
Craig - Thank you for replying to me. Very helpful. This sounds like what we are trying to do exactly.
A couple questions - Did your Non-Quantity bearing parts get checked off in Job closing in Job closing?
And - Were you able to see the STK-MTL transaction in Part Transaction History Tracker? Currently our parts will not be clicked off as backflush and no transaction is made in the Part Transaction History tracker.
If you don’t get a transaction in PTHT, then you won’t get cost on the job.
We do what you are talking about - we have parts that are expense parts: non-qty-bearing with a standard cost. (I wish it could allow Last cost, but alas, it does not.)
When we backflush (in some way), cost goes to the job, a transaction appears in PTHT, but the OH qty goes from zero OH to zero OH.
Like you said, type is STK-MTL. There is no such thing as UKN-MTL (even though there is PUR-UKN). I wish there was… for other reasons.
@JasonMcD Looking at my notes from 2 years ago. Cost did move from Inv to WIP when backflushing Non quantity parts. you wont see anything in PTHT but the STD cost of the part did move to wip.
@Richh12 Welcome. Are they actually marked correctly on the job? We sometimes get a few JobMtl records that do not match. I am assuming that is why they are on the pick list.
For our vendor managed parts…they are Qty bearing and on BOM’s but not backflush, essentially on the BOM for costing purposes only. The inventory is managed by misc issue…as in stock is transferred to the factory floor based on a kanban process and once a day (sometimes every second day) a report is run of these parts in the factory. These are exported to excel and copied and paste inserted into a misc issue screen to reduce inventory.
