SQL view syntax for best index/summing performance

dashenk23

Hello,

I'm new to creating SQL views for NAV and was looking for informationon the best way to sum data from a NAV table. The view will be taking data from the Job Ledger Entry table Line Amount (LCY) field and will be looking to sum data by Job, for a certain range of g/l accounts. I'm able to obtain data from the table, but it looks like it is always coming across using the primary key Entry No....any advice would be much appreciated.

stryk

Hi,

well, since you are new to Views and SQL "stuff" maybe Waldo's article here could give you a starting point:
http://dynamicsuser.net/blogs/waldo/archive/2008/11/08/how-to-display-an-sql-server-view-in-microsoft-dynamics-nav.aspx