News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Show Lowest And Higest...

Finance | Project Operations, Human Resources, ...

Unanswered

Show Lowest And Higest PurchPrice In Report AX 2012

(0) Share

Report

Report

Posted on by AXx

95

hi Experts,

I Have Purchase Order Report In which I want to show Higest and lowest PurchPrice

Can any one guide me how to get Higest and Lowest PurchPrice against item

For Example

One Item "ITEMNAME" it has 3 PurchPrice , 1200 , 1300, 1400

how can I get lowest 1200, and higest 1400 against this Item

All responses Img

All responses (3)

Answers Img

Answers (0)

AXx 95 on at

Like (0)

Report

RE: Show Lowest And Higest PurchPrice In Report AX 2012

I have 5 hundered plus items which are purchased , and many of them items are purchased many times on different prices i want to show higest and lowest price against items ??
HenryXie on at

Like (0)

Report

RE: Show Lowest And Higest PurchPrice In Report AX 2012

Hi AXx, show the value on the report you can overwrite processReport method in report data provider class.

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-use-a-report-data-provider-class-in-a-report

for query the price, I think you can use select firstOnly from table order by price.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Show Lowest And Higest PurchPrice In Report AX 2012

Hi,

The highest and lowest price depend on the period for which you want to analyze the data.

You thus need to consider the time range to identify the highest and lowest price in my opinion.

Best regards,

Ludwig

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2

Martin Dráb 232,038 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans