Hi Folks -
My client are on NAV 2009 Classic and they are using SQL server 2008 R2, they want to create a SQL script to extract information from G/L account table and want the 'Net change' field filtered by Global dimension filter = 'WA'. When they go to SQL they dont see the Net change field as its a flowfield. Can someone please let me know how they should create the SQL script in order to extract the information.
Any help is highly appreciated.
S.
0
Comments
http://www.mibuso.com/forum/viewtopic.php?f=23&t=44678
I saw the topic where I replied but I didn't spot that detail. Same user!
I promise not to reply next month!
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool