Run Capture WIP - effect on Gross Margin Report

system · March 24, 2012, 9:38am

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...

system · April 5, 2012, 7:39pm

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com>

system · April 7, 2012, 1:36pm

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP@...> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 8:13am

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa@...>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 9:58am

Ken,

You don't have to complete jobs before invoicing, and as mentioned you can't close them before shipping either. We do review job completion and closing everyday based on established criteria here, but completion and closing isn't a must before invoicing. As to why costs aren't showing up, hmmm, then where are the costs going? Is there a lot of activity in your variance accounts? I assume the part numbers you are selling from the jobs all have product codes, which is of course the pointer to all the various accounts for job costs etc.. so if what I read you are saying correctly is that you don't see data populating the cost columns on the invoice detail tables?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Thursday, April 05, 2012 6:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 9:59am

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 10:01am

Those scenrios should only apply if shipping from stock... if you are shipping from the job, actual costs per job (as accumulated at time of shipment) should apply.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 8:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 10:21am

So having a standard costing method with $0 for the costs should not affect these as they are shipping from a job?

I'll have to dig into the GL side. First blush the costs are hitting because our financials for March are not way out of whack. It appears it's only the invoice costing detail that's missing.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Monday, April 09, 2012 8:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Those scenrios should only apply if shipping from stock... if you are shipping from the job, actual costs per job (as accumulated at time of shipment) should apply.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 10:30am

Correct, the only part im a bit shady on is that whether or not the item needs to be declared in the item master as stock or non stock. Id verify that as well. i.e. if you ship a 'stock' part from the job or if you ship a 'non stock' part from the job, I cant remember if that effects the costing scenario or not. I could do some checking later this morning.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 9:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

So having a standard costing method with $0 for the costs should not affect these as they are shipping from a job?

I'll have to dig into the GL side. First blush the costs are hitting because our financials for March are not way out of whack. It appears it's only the invoice costing detail that's missing.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Rob Bucek
Sent: Monday, April 09, 2012 8:01 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Those scenrios should only apply if shipping from stock... if you are shipping from the job, actual costs per job (as accumulated at time of shipment) should apply.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 10:35am

All of these parts would be non-stock, qty bearing, standard costing.

I plan on doing some testing myself, but appreciate those of you who have done the deep dive providing directional assistance!

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Monday, April 09, 2012 8:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Correct, the only part im a bit shady on is that whether or not the item needs to be declared in the item master as stock or non stock. Id verify that as well. i.e. if you ship a 'stock' part from the job or if you ship a 'non stock' part from the job, I cant remember if that effects the costing scenario or not. I could do some checking later this morning.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 9:20 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

So having a standard costing method with $0 for the costs should not affect these as they are shipping from a job?

I'll have to dig into the GL side. First blush the costs are hitting because our financials for March are not way out of whack. It appears it's only the invoice costing detail that's missing.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Rob Bucek
Sent: Monday, April 09, 2012 8:01 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Those scenrios should only apply if shipping from stock... if you are shipping from the job, actual costs per job (as accumulated at time of shipment) should apply.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Monday, April 09, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 12:26pm

We ran into an issue with Epicor 9.05 and standard costing. Apparently when we were on 8.04.408a we benefited from a little "feature" that transferred actual costs from job-to-job. Epicor said that should never have happened in V8, we liked it because our costs were more accurate on large jobs that way.

Once we started testing on E9 we found if we didn't have the standard costs fairly accurate when the lower-level job was received to the parent there was a lot of variance left on the child job. [Disclaimer - I am not a cost accountant, just paraphrasing user/Epicor feedback] For example, we have standard material that goes into a "special" so we add 2 hours additional labor hours to the job. We set that operation to have the tech log his time. He clocked into the operation and it actually took him 3 hours. In V8, all 3 hours would transfer to the parent job. In E9, 2 hours cost transfer to the parent job if a cost roll was done to capture it as part of the standard - the remaining hour stays on the child job as variance.

Something to watch / test as you move from V8 to E9 - not sure if it applies to everyone but it did throw us for a loop.

[Non-text portions of this message have been removed]

system · April 9, 2012, 2:59pm

We have found that using std cost as the costing method, shipping from jobs, the sales gross margin report is affected by the timing of job closing. The trick we have found, you cannot close the job until invoicing is posted....shipping transactions are not the key, rather invoice posting. If jobs are closed prior to invoices posted, it will use the std cost versus the job cost. I saw in this string that 0 was showing up and also saw that 0 was the standard. Sounds like most are trying to time the shipment with job closing versus invoice posting. Based on what we understand this does not matter the part flags stocked or non stocked. Our process is simply not to do daily job closing until shipments are invoiced first thing in the morning. Try some simple tests and let me know if you find the same thing.

Of course that was when we were on 8.03, now on 9 it uses standard cost no matter what. And get this, we asked Epicor about this and their answer....are you sitting down.....your version 8 had a bug, it should have always used std cost, even when shipping from a job.

Chris Berger
Dorner Mfg. Corp.
Controller.

system · April 9, 2012, 5:40pm

Ken

Not sure if anyone has already answered, but average costing method gives your actual cost of sale when shipping

In older version of Vantage when shipping directly from a job, if your part was set to standard it still gave you actual costs, but in the more recent versions Epicor changed it so it gave you a variance and shipped at standard.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP@...> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: 09 April 2012 14:58
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 6:15pm

Manasa

Just to ensure correct information being posted to the user group. At what point can you not close a job before invoicing?

Although the invoice line stores cost information, it is the shipment and its resulting transaction that stores cost information
The Invoice only deals with cost if you have an AR clearing account, but his has nothing to do with the job.

Unless you have a configuration or process that differs, there is nothing to my knowledge in Epicor that stops you from closing a job post shipment and then invoicing it afterwards. The invoicing revenue will either catch up with the shipment transaction that has posted to COS, or will pull the cost from the AR clearing account to COS at point of invoice posting.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP@...> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: 09 April 2012 13:13
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 6:29pm

Gary,

I'm new to Epicor and have a question. Is it possible to process the shipment and print the packing slip without having the parts in inventory. Seems like that is a problem

Rob,

________________________________
From: vantage@yahoogroups.com [vantage@yahoogroups.com] On Behalf Of Gary Parfrey [garyp@...]
Sent: Monday, April 09, 2012 6:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Manasa

Just to ensure correct information being posted to the user group. At what point can you not close a job before invoicing?

Although the invoice line stores cost information, it is the shipment and its resulting transaction that stores cost information
The Invoice only deals with cost if you have an AR clearing account, but his has nothing to do with the job.

Unless you have a configuration or process that differs, there is nothing to my knowledge in Epicor that stops you from closing a job post shipment and then invoicing it afterwards. The invoicing revenue will either catch up with the shipment transaction that has posted to COS, or will pull the cost from the AR clearing account to COS at point of invoice posting.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: 09 April 2012 13:13
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 7:02pm

Ken

If you have set these parts to standard costing and your standard in your part master is set to zero then you will get zero. This will leave cost behind in WIP which will then get variance upon closing and running of capture COS/WIP

Set to average/actual and you may find you start to get costs flowing through

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP@...> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: 09 April 2012 14:58
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary, I checked your list and we are good on all of those items...but I did notice something that I'm sure is causing our issue. I forgot we switched these particular parts to "standard" for costing type because last cost means nothing to us and was leading to incorrect information on reports in other areas. I can switch these back, but then I run into the issues we had with reporting.

Is there any way to get actual costs tied to an invoice without relying on last costing? What happens if we have 3 different units that ship in a given day, all with different costs? If the system is going off last costing then they're 2 out of the 3 units are going to have the wrong cost. What about the last 6 weeks of invoices, any way of adjusting the costs on these?

Thanks for the help,
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: Monday, April 09, 2012 6:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 9, 2012, 7:13pm

Rob

You can enter a packer and print a packing slip but this does not put a shipment transaction through until you mark it as shipped
As this point you can then pull it into an invoice. But it will not be available to invoice until it is shipped.

I believe the original discussion started as Ken was having issues capturing his job costs as part of his shipment transaction. This is often down to standard costing method being used and the standard being set to zero or parts set to non-quantity in the part master

In Vantage 6.1 and prior I believe it worked differently, shipping from a job always used actual cost even the part master was set to standard.

This can also be caused by a certain processes such as job closing being carried out before others as it purges cost from WIP.
These costs no longer exist in WIP and have been 'WIP cleared' and varianced.
Therefore if a job is then reopened and shipped you will find the original cost does not get associated with the shipment as it had already been varianced. (You have to reopen the job as Epicor does not allow you to ship from a closed job)

However when you are using standard costing it will take the standard cost and move your reopened job into a negative WIP value. When this job is reclosed it variances in the opposite direction and should cancel out your original manufacturing variance. This however can cause accounting issues where positive and negative variances span fiscal periods

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

