Abstract:
Systems and Methods for telecommunication expense management are provided. A distributed platform including a user support site, multiple user databases and customized user applications is provided to enable organizations to better manage their telecommunication services and expenses. In an embodiment, a method for electronically processing telecommunication invoices includes importing the telecommunication invoices, extracting elements from the imported invoices and performing reasonability tests on the imported invoices. The reasonability test includes conducting an automated comparison against established criteria that may be customized by users. The method includes generating one or more interactive reports that enable an organization to effectively manage its telecommunication services.

Description:
CROSS REFERENCE TO RELATED APPLICATIONS 
       [0001]    The present application is a continuation of U.S. patent application Ser. No. 12/031,399, entitled Systems and Method Jr Analyzing Telecommunications Invoices, filed Feb. 14, 2008 (399 Application), which is herein incorporated by reference in its entirety. 
         [0002]    The &#39;399 application is a continuation of U.S. patent application Ser. No. 10/361,519, entitled Systems and Method for Managing and Processing Telecommunications Invoices, which was filed Feb. 10, 2003, issued as U.S. Pat. No. 7,340,422 on Mar. 4, 2008 and is herein incorporated by reference in its entirety. 
         [0003]    The present application is also related to U.S. patent application Ser. No. 12/031,406, entitled Systems and Methods for Identifying and Processing Telecommunications Billing Exceptions, which was filed on Feb. 14, 2008, issued as U.S. Pat. No. 7,805,342 on Sep. 28, 2010, and is herein incorporated by reference in its entirety. 
     
    
     BACKGROUND OF THE INVENTION 
       [0004]    1. Field of the Invention 
         [0005]    The present invention relates to a system and method for electronically processing and managing a plurality of types of telecommunications invoices. 
         [0006]    2. Background Art 
         [0007]    The traditional manual methods of collecting, reviewing and paying vendors&#39; invoices, especially periodic invoices, e.g., telecommunications and utility bills, are a manual process. These methods impose substantial difficulties for users having large volumes of such invoices. 
         [0008]    One format designed to bring uniformity to these invoices is the electronic data interchange (EDI) standard. EDI is the direct communication of trading messages between computer systems using national and international telecommunications networks. EDI transaction files can be as basic as orders and invoices, but EDI can also develop into a much more sophisticated information exchange so that trading partners may manage their whole supply chain more effectively. Key elements in EDI are the application software at either end of the exchange, linked to EDI message handling software that is in turn linked to a communications network. 
         [0009]    While the EDI standard is very flexible to accommodate various types of transactions and businesses, this variety provides difficulties in the audit function, as vendor files differ in their implementation of the EDI standard. 
         [0010]    Another format designed to bring ease of information exchange between businesses is the extensible markup language (XML) standard. XML 1.0 was released in February 1998. XML is now viewed as the standard way information will be exchanged in environments that do not share common platforms. 
         [0011]    While the XML standard is very flexible to accommodate various types of transactions and businesses, this variety provides difficulties in the audit function, as vendor invoice files differ in their implementation of the XML standard. 
         [0012]    Presently, there are a few similar inventions. One type of solution is MBG&#39;s (New York, N.Y.) solution for telecommunications providers, iBillManager®. It is a web-based billing system that enables telecom carriers to present invoices electronically over the Internet or corporate intranet. While the solution is also web based and presents telecom invoices and the detail, it is presented from the view of one provider and is not designed to present invoices from multiple telecommunications providers. The solution also does not provide any audit capability. 
         [0013]    Another is type of solution is call accounting software. Veramark&#39;s (Pittsford, N.Y.) solution for Web-based call accounting software is eCAS®. Call accounting software extracts call detail records from the user&#39;s phone hardware to analyze telecommunications usage. This information does not directly tie back to the vendors billing due. This information can be used to analyze and audit inter-company expenses but it doesn&#39;t analyze vendor invoices for errors. It also doesn&#39;t support the entire telecommunications infrastructure because it is limited to only inbound and outbound voice traffic and only on traffic that runs through the user&#39;s hardware. 
       SUMMARY OF THE INVENTION 
       [0014]    The current invention provides a system and a method that permits a user to electronically audit and process a plurality of types of telecommunication vendor invoices. “Telecommunication” is defined as service that provide the ability for individuals or systems to communication over a distance including but not limited to local and long distance phone services, wireless services, and data services. A type of invoice includes, but is not limited to, EDI as a type and XML as another type of invoice. A plurality means at least two different types of invoices can be received. The system includes a means for communicating a plurality of types of invoices from a vendor site to a user site and a means for performing an automated reasonability test on the invoices at the user site. 
         [0015]    More specifically, this invention provides a system for processing a plurality of types of telecommunication invoices received by a user from a plurality of vendors. The system including: 
         [0016]    (a) means for importing a plurality of types of telecommunication invoices to a user database from a plurality of vendors to provide comparable telecommunication invoices; 
         [0017]    (b) means for auditing the comparable telecommunication invoices by the user; 
         [0018]    (c) means for approving the comparable telecommunication invoices by the user; and 
         [0019]    (d) means for processing the comparable telecommunication invoices by the user. 
         [0020]    Additionally, this invention provides a system for management of a plurality of types of telecommunication invoices received by a user from a plurality of vendors. This system including: 
         [0021]    (a) means for importing a plurality of types of telecommunication invoices to a user database from a plurality of vendors to provide comparable telecommunication invoices; 
         [0022]    (b) means for auditing the comparable telecommunication invoices by the user; 
         [0023]    (c) means for reporting comparable telecommunication invoices by the user; 
         [0024]    (d) means for approving the comparable telecommunication invoices by the user; and 
         [0025]    (e) means for processing the comparable telecommunication invoices by the user. 
         [0026]    A method to process a plurality of types of telecommunication invoices received from a plurality of vendors comprising: 
         [0027]    (a) importing a plurality of types of telecommunication invoices from a plurality of vendors through mapping modules corresponding to a plurality of types of telecommunication invoices to obtain comparable telecommunication invoices; 
         [0028]    (b) auditing the comparable telecommunication invoices; 
         [0029]    (c) approving the comparable telecommunication invoices; and 
         [0030]    (d) processing the comparable telecommunication invoices. 
         [0031]    More specifically, using the present invention, a user can (1) receive invoice information by any of a variety of methods, including electronically, from a vendor; (2) automatically audit the invoice information, resulting in either approval of the invoice information or identification of billing exceptions; (3) notify the vendor of any billing exceptions; (4) pay the vendor by electronically transmitting a file to the user&#39;s accounts payable (“AP”) system in fixed length, delimited or XML file formats; (5) allocate costs by electronically transmitting a file to the user&#39;s general ledger (“GL”) system in fixed length, delimited or XML file formats; and (6) maintain historical information, which permits trend analysis and management reporting. The advantages of the present invention over conventional systems and techniques are numerous and include the following: (1) a paperless invoice processing thus an increased efficiency; (2) a drastic reduction in the administrative costs and human resources needed for processing invoices; (3) a real time updating of supplier accounting and thus no penalizations for the user; (4) an electronic data input to accounting systems, reducing invoice accuracies; (5) a large number of specialized reports, including audit, summary and customizable (custom) reports, that will provide the user with valuable feedback on the transactions that are processed through the system; (6) an improved way to communicate and have feedback to the vendor, regarding invoices received from him; (7) a trend of invoices received by a user from one vendor that provides the user with the possibility of comparison of received invoices. 
     
    
     
       BRIEF DESCRIPTION OF THE DRAWINGS 
         [0032]      FIG. 1  represents the distributed embodiment of the present invention. 
           [0033]      FIG. 2  is a data flow diagram which depicts the flow of data between major processes in the present system. 
       
    
    
     DESCRIPTION OF THE INVENTION 
     I. Distributed Embodiment 
       [0034]    Now referring to  FIG. 1 , the present invention uses a distributed architecture in which a user database  3  is located at a user site. Portions of the user database  3  are maintained remotely through a user support site  1 . The portions are routinely updated to keep the system up to date with the latest vendors and their corresponding service offerings. Vendor mapping rules are replicated to the user&#39;s database  3  from user support site  1  via communication pathway  2 , such as the Internet. The user database  3  is maintained by a series of computer-implemented processes, computer programs, which run on the user database  3  to stay current with vendor invoice mapping rules received from the user support site  1 . Reports may be generated to test synchronization that must exit between the user database  3  and the user support site  1 . 
         [0035]    The user database  3  includes the vendor mapping rules replicated from the user support site  1 , the user&#39;s vendor invoices, and all of the tables for the user application  5 . A table is a portion of database that groups like records together, such as, but not limited to, user table, user rights table, dictionary table defining drop down boxes. The user application  5  is the functional portion of the invention where the user enters information manually, the system enters information electronically, the user views information, and the system outputs information electronically. All of this information is accessed from the user database  3  via the communication pathway  4 . 
         [0036]    Multiple users may be supported by the user support site  1 . User database  3  can be and normally would be located at another location designated by the user. This user database  3  can be maintained remotely through a user support site  1  via communication pathway  2 . Similarly, user application  5  is also located in another location designated by the user. Similarly, any number of other user databases  6  and user applications  7  can he installed and maintained from one common user support site  1  via a communication path  2 . 
       II. Data Flow and Major Processes 
       [0037]    The distributed embodiment described in  FIG. 1  is more fully shown in  FIG. 2 . The user application  5  is made of various modules that can receive inputs from vendors and provide output to the user database  3 , user human resource system  40 , and user accounting system  41 . A module is a component of the system that can be removed and the system can still function without the functionality of the module. It has a predefined set of inputs and outputs. These inputs and outputs can be from or to system or user. The system includes means for: importing types of telecommunication invoice information to a user database  3  to provide comparable telecommunication invoices. Invoices are comparable when the basic elements of the invoice are placed in common categories. These common categories can include, but are not limited to, such items as taxes and surcharges. The system also includes means for auditing, approving and processing the comparable invoice information. The following sections describe various means to accomplish these functions. 
         [0038]    A. Means for Importing a Plurality of Types of Telecommunication Invoice Information to User Database 
         [0039]    The system includes a means for importing a plurality of types of telecommunication invoice information into a user database  3 . A plurality of invoice types means more than one type. Type of invoices include: EDI, XML, custom and paper invoices. The types of vendor invoices can be imported by importing this data through the mapping process. The mapping process takes vendor specific charges and places them in common categories based on service rendered. For example, under local service, call-waiting, call forwarding, voice mail, and caller ID are all features that can be removed and still have the service so they are categorized as feature charges and grouped together. A mapping module is a component of the system that for each service rendered on a type of types of invoice provides a common category for comparison. The corresponding mapping module is the mapping module that allows the categorization of specific telecommunication invoice entries; that is an XML invoice goes to an XML mapping module  21 . A XML mapping module  21  is the corresponding mapping module for a XML invoice. 
         [0040]    Multiple types of vendor invoice  19  information can be received, including EDI invoices using the EDI Mapping Module  20 , e.g., both  810  invoices and  811  invoices; XML invoices using the XML Mapping Module  21 , e.g., cXML; custom electronic invoices using the Custom Mapping Module  22  and traditional paper invoices using the Invoice Management Module  23 . The term automated input modules means the EDI mapping, XML and custom mapping modules. The Custom Mapping Module  22  offers the possibility for the user of the application to import other formats of files that contain invoices, such as XLS or DBF files. This module provides the user an interface to browse their computer or network for vendor invoice files that they want to import into the application. As the telecommunications invoice information is imported by these various modules, it is organized into comparable categories and is referred to as comparable telecommunication invoice information. 
         [0041]    EDI invoices are received via a traditional EDI delivery path, e.g., value added network (VAN). The file(s) are collected by the EDI Mapping Module  20  at designated times, e.g., on a daily, hourly, minute, or real-time basis. Upon receipt of the file(s), the EDI Mapping Module  20  performs a series of checks (see Table 1) on the invoice(s) contained in the individual EDI file(s). If an error is detected, action is taken in accordance with Table 1. After the invoice(s) are successfully entered into the User Database  3 , the Invoice Analyzer  24  audits the invoice(s). 
         [0042]    XML invoices are received via a traditional XML delivery path, e.g., HTTP or FTP. The file(s) are collected by the XML Mapping Module  21  at designated times, e.g., on a daily, hourly, minute, or real-time basis. Upon receipt of the file(s), the XML Mapping Module  21  performs a series of checks (see Table 1) on the invoice(s) contained in the individual XML file(s). If an error is detected, action is taken in accordance with Table 1. After the invoice(s)  19  are successfully entered into the User Database  3 , the Invoice Analyzer  24  audits the vendor invoice(s)  19 . 
         [0043]    Custom invoices are received via any electronic delivery method, e.g., Internet, CDROM, or floppy disc. The file(s) are collected by the “Custom Import” facility and entered into the Custom Mapping module  22  on a real-time basis. Upon receipt of the file(s), the Custom Mapping Module  22  performs a series of checks on the invoice(s) contained in the individual file(s). After the invoice(s) are successfully entered into the User Database  3 , the Invoice Analyzer  24  audits the vendor invoice(s)  19 . 
         [0044]    Paper invoices are received from a vendor via a traditional delivery path, e.g., first-class mail. Upon receipt, the user of the application manually enters the paper invoices into the application using the Invoice Management Module  23 . The term manual input module refers to a means to manually import types of telecommunication invoice information to user database  3 . After the vendor invoice(s)  19  are successfully entered into the User Database  3 , the Invoice Analyzer  24  audits the vendor invoice(s)  19 . 
         [0045]    The Invoice Management Module  23  is also used to view and edit the invoice after it has been input into the User Database  3 . The user can use this module to view the exceptions that have been found in the invoice and see descriptions for reason that the exception was generated. The user can see the details for all of the individual charges for each line item in the invoice. For example under local service, the user can see the various charges that comprise monthly service for a single phone line including the USOC code and the USOC description for each charge related to the monthly service charges. 
         [0046]    Each of the paper invoices and electronic invoices is stored as distinct records in the invoice table of the user database. The term types of means any of the above discussed invoice types that can be received from a vendor and imported into the user database  3 . Each record has an identifier that indicates the type of the invoice, e.g., paper or electronic. 
         [0047]    B. Means for Auditing the Comparable Telecommunication Invoices 
         [0048]    The term audit means to analyze individual charges at its smallest component, to verify its&#39; correctness, lack of irregularities. In this system, automated reasonability testing can be conducted on comparable telecommunication invoices. The Invoice Analyzer  24  retrieves each new invoice or edited invoice from the User Database  3  and performs an automated reasonability test. For new invoices, the Invoice Analyzer  24  evaluates each line item of the invoice for billing irregularities or “exceptions”, and assigns a flag along with a description based upon the analysis criteria that the application and user have established for the various types of service corresponding to the invoice. Types of invoice exceptions are found in Table 2. For edited invoices, the Invoice Analyzer  24  only evaluates the line item that was changed. In both cases, the Invoice Analyzer  24  is invoked by the component that is handling either the input or editing of the invoice, e.g. the various Mapping Modules  20 ,  21  and  22  or the Invoice Management Module  23 . 
         [0049]    All of the invoice line items and any exceptions that belong to the invoice are presented in the invoice grid of the Invoice Management Module  23 . 
         [0050]    C. Means for Approving the Comparable Telecommunication Invoices 
         [0051]    After the vendor invoice  19  is input into the User Database  3  and reviewed by the Invoice Analyzer  24 , a user must review and approve the comparable telecommunication invoice. The actual invoice detail can be displayed in the Invoice Management Module  23 . The invoice detail is broken down into its various types of service. All invoices have at least one service type, but can have any number of different types of service as well. For example, one invoice might contain only long distance bills and another invoice may contain long distance bills and another invoice may contain long distance, local, and frame bills. The invoice detail for each of the various service types looks slightly different due to the different type of charges that are associated with them. If any exceptions appear (designated as red in the grid), the user can click the “Exception details” to see the reason the item was marked as an exception. If the user agrees that the charges are valid and “clears” the exception, then the item&#39;s background color will be turned from red to yellow. The user may proceed to continue reviewing the invoice until all items are “cleared” or mark the various service types of the invoice as “reviewed” by clicking on the Review/Approve button. The only exception that must be resolved prior to designating an invoice as “reviewed” is the cost center exception. Each line item must be assigned to a currently active cost center prior to being reviewed or approved for payment. This is to ensure that all of the costs associated with the invoice are allocated properly. 
         [0052]    The user can also set bookmarks to certain rows in the grid (specific line items), which he may want to look at later. 
         [0053]    The status of the invoices that appear in the tree situated in the left region of the Invoice screen, where the invoices are grouped in two major categories: Approved and Pending Approval (see Table 3). 
         [0054]    D. Means for Processing the Comparable Telecommunication Invoices 
         [0055]    Both AP and GL refer to the final step in the process of invoices and either may be processed in the same or separate processes. AP and GL refer to distinct phases that occur after the invoices are approved. The system provides flexibility to allow users to approve an invoice for both AP and GL processing, just AP processing, or just GL processing. This flexibility allows users to pay an invoice and allocate costs, only pay the vendor and not allocate costs, or only allocate the costs and not pay the vendor respectively. 
         [0056]    The AP and GL refer to distinct operations that occur after the invoices are approved. The Custom Accounts Payable (AP) Interface Module  31  sends all approved invoices not yet sent to the User Accounting AP subsystem  32 . The User Accounting AP system  32  then creates the payment(s) for the vendor(s) using the information supplied through the AP file. It is possible for the AP system to also process the GL items as well or this can be processed with a separate GL system. 
         [0057]    The Custom General Ledger (GL) Interface Module  33  sends all approved invoices not yet sent to the User Accounting GL system  34 . The User Accounting GL system  34  then creates the necessary debits and credits using the information supplied through the GL file. 
         [0058]    The AP/GL process can be set to run at a predetermined time, hourly, daily, weekly, or monthly. This process consists of sending one or more files of a predetermined format such as XML, delimited, or flat file. The format for the AP and GL files and where the files are transmitted are stored in separate XML configuration files for the Custom AP Interface Module  31  and the Custom GL Interface Module  33 . 
         [0059]    The process of importing and auditing a plurality of types of telecommunication invoices is more specifically described in this section. 
         [0060]    The present invention uses various methods to import vendor invoices  19 . Vendor invoices  19  can come into the user application  5  via one of three methods. The first method is to receive the invoice on paper. Paper invoices are entered into the user application  5  through the Invoice Management Module  23 . The user selects the vendor from the current list of active vendors and then the types of services in the invoice. The line items and charges are then entered manually into the user application  5 . When the user saves the invoice, the invoice analyzer module  24  performs an audit on the invoice. 
         [0061]    The second method for receiving invoices is via XML or EDI. These invoices are sent to the user application  5  via email, FTP, HTTP, a VAN or any other transfer protocol. These invoices are collected in one common location that the user application  5  monitors. Typically, this is a local system file folder on the server. The user application  5  will monitor this directory for files in a real-time or batch mode. In the real-time mode, the user application  5  will automatically start the import procedure when a new file is received. In the batch mode, the user application  5  will wait until a specified time to monitor the common location for any new files. The user application  5  then analyzes the file or files to determine if it is an EDI file or an XML file. The user application  5  then branches to one of two modules dependent on the type of file. 
         [0062]    For EDI files, the user application  5  looks at the header of the tile to determine the vendor. If the vendor is unknown the user application  5  will send a 997 response file as specified in the EDI standard. If the vendor is known the user application  5  will extract the vendor specific mapping rules from the user database  3  and begin the importing process. Once the file is imported the user application  5  verifies the invoice total. If the total does not equal the sum of the charges at the line items, then the invoice is purged from the database and an error message is generated. When the import is complete, the invoice analyzer module  24  performs an audit on the invoice. After this, the process returns to waiting for more files or importing the next file in the common location. 
         [0063]    For XML files, the user application  5  looks at the header of the file to determine the vendor. If the vendor is unknown the user application  5  will generate an error message. If the vendor is known the user application  5  will extract the vendor specific mapping rules from the user database  3  and begin the import process. Once the file is imported the user application  5  verifies the invoice total. If the total does not equal the sum of the charges at the line items, then the invoice is purged from the user database  3  and an error message is generated. When the import is complete, the invoice analyzer module  24  performs an audit on the invoice. After this, the process returns to waiting for more files or importing the next file in the common location. 
         [0064]    The third method for receiving invoices is via custom electronic invoices. These invoices are sent in the vendor&#39;s specific billing format. These can be CDROMs from their own bill management systems, spreadsheets, etc. The user receives these invoices and then goes to the custom mapping module  22  and selects the vendor and the location for the invoice such as a floppy disc. CDROM, or local folder. The user application  5  then imports the invoices using algorithms hard coded for that type of file format and that vendor. Once the file is imported the user application  5  verifies the invoice total. If the total does not equal the sum of the charges at the line items, then the invoice is purged from the database and an error message is generated. When the user saves the invoice, the invoice analyzer module  24  performs an audit on the invoice. 
         [0065]    E. Means for Reporting Comparable Telecommunication Invoices 
         [0066]    The invention provides a large number and different types of reports, such as audit, custom and summary reports using the Report Module  27 . Several of the reports require the server to precalculate values so that the report can be viewed in a reasonable amount of time. This includes reports such as monthly, quarterly, and annual reports. The Pre-calculated Report Module  28  maintains these values as new information is added to the system. Various types of reports contemplated by this invention are shown in Table 4. 
         [0067]    The audit reports allow the user to view exceptions across a range of vendors, types of service, and dates. The custom reports allow the user to view all of the bill details across a range of vendors, types of service, and dates. 
         [0068]    The summary reports are comparable reports on invoices, vendors, cost centers, reoccurring invoices, accounts payable, general ledger, circuit mappings, system information (that will report information that is missing in the database and should be entered: for vendors, phone numbers, circuit ids etc) etc. 
         [0069]    F. Inputs Related to Processing 
         [0070]    The system provides for integration with other external systems such as the User&#39;s Human Resource (HR) System  40  and the User&#39;s Accounting System  41  by means of the Custom Accounts Payable (AP) Interface Module  31 , the Custom General Ledger (GL) Interface Module  33 , and the Custom HR Interface Module  35 . 
         [0071]    The Custom HR Interface Module  35  allows the system to import information relating to the user&#39;s cost centers. This information traditionally is found in the user&#39;s HR system but can be imported from any other system that provides this information. The most important piece of information regarding the cost center is whether it is active or inactive currently. In addition, cost center information such as the address, phone number, manager&#39;s name, number of full-time employees, etc. can be imported into the system. 
         [0072]    Each of these interface modules are configured using XML configuration files. The external systems receive and send information in a variety of file formats such as XML, delimited, or flat file formats. The file format and the format of the information transferred is specified in the XML configuration files. Each Interface Module has its own XML configuration file. This configuration file begins by identifying the format of the file such as XML, delimited, or flat file. If the format for the transmitted file is XML then the configuration file contains the tags used to identify the data elements in the file. If the formal for the transmitted file is delimited then the configuration file contains the delimiter and the order of the data elements in the file. If the format for the transmitted file is flat then the configuration file contains the order and length of the data elements in the file. 
       II. Application Module 
       [0073]    The Application Module  45  is the part of the system that allows a user to interact with the system such as to approve and view audited information. More specifically, various tools are provided to accomplish the function of the system. These tools include: 
         [0074]    A. Login 
         [0075]    The Application Module  45  is designed to allow users different access to processes and reports depending on their access rights. Therefore all users must have a valid login username and password to enter the system. This username and password does not have to but it can he authenticated with another external system using a protocol such as Lightweight Directory Access Protocol (LDAP). 
         [0076]    B. Common Toolbar 
         [0077]    The toolbar provides access to the various sections of the User application  4 . The toolbar is always available and provides navigation between the various sections. 
         [0078]    C. What&#39;s New 
         [0079]    The What&#39;s New screen provides every user with an interface to view the items in the system that relate to their access rights. It shows invoices that have been added and the date it was entered and a list of invoices pending approval in the system and a summary of invoice including the vendor name, types of service, invoice amount, number of exceptions, number of cleared exceptions, and the users that are assigned. The users “To Do” items are also displayed in the What&#39;s New page. 
         [0080]    D. Deleted Items 
         [0081]    The system offers a capability similar to the Recycle Bin (Windows) that means that specific key-items in the system are not purged from the system when a user performs the delete action. They appear as deleted but they can he viewed, restored or purged from the Deleted Items section. There is such a Deleted Items section that appears for Voice, Data and Equipment and also there is a Deleted Items section for the user that has administrator rights (Admin). The administrator is the only user authorized to purge or restore items from Recycle Bin. Other types of users may only view deleted items in the above-mentioned Deleted Items sections. 
         [0082]    E. Drafts 
         [0083]    The drafts section provides the means of storing draft information for key-items such as invoices, cost centers, vendors, phone numbers etc. This draft section provides a means for temporarily storing this information, before it is actually saved as valid information in the present system. 
         [0084]    F. To Do 
         [0085]    The to do section offers the users the capability to track tasks that are going to be made by a specific user. These tasks can be assigned to the user by another user of the system, tasks that the user assigned to himself, or tasks created by the system automatically. These tasks can he filtered by “All”, “Open” or “Closed”. 
         [0086]    G. Invoice Details 
         [0087]    The application module  45  allows a user to view specific invoice details such as: invoice comments, vendor remittance, invoice splits, approve/review invoice, edit invoice, split as previous, accrue invoice, view invoice trend, bill details or invoice exceptions. 
       IV. Technical Specifications 
       [0088]    A. General Hardware and Software Requirements: 
         [0089]    This software is web-based. The web pages are displayed using either Internet Explorer 5.0 or higher, or Netscape Communicator 4.73 or higher. Due to the volume of information being displayed on the user screens, the screens are designed to be viewed on 1280×1024 displays. 
         [0090]    One of the following server platforms can be used: Sun Solaris, MS Windows 2000 Server or Microsoft NT Server running iPlanet Web server Enterprise Edition Int.4.1 SP9 (or higher), Resin 2.1.4 (or higher), or Tomcat 3.2.1 (or higher). 
         [0091]    The application is database driven using Oracle 8i or 9i. The EDI extraction modules require that, regardless of the server platform, the SQL*Loader utility that comes bundled with Oracle 8i or 9i is installed. 
         [0092]    The application speed is primarily dependent on the performance of the server platform specifically the Oracle database. The web server and database can be on one machine or separate machines. Most of the application processing is done in Oracle in the database layer. Therefore, the more powerful the database server is, the quicker the response time will be for the users of the application. 
         [0093]    B. Recommended Hardware and Software requirements: 
         [0094]    For the User the hardware and software requirements are described in Tables 5 and 6. 
         [0095]    All of the invoice line items and any exceptions that belong to the invoice are presented in the invoice grid of the Invoice Management Module  23 . 
         [0096]    Although the foregoing invention has been described in some detail by way of illustration an example for purposes of clarity of understanding, it will be obvious that certain changes and modifications may be practiced within the scope of the appended claims. 
         [0000]    
       
         
               
             
               
             
           
               
                 TABLE 1 
               
               
                   
               
               
                 EDI or XML Exception Action 
               
               
                   
               
             
             
               
                   
               
             
          
           
               
                 (1) EDI or XML syntax error: 
               
               
                 Reject file - Transmit back an acknowledgment rejecting the received EDI 
               
               
                 or XML file. 
               
               
                 (2) Exception in the EDI or XML file: (a different amount between 
               
               
                 global invoice total and the calculated total) 
               
               
                 Reject file - Transmit back an acknowledgment rejecting the received EDI 
               
               
                 or XML file. 
               
               
                 (3) Missing vendor: 
               
               
                 Reject file - Transmit back an acknowledgment rejecting the received EDI 
               
               
                 or XML file. 
               
               
                 (4) Duplicate Invoice: (Invoice Number + Invoice Date + Vendor + 
               
               
                 Account Number) 
               
               
                 Reject file - Transmit back an acknowledgment rejecting the received EDI 
               
               
                 or XML file. 
               
               
                   
               
             
          
         
       
     
         [0000]    
       
         
               
             
               
               
             
           
               
                 TABLE 2 
               
               
                   
               
               
                 Types of Invoice Exceptions 
               
               
                   
               
             
             
               
                   
               
             
          
           
               
                 Calling Card 
                 Bill line item rate charges/minutes is not equal to the contracted 
               
               
                   
                 rate for this vendor. 
               
               
                   
                 Bill line items that have 0 minutes and charges. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Calling Card number that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Conference Call 
                 Cancellation Fee that is not equal to 0. 
               
               
                   
                 Telemanagement charges that are not 0 on the bills. 
               
               
                   
                 Bill line item rate charges/minutes is not equal to the contracted 
               
               
                   
                 rate for this vendor. 
               
               
                   
                 Bill line items that have 0 minutes and charges. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Local 
                 Itemized calls that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone number/Circuit ID that is designated to another vendor in 
               
               
                   
                 the system. 
               
               
                   
                 Phone number/Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Long Distance 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone number/Circuit ID that is designated to another vendor in 
               
               
                   
                 the system. 
               
               
                   
                 Phone number/Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 Pager 
                 Pager charges not equal to the contracted rates. 
               
               
                   
                 Excess Page Charges/Number of Excess pages are not equal to 0. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Pager number that is designated to another vendor in the system. 
               
               
                   
                 Pager number that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Protection charges that are not 0 on the bills. 
               
               
                 Toll Free 
                 Toll Free charges not equal to the contracted rates. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone number/Circuit ID that is designated to another vendor in 
               
               
                   
                 the system. 
               
               
                   
                 Phone number/Circuit ID that has no into in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 Wireless 
                 Billed minutes is greater or less than plan number of standard 
               
               
                   
                 minutes. 
               
               
                   
                 Monthly service charges not equal to the contracted rates. 
               
               
                   
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone number that is designated to another vendor in the system. 
               
               
                   
                 Phone number that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                   
                 Roaming Charges that are not equal to 0 for plans without 
               
               
                   
                 roaming. 
               
               
                   
                 LD Charges that are not equal to 0 for plans without LD. 
               
               
                 ATM 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system. 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                   
                 Port Charges that are not equal to the contracted rates. 
               
               
                   
                 Access Charges that are not equal to the contracted rates. 
               
               
                   
                 PVC Charges that are not equal to the contracted rates. 
               
               
                 Frame 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system. 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that arc not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                   
                 Port Charges that are not equal to the contracted rates. 
               
               
                   
                 Access Charges that are not equal to the contracted rates. 
               
               
                   
                 PVC Charges that are not equal to the contracted rates. 
               
               
                 Internet 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system. 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 ISDN 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone Number that is designated to another vendor in the system. 
               
               
                   
                 Phone Number that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that arc not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 Point To Point 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system. 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that arc not equal to 0. 
               
               
                 Security 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system. 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 VPN 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Circuit ID that is designated to another vendor in the system, 
               
               
                   
                 Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 Other 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Phone Number/Circuit ID that is designated to another vendor in 
               
               
                   
                 the system. 
               
               
                   
                 Phone Number/Circuit ID that has no info in the system. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Other charges that are not equal to 0. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                   
                 Equipment Charges that are not equal to 0. 
               
               
                 Equipment 
                 Percent change of the invoice line item compared to the invoice 
               
               
                 Maintenance 
                 line item from the previous invoice. 
               
               
                   
                 Invoice total is different for the Quote total. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Equipment Purchase 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Invoice total is different for the Quote total. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Equipment Repair 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Invoice total is different for the Quote total. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Late charges that are not equal to 0. 
               
               
                 Equipment Lease 
                 Percent change of the invoice line item compared to the invoice 
               
               
                   
                 line item from the previous invoice. 
               
               
                   
                 Invoice total is different for the Quote total. 
               
               
                   
                 Cost Center that is no longer active or in the system. 
               
               
                   
                 Late charges that are not equal to 0 
               
               
                   
               
             
          
         
       
     
         [0000]    
       
         
               
               
               
             
           
               
                 TABLE 3 
               
               
                   
               
               
                   
                   
                 Grid (left region 
               
               
                 Type of Status 
                 Color 
                 of the screen) 
               
               
                   
               
             
             
               
                 Approved/Normal Invoices 
                 None 
                 Approved Invoices 
               
               
                 Needs to he Reviewed, has no exceptions 
                 None 
                 Pending Approval 
               
               
                 Needs to be Reviewed, has exceptions 
                 Red 
                 Pending Approval 
               
               
                 Reviewed, waiting to be sent to AP/GL 
                 Green 
                 Pending Approval 
               
               
                 by the AP/GL process that is integrated 
               
               
                 in the application 
               
               
                   
               
             
          
         
       
     
         [0000]    
       
         
               
               
             
           
               
                 TABLE 4 
               
               
                   
               
               
                 Report type 
                 Description 
               
               
                   
               
             
             
               
                 Audit Reports 
                 There is implemented one audit report for each type 
               
               
                   
                 of service type. The audit reports are grouped under 
               
               
                   
                 3 major categories: Voice, Data and Equipment. For 
               
               
                   
                 each major type and for each service type, there is a 
               
               
                   
                 set of audit (exception) criteria, from which the user 
               
               
                   
                 can choose in order to see a report. 
               
               
                 Custom Reports: 
                 The following reports are available: 
               
               
                   
                 Standard (multiple services) custom report 
               
               
                   
                 Data Fixed or has Direct Billing custom report 
               
               
                   
                 Invoice Approved, waiting to be sent to 
               
               
                   
                 Accounting custom report 
               
               
                   
                 Fixed Allocation Charges Report 
               
               
                   
                 Full-time Employee (FTE) Report 
               
               
                   
                 Physical inventory custom report 
               
               
                 Summary Reports: 
                 The following reports are available: 
               
               
                 All Services 
                 Disconnect 
               
               
                   
                 Invoice 
               
               
                   
                 Invoice Not Received 
               
               
                   
                 Service Type 
               
               
                   
                 Cost Center 
               
               
                   
                 GL 
               
               
                   
                 Total Telecom Expense 
               
               
                   
                 Vendor 
               
               
                 Summary Reports: 
                 The following reports are available: 
               
               
                 Data 
                 Summary 
               
               
                   
                 Frame/ATM 
               
               
                   
                 PVC 
               
               
                   
                 Circuit 
               
               
                 Summary Reports: 
                 The following reports are available: 
               
               
                 Equipment 
                 Maintenance 
               
               
                   
                 Purchase 
               
               
                 Summary Reports: 
                 The following reports are available: 
               
               
                 System 
                 Cost Centers 
               
               
                   
                 Vendors 
               
               
                   
                 Phone 
               
               
                   
                 Circuit ID 
               
               
                   
               
             
          
         
       
     
         [0000]    
       
         
               
               
             
           
               
                   
                 TABLE 5 
               
               
                   
                   
               
             
             
               
                   
                 Processor: minimum Intel Celeron 433 MHz or equivalent. 
               
               
                   
                 OS: Windows 95, 98, NT, 2000, or XP computers. 
               
               
                   
                 Memory: 64 MB of RAM. 
               
               
                   
                 Hard Drive: sufficient capacity for OS and browser. 
               
               
                   
                 Browser: IE 5.0+ or Netscape 4.73+ 
               
               
                   
                 Display: minimum of 17″ monitor capable of 1280 × 1024, 
               
               
                   
                 19″ monitor is recommended. 
               
               
                   
                 Video Adapter: minimum of 8 MB of RAM capable of 
               
               
                   
                 supporting 1280 × 1024 resolution. 
               
               
                   
                   
               
             
          
         
       
     
         [0000]    
       
         
               
               
             
           
               
                   
                 TABLE 6 
               
               
                   
                   
               
             
             
               
                   
                 Server (option 1) 
               
               
                   
                 Processor: minimum Intel Pentium III 600 MHz 
               
               
                   
                 OS: Windows NT 4.0 SP6a or Windows 2000 SP2 
               
               
                   
                 Memory: minimum of 512 MB of RAM 
               
               
                   
                 Hard Drive: 9.0 GB SCSI2 
               
               
                   
                 Software: Oracle 8i or 9i w/SQL*Loader, iPlanet Web Server 
               
               
                   
                 Enterprise 4.1 SP9+ (optional Resin 2.1.4+, Tomcat 3.2.1+ or 
               
               
                   
                 IIS w/Resin or Tomcat as the JSP engine) 
               
               
                   
                 Server (option 2) 
               
               
                   
                 Processors: minimum Dual 300-MHz UltraSPARC-II CPUs 
               
               
                   
                 OS: Solaris 8 or higher 
               
               
                   
                 Memory: minimum of 512 MB of RAM 
               
               
                   
                 Hard Drive: 36 GB SC SI2 
               
               
                   
                 Software: Oracle 8i or 9i w/SQL*Loader, iPlanet Web Server 
               
               
                   
                 Enterprise 4.1 SP9+ (optional Resin 2.1.4+ or Tomcat 3.2.1+)