While developing reports in Oracle General Ledger using FSG (Financial Statement Generator) you may have to develop a report in which you have to display Debit and Credit in a separate column. We can set Dr/Cr of two columns but if any account will have values in both Dr and Cr then both values will be displayed instead of net Dr or Cr. It is not as simple as it seems to be. We will use a trick to get the result.
For this demonstration I have used user operations/welcome of 220.127.116.11 vision instance. After login switch to General Ledger responsibility,