web
You’re offline. This is a read only version of the page.
close
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 GP (Archived) / Item Class Codes
Microsoft Dynamics GP (Archived)

Item Class Codes

(0) ShareShare
ReportReport
Posted on by Katie Pieczynski 3,225

Hello,

I have a list of Item Class Codes that I need to add a 6th Digit too.

We are strictly doing this for our "web" service as it will not affect anything in GP

So for example my list of class codes right now are:

11CCA

11MZI

12CLJ

I need to add a W on to the end of all of these.  I thought I could create a Macro to upload them all as the only thing that is changing is the ID, all the other information will stay the same, but it seems that you can not edit an existing class code.

-------------------------------------------

Katie Pieczynski

Accounts Receivable Manager

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Katie,

    That is correct, you cannot edit existing class codes. If you are going to attempt it in SQL, be sure you change it in all of the applicable tables. For sure the tables include

    RM00101

    SOP00200

    SVC00651

    SVC00654

    You  may have more depending on which modules/products you have installed.

    Kind regards,

    Leslie

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    While Leslie is correct if you are CHANGING your class IDs, If you need to add more, duplicating the existing ones but with an extra character, export them from the Class code table to excel, add the W to the end of the 3 ids and import them back into the same table.  You will now have 6 IDs

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hello,

    Through Macro you can make it possible.

    1. Create new class code and assign same setup as old.

    2. Export your Item with class using smart list

    3. Change Old Item Class with New One in Excel

    4. Use word mail-merge  and Macros to assign new class to items

    blogs.msdn.com/.../how-to-use-word-mail-merge-and-macros-to-import-data.aspx

    Thanks

    Sandip

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans