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 / Small and medium business | Business Central, N... / Change Department
Small and medium business | Business Central, N...
Unanswered

Change Department

(0) ShareShare
ReportReport
Posted on by MJM-IHB 5

What is the SQL script to change department and category for a large batch of selected items ?

Thank You.

  • MJM-IHB Profile Picture
    MJM-IHB 5 on at
    RE: Change Department

    Yes. I am aware of worksheet 250.

    I can manually create new departments as there aren't many.

    I need the script to move 3000 active items to the newly created departments

    Item  ID is no issue

    Thanks

  • kf5ydu Profile Picture
    kf5ydu 30 on at
    RE: Change Department

    If you are using HQ keep in mind that you will need to send down a 250 worksheet to make the changes take effect at the store. Do you know the IDs or do you want a script that uses the department and category names? Also how are you defining the batch of items?

  • MJM-IHB Profile Picture
    MJM-IHB 5 on at
    RE: Change Department

    Will do . Thank You

  • ToddB Profile Picture
    ToddB on at
    RE: Change Department

    HI MJM-IHB,

    There are multiple tables involved in this.

    Please create a support incident if you would like assistance from Microsoft in creating the Update scripts.

    The support number is 888-477-7877.

    pastedimage1624593358935v2.png

    pastedimage1624593273230v1.png

  • MJM-IHB Profile Picture
    MJM-IHB 5 on at
    RE: Change Department
    [quote user="MJM-IHB"]

    What is the SQL script to change department and category for a large batch of selected items ?

    Thank You.

    [/quote]

    Yes. Headquarters..

    Yes. From Department /Category to newly created Department / Category.

    The first batch of 1504 SKUs need to be altered to the new Department / Category 

    Thank You

  • ToddB Profile Picture
    ToddB on at
    RE: Change Department

    Hi MJM-IHB,

    Are you using Headquarters?

    Are you changing one Department/Category to one other Department/Category?

    How many items?

    ______________________________________________

    Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

    https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs
     
    pastedimage1624300474462v1.png

    This is around 3 weeks from now; and you can continue using RMS after this date, but technical support will not be available.

    I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans