Skip to main content
Solved

Generic Inquiry to pull check payment information and remittance address


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 arthia98

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

Table Relation: APAdjust and APPayment

Data Field Link: 

adjgDocType and docType

adjgRefNbr and refNbr

 

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+1
  • Jr Varsity III
  • 45 replies
  • 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


@arthia98,

 

Thank you what about the invoice number? 

 


Forum|alt.badge.img+1
  • Jr Varsity III
  • 45 replies
  • 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

 


@arthia98,

 

Thank you.  


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings