Linking the customer name to a job number

Yahoo Archive
1
WoW!!! That worked and it was sooo easy. Thanks again.

--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> The only way to do this is if the demand is Sales Order (job[s]
linked
> to the sales order release-MAKE DIRECT is checked).
>
> If this is the case, then JobProd is your table to link the JobHead
and
> OrderRel (back to the OrderHed). But the OrderHed has CustNum
(which
> is meaningless to most). So to get to the Customer Name, you must
link
> the OrderHed.CustNum to the Customer.CustNum to get the Customer
Name.
>
> Whew...
> Patty Buechler
>
>
> --- In vantage@yahoogroups.com, "smithjennifer79" <jsmith@> wrote:
> >
> > Can this be done easily. I am trying to create a crystal report
to
> > group by job number and then display est. hours vs. actual. I
want
> to
> > be able to know what customer is associated to the jobs.
> >
>
2
Can this be done easily. I am trying to create a crystal report to
group by job number and then display est. hours vs. actual. I want to
be able to know what customer is associated to the jobs.
3
Are your jobs linked to the Customer Sales Order? If so, use the
JobProd table.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of smithjennifer79
Sent: Friday, November 14, 2008 10:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Linking the customer name to a job number



Can this be done easily. I am trying to create a crystal report to
group by job number and then display est. hours vs. actual. I want to
be able to know what customer is associated to the jobs.






[Non-text portions of this message have been removed]
4
The only way to do this is if the demand is Sales Order (job[s] linked
to the sales order release-MAKE DIRECT is checked).

If this is the case, then JobProd is your table to link the JobHead and
OrderRel (back to the OrderHed). But the OrderHed has CustNum (which
is meaningless to most). So to get to the Customer Name, you must link
the OrderHed.CustNum to the Customer.CustNum to get the Customer Name.

Whew...
Patty Buechler


--- In vantage@yahoogroups.com, "smithjennifer79" <jsmith@...> wrote:
>
> Can this be done easily. I am trying to create a crystal report to
> group by job number and then display est. hours vs. actual. I want
to
> be able to know what customer is associated to the jobs.
>
5
Thanks for the quick responses. I will try that.
Jennifer


--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> The only way to do this is if the demand is Sales Order (job[s]
linked
> to the sales order release-MAKE DIRECT is checked).
>
> If this is the case, then JobProd is your table to link the JobHead
and
> OrderRel (back to the OrderHed). But the OrderHed has CustNum
(which
> is meaningless to most). So to get to the Customer Name, you must
link
> the OrderHed.CustNum to the Customer.CustNum to get the Customer
Name.
>
> Whew...
> Patty Buechler
>
>
> --- In vantage@yahoogroups.com, "smithjennifer79" <jsmith@> wrote:
> >
> > Can this be done easily. I am trying to create a crystal report
to
> > group by job number and then display est. hours vs. actual. I
want
> to
> > be able to know what customer is associated to the jobs.
> >
>