News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How do i generate an A...

Microsoft Dynamics GP (Archived)

How do i generate an Analytical Accounting report with corresponding transactions

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I have tried generating a report from smart list that has details of associated transactions e.g payable ,purchases etc in order to have an overview of individual projects expenses before its transferred into fixed asset.

N/B I have several projects on going and have a unique identifying code in the analytical accounting but generating all the transactions associated to this individual projects is a pain and prompted to waste alot of time.Any suggestion on how this can be done easily and steps involved?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Imad Kassoumah 3,235 on at

Like (0)

Report

RE: How do i generate an Analytical Accounting report with corresponding transactions

Hi,

Writing an SSRS reports is suitable and easy to export to Excel for more analysis.

Imad Kassoumah
Mick Egan 3,557 on at

Like (0)

Report

RE: How do i generate an Analytical Accounting report with corresponding transactions

I ended up creating my own View linking all the AA tables with the Account Master, didn't go back to the actual Sub Ledger and that took a bit of work.

Then added this as a Smartlist using SmartList Designer.

Mick

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans