BIDA Forums › Forums › Technical Topics › 2-Databases › 2-SQL Server › P0043 – Grouping for Totals for direct query into the GL
Tagged: businesscentral, direct query, sqlserver
This is the post on the BC forums.
In this post I decode the totaling field and then summ the values in the GL accounts to their parents.
Not a bad bit of SQL even if I have to say so myself.
https://community.dynamics.com/forums/thread/details/?threadid=0cb056d2-d5ff-ee11-a1fd-7c1e52184eaf
Best Regards Peter Jones