|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Check Register |
|
|
|
|
Most of the reports have options to generate reports with special partial run and range-of-date features. The partial run option allows for a report to be generated for selected records only. When this option is enabled, a list of the records within the selection criteria will be displayed. Click the box on the left side of each record to select the items that will appear on the report. The selection flag may be removed by clicking the box once more. Select OK to record your selections and to return to the report options screen.
When printing a detail report, a beginning date and an ending date must be selected. The data range may be any period such as one day, one week, one month, one year, etc. To print the report for only one day, use the same date for both the beginning and ending dates. To print a report that includes all periods, enter the date range as 01/01/1900 through today's date.
The partial run option allows for a report to be generated for selected records only. Depending on the report, the selection criteria may either be for a client, job or general ledger account number. When this option is enabled, a list of the records within the selection criteria will be displayed. Select the box on the left side of each record to select the records that will appear on the report. The selection flag may be removed by selecting the box once more. Select OK to record your selections and to return to the report options screen.
Some reports, such as the trial balance or financial statements, may only be printed for the current fiscal year. Any report that prompts for a two digit month instead of a MM/DD/YYYY format is a report that will only print current year data.
As of software version 9.1.0.0, the SQL Script for MAR General Ledger reports has been updated to create detail transaction records directly from the Sales Journal in order to obtain the actual job number associated with general ledger transactions that are “non job cost” related. In addition, a new summary table called LEDGERDETAILSALESBYBATCHTOTALS.ADT is created with each MAR GL Report which will contain a list of batch numbers and g/l accounts where the totals from the gldetail table and the sales table are not in balance. These files should never be out of balance unless there are unusual circumstances such as editing of batches, hardware failures, or data corruption. A new footer description has been added to the MAR Ledger Detail reports to indicate how the records are created for sales related transaction as shown below:
This report queries the historical gldetail records and related sales table records in order to determine the job number associated with each gldetail record for non-jobcost records where the job number is not stored in the gldetail record. During this query process, the job number (gljob field) and transaction records are created from the sales table records for source codes 20, 21 and 30 and these records are NOT pulled from the gldetail table for this report. A special table called LedgerDetailSaleseByBatchTotals is created for this report which traps any batches where the sales records and gldetail records DO NOT match.
The above script changes will correct any issues where the job numbers could not be obtained accurately when multiple invoices of the same amount and same invoice description were posted together in the same batch.