Inventory

We are on 3.0 and use average costing. Purchased part to inventory
from old vendor priced over double of new vendor. No open purchase
orders for old vendor, however, parts are being rejected from stock.
What is the best way to remove the parts from inventory without
destroying your costing?
Jeni,

If these parts were received from one of your purchase orders, then go into
the Vender Return Mgmt. module, General operations, Reject received
material.
If my memory serves me correctly once you have done this, the material will
show up in the DMR processing and then you can reject it. Hope this is what
you were asking for or helps!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


-----Original Message-----
From: jeni.wilson@... [mailto:jeni.wilson@...]
Sent: Friday, November 03, 2000 6:21 AM
To: vantage@egroups.com
Subject: [Vantage] Inventory


We are on 3.0 and use average costing. Purchased part to inventory
from old vendor priced over double of new vendor. No open purchase
orders for old vendor, however, parts are being rejected from stock.
What is the best way to remove the parts from inventory without
destroying your costing?



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Thank you for responding but, we have tried that. You can put the
correct costs on the debit memo, but the parts come out of inventory
at the new price, not the old one. Wouldn't be such a big deal if
there wasn't such a big difference in the cost.

Only solution we can think of is changing the inventory costs,
adjusting the quantity and then change the costs back again. Hate to
do this but might have to just to get them out of inventory. No
wonder I can't get a stock status and a GL acct to balance.

Thanks for your input.

Jeni Wilson
Boyer Machine


--- In vantage@egroups.com, "Kimberly Maxwell"
<kimberly.maxwell@w...> wrote:
> Jeni,
>
> If these parts were received from one of your purchase orders, then
go into
> the Vender Return Mgmt. module, General operations, Reject received
> material.
> If my memory serves me correctly once you have done this, the
material will
> show up in the DMR processing and then you can reject it. Hope
this is what
> you were asking for or helps!
>
> Kimberly Maxwell
> Westwood Precision, Inc.
> PH: 425-347-1303 Ext. 41
> Fax: 425-353-8945
> email: kimberly.maxwell@w...
> www.westwoodprecision.com
>
>
> -----Original Message-----
> From: jeni.wilson@b... [mailto:jeni.wilson@b...]
> Sent: Friday, November 03, 2000 6:21 AM
> To: vantage@egroups.com
> Subject: [Vantage] Inventory
>
>
> We are on 3.0 and use average costing. Purchased part to inventory
> from old vendor priced over double of new vendor. No open purchase
> orders for old vendor, however, parts are being rejected from stock.
> What is the best way to remove the parts from inventory without
> destroying your costing?
>
>
>
> We no longer allow attachments to files. To access/share Report
Files,
> please go to the following link:
http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try
it, go to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the
link above
> will work the next time you try it.)
Jeni,
That's what we would end up doing also. Sorry I couldn't help with a better
plan! I hate doing adjustments also!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


-----Original Message-----
From: jeni.wilson@... [mailto:jeni.wilson@...]
Sent: Friday, November 03, 2000 12:26 PM
To: vantage@egroups.com
Subject: [Vantage] Re: Inventory


Thank you for responding but, we have tried that. You can put the
correct costs on the debit memo, but the parts come out of inventory
at the new price, not the old one. Wouldn't be such a big deal if
there wasn't such a big difference in the cost.

Only solution we can think of is changing the inventory costs,
adjusting the quantity and then change the costs back again. Hate to
do this but might have to just to get them out of inventory. No
wonder I can't get a stock status and a GL acct to balance.

Thanks for your input.

Jeni Wilson
Boyer Machine


--- In vantage@egroups.com, "Kimberly Maxwell"
<kimberly.maxwell@w...> wrote:
> Jeni,
>
> If these parts were received from one of your purchase orders, then
go into
> the Vender Return Mgmt. module, General operations, Reject received
> material.
> If my memory serves me correctly once you have done this, the
material will
> show up in the DMR processing and then you can reject it. Hope
this is what
> you were asking for or helps!
>
> Kimberly Maxwell
> Westwood Precision, Inc.
> PH: 425-347-1303 Ext. 41
> Fax: 425-353-8945
> email: kimberly.maxwell@w...
> www.westwoodprecision.com
>
>
> -----Original Message-----
> From: jeni.wilson@b... [mailto:jeni.wilson@b...]
> Sent: Friday, November 03, 2000 6:21 AM
> To: vantage@egroups.com
> Subject: [Vantage] Inventory
>
>
> We are on 3.0 and use average costing. Purchased part to inventory
> from old vendor priced over double of new vendor. No open purchase
> orders for old vendor, however, parts are being rejected from stock.
> What is the best way to remove the parts from inventory without
> destroying your costing?
>
>
>
> We no longer allow attachments to files. To access/share Report
Files,
> please go to the following link:
http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try
it, go to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the
link above
> will work the next time you try it.)



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we are
finding that the
changes are not reflected in the transaction histories of the part number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0
Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we are
finding that the
changes are not reflected in the transaction histories of the part number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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]
Sorry, the version and patch level are:

5.00.332

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 12:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we
are
finding that the
changes are not reflected in the transaction histories of the part number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038862678828962?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=925169979>

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

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




[Non-text portions of this message have been removed]
Pablo,
If you run your Stock Status as of: 01/01/70 (or some date that precedes any of your transactions) what number do you get for a total? Don't include zero balances unless you want a really LONG report.

If the sum total is any number other than ZERO, you could be a victim of inaccurate Inventory transactions. This may especially be true if you lived on Vantage 3.0 for awhile.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 4:05 PM
Subject: RE: [Vantage] Inventory


Sorry, the version and patch level are:

5.00.332

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 12:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we
are
finding that the
changes are not reflected in the transaction histories of the part number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038862678828962?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=925169979>

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

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




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


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]
Troy et al.,

Very interesting. I took your suggestion and ran the stock status report as
of 01/01/70 and have about 40 parts with non-zero quantities and costs.
Since our current on hand qty's are correct, I assume that the stock status
report is based on a backwards calculation using inventory transaction
totals from the current on hand. Can anyone confirm this? If so, I'm
guessing the problem lies with Vantage including some transactions in the
backwards calculation that it shouldn't. Is there a Database Conversion
utility that corrects this? Are there any other ramifications to this? Any
information would be much appreciated!

Todd Gilbert
Altair Technologies, Inc.
Vantage 5.10.130

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 3:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Pablo,
If you run your Stock Status as of: 01/01/70 (or some date that precedes
any of your transactions) what number do you get for a total? Don't include
zero balances unless you want a really LONG report.

If the sum total is any number other than ZERO, you could be a victim of
inaccurate Inventory transactions. This may especially be true if you lived
on Vantage 3.0 for awhile.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 4:05 PM
Subject: RE: [Vantage] Inventory


Sorry, the version and patch level are:

5.00.332

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 12:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we
are
finding that the
changes are not reflected in the transaction histories of the part
number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
>
83:HM/A=1267611/R=0/*
http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
<http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=>
300x250;ord=1038862678828962?>

<
http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
>
l/S=:HM/A=1267611/rand=925169979>

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

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




[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038871931006884?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=750396592>

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

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




[Non-text portions of this message have been removed]
Todd,
Your assumption is correct. Running the Stock Status to a backward date causes a 'reverse calculation' to occur. It's probably not the Stock Status calculations that are wrong, but the fact that at some point in history Vantage didn't add or subtrack a PartTran transaction correctly. This is a likely occurrence in Vantage 3.0, and possible up through 5.0.

I would encourage you, although this may be quite a mundane process, to take one of the parts on your SS report you just ran, and manually calculate the PartTran transactions. (pick a part with the shortest list of transactions).

I wrote a Crystal report that can do it, which sped the process up for me.

Is there a fix? You would probably want to contact Epicor to ask that question. The pro's of fixing the problem here is that you would have an accurate Transaction History for each part, and also it would correct any errors in your OnHandQty's due to those calculations. The con's of fixing it are: If you have every QtyAdjusted your OnHandQty's, then the fix program will 'undo' the adjustment when it fixes the PartTrans, but the QtyAdjustment will then skew the totals the other way -- thus you will have incorrect OnHandQty's as a result. You have to assess your damage and go from there.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Gilbert
To: 'vantage@yahoogroups.com'
Sent: Tuesday, December 03, 2002 8:40 AM
Subject: RE: [Vantage] Inventory


Troy et al.,

Very interesting. I took your suggestion and ran the stock status report as
of 01/01/70 and have about 40 parts with non-zero quantities and costs.
Since our current on hand qty's are correct, I assume that the stock status
report is based on a backwards calculation using inventory transaction
totals from the current on hand. Can anyone confirm this? If so, I'm
guessing the problem lies with Vantage including some transactions in the
backwards calculation that it shouldn't. Is there a Database Conversion
utility that corrects this? Are there any other ramifications to this? Any
information would be much appreciated!

Todd Gilbert
Altair Technologies, Inc.
Vantage 5.10.130

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 3:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Pablo,
If you run your Stock Status as of: 01/01/70 (or some date that precedes
any of your transactions) what number do you get for a total? Don't include
zero balances unless you want a really LONG report.

If the sum total is any number other than ZERO, you could be a victim of
inaccurate Inventory transactions. This may especially be true if you lived
on Vantage 3.0 for awhile.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 4:05 PM
Subject: RE: [Vantage] Inventory


Sorry, the version and patch level are:

5.00.332

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 12:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we
are
finding that the
changes are not reflected in the transaction histories of the part
number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
>
83:HM/A=1267611/R=0/*
http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
<http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=>
300x250;ord=1038862678828962?>

<
http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
>
l/S=:HM/A=1267611/rand=925169979>

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

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




[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038871931006884?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=750396592>

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

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




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


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]
It's also possible that someone dated a packing slip incorrectly and it
wasn't caught by the invoice person--we have one transaction dated 2010 in
our records. Of course, once it's posted, you're out of luck.

Lydia


-----Original Message-----
From: Todd Gilbert [mailto:todd@...]
Sent: Tuesday, December 03, 2002 8:41 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Inventory


Troy et al.,

Very interesting. I took your suggestion and ran the stock status report as
of 01/01/70 and have about 40 parts with non-zero quantities and costs.
Since our current on hand qty's are correct, I assume that the stock status
report is based on a backwards calculation using inventory transaction
totals from the current on hand. Can anyone confirm this? If so, I'm
guessing the problem lies with Vantage including some transactions in the
backwards calculation that it shouldn't. Is there a Database Conversion
utility that corrects this? Are there any other ramifications to this? Any
information would be much appreciated!

Todd Gilbert
Altair Technologies, Inc.
Vantage 5.10.130

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 3:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Pablo,
If you run your Stock Status as of: 01/01/70 (or some date that precedes
any of your transactions) what number do you get for a total? Don't include
zero balances unless you want a really LONG report.

If the sum total is any number other than ZERO, you could be a victim of
inaccurate Inventory transactions. This may especially be true if you lived
on Vantage 3.0 for awhile.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 4:05 PM
Subject: RE: [Vantage] Inventory


Sorry, the version and patch level are:

5.00.332

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 02, 2002 12:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Inventory


Which version/patch of Vantage?

Troy Funte
Liberty Electronics


----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 3:35 PM
Subject: [Vantage] Inventory


We are in the process of cycle counting and adjusting our inventory.
After making the count adjustment in the Quantity Adjustment Module, we
are
finding that the
changes are not reflected in the transaction histories of the part
number.

The changes are also not in the stock status report.

This has never been an issue; does anyone have any ideas??




Best Regards,

Pablo Garza

Vantage 5.0

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
>
83:HM/A=1267611/R=0/*
http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
<http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=>
300x250;ord=1038862678828962?>

<
http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
>
l/S=:HM/A=1267611/rand=925169979>

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

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




[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

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


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038871931006884?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=750396592>

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

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




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



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/
Good morning,

My materials planner asked if there was a simplified RB report available
that
details part number, on hand qty, and basic time phased information.

There is a very extensive report that comes standard with 5.2, but we are
looking for something
that can provide broad information at a glance.

I would appreciate any input from the group.



Best Regards,

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




[Non-text portions of this message have been removed]
I need to know how many pounds I have in beginning inventory of Raw
Material for each month. Using Vantage 6.1
Does Vantage have something that can get me this or anyone have a
crystal report or progress code?


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