How to Apply Iff Function in Generic Inquiry

I’d like to see the other available columns. Without seeing, I am guessing.

Here is my guess. Your GI likely shows a document type. Payments are showing Payment in Document type column and Invoices are showing Invoice in document type column.

If I am correct so far, I think you can add a new “Project” column to your GI with code something like this:

If Document type = ‘Payment’, [ARPayment.ProjectID], [ArInvoice.projectID].

However, this above example may be too simple if there are many document types showing. You may need to use  OR like this:

If Document Type = ‘Payment’ or Document Type = ‘Prepayment’ or Document Type = ‘Credit Memo’, [ARPayment.ProjectID],  ... etc.

I hope this helps you.

Thanks Laura so much

You get my point but I have a lot of types document so I dont know how to use iff for ar invoice screen  and I try to link another table that is PM Project (PM3010PL) . Below is the relationship I used

It’s work for all type but I dont know why type credit memo is doubled like this, it should be show one line “CV-21-A008” 

Thanks in advanced 

Thank you for sharing your solution with the community @hthuy24 !