Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Setting up sales/use tax tables

Posted on by 45

Can anyone point me to good knowledgebase articles or other resources about setting up sales and use taxes?  Specifically, we are trying to integrate sales tax reporting into our AP processing.  We have a significant amount of use tax (self reported sales tax).  Currently, we are grossing up the voucher line for the tax rate, and then creating a credit line that goes to use tax payable account.  At the end of the month, we pull the amount in the use tax payable account and pay to the state.  It is working , but I'm wondering if there is an easier way?

I established a tax ID for use tax, but it is increasing the amount due to the vendor at the voucher level.  This does not work because we are paying vendor for material only, the rest goes to the state at the end of the month.  Is there a way to indicate that this is a self assessed tax?

Also, on the tax maintenance screen (21.280.00), purchasing tab, I left the tax expense account blank.  When the voucher posts, it posts the tax portion to the same GL account that the item posts to.  That is how we account for tax, so that works for us.  However, the tax portion does not pull through the project and task.  Is there a way to get the project to pull through?

Thanks in advance for your help.

Elizabeth

*This post is locked for comments

  • brent_quick Profile Picture
    brent_quick 180 on at
    RE: Setting up sales/use tax tables

    mbs2.microsoft.com/.../KBDisplay.aspx

    This post is now what comes up first.

  • Re: Setting up sales/use tax tables

    Hi Elizabeth,

    I went to Bing.com and searched on 869020 use taxes.  The article was the first in the list.  Let me know if you find it or not.

  • Elizabeth Carter Profile Picture
    Elizabeth Carter 55 on at
    Re: Setting up sales/use tax tables

    Carolyn - Thanks for your response.  Silly question - how do I get to that knowledge base article?  It is not coming up when I put the article ID in the search field.  

    The project not updating - currently I have no expense account in the Tax ID setup screen.  So I created a voucher to office supplies account, office location project and set the tax ID to add taxes.  The line for taxes (the one that auto-posts when the voucher posts) posted to office supplies account, but the project field was blank.    Wondering if there is a way for the tax line to post to a specific project.

    Thanks,

    Elizabeth

  • Re: Setting up sales/use tax tables

    Hi Elizabeth,

    What you describe in your first paragraph is one way to handle sales and use taxes in Dynamics SL.  There is a Knowledge Base article number which describes two other possible methods.  The KB article is 869020.  

    Let me know what you think.  I'm not sure I understand what you are describing about the project not being updated.  Is this related to what you are describing in the second paragraph?  There is no place to tell the system it is a use tax.  SL doesn't have any functionality directly to handle use taxes.

    There might be a third party product.  Does that interest you?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans