I have created a new generic inquiry, I joined tables and I want to show project ID in one column. But currently I only can show 2 columns, because project ID appears in 2 screens ( Invoice & Memos) and (Payment & Application)
I have tried to use iff function for ar invoice, if project id is null, it’s will show project ID in payment, but it’s not work.
Pls help me if you have any idea to show project ID in one column.
Thanks in advanced.
Page 1 / 1
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’, yARPayment.ProjectID], oArInvoice.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’, eARPayment.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
Updated:
Thanks all, I have already solved my problem, I use function NullIff ([arinvoice.projectid], [arpayment.projectid]), and I join 2 tables arinvoice and arpayment with ar register.
Thank you for sharing your solution with the community @hthuy24 !