Stock Status Report

Yahoo Archive
1
Hello ,
I was wondering if someone had a report they would be willing to share
like the canned "stock status" report that I could either change the
sort in Report Builder or be able to pull into Excel so I could sort it
based on descending dollar value.


Thanks
2
My CFO is pretty unhappy with the Stock Status Report at this point and I'm
trying to make things work they way (I think) that they are supposed to.
The problems occur when I want the inventory as of a date in the past (say
as of Oct 31, 2000) but I run the report today.

Problem #1: If I had inventory on-hand for part XYZ on 10/31/2000, but I
don't have any on-hand today, then the report skips that part if I choose
the option to exclude parts with zero quantities. This is a logic error
caused by the fact that the report checks for zero quantity *before* it
backs out transactions since the as-of date. Epicor has been aware of this
problem for more than a year and still has done nothing to fix it. Its a
problem in both version 3 and 4. Fortunately for me, my company has the
source code and we can fix this one ourselves - just thought you might be
interested in knowing about it especially if you want to call support and
add your company to the list to get it fixed faster (reference call number
629813MPS).

Problem #2: We use average costing for our inventory. The problem is that a
report run today will be different from the same report run two months ago
because the average costs have changed since that time. Since Vantage can't
determine what the average cost was on 10/31/2000 it is apparently using
today's average cost. This doesn't make any sense to me (or the CFO); am I
missing something here?? I am very interested to know how other companies
are handling this issue.

Thanks.
================
Steve Sanders
Delta Centrifugal Corp.
3
I would be interested too in knowing how other companies handle the Stock Status Report also.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Steve Sanders
To: vantage@egroups.com
Sent: Friday, December 08, 2000 11:51 AM
Subject: [Vantage] Stock Status Report


My CFO is pretty unhappy with the Stock Status Report at this point and I'm
trying to make things work they way (I think) that they are supposed to.
The problems occur when I want the inventory as of a date in the past (say
as of Oct 31, 2000) but I run the report today.

Problem #1: If I had inventory on-hand for part XYZ on 10/31/2000, but I
don't have any on-hand today, then the report skips that part if I choose
the option to exclude parts with zero quantities. This is a logic error
caused by the fact that the report checks for zero quantity *before* it
backs out transactions since the as-of date. Epicor has been aware of this
problem for more than a year and still has done nothing to fix it. Its a
problem in both version 3 and 4. Fortunately for me, my company has the
source code and we can fix this one ourselves - just thought you might be
interested in knowing about it especially if you want to call support and
add your company to the list to get it fixed faster (reference call number
629813MPS).

Problem #2: We use average costing for our inventory. The problem is that a
report run today will be different from the same report run two months ago
because the average costs have changed since that time. Since Vantage can't
determine what the average cost was on 10/31/2000 it is apparently using
today's average cost. This doesn't make any sense to me (or the CFO); am I
missing something here?? I am very interested to know how other companies
are handling this issue.

Thanks.
================
Steve Sanders
Delta Centrifugal Corp.


eGroups Sponsor


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.)



[Non-text portions of this message have been removed]
4
Has anyone created a report that details the stock status on one
given date compared to another date and includes the difference of
onhand balances?
5
That sounds like quite an undertaking that would require a number of tools, such as Access, Excel, and possible Progress 4GL.

Troy Funte
Liberty Electronics

----- Original Message -----
From: rightster <twright@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 09, 2003 12:04 PM
Subject: [Vantage] Stock Status Report


Has anyone created a report that details the stock status on one
given date compared to another date and includes the difference of
onhand balances?


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]
6
That would be one hell of a report as it would have to go thru each part
and look at the current onhand and then go thru the PartTran and reverse
all the transactions (based upon trantype) that have occured since then
to come up with your #. A more simplistic approach would be to run a
stock status at month end and keep that information for statistical
purposes

Dan Tisone
IS / IT Consultant
dan.tisone@...
(949) 440-3685 x148
Cel (714) 227-4173




-----Original Message-----
From: rightster <twright@...> [mailto:twright@...]
Sent: Thursday, January 09, 2003 9:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status Report


Has anyone created a report that details the stock status on one
given date compared to another date and includes the difference of
onhand balances?


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]
7
Hello All,

We are having a problem with the stock status report.

The report is being run as of 12-31-02. When this exact report was run
early this morning, everything looked good. However, later in the day there
was a STK-ASM transaction for a certain part.

The part had a quantity of one in stock, and the entire quantity of one was
issued to the job. This transaction was the only transaction for the part
since last november.

Now when the same stock status report is run, as of 12-31-02, the part we
issued this morning does not show up in a stock status report dated today,
yesterday, or 12-31-02.

We're running vantage 3. Has any one had similar occurances?

Thaddeus Jacobs
IT Developer
Kinematic Automation, Inc.
mailto:tjacobs@...
8
Thad,

We are also on V3... The Stock Status setup screen has the "Exclude parts
with zero quantities" checked by default. This is interpreted as meaning
"don't include parts whose inventory is zero now!" Remove the check and you
should be fine.

Jim Stetter
IT Manager
Snow Filtration, a division of Reemay, Inc.
(513) 777-6200 ext 268
<mailto:jstetter@...> jstetter@...

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, February 11, 2003 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Stock Status Report


Hello All,

We are having a problem with the stock status report.

The report is being run as of 12-31-02. When this exact report was run
early this morning, everything looked good. However, later in the day there
was a STK-ASM transaction for a certain part.

The part had a quantity of one in stock, and the entire quantity of one was
issued to the job. This transaction was the only transaction for the part
since last november.

Now when the same stock status report is run, as of 12-31-02, the part we
issued this morning does not show up in a stock status report dated today,
yesterday, or 12-31-02.

We're running vantage 3. Has any one had similar occurances?

Thaddeus Jacobs
IT Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


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]
9
This check was removed, and nothing changed.

-----Original Message-----
From: Stetter, Jim [mailto:jstetter@...]
Sent: Tuesday, February 11, 2003 12:25 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Stock Status Report


Thad,

We are also on V3... The Stock Status setup screen has the "Exclude parts
with zero quantities" checked by default. This is interpreted as meaning
"don't include parts whose inventory is zero now!" Remove the check and you
should be fine.

Jim Stetter
IT Manager
Snow Filtration, a division of Reemay, Inc.
(513) 777-6200 ext 268
<mailto:jstetter@...> jstetter@...

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, February 11, 2003 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Stock Status Report


Hello All,

We are having a problem with the stock status report.

The report is being run as of 12-31-02. When this exact report was run
early this morning, everything looked good. However, later in the day there
was a STK-ASM transaction for a certain part.

The part had a quantity of one in stock, and the entire quantity of one was
issued to the job. This transaction was the only transaction for the part
since last november.

Now when the same stock status report is run, as of 12-31-02, the part we
issued this morning does not show up in a stock status report dated today,
yesterday, or 12-31-02.

We're running vantage 3. Has any one had similar occurances?

Thaddeus Jacobs
IT Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


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/
10
This was a major bug in the V3 Stock Status Report. If I remember the scenario correctly, once there were transactions dated AFTER your 'run as of' date AND these
transactions zeroed out your on hand quantity, the Stock Status Report did not include them on the report even though your 'run as of' date was dated prior to those
transactions.. Note that both criteria needed to be met to have the problem. Any transactions that did not zero out your on hand quantity did not affect the report.

When we were on V3, our procedure was to NOT enter any transactions for the new period until the old period Stock Status Report was correct. This was a major hassle.

The problem was fixed on either V4 or 5, but I don't remember which one. The Stock Status report is now a beautiful thing!

Marty Kuphall
Controller
Ultra Tool & Mfg., Inc.

Ph. 262-703-0455
Fx. 262-703-0468

marty.kuphall@...

Thad Jacobs wrote:

> Hello All,
>
> We are having a problem with the stock status report.
>
> The report is being run as of 12-31-02. When this exact report was run
> early this morning, everything looked good. However, later in the day there
> was a STK-ASM transaction for a certain part.
>
> The part had a quantity of one in stock, and the entire quantity of one was
> issued to the job. This transaction was the only transaction for the part
> since last november.
>
> Now when the same stock status report is run, as of 12-31-02, the part we
> issued this morning does not show up in a stock status report dated today,
> yesterday, or 12-31-02.
>
> We're running vantage 3. Has any one had similar occurances?
>
> Thaddeus Jacobs
> IT Developer
> Kinematic Automation, Inc.
> mailto:tjacobs@...
11
When you do the Stock Status "as of" in 5.0, the quantity is correct but the
average cost is wrong. Is this fixed in 5.1 or 5.2?

-----Original Message-----
From: Marty Kuphall [mailto:marty.kuphall@...]
Sent: Tuesday, February 11, 2003 2:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Stock Status Report


This was a major bug in the V3 Stock Status Report. If I remember the
scenario correctly, once there were transactions dated AFTER your 'run as
of' date AND these
transactions zeroed out your on hand quantity, the Stock Status Report did
not include them on the report even though your 'run as of' date was dated
prior to those
transactions.. Note that both criteria needed to be met to have the problem.
Any transactions that did not zero out your on hand quantity did not affect
the report.

When we were on V3, our procedure was to NOT enter any transactions for the
new period until the old period Stock Status Report was correct. This was a
major hassle.

The problem was fixed on either V4 or 5, but I don't remember which one. The
Stock Status report is now a beautiful thing!

Marty Kuphall
Controller
Ultra Tool & Mfg., Inc.

Ph. 262-703-0455
Fx. 262-703-0468

marty.kuphall@...

Thad Jacobs wrote:

> Hello All,
>
> We are having a problem with the stock status report.
>
> The report is being run as of 12-31-02. When this exact report was run
> early this morning, everything looked good. However, later in the day
there
> was a STK-ASM transaction for a certain part.
>
> The part had a quantity of one in stock, and the entire quantity of one
was
> issued to the job. This transaction was the only transaction for the
part
> since last november.
>
> Now when the same stock status report is run, as of 12-31-02, the part we
> issued this morning does not show up in a stock status report dated today,
> yesterday, or 12-31-02.
>
> We're running vantage 3. Has any one had similar occurances?
>
> Thaddeus Jacobs
> IT Developer
> Kinematic Automation, Inc.
> mailto:tjacobs@...


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/> .
12
That is a problem forever I believe -- the qties can be correct for whatever date you run the report but Vantage doesn't keep track of what the value was at that time. So you get the value as of the day it is ran. That is why you need to run the report at the end of your accounting period to get the actual amount that should be in your GL account number for the month.
Ed Zywiec <ed.zywiec@...> wrote: When you do the Stock Status "as of" in 5.0, the quantity is correct but the
average cost is wrong. Is this fixed in 5.1 or 5.2?




---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day

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

Anyone have ideas as to why some parts in the part master may not show up
on the Stock Status Report?

I know that items in an inspection warehouse or items that are in DMR
pending will not show. Any ideas on other reasons to look for?



Thanks in advance for your help.



Marilyn Fairchild

Systems Administrator

Pickwick Manufacturing Services







[Non-text portions of this message have been removed]
14
They may be in a non-nettable warehouse bin.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Wednesday, July 14, 2004 4:24 PM
To: 'Vantage (Vantage List)'
Subject: [Vantage] Stock Status Report


Hi,

Anyone have ideas as to why some parts in the part master may not show up
on the Stock Status Report?

I know that items in an inspection warehouse or items that are in DMR
pending will not show. Any ideas on other reasons to look for?



Thanks in advance for your help.



Marilyn Fairchild

Systems Administrator

Pickwick Manufacturing Services







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




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



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Wednesday, July 14, 2004 4:24 PM
To: 'Vantage (Vantage List)'
Subject: [Vantage] Stock Status Report


Hi,

Anyone have ideas as to why some parts in the part master may not show up
on the Stock Status Report?

I know that items in an inspection warehouse or items that are in DMR
pending will not show. Any ideas on other reasons to look for?



Thanks in advance for your help.



Marilyn Fairchild

Systems Administrator

Pickwick Manufacturing Services







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



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129toce2l/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1089923099/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=652418304>


_____

Yahoo! Groups Links


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


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


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



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

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

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



[Non-text portions of this message have been removed]
16
Thanks much - both played roles in the issue.



Marilyn



>are they marked non-stock or non-nettable location?






[Non-text portions of this message have been removed]
17
Can anyone help with the following problem?

What has happened when the Stock Status Report increased more than
both the WIP Recon/Inv report and the GL? (The change in WIP Inv/Recon
Report and the GL is exact.)

