Questions Report Designer Tables join
i tried to join batch and account which is not possible so i have to pass by gltran to get one field to filter with it branch.status
my problem now is that each line is duplicated many times
i know the problem is with the join between LegalGneralBalance and GlTran
I tried to join with Account and i tried to group the result with AccountID Or AccountCD but i got the same results
I've had this problem multiple times. I'm sorry I can't specifically help you since I'm still so green, but everytime for me I fixed it by playing around with the join type. You are on the right path.
I am new to Acumatica as well and I am spending a lot of time reviewing out of the box reports to gain insights into how Acumatica themselves create reports.
I am not seeing any references to a LegalGeneralBalanceGLHistory table in the version of Acumatica we use but if it similar to GLHistory I think you would also need to join on the following fields:
You can look at the following reports for additional guidance:
GL633000 Journal Transactions by Period
GL633500 Journal Transactions for Account