WIP Report

Yahoo Archive
1
I was wondering if anyone had a WIP report that basically mirrors the
canned one but allows to sort by completed jobs only. The best scenario
would be if a programming guru out there could modify the existing
canned report with a check box to facilitate that sort option. If anyone
out there is interested you can contact me off the list at
tsarber@... to go over what it would cost.

Todd Sarber
I.S. Manager
Accra-Fab, Inc.
2
Where do I mail my dollar ?
3
Agreed, where do we send the dollar?

Suzanne Willems
Inventory Manager
Milford Enterprises, Inc.

> -----Original Message-----
> From: Keith Taylor [SMTP:keith@...]
> Sent: Wednesday, August 30, 2000 12:06 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage]
>
> Where do I mail my dollar ?
>
>
>
>
4
If ALL 600 of us sent in $1.00 that would buy 10 years of no ads. Count me
in.
Pat Kabel
Loc Performance

-----Original Message-----
From: Suzanne Willems [mailto:swillems@...]
Sent: Wednesday, August 30, 2000 7:04 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage]


Agreed, where do we send the dollar?

Suzanne Willems
Inventory Manager
Milford Enterprises, Inc.

> -----Original Message-----
> From: Keith Taylor [SMTP:keith@...]
> Sent: Wednesday, August 30, 2000 12:06 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage]
>
> Where do I mail my dollar ?
>
>
>
>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
5
Unless they change the rules. But count me in!
Lydia
Canyon Engineering



If ALL 600 of us sent in $1.00 that would buy 10 years of no ads. Count me
in.
Pat Kabel
Loc Performance


Agreed, where do we send the dollar?
Suzanne Willems
Inventory Manager
Milford Enterprises, Inc.

> Where do I mail my dollar ?
6
Has anyone managed to replicate the WIP report?

I would like to see the date completed and date closed added to the
standard report.

• Rob McFarlin, Controller
• Accel Group, Inc.
325 Quadral Dr.
Wadsworth, OH 44281
• (330)336-0317 x14
• FAX(330)336-1224
• RobM@...
7
Does anyone have a W.I.P report that was written in report writer? The V.P. of manufacturing here hates the canned one in Vantage
and from what I can see this could take me some time to develop one. Not that I'm trying to shirk my responsibilities but
it would sure make my life a lot easier if I could get one pre-made. It doesn't have to be a great one, anything that I could customized would be much welcomed.

Thanks for your time.



Jeff House
MIS Coordinator
Airtronics Metal Products
1980 Senter Road
San Jose, CA 95112
(408) 977-7817
Jhouse@...

----------

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:jeff House
TEL;WORK:817
ORG:;MIS
EMAIL;WORK;PREF;NGW:jhouse@...
N:House;jeff
TITLE:Database Administrator
X-GWUSERID:jhouse
END:VCARD



[Non-text portions of this message have been removed]
8
As a matter of fact I am writing one right now in Crystal. We wanted to be
able to run a wip report based on Customer Groups or sorted various ways. I
am at the point of verifying totals and ran across a problem. I am getting
differences in the vantage report labor and my report. I have verified that
my report is right. My report ties to the production detail and the
labordtl table yet the wip report does not. Has anyone experienced this
problem before. I was just about to call vantage support but thought I
would ask you guys first. (usually quicker that way). Once I get this
report done I will publish it on the website for those interested.

-----Original Message-----
From: jeff House [mailto:jhouse@...]
Sent: Wednesday, March 14, 2001 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] WIP Report


Does anyone have a W.I.P report that was written in report writer? The V.P.
of manufacturing here hates the canned one in Vantage
and from what I can see this could take me some time to develop one. Not
that I'm trying to shirk my responsibilities but
it would sure make my life a lot easier if I could get one pre-made. It
doesn't have to be a great one, anything that I could customized would be
much welcomed.

Thanks for your time.



Jeff House
MIS Coordinator
Airtronics Metal Products
1980 Senter Road
San Jose, CA 95112
(408) 977-7817
Jhouse@...

----------

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:jeff House
TEL;WORK:817
ORG:;MIS
EMAIL;WORK;PREF;NGW:jhouse@...
N:House;jeff
TITLE:Database Administrator
X-GWUSERID:jhouse
END:VCARD



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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
9
I don't see a production detail table available. Can you be more specific?

>>> rreilly@... 03/14/01 02:05PM >>>
As a matter of fact I am writing one right now in Crystal. We wanted to be
able to run a wip report based on Customer Groups or sorted various ways. I
am at the point of verifying totals and ran across a problem. I am getting
differences in the vantage report labor and my report. I have verified that
my report is right. My report ties to the production detail and the
labordtl table yet the wip report does not. Has anyone experienced this
problem before. I was just about to call vantage support but thought I
would ask you guys first. (usually quicker that way). Once I get this
report done I will publish it on the website for those interested.

-----Original Message-----
From: jeff House [mailto:jhouse@...]
Sent: Wednesday, March 14, 2001 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] WIP Report


Does anyone have a W.I.P report that was written in report writer? The V.P.
of manufacturing here hates the canned one in Vantage
and from what I can see this could take me some time to develop one. Not
that I'm trying to shirk my responsibilities but
it would sure make my life a lot easier if I could get one pre-made. It
doesn't have to be a great one, anything that I could customized would be
much welcomed.

Thanks for your time.



Jeff House
MIS Coordinator
Airtronics Metal Products
1980 Senter Road
San Jose, CA 95112
(408) 977-7817
Jhouse@...

----------

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:jeff House
TEL;WORK:817
ORG:;MIS
EMAIL;WORK;PREF;NGW:jhouse@...
N:House;jeff
TITLE:Database Administrator
X-GWUSERID:jhouse
END:VCARD



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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
10
Sorry for the confusion I meant to say "My report ties to the Production
detail report". What I meant about the labordtl is that I am told that the
wip report labor totals come from the labordtl table yet in this situation
it is not correct. My report, the production detail report, and the records
from the labordtl table all tie but the Vantage Wip report does not.

-----Original Message-----
From: jhouse@... [mailto:jhouse@...]
Sent: Wednesday, March 14, 2001 3:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] WIP Report


I don't see a production detail table available. Can you be more specific?

>>> rreilly@... 03/14/01 02:05PM >>>
As a matter of fact I am writing one right now in Crystal. We wanted to be
able to run a wip report based on Customer Groups or sorted various ways. I
am at the point of verifying totals and ran across a problem. I am getting
differences in the vantage report labor and my report. I have verified that
my report is right. My report ties to the production detail and the
labordtl table yet the wip report does not. Has anyone experienced this
problem before. I was just about to call vantage support but thought I
would ask you guys first. (usually quicker that way). Once I get this
report done I will publish it on the website for those interested.

-----Original Message-----
From: jeff House [mailto:jhouse@...]
Sent: Wednesday, March 14, 2001 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] WIP Report


Does anyone have a W.I.P report that was written in report writer? The V.P.
of manufacturing here hates the canned one in Vantage
and from what I can see this could take me some time to develop one. Not
that I'm trying to shirk my responsibilities but
it would sure make my life a lot easier if I could get one pre-made. It
doesn't have to be a great one, anything that I could customized would be
much welcomed.

Thanks for your time.



Jeff House
MIS Coordinator
Airtronics Metal Products
1980 Senter Road
San Jose, CA 95112
(408) 977-7817
Jhouse@...

----------

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:jeff House
TEL;WORK:817
ORG:;MIS
EMAIL;WORK;PREF;NGW:jhouse@...
N:House;jeff
TITLE:Database Administrator
X-GWUSERID:jhouse
END:VCARD



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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
11
Sorry, the actual transaction should be WIP-Mfg -- the transaction that
takes the $$ from the transferring job is Mfg-WIP and it is working on the
report.
12
The Wip reconciliation report reports the amount $ of inventory in
WIP. Does anyone ever need to have the quantities associated with
that wip amount? If so, how do you handle that? Did you develp a
report?
13
Good Morning Group,

We are still in the process of adjusting to 5.2, since migrating from 5.0 in
late November.
During the month end closure of January, one of the things that jumped out
at our accounting group was the WIP number in the subcontract column. The
number was -$49,000; it has always been a positive number. Historically, it
usually ran about 10,000 in the positive.

Has this happened to anyone else? We checked the GL reporting structure, and
everything seems to be in order. Any ideas where this number would possibly
come from?



Best Regards,

Pablo Garza
Dix Metals, Inc.
714.677.0799
pgarza@...




[Non-text portions of this message have been removed]
14
Oh yes, I have been complaining about this since we upgraded to 5.1 last
March. Patch 311 is supposed to fix it but there is another problem with the
Wip Material calculation. Seems I have jobs that show a larger amount
distributed to Cost of Sales than what was actually posted. The result is
that WIP Material is understated and when the job closes, a large amount
"purges" from the job. What I don't understand is why we haven't heard more
about this problem from the people who are in 5.1. It jumped out at me the
very first month-end after upgrading.

Karen Brodniak
Accounting Manager
Westwood Precision, Inc.
Phone 425-742-7011 x44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Monday, February 17, 2003 6:54 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] WIP Report


Good Morning Group,

We are still in the process of adjusting to 5.2, since migrating from 5.0
in
late November.
During the month end closure of January, one of the things that jumped out
at our accounting group was the WIP number in the subcontract column. The
number was -$49,000; it has always been a positive number. Historically,
it
usually ran about 10,000 in the positive.

Has this happened to anyone else? We checked the GL reporting structure,
and
everything seems to be in order. Any ideas where this number would
possibly
come from?



Best Regards,

Pablo Garza
Dix Metals, Inc.
714.677.0799
pgarza@...




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


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
15
When we tried a test upgrade from 5.1 to 5.2 our WIP totals where all off.
Epicor could never give us an acceptable answer as to why this happened. We
couldn't figure out if 5.1 was wrong or 5.2. If I remember correctly, it
was a considerable amount. This was the reason for us not upgrading to 5.2
at that time. Since then we have seen everyone else's problems and are
going to wait till 6.0.

Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, February 17, 2003 12:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] WIP Report


Oh yes, I have been complaining about this since we upgraded to 5.1 last
March. Patch 311 is supposed to fix it but there is another problem with the
Wip Material calculation. Seems I have jobs that show a larger amount
distributed to Cost of Sales than what was actually posted. The result is
that WIP Material is understated and when the job closes, a large amount
"purges" from the job. What I don't understand is why we haven't heard more
about this problem from the people who are in 5.1. It jumped out at me the
very first month-end after upgrading.

Karen Brodniak
Accounting Manager
Westwood Precision, Inc.
Phone 425-742-7011 x44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Monday, February 17, 2003 6:54 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] WIP Report


Good Morning Group,

We are still in the process of adjusting to 5.2, since migrating from 5.0
in
late November.
During the month end closure of January, one of the things that jumped out
at our accounting group was the WIP number in the subcontract column. The
number was -$49,000; it has always been a positive number. Historically,
it
usually ran about 10,000 in the positive.

Has this happened to anyone else? We checked the GL reporting structure,
and
everything seems to be in order. Any ideas where this number would
possibly
come from?



Best Regards,

Pablo Garza
Dix Metals, Inc.
714.677.0799
pgarza@...




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


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
16
Good Morning,


We are trying to clean up our WIP report by closing completing and closing
jobs that have shipped.
The report is about 1200 pages. Although we have reduced this report, there
are jobs showing up on the report that are closed through the job closing
feature.

Does anyone in have any insight as to what may be causing these closed jobs
to show up on the report? If so, how do we clean up?
We have discussed this with Vantage support, no one has come up with any
answers.




Pablo Garza
Dix Metals, Inc.





[Non-text portions of this message have been removed]
17
Have you run the Capture COS/WIP Activity from Job Management?


-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Wednesday, April 23, 2003 10:58 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] WIP Report

Good Morning,


We are trying to clean up our WIP report by closing completing and closing
jobs that have shipped.
The report is about 1200 pages. Although we have reduced this report, there
are jobs showing up on the report that are closed through the job closing
feature.

Does anyone in have any insight as to what may be causing these closed jobs
to show up on the report? If so, how do we clean up?
We have discussed this with Vantage support, no one has come up with any
answers.




Pablo Garza
Dix Metals, Inc.
18
Thank you for your response Matt,

Here is a dumb question..What does this process do?

-----Original Message-----
From: Matt Finn [mailto:matt@...]
Sent: Wednesday, April 23, 2003 9:05 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] WIP Report


Have you run the Capture COS/WIP Activity from Job Management?


-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Wednesday, April 23, 2003 10:58 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] WIP Report

Good Morning,


We are trying to clean up our WIP report by closing completing and closing
jobs that have shipped.
The report is about 1200 pages. Although we have reduced this report, there
are jobs showing up on the report that are closed through the job closing
feature.

Does anyone in have any insight as to what may be causing these closed jobs
to show up on the report? If so, how do we clean up?
We have discussed this with Vantage support, no one has come up with any
answers.




Pablo Garza
Dix Metals, Inc.







Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=245454.3115308.4434529.2595810/D=egroupweb/S=17050071
83:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>

<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.2595810/D=egroupmai
l/S=:HM/A=1457554/rand=944480092>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
19
Directly from Vantage Help:

"Use this function to capture current cost-of-sales (COS) and
work-in-process (WIP) activity. Run this function periodically to calculate
the cost-of-sales of any shipments made from WIP, capture costs that have
been relieved from WIP, remove any closed jobs from WIP, and, optionally,
post inventory and WIP activity to your G/L. To keep your cost of sales and
WIP values accurate, you should run this function at regular intervals.
Epicor recommends running this function once each period, before closing the
period in general ledger."



[Non-text portions of this message have been removed]
20
I have been having problems with the WIP report for over a year now. First
there was a problem with the WIP Subcontract and WIP Material totals not
agreeing with the GL. The problem has to do with DMR's. If a subcontractor's
work is rejected, the WIP report was not taking recognizing that the cost of
the rejected parts was no longer in the job. This problem got fixed in 5.2.
There is still a problem with WIP material and it has to do with the DMR's
also. Seems that the system is not recognizing that the rejected parts are
no longer in the job and is adjusting for the rejects in WIP Material. The
result is that the system is Debiting WIP Material and Crediting COS to try
to adjust for the rejected amounts. My WIP material is over 37,000 out of
balance with the GL because of this. Technical support is reviewing the
problem.

Karen Brodniak
Accounting Manager
Westwood Precision, Inc.
Phone 425-742-7011 x44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Pablo Garza [mailto:pgarza@...]
Sent: Wednesday, April 23, 2003 8:58 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] WIP Report


Good Morning,


We are trying to clean up our WIP report by closing completing and closing
jobs that have shipped.
The report is about 1200 pages. Although we have reduced this report,
there
are jobs showing up on the report that are closed through the job closing
feature.

Does anyone in have any insight as to what may be causing these closed
jobs
to show up on the report? If so, how do we clean up?
We have discussed this with Vantage support, no one has come up with any
answers.




Pablo Garza
Dix Metals, Inc.





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


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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