208-436-1912 (Fax) 208-436-1914 cti@pmt.org
Computer Technology, Inc.	301 Scott Ave. #1 Rupert, ID 83350

Program Enhancements & Changes-------------------------- March 08, 2007

Project #2312 – Sales Person Required Based on NPA and NXX

We have added the ability to Require the Sales Person in the Phone Number Information screen based on NPA and NXX in addition to required by Company Number.

Within User Edit ‘SALESPERSONEACHSVO’ you can enter Company Numbers or NPA and NXX that require a Sales Person to be added in Service Order Entry on all Accounts that are within the Company Numbers or NPA and NXX entered. All Service Orders with the Company Numbers entered into Field 3 will require Sales Person Code 1 and 2 to be entered. All Service Orders with the NPA and NXX entered in Fields 4 through 8 will require Sales Person Code 1 and 2. * You can enter Company Numbers and NPANXX or you can enter Only Company Number or Only NPANXX.

Setup User Edit:

Field 1 = SALESPERSONEACHSVO

Field 2 = Leave Blank

Field 3 = Enter Company Numbers that require a Sales Person Code

OR

Field 4 = Enter the NPA and NXX that require a Sales Person Code

Field 5 = Enter the NPA and NXX that require a Sales Person Code

Field 6 = Enter the NPA and NXX that require a Sales Person Code

Field 7 = Enter the NPA and NXX that require a Sales Person Code

Field 8 = Enter the NPA and NXX that require a Sales Person Code

(Field 3 - Enter without any spaces. Example if Company 2 & 6 requires a Sales Person Code, Enter 26)

(Fields 4 through 8 - Enter NPANXX followed by a period, then enter the next NPANXX. Example; 208436.208734.541652)

Project #2313 – Task Manager Added to the Riata Programs Menu

We have added ‘Task Manager’ to the Riata Programs Menu under the ‘Other’ options on the right hand side.

Project #2320 – Inventory History Added to Riata Programs Menu

We have added ‘Inventory History’ to the Riata Programs Menu. This feature gives you the ability to search the Inventory History File or the Phone File by Inventory Number, Serial Number and/or Electronic Serial Number. Once you select Inventory History from the Riata Programs Menu, the following Screen will be displayed;

– Click on File, the search the Inventory Master or Inventory Detail

– Enter the Inventory Number, Serial Number or Electronic Serial Number and Press Find History for details on that Inventory Number

– Select ‘Search for ESN in Phone File’ to locate a specific phone regardless of when it was sold. This is useful if someone turns in a found phone.

The following Screen will be displayed to enter your Search criteria.

Project #2318 – Ability to Clear the ‘Pay Later File’

Within the New 2007 Service Order, when entering a Cash Receipt there is an option to ‘Pay Later’. When this option is used the Cash Receipts are stored in a ‘Pay Later’ File. You now have the ability to Review and/or Remove these Cash Receipts from this file. Contact your Security Personnel to get Authorization to this Feature.

** Use this to Clean-up the ‘Pay Later’ file Manually.

- The following screen will be displayed when selecting ‘Pay Later’ from the Riata Programs Menu.

- Color change indicates separation of each Cash Receipt

- Double Click on the Line item you wish to Remove

- Single click using your Ctlr button will allow you to select more than one at a time.

Project #2324 – Inventory / Charge Tax User Edit

A new User Edit called ‘INVENTORY-SALE STATE-TAX-ALWAYS’ will leave the ‘Charge Tax’ checked even if the customer has ‘No’ selected for the ‘Charge State Tax’ in the Phone Number Information screen. This is so you can Not Charge State Tax on Recurring Charges, but still Charge State Tax on Inventory Items.

Setup User Edit

Field 1 = INVENTORY-SALE

Field 2 = STATE-TAX-ALWAYS

Field 3 through 8 = Leave Blank

If this User Edit is setup, and the account has a ‘NO’ selected on the Phone Number Information screen, Taxes Tab;

- When adding Inventory, the ‘Charge Tax’ will still be checked.

Project #2321 – Edit Switch Commands

We have a new option on the Riata Program Menu called ‘Switch19 Commands’. This option will allow Edits to Switch Commands. Contact your Security Personnel to get Authorization to this Feature.

- The following screen will be displayed when selecting ‘Switch Commands’.

- To ‘Delete’, highlight the command you want to Delete and click on the Delete button.

- To ‘Edit’, double click on the command you want to change. (The same screen as shown below when Adding will be displayed)

- To ‘Add New’, click on the Add New button and the following screen will be displayed;

- Enter the Switch Command Information you want to change or add. Select Save & Exit or Exit without Saving.

- Edit Add and Delete fields together

If this button is selected the following screen will be displayed;

- Enter the Switch Command Information you want to change or add. Then select ‘Return to Normal Fields’ – the changes will be displayed on the previous screen and you can now select Save & Exit or Exit without Saving.

Project #2116 – SMS Information Displayed on Toll Information Screen

You now have the ability to view SMS Information from Toll Inquiry. In Inquiry, select the ‘Toll Inquiry’ button. On the top right of the ‘Toll Information’ screen select ‘SMS Messages’. The following screen will be displayed.

- You can select to view the History File or Unbilled File

- You can select to view 1 to 24 months past.

- Click on the Grid Heading to sort by Date, Time, Direction, Batch, From Phone or To Phone.

- Click on Excel Spreadsheet to load the information into Excel.

Project #2332 – SMS Review

We have a new option on the Riata Program Menu called ‘SMS Review’. This option will give you the ability to view SMS Records. Contact your Security Personnel to get Authorization to this Feature.

- The following screen will be displayed when selecting ‘SMS Review’.

- TCALSMC2 will be the default SMS File displayed.

- If you wish to view another file, enter the SMS File name and click on ‘Refresh’ to load the SMS file.

- You can sort by Account, Phone Number, SMS Messages or Date & Time.

- There is also the ability to Print and Save to Excel.

Project #2374 – LOCKNOTES User Edit Change

If you have the "LOCKNOTES" User Edit setup, we now allow the user to Change the Notes they have added until the Service Order is Updated and Approved Yes or No.

Project #2375 – Access Minutes for a Number

You now have the ability to view Access Minutes from Toll Inquiry. Remember, Access Minutes are all calls for a number, not just Toll Billed calls. In Inquiry, select the ‘Toll Inquiry’ button. On the top right of the ‘Toll Information’ screen select ‘Access Minutes’. The following screen will be displayed.

- The system will default to Unbilled Information.

- To view History Information; Select History, Enter a Year & Month, select Our Switch or Other Switch, then click on Load.

- Options to Print and Download to Excel are available at the bottom of the screen.

If you select Filter Calls – The following window will be pop-up over the screen as shown below;

- Enter Filter information and Select Apply Filer.

Project #2404 – Query Switch Option Available in Riata Inquiry

You can now Query Switch Information from Riata Inquiry. On the first Inquiry Screen, enter the entire 10 digit Number then click on the ‘Query Switch’ button located to the right of the number.

Project #2405 – Clear Toll Files

You now have the option to Clear Toll Files that have already been uploaded to the AS/400. From the ‘Riata Programs Menu’ select “Files to Process for Toll”. Use this if you are 100% sure that the Toll has been read in and Not posted and you want to clear it out and start over.

Reminders:

You have the “Edit/Print File” Button that you can use to Delete individual files if you have clicked “Process these files” button and then realize you had the wrong options selected for 1, 2, 3 on the left side of the screen for type of file you are processing.

You have the “Remove From List” button that you can use to Delete individual files that have been loaded into the list but you have not yet clicked the “Process these files” button.

As you can tell we have added many options for you to clear out your toll and start over from the start. Please use caution and make sure you really want to clear out the files and start over.

Click on the ‘Clear Files’ Button

A drop down box will be displayed; Click on the option you want to clear.

Once you have selected which Toll Menu to Clear, the following WARNING will be displayed.

- Click Yes to Clear the File

- If you select No or Cancel you will be returned to the Toll File Processing Selection Screen and nothing was cleared.

When the file is successfully cleared the following message will be displayed.

Error:

If the system is unable to find the file, the following message will be displayed.

- Click on OK and you will be returned to the Toll File Processing Selection Screen and nothing was cleared.

Project #2406 – ‘Sell Nothing’ Button Added to Service Order Entry

We have added a ‘Sell Nothing’ button to the Inventory Sales Item Detail Screen in Service Order Entry.

- Once you select this button, nothing will be sold and both the Detail Screen and the Inventory Sales Invoice screen will be Closed and you will Continue on with the Service Order.

Project #2210 – Payroll History Columns Selection

We have added a button called ‘Predetermined Columns’ option in Payroll – Employee History option. We have also created a new User Edit called ‘Payroll Print-History’. This User Edit allows the you to change the Column Display & Order when the Predetermined Columns button in Employee History is selected.

From the Riata Programs Menu, select ‘Payroll Time Entry’, then click on the ‘History’ button located at the bottom right of the Payroll Screen, then Select the employee and enter date range you wish to review – click on the ‘Select’ button.

The following Screen will be displayed:

- Click on ‘Show Predetermined Columns’ and the following screen will be displayed showing only the columns you select in the User Edit (PAYROLL PRINT-HISTORY) and the order you entered them in.

- If you would like to change the Order of the Columns click on ‘Column Order’ and the following window will be displayed.

- You can change the order of the column in this screen then click on Update.

- NOTE: This will automatically Setup User Edit (PAYROLL PRINT-HISTORY). and you will be returned to the Employee History Predetermined Columns Screen displaying the order you selected.

User Edit Details:

Field 1 = PAYROLL

Field 2 = PRINT-HISTORY

Field 3 through 5 = Enter the 2 digit column number separated with a period. (00.xx.xx.xx.xx)

**Column #00 = Employee must be entered first in Field #3 – If Not entered, once the User Edit is Updated, Column #00 will be displayed in the first position.

Field 6 through 8 = Leave Blank

For example if you only want to see the Employee Number, Date, Regular Hours, G/L#, Budget Code and Notes; you would setup the User Edit as shown here.

Note: Remember – Employee is Column #00, and needs to be entered first.

Project #1934 – Show Un-Posted Cash Receipts

You now have the ability to check if there is any Un-Posted Cash Receipts for a given Account. This option can be accessed from the Balance Tab in Riata Inquiry - Customer Account Information screen or within the ‘Show Posted Cash Receipts’ button, by clicking the ‘Show Un-Posted Cash Receipts’ button.

- We have changed the ‘Show Cash Receipts’ button to ‘Show Posted Cash Receipts’.

- New ‘Show Un-Posted Cash Receipt’s’ button added.

- Balance with Un-Posted Cash Receipts

Project #2469 – Auto Disconnect Toll Restrict/Suspend Updated After Cash Receipts are Reviewed & Updated

We no longer allow the cash receipts program to directly change the "Toll Restrict"/"Suspend" status of a phone number in the Auto-Disconnect program. Cash Receipts will still indicate such a status change is desired, however the change will not be made until the Cash Receipts are marked ‘Reviewed’ and Updated.

When a Cash Receipt is taken on a Account that is in the Disconnect file and has been ‘Toll Restrict, Suspend or Disconnected’, the following screen is displayed.

- If the CSR checks the ‘Send Toll Un-Restrict, Send Un-Suspend or Send Un-Disconnect’ then Updates, this will no longer update the Auto Disconnect program. Instead it will show as a desired change and will need to be confirmed when Cash Receipts are Reviewed.

When Reviewing Cash Receipts Changes, the following screen is displayed.

The User will Check the ‘Reviewed’ box if the Desired Change is Approved or the ‘Don’t do’ box if the Desired Change is Not Approved.

In this example:

The 1^st Account shown has been marked ‘Reviewed’, therefore a ‘Toll Un-Restrict’ change will be made to the Auto Disconnect Program once Update is selected.

The 2^nd Account has been marked ‘Don’t do’; therefore even though the CSR said to ‘Un-Toll Restrict’ no changes will be made to the Auto Disconnect Program.

Project #2470 – Inventory Detail History – Last Updated YY/MM/DD

We have changed the "Last Updated" date on the Inventory Detail History screen to an YY/MM/DD format so it will be easier to sort the column by date.

Project #2479 – More Tariff Detail Displayed in Riata Inquiry / Non-Recurring Charges

We have added ‘Description, ‘Service Order’ and ‘Updated By’ for each Charge to the Non-Recurring Charges Screen in Riata Inquiry.

- We have also added a checkbox "Omit Zero Cost Items". When this box is checked Charges with a $0.00 Unit Cost will not be displayed.

Project # 123 – Move the Balance Amount/Account Only Non-Recurring Charges

We have added a way to let the user move the Balance Amount on an Account only Non-Recurring Charges, and the Current Cash Receipts to a different Account.

From Service Order Entry, Customer Account Information Screen, Balance tab:

- Click on ‘Move Balance’ button.

** Contact your Security Personnel, for authority to this option.

(Details on Page 11& 12 of Security Manual)

- Select ‘Move Balance’, ‘Move Only Account Non-Recurring’, and ‘Move Cash Receipts’. (Check as many as apply)

- NOTE: ‘This move may not take affect until the Balance is Recalculated’.

- Click on Move Information to complete the task or ‘Exit’ to cancel and nothing will be moved.

The following message will be displayed to confirm and double check the balance you are moving and the Account that you are moving it to.

Project # 471 – Automatically Display Note Program when a Note is Required

We now automatically display the note program on the Phone Number Information and Customer Information screens in Service Order entry if a note is required to update the Service order and has not been entered.

To require a Note by Service Order Type, from Start1 Menu: Select # 1 (Customer Information), then select #19 (Riata), then select #20 (Maintenance Items) then select #14 (Common Defaults) – Page #4

Enter ‘Y’ (Yes) – Notes/Desc Required.

To require a Note by Service Order Type, from Start1 Menu: Select # 1 (Customer Information), then select #19 (Riata), then select #20 (Maintenance Items) then select #4 (Service Order Type 2 Codes)

Enter ‘Y’ (Yes) – Is Note Required.

If both Notes fields shown above indicate ‘Y’ (Yes) a Note is required. When a Service Order is entered for the Type Code that has a ‘Y’ (Yes) for Note is Required, the Note window will appear and a Note must be entered before the Service Order can be completed.

Project # 2077 – Riata Sign-On ‘User Name Blank’

Setup the following new User Edit if you want the Riata Sign-On/Password window to Not display User Name that last signed on at this PC.

If this User Edit is setup, when signing on to Riata, the Password window will not default a User Name.

To Set-Up User Edit:

Field 1: PASSWORD-SIGN-ON

Field 2: BLANK-USER-NAME

- Password window will not display a User Name.

Project #2502 – ‘Omit Zero Count’ in Riata Inquiry

We have added a new checkbox to ‘Inquiry - Recurring Charges’ Screen called "Omit Zero Cost Items". If this box is checked, $0.00 Total Cost’s will Not be Displayed.

Project #2515 –Selected Tariff Codes to Pro-Rate to their Full Cost

We have added a new User Edit called PRORATE-FULL. The User Edit will allow you to enter Tariff Codes which will always be pro-rated to their Full Cost, no matter how many days you are pro-rating for.

In the Tariff Master, there must be a ‘Y’ (Yes) in the Pro-Rate Field.

To Set-Up User Edit:

Field 1 = PRORATE-FULL

Field 2 = Leave Blank

Field 3 through 8 = Tariff Code followed by a decimal (xxxxx.xxxxx.xxxxx.)

** Remember to key leading spaces if the tariff code if not 5 long.

In this example, Tariff Codes QM800 & QUMTM would be pro-rated to their Full Cost regardless of the number of days in the Pro-Rate Recurring Charges Screen; however Tariff Code QVMEN is Pro-rated for 16 days as shown.

Project #2128 – Cash Receipts / Save PDF Documents to a Path Based on Location

We now allow you to save your Cash Receipts PDF documents to a path based on location.

First you must have the "S2PCINFO" user edit setup. This User Edit identifies the PC location information.

For this application; only Fields 1, 2 and 7 are needed.

Setup User Edit;

Field 1 = S2PCINFO

Field 2 = Enter the PC Name (Example: Burley01)

Field 3 = Enter the Location Name for the next Service Order (Example: Burley)

Field 4 = Enter the NPA & NXX (Example: 208678)

Field 5 = Enter the Service Type (Example: Wireless)

Field 6 = Enter the Code for the Next Account # (Example: Syringa)

Field 7 = Enter the Actual Location (Example: Burley)

Field 8 = Leave Blank

Second you setup the new User Edit ‘CASHRECEIPT-PDFSAVE’. This User Edit allows you to Save your Cash Receipts PDF documents to a Path based on Location. This will be used if you have different locations that use Riata Cash Receipts and want to save the PDF documents in a different folder for each location.

Setup User Edit;

Field 1 = CASHRECEIPT-PDFSAVE

