Crystal - Available Stock Report

Yahoo Archive
1
Jill,
The stock status report on http://www.egroups.com/files/vantage/
aggregates multiple bins. It also does some other stuff that you probably don't want, but you can chop off the extras. It goes along the lines of Warren's suggestion. If nothing else, maybe it will give you an example to copy from to get the part quantities totaling across lots.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Jill Seath
To: 'vantage@egroups.com'
Sent: Monday, January 08, 2001 1:18 PM
Subject: [Vantage] Crystal - Available Stock Report


I've created a report in Crystal Version 8.0 which lists the On Hand,
Allocated and Available Quantities for all stocked Parts.
It works fine until there is a Part with stock split over several Lot
No.s. The report is printing the correct allocated quantity. However the
On Hand Qty is the Qty of just one Lot rather than a total of all the
Lots. Can anybody point me in the right direction to rectify this?
Thanks in advance
Sophie




eGroups Sponsor

Click here for Business information

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]
2
I've created a report in Crystal Version 8.0 which lists the On Hand,
Allocated and Available Quantities for all stocked Parts.
It works fine until there is a Part with stock split over several Lot
No.s. The report is printing the correct allocated quantity. However the
On Hand Qty is the Qty of just one Lot rather than a total of all the
Lots. Can anybody point me in the right direction to rectify this?
Thanks in advance
Sophie
3
Sophie;



Insert a Group on part number, do a summary total on the quantities on hand
from each lot and print the rest of the detail on that group total line. You
can hide the group header and detail lines which will then give you what
appears as a single line detail report.



If you need more help feel free to contact me off line.



Warren R. Eddy

Information Services Manager

National Tube Form, LLC

An Excaliber Company

e-mail - Warren.Eddy@...

phone - 219 478-2363 ext 217

fax - 219 478-1043







-----Original Message-----
From: Jill Seath [mailto:JillSeath@...]
Sent: Monday, January 08, 2001 1:19 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Crystal - Available Stock Report


I've created a report in Crystal Version 8.0 which lists the On Hand,

Allocated and Available Quantities for all stocked Parts.

It works fine until there is a Part with stock split over several Lot

No.s. The report is printing the correct allocated quantity. However the

On Hand Qty is the Qty of just one Lot rather than a total of all the

Lots. Can anybody point me in the right direction to rectify this?

Thanks in advance

Sophie









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