Is there a report/data Source that shows the approval history of orders in C4C

[former_member700672]

Is there any report/data Source that shows the approval history of orders in C4C for example when the order submitted for approval , and when it get approved (considering multiple approvers) the reason behind this is to monitor the order life cycle after creation.

[mjveerhuis1 · Accepted solution]

Hi,

You can analyse report CODCOHB_Q001 Sales Order Data and the underlying data source CODCOHB Sales Order Header. They include the approval status.

As far as i can see, there is no date stored for the statuses you mention. What you could do is define extension fields of the type Date for these statuses and fill them based on a workflow rule with a field update rule type. In the workflow conditions you can select on Approval status and you can fill the extension field when the condition is met (e.g. 'in approval') with current date.

In the definition of the extension fields, you can determine that they need to be added to the CODCOHB data source, so that you can combine the extension fields and the statuses in the Sales Order Data report.

Kr.

MJ

[former_member700672 · Accepted solution]

Hello Marie,

thanks for your answer. I have a question here, a standard workflow can fill the date ? don't we need a development here ?

[mjveerhuis1 · Accepted solution]

Hi Abdullah,

No, you do not need a development. The workflow of the type field update can help you updating a date field with e.g. the current date, so the date of the day the workflow is triggered and executed.

Workflows are extremely useful and easy to use to automate certain business process steps. And as it is standard functionality it remains stable throughout the releases.

Kr.

MJ

[former_member81526]

Good morning,

you can also check data source Approval Task Details, which provides information about an approval task with several available dates (Task Completed On, Task Created On...).

Best regards,

Ana Gándara