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

Program Enhancements & Changes------------------------------- 08/13/2007

** Please see Project# 2757 – Enter Inventory Codes on Page #23 of this Program Change document.

We suggest you immediately setup all Inventory Location Codes.

Project #2643 – Add Tax to Surcharges

If you need to Add Tax to Surcharges we have created a new User Edit called 'SURCHARGE-ADD-TAX'.

When you setup this User Edit, Federal and State Taxes will be charged on the surcharge if the Tariff Master Surcharge is Yes.

Setup User Edit

Field 1 = SURCHARGE-ADD-TAX

Field 2 through 8 = Leave Blank

Project #2753 – Service Order Entry / MIN Description Displayed

We now display the MIN Description after the number in the "Mobile Identification Number" window.

In Service Order Entry – Phone Number Information Screen – Bill Info Tab, select the ‘Available MIN’ button.

- The Description will now be displayed after the Mobile Identification Number

Note: MIN Description is entered by Phone Number range. From Start1 Menu: Select option #1 (Customer Information), then select #22 (Goto Equipment/Trouble Reports), then select #7 (Key/List Phone # Ranges).

Description: **MINS** are the Descriptions displayed.

Project #2756 – Additional Information Displayed in Trouble Ticket Program

We have added a ‘Show Extra’ Button to the Trouble Ticket: Standard Screen.

- Once you click on the ‘Show Extra’ button, you can Enter and/or View the ‘Tower #, Cell Site, Sector and Reference Trouble Ticket #.

- Click on ‘Hide Extra’ to return to the previous view.

Project #2748 – Plan Selector in Recurring Charges

We have added the ‘Plan Selector’ to Recurring charges in Service Order Entry. ** You will need to contact Kimberly at CTI to setup your Plan Selections before you will be able to use feature. We reviewed this new feature in Client Meeting.

From the Recurring Charges Screen, select the ‘Launch Plan Selector’ button.

The following Screen will be displayed:

- Select the Plan Option you want, then click on Update.

- The system will take you to the Prorate Recurring Charges so you can take care of Pro-rating at this point.

Once you have completed these steps, you will be returned to the Recurring Charges screen with the ‘Loading Plan Selector Information’ window displayed. You can select ‘Launch Plan Selector’ to change and/or review your Plan selections or click on Exit.

Once you click on Exit, you will be returned to the Recurring Charges screen and it will display all the Tariff Codes the are associated to the Plan you have just selected.

Project #2755 – Cash Receipts / Change Money Type on First Screen

Cash Receipts, you can now change the Money Type on the first screen for Cash Receipts. Select the Row(s) you would like to change then Right Click and Select "Change Money Type for Selected Items". Select the Money Type you want the selected rows changed to.

Print Customer Receipt

Setup Receipt Printer/Current Printer: Star TSP643

Select All Ctrl+A

Delete All

Delete Selected Cash Receipts Del

Change Money Type for Selected Items

Exit Cash Receipts

- Click on ‘Change Money Type for Selected Items’ and the following drop down will appear.

-

Check

Currency

Coin

Draft

Credit Card-Generic

Discover

Master Card

Visa

American Express

The following message with then be displayed:

- Select Yes to continue and change the Money Type or No to Cancel and no changes will be made.

Note: If you are using different G/L companies, and the Money Type is not valid for the current Company and Year, the money type will Not be changed. If this happens the following error message will be displayed.

Project #2773 – Check ‘Move Non-Recurring Charges’

We have created a new User Edit that will automatically check the "Move Non-Recurring Charges" when the user has selected to "Move to Different Account" in the Phone number Change/Remove screen in Service Order Entry.

To set this up:

Field 1: CHANGE-REMOVE-NUMBER

Field 2: CHECK-NON-RECURRING

When this User Edit is setup, we automatically check the ‘Move Non-Recurring Charges’ for you. You can still un-check this box if you do not want to move Non-Recurring Charges.

Project #2732 – Contract Reports

We have added ‘Contracts Report’ option to the Riata Programs Menu. You will need to contact your Security Personnel to get access to this feature. Once you click on ‘Contracts Report’ the following screen will be displayed.

- Enter the Number of Days to view the Contracts you want to see, then click on GO.

- Check ‘Show All’ to view Contracts with End Dates that have past.

- You can sort on any column by clicking on the heading.

- Option to Print and/or download to Excel.

Project #2801 – Drop Roaming Toll if Special Roaming Rates from PCS Plan Includes Any Toll

PCS - Drop Roaming toll if Special Roaming Rates from PCS plan includes any toll.

If you are using Special Roaming Rates from Screen #4 on the PCS Plan Setup to re-rate roaming calls and this rate includes any toll with the call, you need to setup the following new User Edit ‘PCS-CIBER-DROP-TOLL’.

Right now only the airtime portion of a roaming call is re-rated and the toll portion is left alone. With this User Edit, the toll portion will be Dropped.

Setup User Edit

Field 1 = PCS-CIBER-DROP-TOLL

Field 2 through 8 = Leave Blank

** Do Not setup this User Edit unless you are 100% sure you need it and have spoken with CTI.

Project #2770 – MIN (Mobile Identification Number) Only Option on the Phone Number Information Screen

We have added a new option to the LNP dropdown on the Phone Number Information screen.

This new option is "MIN Only - Not LNP"

This option is for those of you that have separate MIN’s for pre-paid numbers that are Not LNP.

MIN’s that are different from MDN’s (Mobile Directory Number).

Project #2784 – Reason Code if Service Order Type is Disconnect or Suspend

We have added a ‘Reason Code & Comments Field’ to the Approve Telephone Information Screen in Service Order Entry.

When a Phone Number is Disconnected or Suspended, you will now be required to enter a Reason Code before Approving the Service Order.

Comments are optional. These comments are different from notes. Will probably be used by Management to review Disconnected and Suspended Accounts.

First Setup Reason Codes:

To setup the reason codes you will need follow these AS/400 steps.

From Start1 Menu; select #1 (Customer Information), then #19 (Riata), then #20 (Maintenance Items), then #20 (More Options), then #16 (Disconnect Reason Codes).

Project #2791 – AS/400 IP, User Name and Password Requested when Launching QB

We now request AS/400 IP, User-Name and Password when selecting QB (Query Builder). Because it asks for the IP Address of the AS/400, we changed the GL Control to store the IP address to the AS/400. This is requesting your AS/400 User Name & Password. Most users have the same User ID and Password for both the AS/400 and Riata. You will no longer have to setup your 400 Data Source.

Project #2793 – ‘Select File’ & ‘CTI QB’s’ Added to Query Builder

We have added an ‘Select File’ and ‘CTI QBs’ button to Query Builder. CTI Controls the options within these two new options, you will be prompted as needed.

Select Files

- When you click on the ‘Select File’ button this window is displayed. This gives you file names that are user friendly and easier to identify and select.

- Double Click on the File you want or Click once then Click on the Select button.

If you select the File Name B<Other>, this window will be displayed for you to enter the file you want to use. This could be P<other>, Z<other> or whatever you want. You are just replacing the ‘<other>’.

- You can change the Company Number & Year.

(This will only affect filenames that have <CO>, <YR> or both. The <CO>

will be replaced by what is in the Company txt box and the <YR> will be replaced

by what is in the Year txt box.)

You can also Filter to the desired File Name

CTI QB’s

- When you click on the ‘CTI QBs’ button this window is displayed.

- These Files will be the most commonly used Files for QB generated by CTI.

- You can also Filter to the desired QB.

- Double Click on the QB you want or Click once then Click on the Select button.

Project #2807 – PCS Select Plan Default By Cycle

You can now select by cycle what plan to default a customer to that does not have a plan as a recurring charge.

User Edit 'PCSDEFAULTPLANTARIFF' will continue to be used for this. You can now put your Cycle Code in Field 2 and the Tariff Code for the Default plan for that Cycle in Field 3.

You can have multiple user edits with the same Field 1 value. If you only have one cycle or the default is the same for all cycles, you can still leave field 2 blank. All cycles use it.

Setup User Edit

Field 1 = PCSDEFAULTPLANTARIFF

Field 2 = Enter Cycle Code or Leave Blank for All Cycles

Field 3 = Enter the Tariff Code for the Cycle entered in Field 2

(Leave Blank if no cycle is entered in Field 2)

Field 4 through 8 = Leave Blank

Project #2808 – QB Added to Special Search in Riata Inquiry

We have added ‘Query Builder’ as an option under the Special Search button on the Riata Inquiry screen. In addition to this, we have also moved the options Directory Search, Government ID Search and Special Search from the File menu option to the Special Search button.

** Choosing the ‘Special Search’ option in this drop down will do the same as when clicking the Special Search button before.

Project #2810 – New Checks when Approving Service Orders

We've added a new check when Approving Service Orders. If the Service Order is marked to be Deleted and the Account is a New Account, we look for Posted and Un-Posted Cash Receipts. If we find Un-Posted Cash Receipts or the Posted Cash Receipts do Not Net to Zero, we display a list of the Cash Receipts and do not allow you to approve the Service Order.

In order to approve the Service Order, the Posted Cash Receipts must net to zero and there can not be any Un-Posted Cash Receipts.

You can un-check the ‘Delete / Undo” Service Order to Approve the Service Order if there are Un-Posted Cash Receipts or the Posted Cash Receipts do not Net Zero.

This is to Prevent the deletion of an Account (Service Order) after Cash has been taken.

Project #2816 – Special Transfer Added in Other Options

We have added an option called "Special Transfer". This is located on ‘Telephone Number and Location’ screen in Riata Inquiry under the Other Options button. Special Transfers are only used by select Companies that have to move Accounts to an outside company.

Inventory Sales

Minutes Used

Web Trouble Ticket

Special Transfer

Project #2817 – Auto Selection of Sales Person 1 & 2 Changed (2007 Service Order Entry)

Now in 2007 Service Order Entry, on the 3^rd screen, the system will automatically default the Sale Representative & Sales Verified By based on the following circumstances.

Sales Representative will default to Riata Sign-on.

If the Sales Representative is Not an outside sales person, the system will default the Sales Representative in ‘Sales Verified By’ field. The Sales Verified By field will be disabled.

You do have the ability to change the ‘Sale Representative’ using the drop down if needed.

If the Sales Representative IS an outside sales person, a Sales Verified By must be selected using the drop down.

Project #2821 – Non-Recurring Charges / Calling Plan Check

Calling plans can no longer be added to the Non-Recurring Charges for an Account, there must be a Phone Number associated with all Calling Plans.

If there is no working number, you are unable to add a Calling Plan Tariff Code.

From the ‘Telephone Number & Location’ screen, when you select ‘Non-Recurring’ and attempt to add a

Calling Plan, the following message will be displayed.

Project #2824 – ‘Deposit is Sufficient’, No Credit Check Needed

We have added a check that will allow any additional Phones to be added to an account without an Additional Deposit or a Credit Check. After a validation number has been retrieved, a supervisor accesses the Credit Score Override and checks the ‘Deposit is Sufficient’. (No more deposit or credit check is needed - check box).

Once a supervisor checks this box, Accepts, then Saves this validation the system will allow you to add additional phones to this account without requiring an additional Deposit or a Credit Check.

Project #2825 – “Delete This Service Order’ - Moved to the First Screen in 2007 Service Order

We have moved the option to ‘Delete This Service Order’ from the 3^rd screen to the 1^st screen in 2007 Service Order Entry.

This option will be disabled until a valid Service Order has been selected or started. Once you check the ‘Delete This Service Order’ check box, click on Next, then Update & Approve the Service Order it will be deleted.

Project #2828 – PDF Search Added to Inquiry

We have added ‘PDF Search’ to Riata Inquiry. Under the Special Search button, select PDF Search. This will just have PDF’s for 2007 Service Order Sales Receipts for now, more will be coming

Use the drop down ‘Type’ to select the Type of PDF’s you would like displayed.

To Filter, enter any information you wish to filter the PDF’s you would like displayed.

(Example shows Account number entered, therefore only the PDF’s for that account number are displayed. Leave the Filter blank to view all PDF’s )

Click on ‘Get PDF’s’ to view the PDF’s for your selection.

To view a PDF, highlight and click on Open or double click on the PDF you would like to view.

Project #2823 – Ability to View Inventory History by Account & Sub-Account

We have added the ability to Search by Account Number and Sub-Account Number in Inventory History.

From the Riata Programs Menu – select ‘Inventory History’.

Enter the Search criteria you would like displayed.

(Account Number, Sub-Account Number, Inventory Number, Serial Number, Electronic Serial Number).

Click on ‘Find Account’ to locate an account.

Check additional fields of what you would like displayed.

(Manual Changes, Transfer Details, Additions, Withdrawal, On Hand Quantity).

Enter the time period to be displayed.

(From MM YY To MM YY).

Click on ‘Find History’.

Project #2814 – Allow Tariffs to be Grandfathered

In 2007 Service Order Entry, we now allow Grandfathered Tariff Codes. These are tariff codes that were setup and used but no new Customers can get them; therefore new Tariff Codes have been created for the new customers. For example, as shown below, ‘Mountain West Plan 800 & Mountain West Plan 1550’ are not longer valid plans however; previous customers may still be using these plans. The Grandfathered Tariffs/Plans will be displayed in Purple.

Project #2844 – View All Account Contracts

The following are new ways to view ‘All Contracts’ for an Account.

In ‘2007 Service Order Entry’, from the "Totals" screen click the "Go back to..." and then select "Contracts – All for this Account". All the contracts for the account will be displayed. From this option, you can only view Contracts, no changes or Adding are allowed.

In ‘Service Order Entry & Inquiry’, from the "Telephone Number and Location" screen – a Contracts button has been added. Click on this button to view All Contracts for this Account". All the contracts for the account will be displayed. From this option, you can only view Contracts, no changes or Adding are allowed.

Project #2848 – Inventory History Option Added to the Phone Number & Customer Information Screens

You can now access the Inventory history from the Phone Number Information and Customer Account Information screens when you right click the mouse button in an empty space on the form. Select ‘Inventory’ then, Inventory History.

You can also view the Inventory History from Inventory Sales Invoice screen.

Project #2855 – Pre-defined Descriptions in Cash Receipts

We have added a new dropdown list for Pre-defined Descriptions in the Cash Receipts. When a pre-defined description is selected from the dropdown we place it in the Description field.

• First you need to setup the following User Edit.

Setup User Edit

Field 1 = CASH-RECEIPT

Field 2 = PREDEFINED-DESCRIPTN

Field 3 through 8 = Enter a description in each field to display in the dropdown list. Maximum 20 Characters for each field.

Once the User Edit is setup – from the Cash Receipts Screen, you can select from this Pre-defined dropdown List.

After selecting a Pre-defined Description, you can also add more Description details.

The Pre-defined Description and the Description fields will be displayed in the Description field in the following Cash Receipts screen. Maximum of 40 characters allowed for the combination of both description fields.

Project #2840 – Inventory Summary Added to Inventory History

There is a new option in the Inventory History program called "Inventory Summary" which allows you to browse all current inventory. Quantities are sub-totaled by either Inventory # or Location. To run this browser, press the "Inventory Summary" button on the Inventory History screen.

Results in the grid are sub-totaled by Inv#/Description and Location. You may change the organization of the subtotals by either using the "Subtotal By" options at the bottom of the screen, or by dragging the first two columns into the order you want. For example, if you want to look at the inventory by specific location, clicking on "Location" in the "Subtotal By" options will put the "Location" column in the first position, followed by the Inv#/Description column.

Swap INV# and Desc. This button will change the reverse the order of the Inventory # and Description values. This is helpful when sorting in order to alphabetize either by the Inventory # or by the Description.

Filters

There are three filters, one for Inventory Number and Description, Serial Number and Electronic Serial Number (ESN). You can click the "Select All" button next to a filter in Inventory Summary to turn that filter off.

Note: if Inventory #, Serial # or ESN contain a value on the Inventory History screen, they will be used as initial filter values in Inventory Summary.

Inventory entries must match all three filters to appear in the grid. To match an individual filter, an inventory entry must contain the text entered in the filter. For example, if the Inventory Number & Description filter is set to "kyoc", all items with "kyoc" anywhere in their description or inventory number will be selected. In the example below, all 6 inventory items with "kyoc" in their inventory#/description and with "0340810" in their ESN are selected:

Show All Filters & These buttons allow you to expose, either one at a time or all at

Go To Next Match once, the detailed results of the filtering. This works the same

way as clicking the plus button for each row in the outline at

the left of the grid.

Search The "Search" button allows you to find items containing your search word

(in any column) within the grid. Unlike filters, Search will not go through

the entire inventory, only what is in the current grid results.

Project #2867 – View Contracts From Riata Inquiry

We have added a ‘Contracts’ button to Inquiry & Service Order Entry – Telephone Number & Location screen.

From this option, you can view all contract for the Account. (No changes or Adding a Contract are allowed.)

You can now view the contracts from the Customer Account Information screen in Riata Inquiry. We have added a new button on the Lines Tab to view the Contracts for the Line, there is also a new button to view all the contracts for the Account.

Project #2869 – ‘Alarm’ Note Type

We have added two new Note Types. They are Alarm & Alar2.

Note Type ‘ALARM’ = Means there is an Alarm on the Account and will show the Alarm in Service Order Entry, Inquiry & Cash Receipts.

Note Type ‘ALAR2’ = Alarm has been taken care of and the warning Alarm will no longer show in Service Order Entry, Inquiry & Cash Receipts.

When you select ‘Alarm’ as a note type the following warnings and options will be available.

In Riata Inquiry, Service Order Entry & Cash Receipts – if a Note Type ‘ALARM’ is found the following warning will be displayed. You must click on Close to continue on.

In Inquiry & Service Order Entry – Telephone Number & Location Screen. An ‘ALARM’ note type will display ‘Has Alarms’ in Red. There is also an option ‘Show Alarms’ button to view the ALARM notes.

‘Show Alarms’ button will allow you to view the alarms and change Alarm to Alar2 if the Alarm has been taken care of.

In Cash Receipts an ‘ALARM’ note type will display ‘Has Alarms’ in Red as shown below. There is also an option ‘Show Alarms’ button to view the ALARM notes.

When you click on ‘Show Alarms’ button the following screen will display showing all the Alarm note types. You can select & open the alarm and change the Note type from ‘ALARM’ to ALAR2’ indicating the ALARM has been taken care of.

Double click on the Alarm you want to change and the following screen will be displayed.

Change the Alarm to “Alarm Taken Care Of” to remove the Alarm from being displayed. If you have any questions regarding this feature please contact us.

Project #2700 – Tariff Codes Not Checked to Give Late Notice

We have added a new check when printing Disconnect and Late Notices, if the Phone Number or Special ID is Disconnected we Do Not check the Tariff Codes to not give a Disconnect or Late Notice.

Project #2789 – Multi State Payroll

For Multi-State Payroll we have made some changes on how Tax & Gross is calculated. These are transparent changes. Please validate your Multi-State Tax Charges are correct and contact us if you have any questions or concerns.

Project #2800 – Number Changes/Directory

We now update the Actual Listing Number in the Directory System when a Number Change is Completed.

** This is ONLY done, if the Actual Listing Number matches the Phone Number it is tied to. This way Foreign Listings will not be affected.

Project #2864 – Launch Pre-Paid Switch Commands with MIN (Mobile Identification Number)

You now have the ability to launch Pre-paid Switch commands with MIN information from within both old and new service order entry. If the number is a Pre-paid number, we have added new switch commands. We have also made so the ‘MIN Only’ is passed to the switch. Contact Josh if you have any questions.

Project #2747 – Automatically Setup the Invalid Mexico NPA-NXX

You can now have the system Automatically setup the Invalid Mexico NPA-NXX based on Tijuana (052-644). We are doing this as a convenience for you. The real problem is with Telcordia or whomever, does not have some Mexico Cities in the TPM file. We know the City may say Tijuana and could be wrong, but at least it will be billed. Most Mexico rates are the same so it should be billed correctly, it just may have the wrong City listed.

From Start1 Menu: Select option #2 (Toll), then select #22 (Goto Toll Carrier Menu), then select #2 (Process Toll) – Workstation Status F5 – Enter ‘Y’ (Yes) in ‘Process Invalid Calls with errors when rating – press F5.

The following Message will be displayed:

- Enter ‘Y’ (Yes) to have the system Automatically Setup the Invalid Mexico NPA-NXX based on Tijuana (052-664).

- Enter ‘N’ (No) if you do not want the system to Automatically do this, then do the following to key in the changes Manually.

o From Start1 Menu: Select option #2 (Toll), then select #14 (Change/List TPM File) – enter ‘Y’ (Yes) in the ‘Do You want to Manually key in Changes to the TPM File.

Project #2689 – Disconnect Reason Codes

You can now enter ‘Disconnect Reason Codes’. From Start1 Menu: select option #1 (Customer Information), then #19 (Riata), then #20 (Maintenance Items), then #20 (More Options), then #16 (Disconnect Reason Codes)

The following window will be displayed. Enter the Reason Code and press enter. The window will then display a Description field to be entered.

Press Enter to update Description, then F3. Once one description code is entered you will be taken to the standard screen to view the ‘Reason Code & Descriptions’. Use (2) Change or (9) Add.

Project #2757 – Enter Inventory Location Codes

You can now enter the Inventory Location Codes & Description. From Start1 Menu; select option #7 (Inventory), then #24 (More Inventory Items), then #12 (Key Inventory Location Codes).

The following screen will be displayed to Enter your Location Code & Description

Location Code Description

Location Code WH

Description TEST WH

F16 - Delete F18 - Return

** We strongly suggest you immediately setup all Inventory Location Codes.

Project #2771 – State Tax District Change

When you select the State Tax District to Change we now Change the State Tax District in the Account File along with the Phone and Special ID File.

From Start1 Menu: select option #1 (Customer Information), then #23 (Goto Customer Menu #2), then #19 (Change State Tax District)

Project #2769 – Cellular / Testing of PCS Calling Plans

Three new Options have been added to this process.

1. Run a test from a billing cycle. This could be used to see what a customer should have been billed in cases where the plan might not have been set up correctly at billing time.
2. Test a specific plan. You can enter what plan to test. You could run a test for different plans to do a comparison.
3. Run a test on an open service order. With this option you could select various add on features like SMS, additional nights & weekends to see what would get charged. You would open a new service order, select the options to test, run the test and then delete the service order.

Some new wording and new screens have been added to ask these questions. See the following steps for additional details. This can be confusing with so many options, but we hope we have made it as simple as possible.

From Start1 Menu: Select option #23 (System Maintenance), then #24 (Goto Wireless Menu), then #4 (Key/List PCS Packages) – then Select option #8 (Test Rates for New PCS Plan) – Press F5.

The following message will be displayed:

99 07 06 CADATA 99 Company 6/19/07

6/06/07 10:01:50

This runs programs to test Wireless Plan Rating.

EXTREME CAUTION is needed.

This creates a new library called XXAIRTST and moves

data into it that is used for testing.

When you are done you MUST SIGNOFF to get back to your regular

data for regular processing !!!!!

Do you want to continue (Y,N)

Y

Cmd 5 - Continue on Cmd3=N

Press F5 to Continue

99 07 06 CADATA 99 Company 6/19/07

6/06/07 10:04:01

Make sure you have set up the PCS plan the way you want it.

The PCS plan tariff code needs to be set up as a

recurring charge on the phone numbers you want to test.

*** You can also do an SVO to set up a phone# the way you want.

Then run the test. Then delete the SVO. A new option to select

from open SVO has been added to the next screen.***

If you pull roamer records to rate at local calls, you might

want to do that process before going on.

Are you ready to run a test? (Y/N)

Y

Cmd 5 - Continue on Cmd3=N

F5 – To Continue

** For Option #1 explained above, Key in the Billing Cycle you want to Test.

(If a Cycle is entered, the calls are pulled from the Cycle Files instead of Un-Billed Files. TBCELL, TBCIBR)

** For Option #3 explained above, Key in the ‘S’ to Pull Recurring from Open Service Orders.

** For Option #2 explained above, Key in the Plan you want to Test and it will be used instead of what is found in the recurring charges.

Project #2804 – Additional Special Selling Price Fields in Inventory Master

We have added 5 more Special Selling Price fields in the Inventory Master.

From Start1 Menu; select #7 (Inventory), then #13 (Key Inventory Master). – (F15 – Selling Prices)

This is for special promos or contracts that get special pricing.

Description Cell Phone#1 Inventory # JO1

