WIP Functionality

Hi,

This may be a bit late to the bonfire but there is a WIP reconciliation map in the help directory:

\\Yourserver\epicor\mfgsys80\Help\enu\Vantage\ccInvGLFlowchart.jpg

(I have recreated this in Viseo 2003 if ne one is interested?)

you may also want to check out the job costing reference guide:

*
\\Yourserver\epicor\mfgsys80\Help\enu\Vantage\JobCostingTechRefGuide_803408.pdf


You may need to change the "mfgsys80" bit of the directory above to get to the files and o/c have downloaded and installed the help from Epicor.

Mark.

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Hi Group
>
> I Would like to get a bit more familiar with the WIP functionality in epicor
> 9 .
>
> We are shipping from job and never have Finished goods in Inventory.
>
> As i understand it the following is happening please confirm if I'm right:
>
> 1) When issuing qty against a job the qty reduces the Inventory and
> increases the WIP (No G/L posting aer done ??)
> 2) When shipping the Job then WIP is not getting touched
> 3) When closing the Job again nothing happens
> 4) When running the Capture COS/WIP then it will take all Closed jobs that
> are shipped and reduce the WIP and put it in AR clearing till it gets
> invoiced.
> 5) Invoicing will reduce AR Clearing and increase AR
>
> Now how can i check whats happening in WIP Account and what the numbers
> posted represent?
> We are facing a issue where our WIP account is in negative.. How is this
> possible?
> Also how can i see what material are currently in WIP? the Work in Process
> report is useless since i cannot format it in a proper way.
>
>
> Any help on this issue with WIP would be appreciated .
> Also whoever is using WIP for Shipping from Job like us i would love to hear
> their procedures on keeping WIP in balance.
>
>
> Ephraim
>
>
> [Non-text portions of this message have been removed]
>
Hi Group

I Would like to get a bit more familiar with the WIP functionality in epicor
9 .

We are shipping from job and never have Finished goods in Inventory.

As i understand it the following is happening please confirm if I'm right:

1) When issuing qty against a job the qty reduces the Inventory and
increases the WIP (No G/L posting aer done ??)
2) When shipping the Job then WIP is not getting touched
3) When closing the Job again nothing happens
4) When running the Capture COS/WIP then it will take all Closed jobs that
are shipped and reduce the WIP and put it in AR clearing till it gets
invoiced.
5) Invoicing will reduce AR Clearing and increase AR

Now how can i check whats happening in WIP Account and what the numbers
posted represent?
We are facing a issue where our WIP account is in negative.. How is this
possible?
Also how can i see what material are currently in WIP? the Work in Process
report is useless since i cannot format it in a proper way.


Any help on this issue with WIP would be appreciated .
Also whoever is using WIP for Shipping from Job like us i would love to hear
their procedures on keeping WIP in balance.


Ephraim


[Non-text portions of this message have been removed]
I give this issue a jump since its very urgent to us now on the year end.

I hope there are other people working with WIP that could help me in this.

I need the WIP G/L account cleared since its in negative and we need to
start fresh.

I know this group is the best resource i could turn to and as i was helped
in the past i hope to get helped now too.

Thanks

Ephraim Feldman

On Fri, Jan 28, 2011 at 12:42 PM, Ephraim Feldman <effgroups@...>wrote:

> Hi Group
>
> I Would like to get a bit more familiar with the WIP functionality in
> epicor 9 .
>
> We are shipping from job and never have Finished goods in Inventory.
>
> As i understand it the following is happening please confirm if I'm right:
>
> 1) When issuing qty against a job the qty reduces the Inventory and
> increases the WIP (No G/L posting aer done ??)
> 2) When shipping the Job then WIP is not getting touched
> 3) When closing the Job again nothing happens
> 4) When running the Capture COS/WIP then it will take all Closed jobs that
> are shipped and reduce the WIP and put it in AR clearing till it gets
> invoiced.
> 5) Invoicing will reduce AR Clearing and increase AR
>
> Now how can i check whats happening in WIP Account and what the numbers
> posted represent?
> We are facing a issue where our WIP account is in negative.. How is this
> possible?
> Also how can i see what material are currently in WIP? the Work in Process
> report is useless since i cannot format it in a proper way.
>
>
> Any help on this issue with WIP would be appreciated .
> Also whoever is using WIP for Shipping from Job like us i would love to
> hear their procedures on keeping WIP in balance.
>
>
> Ephraim
>


