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