This script is used to pull data that may be required for a government audit. The usual form of audit requests is for a previous year, with the following information being provided:
This information pulls from the GL20000 and GL30000 tables (current year transactions and historical transactions.) The data can be exported into whatever format the government agency is requesting.
- Account Number
- Account Name
- Transaction Date
- Posting Date
- Entry Source
- Journal Entry Number
- Description
- Batch Number
- Debit (Functional Currency)
- Credit (Functional Currency)
- Net Amount (Functional Currency)
- Transaction Currency
- Debit (Originating Currency)
- Credit (Originating Currency)
- Net Amount (Originating Currency)
- Originating Control Number (i.e. A/R or A/P transaction number)
- Originating Master ID (i.e. Customer ID or Vendor ID)
- Originating Master Number (i.e. Customer Name or Vendor Name)
- Originating Document Number
This information pulls from the GL20000 and GL30000 tables (current year transactions and historical transactions.) The data can be exported into whatever format the government agency is requesting.