Difference between revisions of "OCR service"

From 1Archive help
Jump to: navigation, search
(→‎Available fields)
(→‎Available fields)
 
(23 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
==General==
 
==General==
 +
<br/>{{info|The OCR serivce is only active between 8h untill 18h. Documents will only be validated during this time of the day.}}<br/>
 
The OCR service is used for recognizing and validating documents coming from an external source. Your app can make use of it by sending PDF documents to Onea Transfer (documentation can be found [https://dev.onea.be/api/oneatransfer/index.html here]).<br/>
 
The OCR service is used for recognizing and validating documents coming from an external source. Your app can make use of it by sending PDF documents to Onea Transfer (documentation can be found [https://dev.onea.be/api/oneatransfer/index.html here]).<br/>
 
Those documents will automatically be sent through our recognition server, where they will await validation by a manual validator.
 
Those documents will automatically be sent through our recognition server, where they will await validation by a manual validator.
Line 28: Line 29:
 
===Manual validation===
 
===Manual validation===
 
<br/>{{warning|This chapter is only applicable for manual validators.}}<br/>
 
<br/>{{warning|This chapter is only applicable for manual validators.}}<br/>
 +
 +
Please see the link to [https://drive.google.com/open?id=1uAiJ43-Gk2v3waDz2VeUxGUsrzcOYSok Google Drive] for dictionaries, example invoices, etc.
  
 
====Login====
 
====Login====
Line 49: Line 52:
 
* '''Supplier/customer''': the supplier from who the invoice came / the customer for which the invoice is intended.
 
* '''Supplier/customer''': the supplier from who the invoice came / the customer for which the invoice is intended.
 
* '''Supplier/customer VAT''': the VAT ID of the supplier/customer. '''This field is read-only and cannot be edited.'''
 
* '''Supplier/customer VAT''': the VAT ID of the supplier/customer. '''This field is read-only and cannot be edited.'''
 +
* '''Supplier/customer IBAN''': the IBAN of the supplier/customer. '''This field is read-only and cannot be edited.'''
 +
* '''Supplier/customer TRN''': the TRN of the supplier/customer. '''This field is read-only and cannot be edited.'''
 
* '''Invoice number''': the number of the invoice.
 
* '''Invoice number''': the number of the invoice.
 
* '''Invoice date''': the date of the invoice.
 
* '''Invoice date''': the date of the invoice.
Line 55: Line 60:
 
* '''Currency''': the currency used for the invoice.
 
* '''Currency''': the currency used for the invoice.
 
* '''Net amount''': the net amount of the invoice.
 
* '''Net amount''': the net amount of the invoice.
−
* ''' Local net amount''': when choosing a value other than EUR for currency, this field shows the net amount in EUR. '''This field is read-only and cannot be edited.'''
 
 
* '''VAT amount''': the VAT amount.
 
* '''VAT amount''': the VAT amount.
 
* '''Total amount''': the total amount of the invoice.
 
* '''Total amount''': the total amount of the invoice.
−
* '''Discount %''': the percentage of the discount received when the document is paid within a certain period. '''This field is only available for incoming invoices.'''
 
 
<br/>
 
<br/>
 
Available posting line fields:
 
Available posting line fields:
 
* '''Net amount''': the amount of the booking line. The default value is the net amount entered on the header.
 
* '''Net amount''': the amount of the booking line. The default value is the net amount entered on the header.
−
* '''VAT %''': the percentage of VAT
+
* '''VAT %''': the VAT percentage used on the document.
 +
* '''Line VAT amount''': the VAT amount for this line.
  
 
<br/>{{info|Fields shown in red are mandatory and need to be filled in to be able to validate a document. A field is shown in yellow when the recognition server is not sure of the value it found. These fields always need to be validated.}}<br/>
 
<br/>{{info|Fields shown in red are mandatory and need to be filled in to be able to validate a document. A field is shown in yellow when the recognition server is not sure of the value it found. These fields always need to be validated.}}<br/>
Line 73: Line 77:
 
* [[image:remove.png|link=]] '''"Cancel document"''': cancel the current document.
 
* [[image:remove.png|link=]] '''"Cancel document"''': cancel the current document.
 
* [[image:yes.png|link=]] '''"Validate"''': validate the current document.
 
* [[image:yes.png|link=]] '''"Validate"''': validate the current document.
 +
* [[image:deliveryrule.png|link=]] '''"Send with email"''': send the current opened document as an e-mail attachment to a certain e-mail address. '''This is only available for incoming invoices!'''
 
<br/>
 
<br/>
 
When cancelling a document, you need to provide a reason why you think this document should be cancelled. There are multiple possibilities to choose from:
 
When cancelling a document, you need to provide a reason why you think this document should be cancelled. There are multiple possibilities to choose from:
Line 79: Line 84:
 
<br/>[[image:cancel_document.png|link=]]<br/>
 
<br/>[[image:cancel_document.png|link=]]<br/>
 
<br/>
 
<br/>
 +
 
=====Supplier/customer validation=====
 
=====Supplier/customer validation=====
 
When no existing supplier/customer could be found with the data found on the invoice, the system gives you the possibility to add a new one.
 
When no existing supplier/customer could be found with the data found on the invoice, the system gives you the possibility to add a new one.
Line 87: Line 93:
 
Use the [[image:add.png|link=]] "Add" or the [[image:edit.png|link=]] "Edit" button to add or edit the supplier/customer.
 
Use the [[image:add.png|link=]] "Add" or the [[image:edit.png|link=]] "Edit" button to add or edit the supplier/customer.
 
<br/>
 
<br/>
 +
<br/>{{warning|Don't use the "X" icon in the supplier/customer field in Internet Explorer/Edge for clearing the field! This will not be picked up by the system and the already entered value will be sent to BilltoBox!}}
 
<br/>
 
<br/>
 
======Available fields======
 
======Available fields======
Line 100: Line 107:
  
 
<br/>[[image:ocr_partner_edit.png|link=|400px]]<br/>
 
<br/>[[image:ocr_partner_edit.png|link=|400px]]<br/>
 +
<br/>
 +
 +
====Reports====
 +
To view the available reports for the OCR environment, follow these steps:
 +
 +
# Open the reports via this [https://jasperreports.onea.be/jasperserver-pro url]
 +
# Login with your credentials
 +
# Open the list of reports via ''View - Repository'' in the menu on top
 +
# Select the ''ocr'' folder located in ''Root - Organizations''
 +
# Select the report you would like to see on the right
 +
 +
Following reports are availalbe:
 +
* '''OCR field recognition''': view the recognition rate for the different fields per document
 +
* '''OCR field recognition (chart)''': view the recognition rate for the different fields in a chart
 +
* '''OCR percentages''': view the overall recognition rate percentages and how long it takes to process documents
 +
* '''OCR volumes (chart)''': view a chart of the documents which entered the system and were processed on a specific day
 +
<br/>
 +
 +
===VAT lines===
 +
====1Archive used as pre-accounting====
 +
When 1Archive is configured as a pre-accounting platform, the master data resides in the corresponding accountancy software. This means that the VAT values used for booking are defined as standard values on either supplier and/or GL account in the accounting software.
 +
When receiving multiple VAT lines and/or multiple VAT regimes from the community platform, an override will be made by 1Archive using the default values used on supplier and/or account level.
 +
 +
====Use case scenario when using STP (Straight Through Processing)====
 +
Within 1Archive you can choose to define suppliers on STP = true to enable direct booking. Whenever multiple VAT lines are applicable, only one line will be transferred to the accounting software. If needed, a correction has to be made in the accountancy software.
 +
<br/>{{info|Use STP for suppliers where only onea VAT regime is applicable. When multiple VAT regimes are needed, a correction of the booking can be made in 1Archive or in the accountancy software.}}<br/>
 +
1Archive is using the API of the accountancy software to integrate, which is different from uploading invoices using the accountancy software XML import modules.
 +
 +
===FAQ===
 +
====Net and VAT amount fields are shown red====
 +
No tolerance is taken into account when amounts are entered into the document. ''"Net amount"'' + ''"VAT amount"'' should always equal ''"Total amount"''. When the fields are shown red, this means that the sum is not correct and the amounts need to be updated.
 +
<br/>
 +
In case the fields are shown red and they are the same amounts as on the image, you can change the ''"Net amount"'' field so the sum equalizes.
 +
<br/> {{warning|<u>'''Never ever'''</u> change the ''"VAT amount"'' and ''"Total amount"'' fields to make sure the sum equalizes!}}<br/>
 +
<br/> [[image:ocr_amount_validation.png|link=|900px]]<br/>
 +
<br/>
 +
 +
====French invoices====
 +
When a French invoice enters the system and the supplier on this invoice has a Dutch name, you are allowed to edit the name and add the French variant to it.
 +
 +
'''For example''':<br/>
 +
# An invoice for "Agence alimentaire fédérale" enters the system, but the supplier/customer is not recognized
 +
# You check the VAT number on the invoice and find a supplier/customer called "Federaal voedselagentschap"
 +
# You check the website of "Federaal voedselagentschap" to see if there is a French variant of the company
 +
# You see there is a French variant
 +
# You are now allowed to edit the name of the supplier/customer to "Federaal voedselagentschap/Agence alimentaire fédérale"
 +
 +
<br/>{{warning|If there is no French variant of the company, you are not allowed to edit the name! In that case, you should create a new supplier/customer.}}<br/>

Latest revision as of 07:53, 14 September 2021

1 General


Info.png The OCR serivce is only active between 8h untill 18h. Documents will only be validated during this time of the day.

The OCR service is used for recognizing and validating documents coming from an external source. Your app can make use of it by sending PDF documents to Onea Transfer (documentation can be found here).
Those documents will automatically be sent through our recognition server, where they will await validation by a manual validator.


Info.png The advantage of using a manual validator is we can increase the recognition percentage to a maximum.

Schematic overview of the flow:
App ocr integration.png

  1. Your app is sending a PDF document to the OCR service
  2. The OCR service sets the status to PENDING and sends a uuid back
  3. The OCR service sets the status to PROCESSING when the document is successfully received and ready to process
    The OCR service also pokes the given callback URL saying there was a statusupdate
  4. Your app gets the PROCESSING status from the OCR service
  5. The OCR service sets the status to VALIDATION when the document is successfully processed and ready for manual validation
    The OCR service also pokes the given callback URL saying there was a statusupdate
  6. Your app gets the VALIDATION status from the OCR service
  7. Now there are two possible events:
    1. The OCR service sets the status to CANCELLED when the document has been cancelled by the manual validator
    2. The OCR service sets the status to DONE when the document was successfully validated by the manual validator
    The OCR service also pokes the given callback URL saying there was a statusupdate
  8. Your app gets the CANCELLED or DONE status from the OCR service
  9. Your app gets the UBL data of the document from the OCR service

2 BilltoBox usecase


Note.png This is only applicable for companies for which the Value Added Service OCR & Scanning is set to Onea in BilltoBox.

2.1 Manual validation


Warning.png This chapter is only applicable for manual validators.

Please see the link to Google Drive for dictionaries, example invoices, etc.

2.1.1 Login

The OCR service validation is located at https://ocr.onea.be. Login with your provided credentials. Once logged in, you will be redirected to the archive screen where you are able to see a list of all documents that still need to be validated.


Ocr archive.png

2.1.2 Validation

Click the View ok.png View notok.png "View the document" button to open a document.


Ocr document view.png

2.1.2.1 Available fields


Available header fields:

  • Company VAT: the VAT number for the own company. This should always be prefilled by BilltoBox!
  • Invoice type: the type of the invoice. Possible values are:
    • F: invoice
    • C: credit note
  • Supplier/customer: the supplier from who the invoice came / the customer for which the invoice is intended.
  • Supplier/customer VAT: the VAT ID of the supplier/customer. This field is read-only and cannot be edited.
  • Supplier/customer IBAN: the IBAN of the supplier/customer. This field is read-only and cannot be edited.
  • Supplier/customer TRN: the TRN of the supplier/customer. This field is read-only and cannot be edited.
  • Invoice number: the number of the invoice.
  • Invoice date: the date of the invoice.
  • Due date: the date before which you have to pay the invoice.
  • OGM: the structured bank transfer code.
  • Currency: the currency used for the invoice.
  • Net amount: the net amount of the invoice.
  • VAT amount: the VAT amount.
  • Total amount: the total amount of the invoice.


Available posting line fields:

  • Net amount: the amount of the booking line. The default value is the net amount entered on the header.
  • VAT %: the VAT percentage used on the document.
  • Line VAT amount: the VAT amount for this line.

Info.png Fields shown in red are mandatory and need to be filled in to be able to validate a document. A field is shown in yellow when the recognition server is not sure of the value it found. These fields always need to be validated.

2.1.2.2 Available buttons


  • Back.png "Close": close the current opened document.

Warning.png If there are unsaved changes, these will be lost!

  • Save.png "Save": save the changes you made in the document.
  • Remove.png "Cancel document": cancel the current document.
  • Yes.png "Validate": validate the current document.
  • Deliveryrule.png "Send with email": send the current opened document as an e-mail attachment to a certain e-mail address. This is only available for incoming invoices!


When cancelling a document, you need to provide a reason why you think this document should be cancelled. There are multiple possibilities to choose from:

  • No invoice found: select this one if the document isn't an invoice.
  • Other: select this one if you think for some reason the document should be cancelled. Please provide a comment explaining why you think the document should be cancelled.


Cancel document.png

2.1.2.3 Supplier/customer validation

When no existing supplier/customer could be found with the data found on the invoice, the system gives you the possibility to add a new one.


Info.png The supplier/customer field can be shown in orange, this means that there is already a proposal for creating the supplier/customer.

When a supplier is already selected (either by the recognition server, or by manually selecting one), you still can edit its data.
Use the Add.png "Add" or the Edit.png "Edit" button to add or edit the supplier/customer.


Warning.png Don't use the "X" icon in the supplier/customer field in Internet Explorer/Edge for clearing the field! This will not be picked up by the system and the already entered value will be sent to BilltoBox!


2.1.2.3.1 Available fields
  • Active: should the supplier/customer be active or not?
  • Code: the code for the supplier/customer. This field cannot be changed!
  • Name: the name for the supplier/customer.
  • External ID: the ID for the supplier/customer in an external package. This field should not be used!
  • Aliases: the aliases for the supplier/customer.
  • VAT ID: the VAT ID for the supplier/customer.
  • Bank account 1: the bank account (IBAN) for the supplier/customer.
  • E-mail: the e-mail address for the supplier/customer.
  • Website: the website for the supplier/customer


Ocr partner edit.png

2.1.3 Reports

To view the available reports for the OCR environment, follow these steps:

  1. Open the reports via this url
  2. Login with your credentials
  3. Open the list of reports via View - Repository in the menu on top
  4. Select the ocr folder located in Root - Organizations
  5. Select the report you would like to see on the right

Following reports are availalbe:

  • OCR field recognition: view the recognition rate for the different fields per document
  • OCR field recognition (chart): view the recognition rate for the different fields in a chart
  • OCR percentages: view the overall recognition rate percentages and how long it takes to process documents
  • OCR volumes (chart): view a chart of the documents which entered the system and were processed on a specific day


2.2 VAT lines

2.2.1 1Archive used as pre-accounting

When 1Archive is configured as a pre-accounting platform, the master data resides in the corresponding accountancy software. This means that the VAT values used for booking are defined as standard values on either supplier and/or GL account in the accounting software. When receiving multiple VAT lines and/or multiple VAT regimes from the community platform, an override will be made by 1Archive using the default values used on supplier and/or account level.

2.2.2 Use case scenario when using STP (Straight Through Processing)

Within 1Archive you can choose to define suppliers on STP = true to enable direct booking. Whenever multiple VAT lines are applicable, only one line will be transferred to the accounting software. If needed, a correction has to be made in the accountancy software.


Info.png Use STP for suppliers where only onea VAT regime is applicable. When multiple VAT regimes are needed, a correction of the booking can be made in 1Archive or in the accountancy software.

1Archive is using the API of the accountancy software to integrate, which is different from uploading invoices using the accountancy software XML import modules.

2.3 FAQ

2.3.1 Net and VAT amount fields are shown red

No tolerance is taken into account when amounts are entered into the document. "Net amount" + "VAT amount" should always equal "Total amount". When the fields are shown red, this means that the sum is not correct and the amounts need to be updated.
In case the fields are shown red and they are the same amounts as on the image, you can change the "Net amount" field so the sum equalizes.


Warning.png Never ever change the "VAT amount" and "Total amount" fields to make sure the sum equalizes!


Ocr amount validation.png

2.3.2 French invoices

When a French invoice enters the system and the supplier on this invoice has a Dutch name, you are allowed to edit the name and add the French variant to it.

For example:

  1. An invoice for "Agence alimentaire fédérale" enters the system, but the supplier/customer is not recognized
  2. You check the VAT number on the invoice and find a supplier/customer called "Federaal voedselagentschap"
  3. You check the website of "Federaal voedselagentschap" to see if there is a French variant of the company
  4. You see there is a French variant
  5. You are now allowed to edit the name of the supplier/customer to "Federaal voedselagentschap/Agence alimentaire fédérale"

Warning.png If there is no French variant of the company, you are not allowed to edit the name! In that case, you should create a new supplier/customer.

Retrieved from "https://help.onea.be/index.php?title=OCR_service&oldid=3137"