An inventory data management method, apparatus, storage medium, and electronic device.

Abstract

This application proposes an inventory data management method, apparatus, storage medium, and electronic device. When adding second-type data information to a target database, if first-type data information is detected in the target database, the first-type data information is corrected based on the second-type data information. The first-type data information represents negative inventory information, and the second-type data information represents positive inventory information. If the first-type inventory cost change information is not zero, a mapping relationship is established between the first-type inventory cost change information and the first and second-type data information. The first-type inventory cost change information refers to the inventory cost change information resulting from the correction. This automatically completes the data correction, saving time and effort, and also allows for observation of cost change information through the mapping relationship, facilitating subsequent statistical verification.

Description

Technical Field

[0001] This application relates to the field of data processing, and more specifically, to an inventory data management method, apparatus, storage medium, and electronic device. Background Technology

[0002] As society develops, people's living standards are rising, and the availability of daily necessities is increasing. Along with this abundance, businesses are experiencing massive volumes of goods entering and leaving their warehouses. When a business's inventory data is disorganized, it can lead to incomplete stock or misleading product information, hindering business management.

[0003] How to effectively manage inventory data in the context of high-volume goods circulation has become a challenging problem of concern to those skilled in the art. Summary of the Invention

[0004] The purpose of this application is to provide an inventory data management method, apparatus, storage medium, and electronic device to at least partially improve the above-mentioned problems.

[0005] To achieve the above objectives, the technical solutions adopted in the embodiments of this application are as follows:

[0006] In a first aspect, embodiments of this application provide an inventory data management method for managing a target database, wherein the target database is used to statistically analyze the current inventory quantity of target items, and the method includes:

[0007] When adding the second type of data information to the target database, if the first type of data information is detected in the target database, the first type of data information is corrected based on the second type of data information.

[0008] The first type of data information is negative inventory information, and the second type of data information is positive inventory information;

[0009] If the first type of inbound cost change information is not zero, establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information;

[0010] The first type of inbound cost change information refers to inbound cost change information resulting from corrections.

[0011] Secondly, embodiments of this application provide an inventory data management device for managing a target database, wherein the target database is used to statistically analyze the current inventory quantity of target items, and the device includes:

[0012] The processing unit is configured to, when adding second type of data information to the target database, if it is recognized that first type of data information exists in the target database, correct the first type of data information based on the second type of data information;

[0013] The first type of data information is negative inventory information, and the second type of data information is positive inventory information;

[0014] The mapping unit is used to establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information when the first type of inbound cost change information is not zero.

[0015] The first type of inbound cost change information refers to inbound cost change information resulting from corrections.

[0016] Thirdly, embodiments of this application provide a storage medium storing a computer program thereon, which, when executed by a processor, implements the above-described method.

[0017] Secondly, embodiments of this application provide an electronic device, the electronic device including: a processor and a memory, the memory being used to store one or more programs; when the one or more programs are executed by the processor, the above-described method is implemented.

[0018] Compared to existing technologies, the inventory data management method, apparatus, storage medium, and electronic device provided in this application, when adding second type of data information to a target database, if first type of data information is detected in the target database, corrects the first type of data information based on the second type of data information; wherein, the first type of data information is negative inventory information, and the second type of data information is positive inventory information; if the first type of inventory cost change information is not zero, a mapping relationship is established between the first type of inventory cost change information and the first and second types of data information; wherein, the first type of inventory cost change information is the inventory cost change information generated due to the correction. This automatically completes the data information correction, saving time and effort, and also allows for observation of cost change information through the mapping relationship, facilitating subsequent statistical verification.

[0019] To make the above-mentioned objectives, features and advantages of this application more apparent and understandable, preferred embodiments are described below in detail with reference to the accompanying drawings. Attached Figure Description

[0020] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of this application and should not be regarded as a limitation of the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.

[0021] Figure 1 This is a schematic diagram of the structure of the electronic device provided in the embodiments of this application;

[0022] Figure 2 A flowchart illustrating the inventory data management method provided in this application embodiment;

[0023] Figure 3 One of the flowcharts illustrating the inventory data management method provided in this application embodiment;

[0024] Figure 4 One of the flowcharts illustrating the inventory data management method provided in this application embodiment;

[0025] Figure 5 This is a schematic diagram of a unit of an inventory data management device provided in an embodiment of this application.

[0026] In the diagram: 10-Processor; 11-Memory; 12-Bus; 13-Communication Interface; 201-Processing Unit; 202-Mapping Unit. Detailed Implementation

[0027] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. The components of the embodiments of this application described and shown in the accompanying drawings can generally be arranged and designed in various different configurations.

[0028] Therefore, the following detailed description of the embodiments of this application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely to illustrate selected embodiments of the application. All other embodiments obtained by those skilled in the art based on the embodiments of this application without inventive effort are within the scope of protection of this application.

[0029] It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Furthermore, in the description of this application, terms such as "first," "second," etc., are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.

[0030] It should be noted that, in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, 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 a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0031] In the description of this application, it should be noted that the terms "upper", "lower", "inner", "outer", etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings, or the orientation or positional relationship that the product of this application is usually placed in. They are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application.

[0032] In the description of this application, it should also be noted that, unless otherwise explicitly specified and limited, the terms "set" and "connection" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; and they can refer to the internal connection of two components. Those skilled in the art can understand the specific meaning of the above terms in this application based on the specific circumstances.

[0033] The following detailed description of some embodiments of this application is provided in conjunction with the accompanying drawings. Unless otherwise specified, the following embodiments and features can be combined with each other.

[0034] The following is an explanation of the terms that may be used in this application:

[0035] ERP: an abbreviation for Enterprise Resource Planning, refers to an information management system that is based on information technology and uses a systematic management approach to provide enterprises with information management for procurement, inventory management, production management, sales management, financial management, etc.

[0036] Inventory valuation method: refers to the way a company accounts for the cost of its inventory. Choosing different inventory valuation methods will affect the company's inventory costs, profits, etc.

[0037] Specific identification method: a method of inventory valuation in which the cost of goods sold is the price at which the goods were purchased.

[0038] First-In, First-Out (FIFO) method: A method of inventory valuation in which the cost of the first batch of goods purchased is used as the cost of goods issued.

[0039] Batch Algorithm: In ERP software for industries such as retail and department stores, it is a general term for specific identification and first-in-first-out (FIFO) methods. When goods are received, the corresponding batch cost is recorded. When goods are shipped out, the batch is selected or FIFO is applied to the batch, which can realize specific identification and FIFO.

[0040] Negative inventory: refers to a situation where the quantity recorded in the ERP software is negative. Negative inventory generally indicates a discrepancy between the book value and the physical inventory.

[0041] In industries such as manufacturing, wholesale, and retail, discrepancies often arise between the quantities recorded in ERP systems and the actual quantities due to reasons such as failure to promptly receive goods or loss of physical goods. In such cases, negative inventory occurs when the physical quantity is sufficient but the recorded quantity is insufficient during outbound business scenarios such as requisition, transfer, and sales.

[0042] ERP software has mature solutions for handling negative inventory when the inventory valuation method is moving weighted average or monthly average. However, when the inventory valuation method is specific identification or first-in-first-out (FIFO), both methods use the actual cost of goods received in a batch as the cost of goods sold. Since there is no actual batch for negative inventory sales, most ERP software does not support negative inventory management or manages it in a non-standard manner when the cost calculation method is specific identification or FIFO.

[0043] To overcome the above problems, one possible implementation is as follows:

[0044] Step 1: When an inbound transaction occurs, a new batch is generated. If the subsequent inbound costs, production dates, suppliers, etc. are consistent, then the batches are merged.

[0045] For details, please refer to Tables 1 and 2.

[0046] Business 1: Purchase and warehousing: Quantity 2 units, unit price 10 yuan, batch information after warehousing; Business 2: Purchase and warehousing: Quantity 3 units, unit price 10 yuan, batch information after warehousing. Table 1 shows the data information corresponding to Business 1, and Table 2 shows the data information after combining Business 2 and Business 1.

[0047] batch quantity unit price A 2 10

[0048] Table 1

[0049] batch quantity unit price A 5 10

[0050] Table 2

[0051] Step 2: When negative inventory occurs, the original batch quantity is reduced to a negative value, and the original batch unit price is used as the outbound cost.

[0052] Specifically, please refer to Table 3 (data information) corresponding to Business 3. Business 3: Sales occurred, 8 items were shipped out, and batch information after shipment is provided.

[0053] batch quantity unit price A -3 10

[0054] Table 3

[0055] Step 3: If a receipt occurs again while the inventory is negative, the quantity of the original negative inventory batch will be increased.

[0056] Total value of original negative inventory batch = Original negative inventory value + Inbound value; Unit price of original negative inventory batch = (Original negative inventory batch value + Inbound value) / (Original negative inventory batch quantity + Inbound quantity);

[0057] Please refer to Table 4 corresponding to Business 4.

[0058] batch quantity unit price A 2 15

[0059] Table 4

[0060] Transaction 4: Purchase and warehousing, quantity 5, unit price 12 yuan, total amount after warehousing is 30 (-30+60), unit price is 15 (30 / 2) batch information after warehousing.

[0061] This implementation method has the following drawbacks:

[0062] First, batches are merged, making it impossible to match them with business documents, leading to difficulties in subsequent business traceability. For example, if the original receiving price is incorrect and adjustments to the original receiving document are needed, it's impossible to trace the original receiving batch's inventory and sales quantities, making accurate adjustments impossible. Second, when negative inventory occurs, deductions continue from the original batch, resulting in inaccurate estimated costs under negative inventory, and it's impossible to distinguish between batches generated when negative inventory is issued and batches that are normally received. Third, continuing to receive inventory after negative inventory occurs, continuing to receive inventory from the original batch, causes the unit cost to deviate from the actual receiving cost, and it's impossible to immediately compensate for the previously estimated sales costs.

[0063] This application provides an electronic device, which may be a server device or a computer device. Please refer to... Figure 1 This is a schematic diagram of the structure of an electronic device. The electronic device includes a processor 10, a memory 11, and a bus 12. The processor 10 and the memory 11 are connected via the bus 12. The processor 10 is used to execute executable modules, such as computer programs, stored in the memory 11.

[0064] Processor 10 can be an integrated circuit chip with signal processing capabilities. During implementation, each step of the inventory data management method can be completed through integrated logic circuits in the hardware or software instructions within processor 10. The aforementioned processor 10 can be a general-purpose processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc.; it can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.

[0065] The memory 11 may include high-speed random access memory (RAM) and may also include non-volatile memory, such as at least one disk storage device.

[0066] Bus 12 can be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, or an EISA (Extended Industry Standard Architecture) bus, etc. Figure 1 The symbol is represented by a single double-headed arrow, but this does not mean that there is only one bus 12 or one type of bus 12.

[0067] The memory 11 is used to store programs, such as programs corresponding to an inventory data management device. The inventory data management device includes at least one software functional module that can be stored in the memory 11 in the form of software or firmware, or embedded in the operating system (OS) of the electronic device. Upon receiving an execution instruction, the processor 10 executes the program to implement the inventory data management method.

[0068] The electronic device provided in this application embodiment may also include a communication interface 13. The communication interface 13 is connected to the processor 10 via a bus.

[0069] It should be understood that, Figure 1 The structure shown is only a partial schematic diagram of the electronic device; the electronic device may also include components that are larger than... Figure 1The more or fewer components shown, or having the same Figure 1 The different configurations shown. Figure 1 The components shown can be implemented using hardware, software, or a combination thereof.

[0070] This application provides an inventory data management method for managing a target database. The target database is used to statistically analyze the current inventory quantity of target items and can be applied to, but is not limited to, various applications. Figure 1 For the specific process of the electronic devices shown, please refer to [link / reference]. Figure 2 The inventory data management methods include S111, S112, S114 and S117, which are described in detail below.

[0071] S111, Add the second type of data information to the target database.

[0072] The second type of data is positive inventory information. Positive inventory information can be represented as positive batches.

[0073] Specifically, normal incoming goods are all generated as positive batches, and batches are not allowed to be merged, even if key attributes such as price, supplier, and production date are the same. That is, each batch will generate a separate second-type data entry.

[0074] The second category of data information includes key batch attributes after procurement and warehousing, as shown in Table 5.

[0075]

[0076] Table 5

[0077] When the second type of data information is generated by cross-organizational business such as allocation, distribution, and return to warehouse, the receiving party generates a new positive batch number, which does not inherit the original sending batch number. At the same time, the receiving party batch and the sending party batch are matched one-to-one, and the batch attributes are inherited from the original sending batch, as shown in Table 6.

[0078]

[0079] Table 6

[0080] This method allows for clear management of recipient batch data. Compared to inheriting the original batch number, it can better manage multiple shipments of a single batch by the sender, and also handle situations where there are price increases or inconsistencies during shipment.

[0081] When the second type of data information is generated from transactions such as inventory surplus reporting, a new positive batch is produced. The cost, supplier, and tax rate are taken from the last receipt and purchase information data in sequence to ensure that the source of cost, supplier, and tax rate data is consistent, as shown in Table 7.

[0082] At this point, both the cost and the supplier's price are provisional estimates. The price and supplier's price for the last purchase are closer to the accurate cost and supplier's price.

[0083] Using the earliest currently valid production date as the production date is based on a principle of prudence and is more conducive to expiration date management.

[0084]

[0085] Table 7

[0086] S112, identify whether the target database contains the first type of data information. If yes, proceed to S114; otherwise, skip.

[0087] The first type of data information is negative inventory information.

[0088] Optionally, if outbound transactions continue to occur when inventory is insufficient, a new negative batch, i.e., the first type of data information, is added. The data is not deducted from the original positive batch. This method can avoid interfering with the original normal inbound batches and facilitates the traceability of subsequent positive and negative batches.

[0089] Regarding the key attribute values ​​in the newly added negative batch (first type of data information), this application embodiment also provides a possible implementation method, please refer to Table 8.

[0090] When adding a new negative batch, the cost, supplier, and tax rate are taken from the last receipt and purchase information data in sequence to ensure that the data sources for cost, supplier, and tax rate are consistent.

[0091] With negative inventory, costs, suppliers, tax rates, production dates, etc., are still provisional estimates. The price and supplier of the last purchase are closer to the accurate cost and supplier, so the last receipt data should be used first.

[0092] Using the earliest currently valid production date as the production date is based on a principle of prudence and is more conducive to expiration date management.

[0093]

[0094] Table 8

[0095] If shipments continue under negative inventory conditions, and if the key data such as cost, supplier, tax rate, and production date obtained according to the default rules are consistent, then the negative batch will continue to be deducted. Since negative batches are abnormal data due to inaccurate accounting records, the system needs to minimize the number of negative batches. Therefore, negative batches will be merged instead of adding new negative batches.

[0096] It should be understood that the estimated purchase cost in negative inventory information may contain errors. Therefore, if the first type of data information is identified in the target database, S114 can be executed to correct the first type of data information based on the second type of data information. Otherwise, it can be skipped.

[0097] Optionally, the presence or absence of the outbound quantity can be used to identify whether it belongs to the first or second category of data information.

[0098] S114, Correct the first type of data information based on the second type of data information.

[0099] Optionally, correction can be understood as offsetting, that is, increasing the quantity of goods received in the negative batch (first type of data information) by X and decreasing the quantity of goods received in the positive batch (second type of data information) by X. For example, if the first quantity received is -2 and the second quantity received is 8, then X is 2. After offsetting, the first quantity received is 0 and the second quantity received is 6. By offsetting, the deviation caused by incomplete and inaccurate estimates of purchase costs in cost statistics or profit statistics can be avoided.

[0100] S117, If the first type of inbound cost change information is not 0, establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information.

[0101] The first category of inbound cost change information refers to inbound cost changes resulting from corrections.

[0102] Optionally, the first type of inventory cost change information is the gross profit adjustment amount, which is calculated as: positive batch outbound amount + negative batch inbound amount = gross profit adjustment amount.

[0103] The original negative batch outbound amount is the estimated cost, while the positive batch inbound amount is the accurate cost. The difference between the two is the difference between the estimated cost and the actual cost. The gross profit of the original negative inventory sales needs to be adjusted, and the main business cost needs to be reduced financially.

[0104] The mapping relationship allows us to observe cost changes, which facilitates later statistical verification.

[0105] In summary, the inventory data management method provided in this application involves correcting the first type of data information based on the second type of data information when adding a second type of data information to a target database, provided that the first type of data information is identified as existing in the target database. The first type of data information represents negative inventory information, and the second type represents positive inventory information. If the first type of inventory cost change information is not zero, a mapping relationship is established between the first type of inventory cost change information and the first and second types of data information. The first type of inventory cost change information refers to the inventory cost change information resulting from the correction. This method automatically corrects data information, saving time and effort, and also allows for observation of cost change information through the mapping relationship, facilitating subsequent statistical verification.

[0106] Optionally, the first type of data information includes the first inbound quantity and the first inbound cost, and the second type of data information includes the second inbound quantity and the second inbound cost. The first inbound quantity is less than 0, and the second inbound quantity is greater than 0. The first object is the first type of data information that serves as the correction object. When the first inbound cost and the second inbound cost of the first object are different, such as... Figure 3 As shown, before establishing the mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information, the inventory data management method also includes: S115 and S116, which are described in detail below.

[0107] S115, the smaller of the first and second quantity of the first object is determined as the first correction quantity.

