Hi everyone,
I’m trying to build a Generic Inquiry that combines:
OTPAPPurchaseFiltered: to show a total amount based only on FinPeriodID (Created View inSQL)
TaxHistory: to show tax details for the same FinPeriodID, but filtered by Vendor and finperiodid which is from OTP in my GI
My goal is:
OTP should not be restricted by Vendor — only by FinPeriod. OTP should only show data from that view based on Finperiod that user selected.
TaxHistory should be filtered by FinPeriod + Vendor.
I can get this to work if I join OTP to TaxHistory, but then the OTP total also filters by Vendor, which I don’t want.
If I try to keep OTP as a separate root Data Source, the GI compiler drops the table (FinPeriodID cannot be used because the table is not joined).
I added valid Conditions and fields in the Results Grid but still see the error.
My question:
What is the best practice to show independent results from two different tables with a common FinPeriod filter, when they can’t be joined directly on other fields. I am going to include more tables based on finperiod only that shows data related to that finperiod
I have attached two XML files below.
