- Green versionCheck
- Green versionCheck
- Green versionCheck
1. Set "TV fee standard, billing date, billing period"
Use "System Administrator" to click [Set "Rating Fee Standard, Billing Date, Billing Period"] under the "Settings" menu, select the year to be set in the setting interface, enter the viewing fee standard, select the billing date, etc. content, click "Save".
Usually you only need to set the settings for the activation year. After the carryover to the next year, if the settings for the next year are the same as the previous year, there is no need to set them again.
2. Set the area (tun)
Use "System Administrator" to select a year on the main interface and click "Set Area (Tun) (Add, Modify, Delete)" under the "Settings" menu.
Usually, you only need to set the area (tun) for the year of activation. If it is carried forward to the next year, if there is no change in the area (tun) in the next year, there is no need to set it again.
It is best to have the same length of area (tunnel) numbers to facilitate correct sorting. For example, if the area (tunnel) number is 3 digits, the first number can be set to 001.
3. Set up the operator
As "System Administrator" click "Set Operator" under the "Settings" menu.
4. Set up users
As an operator of "System Administrator" or "Operation Group", select a year on the main interface, select the area (tun) where you want to set users, and click "Set Users (Add, Modify, Delete)" under the "Settings" menu.
Usually it is only necessary to centrally set users for the year of activation, and carry forward the settings to the next year, and only need to set up new users in the next year.
It is best to have the same length of user numbers for correct sorting.
After registration, you can also import user information that has been saved in the .xls file into the software through "Import users from .xls file" under the "Settings" menu to facilitate centralized user settings. Please see the detailed instructions below.
5. Perform operations such as "charging"
6. Carry forward to next year
As "System Administrator" click "Carry Forward" under the "File" menu. See detailed instructions below.
2. Software running sequence
1. Unregistered users will see the "Cable TV Billing Software - Registration" interface, click the "Try Now, Register Later" button to continue running the program.
This interface will no longer appear after registration.
2. Set commonly used printers: This setting is used to print query results and the printer and paper used for "A4 paper receipts".
After setting, run the software again and this interface will no longer appear.
To reset, click "Set Commonly Used Printers" under the "File" menu.
3. Select the activation year: The activation year defaults to the current year, and can also be set to other years, but it cannot be less than 2006 and cannot be greater than the next year.
After setting, run the software again and this interface will no longer appear.
4. If a prompt appears that the "TV fee standard, billing date, and billing period" have not been set, click "OK" to continue.
After setting, run the software again and this interface will no longer appear.
5. Enter "Unit Information".
After inputting, run the software again and this interface will no longer appear.
6. Select operator: There is only "System Administrator" when running the software for the first time.
In this interface, the operator password can be changed, the default operator can be set, and the operator set as the default will be automatically selected when the operator is selected.
To switch operators, you can click "Switch Operator" under the "File" menu without exiting the software and re-running it.
3. Charges
As an operator in the "System Administrator" or "Operation Group" or "Charge Only" group, click the "Charge" button below the main interface.
4. Adjust viewing fees and enter “other fees payable”
As an operator of "System Administrator" or "Operation Group", click the [Adjust viewing fee and enter "other fees payable"] button below the main interface.
Adjusting the viewing fee is used when the user's viewing fee needs to be increased or reduced, such as suspension or account cancellation.
When the arrears amount is carried forward to the next year, it will be displayed in the "Adjustment of Viewing Fees" column.
Entering "Other fees payable" is used when the "initial installation fee, migration fee, late payment fee" incurred by the user cannot be paid in time, such as: installation at the beginning of the year, initial installation fee at the end of the year, etc.
"Initial installation fees, migration fees, late payment fees", etc. that are collected at any time do not need to be entered in "Other fees payable", just click "Charge" to collect them.
Other fees are only calculated in arrears, not balances. Other fees payable are only used to calculate arrears.
5. How to print receipts, modify and delete charges and fees payable
1. Print receipt
(1) In the charging interface, you can click the "Print viewing fee receipt" and "Print other fee receipt" buttons to print the last saved viewing fee and other fees;
(2) You can click on the charge for which you want to print a receipt in the two lists below the main interface, right-click the mouse and select "Print Receipt".
2. Modify or delete "Adjustment of viewing fees, viewing fees paid, other fees payable, and other fees paid"
In the two lists below the main interface, click on the "Adjusted viewing fees, paid viewing fees, other fees payable, other paid fees" that you want to modify or delete, right-click the mouse and select "Modify" and "Delete".
6. Suspension and account cancellation
As an operator of "System Administrator" or "Operation Group", click "Report Suspension, Cancel Account" under the "File" menu.
7. Relocation and name change
As an operator of "System Administrator" or "Operation Group", click "Migrate, Rename" under the "File" menu.
8. Back up data
Click "Backup Data" under the "File" menu.
9. Delete the year
As "System Administrator" click "Delete Year" under the "File" menu.
10. Import user instructions from .xls file
This function is used when "registering users from multiple computers through .xls files" is merged into one computer, or when there is already a "user information file in .xls format". The import steps are as follows:
1. Copy "Import user template.xls" under the "Cable TV Billing Software" folder;
2. Rename the copied file to distinguish the user from which region (tunnel);
3. Remove the read-only attribute of the copied file;
4. Enter user information in the copied file. The requirements are as follows:
(1) The user name cannot be empty;
(2) The user number cannot be empty, the number must be numeric characters, and there cannot be spaces in the number;
(3) Do not include the area (tunnel) number in the user number. When importing, there will be an option to determine whether the software will set the first few digits of the user number as the area number;
(4) In the initial installation date, the year, month and day are separated by "-". If the month and day are less than two digits, add 0. The format is such as: 2014-01-01.
5. When copying user information from your existing "user information file in .xls format" to the template, the requirements are as follows:
(1) When pasting, click "Paste Special" under the "Edit" menu;
(2) Click the "Value" option in the "Paste" option of the "Paste Special" dialog box;
(3) Click the "OK" button in the "Paste Special" dialog box.
6. Click "Import users from .xls file" under the "Settings" menu of the cable TV charging software → Import users;
7. Follow the prompts to select the template file in which you entered the user information, and click "Import".
11. Instructions for carry forward to next year
1. By "carrying forward to the next year", you can create the next year's data, and carry forward the "region (tunnel)", "user", "setting of the viewing fee standard and billing date", "arrears and balance", etc. to the next year. .
2. In the year that has been carried forward, the "Region (Tuen)", "User", "Rating Fee Standard and Billing Date", etc. can no longer be set, and no more charges can be made.
3. If the user's unsettled arrears have been carried forward to the next year, they can be collected in the next year.
4. When carrying forward, if it has been carried forward to the next year, it cannot be carried forward to the current year, because "carrying forward to the next year" will transfer data such as "arrears and balances" to the next year, affecting the data of the next year. . At this time, if there are special needs, you can operate the "current year" through "Mark as carry forward (do not process data)". Otherwise, you need to "cancel the carry forward for the next year" or "cancel the carry forward for the next year" first. After the flag is transferred (data is not processed), the current year will be carried forward to the next year."
5. When carrying forward, if it has not been carried forward from the previous year, it cannot be carried forward to the current year, because the previous year may need to carry forward "arrears and balances" and other data to the current year through "carry forward to the next year" . At this time, if there are special needs, you can operate on the "previous year" by "marking as carry forward (do not process data)". Otherwise, you need to carry forward the previous year to the next year, and then carry forward the current year. next year.
6. When re-carrying forward, the data such as "Region (Tuen)", "User", "Rating Fee Standard and Billing Date Settings", "Arrearage and Balance" that have been carried forward to the next year will be deleted first, and then the data will be re-carried forward. . Data that has been carried forward to the next year and modified in the next year will not be deleted.
7. It is best to carry it forward to the next year on or after December 31 of each year, because at this time, no matter how the billing date is set, the arrears and balance can be accurately calculated. If the billing date is January 1 of each year, it can be carried forward in December. If the billing date is dynamically based on the "month and day corresponding to the initial installation date" or a day other than "January 1st", it is best to carry it forward on or after December 31st.
8. For "TV fees", the arrears and balances will be calculated based on the "TV fees standards and billing date", "TV fees paid" and the "Adjusted TV fees" for special users, as well as "TV fees that should be refunded but have not been refunded" will be calculated. "Refund" situation, and the arrears, balances and amounts to be refunded will be carried forward to the next year.
9. For "other fees other than viewing fees", the user's "other fees" arrears and "other fees that should be refunded but have not been refunded will be calculated based on the entered "other fees payable" and "other fees already paid" ” situation, and carry forward the arrears and the amount to be refunded to the next year. The difference between other fees paid and the "entered other fees payable" will not be treated as a balance and will not be carried forward to the next year.
12. Instructions for canceling carryover
1. Through "Cancel Carryover", you can cancel the "Carryover Flag" of the current year, and at the same time delete the "Region (Tuen)", "User", "TV Fee Standard and Billing Date Settings" that have been carried forward to the next year. Arrears and balances" and other data. Data that has been carried forward to the next year and modified in the next year will not be deleted.
2. When canceling, if it has been carried forward to the next year, you cannot cancel the carryover of the current year, because "cancelling the carryover" will delete the relevant data that has been carried forward to the next year. At this time, if there are special needs, you can operate the "current year" through "Cancel the carryover flag (do not process data)". Otherwise, you need to "cancel the carryover for the next year" or "cancel the carryover for the next year" first. After setting the "Transfer flag (do not process data)", the carryover will be revoked for the current year.
13. Instructions marked as carryover
1. The current year can be marked as "carried forward" through "Mark as carried forward", but the "Region (Tuen)", "User", "Settings of viewing fee standards and billing dates", "Arrearage and The balance is carried forward to the next year.
2. In the year marked as carryover, the "Region (Tuen)", "User", "Rating Fee Standard and Billing Date", etc. can no longer be set, and no more charges can be made.
3. When marking, since the data of the next year will not be affected, the current year can be marked as carried forward regardless of whether it has been carried forward to the next year.
4. When marking, if the previous year has not been carried forward, the current year cannot be marked as carried forward, because the previous year may need to carry forward the "arrears and balances" and other data to the current year through "carry forward to the next year" year. At this time, if there are special needs, you can operate the "previous year" through "Mark as carry forward (no data processing)". Otherwise, you need to carry forward the previous year to the next year, and then mark the current year as carry over.
14. Instructions for canceling the carryover mark
You can cancel the "carryover flag" of the current year through "Cancel Carryover Flag", but the "Region (Tun)", "User", "TV Fee Standard and Billing Date Settings" that have been carried forward to the next year will not be deleted. Data such as "arrears and balances".
15. Query and print
On the last page of the print preview, there are statistics and summaries of this query range. You can click the ">| (last page)" button on the "Print Preview" toolbar to directly display the last page. If you only want to print the last page, you can enter the page number of the last page to print.
it works
it works
it works