Phantom Purge WIP to Variance

Phantom MFG-VAR transactions are temporary records which are created for Completed Jobs which have remaining costs in WIP and no outstanding uncosted shipment records.

These temporary transactions are automatically generated as the Inventory/WIP Reconciliation Report captures simulated COS and WIP information.  The records do not exist as MFG-VAR PartTran records in your database.

 

When a job is closed, any remaining costs are purged from WIP during the WIP/COS calculation process.  These costs are posted to the Cost of Sales and Variance accounts in the ratio of the quantity that was shipped or sent to inventory to the quantity relieved.

 

PURGE TO COST OF SALES ACCOUNT =

  Remaining Wip Costs * [ Shipped Qty todate / (shipped qty + inventory qty) ]

 

PURGE TO VARIANCE ACCOUNT =

  Remaining Wip Costs - (Purged to COS amounts)

 

Note:  MFG-VAR records are only created if there are no uncosted shipment transactions, meaning if there are additional costs that have not been transferred to COS via a shipment.  For shipments that are directly from the job, any costs that are added up until the first capture is run after the shipment will automatically go to COS because the shipment 'floats' until the capture is run.

 

 
Dora Chavarria  
Sr. Consultant Analysis Services,
ERP  
Mayan Technologies USA, Inc. dchavarria@...
www.mayantechs.com 



On Thursday, May 14, 2015 3:17 PM, "Mike Lowe MLowe@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-2059439791yiv4702873714ygrp-text">
  
  
  <div>
It’s what your month end manufacturing variance WILL be when you run the Capture COS/WIP and post at month end.
 
Mike
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 14, 2015 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Phantom Purge WIP to Variance
 
 
Let me start by saying we are Epicor newbies - been live on v10 for  weeks.
 
When viewing my Inventory/WIP Recon report, I see the entry Phantom Purge WIP to Variance and don't know what this is telling me.  The part I see it for is an inventory part that I've received to inventory from a job and have closed the job.  Our costing method is last cost.  Anyone seen this before?
 
Cheers,
Charlie
</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714 -- #ygrps-yiv-2059439791yiv4702873714ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp #ygrps-yiv-2059439791yiv4702873714hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp #ygrps-yiv-2059439791yiv4702873714ads {
margin-bottom:10px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp .ygrps-yiv-2059439791yiv4702873714ad {
padding:0 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp .ygrps-yiv-2059439791yiv4702873714ad p {
margin:0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mkp .ygrps-yiv-2059439791yiv4702873714ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ygrp-lc {
font-family:Arial;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ygrp-lc #ygrps-yiv-2059439791yiv4702873714hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ygrp-lc .ygrps-yiv-2059439791yiv4702873714ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity span {
font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity span span {
color:#ff7900;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714activity span .ygrps-yiv-2059439791yiv4702873714underline {
text-decoration:underline;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714attach div a {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714attach img {
border:none;padding-right:5px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714attach label a {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714bold a {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 dd.ygrps-yiv-2059439791yiv4702873714last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 dd.ygrps-yiv-2059439791yiv4702873714last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 dd.ygrps-yiv-2059439791yiv4702873714last p span.ygrps-yiv-2059439791yiv4702873714yshortcuts {
margin-right:0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714attach-table div div a {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714attach-table {
width:400px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714file-title a, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714file-title a:active, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714file-title a:hover, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714file-title a:visited {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714photo-title a, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714photo-title a:active, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714photo-title a:hover, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div.ygrps-yiv-2059439791yiv4702873714photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 div#ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg #ygrps-yiv-2059439791yiv4702873714ygrp-msg p a span.ygrps-yiv-2059439791yiv4702873714yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714green {
color:#628c2a;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 o {
font-size:0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714photos div {
float:left;width:72px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714reco-category {
font-size:77%;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714reco-desc {
font-size:77%;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 .ygrps-yiv-2059439791yiv4702873714replbq {
margin:4px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg select, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 input, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg pre, #ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 code {
font:115% monospace;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-mlmsg #ygrps-yiv-2059439791yiv4702873714logo {
padding-bottom:10px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-msg p#ygrps-yiv-2059439791yiv4702873714attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-reco #ygrps-yiv-2059439791yiv4702873714reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-sponsor #ygrps-yiv-2059439791yiv4702873714ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-text {
font-family:Georgia;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-text tt {
font-size:120%;}

#ygrps-yiv-2059439791 #ygrps-yiv-2059439791yiv4702873714 #ygrps-yiv-2059439791yiv4702873714ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-2059439791



in Epicor 9.05 we ran the Inventory WIP Account Reconciliation report, and saw a whole bunch of records that have the reference of Phantom Purge WIP to Variance..

What is that? and how did it happen?

Let me start by saying we are Epicor newbies - been live on v10 for  weeks.


When viewing my Inventory/WIP Recon report, I see the entry Phantom Purge WIP to Variance and don't know what this is telling me.  The part I see it for is an inventory part that I've received to inventory from a job and have closed the job.  Our costing method is last cost.  Anyone seen this before?


Cheers,

Charlie

It’s what your month end manufacturing variance WILL be when you run the Capture COS/WIP and post at month end.

 

Mike

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 14, 2015 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Phantom Purge WIP to Variance

 

 

Let me start by saying we are Epicor newbies - been live on v10 for  weeks.

 

When viewing my Inventory/WIP Recon report, I see the entry Phantom Purge WIP to Variance and don't know what this is telling me.  The part I see it for is an inventory part that I've received to inventory from a job and have closed the job.  Our costing method is last cost.  Anyone seen this before?

 

Cheers,

Charlie