In order management old and updated data needed in OTBI in separate lines.
When we create a sales order due to some issues if we cancel the sales order, we are able to see the updated data of the sales order in the OTBI report.
The requirement is to see the old and updated history of sales orders separately in the OTBI report.
Content (required): We created one sales order in order management,
The scenario is sales order is created with 30 quantities. we created a revision by decreasing the quantity to 0. Now we want to create an OTBI report that includes all the revisions in tabular form. as shown below
So our requirement is to have the old 30 quantities in the 1st line and updated 0 Quantities in the 2nd line and so on for the subsequent revisions in an OTBI report.