Is there a report exactly similar to Sales journal by account of 11i, in R12?
Dear Gurus,
We have a problem on hand. We just upgraded from 11i to R12.2.5. Our client was using Sales Journal by Account Report(Which also includes transactions that are not accounted) to match with sales shipped and reconcile. Now in R12, the same report is obsoleted and There is a replacement report Sales journal by account(XML). But this report does not include unaccounted transactions. hence there is a mismatch. We tried for Transaction Register, but with that also has a problem as below:
If the Receivables Account(1102) amonuts to 100 and Revenue Account(4397) amonuts to 200 and we ran Transaction Register Report for Revenue Account and not Receivables Account. But it returns amount 100, which is a corrosponding amount to revenue account and there is a restriction with Transaction Register report as below: