Skip to main content
Solved

GI Isn't Matching Payment Reference Numbers All The Time

  • July 7, 2026
  • 3 replies
  • 9 views
S
Varsity III
Forum|alt.badge.img+1

I have a GI that compares settlement batches to AR payments and then puts those payments on bank accounts, but I’m finding that even though settlement batch processing center transaction numbers match AR payment external reference numbers it’s leaving certain information blank.

 

I’m sure it’s something simple I’m missing!

Best answer by SBaldwin

Solution was to add a =Trim into the relations table

 

 

    3 replies

    S
    Varsity III
    Forum|alt.badge.img+1
    • SBaldwin
    • Author
    • Varsity III
    • July 7, 2026

    I found the issue. There is a space at the beginning of the payment reference number. I will post how I mitigate this

    S
    Varsity III
    Forum|alt.badge.img+1
    • SBaldwin
    • Author
    • Varsity III
    • Answer
    • July 7, 2026

    Solution was to add a =Trim into the relations table

     

     

      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • July 7, 2026

      Thank you for sharing your solution with the community ​@SBaldwin!

      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 & ConditionsAccessibility 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