The PartWhse table should do it...
--- In vantage@yahoogroups.com, RSN <rsnsfi@...> wrote:
>
> I was hoping to find parts allocated to all Jobs in one table and I
thought the PartAlloc table was it except it has no records/blank in
our database. I see a note in the data dictionary viewer on the table
definition:
> "Part Allocations. Contains records representing the Hard, Picking,
Staged allocation quantity against stock and jobs. Note: As of it's
introduction with the 5.1 release it only represents demands from
Sales Orders. Future plans are to include the Mfg demands.".
> Does anyone on the forum have suggestions/recommendations-which
tables (maybe JobMtl?) accurately reflects all allocations for a
Part? I'm trying to get the equivalent of the results of doing a Time
phased enquiry Balance on part in a Crystal report format for all of
our stocked parts to get an accurate reflection of inventory
projected for the next few months. The thought being that aking the
part on-hand qty from the PARTBIN table and subtracting the allocated
qty should give me the results that I was looking for. But I can't
seem to find an accurate up-to-date/realtime allocated qty stored in
one place.
> Thanks for any ideas on how to accomplish this in advance.
> RSN
>
>
>
>
______________________________________________________________________
______________
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket:
mail, news, photos & more.
> http://mobile.yahoo.com/go?refer=1GNXIC
>
> [Non-text portions of this message have been removed]
>