G/L History (GLYH.GL92)

The G/L History (ibis_glyh.gl92) view displays transactions per fiscal period that were posted to each GL account from all sub-ledgers and journal entries.

As each period is closed by running G/L Period Close (ibis_gl81), the period’s transactions are moved from the GL collector file to the yearly history file. The total of all transactions and the YTD balance is included for each period.

The transactions remain in the file and are not purged when the year is closed by G/L Year-End (ibis_gl90).

The following list defines every field available in the G/L history table in alphabetical order:

  • Balance – the balance is the opening balance for the period plus any transactions for the period.

  • Company - the company field defaults to the company assigned to your user id in the Session Parameters view. If you want to view GL history for a different company, you must change the company assigned to your user id in the Session Parameters view and then re-open the GL history view.

  • Credit – if the account type is 'credit balance', the transaction is a positive amount.

  • Currency – domestic currency.

  • Debit – if the account type is 'debit balance', the transaction is a positive amount.

  • Fiscal Period – maintained in Fiscal Date Entry (ibis_cc90).

  • Folio/Inv. – journal entry number or the AP invoice number.

  • G/L Account – the G/L account number.

  • General Ledger Amount – the G/L amount.

  • Report Code – the register number.

  • Source – the following source codes are available:

    • AP – A/P Invoice Audit Trail
    • AR – Cash Receipts Register
    • BT – Background Inventory Transfers
    • CC – A/P Computer Check Register
    • CN – Credit Note
    • FA – Fixed Assets Register
    • IN – Sales Invoice Register
    • JA – Journal Entry – Accrual
    • JC – Journal Entry – Std. Clearing
    • JN – Journal Entry
    • JR – Journal Entry – Std. Reoccurring
    • JX – Journal Entry – Reversing
    • MC – A/P Manual Check Register
    • PA – Payroll Register
    • PI – PI Count Register
    • PO – PO Receiving Register
    • RS – Retail Cash Sales Journal
    • ST – Inventory Adjustments & Transfers
    • YE – Fiscal Year End Register
    • ZZ – Closing Balance
    • 00 – Opening Balance

  • Total Transactions – all transactions for the period are totaled.

  • Trans Date – date of the transaction.

  • Transaction Description – description of the transaction.

  • Unique Trans. Number for GL History – the unique transaction number.