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 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.
NOTE. 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.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.