208-436-1912

(Fax) 208-436-1914

cti@pmt.org  

      Computer Technology, Inc.

 

301 Scott Ave. #1   Rupert, ID 83350

 

Program Enhancements & Changes----------- September 16, 2008

 

** You may get an Error when you Copy from Shared to Local after applying this Program Change.  This is due to the fact we are starting to use .NET for programming.  If you get an error you should be OK to Continue on and all other programs will be updated correctly.  The error would occur if you do not have .Net on your computer.  Most new Versions of Windows has .Net. 

 

Project #3612     Dot Net Runtime Test           

On the Riata Programs Menu, there is a new option called “Dot Net Runtime Test”.  This option is located on the Right Side of the Riata Programs Menu under ‘Set up Riata’ heading.  This will verify if you have .Net setup on your computer.

 

When you click on ‘Dot Net Runtime Test’, if you get a ‘Window Type Error – this probably means you do not have .Net installed on your computer.  Contact you IT Personnel and they can download .NET Framework 2.0. 

 

If you do have .Net setup on your computer, once you click on ‘Dot Net Runtime Test’ a ‘400 Information’ sign-on Screen will be displayed.  Enter your AS/400 User name and Password and click on ‘Log In’.  Then the following confirmation message will be displayed.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you get an error after you sign-on to the 400 and do not receive the above confirmation message, this might mean you are missing a Service Pack.  Contact you IT Personnel and they can download the needed Service Pack or Contact CTI and we can assist you in identifying what Service Pack you need and how to install.

 

 

 

Project #3501      View Special 2 in Summary By Location (2008 Version)        

We have added a New Form to View In & Out Changes called ‘View Special 2’.  From the Riata Programs Menu, select ‘Summary By Location (2008 Version).  Enter the ‘From Date’, ‘To Date’, select the File and Click on ‘Load’.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Note: ‘View Special 1’ Shows In & Out Only - No Changes. 

 

Text Box: View Special 1
View Special 2

 

 

 

 

-          Click on the ‘View Special’ button and select ‘View Special 2’

o        The following screen will display the In Chg and Out Chg by Location. (In & Out Changes).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3502       Require Comments in Service Order if Disconnect/Suspend or All Charges Removed      

We have created a New User Edit called ‘DISCONNECT-REASON    COMMENTS-REQUIRED’.  This User Edit will Force the User to Enter Comments if the Service Order Type is Disconnect, Suspend or if All the Charges for the Billing Type have been Removed.

 

Setup User Edit

                Field 1 = DISCONNECT-REASON

                Field 2 = COMMENTS-REQUIRED

                Field 3 through 8 = Leave Blank

 

 

 

 

 

 

In Riata Service Order Entry and 2007 Service Order Entry, if the Service Order Type is Disconnect, Suspend or if All the Charges for the Billing Type have been Removed. 

 

 

 

 

 

 

 

 

 

 

 

 

The above message will appear and you will be required to enter a Disconnect Reason Code & Comment before Approving the Service Order as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3399        Cash Receipts / Account Type Breakdown

In the Cash Receipts, we have Added the ‘Account Type’ to the detail Information on the Cash Receipt Print-Outs. 

When you Print from the Cash Receipt Screen shown below, the Account Type is now displayed for each Cash Receipt.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Account Type has also been added to the PDF Printout when you ‘Post Cash Receipts’. 

 

 

 

 

Project #3481        Summary By Location (2008 Version) / View In & Out Changes

We now display the ‘In Changes and Out Changes’ in the ‘Summary By Location (2008 Version)’.  As Customers move from Plan to Plan, they will show in Change Column not in ‘In & Out’.  In’s are true In and Out’s are true Out. 

From the Riata Programs Menu; select ‘Summary By Location (2008 Version)

        Enter the From & To Dates and click on the ‘Load’ button. 

        The In Chg & Out Chg are displayed as shown here.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3487         CPNI / Service Order Number, Date Taken & Date Updated Displayed

We have added 3 new Fields to the CPNI Changes program.

From the Riata Programs Menu; select ‘CPNI Changes’. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When you scroll to the right of each list, you will now see;

-          Service Order Number

-          Date Taken

-          Date Updated

 

 

Project #3521       Cash Receipts / ‘Net’ Dropdown

We have added a new item to the "Net" dropdown list in the second screen of Cash Receipts. The new Item in the dropdown list is "Not Statement".  We have also added a ‘Enable’ button.  This will allow you to Enable the dropdown whenever needed.

 

(In the past the Amount needed to be less than Zero to have the dropdown enabled).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The ‘Not Statement’ is what we use to Apply to Current Charges.  Example; if a Customer pays $50.00 for a phone guard, there would be a charge of $50.00 for the item purchased and payment of $50.00 applied to the account for the item but does not adjust the Statement. 

 

 

 

Project #3534    -   Riata Programs Menu / User Edits

In User Edits, from the Riata Program Menu.  When you Cancel, Edit or Delete a User Edit, you will now be returned to the same location on the grid. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

We have also added a Checkbox to the Search Option;  once you select ‘Search’ the following window is displayed.

 

 

 

 

 

 

 - ‘Search Key Field Only (1&2)

When this box is checked, we will only search the User Edits using Fields 1 and 2 (Fields 3 through 8 will Not be included in the Search). 

 

This option is helpful in narrowing a search for a certain key when the search word you are using is a common word such as "CTI", which occurs many times in all User Edit fields.

 

 

Project #3510       MSAG / Delete Multiple Addresses at the Same Time

We have added the Ability to Delete Multiple Address at the same time in the Master Street Address Guide (MSAG).

From Riata Programs Menu; select ‘Master Street Address Guide (MSAG)’.

The following screen will be displayed. 

-          Highlight the addresses you want to Delete.  (Click & Drag or hold down the Ctrl Key and Click the Addresses)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-          Right Click & the Following Screen will be displayed. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click on the ‘Delete’ button.

 - The following ‘Warning Message’ will be displayed. 

                - Click on Yes to Continue and Delete the Selected Addresses or No to Cancel and return to the MSAG window.

 

 

 

 

 

 

 

 

 

 

 

 

Project #3535    -  Special Address for Directory Listings

We have added a new place for you to enter a Special Address to be used for Directory Listings.  This would be used if the Location Address is Different than what you want to show in your directory.  Remember ‘Location’ information goes to 911.  If you want a different address in Directory, use the ‘Directory Location’. 

From Riata Programs Menu, go into Service Order Entry, then from the Phone Number Information Screen click on the Location Tab.   

Note:   ** Directory Name will be used if there is no name entered in the ‘Other Listings’ from the Directory tab.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-          There is a ‘Fill from Location’ button that will copy the information from the Location side into the Directory Location side, then you can change just what you need to.

-          When there is an Address entered on the Directory Location, it will be used in place of the normal Location Address when running Directory Listings. 

-          Bill Info tab Name & Directory tab Name are displayed and there is a ‘Move’ button to the right of each.  If you click on the Move button it will move that name to the Directory Name field.

-          There is a ‘Remove’ check box – if this is checked the Directory Location information will be removed once the Service Order is Approved.  The normal Location information will then be used for Directory Listings.

 

When the Directory Name is edited the following message will be displayed if there is a name in the ‘Other Listing’ that is currently being used for Directory Listings.

 

 

 

 

 

 

 

 

- Enter Yes to remove the name in the ‘Other Listing’.

 

- Enter No to keep the name in the ‘Other Listings’ and it will be used for Directory Listings.

 

 

 

Directory Listing Criteria:  When looking for ‘Directory Listing’ information, we first use the ‘Other Listings’ information located on the Directory Tab.  If there is no Name or Address information in the Other Listings we then use the ‘Directory Location’ Name and Address information as shown above.  If there is no Name or Address information in the Directory Location we then use the Location information. 

 

The Directory Location information is also displayed in Riata Inquiry – Phone Number Information Screen – Location Tab as shown below. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3563   CABs PDF Statements / Email PDF to Carrier              

In the "CABS PDF Statements" option from the Riata Programs Menu, we have added the ability to Email the PDF to the Carrier if an Email address has been furnished.  The following new User Edits have been created for this purpose.

 

**REMINDER:  Carrier Email Address is entered on Option #16 (Key Cabs Carriers) on the CABs Menu (CBMENU1).

 

User Edit ‘CABS-PDF-EMAIL    FROM-ADDRESS’ is used to know the From Address to use when sending the CABs Statement PDF from the Creating CABs PDF File Program.

            Setup User Edit

                        Field 1 = CABS-PDF-EMAIL

                        Field 2 = FROM-ADDRESS

                        Field 3 through 4 = Enter the From Address to Use when sending the CABs Statement PDF to the Carrier.

                        Field 5 through 8 = Leave Blank

 

 

 

 

 

 

 

 

 

 

 

The example shown will use ‘johnsmith@syringawireless.com’ as the From Address when sending the CABs Statement PDF to the Carrier.

 

 

 

User Edit ‘CABS-PDF-EMAIL    MESSAGE-TEXT-FILE’ lets the System know where the Message Text File is Located.

This File will be used to Fill the Message Portion of the Email in the ‘CABs PDF Statements’ Program.

            Setup User Edit

                        Field 1 = CABS-PDF-EMAIL

                        Field 2 = MESSAGE-TEXT-FILE

                        Field 3 through 8 = Enter the Path & File to Use for the Message. 

(Example: N:/CABS/CABS_Email_Message.txt)

 

 

 

 

 

 

 

 

 

 

 

 

In the example shown, the System will look in the N:\CABS Folder for the CABS_Email_Message.txt File and use the Contents of the Text File and the Email Text. 

 

  

 

User Edit ‘CABS-PDF-EMAIL    SUBJECT-TEXT-FILE’ lets the System know where the Subject Text File is Located.  This File will be used to fill the Subject Portion of the Email in the ‘CABs PDF Statements’ Program.

            Setup User Edit

                        Field 1 = CABS-PDF-EMAIL

                        Field 2 = SUBJECT-TEXT-FILE

                        Field 3 through 8 = Enter the Path & File to Use for the Subject.

(Example: N:/CABS/CABS_Email_Subject.txt)

 

 

 

 

 

 

 

 

 

 

 

 

 

In the example shown, the System will look in the N:\CABS Folder for the CABS_Email_Subject.txt File and use the Contents of the Text File as the Email Subject.

 

   

 

