Skip to main content

OCR Overview

The OCR Import settings can be found in ExFlow Setup and Vendor Setup

This page will give an insight in the ExFlow AP OCR Overview

Go to: ExFlow Setup - Overview --> OCR

Data Capture Accounts

Go to: ExFlow Data Capture Accounts

An ExFlow Data Capture Account must be setup to be able to import documents to an Import Journal via ExFlow Data Capture.

Read more about how to get started with ExFlow Data Capture

ExFlow Data Capture Accounts
NewAdd a new EDC Account
ManageEdit/View or Delete
Home
Home --> Test ConnectionWill test the service connection with given settings to confirm valid service setup
Home --> Update Document Templates for All AccountsUpdates document templates for all accounts
Home --> Update Buyer List for All AccountsChecks for new buyers and updates the buyers list for all accounts
Home --> Import Data Exchange DefinitionsOpens a page to Import Data Exchange Definitions
Home --> Enable Automatic Document ReceivingEnables electronic documents receiving and creates job CU 12013655 (ExKFDocumentReceiveJob)
Home --> Disable Automatic Document ReceivingDisables electronic documents receiving and removes job CU 12013655 (ExKFDocumentReceiveJob)
Navigate
Navigate --> ExFlow Data Capture SetupOpens ExFlow Data Capture Setup
Navigate --> Job Queue EntryOpens Job Queue Entries filtered ocr list
Navigate --> Activity LogOpens the activity log. This Log will be shown if the Event Log is enabled in ExFlow Data Capture Setup
Data Capture Account Card Menu
Home
Home --> Set URLs to DefaultIf the Service section URL's have been changed, this action will reset the actions back to default values.
Home --> Test ConnectionTest if the connection is valid, with given settings. Also checks so the Exchange Service connection is correct
Home --> Update Document TemplatesUpdates the document templates
Home --> Update Buyer ListUpdates buyers list, it will check for new buyers and add them to the list
Home --> Resync Master DataResync the master data (vendor ID Fields) and vendor bank accounts with connected ExFlow Data Capture/OCR Service
Home --> Force Master Data Synchronization. This option will resync and replace the master dataForce Master Data synchronization on connected ExFlow Data Capture account
Navigate
Navigate --> ExFlow Data Capture SetupOpens the ExFlow Data Capture Setup page
Navigate --> Job Queue EntryOpens a filtered job queue entry list on the Master data sync job to provide details on status etc.
Navigate --> Activity LogOpens the activity log (if Event Log is enabled) to give details about the EDC Service
Data Capture Account Card --> General
CodeSpecifies the EDC Account code
TypeSpecify the Account type, if it's a Purchase or Sales
User NameSpecifies the user name that represents your company's login to the EDC service
PasswordSpecifies the password that is used for your company's login to the EDC service
Authorization KeySpecifies the authorization key that is used for your company's login to the EDC service
Default EDC Doc. TemplateSpecifies the EDC template that must be used by default for electronic documents that are received from the EDC service. You can change the EDC template on the individual incoming document card before sending the related file to the EDC service.
Data Exchange TypeSpecifies the data exchange type that is used to process the incoming document when it is an electronic document.
Buyer FilterBuyer Name will be shown in the list, according to given credentials. Options will be given to select to enable for Master Data Filter and/or Buyer Filter
Master Data FilterBuyer Name will be shown in the list, according to given credentials. Options will be given to select to enable for Master Data Filter and/or Buyer Filter
Master Data Sync EnabledSpecifies whether or not the master data sync has been enabled.
EnabledSpecifies if the EDC account service has been successfully enabled.
Job Queue Entry UserSpecifies the user that will be used to run the scheduled jobs. The user must have the necessary permissions to perform the tasks that the jobs will execute.
Additional Data Exchange DefinitionsOpens Import Data Exchange Definitions page to make selection and view details
Data Capture Account Card --> Service
Sign-up URLOpens Tungsten Store
Service URLOpens Tungsten Service

Service Connections
Sign-in URLOpens Tungsten login page

Edit the page to change link url to SignUp login, if this link should be used instead

The Service tab links (two last one) will update depending on used EDC and BC localization (NA,AUS,EUR).

Data Capture Account Card --> Customer Information
NameSpecifies the company name at the provider of the EDC service
IDSpecifies the company's customer ID at the provider of the EDC service
StatusSpecifies the company's status at the provider of the EDC service

Data Capture Setup

Go to: ExFlow Data Capture Setup

ExFlow Data Capture Setup
Resync Master DataResync the master data and vendor bank accounts with ExFlow Data Capture/ OCR Service
Force Master Data SynchronizationForce Master Data synchronization for all listed ExFlow Data Capture accounts
Restore SettingsRestore modified Data Capture Setup to the default values
General
Token Lifetime (min)Specifies cookie lifetime (min). Default value is 25 minutes. Authentication tokens are saved in a cookie and expire after 30 minutes of inactivity.
Http Request Timeout (min)Specifies the HTTP request timeout (min)
Max Lock Time (Min)Specifies the maximum lock time (min) after which the lock is considered invalid
Enable Event LogEnable/Disable event log on the Data Capture Account. The log can be found in the ExFlow Data Capture Accounts --> Navigate --> Activity Log or in the ExFlow Data Capture Account Card --> Navigate --> Activity Log
Service
Max Page SizeSpecifies the max number of vendors to be uploaded to ExFlow Data Capture via Force master data synchronization
Max Document Download CountSpecifies the max document download count.

File Import Setups

Go to: ExFlow File Import Setups

Configure the File Import Setup to use, when importing documents to ExFlow Import Journal.

Import Journal Source Types

Import documents to Import Journal via below Import Types.

In the Import Journal list, batches can be setup to import with following Source Types: ExFlow Data Capture, Web Service, Manual and Import Files.

Source Types
ExFlow Data CaptureImport document via ExFlow Data Capture
Web Service ImportImport document via Web Services
ManualManual import of a document image
Import FilesImport via an Azure FileShare
E-DocumentThis Source Type is shown as an option if Microsoft's published E-Document Connector app is installed and used to handle the electronic documents. No document import to ExFlow Import Journal will be made via this option. Read more about E-Documents here
ExFlow E-Invoicing ProChoose this Source Type if ExFlow E-Invoicing Pro app is installed and used to handle the electronic documents. Documents can then be imported to Import Journal, verified, created and then sent for approval. More information will come.

Azure FileShare

Go to: ExFlow File Import Setups to import images/PDF documents.

ExFlow File Import Setups

File Import Setups
New:Create a new File Import Setup
Manage:Edit, view or delete the setup
Run Import:Run the import process
Enable/Disable:Enable/disable the import source
More options--> Actions--> Show Ongoing ImportsShows a list of pending import files

Click on New to create a new File Import Setup.

Under the General -section, enter a Code, description and choose ''Import From: Azure File''.

When ''Azure File'' gets selected, then both ''Image Folder'' and ''Image Folder'' will be set to ''exflow'' per default under the ''Data (XML)'' -section and ''Image (PDF)'' -section.

Add ''Data Exchange Type'' under the ''Data (XML)''- section. Under the ''Azure File''- section, add information about the Account Name, Access Key, File Share and the base URL.

Enable the setup.

ExFlow File Import Setups

OCR Import Mapping

Go to: ExFlow OCR Import Mapping

Utilize ExFlow OCR Import Mapping to assign vendor-specific coding that populates document lines in ExFlow Import Journal.

Read more about this under OCR Import Mapping

Advanced OCR Mapping

Go to: ExFlow Advanced Mappings to setup more advanced mapping, for instance when a field is not included in the used Data Exchange Definition per default or if there is a need to concatenate values from imported documents etc.

Advanced Mapping
CodeSpecify the Mapping Code
DescriptionSpecify the Mapping Code Description
DisabledSpecifies if a mapping is active or not
FormulaFormula describing the calculation or mapping to be done
Data Exch. Def. CodeLinked data exchange definition code, can be left blank to match any DED
Table IDSpecify the Table destination of mapping when importing, if it on header (Table ID Table ID 12013648 - ExFlow Purch. Import Header) or line level (Table ID 12013649 - ExFlow Import Document Line)
Table NameSpecifies the Table Name: ExFlow Purch. Import Header or ExFlow Import Document Line
Field IDSpecify the relevant Field ID, to be used for the ExFlow Purch. Import Header mapping.
Field NameSpecifies the Field ID name
Target Table IDSpecify if the mapping also should be set to the ExFow Purchase Document Header (Target Table ID 12013587). Only applicable if ''Table ID 12013648 - ExFlow Purch. Import Header'' is set.
Target Table NameSpecifies the name of the Target Table ID -ExFlow Purchase Document Header.
Target Field IDSpecify the Target Field ID to map in the Purch Document Header.
Target Field NameSpecifies the Target Field ID name

Data Exchange Definitions

To start, go to Data Exchange Definitions (DED) and choose the definition to be used with advanced mapping.

Once opened the exchange definition, two line definitions are displayed, one for header and one for line.

Header will be used in this scenario. When header is highlighted, click on field mapping and then ExFlow Advanced Mapping.

Examples of Advanced Mappings

Target Mappings

If we would like to map an interpreted value to a specific field, that is not apart of the DED Table ID, then we can create an advanced mapping.

Let say that there is a need to interpret and map Location Code on ExFlow Purch. Import Header (Table ID 12013648), and put it to the ExFlow Purchase Header. Next step is to choose the Field ID fot the Location Code to be mapped to. For this example MiscHead6 is chosen (Field ID 12013626)

ocr

  1. Add a code, and name the code
  2. enable it and add formula if needed.
  3. choose the DED
  4. If no formula is used, add the Table ID to map towards, which is to choose Header och Line
  5. If the ExFlow Purch. Import Header (Table ID 12013648) is chosen, then it's possible to map the Field ID to a Target Table ID, if needed. However this is not applicable when setting up an advanced mapping on the ExFlow Import Document Line (Table ID 12013649).
  6. If mapping is set for ExFlow Purch. Import Header (and not Document Line), then its also possible to specify Table ID 12013587 (ExFlow Purch. Document Header) and Target Field ID of choice.
  7. Lastly, remember to enable the newly created advanced mapping by unticking the ''Disabled'' checkbox.

Formula Mappings

Formula example 1

For this example, lets say that we have one invoice with two values; these values are 1234 and 5678 and are in MiscHead1 and MiscHead2. If there is a wish to concatenated these two values and to populate the reference field with the sum, we could achieve this in this following way:

Create a new code of choice, such as in the example: ''Referencecont'' with the description Reference concatenate.

The used formula is $MiscHead1+MiscHead2, defined that this is only for XML definition, since this is on header level I pick Table ID: 12013648 which is ExFlow header level, and then Field ID: Reference.

Outcome: After the document interpretation, the result would be that the Reference Code will get ''12345678'' in the ExFlow Import Journal header.

ocr

Formula example 2

There is also a way to use advanced mapping with math formulas. By removing the dollar sign (string) in the formula we are now telling ExFlow to add 1234 and 5678 and to sum up in the Reference field.

Outcome: After the document interpretation, the result would be that the Reference Code will get ''6912'' in the ExFlow Import Journal header.

Formula example 3

It is also possible to hardcode the formula by using hashtags, for ex. ‘’$MiscHead1-#66#-MiscHead2’’, it would give the result:

Outcome: After the document interpretation, the result would be that the Reference Code will get ''1234-66-5678'' in the ExFlow Import Journal header.

More information about mapping can be found under Field Mapping