Skip to main content
Answer

APPayment ExtRefNbr field not populating in GI

  • May 16, 2025
  • 6 replies
  • 52 views

Hello,

I am trying to create a GI to show payment information (primarily the payment/ACH number and payment date) for a Purchase Order. The problem I am running into is that when adding the Payment Ref field from the Checks and Payments screen (which appears to be the ExtRefNbr field from APPayment), it does not return a value in the GI. 

I am posting here to see if this is a known issue with a workaround or if I am just missing something in the setup of the GI itself. This is my first community post, so apologies in advance if I left out any important information. Thanks!

 

Best answer by alexgillespie61

@lauraj46 

Apologies for the delay in responding/following up. I tried the change you suggested and while it didn’t get me the results I was looking for, it did help me look at things differently and identify my issue.

The GI was returning the prepayment (VI) records instead of the payment (VP) records I was looking for, which contain the External Ref field. Changing the join for the POOrderPrepayment and APPayment tables to payRefNbr instead of apRefNbr got me the results I was looking for.

Thank you for the help!

6 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • May 16, 2025

Hi ​@alexgillespie61 ,

Welcome to the community! 

The APPayment.ExtRefNbr is part of the out-of-the-box AP-Checks and Payments generic inquiry, and in my system it returns results.  Do you see values in this field on that standard GI?

Laura


Hi ​@lauraj46 

Thanks for the quick reply! I just checked and I do see values in the ExtRefNbr field on the Checks and Payments GI.


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • May 16, 2025

@alexgillespie61 If you export your GI definition and attach the XML to this thread then I’ll take a look.


@lauraj46  Here is the XML for the GI in question. Thanks for the assistance!


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • May 16, 2025

Hi ​@alexgillespie61 ,

I think that perhaps your join between APPayment and APAdjust should be on the adjg fields, not adjd.  The APRegister table holds the payment record, whereas APInvoice holds the bill.  

Hope this helps!

Laura


  • Author
  • Freshman II
  • Answer
  • May 22, 2025

@lauraj46 

Apologies for the delay in responding/following up. I tried the change you suggested and while it didn’t get me the results I was looking for, it did help me look at things differently and identify my issue.

The GI was returning the prepayment (VI) records instead of the payment (VP) records I was looking for, which contain the External Ref field. Changing the join for the POOrderPrepayment and APPayment tables to payRefNbr instead of apRefNbr got me the results I was looking for.

Thank you for the help!