Field 2 = Enter Location (Same as Field #7 in S2PCINFO User Edit)

Field 3-8 = The Path to Save the PDF (Example: N:\CashReceipts)

NOTE: User Edit ‘CASHRECEIPT PDFSAVEPATH’ will continue to be used if there is not a ‘CASHRECEIPT-PDFSAVE’ User Edit for a Location.

Project #2533 – ‘Billing in Progress’ Button

We have added a ‘Billing in Progress’ Button to Riata Inquiry. This will allow you to view Statement Details on an Account. After Step #6 is done in Billing you can now view the Statement Information even before Billing is completed and before you Print the Statement.

From Riata Inquiry – Customer Account Information – Show Statement Button –

- Billing in Progress

Once this option is checked then you select ‘Show Statement Detail’ – all Statement Detail will be displayed, even if the Statement has not been printed yet or the Update done (#8).

The following screen will display all the Statement Detail.

– You have the ability to scroll up & down through this screen to view all the detail. (We took away the Previous & Next options – the entire bill is now displayed).

– You have the ability to Send this Detail to Excel

– You have the ability to Print the detail from this screen.

Billing in Progress Button is also on the Statement-Detail Screen.

- Note: If Billing in Progress is Checked, How Many Months Ago is Ignored.

- Click on Reload to view the Month already Displayed.

Project #1623 – Clean Local & Shared Riatabill Folder

You now have the ability to Clean your Local and Shared Riatabill Folder. This will allow you to remove the programs that are in the Riatabill folder and copy the Riata programs from the shared folder to the local computer. After this has ran there will be 3 Files left on the local computer. They are: Enumerator.dll, miscctls.ocx, and verinfo.dll.

To run, this click "Setup" from Riata Menu then select "Copy From Shared Drive to Local Drive" program, then select the C:\Ritatabil (Local) or N:\Riatabil (Shared) – the Shared Drive number will depend on what number you have identified as your Shared Drive. Then click on the "Clean Up" button.

The following message will be displayed.

Select ‘Yes’ to continue and Clean the Files in the Drive you select previously.

Select ‘No’ to cancel and return to the ‘Copy from’ Screen.

When selecting ‘Yes’, the system will clean the files and when it has completed this task the following message will be displayed.

Select OK – then you will be returned to the ‘Copy from’ Screen – then Select to ‘Copy All Programs’ before running Riata.

Project #2189 –911 Change Note Type Changed to ‘911CG’

The following Only happens if you tell the system to change 911 Location each Night when JHDAILY is run and we process the 911 changes. We generate a Note that was type CSR and will now be Note Type ‘911CG’.

** Here is a Reminder of how to Remove History Records; From Start1 Menu, select option #23 (System Maintenance) then option #11 (Remove History Records). We have added steps to this process so you will be allowed to delete the BGEO 911 Change Notes.

During this process the following message will be displayed.

Select ‘Y’ (Yes) to Delete the BGE0911 Notes or ‘N’ (No) to leave the Notes.

If ‘Yes’ is selected to Delete the BGE0911 Notes and Yes to Continue on and Process, the following screen will be displayed.

- Enter the Note Type to Delete

- Enter the To Date

(This will delete all notes with the type entered up and to the date entered).

F11 – Displays the Note Types to Select From. You may have to Add Note Type ‘911CG’ – select option 9 to add.

Press F5 to Continue or F3 to Return to the Menu without deleting any Notes.

Project #2206 – Inventory Number Description

We have added the Inventory Number Description to the List when running Inventory Location Change, option 1.

From Start1 Menu, Select option #7 (Inventory), then option #7 (Inventory Location Change) then option #1 (Change Location Only)

Project #2211 – Invoice History List by Special Code

We have created a new Invoice History list by Special Code. From Start1 Menu, select option #5 (Accounts Payable), then option #23 (More Print Options), then option #3 (Print Invoice Hist by Special Code) – Enter File Name – Select the Special Code 1 through 4.

The Special Code is pulled from the ‘Show Detail’ Screen in A/P Invoice Entry. Special Code 1, 2 and 3 are five characters and Special Code 4 is twenty characters.

Project #2221 – Discounts for Business/Employee/Associations with Minimum Number of Cellular Phones

You can now give a Business, Employee’s within a Business or a Member of an Association (Cellular Clients Only) a discount if they have a minimum number of People/Employees signed up for cellular service. The discount could be in return for them providing access to Employees/Members that you can contact.

User Edits will be used to determine the minimum number of Phones Required, the Discount Percentage and a Tariff Code to be used. Please contact CTI for further information and step by step instructions to setup this new feature.

Project #2268 – Customer File/Report Option to Drop Accounts

When creating your Own Customer File/Report, after selecting the option to Create a Temporary Account File, you will now have the option to Drop Account Types with Permanent Disconnect, Temporary Disconnect or both.

From Start1 Menu, select option #1 (Customer Information), then option #21 (Goto List & Reports Menu), then option #22 (Create own Customer File/Report). With-in this process we have added the following Screen.

#1 – Will Drop Account Type Permanent

#2 – Will Drop Account Type Temporary

#3 – Will Drop both Account Type Permanent and Temporary

#4 – No Account Types will be Dropped

Project #2290 – Extended G/L Change (All G/L Modules)

Changed the program we key in the From and To Account to check if they are using the Extended G/L. If you are not using Extended G/L we will protect the G/L Extension so they can not be keyed it in.

From Start1 Menu, select option #4 (General Ledger), then option #3 (Print Trial Balance), if you Do Not use Extended G/L the G/L Extensions will be protected.

Project #2084 – Mass Change/Update Sales Person Code

Mass Update of Sales Person Code in Phone/Inventory History files. This new mass update of the Sales Person Code is for those using the B7PHN History file for Activation Commission Purposes and Inventory Sales History for Cell Phone Commissions.

From Start1 Menu, select option #1 (Customer Information), then option #23 (Goto Customer Menu #2) then option #23 (Goto Customer Menu #3) then option #4 (Mass Change – Salesman Code) – the following screen will be displayed;

- Select what files to change.

The following screen will be displayed;

- Enter Sales Person Code Criteria

- Press F5 to Continue & Update Sales Person Codes.

Project #2138 – 2 Duplicate Check Programs

We created a Duplicate Check Program for Text Messages (SMS) and a Cellular check against what was billed last month.

Text Messaging (SMS) Duplicate Checks – We have made two SMS duplicate checks.

These two checks can be run from the PCS menu.

From Start1 Menu, select option #23 (System Maintenance), then option #24 (Goto Wireless Menu).

– Option # 17 (Check Duplicate SMS This Month) - Checks current unbilled file for duplicates

– Option #18 (Check Duplicate SMS Prev Month) - Compares current unbilled file to what was billed last month.

o When Selecting Option #18 – You will be asked for the File Names

§ When asked for Current Month File – Enter TSCSM

§ When asked for Previous Months File – Enter TBSCSML

They are also run automatically when processing SMS files.

Note: These WILL NOT work and are NOT run if you are using Telespire for your Cellular data. It will not work for them because they don’t send the ‘Seconds’ as part of the time field. A person could have several messages within a minutes time frame and we wouldn’t want to delete them. If you are a client that uses them, check with them to see if they can include the seconds.

Cellular Duplicate Checks – Cellular Duplicate Checks against what was Billed Last Month. We now save the Cellular File at month end so a check can be run during the current month to see if any calls were also billed last month.

From Start1 Menu, select option #2 (Toll), then option #23 (Goto Toll Menu #2), then option #2 (Check Duplicates Calls Prev MTH)

When asked for Current Month File – Enter TCELL

When asked for Previous Months File- Enter TBCELLL (Yes, there are 3 L’s in this File Name)

Project #2157 – International Toll Summary Reports

We have added the 6 Digit Country Code on International Toll Summary Reports for Countries that are Not in the North American Numbering Plan. We have also added a new report for the Countries on the North American Numbering Plan. You currently get a report by To State (Province). The new report is broken down by the To State (Province) and then To Place (City). This report could be a very large report.

From Start1 Menu, select option #2 (Toll), then select #23 (Goto Toll Menu #2), then select #20 (List International Call Counts).

Project #2304 – Vendor File for Labels – New Option

You can now build a File of the Vendors ‘Paid for All History’ or ‘Dates Pulled’ that can be used to Print Labels. We have added a new Menu Option “Create Vendors Paid Label File’ (APMXxx). This option gives you the ability to have only Vendors Paid pulled for All History or Date Range.

To Create Label File:

From Start1 Menu, select option #5 (Accounts Payable), then select #23 (More Print Options), then select #13 (Create Vendors Paid Label File) – Select the File to Use, then proceed on to Print Vendor Labels.

xx = Company Number

- Enter ‘A1Hxx’ for All History

- Select ‘A1Xxx’ for History Date Range (Entered in Option #17 ‘Pull History by specified date)

To Print Labels:

From Start1 Menu, select option #5 (Accounts Payable), then select #14 (Print Vendor Labels) – the following new screen will be displayed – if you enter APMXxx, Labels will be created based on your selection in Option #13 above.

xx = Company Number

- Enter ‘APMxx’ for Vendors All History Labels

-

- Enter ‘APMXxx’ for Vendors Paid Labels

Project #2330 – ‘On Hand Quantity’ Added to Year End Physical Inventory

We have changed the Quantity description to ‘Paid for Quantity’ and added ‘On Hand Quantity’ when running Year End Physical Inventory. We realize when counting Physical Inventory, it’s hard to know what is paid for and what is not paid for. This feature gives you the ability to see this information. From Start1 Menu, select option #7 (Inventory), then select #24 (More Inventory Options), then select #6 (Year End Physical).

The Screen now shows ‘Paid for Quantity’ and ‘On Hand Quantity’ as shown below.

Inventory Special Detail & Inventory Master List will also show ‘Paid for Quantity’ and ‘On Hand Quantity’.

Project #1478 – Facility Access Billed to Carrier or Customer

You now have the ability to tell if Facility Access/Special Access was Billed to Carrier or Customer. The older Facility Access/Special Access will not have the field populated. Any new history will have the information.

From Start1 Menu; select option #1 (Customer Information), then select #24 (Goto Year Summary Menu), then select #40 (Goto CABS Billing Summary), then select #31 (Select Records by Date)

The following screen will be displayed.

You can select to pull 1 - Carrier Billed, 2 - Customer Billed or 3 - Both Carrier and Customer Billed.

Project #2341 – Mass Change ‘Charge State Tax Y/N’

You now have the ability to Mass Change the ‘Charge State Tax (Y,N)’ Field. The changes will be to the Customer Phone File and Customer Special ID File. The Open Service Order Files may also be changed if you request to do so.

From the Start1 Menu; select option #1 (Customer Information), then select #23 (Goto Customer Menu #2), then select #23 (Goto Customer Menu #3), then select #19 (Mass Change–Charge State Tax).

The following screen will be displayed;

Change Charge State Tax (Y,N)

- Enter Y (Yes) or N (No) and the NPA and NXX you wish to Mass Change.

(The Example shown, would change the ‘Charge State Tax’ to No for all numbers with NPA 208 and NXX 436. No state tax will be charged on recurring charges)

- Press F5 to Continue and the following Screen will be displayed;

-

- Enter Y (Yes) or N (No) to Mass Change Open Service Orders.

Project #2362 – Copy Budget Files to New Year

You can now Copy old year Budget Files to a New Year Budget File. You will be asked to enter the Old year on the WorkStation status screen then enter the 2 digit New Year to Copy to. The From Year, To Year and Company that you Entered will then be displayed for verification before the files are copied. This copies only the Budget Entries that have Entry Codes for Riata Payroll. ** If you use Riata Payroll this must be done, even if you do not use Budget Files.

From Start1 Menu; Enter option #4 (General Ledger), then #23 (G/L Menu #2), then #22 (Goto Budget Menu), then #22 (Start New Year Budget) –

The Following Message will be displayed – Press F5 to Continue

Enter the OLD or From Year in this WorkStation Status Screen.

Enter the New or To Year in this Screen.

Verify the Year to Copy From, Year to Copy To and Company Number.

- Enter Y (Yes), N (No) or X (Return)

- Press F5 to Continue

You will be returned to the GBDMEN Menu.

Project #2331 – New Top 100 Local, Toll, Access Users Reports by Tra-State & by Ter-State

You will receive multiple new Top 100 Local, Toll, Access Users reports by Tra State and by Ter State. The new reports will print when printing the Top 100 reports.

From Start1 Menu; Select Option #1 (Customer Information), then #12 (Go to Month End Billing Menu), then #9 (Month End Billing Reports) – Select ‘Y’ (Yes) on ‘Top 100 Local, Toll, Access Users

Below are two samples of the new reports.

Project #2380 – ‘Name Delivery File’ Change

If sending “Calling Name Delivery” file, we have corrected LNP sending M to I and U to D.

Project #2385 – 15 Minute File Change

In the 15 minute file for GEO/Atlas we stripe off the Date & Time on the First Note. This was redundant on the web page.

Project #2386 – 1099 Vendor Name & Address

We have adjusted where the Vendor Name & Address prints on the 1099 Forms.

Project #2411 – FED-TAX-REFUND User Edit

We have created a new User Edit called ‘FED-TAX-REFUND’. This User Edit allows you to enter the Federal Tax Refund Statement Message. Enter message 1 in Fields 3 through 5 and message 2 in Fields 6 through 8.

*NOTE: Maximum of 6 Lines which is 3 User Edits.

Setup User Edit:

Field 1 = FED-TAX-REFUND

Field 2 = Leave Blank

Field 3 through 5 = Enter Message 1

Field 6 through 8 = Enter Message 2

In the example shown;

Message 1 = Federal Tax you paid on Toll is:

Message 2 = The years are:

Project #2429 – Pulling History for Inventory by Specified Dates

When Pulling History for Inventory by Specified Dates, we now make sure all Riata Sales are Pulled.

From Start1 Menu; Select #7 (Inventory) then select #17 (Pull History by Specified Date)

Project #2432 – Toll Maximum Report

You now have the ability to Exclude certain Customers from the ‘Toll Maximum Report’. This could be used to Exclude Customers who have Unlimited Toll Calling Plans and you don’t care how much Toll they have used.

A new User Edit ‘TOLLMAXCALLINGPLANS’ has been created to setup this feature and identify what Tariff Codes to Exclude from the Toll Maximum Report.

Setup User Edit:

Field 1 = TOLLMAXCALLINGPLANS

Field 2 = Leave Blank

Field 3 through 8 = Tariff Codes to Exclude (Enter 5 character Tariff Code followed by a decimal; xxxxx.xxxxx.xxxxx.)

** Remember to key leading spaces if the tariff code if not 5 long.

To call the ‘Toll Maximum Report’ from Start1 Menu; Select # 1 (Customer Information), then # 21 (Goto Lists & Reports Menu) then #17 (List Customers over Toll & Max)

Project #2419 – Discounts on Recurring Charges

We have created a way to give Discounts on Recurring Charges. This could be used to give Employees a Discount without setting up 2 sets of Tariff Codes with different amounts. The discount is figured during Step 6 of Month End Billing. The original Recurring Charges will show their normal charge and a Non-Recurring record is generated for the Discount Amount.

First you will need to decide the amount of the discounts. A new Tariff Code would need to be set up for each discount that you want to use. This Tariff Code would be added to Recurring Charges for each phone number that gets the discount. The Discount Amount is part of a new User Edit ‘RECURRING-CHARGE-%’.

There are two different methods that can be used with this User Edit:

- 1. Use ALL to indicate the Discount to be applied to All Tariff Codes EXCEPT the Tariff Codes entered in Fields 4 through 8.

- 2. Use SELECT to indicate the Discount to be applied to Only the Tariff Codes entered in Fields 4 through 8

Setup User Edit:

Field 1 = RECURRING-CHARGE-%

Field 2 = Tariff Code that was setup for each Discount Amount Example: XXXXX

This will be used to look at Recurring Charges to see which Customers Qualify for the Discount.

Field 3 = Discount Percent.Method.Tariff Code for Billing Example: 015.ALL .ZBL15 or 005.SELECT.

The Discount Percent – Enter a 3 digit percent followed by a decimal. (Example; 100 = 100% and 005 = 5%)

The Method would be ‘ALL ’ or ‘SELECT’. (If ALL is used, key 3 spaces after so it is 6 characters followed by a decimal.

The Tariff Code for Billing can be a Tariff you set up or can be left blank and the Tariff Code entered in Field #2 will be used. ** Remember to key leading spaces if the tariff code is not 5 long.

Field 4 through 8 = Tariff Codes to Include or Exclude based on the Method Used. Example: ABCDE.12345. 987.

Enter the 5 character Tariff Code followed by a decimal. If you need room for more tariff codes, set up an additional user edit with fields 1-3 the same. **Remember to key leading blanks if the tariff code is less than 5 long.

Examples:

For a 15% Discount to ALL Recurring Charges EXCEPT for Tariff Codes ABCDE and 12345 and using Tariff XYZAB for output on the bill.

Setup the User Edit as shown here.

For a 5% Discount to ONLY Tariff Codes ABCDE and 12345.

Setup the User Edit as shown here.

Since there is not an output Tariff Code entered in Field #3, the Tariff ‘SPR01’ from Field #2 will be used.

Project #2212 – Remove Cash Receipts History Listing

You will now receive a List of Records that were Deleted, when you select the Option to Remove Cash Receipt History up to the Cut-off Date in ‘Remove History Records’. The list will be in your output queue with ‘CSHHSTDEL’ showing in the User Data.

From Start1 Menu; Select #23 (System Maintenance), then #11 (Remove History Records)

– Enter ‘Y’ (Yes) in Remove From Cash Receipt History & Enter the Cut-off Date.

The following is an example of the Listing that will be in your output queue.

Project #2461 – Show Entire Description for Recurring & Non-Recurring Entries on Statements

You now have the ability to display the Entire Description from Recurring & Non-Recurring Entries on Statements.

In order for more of the Description to Print, we had to use a smaller font. This includes the Dates, Phone Number and Amount, if they are printing with the Description. The rest of the print will be as normal.

Setup New User Edit ‘BSTA6P-MORE-DESC’ if you wish to have the Entire Description from Recurring & Non-Recurring Entries displayed on Statements.

Field 1 – BSTA6P-MORE-DESC

Field 2 through 8 = Leave Blank

Project #2465 – Summary of Top 100 Reports By TRA & TER

When you are printing Top 100 Reports from the Year Summary Menu. There is a new option to Break the Toll Out by TRA and TER. This will give you a list of the Top 100 Toll Reports, broken into TRA and TER.

From Start1 Menu: Select option #1 (Customer Information), then option #24 (Goto Year Summary Menu), then option #1 (Select Records by Date) – Enter your data.

Press F5

Then run option #9 (Summary of Top 100-BCSTT2) – Then enter ‘T’ (Special Break Out TRA and TER) – Press F5

Project #2468 – Allow Limited Number of Free Incoming Call Minutes

We have added an option to Cellular PCS Plan setup to allow for a limited number of Free Incoming Call Minutes.

This would be used if you want to give some Free Minutes, but Not use the ‘All Incoming Free’ field.

Enter the number of Free Minutes you want to give with the plan on the 2nd screen of the plan setup.

These minutes will be applied at Month End Billing time.

From Start1 Menu: Select option #23 (System Maintenance), then #24 (Goto Wireless Menu), then #4 (Key/List PCS Packages) – Select # 1 = Key/List PCS Packages – Press F5 – Select Plan and Press Enter. Page down to the 2^nd Screen.

Enter Number of Free Minutes.

Project #2463 – Bank Reconciliation

We have changed the Bank Reconciliation, when you close-out your Bank Reconciliation we will now print a Cleared List and an Outstanding List.

Project #2472 – Ability to Delete a Range of Trouble Tickets

You now have the ability to delete a range of old Trouble Tickets.

From Start1 Menu; Select Option #1 (Customer Information), then #22 (Goto Equipment/Trouble Reports), then #24 (Go to Equipment Menu #2), then #3 (Delete Range of Trouble Tickets).

- The following window will display -

- Enter Trouble Ticket Number Range and Press F5 to Continue.

Project # 2208 – Tariff Code Notes

We have created a new User Edit called 'TARIFF-CHANGE-NOTE'. If this User Edit is setup, you will be required to enter a Note before you can Change, Add or even go in and look at a Tariff Code.

To Set-Up User Edit:

Field 1: TARIFF-CHANGE-NOTE

Field 2 through 8: Leave Blank

From Start1 Menu; Select #23 (System Maintenance), then #1 (Change/List Tariff File)

- Once you select the Tariff Code you want to Change or enter the New Tariff Code you want to Add, the following window will be displayed.

Tariff Code AC

calling plan.)

- We have also added ‘Cmd 9-Notes’ to the Tariff Code screen. This will give you the ability to view the Notes that have been entered.

Project #2483 – Deleting Sub-Tariff in a Package

A new question to Delete Sub-Tariff’s in a Package has been added to ‘Delete Recurring Tariff Code’ feature.

This new question will appear after the following steps;

From Start1 Menu: Select Option #1 (Customer Information), then #13 (Add/Change/Remove Tariff Codes) –

Selecting option # 3 (Delete), then #8 (Delete Recurring Tariff Code), then R (Regular) or S (Service Orders Pending)

The following message will be displayed:

The new question will appear on the next screen:

If you enter Y (Yes), the Tariff will be deleted even if it is in a Package.

If you enter N (No), the Tariff will be deleted ONLY if it is Not in a Package.

**Default will be ‘N’ (No).

The following message will be displayed if you selected Yes & deleted a Tariff that was part of a Package.

** Billing will be WRONG if these steps are not completed.

Project #1984 – Pull the Name for Calling Name Delivery from the Directory File

When you pull ‘Calling Name Delivery Changes’ you can now setup the new User Edit to Pull the ‘Calling Name Delivery’ from the Directory File. If you do not add this User Edit the Calling Name Delivery will continue to pull from the Bill Info. Tab.

Setup the new User Edit ‘CALLER-ID-FROM' 'DIRECTORY'.

Field 1 = CALLER-ID-FROM

Field 2 = DIRECTORY

Field 3-8: Leave Blank

Please verify the print-out each day that shows what Directory name was used.

To Pull ‘Calling Name Delivery Changes’ – From Start1 Menu: Select option #1 (Customer Information), then #18 (Pull E911/Call Name Delv Chngs.

Project #2089 – Email Statement Check

If an Account has a Zero Balance and the Account is Permanently Disconnected, it will not be added to the ‘Send Email Statements” File.

Project #2154 – QB Export to Excel

Enhanced QB Excel exportation to change the column data type to string on export so that Excel doesn't try to interpret the data. Example: Cable Pair 11-12 will not enter Excel as 11/12/2006

Project #2244 – Switch Password (6 to 10 Characters)

When changing the Switch Password through Riata, we now Require the Password to be 6 to 10 Characters long.

Project #2156 – Website Option to Email Password

A new option is available for your Websites. This option allows the customer to click on a link if they have forgotten their password. They then enter their account number, click a button, and their password is sent to the e-mail address you currently have on file for them. If you would like this option, please contact Josh.

Project #2439 – Turn Off ‘Past Due’ Sign

The following have been changed on the Website Account Information Page:

You now have the option to turn off the "Past Due" sign if the customer's balance less payments posted is less than or equal to their current. We also allow you to change the text "Balance less payments posted" to a phrase of your choice.

To implement this, please contact Josh.

Project # 2478 – E-Billing/Enter E-Mail Address

When a customer goes to an E-Billing Site to pay their bill, they now have the ability to enter an E-Mail Address to which a notification of received payment will be sent. If you would like this feature on your E-Billing Site, please contact Josh.