WIP Calculation

Thank you both - that helps.
Can anyone give me a vague description of how WIP is calculated in Epicor?    I am in need of a WIP report to be processed overnight and emailed out to users along with in-stock inventory dollars.  The WIP report Epicor provides is good however it is not in the format anyone wants.    I have been dumping out tables but I can't come close to the WIP Epicor provides.

If you are on E9 you can add a custom report style and format it in Crystal for exporting.If on V8 you can see answerbook 6135 MPS on EpicWeb.
That is what I am doing but I was hoping for a explanation of how it's calculated.   When I look at JobProd, there is a WIP quantity but that job does show up in the WIP report.    Just a little confusing.
I've found the WIP Calculation information on Epic Web...type 'WIP Calculation' in Search.



On Tue, Aug 19, 2014 at 10:26 AM, pluedke@… [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>That is what I am doing but I was hoping for a explanation of how it&#39;s calculated.   When I look at JobProd, there is a WIP quantity but that job does show up in the WIP report.    Just a little confusing.</p>



</div>
 


<div style="color:#fff;min-height:0;"></div>



--
C. J. (Carole Jo) Harner
Cost/Inventory Control Analyst
CEMSI
780 Keezletown Road, Suite 102
Weyers Cave, VAÂ 24486Â
Work:Â 540-437-2126

Cell:Â 540-435-2040

Fax: Â 540-234-9768

ITAR NOTICE

This email and/or attachments may contain technical data as defined in the U.S. international traffic in arms regulations (ITAR) section 22 C.F.R. § 120.10. The technical data may not be exported, disclosed or transferred to any foreign person (including employees, consultants, or agents, corporation or business association), as defined in the ITAR section 22 C.F.R. §120.16 whether in the United States or abroad, without the prior written approval of the U.S. Department of State

I downloaded a file from this group under Files > BAQ’s named actvestimatedcost.baq.

 

I had to change a few things for our company but, it works great.

 

I created a crystal report and it is on the schedule for month end. I am able to dump it into Excel.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 18, 2014 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] WIP Calculation

 

 

Can anyone give me a vague description of how WIP is calculated in Epicor?    I am in need of a WIP report to be processed overnight and emailed out to users along with in-stock inventory dollars.  The WIP report Epicor provides is good however it is not in the format anyone wants.    I have been dumping out tables but I can't come close to the WIP Epicor provides.