Full Physical Inventory


(system) #1
Thanks to all for the feedback. Our first inventory we did the same
thing with the WIP and Production Detail report. It does take a long
time to count everything with the reports so we were looking to ease the
process. Entering counts into an Access database worked great but I
still had trouble finding the right data in Vantage to duplicate the
entire WIP report so I could automatically produce a variance report. I
finally had to give up (for now) and created a local table to manually
enter the WIP data to get some variances.

Thanks again for you help,
Butch

________________________________

From: Mike Lowe [mailto:MLowe@...]
Sent: Monday, April 04, 2005 8:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


Here is how we handle WIP at PI time...

Ensured all jobs that should have been closed were actually closed
(sounds like common sense but after the first time you spend an hour
trying to find a job that was already out the door/on the shelf and
finally find someone to fess up "oh, that job is long gone" you'll
understand).

Any raw material not already consumed by a job is returned back into
inventory.

Any completed pieces received into FGI.

This is usually done in preparation for PI and begins a few days before.

On count day (it should be noted that we do not run production during
PI) we run the WIP report and production detail reports for all open
jobs. All the info. for each job is contained in the PD report so we
utilize this as our "tag". This 'tag' is carried to the floor and wip
is verified. If adjustments are needed we make correcting transactions
at that point. Our marked up report is the source document of these
adjusting transactions and is saved, along with the tags with our PI
package for the auditors.

May not work for everyone but works pretty well for us.

Mike Lowe
Connor Manufacturing Services

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Monday, April 04, 2005 7:28 AM
To: vantage@yahoogroups.com
Cc: 'Milleman, Jim'
Subject: RE: [Vantage] Full Physical Inventory


Yes - WIP is REAL fun when it comes to a physical inventory!! You know
darn well the system knows how many pieces should be at each operation
of each job at any given time. I wish Epicor could program Vantage such
that WIP could be included in the normal physical inventory process
(i.e. count tags be generated in job number order/by operation). Then,
counts could be entered/posted -- it would take WIP physical inventory
reconcilation/adjusting from nearly 2 days to less than 1 day (like RAW
& FG)!! I believe Epicor's stance is that at a physical inventory, in a
perfect world, you would not have any WIP; HOWEVER... (if your familar
with the commercial, isn't that why CVS Pharmacy exists, because we
don't live near "PERFECT"?!)



Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by
one.
Go through the materials and labor, this worked for us. But took about
2
days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to
see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have
found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most
of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In
Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]

(system) #2
We are in the middle of a full physical inventory and I would like to
see how other folks are performing the task. The warehouse items are
pretty straight forward because you can use the Count Entry form. We
have found WIP, Incoming Inspection, DMR and RMA to be a little more
challenging because they are in more of a "queue" than a physical
location. I have created an Access database to enter the count tags and
have found most of the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In
Process report but none consistently match - of course when I read the
help file that the Work In Process report has "simulated Cost of Sales
and WIP activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


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

(system) #3
To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by one.
Go through the materials and labor, this worked for us. But took about 2
days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).

(system) #4
Yes - WIP is REAL fun when it comes to a physical inventory!! You know
darn well the system knows how many pieces should be at each operation
of each job at any given time. I wish Epicor could program Vantage such
that WIP could be included in the normal physical inventory process
(i.e. count tags be generated in job number order/by operation). Then,
counts could be entered/posted -- it would take WIP physical inventory
reconcilation/adjusting from nearly 2 days to less than 1 day (like RAW
& FG)!! I believe Epicor's stance is that at a physical inventory, in a
perfect world, you would not have any WIP; HOWEVER... (if your familar
with the commercial, isn't that why CVS Pharmacy exists, because we
don't live near "PERFECT"?!)



Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by
one.
Go through the materials and labor, this worked for us. But took about
2
days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to
see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have
found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most
of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In
Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]

(system) #5
Here is how we handle WIP at PI time...

Ensured all jobs that should have been closed were actually closed (sounds like common sense but after the first time you spend an hour trying to find a job that was already out the door/on the shelf and finally find someone to fess up "oh, that job is long gone" you'll understand).

Any raw material not already consumed by a job is returned back into inventory.

Any completed pieces received into FGI.

This is usually done in preparation for PI and begins a few days before.

On count day (it should be noted that we do not run production during PI) we run the WIP report and production detail reports for all open jobs. All the info. for each job is contained in the PD report so we utilize this as our "tag". This 'tag' is carried to the floor and wip is verified. If adjustments are needed we make correcting transactions at that point. Our marked up report is the source document of these adjusting transactions and is saved, along with the tags with our PI package for the auditors.

May not work for everyone but works pretty well for us.

Mike Lowe
Connor Manufacturing Services

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Monday, April 04, 2005 7:28 AM
To: vantage@yahoogroups.com
Cc: 'Milleman, Jim'
Subject: RE: [Vantage] Full Physical Inventory


Yes - WIP is REAL fun when it comes to a physical inventory!! You know
darn well the system knows how many pieces should be at each operation
of each job at any given time. I wish Epicor could program Vantage such
that WIP could be included in the normal physical inventory process
(i.e. count tags be generated in job number order/by operation). Then,
counts could be entered/posted -- it would take WIP physical inventory
reconcilation/adjusting from nearly 2 days to less than 1 day (like RAW
& FG)!! I believe Epicor's stance is that at a physical inventory, in a
perfect world, you would not have any WIP; HOWEVER... (if your familar
with the commercial, isn't that why CVS Pharmacy exists, because we
don't live near "PERFECT"?!)



Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by
one.
Go through the materials and labor, this worked for us. But took about
2
days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to
see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have
found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most
of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In
Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]

(system) #6
Very goods notes mike.

That is basically what we did as well.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Monday, April 04, 2005 11:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory



Here is how we handle WIP at PI time...

Ensured all jobs that should have been closed were actually closed (sounds
like common sense but after the first time you spend an hour trying to find
a job that was already out the door/on the shelf and finally find someone to
fess up "oh, that job is long gone" you'll understand).

Any raw material not already consumed by a job is returned back into
inventory.

Any completed pieces received into FGI.

This is usually done in preparation for PI and begins a few days before.

On count day (it should be noted that we do not run production during PI)
we run the WIP report and production detail reports for all open jobs. All
the info. for each job is contained in the PD report so we utilize this as
our "tag". This 'tag' is carried to the floor and wip is verified. If
adjustments are needed we make correcting transactions at that point. Our
marked up report is the source document of these adjusting transactions and
is saved, along with the tags with our PI package for the auditors.

May not work for everyone but works pretty well for us.

Mike Lowe
Connor Manufacturing Services

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Monday, April 04, 2005 7:28 AM
To: vantage@yahoogroups.com
Cc: 'Milleman, Jim'
Subject: RE: [Vantage] Full Physical Inventory


Yes - WIP is REAL fun when it comes to a physical inventory!! You know darn
well the system knows how many pieces should be at each operation of each
job at any given time. I wish Epicor could program Vantage such that WIP
could be included in the normal physical inventory process (i.e. count tags
be generated in job number order/by operation). Then, counts could be
entered/posted -- it would take WIP physical inventory
reconcilation/adjusting from nearly 2 days to less than 1 day (like RAW &
FG)!! I believe Epicor's stance is that at a physical inventory, in a
perfect world, you would not have any WIP; HOWEVER... (if your familar with
the commercial, isn't that why CVS Pharmacy exists, because we don't live
near "PERFECT"?!)



Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by one. Go
through the materials and labor, this worked for us. But took about 2 days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).

(system) #7
That is sort of what we do too; however, one thing that we do that
causes us the most problems (self-inflicted) is that we ship most of our
parts from the job, rather than moving them to FG within Vantage (the
parts are maintained in the same general area as our Finished Goods).
We generally use Finished Goods primarily for those parts with a
stocking program in place. Then we have the problem at inventory - is
it FG or WIP? More times than not, it gets tagged as FG, only to
discover a difference with the FG on hand within Vantage. I will employ
a better method of tracking as this year's December inventory approaches
(a system that easily identifies parts still WIP within Vantage even
though they are in the Finished Goods area).

I still think if Epicor could include the WIP inventory as a "warehouse"
and thus, the ability to generate/enter count tags and compare against a
variance report... This would save many of us hours of time at physical
inventory since most inventories occur over weekends or around Christmas
holiday. A time when many of us have better things to do/places to
be...

Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 11:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


Very goods notes mike.

That is basically what we did as well.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Monday, April 04, 2005 11:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory



Here is how we handle WIP at PI time...

Ensured all jobs that should have been closed were actually closed
(sounds
like common sense but after the first time you spend an hour trying to
find
a job that was already out the door/on the shelf and finally find
someone to
fess up "oh, that job is long gone" you'll understand).

Any raw material not already consumed by a job is returned back into
inventory.

Any completed pieces received into FGI.

This is usually done in preparation for PI and begins a few days before.

On count day (it should be noted that we do not run production during
PI)
we run the WIP report and production detail reports for all open jobs.
All
the info. for each job is contained in the PD report so we utilize this
as
our "tag". This 'tag' is carried to the floor and wip is verified. If
adjustments are needed we make correcting transactions at that point.
Our
marked up report is the source document of these adjusting transactions
and
is saved, along with the tags with our PI package for the auditors.

May not work for everyone but works pretty well for us.

Mike Lowe
Connor Manufacturing Services

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Monday, April 04, 2005 7:28 AM
To: vantage@yahoogroups.com
Cc: 'Milleman, Jim'
Subject: RE: [Vantage] Full Physical Inventory


Yes - WIP is REAL fun when it comes to a physical inventory!! You know
darn
well the system knows how many pieces should be at each operation of
each
job at any given time. I wish Epicor could program Vantage such that
WIP
could be included in the normal physical inventory process (i.e. count
tags
be generated in job number order/by operation). Then, counts could be
entered/posted -- it would take WIP physical inventory
reconcilation/adjusting from nearly 2 days to less than 1 day (like RAW
&
FG)!! I believe Epicor's stance is that at a physical inventory, in a
perfect world, you would not have any WIP; HOWEVER... (if your familar
with
the commercial, isn't that why CVS Pharmacy exists, because we don't
live
near "PERFECT"?!)



Thanks!



Rick Ludwig



-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, April 04, 2005 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Full Physical Inventory


To audit WIP, which is real fun by the way.

I would print out the work in process report and out each job one by
one. Go
through the materials and labor, this worked for us. But took about 2
days.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Monday, April 04, 2005 9:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Full Physical Inventory



We are in the middle of a full physical inventory and I would like to
see
how other folks are performing the task. The warehouse items are pretty
straight forward because you can use the Count Entry form. We have
found
WIP, Incoming Inspection, DMR and RMA to be a little more challenging
because they are in more of a "queue" than a physical location. I have
created an Access database to enter the count tags and have found most
of
the tables to produce variance reports:

DMRHead -> DMR
RcvDtl, FirstArt, NonConf -> Inspection Processing
RMARcpt -> RMA

The real problem I'm having is coming up with the WIP totals in Vantage.
I've tried reports from the PartWIP, PartTran, JobAsmbl.IssuedQty,
JobMtlIssuedQty tables but none seem to be consistent with what we are
counting. I've compared each of these tables against the Work In
Process
report but none consistently match - of course when I read the help file
that the Work In Process report has "simulated Cost of Sales and WIP
activity ", I'm not sure this is a reliable report for actuals.

Any help would be appreciated,
Butch


[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views
of the sender and not necessarily the views of the company. The email
and
any files transmitted with it are confidential to the intended recipient
at
the e-mail address to which it has been addressed. It may not be
disclosed
or used by any other than that addressee, nor may it be copied in any
way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized
alteration.
This e-mail has been prepared using information believed by the author
to be
reliable and accurate. Unless expressly stated otherwise, this e-mail
does
not form part of a legally binding contract or agreement between
recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments
(if
any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]