web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Abdul Shakoor Profile Picture
    Abdul Shakoor 365 on at
    RE: SQL query for item to unit conversion?

    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

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 48,313 User Group Leader on at
    RE: SQL query for item to unit conversion?

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

  • raff Profile Picture
    raff 1,236 on at
    RE: SQL query for item to unit conversion?

    :) 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 48,313 User Group Leader on at
    RE: SQL query for item to unit conversion?

    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
    RE: SQL query for item to unit conversion?

    hi Sohaib

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

    mal

  • raff Profile Picture
    raff 1,236 on at
    RE: SQL query for item to unit conversion?

    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)

  • Verified answer
    KCDeVoe Profile Picture
    KCDeVoe 1,450 on at
    RE: SQL query for item to unit conversion?

    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.

  • Suggested answer
    KCDeVoe Profile Picture
    KCDeVoe 1,450 on at
    RE: SQL query for item to unit conversion?

    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.

  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,313 User Group Leader on at
    RE: SQL query for item to unit conversion?

    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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans