Skip to main content
Answer

Generic Inquiry to pull check payment information and remittance address

  • December 9, 2024
  • 4 replies
  • 82 views

Forum|alt.badge.img

Hi,

 

I need guidance in modifying the GI for Checks and Payments to include the remit to address information and invoice number that was paid on the check. Does anyone have a sample GI they can share or provide guidance on what table relations and data fields link to use to get this information.

 

Thank you,

Frances 

 

Best answer by arthia

Hi ​@fpantelidakis07 , Hope this  helps you to get Invoice Number

Table Relation: APAdjust and APPayment

Data Field Link: 

adjgDocType and docType

adjgRefNbr and refNbr

 

4 replies

Forum|alt.badge.img+3
  • Varsity I
  • December 9, 2024

Hi ​@fpantelidakis07 , To get Remittance Address of Checks and Payments, use below tables

Table Relations: APPayment inner join with APAddress 

Data Field Link: APPayment.RemitAddressID and APAddress.AddressID


Forum|alt.badge.img

@arthia98,

 

Thank you what about the invoice number? 

 


Forum|alt.badge.img+3
  • Varsity I
  • Answer
  • December 10, 2024

Hi ​@fpantelidakis07 , Hope this  helps you to get Invoice Number

Table Relation: APAdjust and APPayment

Data Field Link: 

adjgDocType and docType

adjgRefNbr and refNbr

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • December 12, 2024

@arthia98,

 

Thank you.