Fw: ignore--tying auditor physical inventory test counts in

Yahoo Archive
1
You can run a report from Crystal and sort the tags by part number, etc.

I am on 5.0 and I run a Report Builder report to use count sheets instead of
tags. All the data is there for you to use.

Creating a custom report will be a lot easier than the count variance report
IMHO.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com
-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Tuesday, February 24, 2004 3:36 PM
To: Vantage@yahoogroups.com
Subject: [Vantage] FW: IGNORE--TYING AUDITOR PHYSICAL INVENTORY TEST
COUNTS IN


Our IT department did some searching and found if you run the Count
Variance Report and set your variances to 0, that will work.

Thanks!

Rick Ludwig



-----Original Message-----
From: Ludwig, Rick [mailto:rickl@...]
Sent: Tuesday, February 24, 2004 3:34 PM
To: 'Vantage@yahoogroups.com'
Subject: TYING AUDITOR PHYSICAL INVENTORY TEST COUNTS IN


I find this hard to believe that this question has not been asked
before...

For all you accountants out there, you know that a simple test all
auditors do is perform test counts during a physical inventory. How do
your auditors tie these in using Vantage (assuming you used Vantage's
"Count Entry" function)?

For us, this is the first year we fully used Vantage "Count Entry" for
Finished Goods and the 3rd year for Raw Materials, EXCEPT in the past,
our raw materials manager always kept a separate Excel spreadsheet to
track tags. We did not keep a separate Excel spreadsheet this year (why
should we, it's a duplication of what Vantage can do - or maybe not!)
and our auditors are looking for a way to tie in their test counts. We
are on 6.1 and the only ways you can sort the "Count Entry" batch is by
Tag Number and by Warehouse (NOT Part Number). As it appears, the only
way for them to do this is to manually search for all tags related to
the same part number and write down the tag numbers/quantities
associated with a given part number in order to ensure their count made
it into the final quantity. Does anyone know a better solution?
Obviously, a simple fix for this is to add a third sort option (Part
Number) to the Count Entry-Count Group.

Thanks in Advance!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327




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

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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



[Non-text portions of this message have been removed]
2
Our IT department did some searching and found if you run the Count
Variance Report and set your variances to 0, that will work.

Thanks!

Rick Ludwig



-----Original Message-----
From: Ludwig, Rick [mailto:rickl@...]
Sent: Tuesday, February 24, 2004 3:34 PM
To: 'Vantage@yahoogroups.com'
Subject: TYING AUDITOR PHYSICAL INVENTORY TEST COUNTS IN


I find this hard to believe that this question has not been asked
before...

For all you accountants out there, you know that a simple test all
auditors do is perform test counts during a physical inventory. How do
your auditors tie these in using Vantage (assuming you used Vantage's
"Count Entry" function)?

For us, this is the first year we fully used Vantage "Count Entry" for
Finished Goods and the 3rd year for Raw Materials, EXCEPT in the past,
our raw materials manager always kept a separate Excel spreadsheet to
track tags. We did not keep a separate Excel spreadsheet this year (why
should we, it's a duplication of what Vantage can do - or maybe not!)
and our auditors are looking for a way to tie in their test counts. We
are on 6.1 and the only ways you can sort the "Count Entry" batch is by
Tag Number and by Warehouse (NOT Part Number). As it appears, the only
way for them to do this is to manually search for all tags related to
the same part number and write down the tag numbers/quantities
associated with a given part number in order to ensure their count made
it into the final quantity. Does anyone know a better solution?
Obviously, a simple fix for this is to add a third sort option (Part
Number) to the Count Entry-Count Group.

Thanks in Advance!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327