All, tearing my hair out over this. GL stuff is way above my head.
Basically, we need to print out GL accounts associated with a batch. This is where it goes above my head… sometimes a batch also has an associated PO with an attached GL account (POLine.ExpenseAcctID).
You can see in the first screenshot, the amazon GLTran is duplicated numerous times.
In the second screen, I added a grouping, it fixed things visually, but it broke things more than fixed. I don’t think the issue is grouping but a relationship/join.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/91e55709-5db3-4304-917f-e89b1f75d9b4.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/885b9345-595b-450d-b19f-4d5aca8b406b.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/44370ff9-93b5-48be-a969-38822d825fbb.png)
I’ve attached the xml if anyone could take a look… thank you!
Best answer by michellehesketh58
View original