Hi All,
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/cb36dddc-bb61-4a22-a325-da6bdb4bde2f.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d33709c4-121a-48e9-a817-370fcb96be78.png)
Pls help me if you have any idea to show project ID in one column.
Thanks in advanced.