Audit Trail with Reporting and Transaction Currency

Modules > Advanced revenue & expense deferrals > Inquiries > Audit trail with reporting and transaction currency

Use this page to view the history of any modifications or processing performed on a deferral schedule that match the search criteria or filter that you specify. This inquiry is similar to the Audit trail inquiry but also includes information about the reporting and transaction currencies used. If you are using multiple currencies and using this inquiry, then the exchange rate is determined by the Exchange rate calculation base that you select in your Subscription Billing Parameters. If you want to change the Exchange rate calculation base there can be no data in the inquiry. You can use the Cleanup action to delete any generated data and reset the inquiry.

The inquiry also shows details about deferral schedules such as customer and vendor names, the delivery address, city, state or province, and country.

Generate an Inquiry

When you run the report for the first time you must run a batch to populate the records in the inquiry form. Any transactions added to the audit trail after the batch job will not appear in the inquiry form. To update the inquiry with the latest transactions, run another batch.

You can check the status of your batch jobs by going to System administration > Inquiries > Batch jobs > Batch jobs.

To generate an Audit trail with reporting and transaction currency inquiry, do the following.

1. On the Inquiry page, specify the filters to show only the records that you want, and select OK.

The Overview tab shows the list of audit trail information for all records that match the specified criteria.

2. Select a line and select the General tab to view the details of the selected line.
3. Then, if this is the first time using the Audit trail with reporting and transaction currency inquiry, on the Action tab, select Audit trail batch.
4. A batch processing page opens. Run a batch to generate the data.

Fields

The following fields and columns appear on the report: 

Field	Description
Header
Accounting currency	Displays the accounting currency used in the General Ledger.
Reporting currency	Displays the reporting currency used in the General Ledger.
Columns
Customer name	Displays the customer account for the billing schedule and the customer name.
Vendor name	Displays the currency for the billing schedule.
City	Displays the city of the transaction.
State/Province	Displays the state or province of the transaction.
Country/Region	Displays the country or region of the transaction.
Period	Displays the period in which the transaction was created.
Year	Displays the year when the transaction was created.
Event amount	Displays the amount in the accounting currency.
Transaction currency	Displays the transaction currency used by the deferral schedule.
Transaction currency exchange rate	Displays the exchange rate used to convert the transaction amount from the accounting currency.
Reporting currency exchange rate	Displays the exchange rate used to convert the reporting amount from the accounting currency.
Amount in transaction currency	Displays the amount in the transaction currency.
Amount in reporting currency	Displays the amount in the reporting currency.

Buttons

This page contains the following buttons: 

Reconciliation transaction detail buttons

Field	Description
Schedule
Schedule	View the original deferral schedule.
Original document	View the original document used to created the schedule.
Voucher transactions	Opens a list which displays the ledger transactions.
Generate data
Audit trail batch	Open a batch processing page where you can run a batch process to generate data for the audit trail with reporting and transaction currencies.
Cleanup	Deletes any data in the inquiry. Important: The Cleanup action does not delete the records which the inquiry uses to generate its data. It removes data from the inquiry page and you can then run another batch process to generate the same or different data.

Back to top ▲