Account Inquiry Grid

Field

Explanation

TranNo

Transaction journal number.

Date

Document date.

Note: If the date is coloured blue, this signifies that it is a different date to the transaction date.

Tran.Date

Transaction date.

Note: If the Tran.Date is coloured blue, this signifies that it is a different date to the document date.

The Document date is the date that the transaction impacted on the general ledger accounts. This is the date entered in the Date field in the general journal.

The Transaction date is the date the transaction was entered into Jim2. This is the actual date of entry, ie. entered today but entered a different date in the Date field of the general journal.

Type

Type of transaction.

Account

Account number

Account

Account name, ie. cheque account.

RefNo

Reference number.

Period

The financial period of the transaction, according to Tools > Options > Accounts.

Comments

Description of the transaction, ie. payment.

Detail Comments

Comments entered by user.

Note: When you create a purchase order, the Detail Comments do not appear on an Account Inquiry, as all stock in the purchase order linked to the same account will be on 1 line.

When you create an Expense Order not linked to a purchase order, the Detail Comments will appear.

When you create an Expense Order linked to a purchase order, the Detail Comments will be blank, as the account affected is the account on the linked purchase order, therefore all transaction will appear on the 1 line.

Debit

Debit value.

Credit

Credit value.

Tax

The tax code used.

AccumTotal

The accumulated total.

FC AccumTotal

The foreign currency accumulated total (if applicable). Otherwise, this field will display the same as AccumTotal.

Branch

The branch used (this column is only displayed if branches have been set up in Tools > Options > Branches).

GL Dept

The GL Department (this column is only displayed if GL Departments have been set up in Tools > Options > Branches).

GST #

The GST session number that the transaction was included in.

Option	Explanation
View xxxxx #	Allows viewing of the original transaction, eg. View Invoice #, View Debtors Payment #, View Return from Customer #, etc.
View Reconciliation #	Allows viewing the bank reconciliation this entry belongs to.
View Transaction Journal #	This will open the relevant transaction number in the Transaction Journal.
Show Amounts with 4 decimal places	This will display the Account inquiry grid results with four decimal places (the default is two). Switching between two or four decimal places means the setting will remain active until the Account inquiry screen is closed. Once closed, it will default back to two decimal places next time it is opened.
Export Data	Allows exporting of data to XLSX format.
Print/Print Preview	Self explanatory.
Copy Cell/Copy Row/Copy All	Self explanatory.
Show Find panel	Will display the Find panel above the grid.
Grid Columns...	Allows adding more columns. Also allows removal of columns. Select the column to add, then drag it to the position required in the columns within the grid. To remove, click and drag to the Grid Columns... window, or drag down away from the header area.

The grid is always ordered by transaction number – select a column and order by that column but this will place the Accumulated Total column out of order.

The background of any transactions where the document date doesn't match the transaction date will be shown in a light blue colour.

Further information

Account Inquiry Screen

Account Inquiry Filters

Account Inquiry Footer

Account Inquiry Reports

Account inquiry Grid