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