CN115713353A

CN115713353A - Method, equipment and medium for realizing product inventory based on ERP system

Info

Publication number: CN115713353A
Application number: CN202211499195.XA
Authority: CN
Inventors: 潘建宇; 邬柏
Original assignee: Shandong Inspur Science Research Institute Co Ltd
Current assignee: Shandong Inspur Science Research Institute Co Ltd
Priority date: 2022-11-28
Filing date: 2022-11-28
Publication date: 2023-02-24

Abstract

The application discloses a method, equipment and medium for realizing product inventory based on an ERP system, wherein the method comprises the following steps: determining a cost accounting object, and configuring a production data source matched with the precision requirement according to the corresponding precision requirement, wherein the production data source comprises: production orders, material receiving sets and MES work reports; calling a corresponding interface according to a production data source to obtain current-stage investment data corresponding to the cost accounting object; and acquiring the initial cost data, and checking the product quantity of the cost accounting object according to the investment data and the initial cost data of the current period. The calculation is accurate, and the requirement of customer fine management can be met. The flexibility is strong, and different calculation schemes can be realized according to the client configuration. The traceability is good, the calculation process can be tracked after calculation, and the delivery capacity is improved.

Description

Method, equipment and medium for realizing product inventory based on ERP system

Technical Field

The application relates to the field of computers, in particular to a method, equipment and medium for realizing product inventory based on an ERP system.

Background

With the development of informatization, the complexity of data generated in the production process of enterprises is higher and higher, the workload of cost calculation is also increased, and the cost calculation mode completely depends on manpower, and the defects of unreliable data, low efficiency, poor result visibility, difficult storage and the like are often included. In addition, in the traditional ERP system, the checking mode is single, the configurability is poor, and the flexible market environment and the individual requirements of customers are not met.

How to accurately count the number of the products made by the workshop is a more complex place in the cost calculation of the ERP system, and the main complexity is that customers have different scene requirements for the sources of the initial number, the input number and the finished number of the products.

Taking the input amount as an example, a general software processing method is as follows: the product directly takes the quantity of the production order in the current month as the input quantity of the current period. For enterprises whose production orders do not span months, investing, i.e., producing, is not a problem. However, many manufacturing industries have a production order span period scene, and if the end-of-term work-in-process is already converted into the beginning-of-term work-in-process of the next period, and the investment amount is used as the distribution standard during product distribution, the accuracy of the cost calculation of the product is greatly influenced.

Disclosure of Invention

In order to solve the above problem, the present application provides a method for implementing product inventory based on an ERP system, including:

determining a cost accounting object, and configuring a production data source matched with the precision requirement according to the corresponding precision requirement, wherein the production data source comprises: production orders, material receiving sets and MES work reports;

calling a corresponding interface according to the production data source to obtain the current-stage input data corresponding to the cost accounting object;

and acquiring initial cost data, and checking the product quantity of the cost accounting object according to the current investment data and the initial cost data.

On the other hand, the application also provides equipment for realizing product inventory based on the ERP system, which comprises the following steps:

at least one processor; and the number of the first and second groups,

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform such as:

determining a cost accounting object, and configuring a production data source matched with the precision requirement according to the corresponding precision requirement, wherein the production data source comprises: production orders, material receiving sets and MES work reporting;

and acquiring initial cost data, and checking the product quantity of the cost accounting object according to the initial investment data and the initial cost data.

In another aspect, the present application further provides a non-volatile computer storage medium storing computer-executable instructions configured to:

The method provided by the application can bring the following beneficial effects:

the calculation is accurate, and the requirement of customer fine management can be met. The flexibility is strong, and different calculation schemes can be realized according to customer configuration. The traceability is good, the calculation process can be tracked after calculation, and the delivery capacity is improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:

fig. 1 is a schematic flowchart of a method for implementing product inventory based on an ERP system in an embodiment of the present application;

fig. 2 is a schematic flowchart of a method for implementing product inventory based on an ERP system in a scenario in an embodiment of the present application;

fig. 3 is a schematic flowchart of a method for implementing product inventory based on an ERP system in another scenario in the embodiment of the present application;

fig. 4 is a schematic diagram of a device for implementing product inventory based on an ERP system in the embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only a few embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The cost accounting refers to distributing and collecting various consumptions generated in the production and operation process of an enterprise according to a certain object so as to calculate the total cost and the unit cost. Cost accounting is typically based on accounting, in currency. Cost accounting is an important component of cost management, and has direct influence on cost prediction of enterprises, operation decisions of enterprises and the like. Meanwhile, with the accumulation of internal experiences of enterprises and the change of market conditions, the requirements on the checking mode and accuracy are gradually improved. In a traditional product inventory mode, the actual production process is more and more difficult to match, the reaction hysteresis is always generated by the improvement of a new process and the price fluctuation of raw materials, the generated cost deviation value is continuously changed, and the actual production condition is more and more difficult to reflect.

The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.

As shown in fig. 1, an embodiment of the present application provides a method for implementing product inventory based on an ERP system, including:

s101: determining a cost accounting object, and configuring a production data source matched with the precision requirement according to the corresponding precision requirement, wherein the production data source comprises: production order, material-receiving set number, MES work report.

The method supports accounting the objects according to two cost of orders and products. Based on the difference of cost accounting objects, selecting a plurality of matched dimensions from preset dimensions to summarize data, wherein the preset dimensions comprise: work order number, work order line number, cost center, auxiliary attribute, BOM version number, plan tracking number, product number, etc.

Of course, personalized customization by user needs is also supported. And acquiring user requirements, and performing personalized adjustment on the multiple selected and matched dimensions through the auxiliary attributes according to the user requirements.

S102: and calling a corresponding interface according to the production data source to obtain the current-stage input data corresponding to the cost accounting object.

And if the production data source is configured into a production order according to the precision requirement corresponding to the cost accounting object, directly taking the number from the production order and the outsourcing order as the production data. The logic is relatively simple, the requirements on equipment and a system are low, but certain defects exist, and the precision is relatively low.

And if the precision requirement corresponding to the object is calculated according to the cost, configuring the production data source as an MES (manufacturing execution system) worker reporting condition, and obtaining the production data according to the MES worker reporting condition. This logical data is the most accurate, but is more demanding on enterprise management and hardware facilities.

And if the production data source is configured into the number of the material receiving sets according to the precision requirement corresponding to the cost accounting object, capturing data of material receiving and returning documents according to the starting and ending time and the dimension of the accounting organization, summarizing the material receiving data according to the specified dimension to obtain the actual material receiving data of the current period, and converting the calculated production data according to the material proportion set on the production and commission exterior material details and the actual material receiving data. This logic is less accurate than MES labor reporting, but is higher than production orders, and does not incur excessive administrative and hardware costs to the customer.

S103: and acquiring initial cost data, and checking the product quantity of the cost accounting object according to the initial investment data and the initial cost data.

And calculating to obtain the product quantity corresponding to the cost accounting object according to a preset formula, wherein the preset formula is as follows: initial cost data + current investment data = finished product quantity + in-process product quantity.

Specifically, if the cost accounting objects are orders and products, the number of the products in production is generated based on the order details, and the order details comprise an up-date transfer order and a current-date production order.

And if the cost accounting object is a product, creating an empty dictionary.

In the space dictionary, according to a plurality of matched dimensions, data summarization is carried out from output collection, production order detail, outsourcing order detail, input-output data and initial adjustment data, so that the quantity of manufactured products is generated.

For the same product, if the adjustment range contains both materials and cost, the access rule in the adjustment process includes: preference is given to taking from the material, if no material is available, then from the cost, if repetition occurs, the material is taken as the basis.

Specifically, from the adjustment list of the material, data aggregation is performed according to a first dimension key, and the first dimension is stored in a corresponding table adj _ key _ list. And traversing the adjustment list of the cost, if the first dimension already exists in the corresponding table adj _ key _ list, skipping, and if the first dimension does not exist, updating the corresponding table according to the first dimension.

Of course, before the current date data is created, the previous current date data is determined to be deleted, and then the collected data is created. If the data meeting the conditions cannot be collected, a prompt needs to be given.

In one embodiment, as shown in FIG. 2, a method under a scenario is presented.

Specifically, before the method for implementing product inventory based on the ERP system in the above embodiment is executed, an accounting organization corresponding to a production organization under a main accounting system is taken, an accounting policy under the accounting organization is changed from the main accounting system, a current period of costs of the main accounting system, the accounting organization and the accounting policy is taken, a filtering condition is organized according to the period, and then output data in the current period is obtained.

And judging whether to check 'automatic updating of output data', if so, calling a public method of the output data, and collecting the output data in the period. If not, judging whether the output data in the period is updated, if so, directly acquiring the output data in the period, and if not, calling a public method for the output data to collect the output data in the period.

Inquiring the input-output table of the current period to obtain initial on-production data (final delivery), receiving material conversion set number, respectively inquiring production and outsourcing order details to obtain the input data of the current period when the parameters are a production order, the receiving material set number and MES (manufacturing execution system) working hour, calling a receiving material conversion product interface, calculating the input data of the current period, calling a receiving material conversion product interface and calculating the input data of the current period.

The initial cost adjustment sheet is queried to obtain initial adjustment data. And judging whether the cost accounting object is a product and an order, if so, organizing the data to be inserted with details by taking the order information as a core, and if not, organizing the data to be inserted with details by taking the product information as a core. Finally, the organized insertion data is inserted into the detail.

In one embodiment, as shown in FIG. 3, a method under a scenario is presented.

