OFFLINE STOCK AUTHORIZATION AND RECONCILIATION SYSTEM

Abstract

This invention relates to a system (1) that enables stock transactions to be carried out offline in the absence of connection, to be executed within the scope of the defined transaction authorizations, and to verify the stock transactions carried out when the connection is restored and reconcile them with the central stock records.

Description

1 TARIFF OFFLINE STOCK AUTHORIZATION AND RECONCILIATION SYSTEM Technical Area This invention enables the centralized operation of a network where data communication is completely or partially interrupted. Stock operations without requiring constant connection to the inventory system. and after the connection is re-established transactions performed in a manner consistent with the central inventory system It relates to an inventory management system that facilitates reconciliation. 10 Previous Technique Today, inventory management systems use a central inventory server. Stock entry, stock 15 through connected warehouse, field and mobile processing devices. performing inventory operations such as stock transfer, counting and similar processes. This is provided. However, in cases where the connection to the central system is interrupted, some In systems, inventory transactions are recorded locally on the end device and After the connection is re-established, these records are transferred to the central system. Offline operation and subsequent synchronization methods in the form of transfer 20 is used. In some solutions in the known state of the art, such problems, After the connection is re-established, the data will be synchronized with the central system. and resolving emerging data discrepancies through conflict resolution mechanisms. This is addressed through this method. However, in this approach, the right to act on the stock... This right must be distributed before the connection is interrupted and during the connection interruption, and the difference is 25. Instead of enabling its use without duplication across devices, the resulting The comparison of these processes is based on a later analysis. Therefore, the current considering the studies and shortcomings in the technology when kept in place, it reliably reconciles with the central inventory system. It is understood that the system is needed. 30 2 United States Regulation US11727350B2, which is included in the known state of the art. a system and method for service and inventory management in the patent document It is explained that in this system, mobile computers and a central system are used. Inventory movements carried out in the absence of communication between them after being kept on the mobile computer and communication is re-established, these 5 The transactions are transferred to a central database. However, the aforementioned The document specifies the upper and lower transaction authorizations created through the central inventory. the distribution of protected permissions and the sum of sub-process permissions A transaction authorization system based on the principle of preventing exceeding superior transaction authority. tree structure and unfinished operation from the previous synchronization period 10 late-term locked reserves preventing the redistribution of rights in the new period Its structure is also not explained. Brief Description of the Invention The purpose of this invention is to enable data communication to be completely or partially interrupted in network conditions where, multiple edge processing devices performing operations on the same inventory enabling offline inventory management and the aforementioned transactions will be consistent with the central inventory once the connection is re-established. The goal is to create a system that facilitates reconciliation. 20 Another objective of this invention is to ensure that every inventory operation performed on end processing devices... exhaustion of the relevant transaction authorization and recording of the transaction in the event log In this way, inventory transactions performed when the connection is re-established are both The purpose is to ensure transaction authorization is verified through both the family tree and event records. 25 Detailed Description of the Invention The "Offline Stock" project was carried out to achieve the purpose of this invention. The "Authorization and Conciliation System" is shown in the attached document; this document is numbered 30. 3 Figure 1. Schematic view of the system described in the invention. The parts shown in the figure are individually numbered, and the corresponding numbers correspond to these numbers. given below: 1. System 2. Central inventory server 3. Local server (Hub) that can operate offline 4. End processing device 5. Transaction authorization family tree 10 6. Event Log 7. Late-stage locked reserve 8. Mediation module This invention enables the central 15 network to operate under network conditions where data communication is completely or partially interrupted. Stock operations without requiring constant connection to the inventory system. and after the connection is re-established transactions performed in a manner consistent with the central inventory system The system that enables the reconciliation of the invention (1); - Creating transaction authorizations based on verified stock information and the 20 created at least one central inventory configured to delegate transaction authorizations server (2), − within the scope of the transaction authorization received from the central inventory server (2), the word to create sub-operation authorizations in such a way that the subject matter does not exceed the total authorization amount and At least one 25 configured to transfer the created sub-process permissions Local server (Hub) (3) that can operate offline, - the authority assigned to him in case the connection is not found to carry out inventory transactions within this scope, for each transaction performed configured to create a transaction log and exhaust the associated transaction authorization. at least one end processing device (4), 30 4 − local that can work offline starting from the central inventory server (2) Which superiors are responsible for the processing authorizations transferred to the server (3) and end processing devices (4) to track how it derives from authority and into which sub-authorities it is divided At least one configured transaction authorization family tree (5), - Stock operations performed on end processing devices (4) in order of operation 5 at least one event log configured to record (6), − The old period that was not finalized during the transition to the new synchronization period to prevent the redistribution of transaction authorizations at least one late period locked reserve (7) configured to be kept locked. and 10 − transaction authorization together with the records found in the family tree (5) and the incident log (6) by evaluating the valid stock transactions with the central inventory server (2) at least one reconciliation module (8) structured to ensure reconciliation It includes. In the system that is the subject of the invention, the central inventory server (2) located in (1), central offline using verified stock information retrieved from the inventory system. transaction authorizations related to inventory operations to be carried out in the environment It is configured to enable its creation. Central inventory server (2) to obtain stock quantity, product, warehouse, location, lot and serial number information and to say 20 The subject matter is to ensure that the scope of the transaction authorization to be created is determined. It is structured in such a way. The central inventory server (2) has the authority to process, a specific to be associated with the operations that can be performed on the stock and created to ensure that the processing authority is transferred to a local server (3) that can operate offline It is structured as follows: central inventory server (2), offline 25 the transaction right that can be used for inventory operations to be carried out in the environment to ensure it is based on verified central inventory information It is configured. The central inventory server (2) creates the transaction authorization, transaction authorization, authorization ID, superior authorization ID, synchronization period, authorizer, 30 will include authorization scope, remaining authorization amount or serial number and version information. and active, consumed, transfer pending, late-stage locked, quarantined, or closed. It is structured to be kept in one of the situations. Central inventory server (2), process to be reallocated in the new synchronization period When determining its authority, active transaction authorizations, late period locked reserve (7) and to take into account incomplete transactions or transfers It is being structured. 5 The offline local server (3) in the system in question (1) is central transferring the processing authorization received from the inventory server (2) to the end processing devices (4) and is structured to allocate permissions to sub-processes. Capable of working offline. The local server (3) assigns to itself the total scope of the sub-process authorizations it creates 10 It is configured to limit the transferred transaction authorization. Offline the processing privileges distributed to the working local server (3) end processing devices (4) the total of the top process created by the central inventory server (2) It is configured to ensure it does not exceed its authority. It can operate offline. The local server (3) assigns all of the processing authority transferred to it to a single end process 15 to assign the said processing authority to more than one end processing device (4) (4) It is structured to allocate sub-process authorizations for distribution. The local server (3) that can operate offline has the authority of each sub-process connected as a resource. to be within the scope of the superior processing authority and the same central stock If the user is able to exercise the transaction authorizations related to the source, the total number of transactions distributed is 20. It is structured to prevent its authority from exceeding its superior authority. The end processing device (4) in the system of the invention (1) is a local device that can operate offline. stock within the scope of the transaction authorizations allocated to them by the server (3) It is configured to perform its operations. The end processing device (4), data 25 even in the absence of communication, they retain their assigned transaction authorizations. Within its scope, it includes stock entry, stock exit, stock transfer, and serial or lot information. It is configured to perform related inventory operations. End processing device (4), in stock transactions performed via barcode, RFID or manual entry It is configured to receive transaction data. The end processing device (4), 30 For each inventory transaction they perform, they record the transaction time, device ID, and the device used. 6 transaction authorization, used transaction rights and related transaction information It is configured to create the record. The end processing device (4) performs To exhaust the portion of the transaction authorization used in relation to the inventory transaction, If the connection is not available, the records relating to the processing will be stored on your own local data storage. to maintain in these areas and stock levels during connection interruptions 5 their operations on end processing devices until the connection is re-established. It is structured to ensure its protection. The end processing device (4) processes the stock. Before execution, the synchronization period, owner, version, and authorization of the transaction must be checked. checking the scope and the remaining amount of transaction authorization or serial scope It is configured not to perform operations exceeding the limit. . End processing device (4) 10 Which transaction authorization applies to offline inventory transactions? determining that it is based on and a subordinate action derived from a higher-level authority to check that the total scope of their authority does not exceed the relevant superior authority. It is structured to ensure that it is done The transaction authorization family tree (5), central inventory included in the system (1) of which the invention is located with the transaction authorization created by the server (2) and from this transaction authorization Sub-devices created for local servers (3) and end processing devices (4) that can operate offline It is structured to track the relationships between transaction authorizations. Transaction 20 authority family tree (5), from which higher authority a transaction authority is derived and which sub-authorizations were created from the said authorization It is structured to determine the transaction authority family tree (5), central inventory Starting from the transaction authorization created by the server (2), offline Sub-process privileges created by the working local server (3) and end process 25 maintain the authorization relationship up to the transaction authorizations allocated to the device (4) It is structured to do so. The event log (6) in the system (1) is recorded by the end processing device (4) 30 recording the stock transactions performed according to the transaction order. It is structured to provide. Event log (6), stock performed. 7 Transaction time, device ID, consumed transaction authorization, event sequence related to the transactions. maintains records containing information about the number and synchronization period. It is structured to do so. The event log (6) records information for each stock transaction. The record determines the position of the performed action within the sequence of events. It is configured to keep records in a way that will allow it to function properly. Event log 5 (6), stock carried out by end processing devices (4) during connection interruption This allows the processes to be evaluated after the connection is re-established. It is structured to provide. The records in the event log (6), The relevant transaction authorization is evaluated together with its source and consumption. The relationship of the inventory transaction to previously performed transactions and the transaction sequence 10 It is configured to keep records. The late-stage locked reserve (7) in the system (1) of the invention is a synchronization unfinished old period transactions during the transition from one period to another The authorization to perform transactions that can be reused in the new synchronization period is 15. It is structured to prevent it from being considered as such. Late-stage lock-in. reserve (7) has not yet been sent to the central inventory server (2) due to connection interruption. undelivered transaction records or transaction authorizations that have not yet been finalized the rights relating to the previous synchronization period being kept separate It is structured to provide. Late period locked reserve (7), new 20 During the synchronization period, the transaction permissions from the previous period will be reinstated. to prevent distribution and on a disconnected end processing device (4) or located on the local server (3) which can operate offline and is not yet finalized the old transaction authorization to another end transaction in the new synchronization period It is configured to prevent the device (4) from being reassigned. 25 Late period locked reserve (7), transaction delayed from the old period in the evaluation of the records with the relevant previous period transaction authorizations It is structured to be associated with something. The reconciliation module (8) in the system (1) which is the subject of the invention, the connection is re-established 30 After the end processing devices (4) and the local server that can operate offline are provided, 8 Stock transaction records created by (3), relevant transaction authorizations, transaction authorization To evaluate together with the family tree (5) and event log (6), the transaction authorization its validity, whether the stock transaction is carried out within the scope of the relevant transaction authorization. check that it was not performed and that the transaction record is consistent with the event log (6). It is structured to do so. The reconciliation module (8) has transaction authorization and stock 5 the necessary compatibility between the transactions and the scope of transaction authorization If it does not exceed the valid transactions, the stock in the central inventory server (2) reconcile with records, authorization family tree (5), event log (6), stock operation and if there is a discrepancy between the transaction authorization, the relevant transaction will be verified. To prevent direct application to the stock record and for the purpose of verifying the transaction, 10 It is structured to be evaluated separately. The conciliation module (8), Current stock delivered with a delay from the previous synchronization period. with the transaction authorization included in the relevant late period locked reserve (7) reconcile stock records in the central inventory server (2) by associating them It is structured in such a way. The reconciliation module (8) handles multiple instances of the same transaction record. To prevent it from being applied again, the process is repeated via the unique event ID. It is configured to perform replay / idempotency control. The reconciliation module (8) addresses unverifiable issues or issues between transaction authorization and event log. Verification is being carried out by quarantining stock transaction records that contain discrepancies. to prevent its application to the central inventory record until it is completed 20 It is being structured. 30 9 Industrial Application of the Invention Thanks to the system (1) that is the subject of the invention, end processing devices (4) in case of connection interruptions Performing inventory transactions offline, 5 of the transactions performed limiting transaction authorizations to predefined limits, subordinate transaction authorizations Preventing the total authority from being exceeded during the division of powers, offline. Event log of stock transactions (6) and transaction authorization family tree (5) Verification via the central inventory server (2) valid transactions reconciliation with stock records and 10 from the previous synchronization period late period locked reserve (7) of uncompleted transaction authorizations reconciliation of delayed transactions based on the relevant period while protecting against delays. is provided. Around these fundamental concepts, the subject of the invention is “Offline Stock Authorization and 15 It is possible to develop a wide variety of applications related to the Conciliation System (1)” and the invention cannot be limited to the examples described here, but mainly to the claims as stated.

Claims

REQUESTS 1. This invention applies to network conditions where data communication is completely or partially interrupted, Stock operations without requiring constant connection to the central inventory system. to be able to be done and after the connection is re-established 5 transactions performed in a manner consistent with the central inventory system enabling reconciliation; - Creating transaction authorizations based on verified stock information and the created at least one central inventory configured to delegate transaction authorizations server (2), 10 - within the scope of the transaction authorization received from the central inventory server (2), the word to create sub-operation authorizations in such a way that the subject matter does not exceed the total authorization amount and at least one configured to transfer the created sub-process permissions Local server (Hub) (3) that can operate offline, − In the event that the connection is not found, the assigned transaction authority is 15 to carry out inventory transactions within this scope, for each transaction performed configured to create a transaction log and exhaust the associated transaction authorization. at least one end processing device (4), − local that can work offline starting from the central inventory server (2) Which top 20 processing permissions are transferred to the server (3) and end processing devices (4) to track how it derives from authority and into which sub-authorities it is divided At least one configured transaction authorization family tree (5), - Stock operations performed on end processing devices (4) in order of operation at least one event log configured to record (6) and, − Unfinished old period 25 during the transition to the new synchronization period to prevent the redistribution of transaction authorizations at least one late period locked reserve (7) configured to be kept locked. and transaction authorization together with the records found in the family tree (5) and the incident log (6). by evaluating the valid stock transactions with the central inventory server (2) at least one reconciliation module (8) 30 structured to ensure reconciliation It includes. 11 - 2. Using verified stock information obtained from the central inventory system Authorization for transactions related to stock operations to be carried out in an offline environment to enable creation, stock quantity, product, warehouse, location, lot and serial number 5 to obtain the number information and to create the transaction authorization for that information. to ensure scope definition, transaction authorization, on a specific stock to be associated with the operations that can be performed and the created operation to ensure that the authority is transferred to a local server (3) that can operate offline and Transaction 10 can be used for inventory operations to be performed offline. to ensure that the right is based on verified central stock information the above characterized by the configured central inventory server (2) a system like any of the requests (1).

3. The transaction authorization created, transaction authorization, authorization ID, superior authorization ID, 15 synchronization period, authorization holder, scope of authorization, remaining authorization amount, or It will include serial number and version information, active, consumed, and pending transfer. late-term lockdown, quarantine, or keeping in one of the closed situations, new When determining the transaction authorization to be reallocated during the synchronization period active transaction authorizations, late period locked reserve (7) and unfinished transaction 20 or a central inventory server configured to take transfers into account (2) like any of the above-mentioned claims characterized by system (1).

4. Transfers the processing authorization received from the central inventory server (2) to the end processing devices 25 (4) transferring and allocating sub-process authorizations, sub-process authorizations created limiting the total scope to the transaction authority transferred to it, end transaction the total of the transaction authorizations distributed to the devices (4) central inventory To ensure that the upper processing authority created by the server (2) is not exceeded, allocating the entire processing authority transferred to it to a single end processing device (4) 30 to distribute the said processing authority to multiple end processing devices (4) 12 to be able to divide it into sub-process authorizations, each sub-process authorization as a resource to be within the scope of the superior authority to which it is affiliated and the same central If the user can exercise transaction authorizations related to the stock source, the distributed to prevent the total transaction authorization from exceeding the superior transaction authorization 5 characterized by a configured offline working local server (3) a system like any of the above requests (1).

5. The local server (3) that can operate offline is allocated to them To perform inventory transactions and manage data communication within the scope of transaction authorizations. Even if they are not present, the scope of their assigned transaction authorities is 10 including information on stock entry, stock exit, stock transfer, and serial or lot information. Performing inventory operations, using barcodes and RFID in the inventory operations performed. or obtain transaction data via manual entry, for each inventory item they process. The process includes the transaction time, device ID, transaction authorization used, and consumed data. 15 to create a transaction record containing the transaction right and related transaction information from the above requests characterized by the configured end processing device (4) a system like any other (1).

6. The portion of the transaction authorization used in relation to the completed inventory transaction. to consume, records relating to the transaction in question, if the connection is not available 20 to be able to store them in their own local data storage areas and during a connection interruption The inventory transactions that have been carried out will continue until the connection is re-established. to ensure protection of processing devices, before carrying out the inventory operation Check the synchronization period, owner, version, and scope of the transaction authorization. and transactions exceeding the remaining amount or scope of the transaction authorization 25 which stock transactions are not performed and are carried out offline determining that it is based on transaction authority and derived from a higher transaction authority that the total scope of subordinate processing authorizations does not exceed the relevant superior processing authorization with the end processing device (4) configured to enable control A system like any of the above-mentioned demands characterized (1). 30 13 7. This transaction is authorized by the central inventory server (2). for local server (3) and end processing devices (4) that can operate offline from their authority Tracking the relationships between the sub-process authorizations created, a process from which higher-level authority the authority is derived and the transaction in question To determine which sub-process authorizations are created from the authority, central 5 Starting from the transaction authorization created by the inventory server (2) Subprocess created by the local server (3) which can operate offline up to the processing authorizations allocated to the end processing device (4) Transaction authority family tree structured to maintain the authority relationship (5), A system like any of the above-mentioned systems characterized by 10 (1).

8. The order of stock operations performed by the end processing device (4) to ensure that it is recorded accordingly, regarding the stock transactions performed. transaction time, device ID, used transaction authorization, event sequence number and 15 Maintaining records containing information about the synchronization period, each A record relating to a stock transaction is the sequence of events in which the transaction was performed. keeping a record in a way that will allow its location to be determined, link Stock management performed by end processing devices (4) during interruption The processes will be evaluated after the connection is re-established. 20 to enable, the records contained therein, the source of the relevant transaction authorization and Considering the consumption, the stock transaction in question was previously to keep a record of the relationship with completed transactions and the order of transactions from the above requests characterized by the structured event log (6) a system like any other (1). 25 9. Unfinished during the transition from one synchronization period to another. Previous period transaction permissions will be reinstated in the new synchronization period. to prevent it from being considered as usable transaction authorization, connection Transaction 30 that has not yet been delivered to the central inventory server (2) due to interruption old records or transaction authorizations that have not yet been finalized 14 To ensure that rights relating to the synchronization period are kept separate, new During the synchronization period, the transaction permissions from the previous period will be reinstated. to prevent distribution and on a disconnected end processing device (4) or located on a local server (3) which can operate offline and not yet Unfinished old period transaction authorization, new synchronization 5 to prevent reallocation to another end processing device (4) during the period to pass, transaction records arriving with a delay from the previous period in the evaluation to be associated with the relevant previous period transaction authorizations characterized by the structured late period locked reserve (7), as described above. a system like any of the requests (1). 10 10. After the connection is re-established, the end processing devices (4) and offline stock transaction records generated by the working local server (3), related transaction authorizations, transaction authorization family tree (5) and event log (6) to evaluate the validity of the transaction authorization, the relevant transaction authorization for the stock transaction 15 whether it was carried out within the scope and the transaction record of the event to check the compliance with the log (6), between the transaction authorization and the stock transaction the necessary compliance is ensured and the transaction does not exceed the scope of the transaction authorization. In this case, the valid transactions are with the stock records in the central inventory server (2) reconciliation, transaction authorization family tree (5), event log (6), stock operation and transaction 20 If there is a discrepancy between the authorities, the relevant transaction will be verified stock. to prevent direct application to the record and to verify the transaction to evaluate separately, delayed from the old synchronization period Valid stock transactions delivered within the scope of the relevant late period locked reserve (7) by associating it with the transaction authorization found in the central inventory server (2) 25 The reconciliation module is configured to reconcile with stock records. (8) like any of the above-mentioned claims characterized by system (1).

11. To prevent the same transaction record from being applied multiple times, a unique 30 To perform a re-processing check via the event ID and unverified or inconsistencies between transaction authorization and event log Stock transaction records will be quarantined until verification is complete. to prevent its application to the central inventory record the above is characterized by the structured reconciliation module (8). a system like any of the requests (1). 5 15 25