From the Riata Programs Menu, click on ‘CABS PDF Statements’.

            Enter Library, Cycle, CABs State & Feature Group – then Click on Load

·         The information displayed in the ‘Message Text file’ correlates to the (MESSAGE-TEXT-FILE) User Edit explained above.   

 

·         Select with a Check next to the Carriers you would like to ‘Create a PDF’ and/or ‘Send Email’

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-          Then click on ‘Create & Email PDF Statement(s) or just Create PDF Statement(s). 

-          Once this is completed the PDF is Saved.

 

 

 

 

Project #3570    Pending Service Orders             

We have added the Ability to Sort and Move each of the Columns on the Pending Service Order screen.

From the Riata Programs Menu, select ‘Service Order Entry’, then Click on the ‘Pending Service Orders’ button.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-          Click on the Column Heading to Sort by that Column

-          Click & Drag a Column to move to a different Location.

 

 

 

 

 

Project #3575   Payroll - View G/L Account Number              

We have added the G/L Account Number when viewing the Summary Information for the current Pay Period.

To view the Summary Information:

      From the 1st Payroll Screen as shown here – Left click on the Name, then Right Click. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Summary Information including the G/L Account is now displayed as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

    To view the Summary Information:

      From the 2nd Payroll Screen as shown here – Left click on the Name, then Right Click. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The following screen will be displayed – select ‘View Summary’ and click on Select.

 

 

 

 

 

 

 

 

 

 

 

 

The Summary Information including the G/L Account is now displayed as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3597   Cash Receipts / Daily Plan             

We now use the "PCS-DAILY-PLAN" User Edit to know if the Customer is a Daily Plan Customer when taking a Cash Receipt. In the past, you were able to click the Daily Plan button in Riata Cash Receipts and take a Cash Receipt for a Customer whether or not the Customer was a Daily Plan Customer.

Now All Daily Plan Customers must have a Tariff Code that is listed in User Edit ‘ PCS-DAILY-PLAN’ fields 6 through 8.  If the Customer does Not have a Tariff listed in this User Edit, you will not be able to select the Daily Plan option in Cash Receipts.

 

Setup User Edit

            Field 1 = PCS-DAILY-PLAN

            Field 2 = Leave Blank

            Field 3 = XX (Days before up to SMS)

            Field 4 = XX (Days before Suspend – Not Used)

            Field 5 = XX (Days before OUT)

Field 6 through 8 = Enter Tariff Codes to Pull Out Recurring and to Verify Customer is a Daily Plan Customer.

                (XXXXX.XXXXX.XXXX) – Enter Tariff Code followed by a decimal. 

**Be sure to use preceding spaces as needed for Tariff Codes that are less than 5 characters. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If ‘Daily Plan’ is selected in Cash Receipts, on a Customer that Does-Not have a Tariff Code listed in Fields 6 through 8 on this User Edit, the following Message will be displayed.

 

 

 

 

 

 

 

 

 

 

Click on OK – and you will be returned to the Cash Receipt Screen. 

 

 

 

 

Project #3592   2007 Service Order Entry / Reset Number         

In 2007 Service Order Entry if you have entered or selected a Phone Number, then want to change the Number; we have added a ‘Reset #’ button.  When you click on the ‘Reset #’ button the Number obtained will be cleared out and that Number will be un-available.  Enter or select another Number and continue on with the Service Order. 

If you click on Reset # in error and want to use the previously obtained number,  Contact CTI to make the number available.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3602   Account Balance Search            

On the Riata Programs Menu, there is a new option called “Account Balance Search”.  Contact your Internal Security Personnel to get Authority to this new Feature.  When ‘Account Balance Search’ is selected a ‘400 Information’ sign-on Screen will be displayed.  Enter your AS/400 User name and Password and click on ‘Log In’.  

 

Once you Log on, the following Account Balance Search screen will be displayed.   This is used to locate Accounts (by Type) that are over the Balance entered.  For Example; if you are looking for all ‘Write Off’ Accounts with a Current Balance of $20.00 or Higher, you would completed the screen as shown and click on Display.

 

Enter $20.00 in the ‘Show Account Balances Over’

Select ‘Write Off’ as the Account Type

Click on Display.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Options to ‘Print’, create a ‘PDF’ and transfer the information to ‘Excel’  are available. 

 

 

 

Project #3606   Write Off Search            

On the Riata Programs Menu, there is a new option called “Write Off Search”.  Contact your Internal Security Personnel to get Authority to this new Feature.  When ‘Write Off Search’ is selected a ‘400 Information’ sign-on Screen will be displayed.  Enter your AS/400 User name and Password and click on ‘Log In’.  

 

Once you Log on, the following ‘Accounts Written Off’ screen will be displayed.   This is used to locate Accounts that have been Written Off within the Time frame (Dates) entered.  This can be used if you have to send an Excel Spreadsheet to a Bank or Credit Bureau.  The screen will display Account Name & Address Information, Payment & Balance Information, Write Off Date and Notes.  Use the scroll bar to view all the fields. 

For Example; if you are looking for all Accounts that were written off between 01-01-2007 through 09-01-2008, completed the screen as shown below and click on Display.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Option to transfer the information to ‘Excel’ is available. 

 

 

 

 

