Printing the G/L Transactions Report

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 content of the detailed report depends on the consolidation options selected on the G/L Integration screen. For example, if general ledger transactions are consolidated by account and fiscal period, the report shows a total for each general ledger account and fiscal period. If they are not consolidated, the report shows full details for each transaction.

For more information on the contents of this report, see A/P G/L Transactions Report Screen.

When to Print

You should print this report:

• After posting Accounts Payable batches, if you use the option to create G/L transactions during posting.

  After creating general ledger batches, if you use the option to create G/L transactions using the Create G/L Batch icon.

  If you do not use Sage 300 General Ledger, print the report before transferring the batch information to another general ledger system.

• Before using the A/P Year End screen.

  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.

To print the G/L Transactions report:

1. Open Accounts Payable > A/P Transaction Reports >  G/L Transactions.

2. In the Select Batch Type field, select any or all of the Invoice, Payment, and Adjustment batch types. If you use multicurrency accounting, you can also select Revaluation.

3. Use the Posting SequenceFrom and To fields to specify a range of posting sequence numbers for each batch type you selected.

   The latest posting sequence numbers are displayed in the To field. You can accept them, or enter earlier numbers.

4. Select additional options for the report using the following fields:

   • Report Format. Select Detail or Summary.

   • Sort By. If you are printing the detailed report, specify whether to list the transactions on the report by Account Number, Year/Period, or 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.

5. Click Print.

   • If you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
   • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.

     Note: For Web-based clients, the preview screen appears first when you click the Print button.

   • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:

     • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
     • Disk file. Save the report to a location you specify.
     • Microsoft Mail. Send the report as an e-mail attachment.

     You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.

   • If you are printing to e-mail, an e-mail message appears with the report attached.