G/L Transactions Listing -- Printing

Sage ERP Accpac General Ledger 6.0

G/L Transactions Listing — Printing

This report lists the net changes, balances and transaction details of all accounts in the selected range, for the specified fiscal periods.

For more information on the contents of this report, see G/L Transactions Listing — features.

Before using

  • Post batches.

  • Decide which accounts you want on the report, and the range of fiscal periods that you want reported.

  • Decide whether to include accounts with no activity (zero-balance accounts with no transactions posted to them in the period specified for the report).

  • Select printing destinations and, if necessary, turn on and connect the printer.

To print the report

  1. From the G/L Reports folder, choose G/L Transactions Listing.

  2. Select the order in which you want the report listed.

    You can print the report in order by account number, by a particular segment (such as department or region), by account groups, or by account sorted groups.

    If printing one particular department or region, you should order the report by the department or region segment.

  1. Select the range of accounts you want printed, whether you print by account number, by account segment, or by account group.

  2. In the Include section of the form, indicate whether to print additional information on the report. You can select:

  • Accounts With No ActivitySelect Include Accounts With No Activity if you want to include all accounts — even if no transactions were posted to them in the reporting period.

  • QuantitiesChoose Quantity to include quantity transaction data.

  • Transaction Optional FieldsChoose Transaction Optional Fields to include optional fields with the details of posted transactions.

  • Balances and Net ChangesSelect the Balances and Net Changes option and a report will be printed that displays the balances and net changes over the defined period for each selected account.

  • Include Posting Sequence and Batch-Entry NumbersSelect the Posting Seq. and Batch-Entry option to include posting sequence and batch entry numbers in the report. This checkbox is disabled if the Quantity option is selected in the Include section.

  1. Select the year and range of fiscal periods for the report.

  2. If you are printing period 12 details, indicate whether to include adjustment and closing entries (if you have created the next year).

  3. Select the type of currency.

    • Choose Source and Functional if you want source-currency information included.

    • Choose Reporting if you want amounts shown in the reporting currency you specified. This option is available only if you selected the euro as your functional currency and you specified a reporting currency.

      When you select Reporting, the debit, credit, net change and balance amounts will be printed in the reporting currency; these amounts are obtained from the reporting fiscal set.

  4. If you want to sort transactions by date within the selected accounting periods on the report, select Sort Transactions By Transaction Date.

  5. Select the option, Select Account Groups By Sort Code Range (optional), then enter a range in the From and To fields of the Sort Code-Account Group section. Otherwise, leave those fields blank.

  6. Select Use Rolled Up Amounts to print the transactions of a rollup account and all of its rollup member accounts (at any level), rolled up into a single amount for each transaction. (Note that rollup member account transactions are included only once in the rolled up transactions.)

  7. If you selected Segment in the Sort By section, you can chose whether or not to add a page break after each account in the report.

  8. Restrict the report further, if you wish, by selecting ranges of segment codes and ranges of account optional fields.

  9. Click Print.

    Depending on the print option you select in the Print Destinations form (Printer, Preview, File, E-mail), you’ll see a different destination-specific dialog box where you can specify more options.

    If you select the Printer option, G/L will display the Print dialog form where you can confirm your printer selection and change the number of copies you want printed.Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

    If you select the File option, G/L will display the Report dialog box where you can select the file format (disk file, Exchange folder, Lotus Notes database, or Microsoft Mail) and the destination (the name of the file).When you choose OK, G/L will display the Export dialog box where you can finalize your selections.

    If you select the Preview (print to screen) option, G/L will generate and display the report in a Crystal Reports form.You have the option of printing the report or saving it to a file.

    If you select the E-mail option, G/L will display the Send Mail dialog box where you can compose an e-mail message and send the report as an attachment. G/L will automatically assign a report name and attach the report in RTF format to any message you compose and send from this dialog box.

Notes

Information for each detail includes the batch entry number, posting entry number (a combination of the posting sequence number and the sequential number assigned to indicate the order in which the entry containing the detail was posted), source code, descriptive and reference text, and the debit or credit amount. Comments do not appear on this report.

After using

  • Use the report in combination with the posting journals and batch listings to trace transactions for auditing purposes.

  • File the listing with your audit trail reports.

See also