A multi-level warehouse accounting method and system based on front-end and back-end linkage

Abstract

This invention relates to the field of data processing technology, and in particular to a multi-level warehouse accounting method and system based on front-end and back-end linkage. The method includes the following steps: acquiring cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved; determining the crosstalk risk value of the transfer path based on the changing characteristics of the coexistence environment of goods between different path stages; determining the inventory crosstalk difference value generated when the transferred goods flow from the sending warehouse to the receiving warehouse; determining the crosstalk risk change of the transferred goods based on the crosstalk risk value of the transfer path and the inventory crosstalk difference value, and performing back-end chain cost transmission processing on the warehousing cost of the corresponding goods in the receiving warehouse based on the crosstalk risk change; generating a dynamic aggregation key based on the mapping relationship between physical warehouses and accounting warehouse groups, and performing front-end dynamic aggregation processing.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a multi-level warehouse accounting method and system based on front-end and back-end linkage. Background Technology

[0002] In Enterprise Resource Planning (ERP) and SaaS management systems, inventory cost accounting and sales profit analysis are core functions of supply chain management and financial management. As businesses expand and supply networks become more complex, traditional warehousing networks have evolved into multi-tiered networks including headquarters warehouses, regional central warehouses, and distributed forward warehouses. The transfer of goods and resource coordination between different warehouses are becoming increasingly frequent. Therefore, achieving accurate cost accounting across the entire supply chain has become crucial for ensuring the accuracy of financial data and operational flexibility.

[0003] Existing technologies neglect the crosstalk propagation characteristics of goods in multi-level warehousing networks, leading to distortions in the transmission of commodity costs during inter-warehouse transfers. In multi-level warehousing networks, the storage environments and commodity categories of different physical warehouses vary significantly. During inter-warehouse transfers, goods are affected by crosstalk from coexisting goods along the transfer path, as well as from crosstalk between existing goods in the receiving warehouse and the transferred goods. These crosstalk effects cause a continuous decline in the value of the goods.

[0004] Traditional accounting models, when handling cross-warehouse transfers, simply transfer the quantity of goods or determine the receiving cost of the receiving warehouse based on a fixed standard cost. They lack consideration for the value decay caused by crosstalk risk and fail to establish an effective cross-warehouse cost transmission mechanism. When goods are transferred from a high-cost warehouse to a low-cost warehouse, the receiving warehouse cannot inherit the dynamic outbound cost of the transferring warehouse in real time and correct the value loss caused by crosstalk. This leads to subsequent sales profits being artificially high or low, and fails to truly reflect the value flow process of goods in the supply chain network. Summary of the Invention

[0005] To overcome the defects and shortcomings of existing technologies, this invention provides a multi-level warehouse accounting method and system based on front-end and back-end linkage. By quantifying the risk of cross-warehouse transfer of goods and transmitting back-end chain costs, it effectively improves the accuracy of supply chain value accounting.

[0006] To achieve the above objectives, the present invention adopts the following technical solution: In a first aspect, the present invention provides a multi-level warehouse accounting method based on front-end and back-end linkage, including: Obtain cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the transfer-out warehouse identifier, the transfer-in warehouse identifier, the transfer path information, and the set of transferred goods. The transfer path between the outgoing and incoming warehouses is divided into continuous path stages. The coexistence status of the transferred goods in each path stage is identified, and the crosstalk risk value of the transfer path is determined based on the changing characteristics of the coexistence environment between different path stages. Based on the analysis of warehouse status characteristic data, the differences in inventory structure between the warehouses being transferred out and the warehouses being transferred in are determined to determine the inventory crosstalk difference caused by the transfer of goods from the warehouse to the warehouse being transferred in. The change in crosstalk risk of the transferred goods is determined based on the crosstalk risk value of the transfer route and the difference value of inventory crosstalk, and the back-end chain cost transmission process is performed on the warehousing cost of the corresponding goods in the receiving warehouse based on the change in crosstalk risk. Dynamic aggregation keys are generated based on the mapping relationship between physical warehouses and accounting warehouse groups. The front-end dynamic aggregation processing is then performed in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby decoupling the financial accounting unit from the physical warehousing structure.

[0007] Furthermore, determining the crosstalk risk value of the transfer path based on the changing characteristics of the commodity coexistence environment between different path stages includes: The transfer path between the outgoing and incoming warehouses is divided into continuous path stages. The coexisting commodity set corresponding to each path stage is obtained and the crosstalk influence intensity between different commodities is combined to calculate the crosstalk risk value corresponding to each path stage, which is used to characterize the value decay effect of commodities due to crosstalk risk in each path stage. The crosstalk risk value of the current path stage is calculated based on the crosstalk risk value output from the previous path stage, and the crosstalk risk values ​​of all path stages are continuously propagated and accumulated along the transfer path to obtain the crosstalk risk value of the transfer path.

[0008] Furthermore, determining the inventory crosstalk difference value generated when transferred goods move from the originating warehouse to the receiving warehouse includes: Based on warehouse status feature data, construct separate sets of coexisting goods in outbound warehouses and coexisting goods in inbound warehouses; Based on the crosstalk intensity between different commodities, the cumulative crosstalk intensity of the transferred commodities is calculated in both the coexisting commodity set in the outgoing warehouse and the coexisting commodity set in the incoming warehouse. The difference between the two is taken as the inventory crosstalk difference value generated when the transferred commodities are transferred from the outgoing warehouse to the incoming warehouse.

[0009] Furthermore, the crosstalk impact intensity is obtained by acquiring historical cross-warehouse transfer data, analyzing the changes in commodity quality during the historical cross-warehouse transfer process, statistically analyzing the probability of quality change under the coexistence of different commodities, and using the normalized value of the probability of quality change as the crosstalk impact intensity between different commodities.

[0010] Furthermore, the back-end chain cost transmission process for the warehousing cost of the corresponding goods transferred into the warehouse includes: The outbound cost of the warehouse is adjusted based on the change in crosstalk risk, and the adjusted outbound cost is used as the inbound cost of the warehouse. When the difference between the inbound cost and the original inbound cost of the warehouse exceeds a preset threshold, incremental cascading recalculation is performed on the inventory flow after the affected time point, and recursively propagation is carried out along the cross-warehouse transfer path.

[0011] Furthermore, the execution of front-end dynamic aggregation processing includes: Obtain the user's accounting configuration data for the physical warehouse, construct a virtual mapping relationship between the physical warehouse and the accounting warehouse group, and store the virtual mapping relationship as a relationship mapping table updated at runtime. In the relationship mapping table, the warehouse identifier and the accounting warehouse group identifier have a many-to-one mapping relationship. During the business document generation process, the front end queries the relationship mapping table based on the product identifier and warehouse identifier input by the user, generates a dynamic aggregation key, and combines the inbound cost after the back end chain cost transmission to aggregate and calculate the business document to obtain the dynamic weighted average cost.

[0012] Furthermore, the generation of dynamic aggregation bonds includes: Determine the existence of the system's accounting switch status and relational mapping table; When the system enables grouped accounting and the warehouse identifier in the relational mapping table has a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the accounting warehouse group identifier. When the system does not enable grouped accounting or the warehouse identifier in the relational mapping table does not have a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the warehouse identifier.

[0013] Secondly, the present invention provides a multi-level warehouse accounting system based on front-end and back-end linkage, including: The data acquisition module is used to acquire cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the transfer-out warehouse identifier, the transfer-in warehouse identifier, the transfer path information, and the set of transferred goods. The transfer path crosstalk risk determination module is used to divide the transfer path between the transfer-out warehouse and the transfer-in warehouse into continuous path stages, identify the coexistence status of the transferred goods in each path stage, and determine the transfer path crosstalk risk value based on the changing characteristics of the coexistence environment between different path stages. The integrated crosstalk risk determination module is used to analyze the differences in inventory structure between the outgoing and incoming warehouses based on warehouse status characteristic data, and to determine the inventory crosstalk difference value caused by the transfer of goods from the outgoing warehouse to the incoming warehouse. The back-end chain cost transmission module is used to determine the change in crosstalk risk of transferred goods based on the crosstalk risk value of the transfer path and the difference value of inventory crosstalk, and to perform back-end chain cost transmission processing on the warehousing cost of the corresponding goods in the warehouse based on the change in crosstalk risk. The front-end dynamic aggregation processing module is used to generate dynamic aggregation keys based on the mapping relationship between physical warehouses and accounting warehouse groups, and to perform front-end dynamic aggregation processing in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby decoupling the financial accounting unit from the physical warehousing structure.

[0014] Thirdly, the present invention provides an electronic device, comprising: a processor and a memory, wherein the memory stores a computer program that can be called by the processor, and the processor executes a multi-level warehouse accounting method based on front-end and back-end linkage by calling the computer program stored in the memory.

[0015] Fourthly, the present invention provides a computer-readable storage medium storing instructions that, when executed on a computer, cause the computer to perform a multi-level warehouse accounting method based on front-end and back-end linkage.

[0016] Compared with the prior art, the present invention has the following advantages and beneficial effects: 1. This invention constructs a crosstalk risk value for the transfer path and a crosstalk difference value for inventory, and corrects the warehousing cost based on the change in crosstalk risk. This allows the attenuation of commodity value caused by differences in warehousing environment, coexistence of commodities, and changes in transportation conditions during cross-warehouse transfers to be reflected in the cost chain, effectively improving the accuracy of supply chain value accounting.

[0017] 2. This invention achieves decoupling between the financial accounting unit and the physical warehousing structure through front-end dynamic aggregation and back-end chain cost transmission. By performing incremental cascading recalculation on inventory flow after the affected time point, it provides a low-load, high-efficiency solution for historical document correction in high-concurrency scenarios. Attached Figure Description

[0018] Other features, objects, and advantages of the invention will become more apparent from the following detailed description of non-limiting embodiments with reference to the accompanying drawings: Figure 1 This is a flowchart illustrating the multi-level warehouse accounting method based on front-end and back-end linkage provided in an embodiment of the present invention. Figure 2 This is a schematic diagram of the process for performing dynamic aggregation processing at the front end, provided in an embodiment of the present invention. Detailed Implementation

[0019] The technical solution of the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present invention and the specific features in the embodiments are detailed descriptions of the technical solution of the present invention, rather than limitations thereof. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

[0020] Please see Figure 1 , Figure 1 This is a flowchart illustrating a multi-level warehouse accounting method based on front-end and back-end linkage provided in an embodiment of the present invention, specifically including the following steps: S100. Obtain cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the identifier of the warehouse to be transferred, the identifier of the warehouse to be transferred, the transfer path information, and the set of transferred goods. The cross-warehouse transfer instruction data is obtained through the cross-warehouse transfer operation interface in the front-end business workbench. The storage status characteristic data can be obtained by calling the back-end inventory interface, including the full SKU list of existing inventory goods in the warehouse to be transferred and the warehouse to be transferred, the quantity of goods in stock, and the storage location, which are used to describe the coexistence relationship between the transferred goods and the existing goods in the warehouse. S200. Divide the transfer path between the warehouse that is being transferred out and the warehouse that is being transferred into continuous path stages, identify the coexistence status of the transferred goods in each path stage, and determine the crosstalk risk value of the transfer path based on the changing characteristics of the coexistence environment between different path stages.

[0021] By dissecting the entire cross-warehouse transfer scenario, the coexistence status of goods at different nodes within the transfer path is distinguished, and the value loss caused by crosstalk in each segment of the transfer path is quantified. Ultimately, the overall crosstalk risk value for the entire transfer path is obtained, providing a precise quantitative basis for subsequent warehousing cost adjustments and chain cost transmission. The crosstalk risk value for the transfer path is determined based on the changing characteristics of the coexistence environment between different path stages, including: The transfer path between the outgoing and incoming warehouses is divided into continuous path stages. The coexisting product set corresponding to each path stage is obtained, and the crosstalk influence intensity between different products is combined to calculate the crosstalk risk value corresponding to each path stage. This value is used to characterize the value decay impact of crosstalk risk on products within each path stage. Specifically, the transfer path information is extracted from the cross-warehouse transfer instruction data, and the transfer path is divided into continuous and non-overlapping path stages according to the product flow, such as the outgoing warehouse temporary storage stage, trunk transportation stage, transit warehouse temporary storage stage, last-mile delivery stage, and incoming warehouse temporary storage stage. For each independent path stage, information on products stored and circulated together with the transferred products within the path stage is collected, and a coexisting product set for the corresponding stage is formed. Combining the crosstalk influence intensity between products, the crosstalk influence intensity of the target transferred product and each product in the coexisting product set is accumulated one by one and averaged to obtain the crosstalk risk value corresponding to the path stage. This achieves segmented and refined accounting, thereby adapting to various complex transfer scenarios and improving the accuracy of crosstalk risk calculation. The crosstalk risk value of the current path stage is calculated based on the crosstalk risk value output by the previous path stage, and the crosstalk risk values ​​of all path stages are continuously propagated and accumulated along the transfer path to obtain the transfer path crosstalk risk value. Specifically, according to the sequential flow of path stages, the crosstalk risk value output by the previous path stage is retrieved as the initial crosstalk risk value of the current path stage; the initial crosstalk risk value is accumulated with the crosstalk risk value of the current path stage to obtain the transfer path crosstalk risk value. The crosstalk impact strength is determined by acquiring historical cross-warehouse transfer data, analyzing changes in commodity quality during historical cross-warehouse transfers, and statistically analyzing the probability of quality changes under different commodity coexistence conditions. The normalized value of the quality change probability is then used as the crosstalk impact strength between different commodities. Specifically, through historical cross-warehouse transfer data, valid data including commodity quality inspection and loss records are selected to construct a standardized historical sample dataset, covering transfer scenarios with various commodity coexistence combinations, various warehousing environments, and various circulation durations. The historical sample dataset is then dimensionally split and categorized according to different commodity coexistence combinations, storage environments, and circulation durations. The total transfer sample size under each coexistence combination and the number of quality anomaly samples showing quality decline and value decay in the corresponding target transferred commodity are statistically analyzed. The probability of quality change under different commodity coexistence conditions is calculated, where the probability of quality change is the ratio of the number of quality anomaly samples to the total transfer sample size. The extreme value normalization method is used to normalize the probability of quality change to obtain the crosstalk impact strength between different commodities.

[0022] S300. Analyze the differences in inventory structure between the warehouse and the warehouse based on the warehouse status characteristic data, and determine the inventory crosstalk difference value caused by the transfer of goods from the warehouse to the warehouse. Current warehouse accounting technology assumes no loss in value due to internal storage conditions before and after cross-warehouse transfers. It fails to consider the differences in inventory categories and coexistence relationships between different warehouses, directly using the cost of the transferring warehouse to calculate the receiving cost. This leads to distorted cost chain transmission and deviations in actual product value calculation. Differences in inventory structure between the transferring and receiving warehouses will cause crosstalk losses and value decay within the transferred goods. When warehouses store different product categories, have different coexistence combinations, and have different types of goods suitable for different storage environments, the same batch of transferred goods will have no significant crosstalk losses within the transferring warehouse, but will experience physical and chemical conflicts and quality interference with existing inventory after entering the receiving warehouse. The inventory crosstalk difference value generated by the transfer of goods from the transferring warehouse to the receiving warehouse includes: Based on warehouse status feature data, two sets of coexisting goods are constructed: one for goods transferred out of the warehouse and one for goods transferred into the warehouse. Specifically, for goods transferred out of the warehouse, all goods that are in the same storage area as the transferred goods are selected to construct a set of coexisting goods in the warehouse. Similarly, a set of coexisting goods in the warehouse is constructed. Both sets use the unique identifier of the goods as the set element to ensure a unified standard for determining the coexistence association between the goods in the set and the transferred goods. Based on the crosstalk intensity between different commodities, the cumulative crosstalk intensity of the transferred commodity is calculated in both the coexisting commodity set in the outgoing warehouse and the coexisting commodity set in the incoming warehouse. The difference between the two is taken as the inventory crosstalk difference value generated when the transferred commodity flows from the outgoing warehouse to the incoming warehouse. Specifically, taking the cumulative crosstalk intensity of the transferred commodity in the coexisting commodity set in the outgoing warehouse as an example: traverse each commodity in the coexisting commodity set in the outgoing warehouse, accumulate the crosstalk intensity between it and the transferred commodity one by one, and take the average value to obtain the cumulative crosstalk intensity of the transferred commodity in the outgoing warehouse environment.

[0023] S400. Determine the change in crosstalk risk of the transferred goods based on the crosstalk risk value of the transfer route and the difference value of inventory crosstalk, and perform back-end chain cost transmission processing on the warehousing cost of the corresponding goods in the warehouse based on the change in crosstalk risk. The outbound cost of goods transferred from the warehouse is corrected by adjusting the crosstalk risk variation, and a back-end cost chain transmission mechanism is introduced to establish a strong correlation between outbound and inbound orders in the transfer scenario. Through the transmission logic of outbound affecting inbound, the accurate correction and hierarchical transmission of the inbound cost of goods transferred to the warehouse are completed. The back-end chain cost transmission processing is performed on the inbound cost of the corresponding goods in the transferred warehouse, including: The outbound cost of the warehouse being transferred is adjusted based on the change in crosstalk risk, and the adjusted outbound cost is used as the inbound cost of the warehouse being transferred. When the difference between the inbound cost and the original inbound cost of the warehouse being transferred exceeds a preset threshold, incremental cascading recalculation is performed on the inventory flow after the affected time point. If there are subsequent transfer relationships between the warehouse and the warehouse being transferred, the recalculation task of the outbound order of the subsequent warehouse is triggered, and the process is recursively propagated along the cross-warehouse transfer path. The preset threshold is based on the minimum precision of financial accounting, and the default preset threshold is set to 0.0001 yuan. The change in crosstalk risk is the sum of the crosstalk risk value of the transfer path and the difference in inventory crosstalk. The original inbound cost is the inbound cost of the warehouse being transferred before the execution of the back-end chain cost transmission. Specifically, the formula for calculating the adjusted outbound cost can be: In the formula This indicates the revised outbound cost. This indicates the outbound cost before the correction. It represents the normalized value of the change in crosstalk risk, which is the ratio of the change in crosstalk risk to the sum of the cumulative crosstalk impact intensity of the transferred goods in both the coexisting goods set in the outgoing warehouse and the coexisting goods set in the incoming warehouse.

[0024] S500 generates dynamic aggregation keys based on the mapping relationship between physical warehouses and accounting warehouse groups, and performs front-end dynamic aggregation processing in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby achieving decoupling between the financial accounting unit and the physical warehousing structure. Dynamic aggregation keys are generated based on the mapping relationship between physical warehouses and accounting warehouse groups. These keys are then combined with the backend chain-based cost transmission correction of the inbound cost to perform frontend dynamic aggregation processing. This decouples the financial accounting unit from the physical warehousing structure, overcoming the drawbacks of the strong binding between physical warehouses and accounting dimensions in traditional accounting models. It adapts to the flexible accounting needs of multi-level warehousing networks in medium to large enterprises. Please refer to [link / reference]. Figure 2 , Figure 2 This is a schematic diagram of the process for performing front-end dynamic aggregation processing provided in an embodiment of the present invention, including: The system acquires user-configured physical warehouse accounting data, constructs a virtual mapping relationship between physical warehouses and accounting warehouse groups, and stores this virtual mapping relationship as a runtime-updated relational mapping table. The relationship between warehouse identifiers and accounting warehouse group identifiers in the relational mapping table is a many-to-one mapping. Specifically, when the front-end system starts or refreshes, it pre-loads the user-configured mapping relationship between physical warehouses and accounting warehouse groups into the memory cache for subsequent dynamic aggregation calculations. The mapping relationship is created by the user on the front-end configuration page, where they create accounting warehouse groups and select associated physical warehouses, and then stored in the corresponding mapping data table by the back-end. For example, based on the enterprise's warehousing organizational structure, it builds multi-level virtual accounting units such as the headquarters warehouse group, the East China regional warehouse group, and the South China regional warehouse group. Then, it selects and binds physical warehouses within the corresponding regions (Shanghai, Hangzhou, and Nanjing warehouses belong to the East China regional warehouse group, while Guangzhou and Shenzhen warehouses belong to the South China regional warehouse group) to the corresponding accounting warehouse groups, thus constructing a many-to-one virtual mapping relationship between physical warehouses and accounting warehouse groups. During the business document generation process, the front end queries the relationship mapping table based on the product identifier and warehouse identifier input by the user, generates a dynamic aggregation key, and combines it with the inbound cost after the back end's chain cost transmission to perform aggregation calculation on the business document, obtaining a dynamic weighted average cost. Specifically, the front end aggregation engine retrieves the inbound cost corrected by the back end through the chain cost transmission mechanism based on the generated dynamic aggregation key, and performs real-time aggregation calculation on the product data in the business document; it traverses all product rows in the business document, classifies and accumulates the product inbound and outbound quantities and corresponding amounts according to the dynamic aggregation key, calculates the total quantity and total amount of products under the same aggregation dimension, and calculates the dynamic weighted average cost in real time; Dynamic aggregation keys are the fundamental carrier for realizing front-end and back-end linked accounting and multi-level data aggregation. Their core function is to break the limitations of fixed accounting dimensions, establish flexibly switchable accounting data indexes, decouple physical warehousing from financial accounting units, and generate dynamic aggregation keys, including: Determine the existence of the system's accounting switch status and relational mapping table; When the system enables grouped accounting and the warehouse identifier in the relational mapping table has a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the accounting warehouse group identifier. When the system does not enable grouped accounting or the warehouse identifier in the relational mapping table does not have a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the warehouse identifier. In a specific embodiment of the present invention, taking the order page as an example, when a user adds a product and selects a warehouse, the front-end dynamic aggregation engine executes the following logic: input the product ID (GoodsID), the current row warehouse ID (WarehouseID), and the system accounting switch status; if the system has enabled warehouse accounting and there is a warehouse group configuration; then, based on the WarehouseID, the corresponding accounting warehouse group ID (GroupID) is found in the accounting warehouse group mapping table GroupMap, and a composite primary key Key = GoodsID + GroupID is generated; if there is no warehouse group, then Key = GoodsID + WarehouseID.

[0025] The multi-level warehouse accounting system based on front-end and back-end linkage provided in this invention is designed with an end-to-end layered architecture. The system is built upon a front-end interactive configuration layer, a back-end business logic processing layer, and a database persistent storage layer. The front-end is responsible for interactive configuration, dynamic view aggregation, and real-time profit forecasting, while the back-end is responsible for business logic processing, cost chain transmission, and persistent storage. The database is used to store basic files, configuration mappings, and cost flows, including: The data acquisition module is used to acquire cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the transfer-out warehouse identifier, the transfer-in warehouse identifier, the transfer path information, and the set of transferred goods. The transfer path crosstalk risk determination module is used to divide the transfer path between the transfer-out warehouse and the transfer-in warehouse into continuous path stages, identify the coexistence status of the transferred goods in each path stage, and determine the transfer path crosstalk risk value based on the changing characteristics of the coexistence environment between different path stages. The integrated crosstalk risk determination module is used to analyze the differences in inventory structure between the outgoing and incoming warehouses based on warehouse status characteristic data, and to determine the inventory crosstalk difference value caused by the transfer of goods from the outgoing warehouse to the incoming warehouse. The back-end chain cost transmission module is used to determine the change in crosstalk risk of transferred goods based on the crosstalk risk value of the transfer path and the difference value of inventory crosstalk, and to perform back-end chain cost transmission processing on the warehousing cost of the corresponding goods in the warehouse based on the change in crosstalk risk. The front-end dynamic aggregation processing module is used to generate dynamic aggregation keys based on the mapping relationship between physical warehouses and accounting warehouse groups, and to perform front-end dynamic aggregation processing in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby decoupling the financial accounting unit from the physical warehousing structure.

[0026] Embodiments of the present invention also provide an electronic device, including a memory, a processor, and a communication bus; the memory and the processor are connected via the communication bus. The memory stores a multi-level warehouse accounting method based on front-end and back-end linkage, which can be loaded and executed by the processor as provided in the above embodiments.

[0027] The memory can be used to store instructions, programs, code, code sets, or instruction sets. The memory may include a program storage area and a data storage area. The program storage area may store instructions for implementing an operating system, instructions for at least one function, and instructions for implementing the multi-level warehouse accounting method based on front-end and back-end linkage provided in the above embodiments, etc. The data storage area may store data involved in the multi-level warehouse accounting method based on front-end and back-end linkage provided in the above embodiments, etc.

