web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Canadian provincial sales tax setup

(0) ShareShare
ReportReport
Posted on by 495

I'm setting up sales tax for a Canadian company.  I'm struggling to configure sales tax to accommodate the posting requirements for PST.

Tax Type A - GST
GST is a VAT-style tax in Canada.  Applicable entries are summarized as follows for a $100 purchase + 5% GST (total of $105):

DR  Office supplies         100
DR  GST paid on purchases     5
CR  Accounts Payable       -105 

* I am able to correctly set up this tax type

Tax Type B - PST
PST (provincial sales tax) is not a VAT-style tax.  Any PST amounts paid are not recoverable.  The applicable entries are summarized as follows for a $100 purchase + 5% PST (total of $105):

DR  Office supplies         105
CR  Accounts Payable       -105 

* I am NOT able to correctly set up this tax type.  

Combined GST & PST
Here's an example of how a purchase of office supplies in Saskatchewan works.  The purchase is for $100 + 5% GST + 5% PST (total of $110):

DR  Office supplies         105
DR  GST paid on purchases     5
CR  Accounts Payable       -110 

I understand there's a GL Parameter called "Apply US taxation rules" but all it does is force the PST value into a GL account specified on the sales tax Ledger Posting Group.  This is incorrect however, the PST value needs to be included in the DR to Office Expenses.

Hope I've been clear here...my issue is properly setting up PST.

Thanks

*This post is locked for comments

I have the same question (0)
  • Steve Stallard Profile Picture
    40 on at

    I think I understand what the problem you are having. there is a setting that allows you to Tax on Tax

  • Heather Gamache Profile Picture
    10 on at

    I am struggling with the same issue but I don't see a solution posted.  It is not a tax on tax issue.

  • Steve Stallard Profile Picture
    40 on at

    Hi Heather,

    We have been working with Microsoft on this and they supplied a hotfix for this issue Jan 27th

    hotfixv4.microsoft.com/.../472468_intl_i386_zip.exe

  • Aaron Goudreau Profile Picture
    495 on at

    I figured this out.  There's a field on the Sales tax code setup which needs to be set to "expense" sales tax instead of "capitalize" it.  I use quotes because the requirement is not really to expense vs. capitalize, but to have the PST portion coded to the same GL as the debit from the transaction (assuming it's a purchase of some sort).  So in the example above, the 5 PST needs to be coded to Office Supplies.  

    GL-Setup-Sales tax-Sales tax codes: Values button.  If you set the field "Pct exempt from sales tax" to 100, AX will "expense" the 5 for that sales tax code.  Questionable name for the field, but when you set it and post an AP invoice journal with that sales tax code used, you'll see it works when you see the coding of the voucher.  The debit relating to the sales tax (PST) is coded to the same account as the main "expense".

    Cheers

  • Heather Gamache Profile Picture
    10 on at

    Aaron I already had that set up.  I have found if I leave all the ledger posting accounts blank I can get the postings I want but then it doesn't work for sales.  I can set up a different code for sales but that would be setting all my sales taxes up double.  Am I missing some other set up?

    Steve we are on CU7 so we should already have the hot fix.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans