Issued Mtl Date

Yahoo Archive
1
Outer join from JobMtl to Parttran thru company, jobnum, (?going from memory - MtlSeq?) and PartNum.

Rob




________________________________
From: Toby Boogerd <tboogerd@...>
To: vantage@yahoogroups.com
Sent: Friday, June 19, 2009 10:03:03 AM
Subject: [Vantage] Issued Mtl Date





I am making a report dealing with material variances on issued qty verse
required qty. I want the report to run by a date parameter. I don't know
which date exactly to use. I want to go by the date the material was
issued, however I don't see any dates in the job tables for that. When
looking at the Vantage screen where mtl is issued it looks like it is
stored in the parttran table using parttran.transdate and looking at
trantype STK-MTL and STK-ASM.

Anyone have thoughts on this or how to link the job tables to the
PartTran table correctly?

Toby Boogerd
Information Systems

712.324.4854 | tboogerd@rosenboom. com <mailto:tboogerd@rosenboom. com>

NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

Please consider the environment before printing this email.

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







[Non-text portions of this message have been removed]
2
I am making a report dealing with material variances on issued qty verse
required qty. I want the report to run by a date parameter. I don't know
which date exactly to use. I want to go by the date the material was
issued, however I don't see any dates in the job tables for that. When
looking at the Vantage screen where mtl is issued it looks like it is
stored in the parttran table using parttran.transdate and looking at
trantype STK-MTL and STK-ASM.



Anyone have thoughts on this or how to link the job tables to the
PartTran table correctly?



Toby Boogerd
Information Systems

712.324.4854 | tboogerd@... <mailto:tboogerd@...>


NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

Please consider the environment before printing this email.





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