Process flow for Financial Closing Unallocated Receipts

RPA (Robotic Process Automation) is leveraged to automate the emailing of open invoices and unallocated amounts to customers, as well as to process applications based on customer responses. The complete process is divided into two automated processes:

  • Outgoing process
  • Incoming process

Outgoing process

RPA retrieves unallocated receipts and open invoices with outstanding balances for business partners and consolidates the data by currency, in an Excel report. An automated email is sent to customers with the Excel file as an attachment. The file contains a list of unallocated receipts and open invoices and instructions on how to mark paid invoices.

Prerequisite
Ensure that the Excel sheet containing Business Partner data and the text file with the email template are stored in the specified directory.
Process
  1. The process is initiated by accessing the Business Partners data from Excel sheet and uses the email template provided in the text file, present in the specified directory.
  2. The RPA process retrieves the unallocated receipts and the open invoices with outstanding balances for business partners from Infor LN and consolidates this data into an Excel report.
  3. An email is sent to the customer with this Excel as an attachment.

Incoming Process

RPA reads customer email responses, extracts application details, switches to the correct finance company and business partners to update the assignment of unallocated receipts in Infor LN, based on customer instructions. The RPA ensures that both, unallocated receipt and the invoice balances are not negative.

Additionally, RPA logs errors and notifies the collection agent for unresolved issues.

Prerequisite
Ensure that a dedicated outlook email folder is created (for example, RPA_Inbox). The user is responsible for moving all customer response emails into the email folder.
Process
  1. The process is initiated by accessing the logged-in tenant email account and reading all emails stored in the specified email folder (for example, from RPA_Inbox).
  2. The unallocated amount is assigned to the invoices as per the responses from the customer and finalizes the Journal vouchers in LN.
Note: 
  • The Unapplied or the In process remittances are not considered while preparing communication to customers.
  • Receipts schedules and Assignment of Credit note or Advances are excluded from this release.