Account Inquiry

This activity allows you to view Account Balances and the List of transactions for a specific account code, finance Book, financial year and period range combination. Data Hyperlink in the transactions enables you to the view the respective transaction page.

Select the “Account Inquiry” link under the “Reports – Book keeping” component under Book Keeping Business Process Component.

The “Account Inquiry” page appears.

The system displays the following details:

Company Code	Use the drop down list box to select the company code. The combo would be loaded with all the companies in the installation for which access rights is available for the login user.
Business Unit	Use the drop down list box to select the business units of the selected business unit. The combo would be loaded with all the business units mapped to the selected company code.
Organization Unit	Use the drop down list box to select the organization units of the selected company. The combo would be loaded with all the organization units mapped to the business unit of the selected company code.

Enter the following fields in “Basic Search”:

Account Code	Account code for which balances to be viewed. Help facility available
Finance Book	Use the drop down list box to select the finance book for which balances for the account code to be viewed.
Financial Year Range	Use the drop down list box to select the finance year range for which balances to be viewed.
Finance period Range	Use the drop down list box to select the finance period range for which balances to be viewed.

Click the “Search” pushbutton to perform “Basic search”.

The various fields displayed in "Account Level Details" search

Finance Book	The finance book for which the balances of the account code is retrieved.
Account Code	Account code for which account balances is retrieved.
Account Currency	Currency of the Account code.
Balance in Account Currency	Balance standing against the account code in account currency.
Balance in Base Currency	Balance standing against the account code in Base currency of the Login OU’ Company.
Account Description	Account description of the account code.
Account Group	Account group under which the account code has been created.
Include Voucher	Use the drop down list box to include memorandum vouchers. Combo would be loaded with "All","Memorandum" and "IFRS Adjustments".

Enter the following fields in “Transaction level search”:

Cost center	Specific Cost center recorded in the transactions for the account code for which balances to be retrieved.
Analysis code	Specific Analysis codes recorded in the transactions for the account code for which balances to be retrieved.
Sub Analysis code	Specific Sub analysis code recorded in the transactions for the account code for which balances to be retrieved.
Value Range (Base currency)	Transaction Amount in base Currency based on which search to be executed.
Additional search by	Use the drop down list box to select the "Additional search by" criteria for launching account inquiry. Bank Code, Customer Code, Supplier Code, Project Code, Item code are the Additional search criteria options. Provide the corresponding details in the text field below additional search to launch the "Transaction Level Search" based on Additional search by criteria option.
Total Records	Shows the total records fetched in Transaction level search.

Click the “Search” pushbutton to perform “Basic search”.

The various fields displayed in "Transaction Level Details" search

Finance Book	Finance Book for which balances for the account code are retrieved.
Account code	Account Code for which balances are retrieved.
Date Range	Specify the date range for which transactions for the account code to be retrieved
Transaction date	Transaction date corresponding to various transactions for the account code.
Transaction No	Transaction Number corresponding to various transactions for the account code.
Transaction OU	The OU in which the transactions recorded.
Transaction Type	Transaction Type corresponding various transactions for the given account code.
Balance (In account currency)	Transaction Amount for the account code in Account currency.
Balance (In base currency)	Transaction Amount for the account code in Base currency.
Balance (In parallel currency)	Transaction Amount for the account code in Parallel Base currency.
Cost center	Cost center recorded in the respective transactions for the account code.
Analysis code	Analysis codes recorded in the transactions for the account code.
Sub analysis code	Sub analysis code recorded in the transactions for the account code.
Ref Doc Type	Nature of reference document raised against the transaction fetched in "Transaction level search".
Ref Doc OU	Organization Unit in which reference document raised.
Ref Doc	Reference document No. of the transaction (if exists).
Item Code	Item Code recorded in the transactions (if exists).
Item Variant	Item Variant recorded in the transactions (if exists).
UOM	UOM recorded in the transactions (if exists).
Qty	Quantity recorded in the transactions (if exists).
Project OU	Project recorded in the transactions (if exists).
Project Code	Project code recorded in the transactions (if exists).
Bank Code	Bank code used in the transactions (if exists).
Bank Code description	Description of Bank code.
Customer	Customer code against whom the transaction is created.
Customer Name	Customer name against whom the transaction is created.
Ship to customer code	Ship to customer code corresponding to transaction created fetched in search.
Ship to customer Name	Ship to customer name corresponding to transaction created fetched in search.
Supplier Code	Supplier code against whom the transaction is created.
Supplier Name	Supplier name against whom the transaction is created.
Business Function Group	Business Function Group under which the transaction falls.
Narration	Narration provided while creation of the transaction.
Created by	User who created the transaction.