C4C Analytics: How to handle Return Orders in Sales Order Reports?
We are dealing with a difficult situation regarding C4C Sales Order reports. Our customer has several types of Sales Orders, including ‘standard orders’ and ‘return orders’. A return order is applied when a (standard) sales order is rejected and the goods are sent back. The value of the ‘return order’ is then refunded to the buyer.
The scenario is illustrated in the below document flow in ERP:
As you see, both the ‘standard order’ and ‘return order’ have a positive Value. However, in ERP, the value of the ‘return order’ will actually be calculated as a negative value in reports, etc., since the return order value is refunded back to the buyer.
In C4C, we haven’t been able to find a way to handle this situation in the Reports. The C4C reports are simply handling all order types in the same way and aggregating their value.
Could you please suggest any possible approaches?
Thank you in advance for any suggestions!