Introduction

Spindle Purchase Invoice Recognition's Web Verify component follows a smart step-by-step process to determine the correct currency for each invoice. 

Description

• First, it looks for the currency stated directly on the document itself - if found, that's what it uses.
• If no currency is shown on the invoice, the system then checks whether a fallback currency has been set in the SPIR Server Administration Tool.
• When neither of those options work, Web Verify then looks up the supplier's default currency setup in Sage 200.
• As a fourth option, if the currency still can't be identified, the system will use the supplier's country held in Sage 200 and use its default currency.

Only if all four of these automatic methods fail will the system require manual input from the user - this ensures we catch every possible scenario while minimising manual intervention.

Even without a fallback currency set, the system can still automatically determine currency through the document & the supplier details.

Rules

The current currency rules are as follows:

1. If currency found on document. Then use currency from the document.
2. If currency is NOT found on the document AND there is a Fallback Currency set in the SPIR Admin Tool.
3. If currency is not found on the document AND there is no Fallback Currency THEN check the ISOCurrencyCode for the supplier in the Master_Creditor.csv
4. If currency is not found using 1, 2 or 3 THEN get Country of Master_Creditor.csv and search for the default currency for that country.
5. If points 1 to 4 above cannot determine the Currency field THEN the user must input the currency manually.

If a fallback currency is not set, the system may still be able to set the currency based on Points 1, 3, & 4.

Knowledge Base Article Details