5.20.305 & None here either, but then we don't have (and never have had) Finished Goods inventory of any sort. But a big project for 2003 is to investigate making to stock. Maybe we should back burner that project until this has been fixed. Thanks for the heads-up.
-Todd C.
-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Monday, January 20, 2003 1:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory not updating...
No parts on my stock status report either.
Version 5.1.
Kim Trapp
Hawk Technology Ltd
309-787-6200 ext 221
www.hawktechnology.com
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, January 20, 2003 9:58 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory not updating...
A couple notes about this problem.
* If you have more than 100 transactions in Part Tracker "Transaction History", your first (oldest) entry may show an incorrect RUNNING TOTAL even if your OnHandQty is correct. This is a separate 'BUG' that involves the Running Total. Even parts with a correct OnHandQty may show the Running Total incorrectly after the 100th transaction.
* The Stock Status report, run on 1/1/70 is the most sure way to identify WHICH parts are affected by the incorrect OnHandQty calculation. However, this doesn't explain WHEN or HOW the OnHandQty became inaccurate.
* Although at our company have traced the STK-MTL as being highly suspect, it may not be the only type of transaction that 'ignors' the OnHandQty calculation. The reason I say this is that we have a Top Level (Manufactured) Part that has an incorrect Calculated OnHandQty. This type of part does not have any STK-MTL transactions.
* It's difficult to track WHEN the incorrect calculation happens because once the OnHandQty is incorrect, it will change the running totals for the whole history of the part. This is because Part Tracker calculates the Running Totals by starting with the current OnHandQty (it assumes this is correct), and adjusts the Running Total as it goes backwards in time.
* There is a 'fix' that Epicor wrote for us that recalculates the OnHandQty for every part in the database. The good part of the fix is that it cleans up the Stock Status report. The three bad parts of the 'fix' is that it 1) doesn't fix the bug, 2) makes no Journal Entries to show why your inventory valuation changed, 3) will make any Cycle Counts or Inventory Adjustments that you made in the past go 'backwards'. This third problem causes more headaches because you have to identify which parts you have adjusted and then decide what to do with those. (ie. Readjust the adjustment, or do another cycle count). We ended up doing a complete inventory count last year after this problem, simply because we couldn't trust any of the numbers in Vantage.
We are working with Epicor Tech support to try to pinpoint what series of events in Vantage cause this problem to occur. If anyone has any further clues, they would be greatly appreciated. I suggest that if you have verified the problem in your database, that you call Epicor to log a call on this issue. Our current call is 832607MPS, Liberty Electronics. You will have to decide, depending on your circumstances, how you would apply the fix that may be provided. Don't just run the fix and call it good. There may be other implications.
Troy Funte
Liberty Electronics
-Todd C.
-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Monday, January 20, 2003 1:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory not updating...
No parts on my stock status report either.
Version 5.1.
Kim Trapp
Hawk Technology Ltd
309-787-6200 ext 221
www.hawktechnology.com
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, January 20, 2003 9:58 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory not updating...
A couple notes about this problem.
* If you have more than 100 transactions in Part Tracker "Transaction History", your first (oldest) entry may show an incorrect RUNNING TOTAL even if your OnHandQty is correct. This is a separate 'BUG' that involves the Running Total. Even parts with a correct OnHandQty may show the Running Total incorrectly after the 100th transaction.
* The Stock Status report, run on 1/1/70 is the most sure way to identify WHICH parts are affected by the incorrect OnHandQty calculation. However, this doesn't explain WHEN or HOW the OnHandQty became inaccurate.
* Although at our company have traced the STK-MTL as being highly suspect, it may not be the only type of transaction that 'ignors' the OnHandQty calculation. The reason I say this is that we have a Top Level (Manufactured) Part that has an incorrect Calculated OnHandQty. This type of part does not have any STK-MTL transactions.
* It's difficult to track WHEN the incorrect calculation happens because once the OnHandQty is incorrect, it will change the running totals for the whole history of the part. This is because Part Tracker calculates the Running Totals by starting with the current OnHandQty (it assumes this is correct), and adjusts the Running Total as it goes backwards in time.
* There is a 'fix' that Epicor wrote for us that recalculates the OnHandQty for every part in the database. The good part of the fix is that it cleans up the Stock Status report. The three bad parts of the 'fix' is that it 1) doesn't fix the bug, 2) makes no Journal Entries to show why your inventory valuation changed, 3) will make any Cycle Counts or Inventory Adjustments that you made in the past go 'backwards'. This third problem causes more headaches because you have to identify which parts you have adjusted and then decide what to do with those. (ie. Readjust the adjustment, or do another cycle count). We ended up doing a complete inventory count last year after this problem, simply because we couldn't trust any of the numbers in Vantage.
We are working with Epicor Tech support to try to pinpoint what series of events in Vantage cause this problem to occur. If anyone has any further clues, they would be greatly appreciated. I suggest that if you have verified the problem in your database, that you call Epicor to log a call on this issue. Our current call is 832607MPS, Liberty Electronics. You will have to decide, depending on your circumstances, how you would apply the fix that may be provided. Don't just run the fix and call it good. There may be other implications.
Troy Funte
Liberty Electronics
----- Original Message -----
From: karenrohe <krohe@...>
To: vantage@yahoogroups.com
Sent: Monday, January 20, 2003 9:45 AM
Subject: [Vantage] Inventory not updating...
We began using Vantage (currently 5.1.130) on September 1, 2002.
I have 1 part on my Stock Status if I run it as of 01/01/1970. And
it's NEGATIVE as of that date!
You can clearly see in my transaction history that on 9/1/02 we ADJ-
QTY in for beginning balances of +617 pieces (+11 into our warehouse,
and +606 into a non-nettable bin), and immediately my on-hand Running
Total is -1,609! My stock status at 1/1/70 is -1,620! For us, this
is almost $20k worth of inventory.
I am outraged that Epicor has not addressed this issue
satisfactorily, and also that they have not published any
documentation warning us of this error.
This could help explain our larger-than-normal book-to-physical
adjustment at year end.
Troy, what's our next step with Epicor?
Karen Rohe
Controller
Nationwide Precision Products Corp.
Rochester, NY
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
< http://rd.yahoo.com/M=241773.2861420.4212388.1925585/D=egroupweb/S=1705007183:HM/A=1394044/R=0/*http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802,FF.html> HGTV Dream Home Giveaway
< http://us.adserver.yahoo.com/l?M=241773.2861420.4212388.1925585/D=egroupmail/S=:HM/A=1394044/rand=971685862>
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 < http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=241773.2861420.4212388.1925585/D=egroupweb/S=1705007183:HM/A=1394044/R=0/*http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802,FF.html> HGTV Dream Home Giveaway
<http://us.adserver.yahoo.com/l?M=241773.2861420.4212388.1925585/D=egroupmail/S=:HM/A=1394044/rand=883428492>
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 <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]