Bible Report

Top  Previous  Next

The Bible Report [bdbr] or also commonly referred to as the General Ledger is the original financial statement that produces a Detailed or Summary Report on distributions based on the date range or period selected.  The Bible Report [bdbr] generates a reference copy of all transactions that were entered in your PSL3 database.  The major difference between the Bible Report [bdbr] and the Chronological Bible Report [bdbible] is that the Bible Report [bdbr] is organized by Account Number and the Chronological Bible Report [bdbible] is organized by Reference Number.

 

 

Open:

 

To access the Bible Report [bdbr], click on Tab #8 or press 'ALT' and the number '8' Key simultaneously to open the screen.

 

The Bible Report [bdbr] is also accessible if you click the 'G/L' module from the menu tree (see following screen shot) as well as the 'Report' folder under the 'General Ledger' and 'Weekly' sub-folders.

 

You can also access this report by typing the screen or acronym name in the blue prompt bar located above the 'Setup' menu.  Then, press Enter.

 

 

 

The screen then appears.

 

 

 

To select criteria, press the F2 Key or right click in most fields to make your selection.  You can also simply type in the criteria in the allotted fields. If you wish to include all criteria information, leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3.

 

 

Period Selection:

         

Period - System-assigned Period Number that indicates the Accounting Period in which these costs were entered.  If you chose to run the report by Period Number, then the Start Date and End Date  fields default for the period chosen.

 

Start Date and End Date - Transaction Effective Dates to include in the report as PSL3 is date-driven.  Current Period Start and End Dates default. You can always change the date by typing over the defaulted date or by right clicking in either field for the calendar selection to appear. To restrict the report to only include information for a single date, input the same date in both the Start Date and End Date fields. To select all dates from inception to future, leave both fields blank.

 

 

 

 

Account Selection:

 

From and To - Account numbers to include in the report. To restrict the report to only include information for a single account number, input the same account in both the From and To fields. To multi-pick certain accounts, press the F2 Key or right click in either field and hold down the Control Key while simultaneously using your mouse to select. To select all account numbers, leave both fields blank.

 

Account Type - Single letter classification indicating the Account Type (Asset, Liability, Capital, Income, Expense).

 

 

Selection Criteria:

 

Press the F2 Key or right click in any of these fields (Production, Company, Source, Series, Location, Set, Insurance, Free Field(s), Vendor and J/E Number) to choose the necessary codes if they don't already default. To choose multiple codes for a particular field, press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select.  To run the report by a specific transaction type (A/P, C/K, J/E, P/C, P/O, and/or P/R), use the Source Code field.  By making a selection, this isolates the report to only display items based on the code(s) selected.

 

 

Include/Exclude:

 

Include Detail - Check mark to include detail distribution data.

 

Include Inactive Accounts - Check mark to include accounts that had no activity/distributions posted to them during the period or date range selected or have a zero dollar balance.

 

Include P/O's - Check mark to include open P/O's.  If a P/O distribution line is transferred to an A/P transaction but the A/P is not yet posted, then the P/O line is still considered open.  A P/O distribution line remains open and is considered a Commitment on the Estimated Final Cost Report [efcrpt] until the A/P containing the transferred P/O line is posted, marking it relieved or until the P/O line is closed.

 

Include Beginning Balance/Beginning Balance is Activity - Check mark to include the Beginning Balance and consider active accounts that have a non-zero Beginning Balance.

 

Include Audit Information/Include User - Check mark to isolate transactions entered by a single User ID for auditing purposes.

 

 

Show/Hide:

 

Series Separation - Check mark if you want transactions for each Series Code displayed separately.  If selected, the report is broken down by account number, then Series Code.

 

Location Separation - Check mark if you want transactions for each Location Code displayed separately.  If selected, the report is broken down by account number, then Location Code (if Series Separation is not check marked first).

 

Set Separation - Check mark if you want transactions for each Set Code displayed separately.  If selected, the report is broken down by account number, then Set Code (if Series and/or Location Separation is not check marked first).

 

Company Separation - Check mark if you want transactions for each Company Code displayed separately.  If selected, the report is broken down by account number, then Company Code (if Series, Location and/or Set Separation is not check marked first).

 

Reference Description - Check mark to include the Reference Description in addition to the Distribution Description of each transaction.  If selected, the report usually defaults to Landscape layout due to the additional column.

 

 

Multiple Currency:

 

Source Currency - If you have more than one currency in your database, you can choose to include only transactions denominated in one currency, two, three, etc., or all currencies.  To choose multiple Currency Codes, press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select.  Each currency in your database and its conversion rate are listed in the report heading.

 

Target Currency - Base currency set up in the System Control Information Entry [suctrl] screen located in the 'Setup' module defaults.  This Currency Code is what all transactions are converted to on the report.  Each currency in your database and its conversion rate are listed in the report heading.

 

 

Print/Preview the Report: Located in the top right hand corner of the screen, you can choose the following options to generate the report:

 

Print Combined Report - Opens the Print Dialogue box and sends the report (combining all Series, Location and Set Codes onto one report) directly to the printer.

 

Print Individual Report - Opens the Print Dialogue box and sends the report (separating each Series, Location and Set Codes into separate reports) directly to the printer.

 

Preview Combined Report - Generates a PDF format report (combining all Series, Location and Set Codes onto one report) and appears instantly on your screen.  You are still able to print from the PDF format.

 

Preview Individual Report - Generates a PDF format report (separating each Series, Location and Set Codes into separate reports) and appears instantly on your screen.  You are still able to print from the PDF format.

 

Spreadsheet - Generates an Excel format report and appears instantly on your screen.  You are still able to print from the Excel format.  Please note if you select this option, you are able to have additional sorting options within Excel.

 

TSV Spread - Generates a Text (.txt) file in which you save to your computer and 'Open With' the desired program of your choice.  This option is usually selected in lieu of the 'Spreadsheet' option in the instance the report exceeds the number of lines allotted in Excel.  The 'TSV Spread' option does not have line limitations whereas depending on the version of Excel, the 'Spreadsheet' option may.

 

*Below is a sample of the Combined Bible Report [bdbr] with 'Include Detail' check marked.