|
|
|
|
This page allows you to modify the details of the selected schedule. Tell me more.
Select the “Edit Schedule” link at the bottom of the “Select Schedule” page.
The “Edit Schedule” page appears.
The system displays the following:
|
Schedule No |
The number identifying the schedule. |
Enter the following fields:
|
Schedule Description |
A textual description of the schedule (Alphanumeric, 100). Mandatory. |
|
Zoom facility available | |
|
Effective Date |
The date from which the schedule will be ineffective (Date Format). The date entered here must be the same or later than the system date. |
The system displays the following:
|
Schedule Classification |
Indicates the category under which the schedule is classified. It could be “Balance Sheet”, “Income Statement” or “Cash Flow Statement”. |
|
Book Type |
Indicates the type of the finance book in which the schedule is available. It could be “Posting finance book”, “Posting tax book”, “Main finance book”, “ Main tax book”, or “Consolidation finance book”. |
|
Finance Book |
The code identifying the finance book in which the schedule is available. |
|
Chart of Accounts ID |
The code identifying the chart of accounts under which the account codes that form part of this schedule falls under. |
|
Description |
The description of the chart of accounts ID. |
|
Chart of Accounts Type |
The type of the chart of accounts. |
Enter the following fields in the “Add Account Code / Schedule No” group box to add a new account code:
|
Account / Schedule |
Use the drop-down list box to select whether you want to retrieve account codes or schedule numbers to be mapped to this schedule. You can select from “Account Code” or “Schedule No.”. |
| |
| |
|
Account Code |
The code identifying the account that you want to add to the schedule (Alphanumeric, 32). The account code must be a valid one for the type of the finance book and the finance book in which the schedule has been created and must be in an “Active” status. |
|
Help facility available |
Note: This field must not be left “Blank” if “Account Code” has been selected in the “Account / Schedule” field.
The classification of the account code must be the same as the schedule classification that is if “Schedule Classification” of the schedule that is being modified is “Balance Sheet” the account codes that are being grouped under must also have “Balance Sheet” as its classification.
|
Schedule No |
The number identifying the schedule that you want to add to the schedule (Alphanumeric, 18). The schedule number must be a valid for the type of the finance book and the finance book in which the schedule has been created and must be in an “Active” status. |
Note: This field must not be left “Blank” if “Schedule No” has been selected in the “Account / Schedule” field
The schedule classification must be the same that is if “Schedule Classification” of the schedule that is being modified is “Balance Sheet” the schedule numbers that are being grouped under must also have “Balance Sheet” as its classification.
|
Assign New Group |
Check the box provided alongside if you want to assign the account codes to a new group. |
|
Group heading |
A unique description of the new group (Alphanumeric, 120). Mandatory. |
|
Zoom facility available | |
|
Total Description |
A textual description of the schedules that have been grouped (Alphanumeric, 120). Mandatory. |
|
Zoom facility available |
Note: The account codes and the schedule numbers must be unique in a schedule.
Click the “Add Account / Schedule / Group” pushbutton to add a new account code or a schedule number to an existing schedule.
The system generates a unique group ID for the group.
Enter the following field in the “Account Code / Schedule No Information” multiline:
|
Include |
Use the drop-down list box to select whether you want to include the account code or the schedule number in the new group under the schedule. |
| |
|
The system displays the following:
|
Account Code / Schedule No |
The code identifying the account or the number identifying the schedule. |
Enter the following field in the “Account Code / Schedule No Information” multiline to modify the details if required:
|
Description |
A textual description of the schedule or group heading (Alphanumeric, 120). |
Note: This field must have a unique group description if “Assign New Group” has been checked.
The system displays the following:
|
Classification |
Indicates the category under which the account is classified. It could be “Balance Sheet”, “Income Statement” or “Retained Earnings”. |
|
Account Group |
Indicates the group to which the account belongs. It could be “Asset”, “Liability”, “Capital”, “Revenue” or “Expenditure”. |
Enter the following fields in the “Account Code / Schedule No Information” multiline:
|
Sequence No |
A sequential order in which the account codes or schedule numbers must be available in the new schedule (Integer). |
|
Account Balance |
Use the drop-down list box to select the balance that you want to display in the schedule. You can select from “Closing Balance”, “Period Credit”, “Period Debit”, “Period Amount” or “Opening Balance”. |
|
Add / Subtract |
Use the drop-down list box to set whether you want to add or subtract the group balances. You can select from “Add” or “Subtract”. |
|
Print / View |
Use the drop-down list box to set the type of balance that you want to print or view on screen. You can select from “Both”, “Positive”, “Negative” or “Do not print”. |
| |
| |
| |
|
Click the “Edit Schedule” pushbutton to save the modifications made.
The system generates sequence numbers for the newly added account codes or schedule numbers. The system also generates sequence numbers for the new groups that have been created under the schedule.
Note: You cannot delete a schedule if it does not have an “Effective Date”.
Click the “Delete Schedule” pushbutton to delete the schedule.
The status of the schedule is updated as “Inactive”.
The system displays the following:
|
Created By |
The login ID of the user who created the schedule. |
|
Created Date |
The date on which the schedule was created. |
|
Last Modified By |
The login ID of the user who last modified the schedule. |
|
Last Modified Date |
The date on which the schedule was last modified. |
To proceed, carry out the following
Select the “View Schedule” link at the bottom of the page to view the details of the selected schedule.
Select the “Copy Schedule” link at the bottom of the page to copy the details of the selected schedule.
Modifying schedule details – An overview
|
|
You can create new sub groups under the selected schedule. You can also add an account code or another schedule number to the schedule that is being modified. You can enter the account code or the schedule number if you know it directly or use the help facility that has been provided to select the account code or the schedule number. You can assign the account code or the schedule number to a new sub group. You can add only one account code or schedule number to an existing schedule or sub group at a time. A unique ID is generated for the new group. While adding a new account code or a schedule to an existing schedule care must be taken to have unique account codes across the schedule.
You can modify details of the account like the balance that is to be displayed and the indent set. If you want to remove an account code or schedule number from the existing schedule you can do so by removing the include flag set for the account code or schedule.
This page also allows you to delete the selected schedule. The status of the schedule number after deletion is updated to “Inactive”. You must enter an effective date from which the schedule number will not be used. The system stores the login user ID and the system date along with the modified details of the schedule.
Add account codes or schedule numbers
Select account codes / schedule numbers to be included in the new schedule
Select the balance to be displayed
Select the type of balance to be displayed
Add account codes or schedule numbers
You can add new account codes or schedule numbers to the schedule that is being modified. The account codes and the schedule numbers must be unique for the schedule that is being modified.
Set the “Account / Schedule” field to “Account Code” to add an account code.
Set the “Account / Schedule” field to “Schedule No” to add a schedule number.
Enter the account code in the “Account Code” field
Enter the schedule number in the “Schedule No” field.
Click the “Add Account / Schedule / Group” pushbutton.
You can create a new sub group under the schedule that is being modified.
Check the “Assign New Group” box.
Enter the description of the new group in the “Group Description” field.
Select account codes / schedule numbers to be included in the new schedule
You can select the account codes / schedule numbers to include them as per the requirement in the new schedule.
Set the “Include” field to “Yes” if you want to include the account code or schedule number available in the row to the schedule.
Set the “Include” field to “No” if you do not want to include the account code or the schedule number available in the row to the schedule.
You can delete the schedule if it is not required. A deleted schedule can no longer be used.
Enter the date in the “Effective Date” to set the date from which this schedule will no longer be used.
Click the “Delete Schedule” pushbutton to delete the schedule.
The status of the schedule is updated as “Inactive”.
Select the balance to be displayed
You can select the type of account balances that you want to view or print in the schedule. You can view or print the “Closing Balance”, “Period Credit”, “Period Debit”, “Period Amount” or the “Opening Balance” of the account.
Set the “Account Balance” field to “Closing Balance” if you want to view / print the closing balances of the account.
Set the “Account Balance” field to “Period Credit” if you want to view / print the credit balances of the account at the end of a financial period.
Set the “Account Balances” field to “Period Debit” if you want to view / print the debit balances of the account at the end of a financial period.
Set the “Account Balances” field to “Opening Balance” if you want to view / print the opening balances of the account.
Select the type of balance to be displayed
You can select the type of account balances that you want to view or print in the schedule. You can view or print the “Positive”, “Negative”, “Both” or “Do not Print”.
Set the “Print / View” field to “Positive” to print / view only the positive account balances.
Set the “Print / View” field to “Negative” to print / view only the negative account balances.
Set the “Print / View” field to “Both” to print / view both the positive and negative account balances.
Set the “Print / View” field to “Do not Print” if you do not want to print / view the account balances
