One inquiry with all checks (regular checks and quick checks)

@khowe86 I just did a quick check (hehe) in my local GI and it looks like this may not be a good idea to add the APQuickCheck into the Checks and Payments GI, but technically the Quick Checks still appear in the AP Payment Register, so really all you need to do is remove all the conditions in the Checks and Payments GI and then quick checks will come in, but there isn’t a DocType to match, so it appears blank:

So you can do an expression like:

=[APPayment.DocType] but it results in the database value for the DocType instead of the UI value:

So instead you would probably need to chain the IIF statements in the expression to make sure there is one for each type of DocType:

=IIF([APPayment.DocType]= 'QCK', 'Quick Check', [APPayment.DocType])

That can work, but even as I’m working through this, it will navigate to Checks and Payments with a blank doctype:

So if the table is joined in:

Then you will get 3 of each quick check type, so you would need to add grouping:

But this will SUM the amounts off the quick check and be 3x what is on the document.

You would also need to add navigation parameters and make an new line for the Quick Check RefNbr:

Then it will navigate correctly

Regarding the error that you got, it was because the APQuickCheck table wasn’t joined into the GI via the relations

But also, I’ve attached the GI for reference