Dale,
We found it much easier to use PartDtl as it contains (real time status) of all scheduled Job & PO supply along with Order & Job requirements.
You can then join other tables as needed (outer joins where appropriate) and quickly build a very powerful & detailed as you need BAQ based tool.
We do NOT use Forecasting so my only caveat is that it probably does NOT also include forecast demand data.
I'm sure though you can also outer join the Forecast table into the query - perhaps through the core table of Part or PartPlant - to also integrate that info. You just might need to create sone calculated fields so that all demand (whether firmed/allocated, unfirmed job or forcasted demand) all get cum'ed into appropriate summary buckets.
Rob
We found it much easier to use PartDtl as it contains (real time status) of all scheduled Job & PO supply along with Order & Job requirements.
You can then join other tables as needed (outer joins where appropriate) and quickly build a very powerful & detailed as you need BAQ based tool.
We do NOT use Forecasting so my only caveat is that it probably does NOT also include forecast demand data.
I'm sure though you can also outer join the Forecast table into the query - perhaps through the core table of Part or PartPlant - to also integrate that info. You just might need to create sone calculated fields so that all demand (whether firmed/allocated, unfirmed job or forcasted demand) all get cum'ed into appropriate summary buckets.
Rob
--- On Fri, 2/13/09, adam.whipp <adam.whipp@...> wrote:
From: adam.whipp <adam.whipp@...>
Subject: [Vantage] Re: Need help finding allocation qty
To: vantage@yahoogroups.com
Date: Friday, February 13, 2009, 3:54 PM
Oh, and as a side note, AllocQty DOES NOT include JobUnfirmAllocQty.
--- In vantage@yahoogroups .com, "adam.whipp" <adam.whipp@ ...> wrote:
>
> Dale,
>
> This is summarized for each warehouse in the partwhse table. You
can
> check out the fields "AllocQty", which is the total allocation,
> or "JobAllocQty" (firm job allocation qty), or "JobUnfirmAllocQty"
> (exactly what it sounds like). Hope that helps,
>
> Adam
>
> --- In vantage@yahoogroups .com, "dswmaom" <dwalker@> wrote:
> >
> > Can anyone offer assistance in hellping me find the total
allocated
> > quantity of a component part? What table & field should I be
looking
> > for?
> >
> > I need to calculate total allocations for the next 12 months.
(firm
> job
> > allocations + unfirmed job allocations + forecasted allocations =
> total
> > allocations) .
> >
> > Thanks in advance,
> > Dale.
> >
>