Skip to main content

Notifications

Microsoft Dynamics RMS forum

HQ Store Tax

Posted on by Microsoft Employee

Mabuhay! 

Is there any advance way to edit mass Store Tan on HQ Manager? We are doing it on a manual way which in every item we newly encode we setup Store Tax based on how many our branches is. So if we meet the 100 branches that's the times we manually edit the store taxes to vat or non vat.

We try to explore the sql table but unfortunetaly theres no hint on how to edit it thru sql. Does anyone done this already? Any help on this? 

Thank you!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Tax

    Mabuhay Sir Ed,

    Hi! Just recently run sql script inserting new items and run worksheets 250 and after the brnach received the data it can be now punch at the POS. Only taxable and taxid will decalre their tax details. 1, and 2 values. After reading it says it is the correct amount also.

    Is there any conflict or problem will soon arise with this process? No encoding now will be done via NEW on Hq manager and no Store taxes being declare. Only thru sql insert command.

    Thanks,

    Chris

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Tax

    Mabuhay! Hi! Is there any possible on creating a new items via sql it can accomodate to add store taxes?

    Or is it possible not to include store taxes ? Or after I insert new item on on HQ via sql is there any way I can update it via sql and adding store taxes?

    Thanks,

    Chris

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Tax

    You cant edit a tax on an item before it exists.  So the store has to have the item in order for you to do a update on that item.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Tax

    Mabuhay Sir Ed,

    Hi! Its a mass update and it will but is there a way it will update before this new item will be sent to store. So before they will get this items it has been edited here in HQ.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Store Tax

    have a look at Inventory wizard.  

    HQ Manager -> Wizards -> Inventory Wizard

    OR  if under a newer version then use the Worksheet Style 320.  

    Both of these will step you through assigning a sales tax to a group of item.  You can even use a custom filter and filter by store.   The newly assigned sales tax will over-write the old value.  

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans