Onhand and Allocated Qty report

Greg,

On hand qty is part of the partbin table. But you have to make sure that if
you want to see all the parts that are on hand that you are grouping by
part#. If there are multiple bins with that part# your records will be
duplicated if you don't. The allocated qty is going to be found in the
partwhse table. HTH.

Jim Frice

> -----Original Message-----
> From: Greg Gillette [mailto:ggillette@...]
> Sent: Tuesday, March 20, 2001 7:50 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Onhand and Allocated Qty report
>
>
> Has anyone tried to write a report to show part #, on-hand qty, and
> allocated qty? I am trying to think of a way to come up with this
> information but have yet to come up with anything.
>
> Thank you.
> Greg
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must
> have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
Has anyone tried to write a report to show part #, on-hand qty, and
allocated qty? I am trying to think of a way to come up with this
information but have yet to come up with anything.

Thank you.
Greg
I have a report that kind of does it in Crystal 7.0, and then I still have
to finess it in Excel for 20 minutes to make it look right. It is so
complicated because it has to do with trying to find the last ship date for
all bins. If you want to look at it, even though it is a loot more
complicated then what you asked for please e-mail me directly (not via list
serv) and I will send it to you.

Oleg Tumarkin

-----Original Message-----
From: Greg Gillette [SMTP:ggillette@...]
Sent: Tuesday, March 20, 2001 7:50 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Onhand and Allocated Qty report

Has anyone tried to write a report to show part #, on-hand qty, and
allocated qty? I am trying to think of a way to come up with this
information but have yet to come up with anything.

Thank you.
Greg


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/