Show/Hide Toolbars

Jim2® Business Engine Help File

accinqgrid

 

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.

 

period

Comments

Description of the transaction, ie. payment.

Detail Comments

Comments entered by user.

 

Info

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.

 

Colours in grid

Transactions that are coloured blue mean the transaction and document date are different. The document date is the date the transaction impacted on the general ledger accounts, whereas the transaction date is the date the transaction was actually entered.

Transactions that are coloured red mean those transactions are reconciled.

Transactions that are coloured black mean those transactions have not yet been reconciled.

 

Right click in the grid for more options.

 

accountinquirygrid

 

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.

 

Info

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

Account Inquiry Filters

Account iInquiry Footer

Account Inquiry Report

Account Inquiry Screen