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

[Former Member]

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

[loganathan_p3 · Accepted solution]

Hi

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

NOTE:

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

Regards

Logan