General Ledger - Transaction History Report

 

Function

This report creates a transaction history for selected periods and lists the individual transactions within those periods. The information available in the Summary Activity Inquiry option of the Accounts maintenance task is shown. A history report can be created for one account or a range of accounts, for an audit number, as well as create a report showing detailed information or a summary of information. The report can be run at any time, and should always be run as part of the period end processing.

 

=> To access this task...

Select Transaction History Report from the Reports menu.

 

Transaction History Report

 

About the Fields

 

In the Audit Number field...

  • Optionally enter the audit number. An entry disables the date, period, and year filter fields.

In the Transaction Date field...

  • Enter the transaction date for the report or use the calendar tool to select the date.

NOTE: If a transaction date is entered, the Audit Number and Beginning/Ending Period /Year fields are cleared and disabled.

 

In the Beginning Period field...

  • Enter the beginning accounting period to show on the report.

In the Beginning Year field...

  • Enter the fiscal year for the beginning period.

In the Ending Period field...

  • Enter the last accounting period to show on the report.

In the Ending Year field...

  • Enter the fiscal year for the ending period.

In the Beginning/Ending Account field...

  • Leave blank to select the first/last account, or enter a valid beginning account number.

  • Click Click to select from a list of all valid accounts.

In the Wildcard Mask field...

 

Understanding Wildcard Masks

 

Certain tasks allow for the input of an account wildcard to enable you to select accounts that have common numbering as part of their identification. The wildcard can use the ‘?’ and ‘-’ characters; the '?' represents a single character, and the dash '-' is a literal. For example, assume an account mask set to 000-000, as is the case with standard demo data. If you want to select all accounts that end with '1', use the wildcard mask ???-??1. The question marks stand in place of the account digits; the dash is located as expected in the mask.

 

In the Journal ID field...

  • If entered, limits the report to the selected journal ID.

  • Click Click to select from a list of all valid codes.

In the Detail or Summary field...

  • Select Detail (D) for a detailed listing of all transactions by journal ID for each period selected.

  • Select Summary (S) for a report summary.

Export format checkbox...

  • Mark the box to create a report without blank data fields for manipulation in MS Excel.

  • Unmark the box to create a report of the raw data.

Exclude Inactive Customers? checkbox...

  • Mark the box to exclude accounts marked as Inactive.

  • Unmark the box to include all accounts.

When finished making entries to the fields...

  • Click Save button to save the report settings.

  • Click Clear Form button to clear the form and begin again.

  • Click Run Process button to create the report.

Sample Transaction History Report

 

See Output Options.

______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.