Dynamics gp historical aged trial balance sql

Has anyone built these in smartlist builder and if so would you like to share them? Also, if anyone can point me in the direction of existing smartlist builder reports for Project Accounting that would be great.

Replies 4 All Responses Only Answers. Somakarpagamoorthy Kanagasabapathy responded on 17 Jun AM. Please have a look on the below links. Hope this helps!!! Thank you for you post. Then I have to explain to the client why my report doesn't match GPs. I imagine that would be true if RM history had been purged.

We've only been live on GP since Nov. But how far back would one really want to generate a Historical Aging? Our own installation includes only the invoices, credit memos, etc.

You are logged in to DynDeveloper. This step is required for credit card processing notification. Please visit the Account page and request an email verification email. Tools for working with Integration Manager. Code libraries How Tos Tutorials Sage advice from the most experienced coders around.

PM Tables. UPR Tables. IV Tables. Olympic Tables. Table Edits. Spider Log Out. NET Menu. WinForms Menu. Getting Email addresses from Dynamics GP.

Move a SOP transaction from open to history. Personalize Community Now. Visit Microsoft Learn. Kevin Dowson asked a question on 30 Nov AM. Hi, Bit of an odd query but does anyone have or no where I might be able to obtain the SQL query that runs behind the Detailed Historical Aged Trial Balance report for the purchase ledger? Thanks Kevin. Microsoft Dynamics GP Other. Replies 1 All Responses Only Answers.