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

Announcements

Introducing our New Video Series: Community Spotlight
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,998 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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans