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 SLA accounts from AP Invoices

Summary:

I have Project AP invoices which are accounted in AP. we need the Debit and credit information from SLA. can any one provide query for the same.

Content (required):

we have AP Distribution id, for a specific distribution we want retrieve the account information. we we query based on event id it return all the SLA account for that invoice. i need SLA for a Specific distribuion. How to get the same using SQL

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

23C

Code Snippet (add any code snippets that support your topic, if applicable):

Select xal.*

,GLCC.ACCOUNT_TYPE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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