Skip to main content
Answer

Altering the AP Register Report- Duplicate Lines

  • October 12, 2022
  • 2 replies
  • 89 views
B
Freshman I

Using versions 2021 R2

I am creating an AP Register for a custom process. I altered the AP Register to remove unneeded fields. Then added the AP Tran Table so that I can add the account and Subaccount.  It is however reporting two lines and the second line contains incorrect account and subaccount.  I know it likely has something to do with the join but I cannot figure out what elements I need to use to get this correct. I could not add the .rpx file, so here are some screenshots.

 

Best answer by BenjaminCrisman

Hi @bdobson! As @laura01 mentioned this issue is caused by the join not containing enough key linking fields. For document tables like SOOrder, APInvoice, ARInvoice, POOrder, etc, they need to use as many key linking fields to their associated Tran tables, SOLine, APTran, ARTran, POLine, etc.

Here is another posting where similar help was provided on locating all the necessary key linking fields:
 

 

Laura03

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • October 12, 2022

Hello, Try joining on two fields, DocType → TranType as well as Reference number.  Is a good idea to join on Company ID too.

~ Laura Barber, WM Synergy
BenjaminCrisman
B
Chris Hackett
BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • October 12, 2022

Hi @bdobson! As @laura01 mentioned this issue is caused by the join not containing enough key linking fields. For document tables like SOOrder, APInvoice, ARInvoice, POOrder, etc, they need to use as many key linking fields to their associated Tran tables, SOLine, APTran, ARTran, POLine, etc.

Here is another posting where similar help was provided on locating all the necessary key linking fields:
 

 

Laura03
Chris Hackett
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