BAQ to track lots...need help!

Kay,
JobBin is not a table in Epicor. It is a 'special' table used in the RDD for the Crystal Report. It looks like they are using this 'table' as away to link PartBin or PartBinInfo with a Job. Honestly, I don't understand why they are doing it, it looks like a Job Pick List could be developed without such weirdness. I thought perhaps it has something to do with Job Allocations, but I don't see any evidence of that since I would think the PartAlloc table could be used for that. I'm sure they have their reasons, but I'm sure you can develop what you need without it.

-Rick Bird
IT Software Administrator
Rowmark, LLC.

--- In vantage@yahoogroups.com, "kayd.indaco" <kay.d@...> wrote:
>
> I'm trying to write a BAQ but can't find all of the information needed.
>
> Vantage has a JOB PICK LIST report that is pulling information from JobAsmbl, JobMtl, and JobBin. The information we need comes from what they're calling "JobBin" but I can't find it in the Data Dictionary. It has the lot's on hand quantity and the lot number.
>
> Can anyone tell me what JobBin is or where to get this information?
>
> Thanks in advance for any help.
>
> Kay Doolin
> Indaco Metals LLC
>
I'm trying to write a BAQ but can't find all of the information needed.

Vantage has a JOB PICK LIST report that is pulling information from JobAsmbl, JobMtl, and JobBin. The information we need comes from what they're calling "JobBin" but I can't find it in the Data Dictionary. It has the lot's on hand quantity and the lot number.

Can anyone tell me what JobBin is or where to get this information?

Thanks in advance for any help.

Kay Doolin
Indaco Metals LLC
PartBin has the current onhand qty for each part/warehouse/lot number,
and PartWhse the total onhand for all lots. If you need more lot
details beyond the current qty you'll need the PartLot table.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of kayd.indaco
Sent: Thursday, July 12, 2012 2:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ to track lots...need help!





I'm trying to write a BAQ but can't find all of the information needed.

Vantage has a JOB PICK LIST report that is pulling information from
JobAsmbl, JobMtl, and JobBin. The information we need comes from what
they're calling "JobBin" but I can't find it in the Data Dictionary. It
has the lot's on hand quantity and the lot number.

Can anyone tell me what JobBin is or where to get this information?

Thanks in advance for any help.

Kay Doolin
Indaco Metals LLC





[Non-text portions of this message have been removed]
We wrote a modified pick list to use Part Lot. In the quantity on hand subreport we used Warehouse joined to Part Lot to display the on hand quantities for each lot. I am not sureI have ever seen JobBin before



________________________________
From: kayd.indaco <kay.d@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 12, 2012 2:19 PM
Subject: [Vantage] BAQ to track lots...need help!


Â
I'm trying to write a BAQ but can't find all of the information needed.

Vantage has a JOB PICK LIST report that is pulling information from JobAsmbl, JobMtl, and JobBin. The information we need comes from what they're calling "JobBin" but I can't find it in the Data Dictionary. It has the lot's on hand quantity and the lot number.

Can anyone tell me what JobBin is or where to get this information?

Thanks in advance for any help.

Kay Doolin
Indaco Metals LLC




[Non-text portions of this message have been removed]