Vendor statement parameters – global settings

ExFlow Common | Setup | Vendor statements | Vendor statement parameters

Set the parameters that suit your company and installation.

Import

Field	Description
Enable batch import for scanned vendor statements	Scanned vendor statements from EDC will be imported by batch job setup.
Identify vendor rules set	Rules can be selected which are created in Vendor Statement identify Vendor rules form in ExFlow Common – Setup – Rules Vendor statement identify Vendor rules, when rules are created it can be selected in import setting.
Validate vendor statement after creation	When checked ExFlow will validate statement after creation and import.

Vendor reconciliation

Field	Description
Require workflow approval	If workflow is required for posting of statements.
Reconciliation email template id	Id for the email template setup for notifications.
Automatically send reconciliation report	If enabled, reconciliation report will be sent automatically to vendor.

Number Sequence

Create the number sequence for Vendor statements by using the number sequence wizard.

• Organization administration – Number sequences – Number sequences.
• Navigate to Exflow Common – Setup – Vendor Statements – Vendor statement parameters.
  

Field	Description
Vendor statement number	The reference is used in ExFlow when unique Vendor statement numbers are generated.
Vendor reconciliation voucher number	The reference is used in ExFlow when unique Vendor reconciliation voucher numbers are generated.
Vendor reconciliation ID	The reference is used in ExFlow when unique Vendor reconciliation numbers are generated.

Automatic vendor reconciliation parameters

Field	Description
Add line	Add new line.
Remove	Remove the marked line.
Account code	For automatic vendor reconciliation select Table for specific vendor, group for vendor group or all vendors.
Account relation	Select the vendor or vendor group to apply.
Matching rule set	Select the rule to apply for the automatic reconciliation.

Automatic email on reconciliation settings

Select account code and account relation to automatically send out e-mail to vendor with the reconciliation report.

Field	Description
Add line	Add new line.
Remove	Remove the marked line.
Account code	For automatic email sending, select Table for specific vendor, group for vendor group or all vendors.
Account relation	Select the vendor or vendor group to apply.

Vendor statement exception reason codes

ExFlow Common | Setup | Vendor Statements | Vendor Statement exception reason codes

Reasons codes available for the vendor statement exception report, like customer reason codes. The Reason codes support translations for multiple languages.

Field	Description
Save	Save the settings.
New	Add new line.
Delete	Delete the marked line.
Translations	Translations for multiple languages.
Reason code	Add reason code.
Default comment	Description of the reason code.

Vendor statement matching rules

ExFlow common | Setup | Rules | Vendor Statement matching rules

Allows you to define the matching rules that shall be used as well as setting up multiple rules set for different matching scenarios.

Basic criteria´s
“Match amount” including allowed amount difference.
“Match open balance” includes allowed amount difference.
“Match posting date” includes allows date difference.
“Match invoice date” includes allowed date difference.

Additional criteria
Allows to add criteria which are not included in basic criteria.

Vendor statement matching rules set

ExFlow Common | Setup | Rules | Vendor Statement matching rule set
Allow you the setup in what order rules should be triggered as well as setting up multiple rules set for different matching scenarios.

Vendor Statement identify Vendor rules

ExFlow Common | Setup | Rules | Vendor Statement identify Vendor rules

The purpose is to find the correct vendor for the statement record based on data in the statement file.
Vendors statement identify Vendor rules are used to make vendor rules on which statements can be matched. “Match Org number”, “Match VAT number”, “Match name” and “Match Email address” are in the basic criteria.

Additional criteria
The additional criteria can be customized with vendors fields (vendtable), values and Statement fields.

For ExFlow data capture below vendor fields is capture in import statement fields;
Vendor account = Identifier 1
Account number = identifier 2

Vendor statement identify Vendor rules set

ExFlow Common | Setup | Rules | Vendor Statement identify Vendor rules set

Allows to setup multiple rules set for different vendor matching scenarios and in what order rules should be triggered.