Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 06, 2017 at 06:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded