Report on Account Inquiry

Report on account inquiry

Account Inquiry is a statement listing the account and the transaction level details for an account code, for a financial Year. Tell me more.

Select the “Report on Account Inquiry" link under “Reports – Book keeping”.

The “Account Inquiry" page appears.

Enter the following fields in the “Basic Search” group box to search for the account details. Data entries in the following fields are optional:

Account Code	The code identifying the account. Mandatory. Help facility available.
Finance Book	Use the drop-down list box to specify the code identifying the finance book. The system lists all the finance books mapped to the login organizational unit of the company. The system displays the default finance book if specified in the “Set Function Defaults” activity. If the default finance book is not specified, then the system displays the first finance book loaded in the drop-down list box by default. Note: If the process parameter ‘Allow FB to load with “All”’ in the Set Finance Process Parameters activity of the OU Parameter Setup business component is set as ‘Yes’ the systems lists the value “All” along with the existing Posting FB's in active status. If the process parameter is set as ‘No’, the system lists only the specific FB's.
Financial Year	Use the drop-down list box to select the financial year in which you want to view the account inquiry. All the financial years defined for the company till the current financial year will be available for selection. The system displays the first value by default on launch of the page.
Financial Period From	Use the drop-down box to select the starting month in the selected financial year, for which you want, to view the account inquiry details. The system lists all the months for the financial year in ascending order. By default it display the current financial period for the selected Financial Year.

Note: The month selected in this field must be the same or less than the number entered in the "Financial Period To" field.

Financial Period To

Use the drop-down box to select the ending month for the selected financial year for which you want to account inquiry details. The system lists all the months for the financial year in ascending order.

Click the “Search” push button to retrieve the account details for the account code entered.

The following fields are displayed in the “Account Level Details” multiline.

Note: The transaction details for the selected account are not displayed in the “Transaction Level Details” multiline. Click the “Search” pushbutton in the “Transaction Level Search” group box to retrieve and view the transaction details.

Finance Book	The code identifying the finance book
Account Code	The code identifying the account
Account Currency	The code identifying the currency for the account code.
Balance (In Base Curr.)	The balance amount in the base currency of the login organization unit. If the selected account code's account group is 'Asset' or 'Liability' or 'capital' then get the account balance as on the last day of the financial period selected in 'financial period to' combo.
Balance (In Acct. Curr.)	The balance amount in the account currency in which the account was created. The balance amount will be the same if the Base currency and the currency of the account code (Account Currency) entered is the same.

Note: If the account group of the selected account code is an 'Asset', or 'Liability' or 'capital' then the account balance is the balance as on the last day of the financial period selected in the “Financial Period To”.

If the account group of the selected account code is an 'Expense' or 'Income', then the balance is computed by including all the transactions that have taken place within the financial period range selected.

Balances in Base and Account Currency are positive if the balance is a Credit Balance and negative if the balance is a Debit Balance.

If the reported account is an “Asset” or “Expense” account with a credit balance or “Liability” or “Revenue” account with a debit balance the balance has a negative sign.

Account Description

The textual description of the account (Alphanumeric, 40).

Account Group

The group to which the account that you selected belongs, such as “Assets”, “Liability”, “Capital”, “Revenue” or “Expenses”.

If there are no transactions in the account for the selected finance book, year, and period “0.00” is displayed in “Balance (In Base Curr.)” and “Balance (In Account Curr.)”.

Enter the following fields in the “Transaction Level Search” group box to search for the transaction details of the account. Data entries in the following fields are optional.

Note: When the “Account Inquiry” screen is launched from the “Review Financial Statements’ activity of the “Finance Book Processing” business component, only the transaction level information will be applicable.

Group Cost Centre	Enter the group cost center for which you want to view the transactions.
Cost Centre	Enter the cost center that is mapped to the group cost center, for which you want to view the transactions posted (Alphanumeric, 10). Help facility available
Analysis Code	Enter the analysis code for which the selected account is mapped in the "Assign Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5). Help facility available
Sub-Analysis Code	Enter the sub analysis code, which is mapped to the analysis code in the "Assign Sub Analysis Code" activity of the "Account Based Budgeting" business component. Help facility available
Expense Classification	The classification of the expense incurred by the transaction. Ensure that the value specified here is an “active” quick code as defined in the “Quick Code” business component. Help facility available.
Value From (In Base Curr.)	The starting amount, which is in base currency, of the transaction in the range of transaction amount for which the details are to be retrieved (Decimal). The system retrieves all the transactions whose transaction amount is greater than the amount entered here. The amount entered here must be lesser than the amount entered in the “Value To” field. If this field is left blank and the “To” field is entered, then the system retrieves all the vouchers whose amount is lesser than the amount entered in the “To” field.
Value To (In Base Curr.)	The ending amount, which is in base currency, of the transaction in the range of transaction amount for which the details are to be retrieved (Decimal). The system retrieves all the transactions whose transaction amount is less than the amount entered. If this field is left blank and the “Value From” field is entered, then the system retrieves all the transactions whose amount is greater than the value entered in the “Value From” field till the end of the database.
Addl. Search by	Use the drop-down list box to select the attribute that must be the basis for the transaction search. The drop-down list box displays the following: Aircraft Maintenance, Customer #, Customer Order, Purchase Order, Repair Order, Supplier #, Shop Work Order, and Created By.
Search Ref.	Based on the additional search criteria selected in the drop-down list box enter the attribute value that you want to search. You can enter the attribute value in full or specify it partially using the “*” character.
Total Records	Indicates the total number of transactions for the selected account and the number of records displayed currently

The following fields are displayed in the “Transaction Level Details” multiline:

Finance Book	The finance book code for the selected account
Account Code	The selected account code
Transaction Date	The date when the transaction occurred
Transaction No	The identification number of the transaction

Note: Click the Transaction No data hyperlink to view the voucher details in the "View Pay Voucher" page.

Transaction Type	The type of transaction which could be a receipt, or credit note, or voucher, or check.
Balance (In Base Curr.)	The balance amount for the transaction in base currency
Balance (In Acct Curr.)	The balance amount of the transaction in account currency
Cost Centre	The cost center to which the transaction is posted (Alphanumeric, 10). The account code is mapped to a cost center in the “Cost Setup” business component.
Analysis Code	The analysis code to which the selected account is mapped in the "Assign Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).
Sub-Analysis Code	The sub analysis code, which is mapped to the analysis code in the "Assign Sub Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).
Expense Classification	The classification of the expense incurred for the transaction.
Ref Doc Type	The type of reference document of the transaction.
Ref Doc #	The identification number of the reference document.
Note: Click the Ref Doc # data hyperlink to view the reference document details in the “View Reference Document” page.
Narration	Any remarks entered in the document.
Customer Order #	The identification number of the customer order associated with the transaction
AME #	The identification number of Aircraft Maintenance Execution for the transaction
SWO #	The shop work order number for the transaction
Customer #	The identification number of the customer.
Customer Name	The name of the customer.
Supplier #	A unique code identifying the supplier (Alphanumeric, 45). This code is unique across the organizational units.
Supplier Name	The name of the supplier (Alphanumeric, 150).
Business Function Group	The name of the business function group to which the account is mapped.
Created By	The login user ID of the person who initiated the transaction.

Click the “Export To Excel” push button to extract the details of the account inquiry to excel.

The system retrieves the account details and all the transactions for the selected accounts in an MS-Excel sheet.

Click the “Previous” pushbutton to view the previous set of transaction details in the multiline.
Click the “Next” pushbutton to view the next set of transaction details in the multiline.

Report on Account Inquiry – An overview

Account Inquiry is a statement listing the account and the transaction level details for an account code, for a financial Year. The user can analyze the transactions happening in an account and understand the total impact of the transactions on an account. An account inquiry can be generated in the base currency of the company and in the account currency. If a parallel base currency is available for a company, the account inquiry can also be generated in the parallel base currency. The details of the generated account inquiry can be viewed before being printed as a report. The account inquiry can also be generated and exported to an Excel work sheet.

This page allows you to set the criteria for generating an account inquiry for a finance book. Account inquiry is generated individually for different finance books. You can view account inquiry for a finance book irrespective of whether it is a “Main”, “Posting” or a “Consolidation” finance book. If a “Tax Book” is maintained for an organization unit, this page also allows you to set the criteria and generate an account balance for the individual tax books. The account inquiry generated can also be filtered based on transaction details by specifying the “Cost Center”, “Analysis”, “Sub Analysis”, “Expense Classification” codes, range of values in base currency, and additional search criteria values.

The account inquiry generated displays the account code, group, description, balance amount in base and account currency.