I would like to have the notes associated with a transaction to print on the same line on the reconciliation statement report. Which field would I have to include on the report to achieve this?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8e4c0745-629c-4a25-98e2-807293b64839.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/12af7ff1-e333-4ed3-9985-8cc61c6796b6.png)
I would like to have the notes associated with a transaction to print on the same line on the reconciliation statement report. Which field would I have to include on the report to achieve this?
Hi
If you are trying to pick the Notes of the Check and Payments screen, you have to join the APPayment DAC with Note DAC by the NotedID of the both DACs.
As an example please check the below screenshot.
I tried your solution and it worked. What table would I need to display the notes from the “Cash Transactions”? I tried to link the CAAdj table and the Note table, also the CATran and Note table but that did not work. Any ideas. The report I want these displayed on is the reconciliation statement. As mentioned before your initial one appears there.
Hi
As CAAdj is not used in the Standard Reconciliation Report and the CATran is used as one of the main DAC, join the CAAdj with CATran first. Then CAAdj with the Note table. I think that in this way you will be able to get the relevant notes.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.