Localization Canada

Language

ExFlow supports the French (Canada) language in Business Central.

Canadian Sales Tax

Go to: ExFlow Setup --> Doc. Creation Checks tab

Enable "Allow Sales Tax" in ExFlow Setups.

With this setting VAT Product Posting Group will not be mandatory in ExFlow and will allow for North American Sales Tax processing.

To make "VAT Prod. Posting Group" optional, both of the following are required:

Requirement	Description
Allow Sales Tax	Enabled in ExFlow Setup, as described above.
Blank VAT Posting Setup record	A VAT Posting Setup record with both "VAT Bus. Posting Group" and "VAT Prod. Posting Group" left blank must exist, with "VAT Calculation Type" set to either "Sales Tax" or "Normal VAT".

Some companies do not use Business Central's Tax Posting Setup for sales tax at all, in which case the blank VAT Posting Setup record commonly defaults to "Normal VAT" instead of "Sales Tax". Both calculation types are accepted, so "VAT Prod. Posting Group" will not be required in these cases either.

To support North American Sales Tax the Tax specific fields from Purchase Document Header and Purchase Document Lines are also implemented in ExFlow Import Journal. The functionalities for these fields are similar to how they work in Purchase Documents in Business Central.

The additional fields in the Document header

• Tax Liable

• Tax Area Code

• Provincial Tax Area Code

• Tax Exemption No.

And on the document lines

• Tax Liable

• Tax Area Code

• Provincial Tax Area Code

• GST/HST

• Tax Group Code

• Use Tax

With the use of Canadian Tax Setup, the ExFlow Import Journal also supports Tax Calculations based on the Canadian Tax. The functionality for retrieving Tax Area Code etc. from Company Information and location instead of Vendor Card is also reflected in ExFlow Import Journal.

Statistics page is now available in ExFlow Import Journal.

It allows for Tax Amount to be manually adjusted when there is a discrepancy between Tax Amount calculated on Invoice Lines and Tax Amount on the invoice received from the vendor (Interpreted by OCR Service in this case).

Handle Tax Group Code in ExFlow Purchase Code

When the Tax Group Code on an invoice line needs to be different than what is defaulted on the master record selected on that invoice line, this can be handled from an ExFlow Purchase Code.

For example, if the Tax Group Code on a G/L account card for Office Supplies is defaulted to NON-TAXABLE, while a line on a Purchase Invoice with that G/L Account needs to be marked as TAXABLE, users could simply add this on the ExFlow Purchase code lines according to picture below.

This would allow users to automate invoice creation in those specific scenarios.

Tax columns on Web

It is possible to make Tax related fields visible in ExFlow Web by adding the columns in ExFlow Setup.

Read more about how to edit web columns under section ExFlow Web.

Prepayment Handling

Canadian environments handle prepayment invoices differently than other localizations due to how Business Central processes GST/HST and PST (Provincial Sales Tax) in multiple stages.

Final Invoice with Prepayment

When processing a final invoice for a purchase order that has prepayment(s), ExFlow does not use the prepayment factbox to show the reduction. Instead, ExFlow automatically creates a negative line in the Import Journal with the prepayment amount.

This approach ensures that:

• Tax amounts (GST/HST and PST) are correctly calculated and offset
• Business Central's multi-stage tax processing for Canadian tax areas is properly handled
• The final invoice correctly reflects the remaining amount to be paid after prepayment deductions

Example:

• A purchase order with 100% prepayment is created with Tax Area Code "BC" (British Columbia)
• GST and PST are calculated separately by Business Central
• When the final invoice is imported, ExFlow adds a negative prepayment line to properly offset the prepaid amounts and taxes

This behavior is specific to Canadian (and US) environments. For all other localizations, ExFlow uses the standard factbox approach without adding a negative line.

Read more about prepayment invoices under section Prepayment Invoices