gflorez 6/15/2021 8:10:06 AM

Account balances by accounts, AA dimensions, and by period

Hello Developers, 

 

Trying to pull a query to get balances by account for each dimension in analytical account by period.  Has anyone written an SQL statement(s), view or TVF or SP to generate such dataset ?

Ideas, comments, suggestions, welcome! 

 

Thank you! 

Version: GP 2013
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3