Method and system of synchronizing accounting objects between a client and server
First Claim
1. A method for use on a server of synchronizing data between a client accounting database on a client computer and the server accounting database on the server, the client computer and server being connected over a communication network by a connection, each of the client accounting database and server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database and server accounting database, the method comprising:
- detecting one or more records in the server accounting database which have changed since a previous synchronization;
identifying one or more accounting objects to be synchronized in accordance with the one or more changed records; and
sending instructions to the client computer to synchronize the one or more accounting objects defined by the one or more changed records in the server accounting database with the client accounting database, wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized;
wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules;
wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects;
wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system of synchronizing accounting objects between a client and server are provided. In accordance with one embodiment, there is provided a method for use on a server of synchronizing data between a client accounting database on a client computer and the server accounting database on the server, the client computer and server being connected over a communication network by a persistent connection, each of the client accounting database and server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database and server accounting database.
6 Citations
19 Claims
-
1. A method for use on a server of synchronizing data between a client accounting database on a client computer and the server accounting database on the server, the client computer and server being connected over a communication network by a connection, each of the client accounting database and server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database and server accounting database, the method comprising:
-
detecting one or more records in the server accounting database which have changed since a previous synchronization; identifying one or more accounting objects to be synchronized in accordance with the one or more changed records; and sending instructions to the client computer to synchronize the one or more accounting objects defined by the one or more changed records in the server accounting database with the client accounting database, wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized; wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules; wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects; wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A server, comprising:
-
a controller; a communication subsystem connected to the controller for communicating over a communication network; a server accounting database comprising a number of tables connected to the controller, wherein accounting objects are defined by a group of one or more related records in one or more tables in the server accounting database; wherein the controller is configured for;
causing communication with a client computer over the communication network over a connection, wherein the client computer has a client accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database;wherein the controller is further configured for;
detecting one or more records in the server accounting database which have changed since a previous synchronization;
identifying one or more accounting objects to be synchronized in accordance with the one or more changed records; and
sending instructions to the client computer to synchronize the one or more accounting objects defined by the one or more changed records in the server accounting database with the client accounting database, wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized;wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules; wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects; wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable.
-
-
11. A method of synchronizing data between a client accounting database on the client computer and a server accounting database on a server, the client computer and server being connected over a communication network by a connection, each of the client accounting database and server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database and server accounting database, the method comprising:
-
identifying one or more accounting objects to be synchronized in accordance with any changed records in the client accounting database, server accounting database, or both; sending instructions to the client computer to synchronize one or more accounting objects defined by any changed records in the server accounting database with the client accounting database; and sending instructions to the server to synchronize one or more accounting objects defined by any changed records in the client accounting database with the server accounting database; wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized; wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules; wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects; wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A client computer, comprising:
-
a controller; a communication subsystem connected to the controller for communicating over a communication network; a client accounting database comprising a number of tables connected to the controller, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database; wherein the controller is configured for;
causing communication with a server over the communication network over a connection, wherein the server has a server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the server accounting database;wherein the controller is configured for;
synchronizing, in response to receiving instructions from the server, the one or more changed records with the client accounting database, wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized;wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules; wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects; wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable. - View Dependent Claims (18)
-
-
19. A method for use on a client computer of synchronizing data between a client accounting database on the client computer and a server accounting database on a server, the client computer and server being connected over a communication network by a connection, each of the client accounting database and server accounting database comprising a number of tables, wherein accounting objects are defined by a group of one or more related records in one or more tables in the client accounting database and server accounting database, the method comprising:
-
detecting one or more records in the client accounting database which have changed since a previous synchronization; identifying one or more accounting objects to be synchronized in accordance with the one or more changed records; and sending instructions to the server to synchronize the one or more accounting objects defined by the one or more changed records in the client accounting database with the server accounting database, wherein the one or more accounting objects are synchronized in accordance with a synching order defining an order in which accounting objects are synchronized; wherein the synching order is determined in accordance with predetermined dependencies between records in the tables and predetermined business accounting logic rules; wherein the accounting objects each belong to one of a number of predetermined categories, wherein the synching order defines an order in which the categories of accounting objects are synchronized so that accounting objects defined by the one or more changed records in the one or more tables are synchronized in accordance with a category of the respective accounting objects; wherein the categories of accounting objects are synchronized in the following order;
(1) independent list objects;
(2) dependent list objects;
(3) transaction objects which do not affect Accounts Receivable or Accounts Payable;
(4) transaction objects that debit Accounts Receivable;
(5) transactions objects that credit Accounts Receivable;
(6) transactions objects that credit Accounts Payable; and
(7) transactions objects that debit Accounts Payable.
-
Specification