Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Dynamics NAV 2013 R2 :...
Microsoft Dynamics NAV (Archived)

Dynamics NAV 2013 R2 : Canada GST Calculation based on Ship to Address.

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

In Dynamics NAV 2013 R2 we created

Tax Group (eg. Finished Goods)

Tax Jurisdictions (eg. Ontario, Quebec, BC etc..)

Tax Details (taxes based on Each Province) and Tax Areas.

Assigned Tax Area [Ontario Tax Area Assigned to Ontario Jurisdiction when the Sell-to-Customer is in Ontario) to a specific Customer wherein the taxes are getting calculated based on the provided tax rate.


However, We need to calculate tax based on Ship to Address and NOT Customer's address. Ship to Address ALWAYS change in EVERY Order (being B2B Business). 

We then tried to assign all Canadian province jurisdictions to a Single Tax Area 

(eg. Tax Area = Canada with Ontario, Quebec, BC etc...tax jurisdictions) and assigned the Canada Tax Area to a specific customer but while processing orders the system comes up with "Index Out of Bounds" error.

Any help to solve this tax calculation would be much appreciated.

Thanks,

Neil

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Dynamics NAV 2013 R2 : Canada GST Calculation based on Ship to Address.

    In Tax Area Locations, we define which tax shall be applicable.

    It worked in Indian Localisation, amy be didn't work as it is Canada Localisation.

    The setup in Indain Localisation was as follows:

    Defining Sales Tax (VAT/CST)

     

    1. Search “States”

      Enter Code, Description, State Code, and details of Tax Account (Sales), CST Account (sales), Tax Account(Purchases) etc. here.

       

    2. Search “Tax Groups”

      Create Tax Groups for VAT and CST

       

    3. Search “Tax Jurisdiction”

    Particulars

    Example

    Code

    KLCST

    Description

    Kottayam CST

    Tax Type

    CST/VAT (Selected from Dropdown)

    Tax Component

    CST/VAT (Selected from Tax Component table)

    State Code

    KL (Selected from listed States defined through Step 1)

     

     

     

     

    1. Clicking on selected “Tax Jurisdiction”, Navigate to “Details”

      Tax Details Window is opened.

    Particulars

    Example

    Tax Jurisdiction Code

    Automatically populated

    Tax Group Code

    Selected from the Tax Group created in Step 2

    Form Code

    Wherever applicable

    Tax Below Maximum

    CST Rate 4% (Enter relevant rate)

     

     

     

     

     

    5. Search “Tax Area”

          Click on “New”

     

    Particulars

    Example

    General

     

    Code

    CST

    Description

    CST

    Lines

     

    Tax Jurisdiction Code

    Selected from “Tax Jurisdictions” created

    Jurisdiction Description

    Automatically populated

     

     

     

       6. Tax Area Locations

    Particulars

    Example

    Type

    Customer/Vendor

    Dispatch/ Receiving Location

    location of the dispatch warehouse or receiving warehouse

    Customer/Vendor Location

    State code of Customer or Vendor

    Tax Area Code

    Applicable Tax Area

     

     

     

     

    Make sure you select the Location in Shipping Fast tab..

    I think you may figure some ideas for Canada localisation

  • Community Member Profile Picture
    Community Member on at
    RE: Dynamics NAV 2013 R2 : Canada GST Calculation based on Ship to Address.

    Thanks but it doesn't work.

  • Community Member Profile Picture
    Community Member on at
    RE: Dynamics NAV 2013 R2 : Canada GST Calculation based on Ship to Address.

    Hi Neil,

    Did you try Location?

    Tax Area Location...

    In invoice, select the 'Shipping Fast tab' and select the Location of Ship to Address..

    I think this would help

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans