Tax logic in Infor e-Commerce

In Infor e-Commerce tax calculation and display is based on the following three conditions:

  • The user is configured as taxable (Is Taxable=Yes) or non-taxable (Is Taxable=No) .

    The "Is Taxable" is true, the line tax is calculated on the line price. i.e. Total Price Tax.

  • The "Tax Handing" feature element is "true" or "false".

    If "Tax Handling" is "true", VAT is included on all prices shown to the user.

    • Line tax is added to the line price and the total is shown as Order Total.

    • Delivery Tax is added to the Delivery Fee and total shown as Delivery Fee.

    • Shipping Tax is added to the Shipping Fee and shown as Shipping Total.

  • The "Display Tax" feature element is "true" or "false".

    If "Display Tax" is "true", the total tax (Delivery Tax+Shipping Tax+Total Line Tax+Discount Tax) is displayed as VAT Total throughout the order flow on the Order Form, Shipping Details, Order Confirmation and Order Acknowledge pages.

The tax is calculated in such a way that the Grand Total accounts to the sum of the line total including Order Total, Delivery Fee, Shipping Fee and Discount.

In an ideal B2B scenario, the Order Total is shown excluding the line tax and a separate row showing the VAT Total is displayed. The Grand Total accounts to the sum of Order Total, Delivery Fee without Delivery Tax (if applicable), Shipping Fee without Shipping Tax (if applicable), Discount Total and VAT Total.

In the B2C scenario, the Order Total includes the line tax. A separate row with the VAT Total is not displayed to the consumer user. The Grand Total accounts to the sum of Order Total, Delivery Fee with Delivery Tax (if applicable), Shipping Fee with Shipping Tax (if applicable), and Discount Total.

The details of the tax-calculation logic are coded within the Infor e-Commerce at design time. If you require a change in the way taxes are calculated in your application, please contact your Infor e-Commerce consultant. However, you can do basic tax administration, such as assigning rates and tax groups, using the Business Center, as described in the sections below.

Scenario Order form page Shipping details page

Is Taxable = Yes

Tax Handling = False

Display Tax = True

  • Order Total = Sum of line price excluding total line tax

  • Discount Total

  • Delivery Fee = Delivery Fee

  • VAT Total = Delivery Tax + Total Line Ta x+ Discount Tax(if applicable)

  • Grand Total = Order Total + Delivery Fee + VAT Total-Discount Total

Note that the VAT Total row is displayed only if the value is greater than zero.

  • Order Total = Sum of line price excluding total line tax

  • Discount Total

  • Delivery Fee = Delivery Fee

  • Shipping Total=Shipping Fee

  • VAT Total = Delivery Tax + Total Line Tax + Shipping Tax + Discount Tax(if applicable)

  • Grand Total = Order Total + Delivery Fee + Shipping Fee + VAT Total-Discount Total

In addition, a VAT column showing the line tax is displayed for each orderline.

The VAT Total row is displayed only if the value is greater than zero.

The VAT Total row is displayed only if the value is greater than zero.

Is Taxable = Yes

Tax Handling = True

Display Tax = True

Order Total = Sum of line price including total line tax

Discount Total

Delivery Fee = Delivery Fee + Delivery Tax

VAT Total = Delivery Tax + Total Line Tax + Discount Tax (if applicable)

Grand Total = Order Total + Delivery Fee - Discount Total

Note: The VAT Total row is displayed only if the value is greater than zero.
  • Order Total = Sum of line price including total line tax

  • Discount Total

  • Delivery Fee = Delivery Fee + Delivery Tax

  • Shipping Total = Shipping Fee + Shipping Tax

  • VAT Total = Delivery Tax + Total Line Tax + Shipping Tax + Discount Tax (if applicable)

  • Grand Total = Order Total + Delivery Fee + Shipping Fee -Discount Total

In addition, a VAT column showing the line tax is displayed for each orderline.

The VAT Total row is displayed only if the value is greater than zero.

Is Taxable = Yes

Tax Handling = True

Display Tax = False

  • Order Total = Sum of line price including total line tax

  • Discount Total

  • Delivery Fee = Delivery Fee + Delivery Tax

  • Grand Total = Order Total + Delivery Fee - Discount Total

  • Order Total = Sum of line price including total line tax

  • Discount Total

  • Delivery Fee = Delivery Fee + Delivery Tax

  • Shipping Total = Shipping Fee + Shipping Tax

  • Grand Total = Order Total + Delivery Fee + Shipping Fee -Discount Total

In addition, a VAT column showing the line tax is displayed for each orderline.

Is Taxable = No

Tax Handling = False

Display Tax = True

  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • VAT Total = Delivery Tax + Discount Tax (if applicable)

  • Grand Total = Order Total + Delivery Fee + VAT Total - Discount Total

Note that the VAT Total row is displayed only if the value is greater than zero.

  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • Shipping Total = Shipping Fee

  • VAT Total = Delivery Tax + Total Line Tax + Shipping Tax + Discount Tax (if applicable)

  • Grand Total = Order Total + Delivery Fee + Shipping Fee + VAT Total - Discount Total

In this case, the VAT column displays the line tax as zero as line tax is not calculated.

Note: The VAT Total row is displayed only if the value is greater than zero.

Is Taxable = No

Tax Handling = True

Display Tax = True

  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • VAT Total = Delivery Tax + Discount Tax (if applicable)

  • Grand Total = Order Total + Delivery Fee + VAT Total - Discount Total

Note: The VAT Total row is displayed only if the value is greater than zero.
  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • Shipping Total = Shipping Fee

  • VAT Total = Delivery Tax + Total Line Tax + Shipping Tax + Discount Tax (if applicable)

  • Grand Total = Order Total + Delivery Fee + Shipping Fee + VAT Total - Discount Total

In this case the VAT column displays the line tax as zero as line tax is not calculated

The VAT Total row is displayed only if the value is greater than zero.

Is Taxable = No

Tax Handling = True

Display Tax = False

  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • Grand Total = Order Total + Delivery Fee + Delivery Tax -Discount Total

  • Order Total = Sum of line price

  • Discount Total

  • Delivery Fee = Delivery Fee

  • Shipping Total = Shipping Fee

  • Grand Total = Order Total + Delivery Fee + Delivery Tax + Shipping Fee + Shipping Tax - Discount Total

In this case the VAT column displays the line tax as zero as line tax is not calculated.