Inventory Tags - UOM

Yahoo Archive
1
At 05:58 PM 1/12/2004, you wrote:
>We are on Vantage 4.0 and have crystal reports 7.0. We would like an
>inventory tag report that prints the unit of measure on the tag. PLEASE
>Help!!!!

Man, how aggravating. I always had enough trouble getting our
inventory-takers to record the count in the correct UOM, even when it WAS
on the tag! Then we migrated to Vantage and it wasn't there at all.

Your best bet, if you have ODBC configured on your server and you're handy
with Crystal is to retrieve it directly from the Part table.

Back when I first ran into this, ODBC wasn't working. My round-about
solution was:
* Use Vantage export utility to crate Excel file of PartNum and IUM.
* Open in Excel and save-as DBase format.
* Open DBase file in Access and create index on PartNum.
* Modify Crystal tag form to link to DBase file for UOM.

I can probably scrounge that up if you'd like; but the ODBC route is a
bunch less kludgy.

So has Epicor ever added UOM to the tags, or at least made it available in
the export file?

-Wayne Cox
Twenty Three - Information Technology Consulting
828-685-2338



[Non-text portions of this message have been removed]
2
We are on Vantage 4.0 and have crystal reports 7.0. We would like
and inventory tag report that prints the unit of measure on the tag.
PLEASE Help!!!!

Russ Silvey
Wisdom Industries, Ltd.