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) / SQL query for item to ...
Microsoft Dynamics AX (Archived)

SQL query for item to unit conversion?

(0) ShareShare
ReportReport
Posted on by raff 1,236

hi

when i look at the table UNITOFMEASURECONVERSION to try an retrieve all of a products uom conversions

it does not show me the itemids, any one know how i would be best pull out this data?

is there a sql resource that i could use for ax in future that helps with useful sql queries etc - ax has so many tables it can be mind boggling! :)

thanks

mal

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    i am not sure why you are writing queries on sql

    but for your question you need to join this table with UnitOfMeasure, two times

    once for FromUnitOfMeasure and secondly for FromUnitOfMeasure

  • Suggested answer
    KCDeVoe Profile Picture
    KCDeVoe 1,450 on at

    If you want the ItemId there's a relation between the UnitOfMeasureConversion table with the EcoResProduct table on UnitOfMeasureConversion.Product to EcoResProduct.RecId. The from there it's a link between InventTable and EcoResProduct to get your ItemId.

  • Verified answer
    KCDeVoe Profile Picture
    KCDeVoe 1,450 on at

    I should point out you could probably just go UnitOfMeasureConversion.Product to InventTable.Product. Don't necessarily need EcoResProduct in the middle unless you need information from there.

  • raff Profile Picture
    raff 1,236 on at

    THANKS kevin

    i had never looked at this product field before - i was just working off itemid! (will eventually get around the structure with a bit more time)

  • raff Profile Picture
    raff 1,236 on at

    hi Sohaib

    how would you propose i extract custom data sets from AX? always like to hear of a better way :)

    mal

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    man.....my bad

    seems I was 'sleepy head' last nigh as I suggested you to join it with UnitOfMeasure

    which is totally wrong. that was needed in case if you were looking for unit or measure id.

    while you were looking to join it with inventory items.

    my bad

  • raff Profile Picture
    raff 1,236 on at

    :) thats ok, why did you say - not sure why you are writing queries? is there an easier way for me to build custom data sets etc in ax?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    of course you can create dataset and you can create VIEWS inside ax, which you can use anywhere further.

  • Abdul Shakoor Profile Picture
    Abdul Shakoor 365 on at

    Dear i want to get data from  table where i  need 

      product id,   

      unit of conversion (  like   meter  to box)  or what ever conversion i select there 

    any help

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