Skip to main content

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.

 

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

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:
 

 

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