web
You’re offline. This is a read only version of the page.
close
Skip to main content

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

I have the same question (0)
  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    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

  • Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans