Hi Carina,

In principle this section is not sufficient to define an activity. The excerpt only represents the extraction of the relevant information from your database (SELECT). If I understand you correctly, you would like to understand how the individual parts are put together. In order to define an activity in Celonis, a case key, a name and a timestamp are required. In addition, as in your case, several additional columns are added, such as the sorting. I assume that all columns are self explanatory except the timestamp creation. Therefore, I suppose that your question refers to the creation of the timestamp. The creation of the timestamp is somewhat more complex in this case, since possible cash discounts are to be taken into account here.

Field ZBD3T describes the payment period, field ZFBDT contains the baseline date for due date calculation, and ZBD1T/ZBD2T contain information on possible cash discounts. The time stamp for the Invoice Due Date Passed activity is determined from this information. The corresponding days are added to the baseline date.

I hope that this information helps you to understand how this activity is created. If there are any open questions, please feel free to contact us again.

Best regards,

Justin

I too have the same question.

Why Due date passed step is included in the happy path? can you please provide more information on this step and its importance here.

Why clear invoice activity cannot be the last activity in the happy path.

Thanks.

Same issue I am facing, the "invoice due date passed" is always the last activity on my path, how is this possible even when the invoice is cleared? It cannot be due if it is cleared.