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

Custom Reports with multi currency Balances , amount to be split into individual row

Accepted answer
22
Views
1
Comments

Summary:

There's one custom report we are trying to generate in which there's one column Currency Balance. Ideally we want only one currency and amount to be shown in one row and if there are multiple then for next currency there should be a new row.

Profile has set up as multiple currency with Entered/Functional/Reporitng balances and for each there would multiple entered balances, one functional balance and one reporting balance.

While we execute custom reports, we observe that all currency balances are grouped in one cell, separated by a <BR> identifier. Ideally we want only one currency and amount to be shown in one row and if there are multiple then for next currency there should be a new row. Is there any way to generate a custom report that gives us a separate row for each currency balance?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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