[0028] A processor may include one or more processing cores. The processor executes instructions, programs, code sets, or instruction sets stored in memory, and calls data stored in memory to perform various functions and process data according to the present invention. The processor may be at least one of the following: Application Specific Integrated Circuit (ASIC), Digital Signal Processor (DSP), Digital Signal Processing Device (DSPD), Programmable Logic Device (PLD), Field Programmable Gate Array (FPGA), Central Processing Unit (CPU), controller, microcontroller, and microprocessor. It is understood that, for different devices, the electronic devices used to implement the above-described processor functions may also be other types, and the embodiments of the present invention do not specifically limit this.

[0029] A communication bus can include a pathway for transmitting information between the aforementioned components. The communication bus can be a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus, etc. Communication buses can be categorized into address buses, data buses, control buses, etc.

[0030] This invention provides a computer-readable storage medium storing a computer program that can be loaded by a processor and executed as described in the above embodiments, which is a multi-level warehouse accounting method based on front-end and back-end linkage.

[0031] In this embodiment of the invention, the computer-readable storage medium can be a tangible device that holds and stores instructions used by an instruction execution device. The computer-readable storage medium can be, but is not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any combination thereof. Specifically, the computer-readable storage medium can be a portable computer disk, a hard disk, a USB flash drive, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), lectern random access memory (SRAM), portable compact disc read-only memory (CD-ROM), digital multifunction disc (DVD), memory stick, floppy disk, optical disk, magnetic disk, mechanical encoding device, or any combination thereof.

[0032] The terms “comprising,” “including,” or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article, or apparatus.

[0033] The above description is merely a preferred embodiment of the present invention and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this application is not limited to the technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the foregoing concept. For example, technical solutions formed by substituting the above-described features with (but not limited to) technical features with similar functions claimed in this invention.

Claims

1. A multi-level warehouse accounting method based on front-end and back-end linkage, characterized in that, include: Obtain cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the transfer-out warehouse identifier, the transfer-in warehouse identifier, the transfer path information, and the set of transferred goods. The transfer path between the outgoing and incoming warehouses is divided into continuous path stages. The coexistence status of the transferred goods in each path stage is identified, and the crosstalk risk value of the transfer path is determined based on the changing characteristics of the coexistence environment between different path stages. Based on the analysis of warehouse status characteristic data, the differences in inventory structure between the warehouses being transferred out and the warehouses being transferred in are determined to determine the inventory crosstalk difference caused by the transfer of goods from the warehouse to the warehouse being transferred in. The change in crosstalk risk of the transferred goods is determined based on the crosstalk risk value of the transfer route and the difference value of inventory crosstalk, and the back-end chain cost transmission process is performed on the warehousing cost of the corresponding goods in the receiving warehouse based on the change in crosstalk risk. Dynamic aggregation keys are generated based on the mapping relationship between physical warehouses and accounting warehouse groups. The front-end dynamic aggregation processing is then performed in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby decoupling the financial accounting unit from the physical warehousing structure.

2. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 1, characterized in that, The determination of crosstalk risk value along the transfer path based on the changing characteristics of the coexistence environment of goods between different path stages includes: The transfer path between the outgoing and incoming warehouses is divided into continuous path stages. The coexisting commodity set corresponding to each path stage is obtained and the crosstalk influence intensity between different commodities is combined to calculate the crosstalk risk value corresponding to each path stage, which is used to characterize the value decay effect of commodities due to crosstalk risk in each path stage. The crosstalk risk value of the current path stage is calculated based on the crosstalk risk value output from the previous path stage, and the crosstalk risk values ​​of all path stages are continuously propagated and accumulated along the transfer path to obtain the crosstalk risk value of the transfer path.

3. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 2, characterized in that, The determination of the inventory crosstalk difference value generated when transferred goods move from the originating warehouse to the receiving warehouse includes: Based on warehouse status feature data, construct separate sets of coexisting goods in outbound warehouses and coexisting goods in inbound warehouses; Based on the crosstalk intensity between different commodities, the cumulative crosstalk intensity of the transferred commodities is calculated in both the coexisting commodity set in the outgoing warehouse and the coexisting commodity set in the incoming warehouse. The difference between the two is taken as the inventory crosstalk difference value generated when the transferred commodities are transferred from the outgoing warehouse to the incoming warehouse.

4. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 3, characterized in that, The crosstalk impact intensity is determined by acquiring historical cross-warehouse transfer data, analyzing the changes in commodity quality during historical cross-warehouse transfers, statistically analyzing the probability of quality changes under the coexistence of different commodities, and using the normalized value of the probability of quality changes as the crosstalk impact intensity between different commodities.

5. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 1, characterized in that, The back-end chain cost transmission process for the warehousing cost of the corresponding goods transferred to the warehouse includes: correcting the outbound cost of the warehouse based on the change in crosstalk risk, and using the corrected outbound cost as the warehousing cost of the warehouse. When the difference between the warehousing cost and the original warehousing cost of the warehouse is greater than a preset threshold, incremental cascading recalculation is performed on the inventory flow after the affected time point, and recursively propagation is carried out along the cross-warehouse transfer path.

6. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 1, characterized in that, The execution of front-end dynamic aggregation processing includes: Obtain the user's accounting configuration data for the physical warehouse, construct a virtual mapping relationship between the physical warehouse and the accounting warehouse group, and store the virtual mapping relationship as a relationship mapping table updated at runtime. In the relationship mapping table, the warehouse identifier and the accounting warehouse group identifier have a many-to-one mapping relationship. During the business document generation process, the front end queries the relationship mapping table based on the product identifier and warehouse identifier input by the user, generates a dynamic aggregation key, and combines the inbound cost after the back end chain cost transmission to aggregate and calculate the business document to obtain the dynamic weighted average cost.

7. The multi-level warehouse accounting method based on front-end and back-end linkage according to claim 6, characterized in that, The generation of dynamic aggregation keys includes: Determine the existence of the system's accounting switch status and relational mapping table; When the system enables grouped accounting and the warehouse identifier in the relational mapping table has a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the accounting warehouse group identifier. When the system does not enable grouped accounting or the warehouse identifier in the relational mapping table does not have a corresponding accounting warehouse group, the dynamic aggregation key is composed of the product identifier and the warehouse identifier.

8. A multi-level warehouse accounting system based on front-end and back-end linkage, used to implement the multi-level warehouse accounting method based on front-end and back-end linkage as described in any one of claims 1-7, characterized in that, The system includes: The data acquisition module is used to acquire cross-warehouse transfer instruction data initiated by the front end and the storage status characteristic data of the warehouses involved. The cross-warehouse transfer instruction data includes the transfer-out warehouse identifier, the transfer-in warehouse identifier, the transfer path information, and the set of transferred goods. The transfer path crosstalk risk determination module is used to divide the transfer path between the transfer-out warehouse and the transfer-in warehouse into continuous path stages, identify the coexistence status of the transferred goods in each path stage, and determine the transfer path crosstalk risk value based on the changing characteristics of the coexistence environment between different path stages. The integrated crosstalk risk determination module is used to analyze the differences in inventory structure between the outgoing and incoming warehouses based on warehouse status characteristic data, and to determine the inventory crosstalk difference value caused by the transfer of goods from the outgoing warehouse to the incoming warehouse. The back-end chain cost transmission module is used to determine the change in crosstalk risk of transferred goods based on the crosstalk risk value of the transfer path and the difference value of inventory crosstalk, and to perform back-end chain cost transmission processing on the warehousing cost of the corresponding goods in the warehouse based on the change in crosstalk risk. The front-end dynamic aggregation processing module is used to generate dynamic aggregation keys based on the mapping relationship between physical warehouses and accounting warehouse groups, and to perform front-end dynamic aggregation processing in conjunction with the back-end chain cost transmission correction of the inbound cost, thereby decoupling the financial accounting unit from the physical warehousing structure.

9. An electronic device, comprising: A processor and a memory, wherein the memory stores a computer program that can be called by the processor; characterized in that the processor executes the multi-level warehouse accounting method based on front-end and back-end linkage as described in any one of claims 1-7 by calling the computer program stored in the memory.

10. A computer-readable storage medium, characterized in that, The system stores instructions that, when executed on a computer, cause the computer to perform the multi-level warehouse accounting method based on front-end and back-end linkage as described in any one of claims 1-7.

Images