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
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,
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 | |||
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,
Share
Report
All responses (
Answers (
32,738
