Add Line Details from Transaction Details Tab in Transactions Form to Standard Report

  • 8 November 2022
  • 3 replies

Userlevel 3
Badge +1

Hi, I am trying to customize the standard report CA Register Detailed (CA624500.rpx). I am trying to get the line details in Transaction Details tab of the Transactions form (CA304000) to the report. I have used the following join but it results in duplicates. Please let me know how I can avoid that.

Thank you.



Best answer by TharidhiP 5 December 2022, 03:44

View original

3 replies

Userlevel 7
Badge +4

Hi @TharidhiP! The join looks good, but I think it is caused by adding this table in addition to the tables which are already present.

It might be easier to work with this in a GI to configure the relations where it can be quicker to manipulate and test.

When viewing just these two tables there are no duplicates in my testing, but adding in the other tables seems to cause this, so if you mimic the report relations in a GI and then try to work with just a few joins at a time, adding more and more until you spot the issue it could make it easier to know which one could be adjusted to fix the duplicates.

Userlevel 3
Badge +1

Hi @BenjaminCrisman thank you for your suggestion! I tried this approach and it yielded the same duplicates. So as a workaround we used a sub report to just extract those line details to the original report which gave the required result.

Userlevel 7

Thank you for sharing your solution with the community @TharidhiP !


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved