It is my understanding that typically ADJ-CST and ADJ-PUR, PartTran records get created when you Variance. PPV/IPV. No problem. Usually it will use your STD Cost.
I have noticed that in my PartTran table exist Purchased Parts (Not in Inventory) and, either the process created the records or Finance Adjusted the records.
What I can’t figure out how does Epicor know to stamp these as PartTran.CostMethod = ‘A’ and Varianced based on Avg Cost; we have no “Avg” costing whatsoever in our PartCost tables and these parts are on-the-fly; like staplers, toilet paper…
Dear CostMethod = ‘A’ where are you coming from my friend?
SELECT CostMethod, * FROM Erp.PartTran WHERE CostMethod <> 'S' AND TranType LIKE 'ADJ%';