{"id":2089,"date":"2020-01-08T09:23:23","date_gmt":"2020-01-08T09:23:23","guid":{"rendered":"https:\/\/processminery.com\/?p=2089"},"modified":"2023-09-27T12:26:37","modified_gmt":"2023-09-27T12:26:37","slug":"predict-ap-invoice-payment-day-with-machine-learning","status":"publish","type":"post","link":"https:\/\/staging.processminery.com\/index.php\/2020\/01\/08\/predict-ap-invoice-payment-day-with-machine-learning\/","title":{"rendered":"Predict AP Invoice Payment day with Machine Learning"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2089\" class=\"elementor elementor-2089\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-634467a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default parallax_section_no qodef_elementor_container_no\" data-id=\"634467a4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6328561c\" data-id=\"6328561c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-361fd053 elementor-widget elementor-widget-text-editor\" data-id=\"361fd053\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.17.0 - 08-11-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>There are many areas where Machine Learning can be used in Celonis to improve business processes. An example is improving the on time payment rate in the Accounts Payable process by predicting when the AP invoices will be paid. The predicted payment day can be used to timely identify invoices that are likely to be paid late so that actions can be taken to ensure the invoice will still be paid on time.<\/p><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3431 size-full\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/due_date_passed_ap_invoices_process_model.jpg\" alt=\"\" width=\"819\" height=\"686\" srcset=\"https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/due_date_passed_ap_invoices_process_model.jpg 819w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/due_date_passed_ap_invoices_process_model-300x251.jpg 300w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/due_date_passed_ap_invoices_process_model-768x643.jpg 768w\" sizes=\"auto, (max-width: 819px) 100vw, 819px\" \/><\/p><p>The data from paid invoices in the ERP application (e.g. Oracle ERP Cloud) is used as input for the model that is going to predict when the invoice will be paid. All the information that is available about the invoice and the past invoices from the same supplier is used to generate the prediction model with Machine Learning. The data that is available includes the invoice amount, PO invoice or not, holds, number of lines, weekday the invoice is due, indication if certain activities are performed, sequence of specific activities, the number of days between the invoice date and the invoice entry date and the number of days from the payment terms. But also the information from previous invoices from the same supplier is available like the number of late paid invoices and the number of holds. All together more than 25 attributes are used to generate the prediction model. And additional attributes can be easily added when needed.<\/p><p>The data from the ERP application is loaded into Celonis IBC for process mining analysis. The invoices are assigned to five different payment categories: from paid on time until paid very late. In the machine learning workbench in Celonis a part of the data is used as training data set. The training data set is used to automatically generate the model with a machine learning algorithm that is predicting the payment category. A test data set is used to validate the generated prediction model.<\/p><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3432 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/extract_data_from_celonis_with_python-1024x656.jpg\" alt=\"\" width=\"1024\" height=\"656\" srcset=\"https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/extract_data_from_celonis_with_python-1024x656.jpg 1024w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/extract_data_from_celonis_with_python-300x192.jpg 300w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/extract_data_from_celonis_with_python-768x492.jpg 768w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/extract_data_from_celonis_with_python.jpg 1078w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p><p>\u00a0<\/p><p>For every new invoice that is entered in the ERP application the model is predicting the payment category. This gives an indication if it is likely that the invoice will be paid on time or not. The predictions are available in Celonis IBC analytics and in the Celonis Action Engine to take automatic actions.<\/p><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3433 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/payment_days_prediction-1024x477.jpg\" alt=\"\" width=\"1024\" height=\"477\" srcset=\"https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/payment_days_prediction-1024x477.jpg 1024w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/payment_days_prediction-300x140.jpg 300w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/payment_days_prediction-768x357.jpg 768w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/payment_days_prediction.jpg 1113w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p><p>\u00a0<\/p><p>By setting up the appropriate signals based on the prediction and other attributes of the invoice in the Action Engine it is ensured that there are signals send to users for those invoices that require direct attention.<\/p><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3434 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/action_engine-1024x265.jpg\" alt=\"\" width=\"1024\" height=\"265\" srcset=\"https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/action_engine-1024x265.jpg 1024w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/action_engine-300x78.jpg 300w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/action_engine-768x198.jpg 768w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/action_engine-1536x397.jpg 1536w, https:\/\/staging.processminery.com\/wp-content\/uploads\/2023\/09\/action_engine.jpg 1637w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p><p>\u00a0<\/p><p>With additional data coming available from new paid invoices the prediction model is trained further and improved versions of the model are implemented to further support the process to ensure timely payment of the invoices!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Did you ever realize that the transactions in Oracle EBS could be used to automatically generate a process model? Not just a process model that is designed by you, but a process model that is generated based on the data in Oracle EBS! Process mining makes this possible.<\/p>\n","protected":false},"author":5,"featured_media":2190,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[63],"tags":[81,49,50,51,75,59,53,54,80,79,74,52],"class_list":["post-2089","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-machine-learning","tag-ap-invoice","tag-celonis","tag-celonis-ems","tag-celonis-ibc","tag-celonis-process-connector","tag-machine-learning","tag-oracle","tag-oracle-cloud-erp","tag-payment-date","tag-predict-payment-date","tag-process-connector","tag-process-mining"],"_links":{"self":[{"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/comments?post=2089"}],"version-history":[{"count":17,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2089\/revisions"}],"predecessor-version":[{"id":3483,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2089\/revisions\/3483"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/media\/2190"}],"wp:attachment":[{"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/media?parent=2089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/categories?post=2089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.processminery.com\/index.php\/wp-json\/wp\/v2\/tags?post=2089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}