G/L Transactions Report — Features

Sage 300 ERP

G/L Transactions Report — Features

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.

The summary report lists one total for each account number.

For instructions on printing the report, see G/L Transactions Report — Printing.

Information printed on the report

  • The detailed report includes:

  • The batch and entry number. The entry number is assigned when the transaction is added to a batch, and is a permanent part of the record of the transaction.

  • The source code assigned during posting to identify the transaction type.

    Accounts Payable source codes are:

    AP-AD Adjustment

    AP-CF Applied Credit (from)

    AP-CR Credit Note

    AP-CT Applied Credit (to)

    AP-DB Debit Note

    AP-DF Applied Debit (from)

    AP-DT Applied Debit (to)

    AP-ED Earned Discount Taken

    AP-GL Gain or Loss (multicurrency ledgers)

    AP-IN Invoice

    AP-IT Interest Charge

    AP-PI Prepayment

    AP-PY Payment

  • The Reference and Description information you selected in the GL Integration form.

  • Total by sorting option.

  • The summary version of the report includes a single line for each account number, with the total debits and credits posted to the account.

  • Total debits and credits for the report.

Related Topics