Solved

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

  • 8 November 2022
  • 3 replies
  • 73 views
T
Rank
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.

 

icon

Best answer by TharidhiP 5 December 2022, 03:44

View original
1 Attachment

3 replies

BenjaminCrisman
Rank
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.

T
Rank
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.

Chris Hackett
Rank
Userlevel 7
Badge

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*.

Reply


Terms & ConditionsCookie settings
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