What's new in Customer Journeys?

Connect and learn more! ×
Query to get pay group from ap invoice installments page — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get pay group from ap invoice installments page

Accepted answer


Hello, I am trying to get the pay group on the payables--> manage invoice --> invoice actions --> manage installment --> paygroup

On the table ap_payment_schedules_all , I found all the other information DUE_DATE, gross_amount, unpaid amount etc.

Also if the installment is on-hold or not.

But I cannot find the information in the installment header except for "Payment Reason Comment" that is itself in the payment_schedules table.

Where are the other information such as Unique Remittance Identifier, Paygroup, Check digits ...?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!