Thank you very much everyone.
When we receive material, our clerk needs to know what Project that
material is for.
Thank you very much for the query below.
I'll just use PartDtl joined to JobHead to get the Project associated
with that part number.
Thanks again Nathan and Rob.
Vic
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of bonner.nathan
Sent: Wednesday, December 10, 2008 12:37 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: PartDtl....... Is there a Vantage screen to see?
Vic,
What are you trying to accomplish?
It sounds like you are trying to see Jobs related to Sales Order
demand.
There is no broad view of this relationship outside of a Dashboard,
BAQ Report or Custom Report that I am aware of and PartDtl can give
you some inconsistent results due to the one-to-many relationship of
PartNum/OrderNum/JobNum to TransType (ex. Stk-Mtl, Mtl-Cus, Pur-Mtl,
etc.)
If you are looking for a way to relate Jobs to Sales Order demand in
a broader view than at the individual Sales Order, I recommend a
Dashboard or BAQ Report based on the following:
for each OrderHed no-lock , each OrderDtl where (OrderHed.Company =
OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock ,
each OrderRel where (OrderDtl.Company = OrderRel.Company and
OrderDtl.OrderNum = OrderRel.OrderNum and OrderDtl.OrderLine =
OrderRel.OrderLine) no-lock , each JobProd outer-join where
(OrderRel.Company = JobProd.Company and OrderRel.OrderNum =
JobProd.OrderNum and OrderRel.OrderLine = JobProd.OrderLine and
OrderRel.OrderRelNum = JobProd.OrderRelNum) no-lock , each JobHead
outer-join where (JobProd.Company = JobHead.Company and
JobProd.JobNum = JobHead.JobNum) no-lock .
Watch your Outer Joins between OrderRel and JobProd (critical) as
well as JobProd to JobHead (less critical). JobProd is a much better
table for relating Sales Orders to Jobs.
Good Luck,
NB
--- In
vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Time Phase takes PartDtl data for an individual part and compbines
it with total partplant o/h and mrp suggestions to generate the temp
table TimePhase table data.
>
> The time phase reports do the same.
>
> Rob
>
> --- On Wed, 12/10/08, Vic Drecchio <vic.drecchio@...> wrote:
>
> From: Vic Drecchio <vic.drecchio@...>
> Subject: [Vantage] PartDtl....... Is there a Vantage screen to see?
> To: vantage@yahoogroups.com
> Date: Wednesday, December 10, 2008, 12:01 PM
>
>
>
>
>
>
> Hey all,
>
> PartDtl is a great table that shows all demands for parts and
associated
> Job Numbers.
>
> Is there a screen in Vantage somewhere that displays the contents of
> this table?
>
> Thank you very much.
>
> Vic Drecchio
> ERP Administrator
>
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Office: 336.668.4410 x3091
> Mobile: 704.530.3092
>
> [Non-text portions of this message have been removed]
>
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links