Skip to main content
Answer

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

  • November 8, 2022
  • 3 replies
  • 135 views
T
Pro III
Forum|alt.badge.img+2

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

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.

1 Attachments

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • November 8, 2022

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.

T
Chris Hackett
T
Pro III
Forum|alt.badge.img+2
  • TharidhiP
  • Author
  • Pro III
  • Answer
  • December 5, 2022

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.

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • December 5, 2022

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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