GL Transactions (BRTRANS)

The GL Transactions view is populated with G/L transactions from the following PointForce Enterprise (PFE) programs that relate to the Bank GL Account defined in the Bank Master view:

• Computer Check Register (AP43)
• Manual Check Register (AP51)
• Cancelled Check Register (AP81)
• Cash Receipts/Adjustments (AR31)
• Post Journal Vouchers (GL31)
• Post Standard Journals (GL81)
• Print Invoice Register (IN44) (*only for EFT transactions that hit the bank directly)

The GL Transactions view includes the report number, reference number, transaction date, debit/credit amount and comments. You can also view the report details by clicking on the icon in the View Report column. To reconcile a transaction, you assign the appropriate Bank Statement date to each transaction.

You cannot edit the transactions in this view directly. You must return to the source program in PFE in order to add or delete transactions from this view. For more details on Bank Reconciliation, please see the Bank Reconciliation Overview topic.

The following fields are available on the GL Transactions view and are based on the order in which they appear in the grid on the search page:

• Company - every record in the PointForce iTopia SQL database includes the Company Number. When reviewing the results from your search, the Company Number will display for all GL Transaction records.

• Bank Account Code - displays the Bank Code to which the transaction is associated.

• Trans. Type - displays the transaction type from PFE. Valid transaction types include:
  • M - Manual Check
  • C - Computer Check
  • D - Deposit
  • J - Journal Entry
  • S - Standard Journal
  • E - EFT

• Report Number - displays the Report Number associated with the transaction from PFE.

• Reference - displays the Reference number assigned to the transaction in PFE.

• Transaction Date - displays the date on which the transaction occurred.

• Debit - displays the debit value of the transaction (if applicable).

• Credit - displays the credit value of the transaction (fi applicable).

• Statement Date - this field defaults to 'blank'. To assign a transaction to a specific statement, select the appropriate Statement Date from this field. Statement Dates are maintained in the Bank Statement view.
  • Note: If a transaction does not have a statement date assigned to it (i.e. if the Statement Date field is blank) then the transaction is only recorded in the GL.

• Reconciled - when the Bank Statement record is flagged as reconciled in the Bank Statement view, the transaction(s) assigned to that statement date are automatically flagged as reconciled.
  • You can no longer assign a Bank Statement that is flagged as reconciled to a transaction in the GL Transaction view. Once you reconcile a Bank Statement, it is no longer available to be assigned to transactions in the GL Transaction view.

  • In order to assign a reconciled Bank Statement to a transaction, you must reset the reconciled flag on the Bank Statement to 'no'. You can then assign the statement date to transactions as required.

• Comment - enter a comment for this GL transaction record as required.

• View Report - a link to the original report (AP43/AP51/AR31/GL31/GL80/IN44) to which the transaction is associated.

• Transaction Counter - a unique numeric identifier assigned to each record in the GL Transactions view by the system.

For information on the functionality of each button on the GL Transaction Search Criteria Results/Grid page, click here.