Accounting Finance:General Ledger-Extracting G/L Transaction Log to Excel

Overview

The export extracts all transactions to a spreadsheet format to permit a user to manipulate data

Process

• Select System Management→Query manager→Run a query request
• Select FINGLLOG02
• Click enter

1. Enter From Main
2. Enter To Main
3. Enter From Voucher Type
4. Enter To Voucher Type
5. Enter From Document Type
6. Enter To Document Type
7. Enter From Voucher Number
8. Enter To Voucher Number
9. Enter From Document Number
10. Enter To Document Number
11. Enter From Period
12. Enter To Period
13. Click enter

• Click enter

UWD Staging on 'Bart'

• Email Nancy to transfer worksheet from: UWD Staging on ‘Bart’/NancyN to your directory (only person with Client access can access files in UWD Staging)
• The file will be saved to Nancy’s directory in UWD Staging