Using versions 2021 R2
I am creating an AP Register for a custom process. I altered the AP Register to remove unneeded fields. Then added the AP Tran Table so that I can add the account and Subaccount. It is however reporting two lines and the second line contains incorrect account and subaccount. I know it likely has something to do with the join but I cannot figure out what elements I need to use to get this correct. I could not add the .rpx file, so here are some screenshots.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a4c346ca-ab7c-4e9f-84d8-53ce55697143.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5f83e76f-767d-40fa-8f97-32475e463620.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a8e351e9-27c1-4af8-b0f8-3ccf1c404afe.png)