Hi everyone,
I want to create a GI to look at where our cash is going. My first attempt was to start with CATran and join GLTran, then to join GLTran on itself with just the BatchNbr. I thought this would return all rows for all batches that involve the cash account.
Has anyone done something like this before?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/aabb13a2-b85e-428f-ac69-8f0a30abd27a.png)
So far, it appears I may need an SQL nested view… would love it if there was another way. I don’t think I have access to make new DACs with SQL
Generic Inquiry – Use subqueries for a field – Acumatica Generic Inquiries & Pivot Tables – Acumatica User Group Forums (augforums.com)