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 AX (Archived) / Inventory and Non-Inve...
Microsoft Dynamics AX (Archived)

Inventory and Non-Inventory items

(0) ShareShare
ReportReport
Posted on by AdnDalhi 336

Hi All, 

I have a functional question (Inventory / Non-Inventory) items, if you can help, i will be very grateful.

I would like to know how can i understand if a product exist in stock or not, it's the searching in (InventSum) table i can get all the products who has stock ? 

Is there any field in InventTable or InventSum table to know if this product exist in Stock or Not ? :)

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    If you need to simply know if an item is inventory / non-inventory item, you can find it at the Item's ItemGroup. docs.microsoft.com/.../set-up-items-and-services-for-not-stocked-trade  The Checkbox 'Stocked product ' will answer this question.

    Further, Inventory items can also have 0 onhand (from InventSum). This doesn't mean, it is a non-inventory item.

    On the other Hand Non-Inventory items do not have any entry in InventSum at all.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Thank you for your reply, so to know if a product On hand Inventory or not just by checking the Item Model Group field in InventTable. ?

  • Verified answer
    Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    I guess, you are using the wrong words.. But I got your question.

    No, just the ItemGroup at InventTable won't tell you anything. You have to navigate to the ItemGroup master, and look at the Checkbox "Stocked product". If this is checked, it is an inventory Item.

    Youcan safely ignore Inventsum table for the Moment.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Thanks Crispin

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Hi .Crispin, can you please, identify to me the difference between the inventTable and InventSum tables.

    and which one of them i need to use to retrieve only OnStock products.

    Thanks.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Also, if i'm obliged to make join ON InventTable and InventSum (InventTable.ItemId = InventSum.ItemId), to retrieve only the onStock products?.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Crispin, i would like to check with me. if using this join is safe to retrieve or check OnHand/Not OnHand items.

    JOIN 1 between InventTable & InventModelGroupItem

    JOIN 2 between InventModelGroupItem & InventModelGroup

    and then test on boolean field " StockedProduct " on " InventModelGroup ".

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Crispin, i would like to check with me. if using this join is safe to retrieve or check OnHand/Not OnHand items.

    JOIN 1 between InventTable & InventModelGroupItem

    JOIN 2 between InventModelGroupItem & InventModelGroup

    and then test on boolean field " StockedProduct " on " InventModelGroup ".

    Thanks a lot

  • Community Member Profile Picture
    Community Member on at

    Hi Crispin,

    Do you mean Item model group or Item group. Because the stocked product checkbox is available at Item model group.

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans