You’re offline. This is a read only version of the page.
Hello everyone,
We are using Analytical Accounting on Dynamics GP, recently tried to create a report based on Analytical Accounting with all ledger items (Financial, Purchases & Sales) on hosted environment - Citrix (Seller of Dynamics). We were now informed that Management reporter only handles 'Financial' items under Analytical Accounting not purchases or Sales, we were advised to use Smartlist in acquiring data through SQL tables query that they had to build. Does anyone have similar problems extracting data across the modules?, also has anyone been able to build Management reporter with Analytical Accounting across all 3 ledgers?.
We are facing charges for reports pertaining to Analytical Accounting where SQL is required to merge or add tables outside Financials which hold Analytical Accounting.
Your responses would be much appreciated.
Thank you kindly.
*This post is locked for comments
I have the same question (0)
>We were now informed that Management reporter only handles 'Financial' items under Analytical Accounting not purchases or Sales
This is correct.
> also has anyone been able to build Management reporter with Analytical Accounting across all 3 ledgers?.
MR can not do this.
>advised to use Smartlist in acquiring data through SQL tables query that they had to build.
Depending on your volume this *can* work. SSRS would probably work better because your developer can optimize the tables better than from Smartlist. Dynamics GP tables with AA are not indexed efficiently out of the box.
With that being said, you should be able to easily join the transaction tables in the subledgers to the AAG2xxxx series tables. AAG20000 has the docnumbr column which will link to the docnumber in the various subledgers. (purchasing, sales and fixed assets) The Series and Doctype columns hold what subledger they are from...I don't use sales with AA so I can't help you there.
Share
Report
All responses (
Answers (
1,515
