I am running transaction reports from Oracle Transactional Business Intelligence.
The produced report includes various lines which net to £0 as well as minor adjustments for tax, delivery, roundings etc.
I was wondering if it is possible to create a transaction list report which merges these transaction lines?
For example:
Would become:
(The above example is using the transaction no. as an indicator to merge lines which I think is the best way.).
Can this be done through Oracle?