Viewing unmapped account / schedule details
This activity allows you to view the details of the account codes that have not been mapped to a schedule. You can also view the details of the schedule numbers that have not been mapped to another schedule or a layout. This activity can be used to view the details of the unmapped account codes or schedule numbers before creating a new schedule or layout. This page allows you to carry out a search and select the account code / schedule numbers that are yet to be mapped. You can carry out a search based on the type of the finance book and the code identifying the finance book. You can search by specifying a range of account codes or schedule numbers within which the unmapped account code or schedule number falls. You can also search by specifying the group to which the account belongs and the category under which the account is classified.
Select the “View Unmapped Account / Schedule” link under the “Financial Statement Layout” business component.
The “View Unmapped Account / Schedule” page appears.
Enter the following fields in the “Search Criteria” group box to search for account codes or schedule numbers that have not been mapped.
Account / Schedule |
Use the drop-down list box to select whether you want to view the details of the account codes or schedules that have not been mapped to a schedule or a layout. You can select from “Schedule No” or “Account Code”. |
| |
| |
The system displays “Account Code” by default on launch of the page. | |
Chart of Accounts ID |
Use drop-down list box to select the code identifying the operative chart of accounts. All the operative chart of accounts for the type of finance book selected will be available for selection in the ascending order. |
Note:
If “Main” finance book or tax book has been selected in the “Book Type” field all the chart of accounts ID that are of the type “Industry specific”, “Country specific” and “Operative Chart of account” will be available for selection.
If “Posting” finance book or tax book has been selected in the “Book Type” field all the chart of accounts ID that are of the type “Operative chart of account” will be available for selection.
If “Consolidation” finance book has been selected in the “Book Type” field all the “Active” consolidation chart of accounts ID will be available for selection.
The system displays the following:
Chart of Accounts Type |
The type of chart of accounts to which the selected chart of account ID belongs. |
Enter the following fields in the “Search Criteria” group box:
Book Type |
Use the drop-down list box to select the type of book that contains the unmapped account codes or schedule numbers for which you want to view details. All the types of finance books that have been deployed in the login organizational unit will be available for selection. You can select from “Posting finance book”, “Posting tax book”, “Main finance book”, “Main tax book”, or “Consolidation finance book”. |
Finance Book |
Use the drop-down list box to select the code identifying the finance book in which the details of the unmapped account codes or the schedule numbers are available. All the “Active” finance books that have been deployed in the login organization unit will be available for selection in the ascending order. |
Classification |
Use the drop-down list box to select the category under which the unmapped account has been classified from “Balance Sheet”, “Income Statement” or “Retained Earnings”. The system displays “All” by default on launch of the page. |
Account Code / Schedule No From |
The starting code or number in the range of unmapped account codes or schedule numbers that you want to retrieve (Alphanumeric, 32). If you know the account codes or schedule numbers you can enter it directly or specify it partially using the “*” character. The system retrieves the details of the account codes or schedule numbers that are similar to the value entered here. |
Note: The account code or schedule number entered in this field must be before the value entered in the “To” field.
To |
The ending code or number in the range of unmapped account codes or schedule numbers that you want to retrieve (Alphanumeric, 32). If you know the account codes or schedule numbers you can enter it directly or specify it partially using the “*” character. The system retrieves the details of the account codes or schedule numbers that are similar to the value entered here. |
Not Mapped to Layout No |
Indicates whether the schedule has been mapped to a layout number or not (Alphanumeric, 18). |
Account Group |
Use the drop-down list box to select the group to which the account belongs. You can select from “Asset”, “Liability”, “Capital”, “Revenue” and “Expenditure”. |
Click the “Search” pushbutton to retrieve the search results.
The system displays the following in the “Search Results” multiline based on the search criteria entered:
Account Code / Schedule No |
The code or the number identifying the unmapped account code or schedule number. |
Description |
A textual description of the unmapped account or schedule. |
Classification |
The category to which the account or schedule has been classified. |
Note: It could be “Balance Sheet”, “Income Statement” or “Retained Earnings” if it is an unmapped account code.
It could be “Balance Sheet”, “Income Statement” or “Cash Flow Statement” if it is an unmapped schedule.
Account Group |
The group to which the unmapped account code belongs. It could be “Asset”, “Liability”, “Capital”, “Revenue” or “Expenditure”. |