Part #

G/L Acct (1-9) 1 G/L .00

Type Code Commission Code

Minimum Qty 0000000 Maximum Qty 0000000

Days to Reorder 000 Annual Usage 0000000 Space Cd

No Cost Item (Y,N)

Special Cost G/L .00 (Usually 0)

Special Revenue G/L .00 (Usually 0)

Resell Markup % 9.99 ( .00=use default 9.99=do not figure from cost)

Unit Selling Price 89.950 (xxxxxx.xxx) Use Manual Cost (Y,N)

Cable Footage Start Manual Cost .000

Cable Footage End To CPR (Y/N) CPR Index # 000000

Cable Footage Curr

Print 10% Price Change (Y,N) By Location (Y,N) Y Need Serial # Y

Qty Paid For Paid For Unit Unit Cost of

On Hand Qty Total Cost Cost Last Addition

4- 15- 1050.00- 70.000 .000

F10-Key Min/Max Qty F19-Unlock G/L

F11-Key UPC Codes F14-Shelf Info F15-Selling Prices F16-Del F18-Clear

The Code is linked to ‘INVENTORY-PRICING SCHEME’ User Edit.

Special Prices

Inventory # JO1

Code Selling Price

(1) SINGL 89.950

(2) PLAN 59.990

(3) COST 9.990

(4) _____ _______

(5) _____ _______

(6) _____ _______

(7) _____ _______

(8) _____ _______

(9) _____ _______

(10) _____ _______

F3= Exit F5= Update F16= Delete

Project #2818 – New Options to ‘State Tax Districts to Change’

We have added two new options to select the State Tax Districts to change. You can enter the 911 City and Tax City. If you enter something into these fields they will be used to select the state tax districts to change. If you leave these fields blank they will not be used to select the state tax districts to change.

From Start1 Menu: Select option #1 (Customer Information), then select #23 (Goto Customer Menu #2), then select #19 (Change State Tax ID# Descriptions).

Project #2794 – New TTPMMX File for Mexico TPM Information

We have created a new TTPMMX file that will have the Mexico TPM information and a program to read the pc file into TTPMMX.

From Start1 Menu; select #2 (Toll), then #14 (Change/List TPM File). Place ‘Y’ (Yes) next to ‘Do you want to Load the Mexico TPM Information – Press F5

- The Following Message will be displayed. Verify the INTLMX.dat file is in CTITRANS folder, if it is enter ‘Y’ (Yes) and press F5.

Project #2795 – Read in Bank Reconciliation File in .CSV Format

We have added another option to read in a file in from your Bank. This option is in .CSV format.

For now we only have one format that is a D.L. Evans Bank format. This format referred to as Format 01 is in the following column order; Account, Check/Reference, Deposit Amount, Check Amount, Balance, Date (MM/DD/YYYY), Description.

Contact us if your Bank’s Format is different than this and we can make it work.

• First you need to setup the following User Edit.

Setup User Edit

Field 1 = BANK-RECONCILIATION

Field 2 = Format Number (Currently 01 is the only valid format. More will be added as needed)

Field 3 through 8 = Leave Blank

After the User Edit is setup you can proceed with reading in a Bank Reconciliation File in .CSV format.

From Start1 Menu; select #4 (General Ledger), then #16 (Bank Reconciliation Menu), then select Reconcile, Run Reconciliation, WorkStation Status, F5 (Run Job).

7/31/07 RCMCL1

17:01:58

Company 01 Riata Training Company

G/L Year 07

G/L Period 07

GF 1120.10 .00

.00 .00

05 1120.05 .00

What Reconcilation File do You want to work with

File Code GF G/L Account 1120.10

CMD-5 Run Job CMD-3 Return to menu

F10 = Reconcile using PC .CSV file

Date to Clear 0/00/00 (MMDDYY) (Bank Reconciliation)

Cmd 12 - Clear By CK # Enter the date of the items

you want to clear, or press

ENTER to start with the

first item.

Cmd 3 - End Job

Cmd 24 - Reconcile

Cmd 10 - Reconcile using PC .CSV file

Cmd 11 - Reconcile using PC spreadsheet

The following message will be displayed – Press F5 to Continue.

The following message will be displayed – Press F5 to Continue.

