Monday 2 July 2018

How to get Product Variants from AX Using X++

Below is the X++ query for getting the product variants.


InventDimCombination inventDimCombination;
InventDim                     inventDim;

while select inventDimCombination

   where inventDimCombination.ItemId == '1000'

      join inventDim

          where inventDim.inventDimId == inventDimCombination.InventDimId

  {

      info(strFmt('%1 : %2 : %3 : %4 : %5',

             inventDimCombination.DistinctProductVariant,

             inventDim.configId,

             inventDim.InventColorId,

             inventDim.InventSizeId,

             inventDim.InventStyleId));     

  }

26 comments:

  1. It is not fetching if Product Type is Product , any help on that . i want to fetch all released product with product and product master both

    ReplyDelete
    Replies
    1. Please note that the InventDimCombination table contains only product masters. Not products.

      Also, products never contains dimensions (Color, style, size and configuration).

      If you want to get all the released product and product master details, please use InventTable.

      Delete
  2. can we find product variant against display product number ?

    ReplyDelete
  3. This is a great article thanks for sharing this informative information. I will visit your blog regularly for some latest post. I will visit your blog regularly for Some latest post. akgbuzz

    ReplyDelete
  4. Very interesting blog. Alot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know. Cannabis Edibles

    ReplyDelete
  5. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. Buy liberty caps

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. I read that Post and got it fine and informative. silicone bibs

    ReplyDelete
  8. If you are looking for more information about flat rate locksmith Las Vegas check that right away. queens marijuana dispensary

    ReplyDelete
  9. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! Innosilicon A11 Pro ETHMiner (2000Mh)

    ReplyDelete
  10. You understand your projects stand out of the crowd. There is something unique about them. It seems to me all of them are brilliant. Innosilicon A11 Pro ETHMiner (2000Mh)

    ReplyDelete
  11. I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. nike running shoe reviews

    ReplyDelete
  12. I have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks! ceramic heating element

    ReplyDelete
  13. Your post has those facts which are not accessible from anywhere else. It’s my humble request to u please keep writing such remarkable articles kitchen tapware

    ReplyDelete
  14. this is really nice to read..informative post is very good to read..thanks a lot! silver charms and beads

    ReplyDelete
  15. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. magic mushroom grow kit

    ReplyDelete
  16. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value. Im glad to have found this post as its such an interesting one! I am always on the lookout for quality posts and articles so i suppose im lucky to have found this! I hope you will be adding more in the future... weed for sale

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. Your work is truly appreciated round the clock and the globe. It is incredibly a comprehensive and helpful blog. Fait a la Main

    ReplyDelete
  19. This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. Spunlace fabric for wet wipes

    ReplyDelete
  20. There are particular dissertation website pages on the web guides have got seemingly uncovered inside the web-site. 加熱煙

    ReplyDelete
  21. A variety of dissertation web pages on-line as you're as well collect in plain english professed in the webpage. 加熱菸

    ReplyDelete
  22. It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait reading. I am impressed with your work and skill. Thanks. dark0de market url

    ReplyDelete
  23. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. Las mejores freidoras sin aceite de 2022

    ReplyDelete
  24. This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. get Waterlogged

    ReplyDelete

Adding a newline into a string in C# and X++

Below is the sample code we can use for  adding a newline after every occurrence of "@" symbol in the string in C#   using System...