Windows XP Pro locking up during printing

[system]

Doesn't support XP and Progress 9.1C? That's a good one.

Patrick Winter


-----Original Message-----
From: Mike Tonoyan [mailto:miket@...]
Sent: Friday, May 30, 2003 10:26 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Windows XP Pro locking up during printing


We installed Lexmark drivers for the printer instead of XP built in drivers
and reinstalled Vantage and haven't had the problem since yesterday. The
person working on that particular client mostly prints invoices and that's
when it locks up. I thought it was because of the fancy formula that I had
in the ARform.rpt causing it but after taking the formula out it still did
it. I spoke to Epicor Tech yesterday, I was informed that Progress does not
formally support XP at 9.1C Ver. level. We are using Vantage 5.1 so we are
stuck unless we get W2K. We are also having a big problem with AP check
printing from another XP Pro client on an Epson FX-880 impact printer. Epson
doesn't have XP drivers for that model yet. Thank you.

Mike Tonoyan / All American Products Co.
E-mail: miket@...

----- Original Message -----
From: "Darren Mann" <dmann@...>
To: <vantage@yahoogroups.com>
Sent: Friday, May 30, 2003 5:22 AM
Subject: RE: [Vantage] Re: Windows XP Pro locking up during printing


> Mike,
>
> No we have never found a solution to this problem. Vantage tech felt
> it was the traveler we were using but the same traveler prints fine
> from our Win2000 and win98 computers. Thus I am going to reinstall
> Win2000 in the troubled computer until later XP Pro is more usuable...
> Sorry not much help. Are you experiencing the same problem?
>
> Darren Mann
> Miller Products Co.
>
>
> -----Original Message-----
> From: miket91326 [mailto:miket@...]
> Sent: Thursday, May 29, 2003 2:28 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Windows XP Pro locking up during printing
>
>
> Darren,
>
> Did you find out what was causing XP to lock up during printing? We
> are printing Invoices on XP-Pro the same story. Our printer is Lexmark
> Optra 2455S.
>
> Mike Tonoyan / All American Products Co. miket@...
>
> --- In vantage@yahoogroups.com, Darren Mann <dmann@m...> wrote:
> > That's what I ended up doing, so she quieted down by afternoon.
> Thank
> > goodness...
> >
> > Best Regards,
> > Darren
> >
> > -----Original Message-----
> > From: Paul Siebers [mailto:paul.siebers@b...]
> > Sent: Thursday, January 16, 2003 4:00 PM
> > To: 'vantage@yahoogroups.com'
> > Subject: RE: [Vantage] Windows XP Pro locking up during printing
> >
> >
> > Darren,
> >
> > To combat your user's fear of the new, XP will let you switch back
> to a more
> > old style windows GUI, although it still is not what 3.1 used to
> look like.
> >
> > HTH,
> >
> > Paul
> >
> > -----Original Message-----
> > From: Darren Mann [mailto:dmann@m...]
> > Sent: Thursday, January 16, 2003 3:12 PM
> > To: VANTAGE USER GROUP
> > Subject: [Vantage] Windows XP Pro locking up during printing
> >
> >
> > I installed my first XP Pro station today and it's been one head
> ache after
> > another. The user is not very open to change in her world!!!
> yikees...
> > Win98 to XP - no big deal, right.... I feel better now thanks.
> >
> > Anyway there is an actual problem that I could use help on. When
> you print
> > shop travellers, after 2 or three jobs it locks up on the printing
> records
> > screen. Any ideas?? I updated the HP 4000 drivers, uninstalled and
> > reinstalled Vantage, Checked to insure properties/security of the
> > vntgworking directory.
> >
> > Thanks,
> >
> > Darren Mann
> > Miller Products Co.
>
>
>
> 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/
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003
>
>
>
> 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/
>


------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

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/

[system]

I installed my first XP Pro station today and it's been one head ache after
another. The user is not very open to change in her world!!! yikees...
Win98 to XP - no big deal, right.... I feel better now thanks.

Anyway there is an actual problem that I could use help on. When you print
shop travellers, after 2 or three jobs it locks up on the printing records
screen. Any ideas?? I updated the HP 4000 drivers, uninstalled and
reinstalled Vantage, Checked to insure properties/security of the
vntgworking directory.

Thanks,

Darren Mann
Miller Products Co.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003

[system]

I installed my first XP Pro station today and it's been one head ache after
another. The user is not very open to change in her world!!! yikees...
Win98 to XP - no big deal, right.... I feel better now thanks.

Anyway there is an actual problem that I could use help on. When you print
shop travellers, after 2 or three jobs it locks up on the printing records
screen. Any ideas?? I updated the HP 4000 drivers, uninstalled and
reinstalled Vantage, Checked to insure properties/security of the
vntgworking directory.

Thanks,

Darren Mann
Miller Products Co.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003

[system]

Darren,

To combat your user's fear of the new, XP will let you switch back to a more
old style windows GUI, although it still is not what 3.1 used to look like.

HTH,

Paul

-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Thursday, January 16, 2003 3:12 PM
To: VANTAGE USER GROUP
Subject: [Vantage] Windows XP Pro locking up during printing


I installed my first XP Pro station today and it's been one head ache after
another. The user is not very open to change in her world!!! yikees...
Win98 to XP - no big deal, right.... I feel better now thanks.

Anyway there is an actual problem that I could use help on. When you print
shop travellers, after 2 or three jobs it locks up on the printing records
screen. Any ideas?? I updated the HP 4000 drivers, uninstalled and
reinstalled Vantage, Checked to insure properties/security of the
vntgworking directory.

Thanks,

Darren Mann
Miller Products Co.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003



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/

[system]

That's what I ended up doing, so she quieted down by afternoon. Thank
goodness...

Best Regards,
Darren

-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Thursday, January 16, 2003 4:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Windows XP Pro locking up during printing


Darren,

To combat your user's fear of the new, XP will let you switch back to a more
old style windows GUI, although it still is not what 3.1 used to look like.

HTH,

Paul

-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Thursday, January 16, 2003 3:12 PM
To: VANTAGE USER GROUP
Subject: [Vantage] Windows XP Pro locking up during printing


I installed my first XP Pro station today and it's been one head ache after
another. The user is not very open to change in her world!!! yikees...
Win98 to XP - no big deal, right.... I feel better now thanks.

Anyway there is an actual problem that I could use help on. When you print
shop travellers, after 2 or three jobs it locks up on the printing records
screen. Any ideas?? I updated the HP 4000 drivers, uninstalled and
reinstalled Vantage, Checked to insure properties/security of the
vntgworking directory.

Thanks,

Darren Mann
Miller Products Co.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003



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/



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/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003

[system]

A part number was brought to my attention this morning that showed a balance
of 289 onhand but there were actually zero. I went back and reviewed the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear, but
the Running Total Column and it appears now the Inventory was not updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.

[system]

Does the Running total in Part tracker match your Bin totals? We had a very
similar issue where the partrans table was not being updated. The Bin Qty
are correct but the running totals didn't match. We had to run a conversion
that Epicor provided to clean up the running total. It seems the Bin Qty's
had been updated but no Parttrans record was generated.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Michael Benedict [mailto:mbenedict@...]
Sent: Friday, January 17, 2003 10:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a balance
of 289 onhand but there were actually zero. I went back and reviewed the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear, but
the Running Total Column and it appears now the Inventory was not updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.



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/

[system]

Jeremy,

Yes they do match. The Part Tran records are there, but it appears the
update is not being performed.

Thanks,

Michael

> -----Original Message-----
> From: Leonard, Jeremy [mailto:jleonard@...]
> Sent: Friday, January 17, 2003 9:11 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Inventory Not Updating Correctly
>
>
> Does the Running total in Part tracker match your Bin totals? We
> had a very
> similar issue where the partrans table was not being updated. The Bin Qty
> are correct but the running totals didn't match. We had to run a
> conversion
> that Epicor provided to clean up the running total. It seems the
> Bin Qty's
> had been updated but no Parttrans record was generated.
> Thanks
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Michael Benedict [mailto:mbenedict@...]
> Sent: Friday, January 17, 2003 10:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Inventory Not Updating Correctly
>
>
> A part number was brought to my attention this morning that
> showed a balance
> of 289 onhand but there were actually zero. I went back and reviewed the
> Tran History on the part and noticed several instances where STK-MTL
> transactions were not updating the inventory. The transactions
> appear, but
> the Running Total Column and it appears now the Inventory was not updated
> correctly. This problem appears to have occurred sporadically since we
> installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
> on Purchased Parts and only for STK-MTL transactions. I pulled a
> few of our
> most frequently used materials up in part tracker and it occurs at some
> point in all parts. There is no common link to the parts and a
> transaction
> performed less than one minute after and incorrect transaction will be
> correct. Has anyone else had this issue before?
>
> Thanks,
>
> Michael Benedict
> IS Manager
> Crestview Aerospace Corp.
>
>
>
> 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/
>
>
>
> 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/
>
>
>

[system]

Michael:

You don't have any non-nettable bins do you?

Lydia

-----Original Message-----
From: Michael Benedict [mailto:mbenedict@...]
Sent: Friday, January 17, 2003 7:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory Not Updating Correctly


Jeremy,

Yes they do match. The Part Tran records are there, but it appears the
update is not being performed.

Thanks,

Michael

> -----Original Message-----
> From: Leonard, Jeremy [mailto:jleonard@...]
> Sent: Friday, January 17, 2003 9:11 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Inventory Not Updating Correctly
>
>
> Does the Running total in Part tracker match your Bin totals? We
> had a very
> similar issue where the partrans table was not being updated. The Bin Qty
> are correct but the running totals didn't match. We had to run a
> conversion
> that Epicor provided to clean up the running total. It seems the
> Bin Qty's
> had been updated but no Parttrans record was generated.
> Thanks
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Michael Benedict [mailto:mbenedict@...]
> Sent: Friday, January 17, 2003 10:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Inventory Not Updating Correctly
>
>
> A part number was brought to my attention this morning that
> showed a balance
> of 289 onhand but there were actually zero. I went back and reviewed the
> Tran History on the part and noticed several instances where STK-MTL
> transactions were not updating the inventory. The transactions
> appear, but
> the Running Total Column and it appears now the Inventory was not updated
> correctly. This problem appears to have occurred sporadically since we
> installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
> on Purchased Parts and only for STK-MTL transactions. I pulled a
> few of our
> most frequently used materials up in part tracker and it occurs at some
> point in all parts. There is no common link to the parts and a
> transaction
> performed less than one minute after and incorrect transaction will be
> correct. Has anyone else had this issue before?
>
> Thanks,
>
> Michael Benedict
> IS Manager
> Crestview Aerospace Corp.
>
>
>
> 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/
>
>
>
> 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/
>
>
>

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/

[system]

Not for these parts.

Thanks,

Michael

> -----Original Message-----
> From: Lydia Coffman [mailto:lcoffman@...]
> Sent: Friday, January 17, 2003 10:27 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Inventory Not Updating Correctly
>
>
> Michael:
>
> You don't have any non-nettable bins do you?
>
> Lydia
>
> -----Original Message-----
> From: Michael Benedict [mailto:mbenedict@...]
> Sent: Friday, January 17, 2003 7:25 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Inventory Not Updating Correctly
>
>
> Jeremy,
>
> Yes they do match. The Part Tran records are there, but it appears the
> update is not being performed.
>
> Thanks,
>
> Michael
>
>
> > -----Original Message-----
> > From: Leonard, Jeremy [mailto:jleonard@...]
> > Sent: Friday, January 17, 2003 9:11 AM
> > To: 'vantage@yahoogroups.com'
> > Subject: RE: [Vantage] Inventory Not Updating Correctly
> >
> >
> > Does the Running total in Part tracker match your Bin totals? We
> > had a very
> > similar issue where the partrans table was not being updated.
> The Bin Qty
> > are correct but the running totals didn't match. We had to run a
> > conversion
> > that Epicor provided to clean up the running total. It seems the
> > Bin Qty's
> > had been updated but no Parttrans record was generated.
> > Thanks
> > Jeremy Leonard
> > IT Manager
> > K-T Corporation
> >
> >
> > -----Original Message-----
> > From: Michael Benedict [mailto:mbenedict@...]
> > Sent: Friday, January 17, 2003 10:04 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Inventory Not Updating Correctly
> >
> >
> > A part number was brought to my attention this morning that
> > showed a balance
> > of 289 onhand but there were actually zero. I went back and
> reviewed the
> > Tran History on the part and noticed several instances where STK-MTL
> > transactions were not updating the inventory. The transactions
> > appear, but
> > the Running Total Column and it appears now the Inventory was
> not updated
> > correctly. This problem appears to have occurred sporadically since we
> > installed Vantage 4.0 in 1999, we are now on 5.0. The problem
> only occurs
> > on Purchased Parts and only for STK-MTL transactions. I pulled a
> > few of our
> > most frequently used materials up in part tracker and it occurs at some
> > point in all parts. There is no common link to the parts and a
> > transaction
> > performed less than one minute after and incorrect transaction will be
> > correct. Has anyone else had this issue before?
> >
> > Thanks,
> >
> > Michael Benedict
> > IS Manager
> > Crestview Aerospace Corp.
> >
> >
> >
> > 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/
> >
> >
> >
> > 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/
> >
> >
> >
>
>
>
> 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/
>
>
>
> 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/
>
>
>

[system]

We have had the very same SERIOUS issue. In fact, I have an open issue on this with Epicor now. We had the same problem in Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has caused major problems with the integrity of our Inventory. I still don't think Epicor knows how this happens exactly, although as you have discovered, it seems to be pinpointed to STK-MTL transactions not adjusting the OnHandQty correctly. You mention purchased parts only, but we have seen it with manufactured parts as well (both subassemblies and top level parts, which tells me that it may not be limited to the STK-MTL transaction type).
For us the problem was serious enough that we had a meeting with Epicor on it over a year ago -- partly to say, "if you know of a problem like this, you should at least let user's know so that they can watch their inventory closer. And if we're having this problem, other users are probably having it as well". They have not acted on that suggestion to date. (This suggestion was to higher Epicor management, not Tech Support, by the way).

I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM -- IT CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.

HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using TODAY'S date, enter a date in the past that is far enough back to precede your earliest transaction in your database. It may take some time to run. 1/1/1970 is a good date since it is probably old enough to precede any installation of Vantage. Also, I'm not sure what logic Vantage uses for Date schemes, but if you enter a date like 1/1/50, it may give you 2050 instead of 1950. Running the Stock Status for 1/1/70 should give you a ZERO dollar Stock Status report with ZERO parts in stock. If you find ANY parts listed (positive or negative), note the part(s) and I'll bet you a candy bar that your OnHandQty is wrong for that part(s). The reason this logic works is this: To find the OnHandQty for dates prior to today, the Stock Status assumes the current OnHandQty is correct TODAY, and then it goes through each transaction (PartTran) for a Part and subtracts/adds the quantity of that transaction to the current OnHandQty until it reaches the date you entered. It calculates backwards from today. Thus, back in 1970 (at least from Vantage's perspective) the OnHandQty for every part should be ZERO. Now you can use the list of parts from the report to calculate the TRUE (calculated) OnHandQty. After you have printed/written the list of parts, open up PartTracker. Find one of the guilty parts that has the shortest transaction history. Next, go line by line through each transaction and manually calculate what the OnHandQty should be. If your transacton history is less that 50 transactions, you can do a quick check by scrolling to the end (bottom) of the transaction history to see if the first running total is correct. (I say less than 50 transactions because there is still a known issue with the running totals being inaccurate after more than 100 transactions. The issue used to involve anything over 50 transactions, so I don't trust either).

Epicor sent us a fix program (fixbinsall.r) back last year to recalculate all the OnHandQty's. The problem was, after it fixed our OnHandQty's, our Stock Status changed by significant $$ dollars. Additionally, any parts that were previously affected by this bug, and which also had a Cylce Count done on them to correct the OnHandQty through a ADJ-QTY, these parts are now OFF again by the amount of the ADJ-QTY. So even after running the 'fixbinsall.r' program, we weren't sure if our OnHandQty was right or not. We ended up doing a complete Inventory Count on all 10,000+ parts in our inventory to clarify the integrity our Stock Status. And now to find out that the problem is still there is incredibly disconcerting. In these days of Enron scandals, this type of thing makes our Controller VERY nervous and our auditors VERY suspicious. Auditor: "Why did your stock status change by thousands of dollars, but we don't see it in your Cost of Sales or anywhere else for that matter?" Controller: "Well, we ran this fix program on our database and it changed our stock status, but you won't see any transactions showing that it did so." Auditor: "What did the fix program do?'". Controller: "It adjusted for a bug in the database that causes it to not calculate our OnHandQty correctly. It goes in and changes the OnHandQty if they are wrong." Auditor: "Which parts did it change?" Controller: "We don't know." Auditor: "O.K. so the bug is fixed now then, right?". Controller: "No, the database can still cause OnHandQty's to be incorrect. We're not sure when it happens or how often, or for how long it has been happening." Auditor: "Do you know how to spell E-N-R-O-N? What has your software company done about this, and when did you first know it existed?" Controller: "We brought the problem to their attention over a year ago. There has been no bug fix for it, nor is there any SCR written to fix it." Auditor: "Why are you still using this software?" Controller: "Good question."

Michael. Thanks for bringing this to our attention. And as I mentioned, I would love to see how many Vantage Customers this is affecting and by how many $$ dollars. I assume it could be hundreds of users if not 100% of the Vantage userbase. I had assumed up until about a month ago that this bug was fixed in 5.1, but I have verified in our current database that it is not. I would have to assume it is still a problem in 5.2 as it has never been addressed in a patch to this date (in addition to the fact that if your OnHandQty's were off in 5.1 or any earlier version, those OnHandQty's would be brought right into 5.2 as well.

Sorry for the long letter. I believe this issue is serious enough that users should be aware and vigilant. Sometimes to be TOO brief is to invite misunderstanding.

With much gravity,

Troy Funte
Liberty Electronics

----- Original Message -----
From: Michael Benedict
To: vantage@yahoogroups.com
Sent: Friday, January 17, 2003 10:04 AM
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a balance
of 289 onhand but there were actually zero. I went back and reviewed the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear, but
the Running Total Column and it appears now the Inventory was not updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.


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]

[system]

Gee whiz Troy ... Our Sales Rep forgot to mention this during his
presentations at our evaluation meetings ...
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, January 18, 2003 12:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory Not Updating Correctly


We have had the very same SERIOUS issue. In fact, I have an open issue
on this with Epicor now. We had the same problem in Vantage 3.0 and 5.0, we
are now seeing it in 5.1 as well. It has caused major problems with the
integrity of our Inventory. I still don't think Epicor knows how this
happens exactly, although as you have discovered, it seems to be pinpointed
to STK-MTL transactions not adjusting the OnHandQty correctly. You mention
purchased parts only, but we have seen it with manufactured parts as well
(both subassemblies and top level parts, which tells me that it may not be
limited to the STK-MTL transaction type).
For us the problem was serious enough that we had a meeting with Epicor
on it over a year ago -- partly to say, "if you know of a problem like this,
you should at least let user's know so that they can watch their inventory
closer. And if we're having this problem, other users are probably having
it as well". They have not acted on that suggestion to date. (This
suggestion was to higher Epicor management, not Tech Support, by the way).

I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY
RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I
WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM -- IT
CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.

HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using
TODAY'S date, enter a date in the past that is far enough back to precede
your earliest transaction in your database. It may take some time to run.
1/1/1970 is a good date since it is probably old enough to precede any
installation of Vantage. Also, I'm not sure what logic Vantage uses for
Date schemes, but if you enter a date like 1/1/50, it may give you 2050
instead of 1950. Running the Stock Status for 1/1/70 should give you a ZERO
dollar Stock Status report with ZERO parts in stock. If you find ANY parts
listed (positive or negative), note the part(s) and I'll bet you a candy bar
that your OnHandQty is wrong for that part(s). The reason this logic works
is this: To find the OnHandQty for dates prior to today, the Stock Status
assumes the current OnHandQty is correct TODAY, and then it goes through
each transaction (PartTran) for a Part and subtracts/adds the quantity of
that transaction to the current OnHandQty until it reaches the date you
entered. It calculates backwards from today. Thus, back in 1970 (at least
from Vantage's perspective) the OnHandQty for every part should be ZERO.
Now you can use the list of parts from the report to calculate the TRUE
(calculated) OnHandQty. After you have printed/written the list of parts,
open up PartTracker. Find one of the guilty parts that has the shortest
transaction history. Next, go line by line through each transaction and
manually calculate what the OnHandQty should be. If your transacton history
is less that 50 transactions, you can do a quick check by scrolling to the
end (bottom) of the transaction history to see if the first running total is
correct. (I say less than 50 transactions because there is still a known
issue with the running totals being inaccurate after more than 100
transactions. The issue used to involve anything over 50 transactions, so I
don't trust either).

Epicor sent us a fix program (fixbinsall.r) back last year to recalculate
all the OnHandQty's. The problem was, after it fixed our OnHandQty's, our
Stock Status changed by significant $$ dollars. Additionally, any parts
that were previously affected by this bug, and which also had a Cylce Count
done on them to correct the OnHandQty through a ADJ-QTY, these parts are now
OFF again by the amount of the ADJ-QTY. So even after running the
'fixbinsall.r' program, we weren't sure if our OnHandQty was right or not.
We ended up doing a complete Inventory Count on all 10,000+ parts in our
inventory to clarify the integrity our Stock Status. And now to find out
that the problem is still there is incredibly disconcerting. In these days
of Enron scandals, this type of thing makes our Controller VERY nervous and
our auditors VERY suspicious. Auditor: "Why did your stock status change by
thousands of dollars, but we don't see it in your Cost of Sales or anywhere
else for that matter?" Controller: "Well, we ran this fix program on our
database and it changed our stock status, but you won't see any transactions
showing that it did so." Auditor: "What did the fix program do?'".
Controller: "It adjusted for a bug in the database that causes it to not
calculate our OnHandQty correctly. It goes in and changes the OnHandQty if
they are wrong." Auditor: "Which parts did it change?" Controller: "We
don't know." Auditor: "O.K. so the bug is fixed now then, right?".
Controller: "No, the database can still cause OnHandQty's to be incorrect.
We're not sure when it happens or how often, or for how long it has been
happening." Auditor: "Do you know how to spell E-N-R-O-N? What has your
software company done about this, and when did you first know it existed?"
Controller: "We brought the problem to their attention over a year ago.
There has been no bug fix for it, nor is there any SCR written to fix it."
Auditor: "Why are you still using this software?" Controller: "Good
question."

Michael. Thanks for bringing this to our attention. And as I mentioned,
I would love to see how many Vantage Customers this is affecting and by how
many $$ dollars. I assume it could be hundreds of users if not 100% of the
Vantage userbase. I had assumed up until about a month ago that this bug
was fixed in 5.1, but I have verified in our current database that it is
not. I would have to assume it is still a problem in 5.2 as it has never
been addressed in a patch to this date (in addition to the fact that if your
OnHandQty's were off in 5.1 or any earlier version, those OnHandQty's would
be brought right into 5.2 as well.

Sorry for the long letter. I believe this issue is serious enough that
users should be aware and vigilant. Sometimes to be TOO brief is to invite
misunderstanding.

With much gravity,

Troy Funte
Liberty Electronics

----- Original Message -----
From: Michael Benedict
To: vantage@yahoogroups.com
Sent: Friday, January 17, 2003 10:04 AM
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a
balance
of 289 onhand but there were actually zero. I went back and reviewed
the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear,
but
the Running Total Column and it appears now the Inventory was not
updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only
occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of
our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a
transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.


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]


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]

[system]

Troy,
Per your suggestion I ran the stock status report. We have three
items showing up with negative onhand quantities which conflicts with
their part tracker inventory. Doesn't appear to be a big problem for
us right now, but it is still an issue.
Put us down for a "me too".

John Elder
Penn State Tool & Die

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> We have had the very same SERIOUS issue. In fact, I have an
open issue on this with Epicor now. We had the same problem in
Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has
caused major problems with the integrity of our Inventory. I still
don't think Epicor knows how this happens exactly, although as you
have discovered, it seems to be pinpointed to STK-MTL transactions
not adjusting the OnHandQty correctly. You mention purchased parts
only, but we have seen it with manufactured parts as well (both
subassemblies and top level parts, which tells me that it may not be
limited to the STK-MTL transaction type).......

[system]

We have almost 3 pages of 'problem' parts, it's no wonder some of the users
here are saying they don't believe the inventory figures reported by
Vantage!

Paul Oliver
Concentric Controls Ltd.

----- Original Message -----
From: <johne@...>
To: <vantage@yahoogroups.com>
Sent: Monday, January 20, 2003 2:02 PM
Subject: [Vantage] Re: Inventory Not Updating Correctly


> Troy,
> Per your suggestion I ran the stock status report. We have three
> items showing up with negative onhand quantities which conflicts with
> their part tracker inventory. Doesn't appear to be a big problem for
> us right now, but it is still an issue.
> Put us down for a "me too".
>
> John Elder
> Penn State Tool & Die
>
> --- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> > We have had the very same SERIOUS issue. In fact, I have an
> open issue on this with Epicor now. We had the same problem in
> Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has
> caused major problems with the integrity of our Inventory. I still
> don't think Epicor knows how this happens exactly, although as you
> have discovered, it seems to be pinpointed to STK-MTL transactions
> not adjusting the OnHandQty correctly. You mention purchased parts
> only, but we have seen it with manufactured parts as well (both
> subassemblies and top level parts, which tells me that it may not be
> limited to the STK-MTL transaction type).......
>
>
>
> 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/
>


This e-Mail (and any attachments) should only be read by the intended
addressee(s) and not be relied upon without subsequent written confirmation
of its contents. Concentric Controls Ltd. accepts no liability for the
consequences of any person acting on such information prior to the receipt
of such confirmation. If you are not the intended recipient, you are not
authorised to, and must not use, disclose, copy, distribute, or retain this
message, its attachments or any part thereof. Any views or opinions
expressed are those of the author and do not necessarily reflect the
opinions of Concentric Controls Ltd.

Concentric Controls Ltd. www.concentriccontrols.com
Priory Road, Aston, Birmingham B6 7LH, UK
Tel: +44 (0)121 327 1662 Fax: +44 (0)121 328 2498

[system]

Thanks Troy. I ran it and now have an Accountant who is bent out of shape.
We had a page and a quarter worth. She says that every job is checked, and
stock status is right on. Has me running the report again, using a more
recent date (still outside the relm of possibility). She believes that it's
something with the very old date. Will see.... :) God I love to watch these
Bean Counters squirm..

Les

> -----Original Message-----
> From: pennstatetool <johne@...>
> [SMTP:johne@...]
> Sent: Monday, January 20, 2003 9:03 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Inventory Not Updating Correctly
>
> Troy,
> Per your suggestion I ran the stock status report. We have three
> items showing up with negative onhand quantities which conflicts with
> their part tracker inventory. Doesn't appear to be a big problem for
> us right now, but it is still an issue.
> Put us down for a "me too".
>
> John Elder
> Penn State Tool & Die
>
> --- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> > We have had the very same SERIOUS issue. In fact, I have an
> open issue on this with Epicor now. We had the same problem in
> Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has
> caused major problems with the integrity of our Inventory. I still
> don't think Epicor knows how this happens exactly, although as you
> have discovered, it seems to be pinpointed to STK-MTL transactions
> not adjusting the OnHandQty correctly. You mention purchased parts
> only, but we have seen it with manufactured parts as well (both
> subassemblies and top level parts, which tells me that it may not be
> limited to the STK-MTL transaction type).......
>
>
>
> 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/
>

[system]

I wonder if those who respond by checking their stock status could also mention which version of Vantage they are running.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Saturday, January 18, 2003 12:27 AM
Subject: Re: [Vantage] Inventory Not Updating Correctly


We have had the very same SERIOUS issue. In fact, I have an open issue on this with Epicor now. We had the same problem in Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has caused major problems with the integrity of our Inventory. I still don't think Epicor knows how this happens exactly, although as you have discovered, it seems to be pinpointed to STK-MTL transactions not adjusting the OnHandQty correctly. You mention purchased parts only, but we have seen it with manufactured parts as well (both subassemblies and top level parts, which tells me that it may not be limited to the STK-MTL transaction type).
For us the problem was serious enough that we had a meeting with Epicor on it over a year ago -- partly to say, "if you know of a problem like this, you should at least let user's know so that they can watch their inventory closer. And if we're having this problem, other users are probably having it as well". They have not acted on that suggestion to date. (This suggestion was to higher Epicor management, not Tech Support, by the way).

I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM -- IT CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.

HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using TODAY'S date, enter a date in the past that is far enough back to precede your earliest transaction in your database. It may take some time to run. 1/1/1970 is a good date since it is probably old enough to precede any installation of Vantage. Also, I'm not sure what logic Vantage uses for Date schemes, but if you enter a date like 1/1/50, it may give you 2050 instead of 1950. Running the Stock Status for 1/1/70 should give you a ZERO dollar Stock Status report with ZERO parts in stock. If you find ANY parts listed (positive or negative), note the part(s) and I'll bet you a candy bar that your OnHandQty is wrong for that part(s). The reason this logic works is this: To find the OnHandQty for dates prior to today, the Stock Status assumes the current OnHandQty is correct TODAY, and then it goes through each transaction (PartTran) for a Part and subtracts/adds the quantity of that transaction to the current OnHandQty until it reaches the date you entered. It calculates backwards from today. Thus, back in 1970 (at least from Vantage's perspective) the OnHandQty for every part should be ZERO. Now you can use the list of parts from the report to calculate the TRUE (calculated) OnHandQty. After you have printed/written the list of parts, open up PartTracker. Find one of the guilty parts that has the shortest transaction history. Next, go line by line through each transaction and manually calculate what the OnHandQty should be. If your transacton history is less that 50 transactions, you can do a quick check by scrolling to the end (bottom) of the transaction history to see if the first running total is correct. (I say less than 50 transactions because there is still a known issue with the running totals being inaccurate after more than 100 transactions. The issue used to involve anything over 50 transactions, so I don't trust either).

Epicor sent us a fix program (fixbinsall.r) back last year to recalculate all the OnHandQty's. The problem was, after it fixed our OnHandQty's, our Stock Status changed by significant $$ dollars. Additionally, any parts that were previously affected by this bug, and which also had a Cylce Count done on them to correct the OnHandQty through a ADJ-QTY, these parts are now OFF again by the amount of the ADJ-QTY. So even after running the 'fixbinsall.r' program, we weren't sure if our OnHandQty was right or not. We ended up doing a complete Inventory Count on all 10,000+ parts in our inventory to clarify the integrity our Stock Status. And now to find out that the problem is still there is incredibly disconcerting. In these days of Enron scandals, this type of thing makes our Controller VERY nervous and our auditors VERY suspicious. Auditor: "Why did your stock status change by thousands of dollars, but we don't see it in your Cost of Sales or anywhere else for that matter?" Controller: "Well, we ran this fix program on our database and it changed our stock status, but you won't see any transactions showing that it did so." Auditor: "What did the fix program do?'". Controller: "It adjusted for a bug in the database that causes it to not calculate our OnHandQty correctly. It goes in and changes the OnHandQty if they are wrong." Auditor: "Which parts did it change?" Controller: "We don't know." Auditor: "O.K. so the bug is fixed now then, right?". Controller: "No, the database can still cause OnHandQty's to be incorrect. We're not sure when it happens or how often, or for how long it has been happening." Auditor: "Do you know how to spell E-N-R-O-N? What has your software company done about this, and when did you first know it existed?" Controller: "We brought the problem to their attention over a year ago. There has been no bug fix for it, nor is there any SCR written to fix it." Auditor: "Why are you still using this software?" Controller: "Good question."

Michael. Thanks for bringing this to our attention. And as I mentioned, I would love to see how many Vantage Customers this is affecting and by how many $$ dollars. I assume it could be hundreds of users if not 100% of the Vantage userbase. I had assumed up until about a month ago that this bug was fixed in 5.1, but I have verified in our current database that it is not. I would have to assume it is still a problem in 5.2 as it has never been addressed in a patch to this date (in addition to the fact that if your OnHandQty's were off in 5.1 or any earlier version, those OnHandQty's would be brought right into 5.2 as well.

Sorry for the long letter. I believe this issue is serious enough that users should be aware and vigilant. Sometimes to be TOO brief is to invite misunderstanding.

With much gravity,

Troy Funte
Liberty Electronics


----- Original Message -----
From: Michael Benedict
To: vantage@yahoogroups.com
Sent: Friday, January 17, 2003 10:04 AM
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a balance
of 289 onhand but there were actually zero. I went back and reviewed the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear, but
the Running Total Column and it appears now the Inventory was not updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.


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]


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]

[system]

Troy,

We have the same problem, many parts are off.

Thanks
Kim Wood
Electro Chemical Finishing

-----Original Message-----
From: Michael D. Howard [mailto:mike@...]
Sent: Monday, January 20, 2003 8:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory Not Updating Correctly


Gee whiz Troy ... Our Sales Rep forgot to mention this during his
presentations at our evaluation meetings ...
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, January 18, 2003 12:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory Not Updating Correctly


We have had the very same SERIOUS issue. In fact, I have an open issue
on this with Epicor now. We had the same problem in Vantage 3.0 and 5.0, we
are now seeing it in 5.1 as well. It has caused major problems with the
integrity of our Inventory. I still don't think Epicor knows how this
happens exactly, although as you have discovered, it seems to be pinpointed
to STK-MTL transactions not adjusting the OnHandQty correctly. You mention
purchased parts only, but we have seen it with manufactured parts as well
(both subassemblies and top level parts, which tells me that it may not be
limited to the STK-MTL transaction type).
For us the problem was serious enough that we had a meeting with Epicor
on it over a year ago -- partly to say, "if you know of a problem like this,
you should at least let user's know so that they can watch their inventory
closer. And if we're having this problem, other users are probably having
it as well". They have not acted on that suggestion to date. (This
suggestion was to higher Epicor management, not Tech Support, by the way).

I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY
RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I
WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM -- IT
CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.

HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using
TODAY'S date, enter a date in the past that is far enough back to precede
your earliest transaction in your database. It may take some time to run.
1/1/1970 is a good date since it is probably old enough to precede any
installation of Vantage. Also, I'm not sure what logic Vantage uses for
Date schemes, but if you enter a date like 1/1/50, it may give you 2050
instead of 1950. Running the Stock Status for 1/1/70 should give you a ZERO
dollar Stock Status report with ZERO parts in stock. If you find ANY parts
listed (positive or negative), note the part(s) and I'll bet you a candy bar
that your OnHandQty is wrong for that part(s). The reason this logic works
is this: To find the OnHandQty for dates prior to today, the Stock Status
assumes the current OnHandQty is correct TODAY, and then it goes through
each transaction (PartTran) for a Part and subtracts/adds the quantity of
that transaction to the current OnHandQty until it reaches the date you
entered. It calculates backwards from today. Thus, back in 1970 (at least
from Vantage's perspective) the OnHandQty for every part should be ZERO. Now
you can use the list of parts from the report to calculate the TRUE
(calculated) OnHandQty. After you have printed/written the list of parts,
open up PartTracker. Find one of the guilty parts that has the shortest
transaction history. Next, go line by line through each transaction and
manually calculate what the OnHandQty should be. If your transacton history
is less that 50 transactions, you can do a quick check by scrolling to the
end (bottom) of the transaction history to see if the first running total is
correct. (I say less than 50 transactions because there is still a known
issue with the running totals being inaccurate after more than 100
transactions. The issue used to involve anything over 50 transactions, so I
don't trust either).

Epicor sent us a fix program (fixbinsall.r) back last year to recalculate
all the OnHandQty's. The problem was, after it fixed our OnHandQty's, our
Stock Status changed by significant $$ dollars. Additionally, any parts
that were previously affected by this bug, and which also had a Cylce Count
done on them to correct the OnHandQty through a ADJ-QTY, these parts are now
OFF again by the amount of the ADJ-QTY. So even after running the
'fixbinsall.r' program, we weren't sure if our OnHandQty was right or not.
We ended up doing a complete Inventory Count on all 10,000+ parts in our
inventory to clarify the integrity our Stock Status. And now to find out
that the problem is still there is incredibly disconcerting. In these days
of Enron scandals, this type of thing makes our Controller VERY nervous and
our auditors VERY suspicious. Auditor: "Why did your stock status change by
thousands of dollars, but we don't see it in your Cost of Sales or anywhere
else for that matter?" Controller: "Well, we ran this fix program on our
database and it changed our stock status, but you won't see any transactions
showing that it did so." Auditor: "What did the fix program do?'".
Controller: "It adjusted for a bug in the database that causes it to not
calculate our OnHandQty correctly. It goes in and changes the OnHandQty if
they are wrong." Auditor: "Which parts did it change?" Controller: "We
don't know." Auditor: "O.K. so the bug is fixed now then, right?".
Controller: "No, the database can still cause OnHandQty's to be incorrect.
We're not sure when it happens or how often, or for how long it has been
happening." Auditor: "Do you know how to spell E-N-R-O-N? What has your
software company done about this, and when did you first know it existed?"
Controller: "We brought the problem to their attention over a year ago.
There has been no bug fix for it, nor is there any SCR written to fix it."
Auditor: "Why are you still using this software?" Controller: "Good
question."

Michael. Thanks for bringing this to our attention. And as I mentioned,
I would love to see how many Vantage Customers this is affecting and by how
many $$ dollars. I assume it could be hundreds of users if not 100% of the
Vantage userbase. I had assumed up until about a month ago that this bug
was fixed in 5.1, but I have verified in our current database that it is
not. I would have to assume it is still a problem in 5.2 as it has never
been addressed in a patch to this date (in addition to the fact that if your
OnHandQty's were off in 5.1 or any earlier version, those OnHandQty's would
be brought right into 5.2 as well.

Sorry for the long letter. I believe this issue is serious enough that
users should be aware and vigilant. Sometimes to be TOO brief is to invite
misunderstanding.

With much gravity,

Troy Funte
Liberty Electronics

----- Original Message -----
From: Michael Benedict
To: vantage@yahoogroups.com
Sent: Friday, January 17, 2003 10:04 AM
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a
balance
of 289 onhand but there were actually zero. I went back and reviewed
the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear,
but
the Running Total Column and it appears now the Inventory was not
updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only
occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of
our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a
transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.


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]


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/

[system]

Gee thanks, Les! Is that a matter of sliding off the hot seat so that
someone else can enjoy it for a change!?!

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: Les Tingley [mailto:ltingley@...]
Sent: Monday, January 20, 2003 9:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Inventory Not Updating Correctly


Thanks Troy. I ran it and now have an Accountant who is bent out of shape.
We had a page and a quarter worth. She says that every job is checked, and
stock status is right on. Has me running the report again, using a more
recent date (still outside the relm of possibility). She believes that it's
something with the very old date. Will see.... :) God I love to watch these
Bean Counters squirm..

Les

> -----Original Message-----
> From: pennstatetool <johne@...>
> [SMTP:johne@...]
> Sent: Monday, January 20, 2003 9:03 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Inventory Not Updating Correctly
>
> Troy,
> Per your suggestion I ran the stock status report. We have three
> items showing up with negative onhand quantities which conflicts with
> their part tracker inventory. Doesn't appear to be a big problem for
> us right now, but it is still an issue.
> Put us down for a "me too".
>
> John Elder
> Penn State Tool & Die
>
> --- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> > We have had the very same SERIOUS issue. In fact, I have an
> open issue on this with Epicor now. We had the same problem in
> Vantage 3.0 and 5.0, we are now seeing it in 5.1 as well. It has
> caused major problems with the integrity of our Inventory. I still
> don't think Epicor knows how this happens exactly, although as you
> have discovered, it seems to be pinpointed to STK-MTL transactions
> not adjusting the OnHandQty correctly. You mention purchased parts
> only, but we have seen it with manufactured parts as well (both
> subassemblies and top level parts, which tells me that it may not be
> limited to the STK-MTL transaction type).......
>
>
>
> 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/
>

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/



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

[system]

I ran the stock status report on my version 4.0 patch 902 database as of
01/01/1970 and the results are a 79 page report. This is freaking me out and
it surely should be freaking Epicor out as it could have major repurcusions
upon them.

Todd Hofert

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, January 20, 2003 9:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory Not Updating Correctly


I wonder if those who respond by checking their stock status could also
mention which version of Vantage they are running.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Saturday, January 18, 2003 12:27 AM
Subject: Re: [Vantage] Inventory Not Updating Correctly


We have had the very same SERIOUS issue. In fact, I have an open issue
on this with Epicor now. We had the same problem in Vantage 3.0 and 5.0, we
are now seeing it in 5.1 as well. It has caused major problems with the
integrity of our Inventory. I still don't think Epicor knows how this
happens exactly, although as you have discovered, it seems to be pinpointed
to STK-MTL transactions not adjusting the OnHandQty correctly. You mention
purchased parts only, but we have seen it with manufactured parts as well
(both subassemblies and top level parts, which tells me that it may not be
limited to the STK-MTL transaction type).
For us the problem was serious enough that we had a meeting with Epicor
on it over a year ago -- partly to say, "if you know of a problem like this,
you should at least let user's know so that they can watch their inventory
closer. And if we're having this problem, other users are probably having
it as well". They have not acted on that suggestion to date. (This
suggestion was to higher Epicor management, not Tech Support, by the way).

I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY
RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I
WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM -- IT
CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.

HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using
TODAY'S date, enter a date in the past that is far enough back to precede
your earliest transaction in your database. It may take some time to run.
1/1/1970 is a good date since it is probably old enough to precede any
installation of Vantage. Also, I'm not sure what logic Vantage uses for
Date schemes, but if you enter a date like 1/1/50, it may give you 2050
instead of 1950. Running the Stock Status for 1/1/70 should give you a ZERO
dollar Stock Status report with ZERO parts in stock. If you find ANY parts
listed (positive or negative), note the part(s) and I'll bet you a candy bar
that your OnHandQty is wrong for that part(s). The reason this logic works
is this: To find the OnHandQty for dates prior to today, the Stock Status
assumes the current OnHandQty is correct TODAY, and then it goes through
each transaction (PartTran) for a Part and subtracts/adds the quantity of
that transaction to the current OnHandQty until it reaches the date you
entered. It calculates backwards from today. Thus, back in 1970 (at least
from Vantage's perspective) the OnHandQty for every part should be ZERO.
Now you can use the list of parts from the report to calculate the TRUE
(calculated) OnHandQty. After you have printed/written the list of parts,
open up PartTracker. Find one of the guilty parts that has the shortest
transaction history. Next, go line by line through each transaction and
manually calculate what the OnHandQty should be. If your transacton history
is less that 50 transactions, you can do a quick check by scrolling to the
end (bottom) of the transaction history to see if the first running total is
correct. (I say less than 50 transactions because there is still a known
issue with the running totals being inaccurate after more than 100
transactions. The issue used to involve anything over 50 transactions, so I
don't trust either).

Epicor sent us a fix program (fixbinsall.r) back last year to recalculate
all the OnHandQty's. The problem was, after it fixed our OnHandQty's, our
Stock Status changed by significant $$ dollars. Additionally, any parts
that were previously affected by this bug, and which also had a Cylce Count
done on them to correct the OnHandQty through a ADJ-QTY, these parts are now
OFF again by the amount of the ADJ-QTY. So even after running the
'fixbinsall.r' program, we weren't sure if our OnHandQty was right or not.
We ended up doing a complete Inventory Count on all 10,000+ parts in our
inventory to clarify the integrity our Stock Status. And now to find out
that the problem is still there is incredibly disconcerting. In these days
of Enron scandals, this type of thing makes our Controller VERY nervous and
our auditors VERY suspicious. Auditor: "Why did your stock status change by
thousands of dollars, but we don't see it in your Cost of Sales or anywhere
else for that matter?" Controller: "Well, we ran this fix program on our
database and it changed our stock status, but you won't see any transactions
showing that it did so." Auditor: "What did the fix program do?'".
Controller: "It adjusted for a bug in the database that causes it to not
calculate our OnHandQty correctly. It goes in and changes the OnHandQty if
they are wrong." Auditor: "Which parts did it change?" Controller: "We
don't know." Auditor: "O.K. so the bug is fixed now then, right?".
Controller: "No, the database can still cause OnHandQty's to be incorrect.
We're not sure when it happens or how often, or for how long it has been
happening." Auditor: "Do you know how to spell E-N-R-O-N? What has your
software company done about this, and when did you first know it existed?"
Controller: "We brought the problem to their attention over a year ago.
There has been no bug fix for it, nor is there any SCR written to fix it."
Auditor: "Why are you still using this software?" Controller: "Good
question."

Michael. Thanks for bringing this to our attention. And as I mentioned,
I would love to see how many Vantage Customers this is affecting and by how
many $$ dollars. I assume it could be hundreds of users if not 100% of the
Vantage userbase. I had assumed up until about a month ago that this bug
was fixed in 5.1, but I have verified in our current database that it is
not. I would have to assume it is still a problem in 5.2 as it has never
been addressed in a patch to this date (in addition to the fact that if your
OnHandQty's were off in 5.1 or any earlier version, those OnHandQty's would
be brought right into 5.2 as well.

Sorry for the long letter. I believe this issue is serious enough that
users should be aware and vigilant. Sometimes to be TOO brief is to invite
misunderstanding.

With much gravity,

Troy Funte
Liberty Electronics


----- Original Message -----
From: Michael Benedict
To: vantage@yahoogroups.com
Sent: Friday, January 17, 2003 10:04 AM
Subject: [Vantage] Inventory Not Updating Correctly


A part number was brought to my attention this morning that showed a
balance
of 289 onhand but there were actually zero. I went back and reviewed
the
Tran History on the part and noticed several instances where STK-MTL
transactions were not updating the inventory. The transactions appear,
but
the Running Total Column and it appears now the Inventory was not
updated
correctly. This problem appears to have occurred sporadically since we
installed Vantage 4.0 in 1999, we are now on 5.0. The problem only
occurs
on Purchased Parts and only for STK-MTL transactions. I pulled a few of
our
most frequently used materials up in part tracker and it occurs at some
point in all parts. There is no common link to the parts and a
transaction
performed less than one minute after and incorrect transaction will be
correct. Has anyone else had this issue before?

Thanks,

Michael Benedict
IS Manager
Crestview Aerospace Corp.


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]


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/

[system]

5.1 Troy

> -----Original Message-----
> From: Troy Funte [SMTP:tfunte@...]
> Sent: Monday, January 20, 2003 9:19 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Inventory Not Updating Correctly
>
> I wonder if those who respond by checking their stock status could also
> mention which version of Vantage they are running.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Troy Funte
> To: vantage@yahoogroups.com
> Sent: Saturday, January 18, 2003 12:27 AM
> Subject: Re: [Vantage] Inventory Not Updating Correctly
>
>
> We have had the very same SERIOUS issue. In fact, I have an open
> issue on this with Epicor now. We had the same problem in Vantage 3.0 and
> 5.0, we are now seeing it in 5.1 as well. It has caused major problems
> with the integrity of our Inventory. I still don't think Epicor knows how
> this happens exactly, although as you have discovered, it seems to be
> pinpointed to STK-MTL transactions not adjusting the OnHandQty correctly.
> You mention purchased parts only, but we have seen it with manufactured
> parts as well (both subassemblies and top level parts, which tells me that
> it may not be limited to the STK-MTL transaction type).
> For us the problem was serious enough that we had a meeting with
> Epicor on it over a year ago -- partly to say, "if you know of a problem
> like this, you should at least let user's know so that they can watch
> their inventory closer. And if we're having this problem, other users are
> probably having it as well". They have not acted on that suggestion to
> date. (This suggestion was to higher Epicor management, not Tech Support,
> by the way).
>
> I HAVE DISCOVED HOW TO SEE IF THIS PROBLEM EXISTS IN YOUR DATABASE BY
> RUNNING A TEST YOUR STOCK STATUS REPORT. AFTER YOU TRY THIS PROCEDURE, I
> WOULD BE LIKE TO HEAR FROM EVERYONE ON THE LIST WHO FINDS THIS PROBLEM --
> IT CAN BE *VERY SERIOUS* FROM A MATERIALS AND ACCOUNTING STANDPOINT.
>
> HERE'S WHAT YOU DO. Run the Stock Status report... but instead of using
> TODAY'S date, enter a date in the past that is far enough back to precede
> your earliest transaction in your database. It may take some time to run.
> 1/1/1970 is a good date since it is probably old enough to precede any
> installation of Vantage. Also, I'm not sure what logic Vantage uses for
> Date schemes, but if you enter a date like 1/1/50, it may give you 2050
> instead of 1950. Running the Stock Status for 1/1/70 should give you a
> ZERO dollar Stock Status report with ZERO parts in stock. If you find ANY
> parts listed (positive or negative), note the part(s) and I'll bet you a
> candy bar that your OnHandQty is wrong for that part(s). The reason this
> logic works is this: To find the OnHandQty for dates prior to today, the
> Stock Status assumes the current OnHandQty is correct TODAY, and then it
> goes through each transaction (PartTran) for a Part and subtracts/adds the
> quantity of that transaction to the current OnHandQty until it reaches the
> date you entered. It calculates backwards from today. Thus, back in 1970
> (at least from Vantage's perspective) the OnHandQty for every part should
> be ZERO. Now you can use the list of parts from the report to calculate
> the TRUE (calculated) OnHandQty. After you have printed/written the list
> of parts, open up PartTracker. Find one of the guilty parts that has the
> shortest transaction history. Next, go line by line through each
> transaction and manually calculate what the OnHandQty should be. If your
> transacton history is less that 50 transactions, you can do a quick check
> by scrolling to the end (bottom) of the transaction history to see if the
> first running total is correct. (I say less than 50 transactions because
> there is still a known issue with the running totals being inaccurate
> after more than 100 transactions. The issue used to involve anything over
> 50 transactions, so I don't trust either).
>
> Epicor sent us a fix program (fixbinsall.r) back last year to
> recalculate all the OnHandQty's. The problem was, after it fixed our
> OnHandQty's, our Stock Status changed by significant $$ dollars.
> Additionally, any parts that were previously affected by this bug, and
> which also had a Cylce Count done on them to correct the OnHandQty through
> a ADJ-QTY, these parts are now OFF again by the amount of the ADJ-QTY. So
> even after running the 'fixbinsall.r' program, we weren't sure if our
> OnHandQty was right or not. We ended up doing a complete Inventory Count
> on all 10,000+ parts in our inventory to clarify the integrity our Stock
> Status. And now to find out that the problem is still there is incredibly
> disconcerting. In these days of Enron scandals, this type of thing makes
> our Controller VERY nervous and our auditors VERY suspicious. Auditor:
> "Why did your stock status change by thousands of dollars, but we don't
> see it in your Cost of Sales or anywhere else for that matter?"
> Controller: "Well, we ran this fix program on our database and it changed
> our stock status, but you won't see any transactions showing that it did
> so." Auditor: "What did the fix program do?'". Controller: "It adjusted
> for a bug in the database that causes it to not calculate our OnHandQty
> correctly. It goes in and changes the OnHandQty if they are wrong."
> Auditor: "Which parts did it change?" Controller: "We don't know."
> Auditor: "O.K. so the bug is fixed now then, right?". Controller: "No,
> the database can still cause OnHandQty's to be incorrect. We're not sure
> when it happens or how often, or for how long it has been happening."
> Auditor: "Do you know how to spell E-N-R-O-N? What has your software
> company done about this, and when did you first know it existed?"
> Controller: "We brought the problem to their attention over a year ago.
> There has been no bug fix for it, nor is there any SCR written to fix it."
> Auditor: "Why are you still using this software?" Controller: "Good
> question."
>
> Michael. Thanks for bringing this to our attention. And as I
> mentioned, I would love to see how many Vantage Customers this is
> affecting and by how many $$ dollars. I assume it could be hundreds of
> users if not 100% of the Vantage userbase. I had assumed up until about a
> month ago that this bug was fixed in 5.1, but I have verified in our
> current database that it is not. I would have to assume it is still a
> problem in 5.2 as it has never been addressed in a patch to this date (in
> addition to the fact that if your OnHandQty's were off in 5.1 or any
> earlier version, those OnHandQty's would be brought right into 5.2 as
> well.
>
> Sorry for the long letter. I believe this issue is serious enough that
> users should be aware and vigilant. Sometimes to be TOO brief is to
> invite misunderstanding.
>
> With much gravity,
>
> Troy Funte
> Liberty Electronics
>
>
> ----- Original Message -----
> From: Michael Benedict
> To: vantage@yahoogroups.com
> Sent: Friday, January 17, 2003 10:04 AM
> Subject: [Vantage] Inventory Not Updating Correctly
>
>
> A part number was brought to my attention this morning that showed a
> balance
> of 289 onhand but there were actually zero. I went back and reviewed
> the
> Tran History on the part and noticed several instances where STK-MTL
> transactions were not updating the inventory. The transactions
> appear, but
> the Running Total Column and it appears now the Inventory was not
> updated
> correctly. This problem appears to have occurred sporadically since
> we
> installed Vantage 4.0 in 1999, we are now on 5.0. The problem only
> occurs
> on Purchased Parts and only for STK-MTL transactions. I pulled a few
> of our
> most frequently used materials up in part tracker and it occurs at
> some
> point in all parts. There is no common link to the parts and a
> transaction
> performed less than one minute after and incorrect transaction will be
> correct. Has anyone else had this issue before?
>
> Thanks,
>
> Michael Benedict
> IS Manager
> Crestview Aerospace Corp.
>
>
> 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]
>
>
> 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/
>