web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AA reports
Microsoft Dynamics GP (Archived)

AA reports

(0) ShareShare
ReportReport
Posted on by Romryan

To All

I want to create an AA report that will list some codes row-wise and others column-wise (codes vs codes).

I have tried srss matrix report but report it proving a bit complicated.Is this possible?

RomRyan

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Can you please illustrate what is the data that you want to retrieve ? Could you please provide a descriptive table of the AA data to be considered ?

    Your feedback is highly appreciated,

  • Romryan Profile Picture
    Romryan on at

    Mahmoud,

    Below is the template

    CODES EXPENSES
    PERIOD TRAVELLED LOCATION COUNTRY TRAVEL TYPE ACCOMONDATION MEAL AIR FARE SECURITY TOTAL
    JAN AFRICA PRETORIA S.AFRICA A 230 670 659 451 2010
    FEB ASIA RIYADH S.ARABIA B 210 780 542 99 1631
    MARCH AMERICA NEW YORK USA D 345 689 568 787 2389
    APRIL EUROPE HELSINKI FINLAND C 55 321 11 323 710
    TOTAL       840 2460 1780 1660 6740
  • Romryan Profile Picture
    Romryan on at

    This one looks better

    The first row, Jan Africa trip,to pretoria south africa travel type A,accondation was 230,meal 670,air fare 659,security 451 and they adds up to 2010.

    RomRyan

    i.e 

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    The blue part of the report is well understood, I am not being able to understand the expenses part (green part), is this the balance of expenses account which are (Commendation, mean, air fare ...etc ) ?

    I have previously provided primary two reports which can be used to meet your inquiry, the first is a dynamic script to retrieve all the dimension and associated dimension code in the same "table" format that you provided above. As for the expenses part (in case it is meant to be the expenses account), you can consider another script which provided all the analytical accounting details for AA journals.

    Check them out on :

    The above could be your first step to proceed with the report you are looking for

    Your feedback is highly appreciated,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans