How to run SQL quary using NAV ?

Hi Expert ,

I want to run SQL quary(“select sum(Quantity) as Stock from [CRONUS International Ltd_$Item Ledger Entry] where [Item No_] =‘1968-S’”) using NAV Service/Object. is it possible ? if yes then how it can be possible ?



Which version are you using?

Using ADO connection you can run SQL Queries.

Hi expert,

i am using NAV 2009 R2



Did you try above link?

Is it working?

From what environment are you trying to run this statement?