[0108] The first object is any set of first-class data information.

[0109] S116, determine and record the change information of the first type of warehousing cost based on the first correction quantity, the first warehousing cost of the first object and the second warehousing cost.

[0110]

[0111] Table 9

[0112] Specifically, please refer to Table 9. The actual business sequence is that 10 units are first put into storage, and then 6 units are sold. Therefore, the actual outbound cost is 60, while the current cost when selling negative inventory is 51. The total amount of the four detailed data in Table 9 for this transaction is -30 + 24 - 30 + 27 = -9 (first type of inbound cost change information). Therefore, the sales cost increases by 9 yuan, and the gross profit decreases by 9 yuan.

[0113] Financial bookkeeping:

[0114] Debit: Cost of Goods Sold 9;

[0115] Credit: Inventory Goods 9.

[0116] Optionally, a mapping relationship can be established between detailed data and the first and second types of data information for easy viewing.

[0117] In one possible implementation, for ease of management, negative batches are deducted using a first-in, first-out (FIFO) rule. This application also provides another possible implementation; please refer to further details. Figure 3 Inventory data management methods also include: S113, which is described in detail below.

[0118] S113, the earliest generated first-class data information that has not yet been completely offset is identified as the first object.

[0119] This allows negative batches to be reversed using the first-in, first-out (FIFO) rule.

[0120] Reversal operations are based on the reverse of the original order, so they require reversing the original batch. If the original outbound document resulted in a negative inventory outbound, creating a negative batch, the reversal requires receiving the goods at the original outbound cost price and increasing the quantity of the original negative batch. However, inventory adjustments may change the current batch's unit price, leading to a difference between the negative batch's unit price and the original outbound unit price. Based on the principle that batch unit prices cannot be moved averaged, this process incurs an adjustment amount, which reduces gross profit. Because the existence of a negative batch during receipt leads to an increase in the negative batch quantity, when reversing the original negative batch outbound document, based on the principle that positive and negative batch attributes cannot be changed, the negative batch quantity cannot increase further once it reaches zero. At this point, a new positive batch is created to ensure the outbound reversal operation continues.

[0121] exist Figure 2 Based on this, regarding how to reverse the original negative batch outbound documents, the embodiments of this application also provide a possible implementation method, please refer to... Figure 4 The inventory data management methods also include: S101 to S110, which are described in detail below.

[0122] S101: When a third type of data information generated by a returned order is identified, determine whether there is a matching first type of data information. If yes, proceed to S102; otherwise, proceed to S111.

[0123] The first type of data matched is the negative inventory information generated when returned orders are shipped out.

[0124] It should be understood that if there is matching first-class data information, the matching first-class data information needs to be cancelled first, and S102 is executed. Otherwise, the new second-class data information can be added directly to the target database based on the third-class data information generated by the return order, that is, S111 is executed.

[0125] S102, determine whether the first entry cost in the first type of matched data information is the same as the third entry cost in the third type of data information. If yes, proceed to S103; otherwise, proceed to S106.

[0126] The first type of matching data information is the negative inventory information generated when the returned order is shipped out. The third type of data information includes the third inbound quantity and the third inbound cost. The third inbound quantity represents the quantity of the target item in the returned order and is positive. The third inbound cost represents the outbound cost of the target item in the returned order before it was returned.

[0127] It should be understood that in business operations, the unit price of the current batch may change due to reasons such as inventory adjustments, resulting in a difference between the unit price of the negative batch and the original unit price at the time of shipment. Therefore, the first inbound cost of the first type of data information will change.

[0128] S103, determine whether the first quantity of data entered into the database in the first category of matched data is greater than the third quantity of data entered into the database. If yes, proceed to S104; otherwise, proceed to S105.

[0129] It should be understood that if the first inbound quantity in the first type of matched data is greater than the third inbound quantity, it means that the original order price (third inbound cost) and the current price of the negative batch (first inbound cost) are the same, and the negative batch quantity is sufficient, so it can be directly offset, i.e., S104 is executed. Conversely, if the quantity is less than the third inbound quantity, it means that the negative batch quantity is insufficient, and S105 is executed.

[0130] S104, subtract the third entry quantity from the first entry quantity in the matched first type of data information, and modify the first entry cost of the matched first type of data information accordingly.

[0131] Optionally, due to differences in precision, if the quantity of the first batch after modification is 0 but the amount is not 0, an adjustment amount will be generated. An adjustment amount will also be generated when the quantity and amount are inconsistent. As shown in Table 10: 3 items are reversed, with a unit price of 3.33 yuan and an amount of 9.99 yuan (after adding a negative batch, the quantity is 0 but the amount is not 0). A negative batch is added.

[0132]

[0133] Table 10

[0134] It should be understood that when generating an adjustment amount, it is necessary to establish a mapping relationship between the adjustment amount or the table showing the generation of the adjustment amount and the matching first type of data information, so as to facilitate later retrieval and viewing.

[0135] S105, adjust the first entry quantity in the matched first type of data information to 0, and adjust the first entry cost of the matched first type of data information to 0.

[0136] It should be understood that for a sufficient portion of the first type of matching data information:

[0137] Outbound write-off amount = sufficient quantity * original outbound unit price.

[0138] If there is a difference in precision, and the amount is not 0 when the quantity is 0, then an adjustment amount will be generated, as above.

[0139] For the insufficient portion of the first type of matching data, after S105, S111 is executed to add the second type of data to the target database. The newly added second type of data includes the second inbound quantity and the second inbound cost. The second inbound quantity is the difference between the third inbound quantity and the first inbound quantity in the matched first type of data, and the second inbound cost is the third inbound cost.

[0140] Optionally, a new positive batch can be added based on the amount of the shortfall to be offset and the original outbound unit price. The amount of the shortfall to be offset = the total outbound offset amount - the amount of the sufficient portion to be offset.

[0141] Example: 3 units are cancelled, with a unit price of 3.33 yuan and a total amount of 9.99 yuan (after adding the negative batch, the quantity is 0, but the amount is not 0).

[0142] Add negative batches:

[0143]

[0144] Table 11 New Positive Batch (Second Category Data Information):

[0145]

[0146] Table 12

[0147] S106, determine whether the first quantity of data entered into the database in the first category of matched data is greater than the third quantity of data entered into the database. If yes, proceed to S107; otherwise, proceed to S109.

[0148] Specifically, the same applies to S103.

[0149] S107, Based on the third inbound quantity, the first inbound cost in the matched first type of data information, and the third inbound cost, determine and record the second type of inbound cost change information.

[0150] The second type of information on changes in warehousing costs is used to adjust gross profit. S107 and S116 are similar.

[0151] S108, subtract the third entry quantity from the first entry quantity in the matched first type of data information, and modify the first entry cost of the matched first type of data information accordingly.

[0152] Specifically, the same applies to S114.

[0153] S109, determine and record the change information of the third type of inbound cost based on the first inbound quantity, the first inbound cost in the matched first type of data information, and the third inbound cost.

[0154] The third type of information on changes in warehousing costs is used to adjust gross profit. Specifically, S109 and S116 are handled similarly.

[0155] S110, adjust the first entry quantity in the first type of matched data information to 0, and adjust the first entry cost of the first type of matched data information to 0.

[0156] Specifically, the process is similar to S105. After S110, S111 is executed to add the second type of data information to the target database. The second type of data information includes the second inbound quantity and the second inbound cost. The second inbound quantity is the difference between the third inbound quantity and the first inbound quantity in the matched first type of data information, and the second inbound cost is the third inbound cost.

[0157] Example: 10 returned items, each priced at 10 yuan.

[0158] The first type of data information (negative batch):

[0159]

[0160] Table 13 New Positive Batch:

[0161]

[0162] Table 14

[0163] It should be noted that in the inventory data management method provided in this application: the positive and negative attributes of data information cannot be changed. Data information management distinguishes between positive batches (second type of data information) and negative batches (first type of data information). Inbound transactions all generate positive batches; when a negative inventory occurs and an outbound transaction occurs, a negative batch is generated. The positive and negative batch attributes cannot be changed. The quantity variation range for positive batches is 0 to +∞; the quantity variation range for negative batches is 0 to -∞. The immutability of positive and negative batch attributes allows for differentiation between batches added in inbound and outbound transactions, facilitating traceability between business documents and batches. Batch costs cannot be weighted averaged; increasing or decreasing the quantity in an existing batch cannot change the batch cost unit price. If the unit price is inconsistent, an adjustment amount is generated. The batch cost cannot be weighted averaged, allowing for clear traceability of the batch cost unit price change history.

[0164] The inventory data management method provided in this application, compared to other batch-based cost algorithms, manages positive and negative batches independently, prohibits batch merging, and allows for batch association and key attribute inheritance between different institutions. This ensures a one-to-one correspondence between business documents and financial batches, making batch outbound rules clearer and batch outbound costs easier to trace. By adding negative batches under negative inventory and allocating positive and negative batches after receipt, the estimated outbound cost under negative inventory is closer to the accurate cost. Furthermore, the estimated outbound cost, gross profit, and financial differences are adjusted through the total amount allocated to negative batches, making outbound costs and gross profit more accurate and facilitating subsequent batch cost traceability. The method handles the reversal of negative inventory outbound transactions by adding positive batches when inventory is insufficient and adjusting amounts due to differences. This allows the system to reverse the batch cost based on the original outbound order. In scenarios where batch costs change, it can compensate for outbound costs during the period, ensuring that outbound reversal transactions are still supported under batches.

[0165] Please see Figure 5 , Figure 5 An inventory data management device is provided as an embodiment of this application. Optionally, the inventory data management device is applied to the electronic device described above.

[0166] The inventory data management device includes a processing unit 201 and a mapping unit 202.

[0167] Processing unit 201 is used to modify the first type of data information based on the second type of data information when adding the second type of data information to the target database if the first type of data information is detected in the target database.

[0168] The first type of data information is negative inventory information, and the second type of data information is positive inventory information;

[0169] Mapping unit 202 is used to establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information when the first type of inbound cost change information is not 0.

[0170] The first category of inbound cost change information refers to inbound cost changes resulting from corrections.

[0171] Optionally, the processing unit 201 may execute S101 to S116 as described above, and the mapping unit 202 may execute S117 as described above.

[0172] It should be noted that the inventory data management device provided in this embodiment can execute the method flow shown in the above method flow embodiment to achieve the corresponding technical effects. For the sake of brevity, any parts not mentioned in this embodiment can be referred to the corresponding content in the above embodiments.

[0173] This application also provides a storage medium storing computer instructions and programs, which, when read and executed, perform the inventory data management method described above. The storage medium may include memory, flash memory, registers, or a combination thereof.

[0174] The following provides an electronic device, which can be an inventory data management device, such as a computer or server. Figure 1 As shown, the above-described inventory data management method can be implemented. Specifically, the electronic device includes: a processor 10, a memory 11, and a bus 12. The processor 10 may be a CPU. The memory 11 is used to store one or more programs, which, when executed by the processor 10, perform the inventory data management method of the above embodiment.

[0175] In the embodiments provided in this application, it should be understood that the disclosed apparatus and methods can also be implemented in other ways. The apparatus embodiments described above are merely illustrative. For example, the flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions marked in the blocks may occur in a different order than those marked in the drawings. For example, two consecutive blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram and / or flowchart, and combinations of blocks in block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or action, or using a combination of dedicated hardware and computer instructions.

[0176] In addition, the functional modules in the various embodiments of this application can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part.

[0177] If the aforementioned functions are implemented as software functional modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0178] The above description is merely a preferred embodiment of this application and is not intended to limit this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.

[0179] It will be apparent to those skilled in the art that this application is not limited to the details of the exemplary embodiments described above, and that this application can be implemented in other specific forms without departing from the spirit or essential characteristics of this application. Therefore, the embodiments should be considered illustrative and non-limiting in all respects, and the scope of this application is defined by the appended claims rather than the foregoing description. Thus, all variations falling within the meaning and scope of equivalents of the claims are intended to be included within this application. No reference numerals in the claims should be construed as limiting the scope of the claims.

Claims

1. An inventory data management method, characterized in that, The method is used to manage a target database, which is used to count the current inventory quantity of target items. When adding the second type of data information to the target database, if the first type of data information is detected in the target database, the first type of data information is corrected based on the second type of data information. The first type of data information is negative inventory information, and the second type of data information is positive inventory information; If the first type of inbound cost change information is not zero, establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information; Among them, the first type of inbound cost change information is the inbound cost change information caused by the correction; The first type of data information includes a first inbound quantity and a first inbound cost; the second type of data information includes a second inbound quantity and a second inbound cost; the first inbound quantity is less than 0; the second inbound quantity is greater than 0; the first object is the first type of data information used as a correction object; when the first inbound cost of the first object is different from the second inbound cost, before establishing the mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information, the method further includes: The smaller of the first quantity of the first object and the second quantity of the first object is determined as the first correction quantity, wherein the first object is any set of first type data information; Based on the first correction quantity, the first warehousing cost of the first object, and the second warehousing cost, determine and record the first type of warehousing cost change information; Before correcting the first type of data information based on the second type of data information, the method further includes: identifying the earliest generated first type of data information that has not yet been completely offset as the first object.

