Is it possible to get the customer/entity name of ...
# administration
c
Is it possible to get the customer/entity name of invoices, bills, and journals all in 1 column? It doesn't seem possible and I have to use both the Name (Entity - line) and (Name (Entity)
s
You could try using something like
NVL({entityline},{entity})
r
That or a case statement. Case when type='journal' then entity(line) else entity, etc
c
Are SQL statements possible in reports now? The only formulas I saw were the basic arithmetic functions
s
Didn't know you were working in reports... not a fan of reports, I don't use them
c
Yea, they are pain. It would be nice if they had the ability to do basic SQL switches like that. I just added another column with the mainline name to solve the issue for now.