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) / Extracting items and p...
Microsoft Dynamics AX (Archived)

Extracting items and prices

(0) ShareShare
ReportReport
Posted on by Lionel07 495

Hello Experts,

I am completely new to Microsoft Dynamic and is learning a I go alone.

I have a urgent request to pull some data from a SQL database. here is the request....

I need to know how to pull all items and their prices from DAX using SQL database. here is what i have done but this is not correct because it does not reflect the prices in DAX.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT DISTINCT [PRODTABLE].NAME, INVENTITEMPRICE.PRICE  FROM [AGDAX2012_Live].[dbo].[INVENTITEMPRICE],[PRODTABLE]
  WHERE  INVENTITEMPRICE.ITEMID = PRODTABLE.ITEMID

Any help or sugession oon this is greatly appreciated.

 

*This post is locked for comments

  • Martin Dráb Profile Picture
    Martin Dráb 233,599 Most Valuable Professional on at
    RE: Extracting data from Microsoft DX

    One thing you should learn is that you shouldn't access AX database directly; you should always go through the application server. It's less work for you (you don't have to manually handle partitions, data area IDs, table inheritance etc.), it will apply security, you'll see enum element names instead of just numbers and so on.

    You can use the Data Import Export Framework to export data from AX.

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Extracting data from Microsoft DX

    Hi,

    Please use the view INVENTITEMPRICEACTIVE to get the active prices of items(filter on field pricetype where enumvalue 0 refers to cost & 1 refers to purchase price and field dataareaId to specific company).

    Thanks,

    Chaitanya Golla

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans