Patent Application
20070005559
Enterprise resource planning (or ERP) is a phrase used to describe a broad set of activities supported by multi-module application software that helps a company manage the important parts of its business. Computerized ERP systems typically handle the logistics of various activity modules internal to a business or organization, such as accounting/financial management, customer relations management, supply chain management and human resource management. Often, an ERP system uses or is integrated with a relational database system. Examples of ERP system software packages include Microsoft® Business Solutions Axapta®, Navision® and Great Plains®.
ERP systems utilize a large number of files that are part of a collection of information that is stored in a database shared by the various management application modules. These files represent widely varying types of information, for example including information related to transactions such as sales, purchase orders and bill payments and information related to reference data, such as currencies, exchange rates, and customer profiles, as well as ledgers and other accounting tables.
There are a large number of events in which users create a new instance of a transaction in the course of conducting daily business activities. For example, creating new purchase orders, invoices and expense reports. To create a new instance of a transaction, the user opens a data entry screen and enters new data into the data entry screen.
When the data entry screen is initially displayed to the user, it is common practice for initial default data to be entered into some of the data fields after data is entered into a controlling data field of the data entry screen. For example, when an order entry clerk enters a new order from a customer, and after a customer number is entered in a controlling field, the data entry screen can display default data such as billing address, shipping address, method of payment, method of shipment and other fixed data associated with the manually entered customer number.
In general, ERP systems often limit the user to a predefined list of data stored in the commonly shared database that can be used as criteria data for defaults. By limiting the user to a predefined list, many times default data that is automatically inserted into a transaction is the wrong data. In the example above, the order entry clerk is limited to the criterion of a customer number.
Upon entering the customer number, all the default data is automatically inserted. However, for this particular customer, the item being ordered needs special pricing. The order entry clerk must then go in and manually change the customer/item pricing. Such manual data entry and manual data selection are time-consuming, costly and prone to errors.
This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description.
This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
Criteria for use in defaulting data in a transaction for an ERP system can be defined using several steps. The data entities that are available in the ERP system are provided. Then, a select number of data entities are selected from the provided data entities based on a user input. The select number of data entities are available as criteria for defaulting data in transactions.
An ERP system includes a database. The database includes a plurality of data entities selectable by a user. The data entities selected by the user include default data entities. The ERP system also includes a defaulting system. The defaulting system is configured to access the plurality of default data entities to develop default rules for populating default fields in a transaction.
The following description is described in the context of an Enterprise Resource Planning (ERP) system. Processes in the ERP system are performed in the form of transactions or documents. A transaction can be defined as an event or conduction of business that occurs between two parties, such as between a customer and a supplier. A transaction can also be an event that occurs internal to the accounting system, such as adjustments to a general ledger or depreciation. For example, a transaction can be entered in a data entry form and recorded on a document to include data describing the event and data describing how a particular transaction should behave. Before describing aspects of the illustrated embodiments, however, it may be useful to describe suitable computing environments that can incorporate and benefit from these aspects. ERP systems are typically implemented in a networked environment of server computers and/or other computers. The computing environment shown in
The illustrated embodiments are operational with numerous other general purpose or special purpose computing system environments or configurations. Examples of well-known computing systems, environments, and/or configurations that may be suitable for use with the illustrated embodiments include, but are not limited to, personal computers, server computers, hand-held or laptop devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, telephony systems, distributed computing environments that include any of the above systems or devices, and the like.
The illustrated embodiments may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The illustrated embodiments may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communication network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices. Tasks performed by the programs and modules are described below and with the aid of figures. Those skilled in the art can implement the description and figures provided herein as processor executable instructions, which can be written on any form of a computer readable medium.
With reference to
Computer 110 typically includes a variety of computer readable media. Computer readable media can be any available media that can be accessed by computer 110 and includes both volatile and nonvolatile media, removable and non-removable media. By way of example, and not limitation, computer readable media may comprise computer storage media and communication media. Computer storage media includes both volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can be accessed by computer 110. Communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media. The term “modulated data signal” means a signal that has one or more of its characteristics set or changed in such a manner as to encode information in the signal. By way of example, and not limitation, communication media includes wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, RF, infrared and other wireless media. Combinations of any of the above should also be included within the scope of computer readable media.
The system memory 130 includes computer storage media in the form of volatile and/or nonvolatile memory such as read only memory (ROM) 131 and random access memory (RAM) 132. A basic input/output system 133 (BIOS), containing the basic routines that help to transfer information between elements within computer 110, such as during start-up, is typically stored in ROM 131. RAM 132 typically contains data and/or program modules that are immediately accessible to and/or presently being operated on by processing unit 120. By way of example, and not limitation,
The computer 110 may also include other removable/non-removable volatile/nonvolatile computer storage media. By way of example only,
The drives and their associated computer storage media discussed above and illustrated in
A user may enter commands and information into the computer 110 through input devices such as a keyboard 162, a microphone 163, and a pointing device 161, such as a mouse, trackball or touch pad. Other input devices (not shown) may include a joystick, game pad, satellite dish, scanner, or the like. These and other input devices are often connected to the processing unit 120 through a user input interface 160 that is coupled to the system bus, but may be connected by other interface and bus structures, such as a parallel port, game port or a universal serial bus (USB). A monitor 191 or other type of display device is also connected to the system bus 121 via an interface, such as a video interface 190. In addition to the monitor, computers may also include other peripheral output devices such as speakers 197 and printer 196, which may be connected through an output peripheral interface 195.
The computer 110 is operated in a networked environment using logical connections to one or more remote computers, such as a remote computer 180. The remote computer 180 may be a personal computer, a hand-held device, a server, a router, a network PC, a peer device or other common network node, and typically includes many or all of the elements described above relative to the computer 110. The logical connections depicted in
When used in a LAN networking environment, the computer 110 is connected to the LAN 171 through a network interface or adapter 170. When used in a WAN networking environment, the computer 110 typically includes a modem 172 or other means for establishing communications over the WAN 173, such as the Internet. The modem 172, which may be internal or external, may be connected to the system bus 121 via the user input interface 160, or other appropriate mechanism. In a networked environment, program modules depicted relative to the computer 110, or portions thereof, may be stored in the remote memory storage device. By way of example, and not limitation,
ERP systems commonly use entity relationship databases for modeling data, such as entity relationship databases that use UML (unified modeling language). An entity is a relational database data structure which manages data. The entity preserves its internal data and the integrity of its relationship with other entities. In the ERP system that corresponds with the illustrated embodiments, entities are commonly referred to as data entities.
Business management application 202 also includes a processing unit 213. Processing unit 213 is configured to receive an input from a user. Processing unit 213 is also configured to communicate with both database 204 and defaulting system 206. Information in database 204 is made available to a user. In turn, processing unit 213 allows a user to select data from the available information in database 204. In one embodiment, information is made available to a user by displaying the information on a display screen.
Referring back to
The data entities of accounts, dimensions, dimension codes, users, customers, territories, items, sites suppliers, currencies and exchange rates are reference data type entities. The data entities of general journal transactions, accounts receivable sales transactions, accounts payable transactions, cash receipt transactions and payment transactions are transaction type entities. Many of the above data entities are those entities that are system data entities. However, some of the above data entities are third party data entities. For example, the data entity titled users is a third party data entity that a third party has made available to a user for selection.
At block 504, a select number of data entities are selected from the plurality of data entities based on a user input that meet the defined criteria for use as default data entities. In general, the user selects which of the available data entities they would like to select or customize as criteria for defaulting data in transactions. The criteria the user selects depends on many different factors. However, in general, the user desires to select criteria that provides better usability in defining default rules 220 in defaulting system 206 and also coincides with the user's business needs. For example, a user may select the following data entities for use in defaulting data:
These select number of data entities are selected for use in defaulting data and are collectively called default data entities 226. Default data entities 226 contain a much more manageable list of criteria for developing default rules 220 in defaulting system 206. In addition, when developing default rules 220 using the default data entities 226, a user will not mistakenly select a data entity that is invalid for use in defaulting data.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.
