Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to show CR and DR account combination in two lines with correct transaction amount in OTBI

in Receivables & Collections 4 comments

Summary:

How to show CR and DR account combination in two lines with correct transaction amount in OTBI analysis?

Content (please ensure you mask any confidential information):

In the OTBI analysis,

1. If we add one more column as "Account Description", then account combination of CR and DR can show correctly in two lines, but only one line can show correct transaction amount, another line always show as "0".

2. If we remove the column "Account Description", the transaction amount is correct, but CR and DR is showing the same account combination, which is not correct.


What we want to see is similar with the screenshot,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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