Skip to Content

C4C Analytics: How to handle Return Orders in Sales Order Reports?

Feb 04, 2017 at 11:39 AM


avatar image

Dear Experts,

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!

Best regards,

Jan Vosecky

return.png (26.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Loganathan P Feb 06, 2017 at 06:30 AM


Try the below step by Going to Business Analytics workcenter and open your required report

  • Settings - Keyfigure - Specific and select the Reverse Sign checkbox as shown below

  • Save the report and execute again.You will have the values with reverse sign


Create a new report based on the Return Order document type and use this reverse sign in order shown these values are pertains to the return orders



ro.jpg (28.7 kB)
10 |10000 characters needed characters left characters exceeded