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
Hi AXx, show the value on the report you can overwrite processReport method in report data provider class.
for query the price, I think you can use select firstOnly from table order by price.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (