General Ledger - Daily Detail Register
Function
This task prints a list of all general ledger transactions entered through journal entries or generated from other modules. It also presents the option to update to the general ledger Summary Activity and Transaction History files.
=> To access this task...
Select Daily Detail Register from the General Ledger main menu.
Daily Detail Register
About the Fields
In the Beginning/Ending GL Account field...
-
Enter the first/last account number that will be listed on the register.
-
Click
to select from a list of all valid codes.
In the Account 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 Code field...
-
Enter a specific Journal ID to include on the register.
-
Click
to select from a list of all valid codes.
By Date or Audit Number? dropdown...
-
By Date, generates the register by date.
-
By Audit Number, generates the register by audit number.
In the By Beginning/Ending Audit Number field...
- Enter the beginning and ending audit numbers to appear on the register.
In the By Beginning/Ending Transaction Date field...
- Enter the beginning and ending transaction dates to appear on the register or use the calendar tool
to select the dates.
Page Break? checkbox...
-
Mark the box to create a page break with each change in the audit number/date.
When done making selections...
-
Click
to create the register. -
Click
to clear the form and begin again. -
Click
to save the register settings.
If there are balance issues to report the system does so with a prompt prior to creating the report. If the Suspense Account is in use and the OOB amount does not exceed the GL Post Limit and the resulting Suspense Account Balance for the current period will not exceed the Account Balance, and a valid Journal ID exists on the Suspense Account, the following prompt will appear:
When [Yes] is selected, a transaction is created which will post the out of balance amount to the Suspense Account when the update is run. A message is printed on the register:
When [No] is selected, the out of balance prompt will appear:
If the Suspense Account is in use but has an invalid or blank Journal ID or the OOB amount exceeds the Suspense Account GL Post Limit, or the resulting Suspense Account Balance for the current period will exceed the Suspense Account Balance limit, the following prompt appears:
Selecting [OK], the out of balance prompt will appear:
If the Suspense Account is not in use, the out of balance prompt will appear:
Sample Daily Detail Register
See Output Options.
-
Select [Yes] to run the register.
-
Select [No] to skip the updating step.
Updating
The Daily Detail Register table is cleared as part of the update.
______________________________________________________________________________________
Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.