[Non-text portions of this message have been removed]
Hi Ephraim, We are on 8.03.408 and we are strictly a make to order business so we have no finished goods in inventory, no materials in inventory that are issued to the jobs and we purchase all raw materials specifically for each job.

>> 1) When issuing qty against a job the qty reduces the Inventory and increases the WIP (No G/L posting are done ??)

You stated earlier in your post that you don't have finished goods in inventory so how are you issuing qty. against the job? Issuing it from where? If what you mean is that you are purchasing material by linking a PO to the job and then receiving the PO, then receiving the PO in Vantage will DR WIP – Material and Credit AP Uninvoiced. You are correct, nothing is posted to the G/L but Vantage does create a transaction which you can view if you run the Inventory/WIP reconciliation report in Production Management/Job Management/Reports. All the transactions that are created are visible through this report and will be posted to the G/L when you Capture COS/WIP. Nothing will be posted to the G/L until you Capture COS/WIP. We print the Inventory/WIP reconciliation report to pdf before running COS/WIP Capture so that we have access to all the transaction detail once it is posted to the GL.

When you are recording labor transactions on the job, this will also DR WIP - Labor & Burden accounts and will CR Applied Overhead & Applied Labor Accounts.

> 2) When shipping the Job then WIP is not getting touched

When we ship to the customer, we ship directly from the order and Vantage creates a MFG-CUS transaction which DR the AR clearing account and CR WIP. If you do not see this movement on the Work In Process Report you can see the transaction on the Inventory/WIP reconciliation report I reference above.

> 3) When closing the Job again nothing happens

Closing the job should not have any impact on WIP, AR clearing, or COS accounts. We do not close our jobs until 30 days after they ship to ensure all costs have been recorded. We have some vendors that tend to invoice late and like to keep that job open until all costs have been invoiced.

> 4) When running the Capture COS/WIP then it will take all Closed jobs that are shipped and reduce the WIP and put it in AR clearing till it gets invoiced.

If you Capture COS/WIP prior to invoicing, the COS/WIP capture will post the transaction to the GL. So it looks like running the COS/WIP capture is creating the transcation to DR AR Clearing and CR WIP but it is not. The COS/WIP Capture is simply posting to the GL the transaction that already took place.

We do not run Capture COS/WIP until after we have completed invoicing.

> 5) Invoicing will reduce AR Clearing and increase AR

Invoicing creates 2 transactions:
CR the AR clearing account and DR COS
DR Acct. Receivable and CR Sales.

You must Capture COS/WIP after invoicing to post the transaction CR AR clearing and DR COS to the GL.


HTH,
Virginia Joseph
Deep Hole Specialists, LLC
440-543-8157


--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Hi Group
>
> I Would like to get a bit more familiar with the WIP functionality in epicor
> 9 .
>
> We are shipping from job and never have Finished goods in Inventory.
>
> As i understand it the following is happening please confirm if I'm right:
>
> 1) When issuing qty against a job the qty reduces the Inventory and
> increases the WIP (No G/L posting aer done ??)
> 2) When shipping the Job then WIP is not getting touched
> 3) When closing the Job again nothing happens
> 4) When running the Capture COS/WIP then it will take all Closed jobs that
> are shipped and reduce the WIP and put it in AR clearing till it gets
> invoiced.
> 5) Invoicing will reduce AR Clearing and increase AR
>
> Now how can i check whats happening in WIP Account and what the numbers
> posted represent?
> We are facing a issue where our WIP account is in negative.. How is this
> possible?
> Also how can i see what material are currently in WIP? the Work in Process
> report is useless since i cannot format it in a proper way.
>
>
> Any help on this issue with WIP would be appreciated .
> Also whoever is using WIP for Shipping from Job like us i would love to hear
> their procedures on keeping WIP in balance.
>
>
> Ephraim
>
>
> [Non-text portions of this message have been removed]
>