Skip to main content
Answer

How to link refund transaction to original payment transaction?

  • November 24, 2025
  • 4 replies
  • 33 views
S
Varsity I
Forum|alt.badge.img

I’m having a hard time building a GI that will show an original payment reference number and any corresponding refunds associated with that payment reference number. The  ARTranPostBal is referenced but it’s a hidden table and not able to be used for reporting.

How else can I bridge these two transactions?

Best answer by SBaldwin

​@ChandraM I actually ended up using the ARTran table and conditioned it to only look at REF types. It was able to give me the source reference number which is the original payment number.

    4 replies

    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • November 24, 2025

    Hi ​@SBaldwin , 
    Try building the GI from AR Payments and ARAdjust tables.

    Let me know if this works.

     

    Chandra M
    Manikanta Dhulipudi
    jinin
    Chris Hackett
    S
    Varsity I
    Forum|alt.badge.img
    • SBaldwin
    • Author
    • Varsity I
    • Answer
    • November 25, 2025

    ​@ChandraM I actually ended up using the ARTran table and conditioned it to only look at REF types. It was able to give me the source reference number which is the original payment number.

    C
    Chris Hackett
    nickcerri32
    S
    Varsity I
    Forum|alt.badge.img
    • SBaldwin
    • Author
    • Varsity I
    • November 25, 2025

     

    C
    nickcerri32
    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • November 26, 2025

    Nice. ​@SBaldwin Thanks for the update!

    Chandra M
    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