How to Pull TTI Activity by Account from the OTBI Reporting Tool to Review GL Activity
Amber Schmitz
|
35 steps
|
3 minutes
1
In Oracle, select "Tools" from your home screen.
2
Select "Report and Analytics"
3
Click "Browse Catalog"
4
Navigate to "Shared Folders" then select "Expand" under the folder labeled "Custom"
5
Then "Expand" under "Financials"
6
"Expand" under "General Ledger"
7
Click "Expand" under "TTI Reports"
8
Click "Expand" under "TTI Activity by Account"
9
Click "Expand" under "TTI Activity by Account"
10
Select "US Ledger"
11
Select "(All Column Values)" under \* Branch
12
Select "1-2021." Click "Remove"
13
In the search field, type "2024 [[enter]]"
14
Select the period(s) you wish to review.
15
Click the arrow pointing to the right.
16
On the \* Natural Account, click "More/Search..."
17
Type the GL code for review.
18
Select the GL code desired.
19
Click the arrow pointing to the right
20
Click on accounts that are to be excluded from the report.
21
Click "Remove"
22
Click "OK"
23
Click the drop down on \* Category
24
Click "(All Column Values) or particular category desired for the report.
25
Click "Continue"
26
At the bottom of the report, click "Export"
27
Click "Data", "Excel"
28
Click "Downloads"
29
Click "TTI Activity by Account"
30
Click "Enable Editing"
31
Click "G" to highlight entire column
32
Hold down the ctrl key and click "I" to highlight the entire column
33
Click "Comma Style"
34
At the bottom of column G and I, use the =SUM formula to calculate the totals of each column
35
Type "GRAND TOTAL" to the left of column G's total. Ensure there is no variance between the 2 columns.