Replace ‘YOURFILE’ with the name of your .CSV file and Press Enter.

Once this process is completed, the following message will be displayed.

Enter ‘N’ (No) if this is the only File you need to process or ‘Y’ (Yes) if you need to add another file.

Press F5 to Continue.

Once you have processed all the Files needed, the following message will be displayed.

Press F5 and you will be returned (Bank Reconciliation) screen.

Verify the print-out ‘BANKRECN’. Below is an example of what it will look like.

Display Spooled File

File . . . . . : PRINT Page/Line 1/1

Control . . . . . Columns 1 - 130

Find . . . . . .

*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+

Test Telephone Company Rupert

RCPCF3 8/03/2007 CLEARED ITEMS NOT FOUND PAGE

DATE CHECK# CD AMT

06/01/2007 000111 CK 20.00

06/01/2007 000000 DP 10.00 CLEARED ITEM-SAME AMOUNT

06/01/2007 000000 DP 40.50

06/01/2007 000000 DP 46.00

06/01/2007 000000 DP 84.92

06/04/2007 000000 DP 791.13

06/04/2007 000000 DP 4286.01

06/04/2007 000000 DP 100.00 CLEARED ITEM-SAME AMOUNT

06/04/2007 000000 DP 146.32

06/04/2007 000000 DP 190.00

Mo

F3=Exit F12=Cancel F19=Left F20=Right F24=More keys

Project #2845 – Key Cabs Carriers Screen Change

You will now be able to enter the Riata Account #, Riata Account Sub, Riata Tariff and Email Address on the second screen in ‘Key Cabs Carriers’. We have also moved the Miscellaneous Bill Customer Number, Miscellaneous Bill Billing Code and Miscellaneous Bill Company to the second screen.

From Start1 Menu; select #3 (Cabs Billing), then #16 (Key Cabs Carriers).

Project #2851 – Originating & Terminating Duplicate Check

We have added the option to compare Originating & Terminating Duplicates in Toll/Access.

Project #2857 – Voice Mail NPA/NXX’s Based on the MIN (Mobile Identification Number)

We have added a new User Edit call ‘VOICEMAIL-NPA-NXX’ to let you setup the Voicemail NPA/NXX’s based on the MIN (Mobile Identification Number). You will enter the MIN NPA-NXX in Field 3 and the Voicemail NPA/NXX in Field 4. Multiple of this User Edit are allowed.

Setup User Edit

Field 1 = VOICEMAIL-NPA-NXX

Field 2 = Leave Blank

Field 3 = MIN NPA-NXX (Example; 208430)

Field 4 = Voicemail NPA-NXX (Example; 208439)

Field 5 through 8 = Leave Blank

In the example shown; Voicemail NPA-NXX 208-439 will be used for MIN (Mobile Indentification Number) NPA-NXX 208-430.

To Add or Change Tariff Switch Commands; From Start1 Menu; select #23 (System Maintenance), then #23 (Goto Maintenance Menu #2), then #11 (Switch Command Maintenance), then #1 (Switch Command Maintenance).

Press F24 – More Options to view additional Codes.

Project #2861 – Note Required in 2007 Service Order Entry

If you want to Require a Note to be entered when doing a Service Order in 2007 Service Order Entry you need to set the following fields. ‘Notes/Description Required’ field in the Common Defaults must be set to Yes and Service Order Type Code ‘Is Note Required’ must be set to Yes. When adding a new Service Order and both of these are set to Yes, a Note will be Required.

To Set the ‘Notes Required’ in the Common Defaults.

From Start1 Menu; select #1 (Customer Information), then #19 (Riata), then #20 (Maintenance Items), then #14 (Common Defaults).

– On the 4th screen place a Y (Yes) in Notes/Desc Required field.

To Set the ‘Is Note Required’ based on Service Order Type Code.

From Start1 Menu; select #1 (Customer Information), then #19 (Riata), then #20 (Maintenance Items), then #4 (Service Order Type 2 Codes). Select the Service Order Type Code and place a Y (Yes) in the ‘Is Note Required’.

When both of these are set to Yes – when adding a new 2007 Service Order, a Note will be Required. You will not be able to Approve a Service Order until a Note is Added.