Fields and controls
Bank Account
After you enter a bank code, this field displays the bank account number specified in the bank record.
If you use multicurrency accounting, the statement currency specified for the bank is displayed in the Currency field.
Bank Code
The program displays the default bank code specified on the Bank Options screen, but you can specify another code if you want to view information for a different bank.
A description of the specified bank code is displayed in the Bank Code Description field.
[Check / Payment /Receipt /Bank Entry] Amount
The names of these fields depend on the source application. For example, if you are selecting Bank Services transactions, the field is called Bank Entry Amount.
You use these fields to specify a range of amounts to display on the Transaction History Inquiry screen. The displayed list will include only transactions whose amounts fall within the specified range
If you accept the default entries for these fields (a blank in the From field and a very large amount in the To field), all checks, payments, or bank entries that meet the other specified selection criteria are displayed.
Note: You specify these amounts in the bank's statement currency.
[Check / Payment / Receipt / Bank Entry] Date
The names of these fields depend on the source application. For example, if you are selecting Bank Services transactions, the fields is called Bank Entry Date.
You use these fields to enter the range of dates for the transactions you want to display on the Transaction History Inquiry grid. Only transactions posted during the specified range of dates are displayed on the screen.
If you accept the default entries for these fields (a blank in the From field and an end date in the To field), all transactions that meet the other specified selection criteria are included.
[Check / Payment / Receipt / Bank Entry] Number
The names of these fields depend on the source application you specify. For example, if you are selecting Bank Services transactions, the field is called Bank Entry Number.
You use these fields to restrict the list of transactions displayed on the Transaction History Inquiry screen to those that fall within the range of check, receipt, or transaction numbers you specify.
If you accept the default entries for these fields (a blank in the From field and a row of Zs in the To field), all checks, receipts, or bank entries that meet the other specified selection criteria are displayed.
Document Type
If you are viewing transactions for Accounts Receivable, Bank Services, or third-party programs ("Others"), you use this field to specify the type of document to display.
If you selected Accounts Payable, you cannot change this field. The Transaction History screen displays only payments for Accounts Payable.
Reconciliation Status
Specify the transactions to display, based on reconciliation status: reconciled, outstanding, or all.
Source Amount
These fields appear only in multicurrency systems. Only transactions whose source amounts fall within the specified range are displayed.
Source Application
Select the application from which the transactions originate: Accounts Payable, Accounts Receivable, Bank Services, or Other (if you are using a third-party product that sends transactions to Bank Services).
Source Currency
These fields appear only in multicurrency systems. Only transactions whose source currency falls within the specified range are displayed.
[Vendor / Customer / Employee] Number
The names of these fields depend on whether you selected Accounts Payable or Accounts Receivable as the source application. (These fields do not appear if you selected Bank Services as the source application.)
You use these fields to enter the starting and ending numbers of the range of vendors, customers, or employees for whom to display transactions.
If you accept the default entries for these fields (a blank in the From field and a row of Zs in the To field), the display will include transactions for all vendors, customers, or employees.
Detail Table
Amount
This field displays the amount of the listed transaction in the bank's statement currency.
[Bank Entry / Receipt / Payment] Date
This field displays the transaction date for the listed payment, receipt, or bank transaction. The data displayed will change depending on the selections made in the Source Application, Document Type, and Reconciliation Status lists.
Transactions are listed by date in the display grid.
[Bank Entry / Check/Payment / Check/Receipt] Number
This field displays the payment, receipt, or transaction number for a listed transaction.
Tip: You can view the document in the source program by selecting a transaction, then clicking the Edit button 
in the Number column heading.
The data displayed will change depending on the selections made in the Source Application, Document Type, and Reconciliation Status lists.
Transactions are listed by date in the display grid.
[Customer / Employee / Vendor] Name
This field displays the name of the listed customer, employee, or vendor. The data displayed will change depending on the selections made in the Source Application, Document Type, and Reconciliation Status lists.
Transactions are listed by date in the display grid.
[Customer / Employee / Vendor] Number
This field displays the number of the listed customer, employee, or vendor. The data displayed will change depending on the selections made in the Source Application, Document Type, and Reconciliation Status lists.
Transactions are listed by date in the display grid.
Description
This field displays the description that was entered for a transaction when it was processed.
Reconciliation Date
This field displays the date that a listed transaction was reconciled.
The field is blank if a transaction is outstanding.
Reconciliation Description
This field displays the description entered when a transaction listed on the display grid was reconciled.
The field is blank if a transaction is outstanding.
Reconciliation Status
This column shows the current reconciliation status for each transaction in the list.
Source Amount
This field displays the amount of each displayed transaction in the source currency.
Note: This field appears only in multicurrency systems.
Source Application
This field displays the source application for the listed transactions.
Note: This field appears only if you specify Other in the Source Application field.
Source Currency
This field displays the source currency for each displayed transaction.
Note: This field appears only in multicurrency systems.
Overview
Use the Bank Transaction History Inquiry screen to:
- Look up payment or receipt transactions originating in Accounts Payable, Accounts Receivable, or other programs send transactions to Sage 300 Bank Services.
- Look up transactions that you enter in Bank Services.
- Print the results of your inquiry to a report.
The source application and other criteria you specify for the inquiry determine the information that is printed on the report.
The Transaction History screen lists transactions by number, and includes the date, description, amount, reconciliation status, reconciliation date, and reconciliation description stored with each transaction.
You can also apply additional criteria to restrict the inquiry to transactions of particular interest to you. For example, you can search for:
- Transactions that have a specified reconciliation status, or you can display transactions regardless of their status.
- Payments or receipts within a range of dates, amounts, or source currencies.
- Receipts for a particular customer or deposit number.