Web Application for the Automated Reporting of Receivables

This workflow creates a small web application for the automated reporting of receivables. The invoices data can be uploaded as an Excel file containing invoice and customer IDs, invoice value, terms, issue and payment dates. The CRM data are uploaded from CSV files containing responsible managers contact data and company ratings. The example data files are available in the workflow data area. To run the workflow from the Web Portal, make sure the files can be accessed from your local machine. The workflow then matches unpaid invoices with CRM data in order to follow up with the most critical customers. It calculates the overdue invoices and their total amount, and joins the data with company internal data about responsible managers and company ratings. Based on the sum of the due invoices as well as the customer rating, it automatically assigns actions for the sales department. Finally, the receivables can be reported via email to the responsible managers, or downloaded as an Excel file, or both.

This is a companion discussion topic for the original entry at https://kni.me/w/XxV7tQRdN1sxczet

Hi, is there a way to access the example date files from my machine when I download the workflow?

Hi @jeffreyli0312 and welcome to the forum.

The easiest way to do this is to save the workflow to your local workspace, then right-click through the context menu to copy the Local Path of the workflow like this:

Once you have copied the local path to your clip board, you can paste it into your Windows Explorer. The example files will be present in the /data subfolder.