Hi,
Was wondering if anyone can help me with the table joins that are required for me to include SO header fields on my invoice reports AR641000 and SO643000
Any help is appreciated
TY!
Best answer by xkylewrightx
View originalHi,
Was wondering if anyone can help me with the table joins that are required for me to include SO header fields on my invoice reports AR641000 and SO643000
Any help is appreciated
TY!
Best answer by xkylewrightx
View originalKeep in mind that you’ll get duplicate data if you have multiple Shipments on an Invoice.
Also, in your second join, it’s best to include OrderType as well since that’s part of the primary key as you can see here:
Nevermind, got some help off site.
The two joins that are needed on the AR641000 report are:
And:
The SO Invoice report (SO643000) already has access to the SOOrder table.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.