How do i generate an Analytical Accounting report with corresponding transactions

(0) Share

Report

Posted on by Community Member

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 (2)

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,561 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