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

Adding a total DR/CR column to a journal detail report

Received Response
edited Apr 23, 2020 7:46PM in General Ledger & Intercompany 2 comments


I'm trying to add a total column to report that shows journal line detail.


Our implementation of oracle financials has separate fields for debit and credit entries. We are trying to determine if it is possible to total up these fields in sql to add a `total dr/cr` column.

So far I have tried to show the difference of these two fields as a separate field in sql, with and without casting them with the variable type of double. Neither pair works. As soon as I reference two fields in the syntax I don't have any values returned for this column. Does anyone know how to do this successfully?

Howdy, Stranger!

Log In

To view full details, sign in.


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