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

Intercompany Approval

in General Ledger & Intercompany

Hi Team,

We have a requirement to select the approval based on cost centre and amount. As there is no direct field/attribute available in intercompany approvals for getting the cost centre, we have chosen to go via SQL query route. We have defined a DFF for the user to select the cost centre and based on it a Mapping Set will provide a username. We are trying to get some help on the SQL query as the below query is not working for us.

Note: We have used similar kind of query option in procurement for similar kind of approval and it is working for them.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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