Link from Job to Invoice information?

Yahoo Archive
1
Try the JobProd table. It holds the order number, line and release
numbers. From there you can link to the InvcDtl table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bjb714
Sent: Friday, October 16, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Link from Job to Invoice information?





I am writing a Crystal Report to summarize gross profit by job. I have
been through the data dictionary but I cannot find a field in the job
tables to link and then look up invoicing information.

Can someone point me in the right direction?





[Non-text portions of this message have been removed]
2
I am writing a Job Profitibility report in Crystal and cannot find a way to link the job tables to the order tables to pull invoicing information.

I am missing something? Shouldn't there be a jobnum field in the orderrel table?

Can any one shed some light on how to pull order/invoice information based on fields available in the job files?

Thanks
3
I am writing a Crystal Report to summarize gross profit by job. I have been through the data dictionary but I cannot find a field in the job tables to link and then look up invoicing information.

Can someone point me in the right direction?