G/L Transactions Report — Printing

Sage 300 ERP

G/L Transactions Report — Printing

The G/L Transactions report is a list of the general ledger transactions created from all posted Accounts Payable batches, and from posted revaluations (in multicurrency ledgers). You can print detailed or summary versions of the report.

The level of detail for transactions on the detailed report depends on your choices on the Integration tab of the G/L Integration form. For example, if you choose Consolidate By Account And Fiscal Period, the report shows a total for each general ledger account and fiscal period. If you choose Do Not Consolidate, the report shows full details for each transaction.

For information on the contents of this report, see G/L Transactions Report — Features.

When to print

  • After posting Accounts Payable batches, or after creating general ledger batches (if you choose generate GL batches using the Create G/L Batch form).If you do not use Sage 300 ERP General Ledger, print the report before transferring the batch information to another general ledger system.
  • Before using the Year End form. You must create any outstanding general ledger batches (if you use the option to create the batches on request) and print the G/L Transaction report before clearing posting journals.

If you do not use Sage 300 ERP General Ledger, Accounts Payable creates the general ledger batch in a CSV (Comma Separated Values) file, tailored to the Sage 300 ERP General Ledger format. You can send the file to a remote location that uses Sage 300 ERP General Ledger, or modify the information in the file to suit another general ledger program.

To print the report

  1. Choose the G/L Transactions icon from the A/P Transaction Reports folder.
  2. Make selections in the following fields:

    Select Batch Type. Specify the batch types to include. You can select any or all of the Invoice, Payment, and Adjustment batch types. If you use multicurrency accounting, you can also choose Revaluation. For each type you select, enter a range of posting sequence numbers. The latest posting sequence numbers are displayed in the To box. You can choose them or enter earlier numbers.

    Report Format. Select Detail or Summary.

    Sort By. If you choose the detailed report format, specify the order in which to list the transactions on the report. The choices are by general ledger Account Number, by Year/Period, and by Batch/Entry Number. The summary report is sorted by general ledger account number.

    Currency. If you use multicurrency accounting, specify whether to print amounts in each source currency or in the functional currency.

  3. Click Print.

    If printing to a printer, Accounts Payable displays the print destination form to let you confirm your printer selection and change the number of copies to print. Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

    If printing to a file, Accounts Payable displays the name of the file, so you can change it or cancel printing.

    If printing to the screen (preview), Accounts Payable displays the report. If you want, you can then export it to a file or send it to the printer.

    If printing to an e-mail, Accounts Payable displays an e-mail message form for you to fill in, and inserts the report as an attachment when you choose Send.

    If printing to a schedule, Accounts Payable displays the Schedule Report form.

Related Topics