Patent application number | Description | Published |
20130073437 | PREVIEWING PROJECTED BALANCE IMPACTS - A method of previewing projected balance impacts in an Enterprise Financial Accounting System is presented. The method may include receiving journal entries that have not been posted to an accounting ledger; displaying the journal entries in a journal portlet; receiving a selection of a first journal entry with a first amount; determining a first ledger that is associated with the first amount; receiving a start date and a beginning balance of the first ledger on the start date; receiving an activity total including a sum of journal entries posted to the first ledger between the start date and a current date; determining a projected balance representing a combination of the beginning balance, the activity total, and the first amount; and displaying a projected balances portlet together with the journal portlet, that includes the beginning balance, the activity total, the first amount, and the projected balance. | 03-21-2013 |
20130073438 | EFFICIENT DETECTION AND ANALYSIS OF VARIANCES - A method of detecting variances in a plurality of accounts from different organizations within an Enterprise Financial Accounting system includes receiving a selection of a first account with an account type; receiving a selection of a first time interval and a second time interval; determining a first amount that is associated with the first account during the first time interval; determining a second amount that is associated with the first account during the second time interval; receiving a selection of a comparison operator that relates the first amount to the second amount; receiving a selection of a threshold; determining a comparison value by comparing the first amount to the second amount according to the comparison operator; determining that the comparison value violates the threshold according to the comparison operator; and displaying a first indication in a portal comprised of the first amount, the second amount, and the comparison value. | 03-21-2013 |
20130080299 | ALLOCATION MANAGER - A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario. | 03-28-2013 |
20130080300 | TRANSFER FORMULAS - A method of using a formula to execute periodic transfers in a hierarchal accounting structure includes receiving a transfer formula that may comprise a source account, a target account, an offset account, an account characteristic, and a formula for determining a first amount of the source account based on the account characteristic. The method may also include accessing a multidimensional data cube with a hierarchal arrangement and aggregated balances for each level. The method may additionally include generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula, and generating one or more accounting journal entries corresponding to the transfer scenario. The method may further include posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating the multidimensional data cube to reflect the transfer scenario. | 03-28-2013 |
20130080301 | ONE-STEP POSTING FOR APPROVAL-BASED LEDGER TRANSACTIONS - Various arrangements for posting a journal entry to a ledger are presented. The journal entry that comprises financial information related to a credit or debit from an account may be received. A request to post the journal entry to the ledger may be received. The journal entry may be determined to be subject to an approval process at least based on the ledger. At least one entity that is required to approve the journal entry as part of the approval process may be identified. An approval from the at least one entity may be received. After receiving approval, the journal entry may be posted to the ledger such that the ledger indicates the credit or debit of the journal entry. Posting of the journal entry to the ledger may require no input from the user following receiving the request to post the journal entry to the ledger. | 03-28-2013 |
20140222632 | DATA TRANSACTION ACCELERATION USING MULTIPLE DATA STRUCTURE TYPES - A method of accelerating execution of a transactions includes storing financial ledgers in a relational database, prepopulating a multidimensional data cube using the relational database, executing the transactions using the data cube by querying the data cube for aggregated balances to generate result values, generating accounting journal entries that update each account in the ledgers affected by the transactions using the result values from the data cube, posting the accounting journal entries to the financial ledgers in the relational database, repopulating the data cube with the changes resulting from the posted journal entries, and updating the aggregated balances of the data cube. | 08-07-2014 |
Patent application number | Description | Published |
20100318572 | FUSION GENERAL LEDGER - A database system combines a general ledger and a multi-dimensional database. The general ledger and multi-dimensional database are mapped such that relationships between the general ledger and multi-dimensional database are characterized with metadata dimensions. Using the mapping, data can be received into the general ledger and stored in both the general ledger and multi-dimensional database substantially simultaneously. Further, a synchronization of the data copies changes to the data automatically from the general ledger to the multi-dimensional database. Thus, there is no manual copying of data between the general ledger and the database. Further, the latency between the general ledger and database is minimal ensuring accurate analysis even contemporaneous with the input of the data. | 12-16-2010 |
20130073436 | DATA PORTAL FOR CONCURRENT ASSESSMENT - A method of concurrently assessing a closure status for multiple ledgers may comprise accessing a general ledger and a plurality of subledgers including a first subledger and a second subledger, having first and second close periods, respectively. The method may also include translating the second subledger such that the second subledger has the first close period, and determining a closure status for each subledger over the first period. The method may additionally include determining a status for the general ledger indicating a closure status over the first period, and concurrently displaying an indication for each of the plurality of subledgers and the general ledger. The method may further include displaying the status of each of the plurality of subledgers next to the indication for each, and displaying the status of the general ledger next to the indication for the general ledger. | 03-21-2013 |
20130073520 | MECHANISM FOR UPDATING OLAP SYSTEM STRUCTURE AND OLTP SYSTEM STRUCTURE STRUCTURE - In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created. | 03-21-2013 |
20130073521 | MECHANISM FOR SYNCHRONIZING OLAP SYSTEM STRUCTURE AND OLTP SYSTEM STRUCTURE - In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created. | 03-21-2013 |