GenJob RDD Help

system · March 15, 2012, 10:49am

Just so I make sure I understand the why behind this. Why include JobPart
between JobHead and JobProd when company and jobjum are common keys
between JobHead and JobProd.

Joshua Giese

CTO

920.437.6400 Ext. 337

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, March 15, 2012 9:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GenJob RDD Help

Josh,

You must be on 9, I don't recognize Part_UD, what is stored in there? I
cant wait till we get to 9...I feel like im behind the curve..

Try going from job head to jobpart (jobhead is parent table) join on
company Jobnum and partnum then join jobprod to jobpart (jobpart is
parent) by company and partnum

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joshua Giese
Sent: Thursday, March 15, 2012 9:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] GenJob RDD Help

How do I verify that? I'm not very good with RDD struggling to equate
what bits of the RDD screen are equal to what parts in an actual SQL
statement. Wish we could just write statements and move on with life. It
is the original table in the definition.?

Joshua Giese

CTO

920.437.6400 Ext. 337

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Thursday, March 15, 2012 9:05 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] GenJob RDD Help

Im reaching...Is jobhead set as the parent table?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Anon
Sent: Thursday, March 15, 2012 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] GenJob RDD Help

I have modified GenJob to include Company, JobHead, JobProd, OrderRel, and
Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum,
OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on
the labels.

Non-make-direct jobs I can print labels from and get a .bt file.
Make-direct jobs where the job prod table has order info in it, when I
print them they go into the system monitor and hang until I restart the
appserver.

I am hoping someone else has had this same problem even if not on the same
RDD and knows what might lead to it.

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

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

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

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

system · March 15, 2012, 9:50am

I have modified GenJob to include Company, JobHead, JobProd, OrderRel, and Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum, OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on the labels.

Non-make-direct jobs I can print labels from and get a .bt file. Make-direct jobs where the job prod table has order info in it, when I print them they go into the system monitor and hang until I restart the appserver.

I am hoping someone else has had this same problem even if not on the same RDD and knows what might lead to it.

system · March 15, 2012, 10:05am

Im reaching...Is jobhead set as the parent table?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Anon
Sent: Thursday, March 15, 2012 8:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] GenJob RDD Help

I have modified GenJob to include Company, JobHead, JobProd, OrderRel, and Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum, OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on the labels.

Non-make-direct jobs I can print labels from and get a .bt file. Make-direct jobs where the job prod table has order info in it, when I print them they go into the system monitor and hang until I restart the appserver.

I am hoping someone else has had this same problem even if not on the same RDD and knows what might lead to it.

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

system · March 15, 2012, 10:11am

How do I verify that? I'm not very good with RDD struggling to equate
what bits of the RDD screen are equal to what parts in an actual SQL
statement. Wish we could just write statements and move on with life. It
is the original table in the definition.?

Joshua Giese

CTO

920.437.6400 Ext. 337

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, March 15, 2012 9:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GenJob RDD Help

Im reaching...Is jobhead set as the parent table?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Anon
Sent: Thursday, March 15, 2012 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] GenJob RDD Help

I have modified GenJob to include Company, JobHead, JobProd, OrderRel, and
Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum,
OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on
the labels.

Non-make-direct jobs I can print labels from and get a .bt file.
Make-direct jobs where the job prod table has order info in it, when I
print them they go into the system monitor and hang until I restart the
appserver.

I am hoping someone else has had this same problem even if not on the same
RDD and knows what might lead to it.

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

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

system · March 15, 2012, 10:35am

I'm making at guess at what you've done, and I suspect you've taken the
hard way...

Did you manually add a new report table to the RDD and specify the table
relationships and fields manually? This works, but its easy to miss a
detail - eg, an outer join required somewhere. You can end up with an
empty XML file & thus no report printed - might be the cause of your
problem.

If there is a natural join between the tables, use the linked tables
section in RDD, and Epicor will build calculated fields for you that
pull in data from other tables. For example, to get the "Part UD
fields" you mention: Find the JobHead table, "Linked Tables", "Pick
Links" & add a link for PartNum. Save, then in "Description Fields" add
Character01 or whatever. In the Crystal field explorer, this will
appear in the JobHead table with a name something like
"PartNum_Character01".

Hope that helps (and that I guessed correctly).

Brian.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joshua Giese
Sent: Thursday, March 15, 2012 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GenJob RDD Help

How do I verify that? I'm not very good with RDD struggling to equate
what bits of the RDD screen are equal to what parts in an actual SQL
statement. Wish we could just write statements and move on with life. It
is the original table in the definition.?

Joshua Giese

CTO

920.437.6400 Ext. 337

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Thursday, March 15, 2012 9:05 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] GenJob RDD Help

Im reaching...Is jobhead set as the parent table?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Anon
Sent: Thursday, March 15, 2012 8:50 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] GenJob RDD Help

I have modified GenJob to include Company, JobHead, JobProd, OrderRel,
and
Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum,
OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on
the labels.

Non-make-direct jobs I can print labels from and get a .bt file.
Make-direct jobs where the job prod table has order info in it, when I
print them they go into the system monitor and hang until I restart the
appserver.

I am hoping someone else has had this same problem even if not on the
same
RDD and knows what might lead to it.

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

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

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

system · March 15, 2012, 10:42am

Josh,

You must be on 9, I don't recognize Part_UD, what is stored in there? I cant wait till we get to 9...I feel like im behind the curve..

Try going from job head to jobpart (jobhead is parent table) join on company Jobnum and partnum then join jobprod to jobpart (jobpart is parent) by company and partnum

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joshua Giese
Sent: Thursday, March 15, 2012 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GenJob RDD Help

How do I verify that? I'm not very good with RDD struggling to equate
what bits of the RDD screen are equal to what parts in an actual SQL
statement. Wish we could just write statements and move on with life. It
is the original table in the definition.?

Joshua Giese

CTO

920.437.6400 Ext. 337

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Thursday, March 15, 2012 9:05 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] GenJob RDD Help

Im reaching...Is jobhead set as the parent table?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Anon
Sent: Thursday, March 15, 2012 8:50 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] GenJob RDD Help

I have modified GenJob to include Company, JobHead, JobProd, OrderRel, and
Part.

The relationship JobHead2Company includes the Company field.
The relationship JobProd2JobHead includes Company and JobNum.
The relationship OrderRel2JobProd includes Company, PartNum, OrderNum,
OrderLine, OrderRelNum
The relationship Part2JobHead includes Company and PartNum

I am ultimately trying to get PONum, Part UD fields, and Rel ship to on
the labels.

Non-make-direct jobs I can print labels from and get a .bt file.
Make-direct jobs where the job prod table has order info in it, when I
print them they go into the system monitor and hang until I restart the
appserver.

I am hoping someone else has had this same problem even if not on the same
RDD and knows what might lead to it.

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

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

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