Project #3552      Run Green Screen or Riata Statements           

When printing Statements, we now ask if you want to run Green Screen or Riata Statements.  From Start1 Menu; select #1 (Customer Information), then #12 (Goto Month End Billing Menu), then #7 (Print Bills).

When running ‘Print Bills’ the following question will be displayed Only if Statements are set to ‘N’ (No) in the Control File – In this Option you can select to Print Statements from Green Screen or Riata.  

 

 

Text Box: 18 08 07         #18  RIATA TELEPHONE COMP                   8/05/08    
      7/08/08                                                    08:31:00    
                                                                             
          Enter the Select Statements to print option you want to run.       
                                                                             
            1 - Green Screen                                                 
            2 - Riata    (requires  .NET)
                                                                             
                                         2                                   
                                 Cmd 5 - Continue on         Cmd3=N

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

** You must have .NET to use option #2 – Riata. 

If you select #2 (Riata) the following screen will be displayed.   

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Default:  All Accounts with a Y (Yes) in the File will be displayed when you first come into this screen. 

-          You have the Option to Change ALL to Y (Yes).  When you select this button, all Accounts in the File will be changed to a Y (Yes) and ALL will be displayed. 

-          You have the Option to Change ALL to N (No).  When you select this button,  all Accounts in the File will be changed to a N (No) and nothing will be displayed. 

You can Click on Column Headings to Sort if needed. 

 

The lower section of the screen will give you the ability to select a certain criteria of Statements.

            For Example;  If you want to view only the Statement for Company #1 and only the Statements in Company #1 that have Zip Code 83638 or greater.  You would complete the lower section of the screen as shown below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*NOTE:

Only Statements that are a ‘Y’ (Yes) are displayed in the upper half of this screen. 

 

-          You can select ‘Change to Y’ or Change to N’ for this Criteria. 

-          You can select ‘Save Selection’ to save this criteria to be used again the next time or next month.

-          The ‘Load Selection’ button will allow you to load in a previously Saved Criteria.

 

You have an Option to ‘Select by Tariff Code’.  When you click on this button the following window will be displayed for you to enter the Tariff Code and if you want to Change to Y or N. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When you have completed all the changes you want you press “All Done” to Continue.  You will be returned to the AS/400 Screen as shown here to continue with Statement Processing.

 

Text Box:   99 08 08                   CADATA 99 Company                 8/20/08  
   8/07/08                                                    10:15:42  
                                                                        
       Statement Selection                                              
                                                                        
       Do NOT go on until you have finished and closed out              
       the PC program that was just running.                            
                                                                        
          --- Make sure you Closed it and did not just Minimize it ---  
                                                                        
                                                    R=Run program again 
       Is the PC program completely done running and closed? (Y/N/R)    
                                      Y                                 
                              Cmd 5 - Continue on         Cmd3=N

                                                                       

                                                                        

                                                                       

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3497      Inventory / Delete Inventory Items       

We have added a way to Delete Inventory Items. This will delete the Master Detail and all Other Information associated with the Master.  (i.e.: Shelf, UPC, Price Information).   You first need to create a Temporary File, in Inventory Master Format, that has just the Inventory Numbers in it that you want to Delete. This file Can Not start with INM. This is what the Inventory Master File starts with. We do not want to take any chances on deleting the entire Master File!

 

You will probably use Query to create this Temporary File.  Contact CTI for assistance.

 

From Start1 Menu; select #7 (Inventory), then #24 (More Inventory Options), then #14 (Delete Inventory).

When this is run, you will be asked for the name of the temporary file. 

 

Text Box:   01 08 07        Riata Training Company                 7/07/08          
   7/07/08                                              14:21:05          
                                                                          
   You need to have a temp file created with just the Inventory           
   Item numbers that you want to delete.                                  
   If you continue, Inventory #s from your temp file will be              
   deleted from your real Inventory Master & Detail files.                
                                                                          
   Are you sure you want to continue?  (Y/N)                              
  
                              Y                                          
                      Cmd 5 to continue on                     Cmd 3=N    
                                                                         

     

 

 

 

 

 

 

 

 

 

 

- Enter ‘Y’ to Continue or ‘N’ to return to the INMEN3 Menu.

 

Enter the Temporary Inventory Master File to Use on the following screen.

                                                                       

Text Box:    01 08 07             Riata Training Company                  7/07/08 
    7/07/08                                                    14:22:55 
                                                                        
        Enter the name of the temp Inventory Master file to use   

      
                               XXINM01                              
                            Cmd 5 to continue on

 

 

 

 

 

 

 

 

 

The Inventory Number from the File entered will be used to go through all the other files to Delete the Information.  Once the Inventory is deleted you will be returned to the INMEN3 Menu.

 

 

 

Project #3498        MSAG / Load From a Excel  (.csv) Spreadsheet    

We have added the option to pull the BMSAG information from a Excel (.csv) Spreadsheet. This process copies the MSAG data in the Excel Spreadsheet form on the PC to the AS/400.

You will need to make sure your Spreadsheet Columns are in the following order:  (You can Move Columns Around to get them is the Order needed).

                Column A = Pre Directional                                 

                Column B = Street                                          

                Column C = House Number From                                    

                Column D = House Number To                                      

                Column E = City                                            

                Column F = State                                           

                Column G = Odd/Even                                        

                Column H = Post Directional                                

 

From Start1 Menu; select #23 (System Maintenance), then #23 (Goto Maintenance Menu #2), then #22 (Key Master Street Address Guide).

 

 

Text Box:      18 08 07         #18  RIATA TELEPHONE COMP                   7/09/08  
      7/03/08                                                    09:29:41  
                                                                           
    Do You Want to ADD/CHANGE A Master Street Address (Y/N)             N  
                                                                           
    Do You Want a Listing (Y,N)                                         N  
                                                                           
    Do You Want to Load the BMSAG file (Y/N)                            Y  
                                                                           
    Create Initial MSAG from BAPHN (Y/N)                                N  
                                                                           
    Change file with DFU ?                                              N  
                                                                           
    List file with Query ?                                              N  
                          Cmd 5 to continue on                             
                                                      

                   

                                                                          

                                                                          

 

 

 

 

 

 

 

 

 

 

 

 

Enter ‘Y’ in Do You Want to Load the BMSAG file?

 

Press F5

Enter ‘2’ ( 2 – CSV) in the screen shown below.

 

Text Box:    18 08 07         #18  RIATA TELEPHONE COMP                   7/09/08 
    7/03/08                                                    09:31:11 
                                                                        
        What format do you want to run?                                 
                                                                        
            1 - Space Delimited                                         
            2 - CSV                                                     
                                       2                               
                               Cmd 5 - Continue on         Cmd3=N       
                                                                       

 

 

 

 

 

 

 

 

 

 

 

 

The following screen will be displayed to verify the Spreadsheet Columns are in the correct order and Spreadsheet has been saved in the correct Format.  Press F5 to Continue.

 

Text Box:   18 08 07         #18  RIATA TELEPHONE COMP                   7/09/08   
   7/03/08                                                    09:32:36   
                                                                         
       This process copies the MSAG data in CSV spreadsheet format       
       on the PC to the 400.  Use the following column order:            
       Col A - Pre Directional                                           
       Col B - Street                                                    
       Col C - House # from                                              
       Col D - House # to                                                
       Col E - City                                                      
       Col F - State                                                     
       Col G - Odd/Even                                                  
       Col H - Post Directional                                          
       Please note, the spreadsheet file should be saved on the          
       PC as a .CSV Comma delimited file                                 
                                                                         
                              Cmd 5 - Continue on         Cmd3=N

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

NOTE: The Spreadsheet File should be saved on the PC as a .CSV Comma Delimited File.  Make sure you have the State Column Populated and Save the Spreadsheet in .CSV Format to your CTITRANS Folder.

                                                                           


 

  The following screen will be displayed – Enter ‘Y or N’ as instructed.  Then Press F5 to Continue.           

 

                                                            

 

Text Box:                                                                            
  18 08 07    #18  RIATA TELEPHONE COMP                  7/09/08           
   7/03/08                                              09:34:25           
                                                                           
      If you choose to clear the file, make sure no one                    
      is in Service Order Entry                                            
                                                                           
   Do you want to Clear the Entire BMSAG File (Y,N)                        
                                                                           
                              N                                            
                                                                           
                      Cmd 5 to continue on                     Cmd 3=N     
                                                                        

 

 

 

 

 

 

 

 

 

 

 

 

 

 

**We recommend ‘N’ on this screen.  Use the following to Delete MSAG information by City. 

      From Start1 Menu; #23 (System Maintenance), then #23 (Goto Maintenance Menu #2), then #22 (Key Master Street Address Guide).  Enter Y to Add/Change Master Street Addresses – Press F16 to Delete All for State & City.

 

 

 

  The following screen will be displayed – Enter ‘Y’ to Continue to the next screen and enter your .CSV File name.

 Then Press F5 to Continue.           

 

 

                                                                         

                                                                         

Text Box:    18 08 07    #18  RIATA TELEPHONE COMP                  7/09/08         
    7/03/08                                              09:35:37         
                                                                          
                                                                          
    On the next screen replace YOURFILE with the file name                
    that you are reading in from the PC Folder                            
    and then press enter.                                                 
                                                                          
    Those records will then be copied into file ZMSAG                     
                                                                          
                               Y                                          
                                                                          
                       Cmd 5 to continue on                     Cmd 3=N   
                                                                         

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  The following screen will be displayed – Enter your .CSV File name (example; ZMSAG1.CSV) then press Enter.  The system will copy the .CSV File into the AS/400. 

 

 

Text Box:                    JHCPYFRMPC - Copy from Folder (JHCPYFRMPC)                   
                                                                                
 Type choices, press Enter.                                                     
                                                                                
 PC File to Copy From . . . . . . > ZMSAG1.CSV      Character value               
                                                                                
                                                                                
                                                                         Bottom 
 F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel   F13=How to use this display    
 F24=More keys

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

Project #3529    -  P/O (Purchase Order) Master File

We have added the following to the Purchase Order (P/O) Master File;

Denied Date,  Denied User,  Date Vendor E-Mail Sent,  Approved P/O User,  Approved Payment User, 

Date Updated,  User Updated.

** This is for Future Enhancements to Email Purchase Order(s). 

 

 

 

Project #3537   -   Location Code for NXX

We have created a User Edit called ‘PLAN-SUMMARY  CONVERT-EXCHANGE to update the location field in BARHS file.  This User Edit is used to enter the NXX and Location Code to use for that NXX.  When the Location Code is blank whatever is keyed in here for that NXX is used.  (You can have multiple records for this User Edit).

 

 

Setup User Edit:

      Field 1 = PLAN-SUMMARY

      Field 2 = CONVERT-EXCHANGE

Field 3 through 8 = Enter the NXX (436) a decimal (.) the Location Code (RU  ) a decimal (.) NXX (532) a decimal (.) the Location Code (WH  ) 

 

 

Note: In this User Edit we allow 3 characters for the Location Code even though most Location Codes are only 2 characters.    

 

      Example:  436.RU .532.WH .

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Plan Summary is based off the Inventory Location (2 Character) Code.  Therefore, normally you will change the NXX to a 2 Character Inventory Location Code.

 

 

 

 

 

Project #3516     Payroll / Check Number Replaces Name         

When you setup new User Edit ‘BANK-RECONCILE PAYROLL-NO-NAME’ the Check Number is put in place of the Name when running Payroll.  This User Edit will be used to Not Include the Name in the Payroll Bank Reconcile File.  The Check Number will be output in the place of the Name.

 

Setup User Edit

            Field 1 = BANK-RECONCILE                       

            Field 2 = PAYROLL-NO-NAME

            Field 3 through 8 = Leave Blank

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3542     GetLisa User Edit         

You can now Create the Non-Recurring charges for GetLisa.  (GetLisa’ is the name of a Company that Supplies Cellular Wallpaper, Ring Tones, etc. to some of our Clients).  You will need to setup new User Edit called ‘GETLISA-BILL-1 TARIFF’.   This User Edit is used to enter the Tariff Codes used for the Codes from the ‘GetLisa’ File.

 

Setup User Edit

Field 1 = GETLISA-BILL-1

Field 2 = TARIFF

Field 3 through 8 = (In the First 14 Characters, enter the ‘GetLisa’ Code, then enter a decimal , then in the Last 5 Characters enter the Tariff Code). 

 

Note: The GetLisa codes are Case Sensitive and make sure you enter Leading Spaces if need on Tariff Codes.

 

 

 

In the Example shown here,

 

GetLisa code ‘Realtones’ would have Tariff Code ‘REAL1’ and GetLisa code ‘Voice Ringers’ would have Tariff Code ‘VRN1’ and GetLisa code ‘Wallpaper’ would have Tariff Code ‘WP1’.

 

Field 3 = Realtones     .REAL1

Field 4 = Voice Ringers . VRN1

Field 5 = Wallpaper     .  WP1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3544     New Access Summary by Batch & Date         

We have made a new Access Summary by Batch and Date.  From Start1 Menu; select #2 (Toll), then # 4 (Access Summary Report) – select Option ‘A’ as shown in the screen below. – Press F5 to Continue

 

 

Text Box:   01 08 07             Riata Training Company                  8/04/08
   7/23/08                                                    16:45:00
                                                                      
       1 - Summary By Batch, NPA, NXX, ETC.                           
       4 - Summary By Exchange, Carrier, Date                         
       8 - Summary By Day by Carrier by Type                          
       9 - Summary by Date only                                       
       A - Summary by Batch and Date                                  
                                                                      
       What Type Of Summary Would You Like (1,4,8,9,A)                
                                                                      
                                     A                              
                              Cmd 5 - Continue on         Cmd3=N      
                                                                     

                                                                      

 

 

 

 

 

 

 

 

 

 

 

 - Enter the File(s) you want to List on the following screen – Press F5 to Continue

* You can enter 1 or 2 File Names as needed.

 

Text Box:    01 08 07             Riata Training Company                  8/04/08   
    7/23/08                                                    16:47:41   
                                                                          
Enter the files you want to list.                                         
You can enter just one file name if needed.                               
                                                                          
File 1 . . . . . . . . . . . . . . . . . . . . . .             TBCLACS    
File 2 . . . . . . . . . . . . . . . . . . . . . .             TBCLACSD   
                                                                          
                        Cmd 5 to continue on                              
                                                                         

                                                                          

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3504  -  Rate Roaming Data With Different Rates        

We have made a way that you can Rate Roaming Data Records different than Data Records made Locally.

This would be when Customers are Roaming and use their Cell Phone to Access the Internet.

 

A new option has been added to the list of PCS Options.

From Start1 Menu; select #23 (System Maintenance), then #24 (Goto Wireless Menu), then #4 (Key/List PCS Packages).

The new option is “J” Set up Roaming Data Charges.  It is on the 2nd screen of Options.

                                                                         

Text Box:    01 08 07             Riata Training Company                  7/09/08   
    7/07/08                                                    11:27:11   
                                                                          
        1= Key/List PCS Packages                                          
        2= Related NPA/NXX for WLL / Call Forward / Drop Toll             
        3= Key States to Include for Roam @ Local Rates                   
        4= Key/List Special Free Minutes (Non Riata)                      
        5= Delete Special Free Minutes (Non Riata)                        
        6= Special Free Minute Summary (Non Riata)                        
        7= 3 Month Summary Report & Over/Under limit of Phones for Plan   
        8= Test rates for new PCS Plan                                    
        9= Key/List Local Market Towers for NPA/NXX                       
        A= Key/List SIDs by Tariff for Special & Local Re-rating          
        B= Key/List City Names to Include in Free Minutes                 
           (A Blank Code will give you more options)                      
                                       _                                  
                               Cmd 5 - Continue on         Cmd3=N         
                                                                         

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*  Leave Option Blank on the First Screen & Press F5 to get to the second screen.

 

Enter ‘J’ (Set up Roaming Data Charges) on the following Screen & Press F5 to Continue.

 

 

Text Box:    01 08 07             Riata Training Company                  7/09/08  
    7/07/08                                                    11:28:15  
                                                                         
        C= Key/List Expanded Area Tower Numbers                          
        D= Key/List Cities Considered Toll Free                          
        E= Key/List City/State for Tower                                 
        F= Key SIDs to change the From Place for CIBER Calls             
        G= Key/List Limit Free Minutes to Certain States                 
        H= Setup Minutes & Charges using User Defined                    
        I= Set up Coverage Areas                                         
        J= Set up Roaming Data Charges                                   
                                 J                                   
                               Cmd 5 - Continue on         Cmd3=N

                                                                        

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                                         

This option uses the same format as the regular plan setup. You need to set up each tariff code here that you want to charge roaming rates for. You will use the same tariff codes as what was set up in the regular plan setup. This includes any add on tariff codes for data rating.  Only tariffs that pertain to Data Rating need set up here.

 

 

 

Go to screen 5 and add the rates you want to charge. 

 

Text Box:                                 Index   ZZ123    (Tariff Code)                            
                                                     Screen 4 of 5
                                   TRA State   TER State                      
  Special Roaming Rates? (Y/N)       .0000       .0000    *** Per Minute ***  
  Free Roaming Minutes      0                                                 
                                                                              
                        Daily Off Peak Hours                                  
                     From   To   or   From   To                               
         Monday       :00   :00        :00   :00                              
         Tuesday      :00   :00        :00   :00   Special Plan Add Ons use   
         Wednesday    :00   :00        :00   :00   times from the initial     
         Thursday     :00   :00        :00   :00   plan to determine Peak/    
         Friday       :00   :00        :00   :00   OffPeak.                   
         Saturday     :00   :00        :00   :00                              
         Sunday       :00   :00        :00   :00                              
                                                                              
     Minimum # of Lines:   0                                                  
     Maximum # of Lines:   0                                                  
                              Holidays (MM/DD/YY)                             
      0/00/00    0/00/00    0/00/00    0/00/00    0/00/00    0/00/00          
      0/00/00    0/00/00    0/00/00    0/00/00    0/00/00    0/00/00          
                                        Cmd12 = Key CarryOver

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

***Note: A message has been added to the SMS/MMS/Data screen that reminds you to use Option J to set up Roaming rates.

 

We now separate Regular Data Usage and Roaming Data Usage.  They will appear  separately in the Air Time Summary section of the Statements. 

 

We have also set up a new User Edit called ‘PCS-DATA-ROAMING-MIN’.

 

This User Edit will let you set up a Minimum Data Size to charge for if making a Data call while Roaming.

You can enter the size in KB or MB. Use the option that matches best how you set your PCS plans up.

You can have different Minimums based on a Tariff Code/PCS Plan Code or have just one Minimum for all Tariff Codes.

 

To have just one generic Minimum, leave Fields 4-8 blank.

 

To set up a Minimum based on Tariff Code, key the Tariff Code(s) in Fields 4 through 8. 

You can enter up to 3 Tariff in each Field.  Enter the 5 Character Tariff separated by a decimal.  Remember to key leading blanks if the tariff code is less than 5 characters long.   Example;    ATARF.1TARF.  TAR

 

** You will have to setup Multiple User Edits with different Tariff Codes if you have different Minimums.

 

Setup User Edit

                Field 1 = PCS-DATA-ROAMING-MIN           

                Field 2 = Leave Blank

                Field 3 = K2048 or M2

Field 4 through 8 = Leave Blank or Enter Tariff Code(s)

 

 

 

 

The Example shown, would Charge for a Minimum of 2 megabytes for any Data Roaming Call for Tariff Codes, ATARF, 1TARF and TAR.

 

 

 

 

 

 

 

 

 

 

 

 

 

Project #3560   “Carrier Line Assessment” – Statement Message            

We changed the program to create statement messages to say Carrier Line Assessment.

Per AT&T PO #07T-20-##-ZZ-M-CPS-1 

 

 

Project #3566     Patronage Local Service File          

Patronage Local Service File (bnrpt1) has been changed so that if, the Member Number is blank in the Account File then we use the Account Number as the Member Number when building the Non-Recurring Patronage File.

 

 

 

Project #3593   Inventory / Key Inventory Master – Unit Cost of Zero            

If you have a Unit Cost of Zero you can Now Continue On.  We changed the message to say 'Unit Cost of zero can be ok’. 

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

 

 

Text Box:  Description         Cell Phone Case                  Inventory #      JO4      
 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      20.000  (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 # N    
     Qty       Paid For      Paid For         Unit    Unit Cost of              
    On Hand        Qty     Total Cost         Cost    Last Addition             
        0         35-           .00           .000            .000              
        0         35-           .00                         .000                
 F10-Key Min/Max Qty F19-Unlock G/L                                             
 F11-Key UPC Codes F14-Shelf Info F15-Selling Prices F20-Image F16-Del F18-Clear
                                                                                                     

                                                                                

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When Unit Cost is Changed to Zero or New Inventory Added with a Zero Unit Cost, the following Message will be displayed.

 

 

Text Box:                       Unit Cost                       
        *** WARNING THE UNIT COST IS ZERO ***         
                                                      
  The Unit Cost is equal to zero.  If this item is    
  taken out of inventory before it is paid for, the   
  system will not know the Unit Cost.  If you do      
  not know the Unit Cost then check with someone      
  who would know.  An estimate is better than zero.   
                                                      
  Unit Cost of zero can be ok.  But make sure it is   
  truly a Unit Cost of zero before you press F5.      
                                                      
                 Unit Cost       .000                 
  F5-Enter                                            
                                                     

                                                      

 

 

 

 

 

 

 

 

 

 

 

You can now Continue with a Zero ‘Unit Cost’ – Press F5

 

**Please verify a Unit Cost of Zero is Correct, before you Continue and Press F5. 

 

 

 

 

 

 

Project #3587     Special Access / Merge             

We have a new option that will let you Merge Two Special Access Files into One.  You will be asked to enter the From State and Carrier and the To State and Carrier.  The Special Access Files for the From State and Carrier will be Merged into the To State and Carrier.

From Start1 Menu; select #3 (CABs Billing), then #24 (More CABs Billing Options…), then #10 (Merge Two Special Access Files Into One).

NOTE:  Clean-up Special Access / Auto Bill in Option #4 before using Option #10 (Merge Two Special Access Files Into One).

 

 

Text Box: CBMEN2                         CBMEN2 Menu                           
                                                                     
Select one of the following:                                         
                                                                     
     1. Key Exchanges for each CABS State                            
     2. Reprint Cabs Bills From History                              
     3. Combine CABS Special Access Files - Nightly All              
     4. Key Spcl Acc. Auto Bill Carriers                             
     5. Auto Run Special Access Carriers                             
     6. Key Special NECA Tariffs                                     
     7. Print Billing Summary-Pct of Differences                     
     8. Enter Cabs Program Sort Order                                
     9. Change Program Sort Order / Print                            
    10. Merge Two Special Access Files Into One                      
                                                                     
Selection or command                                                 
===>                                                                 
F3=Exit   F4=Prompt   F9=Retrieve   F12=Cancel                       
F13=Information Assistant  F16=AS/400 main menu

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The following screen will be displayed – Press F5 to Continue on.

 

Text Box:   01 08 09        Riata Training Company                 9/03/08         
   9/03/08                                              10:26:50         
                                                                         
   On the Next Screen enter the State and Carrier you                    
   are going to copy FROM                                                
                                                                         
                                                                         
                      Cmd 5 to continue on                     Cmd 3=N

                                                                        

                                                                        

 

 

 

 

 

 

 

On the following screen – Enter the ‘From State and Carrier’ – then press F5 to Continue.

                                                               

Text Box:        9/03/08                                                  
      10:27:58   Cabs Billing Selection                         
                                                                
                  Carrier 0110                                  
            Feature Group D                                     
             Jurisdiction EE                                    
                  State # 1                                     
                                                                
               CMD-5 to RUN job                                 
               CMD-3 Return To Menu                             
                                                               

                                                               

 

 

 

 

 

 

 

 

 

 

The following screen will be displayed – Press F5 to Continue on.

 

Text Box:   01 08 09        Riata Training Company                 9/03/08         
   9/03/08                                              10:29:50         
                                                                         
   On the Next Screen enter the State and Carrier you                    
   are going to copy TO                                                
                                                                         
                                                                         
                      Cmd 5 to continue on                     Cmd 3=N

                                                                        

                                                                        

 

 

 

 

 

 

 

On the following screen – Enter the ‘To State and Carrier’ – then press F5 to Continue.

                                                               

 

Text Box:        9/03/08                                                  
      10:27:58   Cabs Billing Selection                         
                                                                
                  Carrier 1234                                  
            Feature Group D                                     
             Jurisdiction EE                                    
                  State # 2                                     
                                                                
               CMD-5 to RUN job                                 
               CMD-3 Return To Menu                             
                                                               

                                                               

 

 

 

 

 

 

 

 

 

 

The Special Access Files will be Merged and the following screen will be displayed.

 

Text Box:   18 08 08    Test Telephone Company  Rupert             9/05/08          
   8/21/08                                              16:53:24          
                                                                          
   Do you want to delete the From File (Y,N)                              
                                                                          
                              N                                           
                                                                          
                      Cmd 5 to continue on                     Cmd 3=N

                                                                         

                                                                         

                                                                          

                                                                         

 

 

 

 

 

      - Enter Y (Yes) if you want to delete the “From File” or N (No) to keep the ‘From File’.