Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / "Cascading" ...
Microsoft Dynamics GP (Archived)

"Cascading" Class Id

(0) ShareShare
ReportReport
Posted on by Matt Reamy

I can't imagine I'm the only person looking to organize my inventory this way.  I did a quick search, but didn't find anything.

I'm setting up an eConnect application and I'm trying to map out my current product table to the various GP inventory classes.  I don't see a method to cascade product: we have a product type value and then a product category.  I don't see any way to try to maintain this in GP.

The Class ID field appears to only be one level.

Has anyone else managed this? 

*This post is locked for comments

  • Suggested answer
    Matt Reamy Profile Picture
    Matt Reamy on at
    Re: "Cascading" Class Id

    Thanks, Tim.

    We heard back from a number of our support team who indicated what I want to do, GP isn't capable of doing.  It seems ridiculous to me that it isn't -- as I mentioned in my original post, I have a hard time thinking that I'd be the only one looking to do that.

    The user-defined fields seem to be the only way to narrow the scope, as you say; I'd considered it, but wasn't happy with the potential outcome.  I'd also considered the two-tier class ID and dropped that idea nearly at once (but thanks for mentioning it).  

    Ultimately, I think we agreed on merging the lists.  The entire culture around my company's industry seems to eschew technology to varying degrees, and whatever documentation's left around doesn't get read.  

    While I have come or am coming to terms with the undesireable answer that what I want to do can't be done in GP, can someone perhaps shed some light on why this was designed with this limitation?  Is it an accounting principle that all products are on the same level?  Or is it a limitation that's been grandfathered in from the very early days of GP?  

    KBO

  • Verified answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: "Cascading" Class Id

    We used the user defined fields on the Item Card for that.  You should set up in a test environment and see if this will do what you want.  You get five fields and you can use them to filter the more important Inventory Reports.  You would have to develop custom reports to sort on these fields.  Or have your application custom sort.

    You could add a second level (sort of with some careful planning) by naming the classes carefully.

    eg, GOLF-CLUBS, GOLF-BALLS, GOLF-BAGS, FOOTBALL-BALLS, FOOTBALL-HELMETS.

    Going more then 1 deep would get complicated and cryptic (only 10 characters to use).  Only Item listing reports can be filtered by Class ID, so not of much use.

    Tim

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans