Process flow

This sequence outlines the process flow:
  1. Invoice and receipts are extracted.
    1. An H5 script, Unallocated_Receipts, is added as a button in (ARS200) program in M3.
    2. Click the button to initiate the process.
    3. Use the API ARS200MI to verify both payment receipts and invoices. For validation, continue the process only if both exist; if not, the process is stopped.
    4. Select a bank identifier to be used during the payment receipt creation.
    5. After successful validation, the RPA is triggered.
      1. RPA uses ARS200MI to retrieve data related to open invoices and unallocated receipts for the selected payer. Unallocated receipts may be identified as credit notes, on account payments, etc.
      2. Data is exported and formatted into Excel.

        Creates a separate section to list invoices and unallocated receipts.

      3. RPA retrieves the payer’s email address using the API CRS111MI.
      4. The Excel file is emailed to the payer. Text document uploaded to IDM containing the email body information, along with the respective PID configured in the script arguments, is retrieved and used as the email body for the customer mail.

        A copy of the sent attachment in Excel is stored in IDM.

      5. Infor Ming.le and email notifications are sent.
  2. Customer matches payment receipts against invoices and replies with the updated Excel file.
    1. A customer manually matches the unallocated receipts to the corresponding invoices with these details:
      • Invoice number
      • Matched amount
    2. Updated file is attached and sent.
  3. RPA reads customer response from email and extracts the key values to create a bank statement in M3.
  4. RPA populates the Load.bankstatement BOD with this information:
    • Bank identifier
    • Invoice numbers and amounts
    • Currency
    • Payment date
    • Correlation ID
  5. The BOD is published to Infor M3 and payment receipts are created (ABS100).
  6. All inbound customer documents are saved in IDM.
  7. Ming.le and email status notifications are sent to defined user or group.