A method, equipment, and media for product inventory based on an ERP system.

Abstract

This application discloses a method, equipment, and medium for product inventory based on an ERP system. The method includes: determining the cost accounting object and configuring production data sources that match the corresponding accuracy requirements, including production orders, material requisition quantities, and MES work reports; retrieving the corresponding interface based on the production data sources to obtain the current period input data for the cost accounting object; obtaining the initial cost data and performing a product quantity inventory of the cost accounting object based on the current period input data and the initial cost data. The calculation is accurate and can meet the needs of customers for refined management. It is highly flexible, allowing for different calculation schemes to be implemented according to customer configurations. It has good traceability, enabling tracking of the calculation process after calculation, thus improving delivery capabilities.

Description

Technical Field

[0001] This application relates to the field of computers, specifically to a method, device, and medium for implementing product inventory based on an ERP system. Background Technology

[0002] With the development of information technology, the complexity of data generated in the enterprise production process is increasing, and the workload of cost calculation is also increasing. Relying entirely on manual cost calculation often has drawbacks such as unreliable data, slow efficiency, poor visibility of results, and difficulty in data storage. Moreover, traditional ERP systems have relatively simple inventory counting methods and poor configurability, which cannot meet the flexible market environment and the personalized needs of customers.

[0003] Accurately counting the number of products in production in the workshop is a complex aspect of cost calculation in ERP systems. The main complexity lies in the fact that customers have different needs regarding the sources of the initial quantity, input quantity, and completed quantity of products.

[0004] Taking input quantity as an example, the typical approach of software is to directly use the quantity of production orders for the current month as the input quantity for this period. For companies whose production orders do not span months, input equals output, and this method works without issue. However, many manufacturing industries have scenarios where production orders span periods. In such cases, if the ending work-in-process has already been carried forward to the beginning work-in-process of the next period, and the input quantity is used as the allocation standard during product allocation, this will significantly impact the accuracy of product cost calculation. Summary of the Invention

[0005] To address the aforementioned issues, this application proposes a method for implementing product inventory based on an ERP system, comprising:

[0006] Identify the cost accounting object and configure the production data source that matches the corresponding accuracy requirements, including: production orders, material requisition quantity, and MES work report;

[0007] Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object;

[0008] Obtain initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0009] On the other hand, this application also proposes a device for product inventory based on an ERP system, comprising:

[0010] At least one processor; and,

[0011] A memory communicatively connected to the at least one processor; wherein,

[0012] The memory stores instructions that can be executed by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to perform, for example:

[0013] Identify the cost accounting object and configure the production data source that matches the corresponding accuracy requirements, including: production orders, material requisition quantity, and MES work report;

[0014] Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object;

[0015] Obtain initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0016] On the other hand, this application also proposes a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured as follows:

[0017] Identify the cost accounting object and configure the production data source that matches the corresponding accuracy requirements, including: production orders, material requisition quantity, and MES work report;

[0018] Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object;

[0019] Obtain initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0020] The method proposed in this application can bring the following beneficial effects:

[0021] It offers accurate calculations, meeting clients' needs for refined management. It is highly flexible, allowing for different calculation solutions tailored to client configurations. It provides excellent traceability, enabling post-calculation tracking and improving delivery capabilities. Attached Figure Description

[0022] The accompanying drawings, which are included to provide a further understanding of this application and form part of this application, illustrate exemplary embodiments and are used to explain this application, but do not constitute an undue limitation of this application. In the drawings:

[0023] Figure 1 This is a flowchart illustrating the method for implementing product inventory based on an ERP system in an embodiment of this application.

[0024] Figure 2This is a flowchart illustrating a method for implementing product inventory based on an ERP system in one scenario, as described in this application embodiment.

[0025] Figure 3 This is a flowchart illustrating another scenario of product inventory based on an ERP system in this application embodiment;

[0026] Figure 4 This is a schematic diagram of the equipment used for product inventory management based on an ERP system in this application embodiment. Detailed Implementation

[0027] To make the purpose, technical solutions, and advantages of this application more clear, the technical solutions of this application will be clearly and completely described below in conjunction with the specific embodiments of this application and the corresponding drawings. Obviously, the embodiments described are only part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.

[0028] Cost accounting refers to the allocation and aggregation of various expenses incurred by an enterprise during its production and operation processes according to certain objects to calculate total cost and unit cost. Cost accounting is typically based on accounting principles and uses currency as the unit of calculation. Cost accounting is a crucial component of cost management, directly impacting an enterprise's cost forecasting and business decisions. Simultaneously, with the accumulation of internal experience and changes in market conditions, the requirements for the methods and accuracy of inventory counting are gradually increasing. Traditional work-in-process inventory counting methods are increasingly unable to match the actual production process, consistently exhibiting lag in response to new process improvements and raw material price fluctuations, resulting in constantly changing cost deviations that increasingly fail to reflect the true production situation.

[0029] The technical solutions provided by the various embodiments of this application are described in detail below with reference to the accompanying drawings.

[0030] like Figure 1 As shown in the figure, this application provides a method for implementing product inventory based on an ERP system, including:

[0031] S101: Determine the cost accounting object and configure the production data source that matches the corresponding accuracy requirements. The production data source includes: production orders, material requisition quantity, and MES work report.

[0032] It supports two cost accounting objects: "order + product" and "product". Based on the different cost accounting objects, multiple matching dimensions can be selected from preset dimensions for data aggregation. The preset dimensions include: work order number, work order line number, cost center, auxiliary attributes, BOM version number, plan tracking number, product number, etc.

[0033] Of course, personalized customization based on user needs is also supported. User needs are obtained, and based on those needs, multiple dimensions of the selected matching are adjusted using auxiliary attributes.

[0034] S102: Based on the production data source, retrieve the corresponding interface to obtain the current period input data corresponding to the cost accounting object.

[0035] If the data source for production launch is configured as production orders based on the accuracy requirements of the cost accounting object, then data will be directly retrieved from production and outsourcing orders as production launch data. This logic is relatively simple and has low requirements for equipment and systems, but it has certain drawbacks, resulting in relatively low accuracy.

[0036] If the production data source is configured to be MES reporting based on the accuracy requirements of the cost accounting object, then the production data can be obtained from the MES reporting status. This logical data is the most accurate, but it places high demands on enterprise management and hardware facilities.

[0037] If the production data source is configured as the number of sets of materials requisitioned based on the accuracy requirements corresponding to the cost accounting object, then data from material requisition and return documents is captured according to the start and end dates of the period and the accounting organization. This data is then aggregated according to the specified dimensions to obtain the actual material requisition data for the current period. Based on the material usage ratios set in the production and outsourced material usage details, the production data is calculated from the actual material requisition data. This logical accuracy is lower than the MES reporting method but higher than production orders, and it does not impose excessive management or hardware costs on customers.

[0038] S103: Obtain the initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0039] The quantity of products corresponding to the cost accounting object is calculated according to the preset formula, where the preset formula is: Initial cost data + Current input data = Quantity of finished products + Quantity of products in production.

[0040] Specifically, if the cost accounting objects are orders and products, the quantity of work-in-process is generated based on the order details. The order details include orders carried over from the previous period and orders put into production in the current period.

[0041] If the cost accounting object is a product, then create an empty dictionary.

[0042] In the empty dictionary, data is aggregated from output collection, production order details, outsourced order details, input-output data, and initial adjustment data according to multiple matching dimensions, thereby generating the quantity of work-in-process products.

[0043] For the same product, if the adjustment scope includes both materials and costs, the data retrieval rules during the adjustment process include: first, take data from materials; if materials are unavailable, then take data from costs; if duplicates occur, the data from materials shall prevail.

[0044] Specifically, data from the material adjustment orders is aggregated according to the first dimension key, and the first dimension is stored in the corresponding table `adj_key_list`. The expense adjustment orders are then iterated through; if the first dimension already exists in the corresponding `adj_key_list` table, it is skipped; otherwise, the corresponding table is updated according to the first dimension.

[0045] Of course, before creating the current inventory data, ensure that previous data for the current period has been deleted, and then create the collected data. If no data matching the criteria can be collected, a prompt should be given.

[0046] In one embodiment, such as Figure 2 As shown, a method for a specific scenario is proposed.

[0047] Specifically, before implementing the product inventory method based on the ERP system in the above embodiments, the accounting organization corresponding to the production organization under the main accounting system takes the accounting policy under the main accounting system and the current period of the cost of the main accounting system, the accounting organization and the accounting policy, and then obtains the output data of the current period according to the period organization filtering conditions.

[0048] At this point, it checks whether "Automatically update output data" is selected. If yes, it calls the common output data method to collect the current period's output data. If no, it checks whether the current period's output data has been updated. If yes, it directly retrieves the current period's output data; otherwise, it calls the common output data method to collect the current period's output data.

[0049] Query the current period's input-output table to obtain the beginning production data (carried forward from the previous period), calculate the number of sets of materials issued, and when the parameters are production orders, the number of sets of materials issued, and MES work reports, query the production and outsourcing order details respectively to obtain the current period's input data, call the material issuance conversion product interface to calculate the current period's input data, and call the material issuance conversion product interface to calculate the current period's input data.

[0050] Query the initial cost adjustment document to obtain the initial adjustment data. Determine whether the cost accounting object is a product or an order. If so, organize the data to be inserted into the details based on the order information; otherwise, organize the data to be inserted into the details based on the product information. Finally, insert the organized data into the details.

[0051] In one embodiment, such as Figure 3 As shown, a method for a specific scenario is proposed.

[0052] Specifically, users select the accounting system, accounting policy, accounting organization, and accounting period to enter the inventory quantity. Input-output table data for the current period is obtained from the input-output table to construct an information dictionary. Based on the input-output table information, the beginning work-in-process quantity in the information dictionary is supplemented according to the summary dimension. Beginning work-in-process cost adjustment information for the current period is obtained from the beginning work-in-process cost adjustment. Based on the beginning work-in-process cost adjustment information, the beginning work-in-process quantity in the information dictionary is supplemented according to the summary dimension. Production order information for the current period is obtained from production orders, and the input quantity for the current period is supplemented according to the production order information. Outsourcing order information for the current period is obtained from outsourcing orders, and the input quantity for the current period is supplemented according to the outsourcing order information. The source of the production quantity (i.e., the source of production data) is queried from the material requisition conversion set count system parameter to determine whether it is necessary to estimate the input quantity for the current period based on the material requisition conversion set count, and the input quantity for the current period is supplemented according to the material requisition conversion set count. Based on the information dictionary, the ending work-in-process quantity is calculated, and the data to be inserted is organized. By entering the product inventory quantity in the table body, the organized data is inserted into the table body.

[0053] like Figure 4 As shown, this application also proposes a device for product inventory based on an ERP system, comprising:

[0054] At least one processor; and,

[0055] A memory communicatively connected to the at least one processor; wherein,

[0056] The memory stores instructions executable by the at least one processor, which, when executed by the at least one processor, enable the at least one processor to perform actions such as:

[0057] Identify the cost accounting object and configure the production data source that matches the corresponding accuracy requirements, including: production orders, material requisition quantity, and MES work report;

[0058] Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object;

[0059] Obtain initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0060] This application also proposes a non-volatile computer storage medium storing computer-executable instructions, wherein the computer-executable instructions are configured as follows:

[0061] Identify the cost accounting object and configure the production data source that matches the corresponding accuracy requirements, including: production orders, material requisition quantity, and MES work report;

[0062] Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object;

[0063] Obtain initial cost data, and based on the current period input data and the initial cost data, conduct a product quantity inventory of the cost accounting object.

[0064] The various embodiments in this application are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, the device and medium embodiments are basically similar to the method embodiments, so the description is relatively simple; relevant parts can be referred to the description of the method embodiments.

[0065] The devices and media provided in this application are one-to-one with the methods. Therefore, the devices and media also have similar beneficial technical effects as their corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0066] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0067] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0068] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0069] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0070] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0071] Memory may include non-persistent storage in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.

[0072] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic magnetic disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.

[0073] It should also be noted that 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 limitation, 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.

[0074] The above description is merely an embodiment of this application and is not intended to limit the scope of 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 scope of the claims of this application.

Claims

1. A method for product inventory management based on an ERP system, characterized in that, include: Determine the cost accounting objects; Based on the different cost accounting objects, multiple matching dimensions are selected from preset dimensions for data aggregation. The preset dimensions include at least one of the following: work order number, work order line number, cost center, auxiliary attributes, BOM version number, plan tracking number, and product number; user requirements are obtained, and the multiple matching dimensions are adjusted according to the user requirements through the auxiliary attributes. And according to the corresponding accuracy requirements, configure the production data sources that match the accuracy requirements. The production data sources include: production orders, material requisition quantities, and MES work reports. Based on the production data source, the corresponding interface is retrieved to obtain the current period input data corresponding to the cost accounting object; Obtain initial cost data; Based on the current period input data and the initial period cost data, a product quantity inventory is conducted on the cost accounting object. Specifically, this includes: calculating the product quantity corresponding to the cost accounting object according to a preset formula, where the preset formula is: Initial period cost data + Current period input data = Quantity of completed products + Quantity of products in production. If the cost accounting object is an order or a product, then the quantity of work-in-process is generated based on the order details, which include orders carried over from the previous period and orders put into production in the current period. If the cost accounting object is a product, an empty dictionary is created; in the empty dictionary, data is summarized from output aggregation, production order details, outsourced order details, input-output data, and initial adjustment data according to the multiple dimensions of the matching, thereby generating the quantity of products in production; Based on the accuracy requirements corresponding to the cost accounting object, configure production data sources that match the accuracy requirements, specifically including: If the production data source is configured as the production order according to the accuracy requirements corresponding to the cost accounting object, then the data is directly taken from the production and outsourcing orders as the production data. If the production data source is configured to be the MES reporting system based on the accuracy requirements corresponding to the cost accounting object, then the production data can be obtained from the MES reporting system. If the production data source is configured as the number of sets of materials requisitioned according to the accuracy requirements corresponding to the cost accounting object, then the data of the material requisition and return documents are captured according to the start and end time of the period and the dimension of the accounting organization, and the material requisition data is summarized according to the specified dimension to obtain the actual material requisition data for this period, so as to calculate the production data based on the material usage ratio set on the production and outsourced material usage details and the actual material requisition data. The auxiliary attributes are used to adjust multiple dimensions of the matching selection, specifically including: For the same product, if the scope of adjustment includes both materials and costs, the data retrieval rules during the adjustment process include: From the material adjustment sheet, data is collected according to the first dimension and stored in the corresponding table; Iterate through the adjustment orders for expenses. If the first dimension already exists in the corresponding table, skip it. If it does not exist, update the corresponding table according to the first dimension. Before performing a product quantity count on the cost accounting object, the method further includes: Once you've confirmed that all previous data for this period has been deleted, recreate the collected data.

2. A device for product inventory management based on an ERP system, characterized in that, include: At least one processor; as well as, A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, which, when executed by the at least one processor, enables the at least one processor to perform a product inventory method based on an ERP system as described in claim 1.

3. A non-volatile computer storage medium storing computer-executable instructions, characterized in that, The computer-executable instructions are set as follows: the method for product inventory based on an ERP system as described in claim 1.

Images