Strange problem, I know...Any help will be greatly appreciated.
18
Group



I am having the classic argument between accounting and material
control. Here is the situation. It is year-end inventory time. Our CFO, who
has very little knowledge of how vantage operates, wants to use the count
entry variance report to value our year-end inventory. I keep explaining to
him that the variance report is designed to show total value of the
difference between our physical on hand balances and vantage on hand
balances and the stock status report is the main tool to determine year end
value. My explanation has fallen on deaf ears. He also has a hard time
understanding that vantage locks in all on hand balances when starting the
physical inventory. Because we have a bloated inventory (7,432 lines) we
start inventory 3 weeks before the cut off and I only use personnel from the
stock room to conduct inventory. He would like us to wait about 5 days
before the cut off and use other individuals who are not familiar with our
part numbers, location, and counting procedures. Yes, they can be trained
but it still leaves us with a liability. So what I am looking for is another
company who is willing to share there inventory experiences, mainly how you
use the count variance report and the stock status report. We are using
vantage 6.00.525 and conduct yearly inventories. Thank you in advance.


Paul H. Smith


[Non-text portions of this message have been removed]
19
Stock status report and not the variance report.

I also agree to get "all hands" available to do the count in the fewest days
possible. Your cut-off issues will be minimized and your employees will
resent inventory much less.

Edward F. Fox, Jr. CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 * Fax 401-596-1050
www.maxsonautomatic.com



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul H. Smith
Sent: Thursday, June 02, 2005 9:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Year end inventory and the Stock Status Report


Group



I am having the classic argument between accounting and material
control. Here is the situation. It is year-end inventory time. Our CFO, who
has very little knowledge of how vantage operates, wants to use the count
entry variance report to value our year-end inventory. I keep explaining to
him that the variance report is designed to show total value of the
difference between our physical on hand balances and vantage on hand
balances and the stock status report is the main tool to determine year end
value. My explanation has fallen on deaf ears. He also has a hard time
understanding that vantage locks in all on hand balances when starting the
physical inventory. Because we have a bloated inventory (7,432 lines) we
start inventory 3 weeks before the cut off and I only use personnel from the
stock room to conduct inventory. He would like us to wait about 5 days
before the cut off and use other individuals who are not familiar with our
part numbers, location, and counting procedures. Yes, they can be trained
but it still leaves us with a liability. So what I am looking for is another
company who is willing to share there inventory experiences, mainly how you
use the count variance report and the stock status report. We are using
vantage 6.00.525 and conduct yearly inventories. Thank you in advance.


Paul H. Smith


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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
20
We use the variance report on for reconciliation. It is used to make sure
there was not a count error. Large variances should always be reconciled.
The stock status report is the value of the inventory. This should be used
to value the inventory after reconciliation of variances.
As far as counting, I have found it very difficult to get a good
count while production is running and material is being moved. I advise
using all available personnel to count and complete the physical inventory
as quickly as possible to minimize the time production is down. It is not
difficult to train people to count. Have detailed written physical
inventory procedures for everyone, and conduct pre-inventory meeting to
explain procedures to all. The variance report will show any counting
error.

Hope this helps.

Mike McGee

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul H. Smith
Sent: Thursday, June 02, 2005 8:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Year end inventory and the Stock Status Report

Group



I am having the classic argument between accounting and material
control. Here is the situation. It is year-end inventory time. Our CFO, who
has very little knowledge of how vantage operates, wants to use the count
entry variance report to value our year-end inventory. I keep explaining to
him that the variance report is designed to show total value of the
difference between our physical on hand balances and vantage on hand
balances and the stock status report is the main tool to determine year end
value. My explanation has fallen on deaf ears. He also has a hard time
understanding that vantage locks in all on hand balances when starting the
physical inventory. Because we have a bloated inventory (7,432 lines) we
start inventory 3 weeks before the cut off and I only use personnel from the
stock room to conduct inventory. He would like us to wait about 5 days
before the cut off and use other individuals who are not familiar with our
part numbers, location, and counting procedures. Yes, they can be trained
but it still leaves us with a liability. So what I am looking for is another
company who is willing to share there inventory experiences, mainly how you
use the count variance report and the stock status report. We are using
vantage 6.00.525 and conduct yearly inventories. Thank you in advance.


Paul H. Smith


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



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