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) / 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 237,892 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

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