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.
I’ve attached the xml if anyone could take a look… thank you!