Join Financeaccount table to a date/period table

Business Central/NAV User Forum
1

I want to download period totals from Gl to excel throug ODBC. In the financeaccount table I have found the total values per account, but how do I join this to a date/period information ??

2

quote:

Originally posted by Frank_E_Jensen: I want to download period totals from Gl to excel throug ODBC. In the financeaccount table I have found the total values per account, but how do I join this to a date/period information ??

Try a SQL Query like this (simplified): SELECT GLAccount.No_, GLAccount.‘Net Change’ FROM “G/L Account” GLAccount WHERE (GLAccount.‘Date Filter’ =‘01.01.02…31.03.02’)