Inventory material cost difference accounting method, system, electronic device and storage medium
By calculating the correct weighted unit price and the difference amount of inventory materials, the efficiency and accuracy of material cost difference accounting is solved, and the cost difference from inbound to outbound is clearly displayed.
Patent Information
- Application Number
- CN202411161648.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-22
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2044-08-22
AI Technical Summary
The prior art cannot clearly and intuitively reflect the specific cost-price differences between materials from procurement and inlet to out-of-warehouse, making it difficult for users to obtain cost-difference information.
By calculating the current corrected weighted unit price of the target inventory material, based on the current material receipt information and historical material receipt information, the difference in outbound and entry differences amount is determined, and the cost difference is then calculated.
It improves the efficiency and accuracy of inventory material cost difference accounting, and can clearly and intuitively understand the cost price difference when collecting the material ticket.
Smart Images

Figure CN118691204B_ABST
Abstract
Description
Background Art
[0002] At present, the difference between the purchase price and the invoice price of materials is usually directly processed uniformly, and the cost difference information of specific materials cannot be reflected. As a result, users cannot clearly and intuitively know the specific cost price difference from purchase to delivery when the material is invoiced.
[0003] Therefore, it is urgent to provide a technical solution to solve the above problems. Summary of the invention
[0004] In order to solve the above technical problems, the present invention provides a method, system, electronic device and storage medium for calculating inventory material cost differences.
[0005] In a first aspect, the present invention provides a method for calculating inventory material cost differences, and the technical solution of the method is as follows:
[0006] When the current purchase receipt of the target inventory material is obtained, at least one current modified weighted unit price of the target inventory material is calculated based on the current material receipt information corresponding to the current purchase receipt;
[0007] According to the current material receipt information and all current modified weighted unit prices of the target inventory material, a current outbound difference amount and a current inbound difference amount for characterizing the cost difference of the target inventory material are determined.
[0008] The beneficial effects of the inventory material cost difference accounting method of the present invention are as follows:
[0009] The method of the present invention can clearly and intuitively obtain the specific cost price difference from material purchase to material delivery when the material is invoiced, thereby improving the efficiency and accuracy of inventory material cost difference accounting.
[0010] On the basis of the above scheme, the inventory material cost difference accounting method of the present invention can also be improved as follows.
[0011] In an optional manner, the current material receipt information includes: the current material receipt time point, the current material storage time point, the current material receipt quantity and the current material receipt unit price; and the step of calculating at least one current modified weighted unit price of the target inventory material based on the current material receipt information corresponding to the current purchase receipt includes:
[0012] Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain a determination result;
[0013] When the judgment result is no, the current revised weighted unit price at the current material entry time point is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity;
[0014] Based on the material entry quantity, material entry unit price, material remaining quantity before material entry and the current revised weighted unit price of the previous material entry time point at any material entry time point between the current material entry time point and the current material invoice collection time point except the current material entry time point, the current revised weighted unit price of the material entry time point is calculated until the current revised weighted unit price of each material entry time point of the target inventory material between the material entry time point and the material invoice collection time point is calculated; wherein, the previous material entry time point of the first material entry time point among all the material entry time points except the current material entry time point is the current material entry time point.
[0015] In an optional manner, the step of determining the current outbound difference amount and the current inbound difference amount for characterizing the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material includes:
[0016] The current invoice difference amount is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material invoice time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity, and the original weighted unit price and the material invoice quantity at the current material invoice time point;
[0017] Based on the material outbound quantity at any material outbound time point between the current material inbound time point and the current material invoice collection time point, and the current modified weighted unit price and the original weighted unit price of the previous material inbound time point closest to the material outbound time point, calculate the outbound difference amount at the material outbound time point, until the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point is calculated, and according to the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point, calculate the current outbound difference amount.
[0018] In an optional manner, the method further includes:
[0019] The verification balance amount is calculated based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and the actual balance amount is calculated based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material receipt time point when the current material inventory quantity is the same;
[0020] Based on the difference between the actual balance amount and the verified balance amount, it is determined whether the cost difference accounting of the target inventory material is correct.
[0021] In a second aspect, the present invention provides an inventory material cost difference accounting system, and the technical solution of the system is as follows:
[0022] It includes: a first accounting module and a second accounting module;
[0023] The first accounting module is used to: when the current purchase receipt of the target inventory material is obtained, calculate at least one current modified weighted unit price of the target inventory material based on the current material receipt information corresponding to the current purchase receipt;
[0024] The second accounting module is used to determine the current outbound difference amount and the current inbound difference amount used to characterize the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material.
[0025] The beneficial effects of the inventory material cost difference accounting system of the present invention are as follows:
[0026] The system of the present invention can clearly and intuitively obtain the specific cost price difference from material purchase to material delivery when the material is invoiced, thereby improving the efficiency and accuracy of inventory material cost difference accounting.
[0027] Based on the above solution, the inventory material cost difference accounting system of the present invention can also be improved as follows.
[0028] In an optional manner, the current material receipt information includes: the current material receipt time, the current material storage time, the current material receipt quantity and the current material receipt unit price; the first accounting module is specifically used to:
[0029] Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain a determination result;
[0030] When the judgment result is no, the current revised weighted unit price at the current material entry time point is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity;
[0031] Based on the material entry quantity, material entry unit price, material remaining quantity before material entry and the current revised weighted unit price of the previous material entry time point at any material entry time point between the current material entry time point and the current material invoice collection time point except the current material entry time point, the current revised weighted unit price of the material entry time point is calculated until the current revised weighted unit price of each material entry time point of the target inventory material between the material entry time point and the material invoice collection time point is calculated; wherein, the previous material entry time point of the first material entry time point among all the material entry time points except the current material entry time point is the current material entry time point.
[0032] In an optional manner, the second accounting module is specifically used to:
[0033] The current invoice difference amount is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material invoice time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity, and the original weighted unit price and the material invoice quantity at the current material invoice time point;
[0034] Based on the material outbound quantity at any material outbound time point between the current material inbound time point and the current material invoice collection time point, and the current modified weighted unit price and the original weighted unit price of the previous material inbound time point closest to the material outbound time point, calculate the outbound difference amount at the material outbound time point, until the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point is calculated, and according to the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point, calculate the current outbound difference amount.
[0035] In an optional manner, the method further includes: a verification module; the verification module is used to:
[0036] The verification balance amount is calculated based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and the actual balance amount is calculated based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material receipt time point when the current material inventory quantity is the same;
[0037] Based on the difference between the actual balance amount and the verified balance amount, it is determined whether the cost difference accounting of the target inventory material is correct.
[0038] In a third aspect, a technical solution of an electronic device of the present invention is as follows:
[0039] The method comprises a memory, a processor and a program stored in the memory and running on the processor. When the processor executes the program, the steps of the inventory material cost difference accounting method of the present invention are implemented.
[0040] In a fourth aspect, the present invention provides a computer-readable storage medium having the following technical solution:
[0041] Instructions are stored in the computer-readable storage medium. When the computer-readable storage medium reads the instructions, the computer-readable storage medium executes the steps of the inventory material cost difference accounting method of the present invention.
[0042] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS
[0043] The accompanying drawings are only used to illustrate the embodiments and are not to be considered as limiting the present invention. In addition, the same reference symbols are used to represent the same components throughout the accompanying drawings. In the accompanying drawings:
[0044] Figure 1 A schematic diagram of a flow chart of an embodiment of a method for calculating inventory material cost differences of the present invention;
[0045] Figure 2 is a schematic flow chart of step S2;
[0046] Figure 3 It is a structural schematic diagram of an embodiment of an inventory material cost difference accounting system of the present invention;
[0047] Figure 4 The figure is a schematic structural diagram of an embodiment of an electronic device of the present invention. DETAILED DESCRIPTION
[0048] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the present invention can be implemented in various forms and should not be limited to the embodiments set forth herein.
[0049] Figure 1 The flowchart of an embodiment of a method for calculating the difference in inventory material costs provided by the present invention is shown. The method for calculating the difference in inventory material costs can be executed by an electronic device such as a terminal device or a server. The terminal device can be any fixed or mobile terminal such as a user equipment (UE), a mobile device, a user terminal, a terminal, a cellular phone, a cordless phone, a personal digital assistant (PDA), a handheld device, a computing device, a vehicle-mounted device, a wearable device, etc. The server can be a single server or a server cluster composed of multiple servers. Any electronic device can implement the method for calculating the difference in inventory material costs by calling computer-readable instructions stored in a memory through a processor. Figure 1 As shown, the following steps are included:
[0050] S1. When the current purchase receipt of the target inventory material is obtained, at least one current modified weighted unit price of the target inventory material is calculated based on the current material receipt information corresponding to the current purchase receipt.
[0051] The target inventory material is any type of material in the inventory, and there is no restriction here. The current purchase receipt is the latest purchase receipt collected at the current moment. The current material receipt information includes but is not limited to: the current material receipt time point, the current material storage time point, the current material receipt quantity and the current material receipt unit price. For example, the current material receipt information of a certain material includes: the current material receipt time point (January 5), the current material storage time point (January 1), the current material receipt quantity (50 pieces) and the current material receipt unit price (2.5 yuan / piece). The number of the current revised weighted unit price is the same as the number of material storage time points included between the current material storage time point and the current material receipt time point. For example, the material storage time points between the current material storage time point (January 1) and the current material receipt time point (January 5) are January 1 and January 3. Since the number of material storage time points is two, the number of the current revised weighted unit price is two.
[0052] S2. According to the current material receipt information and all the current modified weighted unit prices of the target inventory materials, determine the current outbound difference amount and the current inbound difference amount used to characterize the cost difference of the target inventory materials.
[0053] The current outgoing difference amount is the difference amount generated during the outgoing process (between the time when the current material enters the warehouse and the time when the current material is billed) of the target inventory material calculated at the current moment. The current incoming difference amount is the difference amount generated during the incoming process (between the time when the current material enters the warehouse and the time when the current material is billed) of the target inventory material calculated at the current moment.
[0054] In an optional manner, the step of calculating at least one current modified weighted unit price of the target inventory material based on the current material receipt information corresponding to the current purchase receipt includes:
[0055] Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain the judgment result.
[0056] Among them, the material entry unit price is: the unit price of the target inventory material when it is entered into the warehouse at a certain time point. For example, if the material receipt unit price of a certain material on January 5 is 5 yuan / piece, and the corresponding current material entry time point is January 1, and the material entry unit price of the material on January 1 is 5 yuan / piece, then it is judged to be the same (the judgment result is yes); if the material entry unit price of the material on January 1 is 2.5 yuan / piece, then it is judged to be different (the judgment result is no).
[0057] When the judgment result is no, the current revised weighted unit price at the current material entry time point is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity except the current material invoice quantity and the historical material invoice quantity.
[0058] Among them, the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material storage time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity are substituted into the first preset formula to calculate the current modified weighted unit price at the current material storage time point. The first preset formula is: ; The current modified weighted unit price at the current material entry time. The current material invoice price. The current material receipt quantity. The unit price of the i-th historical material receipt corresponding to the current material entry time point. The number of invoices received for the i-th historical material corresponding to the current material entry time point. The total quantity of the historical material receipt unit price corresponding to the current material entry time point. and is an integer, is the original weighted unit price corresponding to the current material entry time point, The material quantity corresponding to the current material entry time point excluding the current material receipt quantity and the historical material receipt quantity. For example, assuming that the current material receipt time point of a material is January 5, and the corresponding current material entry time point is January 1, the material entry quantity on January 1 is 100 pieces, the current material receipt price is 2.5 yuan / piece, the current material receipt quantity is 50 pieces, the total number of historical material receipt prices corresponding to the current material entry time point is 0, the original weighted price corresponding to January 1 is 3 yuan / piece, and the material quantity excluding the current material receipt quantity (50 pieces) and the historical material receipt quantity (0 pieces) is 50 pieces, then the current revised weighted price at the current material entry time point is It is 2.75 yuan per piece.
[0059] Based on the material entry quantity, material entry unit price, remaining quantity of materials before material entry and current revised weighted unit price of the previous material entry time point between the current material entry time point and the current material invoice collection time point except the current material entry time point, the current revised weighted unit price of the material entry time point is calculated until the current revised weighted unit price of the target inventory material at each material entry time point between the material entry time point and the material invoice collection time point is calculated.
[0060] Among them, the previous material entry time point of the first material entry time point among all material entry time points except the current material entry time point is the current material entry time point. For example, the current material entry time point is January 1, and all material entry time points except January 1 include January 3 and January 4, then: the first material entry time point among all material entry time points except the current material entry time point is January 3, and its previous material entry time point is January 1, that is, the current material entry time point.
[0061] Specifically, the material entry quantity, material entry unit price, material remaining quantity before material entry, and the current modified weighted unit price of the material entry time point before the material entry time point are substituted into the second preset formula to obtain the current modified weighted unit price of the material entry time point. The second preset formula is: ; For the The current modified weighted unit price of the material at the time of entry into the warehouse. For the The current modified weighted unit price of the material at the time of entry into the warehouse. and is an integer, For the The remaining quantity of the material before the material is put into storage at the time point of material entry. For the The unit price of the material at the time when the material enters the warehouse. For the The quantity of materials entering the warehouse at a certain time.
[0062] For example, the current material receipt time of a certain material is January 5, and the corresponding current material storage time is January 1. The material storage quantity on January 1 is 100 pieces, and the current material receipt price is 2.5 yuan / piece. The current material receipt quantity is 50 pieces. The outgoing quantity on January 2 is 50 pieces. On January 3, 100 pieces are stored. The material storage price is 1.5 yuan / piece. The current modified weighted price on January 1 is The price is 2.75 yuan per piece. The remaining quantity of materials before the materials are put into storage on January 3 is 50 (100-50=50) pieces. The revised weighted unit price on January 3 is: 1.917 ((2.75×50+1.5×100) / 150≈1.917).
[0063] In an alternative approach, Figure 2 As shown, S2 includes:
[0064] S21. Calculate the current inventory difference amount based on the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material inventory entry time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity, and the original weighted unit price and material inventory quantity at the current material inventory entry time point.
[0065] Among them, the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material storage time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity, and the original weighted unit price and the material storage quantity at the current material storage time point are substituted into the third preset formula to calculate the current storage difference amount. The third preset formula is: ; The original weighted unit price of the current material at the time of entry into the warehouse. is the quantity of materials entering the warehouse at the current material entry time point, The current receipt difference amount.
[0066] For example, the current material receipt time of a certain material is January 5, and the corresponding current material storage time is January 1. The material storage quantity on January 1 is 100 pieces, and the original weighted unit price on January 1 is 3 yuan / piece. The current material receipt quantity is 50 pieces, and the current material receipt price is 2.5 yuan / piece. There is no historical material receipt price and the corresponding historical material receipt quantity. The material quantity other than the current material receipt quantity and the historical material receipt quantity is 50 pieces. The third preset formula can be used to calculate the current storage difference amount. It is -25 yuan.
[0067] For another example, the current material receipt time of a certain material is January 7, and the corresponding current material storage time is January 1. The material storage quantity on January 1 is 100 pieces, the original weighted unit price on January 1 is 3 yuan / piece, the current material receipt quantity is 50 pieces, the current material receipt price is 2 yuan / piece, the historical (January 5) material receipt price is 2.5 yuan / piece, and the historical material receipt quantity on January 5 is 50 pieces. The material quantity other than the current material receipt quantity and the historical material receipt quantity is 0. The third preset formula can be used to calculate the current storage difference amount. It is -75 yuan.
[0068] S22. Calculate the outbound difference amount of the material at any outbound time point between the current material entry time point and the current material receipt time point based on the material outbound quantity and the current modified weighted unit price and the original weighted unit price of the previous material entry time point closest to the material outbound time point, until calculating the outbound difference amount of each material outbound time point between the current material entry time point and the current material receipt time point, and calculate the current outbound difference amount based on the outbound difference amount of each material outbound time point between the current material entry time point and the current material receipt time point.
[0069] Among them, the material outbound quantity at any material outbound time point between the previous material inbound time point and the current material receipt time point, as well as the current modified weighted unit price and the original weighted unit price at the previous material inbound time point closest to the material outbound time point are substituted into the fourth preset formula to calculate the outbound difference amount at the material outbound time point. The fourth preset formula is: ; For the The difference amount of the outbound delivery at the time of the delivery of each material. For the The quantity of materials shipped out at the material shipping time point, For the The current modified weighted unit price of the previous material at the closest time point to the material's outbound time point. For the The original weighted unit price of the previous material at the closest time point to the material's outbound time point. For the The outbound difference amount at the time when the material is outbound.
[0070] For example, the material outgoing quantity on January 2 is 50 pieces, the current modified weighted unit price on January 1 (the closest time point of the previous material entry) is 2.75 yuan / piece, and the original weighted unit price on January 1 is 3 yuan / piece, then the outgoing difference amount on January 2 is -12.5 yuan. For another example, the material outgoing quantity on January 4 is 100 pieces, the current modified weighted unit price on January 3 (the closest time point of the previous material entry) is 1.917 yuan / piece, and the original weighted unit price on January 3 is 2 yuan / piece, then the outgoing difference amount on January 4 is -8.334 yuan.
[0071] In an optional manner, the method further includes:
[0072] S3. Calculate the verification balance amount based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and calculate the actual balance amount based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material inventory quantity and the current material receipt time point.
[0073] Among them, the current inbound difference amount, the current outbound difference amount, the total inbound amount and the total outbound amount between the current material inbound time point and the current material receipt time point are substituted into the fifth preset formula to calculate the verification balance amount. The fifth preset formula is: ; To verify the balance, is the total amount of deposits, is the total outbound amount, The total quantity of the material at the time of shipment.
[0074] The actual balance amount is calculated based on the product of the current material inventory quantity and the current modified weighted unit price of the previous material entry time point that is closest to the current material receipt time point.
[0075] For example, the difference amount of outgoing warehouse on January 2 is -12.5 yuan, and the difference amount of outgoing warehouse on January 4 is -8.334 yuan. The quantity of materials received on January 1 is 100 pieces, and the original weighted unit price on January 1 is 3 yuan / piece. 100 pieces were received on January 3, and the original weighted unit price was 1.5 yuan / piece, and the total incoming warehouse amount was 450 yuan; the quantity of materials outgoing warehouse on January 2 was 50, and the original outgoing warehouse unit price was 3 yuan / piece. The quantity of materials outgoing warehouse on January 4 was 100 pieces, and the original outgoing warehouse unit price was 2 yuan / piece, and the total outgoing warehouse amount was 350 yuan. According to the fifth preset formula, the verified balance amount is 95.833 yuan.
[0076] The current material inventory quantity is 50 pieces. The actual balance (95.833 yuan) is calculated by multiplying the current material receipt time January 5 with the current modified weighted unit price (1.917) of the previous material entry time (January 4) that is closest to the current material receipt time.
[0077] S4. Based on the difference between the actual balance amount and the verified balance amount, determine whether the cost difference accounting of the target inventory material is correct.
[0078] When there is no difference or the difference is very small between the actual balance amount and the verified balance amount, it is determined that the cost difference accounting of the target inventory material is correct; otherwise, it is determined that the cost difference accounting of the target inventory material is incorrect.
[0079] The technical solution of this embodiment can clearly and intuitively obtain the specific cost price difference from material purchase to material delivery when receiving the invoice, thereby improving the efficiency and accuracy of inventory material cost difference accounting.
[0080] Figure 3 FIG. 2 is a schematic diagram showing a structure of an embodiment of an inventory material cost difference accounting system 200 provided by the present invention. Figure 3 As shown, the system 200 includes: a first accounting module 210 and a second accounting module 220;
[0081] The first accounting module 210 is used to: when the current purchase receipt of the target inventory material is obtained, calculate at least one current modified weighted unit price of the target inventory material based on the current material receipt information corresponding to the current purchase receipt;
[0082] The second accounting module 220 is used to determine the current outbound difference amount and the current inbound difference amount for representing the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material.
[0083] In an optional manner, the current material receipt information includes: the current material receipt time, the current material storage time, the current material receipt quantity and the current material receipt unit price; the first accounting module 210 is specifically used to:
[0084] Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain the determination result;
[0085] When the judgment result is no, the current revised weighted unit price at the current material entry time is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity excluding the current material invoice quantity and the historical material invoice quantity;
[0086] The current revised weighted unit price of the material entry time point is calculated based on the material entry quantity, material entry unit price, material remaining quantity before the material entry and the current revised weighted unit price of the previous material entry time point at any material entry time point between the current material entry time point and the current material receipt time point except the current material entry time point, until the current revised weighted unit price of the target inventory material at each material entry time point between the material entry time point and the material receipt time point is calculated; wherein, the previous material entry time point of the first material entry time point among all the material entry time points except the current material entry time point is the current material entry time point.
[0087] In an optional manner, the second accounting module 220 is specifically used for:
[0088] Calculate the current receipt difference amount based on the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material receipt time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity, and the original weighted unit price and the material receipt quantity at the current material receipt time point;
[0089] Based on the material outbound quantity at any material outbound time point between the current material entry time point and the current material invoice receipt time point, and the current revised weighted unit price and original weighted unit price of the previous material entry time point closest to the material outbound time point, calculate the outbound difference amount at the material outbound time point, until the outbound difference amount of each material outbound time point between the current material entry time point and the current material invoice receipt time point is calculated, and according to the outbound difference amount of each material outbound time point between the current material entry time point and the current material invoice receipt time point, calculate the current outbound difference amount.
[0090] In an optional manner, the method further includes: a verification module; the verification module is used to:
[0091] The verification balance amount is calculated based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and the actual balance amount is calculated based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material inventory quantity and the current material receipt time point;
[0092] Based on the difference between the actual balance amount and the verified balance amount, determine whether the cost difference accounting of the target inventory material is correct.
[0093] The technical solution of this embodiment can clearly and intuitively obtain the specific cost price difference from material purchase to material delivery when receiving the invoice, thereby improving the efficiency and accuracy of inventory material cost difference accounting.
[0094] The above parameters and steps for each module to implement corresponding functions in the inventory material cost difference accounting system 200 of this embodiment can refer to the parameters and steps in the embodiment of the inventory material cost difference accounting method above, and will not be repeated here.
[0095] like Figure 4 As shown, an electronic device 300 of an embodiment of the present invention includes a processor 320, the processor 320 is coupled to a memory 310, and the memory 310 stores at least one computer program 330, and the at least one computer program 330 is loaded and executed by the processor 320, so that the electronic device 300 implements any of the above-mentioned inventory material cost difference accounting methods, specifically:
[0096] The electronic device 300 may have relatively large differences due to different configurations or performances, and may include one or more processors 320 (Central Processing Units, CPU) and one or more memories 310, wherein the one or more memories 310 store at least one computer program 330, and the at least one computer program 330 is loaded and executed by the one or more processors 320, so that the electronic device 300 implements any inventory material cost difference accounting method provided in the above embodiments. Of course, the electronic device 300 may also have components such as a wired or wireless network interface, a keyboard, and an input and output interface for input and output, and the electronic device 300 may also include other components for realizing device functions, which will not be described in detail here.
[0097] A computer-readable storage medium according to an embodiment of the present invention stores at least one computer program, and the at least one computer program is loaded and executed by a processor to enable a computer to implement any of the above-mentioned inventory material cost difference accounting methods.
[0098] Optionally, the computer readable storage medium may be a read-only memory (ROM), a random access memory (RAM), a compact disc (CD-ROM), a magnetic tape, a floppy disk, an optical data storage device, etc.
[0099] In an exemplary embodiment, a computer program product or a computer program is also provided, the computer program product or the computer program comprising computer instructions, the computer instructions being stored in a computer-readable storage medium. A processor of an electronic device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the electronic device executes any of the above-mentioned inventory material cost difference accounting methods.
[0100] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application are used to distinguish similar objects and represent the definition of a specific order or sequence. The order of use of similar objects can be interchanged where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than the order shown or described.
[0101] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: it can be complete hardware, it can be complete software (including firmware, resident software, microcode, etc.), or it can be a combination of hardware and software, which is generally referred to as "circuit", "module" or "system" herein. In addition, in some embodiments, the present invention can also be implemented in the form of a computer program product in one or more computer-readable media, and the computer-readable medium contains computer-readable program code.
[0102] Any combination of one or more computer-readable media can be used. Computer-readable media can be computer-readable signal media or computer-readable storage media. Computer-readable storage media can be, for example, but not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or devices, or any combination of the above. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
[0103] Although the embodiments of the present invention have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present invention. A person skilled in the art may change, modify, replace and vary the above embodiments within the scope of the present invention.
Claims
1. A method for calculating inventory material cost differences, characterized in that: include: When the current purchase receipt of the target inventory material is obtained, at least one current modified weighted unit price of the target inventory material is calculated based on the current material receipt information corresponding to the current purchase receipt; Determine a current outbound difference amount and a current inbound difference amount for representing the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material; The current material receipt information includes: the current material receipt time point, the current material storage time point, the current material receipt quantity and the current material receipt unit price; based on the current material receipt information corresponding to the current purchase receipt, the step of calculating at least one current modified weighted unit price of the target inventory material includes: Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain a determination result; When the judgment result is no, the current revised weighted unit price at the current material entry time point is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity; Among them, the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material storage time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity are substituted into the first preset formula to calculate the current revised weighted unit price at the current material storage time point; the first preset formula is: ; The current modified weighted unit price at the current material entry time. The current material invoice price. The current material receipt quantity. The price of the i-th historical material receipt corresponding to the current material storage time point. The number of invoices received for the i-th historical material corresponding to the current material entry time point. The total quantity of the historical material receipt unit price corresponding to the current material entry time point. and is an integer, is the original weighted unit price corresponding to the current material entry time point, The material quantity corresponding to the current material entry time point, excluding the current material receipt quantity and the historical material receipt quantity; Based on the material entry quantity, material entry unit price, material remaining quantity before material entry and the current revised weighted unit price of the material entry time point before the material entry time point at any material entry time point between the current material entry time point and the current material receipt time point except the current material entry time point, calculate the current revised weighted unit price of the material entry time point until calculating the current revised weighted unit price of each material entry time point between the material entry time point and the material receipt time point of the target inventory material; wherein, the material entry time point before the first material entry time point among all the material entry time points except the current material entry time point is the current material entry time point; Among them, the material entry quantity, material entry unit price, material remaining quantity before material entry and the current modified weighted unit price of the material entry time point before the material entry time point at any material entry time point between the current material entry time point and the current material receipt time point except the current material entry time point are substituted into the second preset formula to obtain the current modified weighted unit price of the material entry time point; the second preset formula is: ; For the The current modified weighted unit price of the material at the time of entry into the warehouse. For the The current modified weighted unit price of the material at the time of entry into the warehouse. and is an integer, For the The remaining quantity of the material before the material is put into storage at the time point of material entry. For the The unit price of the material at the time when the material enters the warehouse. For the The quantity of materials entering the warehouse at a certain time.
2. The inventory material cost difference accounting method according to claim 1 is characterized in that: The step of determining a current outbound difference amount and a current inbound difference amount for representing the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material includes: The current invoice difference amount is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material invoice time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity, and the original weighted unit price and the material invoice quantity at the current material invoice time point; Based on the material outbound quantity at any material outbound time point between the current material inbound time point and the current material invoice collection time point, and the current modified weighted unit price and the original weighted unit price of the previous material inbound time point closest to the material outbound time point, calculate the outbound difference amount at the material outbound time point, until the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point is calculated, and according to the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point, calculate the current outbound difference amount.
3. The inventory material cost difference accounting method according to claim 2 is characterized in that: Also includes: The verification balance amount is calculated based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and the actual balance amount is calculated based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material receipt time point when the current material inventory quantity is the same; Based on the difference between the actual balance amount and the verified balance amount, it is determined whether the cost difference accounting of the target inventory material is correct.
4. A system for calculating inventory material cost differences, characterized in that: include: A first accounting module and a second accounting module; The first accounting module is used to: when the current purchase receipt of the target inventory material is obtained, calculate at least one current modified weighted unit price of the target inventory material based on the current material receipt information corresponding to the current purchase receipt; The second accounting module is used to determine the current outbound difference amount and the current inbound difference amount for representing the cost difference of the target inventory material according to the current material receipt information and all current modified weighted unit prices of the target inventory material; The current material receipt information includes: the current material receipt time, the current material storage time, the current material receipt quantity and the current material receipt unit price; the first accounting module is specifically used for: Determine whether the current material receipt price corresponding to the current purchase receipt is the same as the material entry price at the current material entry time corresponding to the current purchase receipt, and obtain a determination result; When the judgment result is no, the current revised weighted unit price at the current material entry time point is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material entry time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity; Among them, the current material receipt quantity and the current material receipt unit price, each historical material receipt unit price corresponding to the current material storage time point and the corresponding historical material receipt quantity, the original weighted unit price and the material quantity other than the current material receipt quantity and the historical material receipt quantity are substituted into the first preset formula to calculate the current revised weighted unit price at the current material storage time point; the first preset formula is: ; The current modified weighted unit price at the current material entry time. The current material invoice price. The current material receipt quantity. The price of the i-th historical material receipt corresponding to the current material storage time point. The number of invoices received for the i-th historical material corresponding to the current material entry time point. The total quantity of the historical material receipt unit price corresponding to the current material entry time point. and is an integer, is the original weighted unit price corresponding to the current material entry time point, The material quantity corresponding to the current material entry time point, excluding the current material receipt quantity and the historical material receipt quantity; Based on the material entry quantity, material entry unit price, material remaining quantity before material entry and the current revised weighted unit price of the material entry time point before the material entry time point at any material entry time point between the current material entry time point and the current material receipt time point except the current material entry time point, calculate the current revised weighted unit price of the material entry time point until calculating the current revised weighted unit price of each material entry time point between the material entry time point and the material receipt time point of the target inventory material; wherein, the material entry time point before the first material entry time point among all the material entry time points except the current material entry time point is the current material entry time point; Among them, the material entry quantity, material entry unit price, material remaining quantity before material entry and the current modified weighted unit price of the material entry time point before the material entry time point at any material entry time point between the current material entry time point and the current material receipt time point except the current material entry time point are substituted into the second preset formula to obtain the current modified weighted unit price of the material entry time point; the second preset formula is: ; For the The current modified weighted unit price of the material at the time of entry into the warehouse. For the The current modified weighted unit price of the material at the time of entry into the warehouse. and is an integer, For the The remaining quantity of the material before the material is put into storage at the time point of material entry. For the The unit price of the material at the time when the material enters the warehouse. For the The quantity of materials entering the warehouse at a certain time.
5. The inventory material cost difference accounting system according to claim 4 is characterized in that: The second accounting module is specifically used for: The current invoice difference amount is calculated based on the current material invoice quantity and the current material invoice unit price, each historical material invoice unit price corresponding to the current material invoice time point and the corresponding historical material invoice quantity, the original weighted unit price and the material quantity other than the current material invoice quantity and the historical material invoice quantity, and the original weighted unit price and the material invoice quantity at the current material invoice time point; Based on the material outbound quantity at any material outbound time point between the current material inbound time point and the current material invoice collection time point, and the current modified weighted unit price and the original weighted unit price of the previous material inbound time point closest to the material outbound time point, calculate the outbound difference amount at the material outbound time point, until the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point is calculated, and according to the outbound difference amount of each material outbound time point between the current material inbound time point and the current material invoice collection time point, calculate the current outbound difference amount.
6. The inventory material cost difference accounting system according to claim 5, characterized in that: Also includes: Verification module; the verification module is used to: The verification balance amount is calculated based on the current incoming difference amount, the current outgoing difference amount, the total incoming amount and the total outgoing amount between the current material incoming time point and the current material receipt time point, and the actual balance amount is calculated based on the current modified weighted unit price of the previous material incoming time point that is closest to the current material receipt time point when the current material inventory quantity is the same; Based on the difference between the actual balance amount and the verified balance amount, it is determined whether the cost difference accounting of the target inventory material is correct.
7. An electronic device, characterized in that: The electronic device includes a processor, the processor is coupled to a memory, the memory stores at least one computer program, and the at least one computer program is loaded and executed by the processor so that the electronic device implements the inventory material cost difference accounting method as described in any one of claims 1 to 3.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores at least one computer program, and the at least one computer program is loaded and executed by a processor so that the computer-readable storage medium implements the inventory material cost difference accounting method according to any one of claims 1 to 3.