Specifically, the user selects an accounting system, accounting policy, accounting organization, and accounting period to enter the product inventory quantity. And acquiring the data of the input-output table in the period from the input-output table, constructing an information dictionary, and supplementing the initial production quantity of the information dictionary according to the summary dimensionality according to the information of the input-output table. And obtaining the product cost adjustment information at the beginning of the current period from the product cost adjustment at the beginning of the period. And adjusting information according to the product cost at the beginning, and supplementing the information dictionary at the beginning in-process quantity according to the summary dimensionality. And acquiring the current production order information from the production order, and supplementing the current input quantity of the information dictionary according to the production order information. Acquiring the information of the ex-commission orders of the current period from the ex-commission orders, and supplementing the input quantity of the information dictionary in the current period according to the information of the ex-commission orders of the current period. Inquiring the system parameter production quantity source (namely production data source) from the material receiving reduced set number, judging whether the current time input quantity needs to be estimated according to the material receiving set number, and supplementing the current time input quantity of the information dictionary according to the material receiving reduced set number. And according to the information dictionary, calculating the end-of-term production quantity and organizing the data to be inserted. And recording the table body according to the product inventory number, and inserting the organized data into the table body.

As shown in fig. 4, the present application further provides an apparatus for implementing product inventory based on an ERP system, including:

at least one processor; and the number of the first and second groups,

the memory stores instructions executable by the at least one processor to cause the at least one processor to perform such as:

The present application further proposes a non-volatile computer storage medium storing computer-executable instructions configured to:

The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on differences from other embodiments. In particular, for the device and media embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, and reference may be made to some description of the method embodiments for relevant points.

The device and the medium provided by the embodiment of the application correspond to the method one by one, so the device and the medium also have the beneficial technical effects similar to the corresponding method.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and so forth) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may 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, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

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

The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, 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 technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.

It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of other like elements in a process, method, article, or apparatus comprising the element.

The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A method for realizing product inventory based on an ERP system is characterized by comprising the following steps:

2. The method of claim 1, wherein after determining the cost accounting object, the method further comprises:

based on the difference of the cost accounting objects, selecting a plurality of matched dimensions from preset dimensions for data summarization, wherein the preset dimensions comprise: at least a plurality of work order numbers, work order line numbers, cost centers, auxiliary attributes, BOM version numbers, plan tracking numbers and product numbers;

and acquiring user requirements, and adjusting the selected and matched multiple dimensions through the auxiliary attributes according to the user requirements.

3. The method according to claim 1, wherein configuring a production data source matching the accuracy requirement according to the accuracy requirement corresponding to the cost accounting object specifically comprises:

if the production data source is configured as the production order according to the precision requirement corresponding to the cost accounting object, directly taking the number from the production order and the outsourcing order as the production data;

if the production data source is configured to be the MES work reporting according to the precision requirement corresponding to the cost accounting object, the MES work reporting condition obtains the production data;

and if the production data source is configured as the material receiving set number according to the precision requirement corresponding to the cost accounting object, capturing data of material receiving and returning documents according to the starting and ending time and the dimension of accounting organization, summarizing the material receiving data according to the specified dimension to obtain the actual material receiving data of the current period, and converting the calculated production data according to the material proportion set on the production and commission exterior material details and the actual material receiving data.

4. The method according to claim 2, wherein the checking the product quantity of the cost accounting object according to the current investment data and the initial cost data specifically comprises:

calculating to obtain the product quantity corresponding to the cost accounting object according to a preset formula, wherein the preset formula is as follows: initial cost data + present investment data = finished product quantity + in-process product quantity.

5. The method according to claim 4, wherein the calculating the product quantity corresponding to the cost accounting object according to a preset formula specifically includes:

and if the cost accounting objects are orders and products, generating the quantity of the products in production based on order details, wherein the order details comprise an upper-stage transfer order and a current-stage production order.

6. The method according to claim 4, wherein the calculating the product quantity corresponding to the cost accounting object according to a preset formula specifically includes:

if the cost accounting object is a product, an empty dictionary is created;

and in the empty dictionary, according to the matched dimensions, summarizing data from output collections, production order details, outsourcing order details, input-output data and initial adjustment data, so as to generate the quantity of the in-process products.

7. The method according to claim 2, wherein the adjusting of the plurality of dimensions of the selected matches by the auxiliary attribute comprises:

for the same product, if the adjustment range contains both materials and cost, the access rule in the adjustment process includes:

collecting data from a material adjustment list according to a first dimension, and storing the first dimension into a corresponding table;

and traversing the adjustment list of the cost, if the first dimension already exists in the corresponding table, skipping, and if the first dimension does not exist, updating the corresponding table according to the first dimension.

8. The method of claim 2, wherein prior to the product quantity inventory of the cost accounting object, the method further comprises:

and determining that the previous date data is deleted, and then creating the collected data.

9. An equipment for realizing product inventory based on an ERP system is characterized by comprising:

at least one processor; and (c) a second step of,

10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to: