Consigned commodity inventory cost calculation method
A cost calculation and commodity technology, applied in the computer field, can solve problems such as unsuitable for GS product inventory cost accounting, unsuitable for entrusted consignment products, consigned consignment product cost accounting, etc., to achieve the effect of easy promotion, strong practicability, and expanding the scope of application
Inactive Publication Date: 2016-11-09
INSPUR COMMON SOFTWARE
View PDF0 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0002] Compared with ordinary commodities, the particularity of the consignment product business determines that under the existing data structure, the outbound order is first generated and then the inbound order is generated, while the original order of inbound and outbound is identified by business date and serial number The rules are not suitable for the business of entrusted consignment products, so the cost accounting for consigned consignment products cannot be carried out according to the moving weighting method under the original rules
For an enterprise that has both ordinary commodities and consignment products, it is impossible to use the existing GS products to carry out inventory cost accounting according to the moving weight method
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0014] The present invention will be further described below in conjunction with specific examples.
[0015] In the data structure of the supply chain, the business date on the inbound and outbound documents represents the date before and after the date. For the case of the same business date, since the serial number of the subsequent document is larger than that of the previous document, the business date is added to the serial number. Combinations of serial numbers are arranged in ascending order to represent the actual business inbound and outbound order. However, the storage date and delivery date of consigned consignment products are the same, but the storage receipt document is generated after the corresponding delivery document, and the serial number of the storage receipt document is larger than that of the delivery document. The rule that "number" identifies the order of inbound and outbound goods cannot be applied to the business of consignment products.
[0016] Ba...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a consigned commodity inventory cost calculation method. The concrete realization process comprises the steps that firstly a virtual time sequence is constructed, wherein the virtual time sequence is formed by the business date, the serial number and the consignment input and output identifier; and the business date, the serial number and the consignment input and output identifier in the virtual time sequence are arranged in an ascending order, the ascending order of the combination sequence marks the time order of input and output of consigned commodities, and the order acts as the basis for calculating the output cost of a moving weighted average method subsequently. Compared with the methods in the prior art, the general rules for the common commodities and the consigned commodities are formulated by constructing the "virtual time sequence" by the consigned commodity inventory cost calculation method, and calculation of the inventory output cost of the month of the consigned commodities according to the moving weighted average method is supported so that GS supply chain products are enabled to support cost calculation of the consigned commodities sensitive to price fluctuation, the range of application of the products is enlarged, practicality is high and popularization is easy.
Description
technical field [0001] The invention relates to the field of computer technology, in particular to a method for calculating the cost of entrusted consignment products according to the mobile weighting method through T-SQL language. Background technique [0002] Compared with ordinary commodities, the particularity of the consignment product business determines that under the existing data structure, the outbound order is first generated and then the inbound order is generated, while the original order of inbound and outbound is identified by business date and serial number The rules are not suitable for the business of entrusted consignment products, so the cost accounting for consigned consignment products cannot be carried out according to the moving weight method under the original rules. For an enterprise that has both ordinary commodities and consignment products, it is impossible to use the existing GS products to carry out inventory cost accounting according to the mo...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06Q30/02
CPCG06Q30/0206
Inventor 赵洪超
Owner INSPUR COMMON SOFTWARE