Realization method and equipment for inventory account book and medium

Abstract

The invention discloses an implementation method and device for an inventory account book and a medium, and the method comprises the steps: determining a settlement instruction for a current inventory account book based on the settlement operation initiated by a user in a preset period; summarizing data in the stock current-period initial table and the stock current-period material voucher table, and synchronizing the summarized data to a stock period balance account table to obtain current-period data corresponding to the stock period balance account table; settlement of the current inventory account book is carried out according to the current data; and based on a settlement result, deleting data synchronized to the inventory period balance account table in the inventory current period initial table and the inventory current period material voucher table. The performance and operation experience of related services of the system can be greatly improved, and the method has the advantages of being small in influence on an existing system, easy to implement, practical, universal and easy to popularize.

Description

technical field [0001] The present application relates to the field of informatization, and in particular, to an implementation method, device and medium for an inventory account book. Background technique [0002] Inventory ledger is one of the core ledgers of the Enterprise Resource Planning (ERP) system. It is the most important input / output information for production management and supply chain management. It is the information foundation of other businesses, and its design restricts the performance and experience of the entire information system. [0003] Traditional inventory books are processed when inventory business documents are saved or recorded, for example, period real-time accounts are created or updated when saved, and period balance accounts are created or updated when bookkeeping is performed. The timing of account book update is closely related to daily business. The amount of data will increase linearly with the application of time. When the amount of dat...

AI Technical Summary

Problems solved by technology

The timing of ledger update is closely related to daily business. The amount of data will increase linearly as the application goes on for a long time. When the amount of data increases to a certain extent, the performance will usually degrade and affect the daily business experience. The performance may include: saving or recording daily inventory business documents Slow running of account time, long time-consuming and slow performance when checking available inventory out of the warehouse, slow performance of MRP and other queries involving inventory balance

Images