ReadSoft Online supports the extraction and interpretation of remittance advices.
A remittance advice is a document sent by a customer to a supplier to inform the supplier that an invoice has been paid. Remittance advices often list several invoices in a table, where each line-item row depicts a separate invoice. Typically, each row contains a reference, such as an invoice number, the amount due and the amount paid.
ReadSoft Online can extract information from remittance advices in various formats, including:
Remittance advice tables which extend over multiple pages.
Side-by-side remittance advice tables.
Multiple remittance advice tables. If ReadSoft Online finds more than one remittance advice table, all of the tables are captured.
Duplicate columns. If ReadSoft Online detects duplicate columns both columns are used to ensure the extracted values are correct. For example, if a value from one column is difficult to read, but the corresponding value in the duplicate column is legible, the legible value is used.
When verifying remittance advices, it is important to make sure that the total amount of the remittance advice equals the sum of all of the invoices in the table. ReadSoft Online makes this task easier by automatically validating the amounts using the Remittance advice line-item total amount validation.
In order to process remittance advices and take advantage of the remittance validation, you must enable a remittance advice document type in the Extraction service. Likewise, you must choose a remittance advice document type when sending remittance advices to ReadSoft Online.
Incoming remittance advices must have these fields in order to utilize the remittance validation:
|Invoice field||Field type name in ReadSoft Online|
|Total amount (header field)||InvoiceTotalVatIncludedAmount|
|Invoice number (line-item field)||LI_InvoiceNumber|
|Invoice total (line-item field)||LI_InvoiceTotal|
Improving capture performance
If the invoice numbers in the line-item table of the remittance advice have a known format, you can improve capture performance by specifying a regular expression that matches the format of the field (LI_InvoiceNumber). When ReadSoft Online extracts invoice number fields from the line-item table on the remittance advice, it uses the regular expression to eliminate uncertain matches. To specify the regular expression for the invoice number field in the line-item table:
Navigate to the Extraction service and click EDIT.
Click the remittance advices document type.
In the view that appears, click the Line-item fields tab and click LI_InvoiceNumber.
In the view that appears, specify a regular expression in the Field format setting.
The regular expression should match all possible values that the invoice number field can have. For example, assume the invoice number fields contain 7 to 9 digits. In this case, you would type the following in the Field format setting:
After you specify a regular expression, you can test it by typing an example invoice number in the Test value box and clicking TEST.