Hi Greg,
Sorry I can't help you with a 4.0 report, but I would love to see your 'pretty good' reports for version 3.0. I just spent countless hours on a Crystal version of a report to look at 'no transaction activity since ??/??/??'. Do you have such a thing?
Troy Funte
Liberty Electronics
Sorry I can't help you with a 4.0 report, but I would love to see your 'pretty good' reports for version 3.0. I just spent countless hours on a Crystal version of a report to look at 'no transaction activity since ??/??/??'. Do you have such a thing?
Troy Funte
Liberty Electronics
----- Original Message -----
From: Greg Clauser
To: 'vantage@egroups.com'
Sent: Wednesday, December 06, 2000 2:31 PM
Subject: [Vantage] Obsolete &/or Slow Moving Inventory report
Anyone got a report that shows something like parts in stock with no
allocations or parts in stock with no transaction activity since ??/??/??.
I have some that were pretty good for version 3.0 but the AllocQty field has
moved in version 4.0. Actually, it looks like it's contained in the
PartPlant table as well as the PartWhse table.
I ended up screwing up a perfectly good report by trying to link the
PartPlant table and creating a calculated field that adds the two AllocQty
fields together. I'm sure I did the join wrong or something. (It sure
would have been nice to have a document from Epicor that showed where all
the newly "obsolete" fields in 4.0 are to be found.)
Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>
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]