Help Linking the PO tables to the Job and Order tables

Hi Jim,

I am not familiar with report builder but I have a Crystal Report that lists all the material required for job with the corresponding PO number for non-inventory material. The only way I found to link the PO info is by creating a sub-report which contains Porel and linking it to Jobmtl in the main report.


Regards,
Abe Klassen




----- Original Message -----
From: schujamm
To: vantage@yahoogroups.com
Sent: Wednesday, November 22, 2006 4:21 PM
Subject: [Vantage] Help Linking the PO tables to the Job and Order tables


I am working in vantage 6.1 and report builder.

I am attempting to develop a report that will give me all open order-
Line-Releases and their corresponding raw material PO. a? mark for
Jobs that do not have material ordered.

The purpose of the report is to be able to see which open jobs do not
have material ordered yet.

I have a report that will give me all open orders with all the
information I need for open orders. I have a report that gives me
all information about pos for material only.

How do I link the open orders report to pull up P.O. information on
corresponding raw material P.O.s?

Jim





[Non-text portions of this message have been removed]
I am working in vantage 6.1 and report builder.

I am attempting to develop a report that will give me all open order-
Line-Releases and their corresponding raw material PO. a? mark for
Jobs that do not have material ordered.

The purpose of the report is to be able to see which open jobs do not
have material ordered yet.


I have a report that will give me all open orders with all the
information I need for open orders. I have a report that gives me
all information about pos for material only.

How do I link the open orders report to pull up P.O. information on
corresponding raw material P.O.s?

Jim