Looking through the WIP/Recon report shows a Variance account getting Credited and debited (same amount) for every PLT-STK (Transfer Order Receipt).
I queried the TranGLC table, and confirmed these are tied to the PLT-STK transaction.
Based on the TranNum in the Journal Tracker, I see that the PartTran:
Why are these net-zero variances being created?
Under your Plant, there are Plant Transfer Definitions. Those are tied to the Plant Transfer GL Controls.
Our general GL accounts for this look like this. We do have some special accounts depending from what plant to STK-PLT and PLT-STK.
We have a similar setup.
I guess my question is why the Variance is getting hit at all?
I thought the ‘Transfer Variance (To Plant)’ was for when a difference exists between the cost at the specific plant, and the value of the TO item (cost when it left the source plant).
But we only use one cost file, across all plants. And in these instances, the cost is unchanged from the time it shipped from Plant A, to the time it was received at plant B.
Understand that the INTENT of Epicor and Plant-to-Plant part transfer is the expectation that the costing per plant would quite likely be different, and/or one plant will/may profit off the receiving plant. Quite rare when it’s not the case.
If you only manufacture specific parts in Plant A (and they never will be made in Plant B) and the reverse is true… particular parts mfg-ed in plant B and never in Plant A… perhaps you are OK! Additionally, if your prime location transfers “at-cost” for both MFG-ed and purchased parts… again, you may be ok.
ONE Plant-cost-ID… gives me the willies! (as the expectation is that part cost in each plant will always be the same). What happens when the cost is different in each plant with only one cost-tanle!?
The cost-table is updated at receipt on a PO, or Receipt from Job, adjustments, and transfers (which is basically a receipt).
I presume, in your case… the entries that offset each other are the result of only one-cost-table.
Do you manufacture the same part in each plant? Is the MOM the same? Even if that is the case, the execution of the JOB (per plant) can not be the same.
If you LOT track, you may be ok!
Purchased parts? same parts procured in each plant? Procure costs exactly the same?
Since each plant is using the same cost table, receipt transactions will update costs.
You buy/receive or make a widget in plant A… it cost 200
You then buy/receive or make a widget in Plant B…it cost 300
You then issue a WIDGET to a JOB! What is the cost of the issued WIDGET!?!?
To relieve you of your willies …
We only manufacture at one plant (Plant ‘A’). The others are warehouses that stock purchased items and some stuff made at Plant A.
Some orders are picked up by a contractor, who will do the installation. When those orders include manufactured parts, we build them at Plant A, the ship to Plant B - where the contractor will pick it up, along with other purchased items.
What really sucks is that these are often one off parts, but we have to make a part number and stock it, in order to do a Transfer Order to get it from Plant A to Plant B.
