I am trying to do reporting on the NET revenue per channel (we differentiate channels by order types). I’m using the ARTran table to obtain the SOOrderNbr, SOOrderType, and NetSalesAmount. However, returns (RC order types) are not connected to the original Sales Order other than via the invoice number and show up under their own order type (RC).
Does anyone have any suggestions regarding how to set up a GI that will reflect the negative amount generated by the RC return against the original Sales Order? Or maybe something like:
IIf(OrderType=’RC’, OriginalSOOrderNbr, SOOrderNbr)