-----------------------------
This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact mailto:GaryP@... and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

-----------------------------

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Van Sant
Sent: 09 April 2012 23:27
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary,

I'm new to Epicor and have a question. Is it possible to process the shipment and print the packing slip without having the parts in inventory. Seems like that is a problem

Rob,

________________________________
From: vantage@yahoogroups.com [vantage@yahoogroups.com] On Behalf Of Gary Parfrey [garyp@...]
Sent: Monday, April 09, 2012 6:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Manasa

Just to ensure correct information being posted to the user group. At what point can you not close a job before invoicing?

Although the invoice line stores cost information, it is the shipment and its resulting transaction that stores cost information The Invoice only deals with cost if you have an AR clearing account, but his has nothing to do with the job.

Unless you have a configuration or process that differs, there is nothing to my knowledge in Epicor that stops you from closing a job post shipment and then invoicing it afterwards. The invoicing revenue will either catch up with the shipment transaction that has posted to COS, or will pull the cost from the AR clearing account to COS at point of invoice posting.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: 09 April 2012 13:13
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 10, 2012, 7:14am

The majority of our orders are make direct but we still utilize parts, we just have limited parts we manufacture to inventory. To prevent issues with make direct parts showing negative on-hand values (due to user error - shipping from inventory instead of from a job) we have set-up a lot of parts as non-quantity bearing with average costing. Below Gary states "This is often down to standard costing method being used and the standard being set to zero or parts set to non-quantity in the part master"

Does this issue with the costs not being captured in the invoice tables in conjunction with the non-quantity checkbox being set to true also apply if using average costing instead of standard costing?

Thanks for everyone's participation on this issue. This has been a great conversation!

Virginia Joseph
Deep Hole Specialists, LLC
440-708-5239
vjoseph@...

system · April 10, 2012, 8:15am

Gary,

If you ship from a job and close it before you invoice, the system won't let you invoice.

I agree with everything else you said. You can complete a job and then if you add costs to the job than those costs hit a variance account because the job is complete. This is for average costing which I found out is not Ken's issue since they are Standard cost.

HTH,

M. Manasa Reddy
manasa@...<mailto:manasa@...>
630.806.2000 x1515
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Gary Parfrey
Sent: Monday, April 09, 2012 5:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Manasa

Just to ensure correct information being posted to the user group. At what point can you not close a job before invoicing?

Although the invoice line stores cost information, it is the shipment and its resulting transaction that stores cost information
The Invoice only deals with cost if you have an AR clearing account, but his has nothing to do with the job.

Unless you have a configuration or process that differs, there is nothing to my knowledge in Epicor that stops you from closing a job post shipment and then invoicing it afterwards. The invoicing revenue will either catch up with the shipment transaction that has posted to COS, or will pull the cost from the AR clearing account to COS at point of invoice posting.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: 09 April 2012 13:13
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

system · April 10, 2012, 9:37am

IMHO, if you are a plant that normally ships from the job and those parts sold are set as non-stock it is somewhat counter intuitive to the design intent with regards to cost flow to have those parts set as standard cost if it is your desire to manage margins from actual costs to sale price. I'm not saying there is only one way to manage margins from this approach, only that for us it has been a much more sane process when we didn't have to fight design intent. If you have your parts set as non-stock, ship from the job; best practice in my opinion should be to complete and close those jobs after shipment (you should still do a daily complete and close process to keep up with this) you'll find you have far less cost hitting your variance accounts, your margins as shipped will be far more accurate, and analyzing REC (realization of estimated cost - what did you leave on the table; the difference between price and cost, low REC being more desirable obviously) becomes an easy task of hitting job costs and tying them to the sales orders they were linked to. In this environment if you were to look at your part costs from an inventory standpoint they would normally be zero, because being non-stock, and average costed and under normal circumstances never having received them into inventory no costs will have been calculated. This can bite you if you occasionally for some reason accept those parts into stock and subsequently ship them, so you have to have some process in place to monitor that as well.. The only thing that prevents costs from being applied to the job after shipment is closing the job. If someone were to apply labor or issue material that may have been missed before shipment, after the part ships, those costs can be seen on the invoice detail table under the JCLbrUnitCost, JCBurUnitCost, etc.. These fields simply house all job costs at the time of job close, which may differ from costs rolled up at time of shipment which is housed in the LbrUnitCost, BurUnitCost etc.. So Vantage does do a good job in my opinion of catching up so to speak, and it does mitigate timing issues somewhat by directing those 'late coming costs' to the correct COS accounts.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Tuesday, April 10, 2012 7:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Gary,

If you ship from a job and close it before you invoice, the system won't let you invoice.

I agree with everything else you said. You can complete a job and then if you add costs to the job than those costs hit a variance account because the job is complete. This is for average costing which I found out is not Ken's issue since they are Standard cost.

HTH,

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com>>
630.806.2000 x1515
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Monday, April 09, 2012 5:15 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Manasa

Just to ensure correct information being posted to the user group. At what point can you not close a job before invoicing?

Although the invoice line stores cost information, it is the shipment and its resulting transaction that stores cost information
The Invoice only deals with cost if you have an AR clearing account, but his has nothing to do with the job.

Unless you have a configuration or process that differs, there is nothing to my knowledge in Epicor that stops you from closing a job post shipment and then invoicing it afterwards. The invoicing revenue will either catch up with the shipment transaction that has posted to COS, or will pull the cost from the AR clearing account to COS at point of invoice posting.

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Manasa Reddy
Sent: 09 April 2012 13:13
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

If you ship off the job, then the job CANNOT be closed before you invoice.

M. Manasa Reddy
manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa@...<mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com><mailto:manasa%40weldcoa.com>>
630.806.2000 x1515

Ex scientia, vera
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Gary Parfrey
Sent: Saturday, April 07, 2012 12:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Ken

Make sure your non stock manufactured items are quantity bearing on your part master.
Make sure you check the COS/Mfg variance checkbox when running capture COS WIP
Make sure you jobs are not closed before you have shipped the goods as you said, but jobs can be but do not have to be closed before invoicing

Gary

Gary Parfrey | Managing Director

Mobile: +44 7765 234 934
DDI: +44 121 314 1172
Main: +44 121 314 1170

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

This e-mail and any files transmitted with it are confidential and are intended solely for the use of the intended recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action based on this communication. If you have received this communication in error please contact GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP@...<mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk><mailto:GaryP%40dotnetit.co.uk>> and delete this communication and any copies of it. Any views or opinions presented are soley of those of the author and do not necessarily represent those of Dot Net IT Limited.

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: 06 April 2012 00:37
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Rob & Virginia - what if you find that no costs are getting captured at the invoice level (and thus the sales GM report shows zero costs)? There's definitely costs to our jobs....but 99% of them are not showing on invoicing, even after capturing WIP.

For years I've been pulling transactional data to make my own reports, but I'd love to just get the system working. Any thoughts on what could cause this activity?

We typically close our jobs out after shipment, is there a requirement that jobs be closed BEFORE invoicing? Please tell me no....

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia Joseph
Sent: Saturday, March 24, 2012 7:38 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Run Capture WIP - effect on Gross Margin Report

Sorry Rob, that was a typo. I meant invoice tables, not inventory tables. I completely agree with your statements about inventory costing.

I have to say I did some more testing and you were right. The Inventory/WIP Reconciliation report seems to be more than just a report. I ran the sales gross margin report for Friday shipments and all the costs were blank (everything that shipped on Friday was make direct - no part number set-up in Vantage). Then I ran the Inventory/WIP Reconciliation report and then re-ran the sales gross margin report and now the job costs appear in the report. Thanks Rob! I now have a gross margin report we can use daily as long as we run Inventory/WIP recociliation on a daily basis!

Ken: Your interest in the effects of capturing without posting to GL is something that I cannot speak to because I have never run the COS capture process without posting to the GL. The only reason I run the COS capture process is specifically to post the transactions to my GL. If there is anyone that rus the COS capture on a regular basis without posting to the GL, I would like to hear what this accomplishes and how either report or data accuracy benefits.

Virginia Joseph
Deep Hole Specialists, LLC
CFO
440-708-5239
440-991-6714 cell
vjoseph@...<mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com><mailto:vjoseph%40deephole.com>

Topic		Replies	Views
Capture/Post WIP Yahoo Archive	16	612	February 26, 2003
Capture COS/WIP Activity Yahoo Archive	11	5104	September 2, 2009
WIP Reconciliation (or unreconciliation) Yahoo Archive	12	1604	March 18, 2009
V 6.1, Costs hungup in WIP Yahoo Archive	3	366	May 6, 2005
Phantom Purge WIP to COS Yahoo Archive	16	3358	November 15, 2007

Run Capture WIP - effect on Gross Margin Report

Related Topics