2. The inventory data management method as described in claim 1, characterized in that, The method further includes: If a third type of data information generated by a returned order is identified, and a matching first type of data information exists, it is determined whether the first inbound cost in the matching first type of data information is the same as the third inbound cost in the third type of data information. The first type of matching data information is the negative inventory information generated when the return order is shipped out. The third type of data information includes the third inbound quantity and the third inbound cost. The third inbound quantity represents the quantity of the target item in the return order and is positive. The third inbound cost represents the outbound cost of the target item in the return order before it is returned. If they are the same, then determine whether the first number of data items in the first category of matched data is greater than the third number of data items. If the value is greater than the first entry quantity in the first category of matched data information, the third entry quantity is subtracted from the first entry quantity, and the first entry cost of the first category of matched data information is modified accordingly.

3. The inventory data management method as described in claim 2, characterized in that, If the first inbound cost in the matched first type of data information is the same as the third inbound cost in the matched third type of data information, and the first inbound quantity in the matched first type of data information is less than or equal to the third inbound quantity, the method further includes: The first entry quantity in the first type of matched data information is adjusted to 0, and the first entry cost of the first type of matched data information is adjusted to 0. Add a second type of data information to the target database; The second type of data information includes a second inbound quantity and a second inbound cost. The second inbound quantity is the difference between the third inbound quantity and the first inbound quantity in the matching first type of data information. The second inbound cost is the third inbound cost.

4. The inventory data management method as described in claim 2, characterized in that, If the first inbound cost in the matched first type of data information is different from the third inbound cost in the third type of data information, the method further includes: Determine whether the first inbound quantity in the first type of matched data information is greater than the third inbound quantity; If it is greater than the third inbound quantity, the second inbound cost change information is determined and recorded based on the third inbound quantity, the first inbound cost in the matched first type of data information, and the third inbound cost. The second inbound cost change information is used to correct the gross profit. Subtract the third entry quantity from the first entry quantity in the matched first type of data information, and modify the first entry cost of the matched first type of data information accordingly.

5. The inventory data management method as described in claim 4, characterized in that, If the first inbound cost in the matched first type of data information is different from the third inbound cost in the matched third type of data information, and the first inbound quantity in the matched first type of data information is less than or equal to the third inbound quantity, the method further includes: Based on the first inbound quantity, the first inbound cost in the matched first type of data information, and the third inbound cost, the third type of inbound cost change information is determined and recorded. The third type of inbound cost change information is used to adjust the gross profit. The first entry quantity in the first type of matched data information is adjusted to 0, and the first entry cost of the first type of matched data information is adjusted to 0. Add a second type of data information to the target database; The second type of data information includes a second inbound quantity and a second inbound cost. The second inbound quantity is the difference between the third inbound quantity and the first inbound quantity in the matching first type of data information. The second inbound cost is the third inbound cost.

6. An inventory data management device, characterized in that, The device is used to manage a target database, which is used to count the current inventory quantity of target items. The device includes: The processing unit is configured to, when adding second type of data information to the target database, if it is recognized that first type of data information exists in the target database, correct the first type of data information based on the second type of data information; The first type of data information is negative inventory information, and the second type of data information is positive inventory information; The mapping unit is used to establish a mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information when the first type of inbound cost change information is not zero. Among them, the first type of inbound cost change information is the inbound cost change information caused by the correction; The first type of data information includes a first inbound quantity and a first inbound cost; the second type of data information includes a second inbound quantity and a second inbound cost; the first inbound quantity is less than 0; the second inbound quantity is greater than 0; the first object is the first type of data information that serves as the correction object; when the first inbound cost of the first object is different from the second inbound cost, before establishing the mapping relationship between the first type of inbound cost change information and the first type of data information and the second type of data information, the processing unit is further configured to determine the smaller of the first inbound quantity and the second inbound quantity of the first object as the first correction quantity; wherein, the first object is any set of first type of data information; and the first type of inbound cost change information is determined and recorded based on the first correction quantity, the first inbound cost of the first object, and the second inbound cost. Before correcting the first type of data information based on the second type of data information, the inventory data management device is also used to identify the earliest generated first type of data information that has not yet been completely offset as the first object.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the method as described in any one of claims 1-5.

8. An electronic device, characterized in that, include: Processor and memory, the memory being used to store one or more programs; When the one or more programs are executed by the processor, the method as described in any one of claims 1-5 is implemented.

Images