Sage Intelligence Consolidated Job Cost reports

Question

I feel like the Not Equal join used in Crystal in order to combine the Company file in a report to be able to get the company name/code would not work in SI. Is there a way of adding the company code for NON-FINANCIAL reports?

Doc102208 · Accepted Answer

Adding the code will let you when populating the container with data fields will let you select from both the AR_Option & SY_Company. 
 AR_Option contains the Co Code 
 SY_Company contains Co Code & Co Description. 
 
 The following is linking AR_TransactionPaymentHistory to the AR_Customer files.

(("AR_TransactionPaymentHistory" INNER JOIN "AR_Customer" ON "AR_TransactionPaymentHistory"."ARDivisionNo" = "AR_Customer"."ARDivisionNo" AND "AR_TransactionPaymentHistory"."CustomerNo" = "AR_Customer"."CustomerNo") LEFT JOIN "AR_Options" ON "AR_Options"."Divisions" = "AR_Options"."Divisions") LEFT JOIN "SY_Company" ON "AR_Options"."CompanyCode" = "SY_Company"."CompanyCode") 
 
 If you use Graphical Linking you can make the link. Then change it from Graphic to Join. Than add the Company Code lines at the bottom.

Sage 100

Sage Intelligence Consolidated Job Cost reports

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING