Linking Returns to the Original Transaction Detail
Linking Return Transactions to the Original Sales Transaction detail - AP21
Returns
There is a table in the cube called "Returns", found under the 'Show Fields' drop down of your pivot table.
This area links the Returns Transaction to the Original Sales Transaction for:
- Original Location of the sale transaction AND the location of the return transaction
- Original Docket Number AND the return Docket Number
- Return Sale $ AND the Previous Transaction Net Sales $
- Original Payment Type AND the Return Payment Type
This table is also linked to
- Salesperson table
- Member table
It is NOT linked to the Product Data

See below link to view Returns (including product information) against Original sales Location