CN117371910A - Material warehouse-out method and device based on ERP - Google Patents

Material warehouse-out method and device based on ERP Download PDF

Info

Publication number
CN117371910A
CN117371910A CN202311302104.3A CN202311302104A CN117371910A CN 117371910 A CN117371910 A CN 117371910A CN 202311302104 A CN202311302104 A CN 202311302104A CN 117371910 A CN117371910 A CN 117371910A
Authority
CN
China
Prior art keywords
warehouse
inventory
information
stock
instant
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202311302104.3A
Other languages
Chinese (zh)
Inventor
张华�
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN202311302104.3A priority Critical patent/CN117371910A/en
Publication of CN117371910A publication Critical patent/CN117371910A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management

Abstract

The invention provides a material ex-warehouse method and device based on ERP, wherein the material ex-warehouse method based on ERP comprises the following steps: acquiring material warehouse-out requirements and material inventory information; traversing the material inventory information, and storing the material inventory information meeting the material ex-warehouse requirement as a temporary reference list; calculating the instant stock data of the ex-warehouse materials according to the temporary reference list, and generating instant stock ex-warehouse information; and obtaining a material delivery scheme according to the instant inventory delivery information and delivery rules. The invention can solve the problem of poor operation flexibility of ex-warehouse.

Description

Material warehouse-out method and device based on ERP
Technical Field
The invention relates to the technical field of computer information, in particular to a material warehouse-out method and device based on ERP.
Background
For a complex place in an ERP system, the material warehouse-in and warehouse-out operation is mainly complex in that multiple measuring units can be adopted during material warehouse-in, different measuring units can be adopted during warehouse-out, and the condition that the same material uses different measuring units for warehouse-out often occurs. In the ERP software popular in the current market, most of ERP software supports multi-metering-unit warehouse-in and warehouse-out, and the instant inventory can be referred to when the ERP software is in warehouse-out, so that the current instant inventory information can be displayed generally. However, the given instant stock information is limited, generally the quantity of basic stock units or main stock units of materials, when the materials are stored in different dimensions, the user needs to aggregate the spliced ex-warehouse quantity, the real-time stock of the materials cannot be reflected, the business processing is troublesome, the flexibility is poor, errors are easy to occur in the ex-warehouse quantity, and the work efficiency is affected.
Disclosure of Invention
The present invention has been made to solve the above-mentioned technical problems. The embodiment of the invention provides a material ex-warehouse method and device based on ERP, which can solve the problem of poor ex-warehouse operation flexibility.
According to one aspect of the invention, there is provided an ERP-based material delivery method, comprising: acquiring material warehouse-out requirements and material inventory information; traversing the material inventory information, and storing the material inventory information meeting the material ex-warehouse requirement as a temporary reference list; calculating the instant stock data of the ex-warehouse materials according to the temporary reference list, and generating instant stock ex-warehouse information; and obtaining a material delivery scheme according to the instant inventory delivery information and delivery rules.
In an embodiment, the material delivery requirement includes a material quantity requirement, and before the obtaining the material delivery requirement and the material inventory information, the ERP-based material delivery method includes: configuring an instant inventory start identifier on an inventory-leaving bill table body; wherein one of the instant inventory start identifiers corresponds to the material delivery demand of one material; wherein, the obtaining the material delivery demand and the material inventory information includes: after a starting signal of an instant stock starting identifier is obtained, reading the material quantity requirement in the material ex-warehouse requirement and the material stock information in a database; wherein the stock information includes a stock name and stock availability.
In an embodiment, before the traversing the material inventory information and storing the material inventory information meeting the material inventory requirement as a temporary reference list, the ERP-based material inventory method includes: associating the material names in the material warehouse-out and the material inventory information, and establishing a connection between the material warehouse-out requirement and the material inventory information; wherein the traversing the material inventory information, storing the material inventory information meeting the material ex-warehouse demand as a temporary reference list includes: extracting and integrating the material inventory information of the ex-warehouse material into the temporary reference list; wherein each row of the temporary reference list corresponds to an inventory organization.
In an embodiment, the calculating the on-line inventory data of the ex-warehouse material according to the temporary reference list, and generating the on-line inventory information includes: calculating the on-line inventory data of the ex-warehouse materials according to the temporary reference list; sorting the inventory organization in the temporary reference list according to the instant inventory data of the ex-warehouse materials and the material ex-warehouse requirements and a preset sorting rule; and generating the on-line inventory outlet information according to the arrangement sequence of the inventory organizations.
In an embodiment, the calculating the on-line inventory data of the ex-warehouse material according to the temporary reference list, and generating the on-line inventory information further includes: calculating the on-line inventory data of the ex-warehouse materials according to the temporary reference list; matching the material delivery requirements and the material inventory information of each row according to the instant inventory data of the delivered materials; and generating instant stock out-of-stock information according to the matching value of the out-of-stock material and the material stock information.
In an embodiment, the material delivery requirements include at least one line of material delivery requirements, and the method for acquiring the on-line inventory data includes: reading the stock information of the ex-warehouse materials in the source line, and obtaining the corresponding stock available amount of the ex-warehouse materials in the database; reading the ex-warehouse quantity of the same ex-warehouse material in other rows; subtracting the quantity of the delivered from the other rows from the available stock quantity of the delivered materials, and obtaining the instant stock data of the delivered materials in the source row.
In an embodiment, the material delivery scheme includes at least one line of material delivery information, and the obtaining the material delivery scheme includes: determining at least one row of material ex-warehouse information according to the instant material ex-warehouse information and the ex-warehouse rule, and filling in recommended ex-warehouse quantity after the material ex-warehouse information; and filling out an ex-warehouse bill and updating the material inventory information in a database according to the recommended ex-warehouse quantity and the material ex-warehouse information.
In an embodiment, the method for delivering materials based on ERP further comprises: modifying the recommended ex-warehouse quantity; the method for acquiring the on-line inventory data further comprises the following steps: and updating the temporary reference list according to the modified ex-warehouse quantity to obtain updated instant inventory data of the ex-warehouse materials.
In an embodiment, after the obtaining the material shipment requirement and the material inventory information, the ERP-based material shipment method further includes: comparing the obtained key fields of the material ex-warehouse requirement and/or the material inventory information with preset key fields to obtain a comparison result; and when the comparison result shows that at least one key field is missing, sending out an incomplete prompt and returning the material delivery requirement and/or the material inventory information.
According to another aspect of the present invention, there is provided an ERP-based material delivery apparatus, comprising: the acquisition module is used for acquiring material warehouse-out requirements and material inventory information; the storage module traverses the material inventory information and stores the material inventory information meeting the material ex-warehouse requirement as a temporary reference list; wherein the temporary reference list comprises on-line inventory data of the materials to be discharged; the generation module is used for calculating the instant stock data of the ex-warehouse materials according to the temporary reference list and generating instant stock ex-warehouse information; and the ex-warehouse module is used for obtaining a material ex-warehouse scheme according to the instant inventory ex-warehouse information and the ex-warehouse rule.
According to the ERP-based material ex-warehouse method and device provided by the invention, the material inventory information is screened according to the material ex-warehouse requirement, the real-time inventory of the actual ex-warehouse unit is automatically calculated in real time according to the information on the current bill, and finally, the recommended ex-warehouse information can be automatically filled according to the ex-warehouse rule of the material, so that the single-making flexibility is improved, the risk of ex-warehouse mistakes is reduced, and the ex-warehouse efficiency is improved.
Drawings
The above and other objects, features and advantages of the present invention will become more apparent by describing embodiments of the present invention in more detail with reference to the attached drawings. The accompanying drawings are included to provide a further understanding of embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, and not constitute a limitation to the invention. In the drawings, like reference numerals generally refer to like parts or steps.
Fig. 1 is a flow chart of an ERP-based material delivery method according to an exemplary embodiment of the present invention.
Fig. 2 is a schematic structural diagram of an ERP-based material delivery device according to an exemplary embodiment of the present invention.
Detailed Description
Hereinafter, exemplary embodiments according to the present invention will be described in detail with reference to the accompanying drawings. It should be apparent that the described embodiments are only some embodiments of the present invention and not all embodiments of the present invention, and it should be understood that the present invention is not limited by the example embodiments described herein.
Fig. 1 is a flow chart of an ERP-based material delivery method according to an exemplary embodiment of the present invention, and as shown in fig. 1, the ERP-based material delivery method includes:
step 100: and acquiring material warehouse-out requirements and material inventory information.
The method comprises the steps of obtaining a material delivery requirement from a delivery bill table, for example, obtaining information such as a material number, a material name, a material specification model, auxiliary attributes, stock units, a warehouse, stock states and the like, and enabling a user to conduct operations such as name adjustment, addition and deletion, display and hiding, position adjustment, freezing and the like on the material delivery requirement, extracting fields according to filled contents on the material delivery requirement, and transmitting the fields to an instant stock window. For example, an on-line inventory start identifier is configured on the outgoing bill form, an on-line inventory window to be called is configured, and a field to be extracted from the bill form header, a field to be extracted from the bill form and a line to be extracted from the bill form are set in the button context. The stock information of the materials is obtained by obtaining all stock information of all materials in a database. Setting minimum information extracted from the bill, such as filling at least one material name, i.e. information capable of screening requirements, can reduce data transmission and extract key fields.
Step 200: traversing the material inventory information, and storing the material inventory information meeting the material ex-warehouse requirement as a temporary reference list.
Wherein the temporary reference list includes on-the-fly inventory data of the outgoing materials.
According to the acquired filled material ex-warehouse demand, traversing material inventory information, wherein the material inventory information comprises information such as serial numbers, whether the material inventory information is selected, inventory organizations, holders, material names, auxiliary attributes, warehouses, warehouse positions, inventory states, lot numbers, BOM version numbers, plan tracking numbers, production dates, validity periods, source line inventory units, available amounts, return amounts and the like, each serial number corresponds to one line of material inventory information, each line of material inventory information comprises one material name and corresponding inventory organizations, holders, material names, auxiliary attributes, warehouses, warehouse positions, inventory states, lot numbers, BOM version numbers, plan tracking numbers, production dates, validity periods, bill inventory units, available amounts and return amounts, and therefore the material inventory information meeting the material ex-warehouse demand comprises at least one line of inventory information, and at least one line of inventory information meeting the demand is extracted from a database to form a new temporary reference list.
Searching corresponding stock information in the stock information, for example, filling in the stock name in the stock out demand, extracting all stock information containing the stock name in the stock information, organizing the stock information into a new temporary reference list, wherein the temporary reference list contains information such as source row ref, source row selection, source row out stock unit, source row basic unit, newly added row, filtering condition and the like, and after the stock name is associated with the temporary reference list, the instant stock data of the stock materials can be displayed. Or the material name and the inventory organization are filled in the material ex-warehouse requirement, namely the source inventory organization of the material is limited, and when the corresponding inventory information in the material inventory information is searched, the obtained result is related inventory information containing the material name and the inventory organization at the same time. Therefore, the more conditions the material delivery requirements define, the finer the result of finding the material inventory information.
Step 300: and calculating the on-line inventory data of the warehouse materials according to the temporary reference list, and generating on-line inventory delivery information.
The temporary reference list comprises stock available amount which is floatable data in the temporary reference list and is adjusted in real time according to the returned amount, so that the instant stock data of each line of ex-warehouse information can be calculated according to the information items extracted from the temporary reference list, the instant stock ex-warehouse information is generated according to the instant stock data, the instant stock ex-warehouse information structure is a list structure, the list items comprise instant stock IDs, the basic number of source lines, the stock units of the source lines, the basic unit of the source lines and the source line ref.
Step 400: and obtaining a material delivery scheme according to the instant inventory delivery information and delivery rules.
After the instant stock delivery information is generated, the sorting is performed according to delivery rules, for example, the sorting is performed according to the time when all stock organizations store the delivery materials according to the first-in first-out rules, and the stock organization which inputs the delivery materials earliest is selected preferentially. And then automatically recommending and filling out the ex-warehouse quantity according to the ex-warehouse rule, wherein the ex-warehouse quantity is embodied as a return quantity, and the return quantity and the available quantity are combined to calculate the instant inventory data. For example, if the quantity of the materials provided by the stock organization which inputs the materials to be delivered at the earliest time is insufficient, the rest quantity of materials to be delivered are delivered from the stock organization which is ordered second until the sum of the filled return quantities is equal to the quantity of the materials to be delivered, and a material delivery scheme can be formed. If the material starts the ex-warehouse rule, the recommended instant inventory item can be automatically selected and filled in the corresponding return quantity, and the business staff can complete the bill making only by clicking and determining.
When the material delivery scheme is obtained and the bill is automatically filled according to the recommendation, if the required quantity of the A materials is 10 by only one line initially, 2A materials are respectively taken from the A bin, 4A materials are taken from the B bin and 4A materials are taken from the C bin according to the material delivery scheme, the bill is finally filled in three lines, and the inventory organization and the warehouse are written.
In an embodiment, the material delivery requirements include a material quantity requirement, and before the step 100, the ERP-based material delivery method may include: configuring an instant inventory start identifier on an inventory-leaving bill table body; wherein, an instant stock starting identifier corresponds to a material delivery requirement of a material; the step 100 may include: after acquiring a starting signal of an instant stock starting identifier, reading the material quantity requirement in the material delivery requirement and the material stock information in a database; wherein the stock information includes a stock name and stock availability.
The method comprises the steps of configuring an instant stock starting identifier on an outgoing bill table body, configuring an instant stock window to be called, and setting a field to be extracted from a bill table head, a field to be extracted from the bill table body and a row to be extracted from the bill table body in a button context. For example, the material inventory requirement may include one or more rows, each row of material inventory requirement is correspondingly provided with an instant inventory start identifier, and when the row of material inventory requirement is filled, the instant inventory window is called by starting the instant inventory start identifier, and is used for displaying a temporary reference list, instant inventory data and the like.
After clicking the instant stock starting identifier, the user acquires a starting signal of the instant stock starting identifier, and starts to read the material ex-warehouse demand and the material stock information in the database according to the starting signal, so as to provide basic data support for establishing a temporary reference list in the subsequent step. The material inventory information comprises a material name and inventory availability, and the material inventory information and the material ex-warehouse demand can be associated by the material name.
In one embodiment, before the step 200, the method for delivering the materials based on the ERP may include: associating the material names in the material warehouse-out and material inventory information, and establishing the connection between the material warehouse-out requirement and the material inventory information; the step 200 may include: extracting and integrating the material inventory information of the materials with the warehouse-out materials into a temporary reference list; wherein each row of the temporary reference list corresponds to an inventory organization.
The stock information of the materials comprises information such as serial numbers, whether the stock information is selected, stock organization, goods owners, material names, auxiliary attributes, warehouses, warehouse positions, stock states, lot numbers, BOM version numbers, plan tracking numbers, production dates, validity period, stock units of source rows, available quantity, return quantity and the like, corresponding stock information in the stock information of the materials is searched, for example, the material names are filled in the material ex-warehouse requirements, all the stock information containing the material names in the stock information of the materials are extracted and organized into a new temporary reference list, and in the temporary reference list, the information such as the source row ref, whether the source row is selected, the source ex-warehouse basic quantity, the source ex-warehouse stock units, the source row basic units, whether new rows are added, filtering conditions and the like is contained, and after the material names are associated with the temporary reference list, the instant stock data of the stock can be displayed. Or the material name and the inventory organization are filled in the material ex-warehouse requirement, namely the source inventory organization of the material is limited, and when the corresponding inventory information in the material inventory information is searched, the obtained result is related inventory information containing the material name and the inventory organization at the same time. Therefore, the more conditions the material delivery requirements define, the finer the result of finding the material inventory information. And, each serial number corresponds to a row of stock information, each row of stock information contains a stock name and corresponding stock organization, cargo owner, stock name, auxiliary attribute, library, bin, stock state, lot number, BOM version number, plan tracking number, production date, validity period, bill stock unit, available amount and return amount, so that the stock information meeting the stock out demand contains at least one row of stock information, and at least one row of stock information meeting the demand is extracted from the database to form a new temporary reference list.
In one embodiment, the step 300 may include: calculating the instant stock data of the warehouse materials according to the temporary reference list; sorting the inventory organization in the temporary reference list according to the instant inventory data of the materials to be delivered and the material delivery requirements and a preset sorting rule; and generating the on-line inventory outlet information according to the arrangement sequence of the inventory organizations.
After the instant stock delivery information is generated, the sorting is performed according to delivery rules, for example, the sorting is performed according to the time when all stock organizations store the delivery materials according to the first-in first-out rules, and the stock organization which inputs the delivery materials earliest is selected preferentially. And then automatically recommending and filling out the ex-warehouse quantity according to the ex-warehouse rule, wherein the ex-warehouse quantity is embodied as a return quantity, and the return quantity and the available quantity are combined to calculate the instant inventory data. For example, if the quantity of the materials provided by the stock organization which inputs the materials to be delivered at the earliest time is insufficient, the rest quantity of materials to be delivered are delivered from the stock organization which is ordered second until the sum of the filled return quantities is equal to the quantity of the materials to be delivered, and a material delivery scheme can be formed.
In an embodiment, the step 300 may further include: calculating the instant stock data of the warehouse materials according to the temporary reference list; matching the material delivery requirements and the material inventory information of each row according to the instant inventory data of the delivered materials; and generating the on-line inventory delivery information according to the matching value of the delivery materials and the material inventory information.
According to the available amount and the returned amount in the temporary reference list, calculating the instant stock data of the stock materials, after generating the instant stock delivery information, according to the requirements set forth by the material delivery requirements, matching the corresponding material names or material units, sorting the material stock information when matching the material stock information, then further matching according to the serial numbers, searching more accurate material stock information, and generating the instant stock delivery information. Or after the user provides the material names for calculation and sorting, the obtained material inventory information is excessive, and the material inventory information needs to be further screened, the user can provide other fields for matching the material inventory information with higher association degree, and the instant inventory outlet information is generated according to the matching value of the outlet material and the material inventory information selected from high to low matching degree.
In one embodiment, the material delivery requirements include at least one line of material delivery requirements, and the method for obtaining the on-line inventory data may include: reading material inventory information of the ex-warehouse materials in the source line, and acquiring inventory available quantity corresponding to the ex-warehouse materials in the database; reading the ex-warehouse quantity of the same ex-warehouse material in other rows; subtracting the quantity of the delivered warehouse in other rows from the available inventory quantity of the delivered warehouse materials, and taking the quantity of the delivered warehouse as the instant inventory data of the delivered warehouse materials in the source row.
The instant stock data are floating data, the displayed instant stock data should consider the ex-warehouse information of the whole bill list, so that when a plurality of material ex-warehouse demands are filled in simultaneously, the instant stock window called by each ex-warehouse material is guaranteed, the most real instant stock data can be displayed, and the instant stock data also count the quantity of the materials ex-warehouse in other rows in the same bill into the instant stock data, and the available stock quantity is revised according to a plurality of data. For example, the total amount of materials A on the delivery bill list needs 50, the materials have 2 rows, the first row inputs materials A to be delivered 20 from the materials A through the instant stock, the total amount of materials A meeting the requirements in the A warehouse has 50 materials A, after the second row is selected to open the instant stock, the remaining available amount of materials A in the A warehouse can be seen to be 30, at the moment, the available amount of stock of the second row considers the delivery amount of the first row, and the instant stock data is calculated.
Or, if the first line has input the to-be-discharged 20 from the a materials through the instant stock, if the new line is added to continue filling the a material discharge requirement, after the instant stock window is called, the available quantity of the a warehouse is 30 (the total quantity is 50 minus the 20 discharged from the first line), and 30 are the instant stock data of the discharged materials, and at this time, 30 more materials can be discharged from the a warehouse or 30 materials can be discharged from other warehouses.
Or, the number of the materials to be discharged from the first row A is modified to be 30, at this time, the second row points the instant stock data which is checked after the instant stock window is opened, and the available number of the warehouse A is displayed to be 20 (the total number is 50 minus the number of the materials to be discharged from the first row is modified to be 30).
The instant stock data not only considers the stock available amount in the database, but also considers the ex-stock amount of other rows on the same bill table, so that the bill making accuracy and the ex-stock efficiency can be improved.
In an embodiment, the material delivery scheme includes at least one line of material delivery information, and the step 400 may include: determining at least one row of material ex-warehouse information according to the instant material ex-warehouse information and the ex-warehouse rule, and filling the recommended ex-warehouse quantity after the material ex-warehouse information; and filling out the delivery bill and updating the material inventory information in the database according to the recommended delivery quantity and the material delivery information.
And automatically recommending and filling out the ex-warehouse quantity according to the ex-warehouse rule, wherein the ex-warehouse quantity is embodied as a return quantity, and the return quantity and the available quantity are combined to calculate the instant inventory data. For example, if the quantity of the materials provided by the stock organization which inputs the materials to be delivered at the earliest time is insufficient, the rest quantity of materials to be delivered are delivered from the stock organization which is ordered second until the sum of the filled return quantities is equal to the quantity of the materials to be delivered, and a material delivery scheme can be formed. According to the material delivery scheme, data can be filled in detail lines of the bill, and the bill making speed is improved.
And is also provided with
In an embodiment, the method for delivering materials based on ERP may further include: modifying the recommended ex-warehouse quantity; the method for acquiring the on-line inventory data may further include: and updating the temporary reference list according to the modified ex-warehouse quantity to obtain updated instant inventory data of the ex-warehouse materials.
After the material delivery scheme is obtained and the bill is automatically filled according to the recommendation, a service person can bring timely inventory delivery information into the bill detail line only by clicking and determining. For the situation that the salesman needs to select the discharging at this time, the salesman can empty the return quantity automatically filled by the system, after the required input return quantity of the instant stock is found again, the system accumulates the basic unit discharging quantity corresponding to the instant stock ID, traverses all the rows, updates the stock available quantity to the initial available quantity minus the accumulated discharging quantity, converts the accumulated discharging quantity into the available quantity of bill stock units and updates the bill stock units to all the rows, and the system can automatically select the rows with the return quantity.
In an embodiment, after the step 100, the method for delivering materials based on ERP may further include: comparing the obtained key fields of the material warehouse-out requirement and/or the material inventory information with preset key fields to obtain a comparison result; when the comparison result shows that at least one key field is missing, an incomplete prompt is sent out and material delivery requirements and/or material inventory information are returned.
Because the user focus is different, different preset key fields can be set to emphasize important data. For example, the inventory organization and the material names are set as preset key fields, if the preset key fields are absent, incomplete prompt is sent out and the material delivery demand or the material inventory information is returned, and the information which is not set as the preset key fields can be information which is considered to be irrelevant to the delivery of the present time by a user, so that the user can perform name adjustment, addition and deletion, display and hiding, position adjustment and freezing column operations on column fields on a window, the flexibility is good, only the line data which is used as the key fields and is the same as the material of the current detail line is transmitted, the transmission efficiency is improved, and the redundant data transmission is reduced. And the integrity detection is carried out, the temporary inventory window is not added to the information which is missing, and the possibility of error delivery is reduced.
According to the material ex-warehouse method based on ERP provided by the invention, a material ex-warehouse device based on ERP can be designed, an instant inventory button is configured on an ex-warehouse bill table body during design, an instant inventory window to be called is configured, fields to be extracted from the bill table head, the fields to be extracted from the bill table body and lines to be extracted from the bill table body are set in the button context. When the instant stock window is opened, the extracted information is transferred to the instant stock window according to the configuration, and the instant stock window organizes data according to the acquired information. The method has the advantages that the designer is provided for performing name adjustment, addition and deletion, display and hidden, position adjustment and column freezing operation on the column field on the window during design, the flexibility is good, and the method is used according to requirements. And setting information obtained from the bill, and only transmitting data which is used as an inventory dimension field and is the same as the material of the current detail row, so that the efficiency problem caused by transmitting all data is prevented. Default fields are serial number, whether selected, inventory organization, shipper, material name, auxiliary attribute, warehouse, bin, inventory status, lot number, BOM version number, plan tracking number, date of manufacture, expiration date, source line inventory unit, availability, return, etc.
The material delivery equipment based on ERP operates as follows: firstly judging whether the incoming information is complete or not, if not, returning a prompt, traversing the incoming line record, organizing an intermediate data structure, and temporarily storing the intermediate data structure into a list. The list contains the source row ref, whether the source row is selected, the source row stock-out unit, the source row basic unit, whether the source row is newly added or not and the filtering condition. The method comprises the steps of preselecting the instant stock data of the available quantity of the ex-warehouse materials, traversing the data structure of an organization, and organizing the instant stock floating quantity and the ex-warehouse information according to the preselect instant stock data of the available quantity of the ex-warehouse materials. Wherein, the real-time inventory floating adjustment information structure comprises real-time inventory ID and floating quantity. Searching in a source row ref account removing table, and if the inquiry is not completed, calculating rules of the floating quantity, wherein the new row is added: (1) newly added lines or temporary storage lines, wherein the floating quantity is as follows: -the value of the current row; (2) the rows already out of the warehouse, the floating number is: database value-current line value, the information structure of going out of stock is list structure, list item content contains instant stock ID, basic number of source line, stock unit of source line, basic unit of source line, and ref of source line. After the floating quantity is calculated, the instant stock ex-warehouse information is generated, the sorting is performed according to the ex-warehouse rule, and the ex-warehouse quantity can be automatically recommended and filled according to the ex-warehouse rule.
The information of the delivery is filled out according to the automatic recommendation, and a business operator can bring the information of the delivery of the timely stock into a bill detail line only by clicking and determining. For the situation that the salesman needs to select the discharging at this time, the salesman can empty the return quantity automatically filled by the system, after the required input return quantity of the instant stock running is found again, the system accumulates the basic unit discharging quantity corresponding to the instant stock ID, traverses all the lines, updates the available quantity of the basic unit to the initial available quantity minus the accumulated discharging quantity, converts the available quantity into the available quantity of the bill stock unit, and updates the available quantity to all the lines. The system automatically selects the line with the return quantity, thereby realizing the instant update of the inventory.
Fig. 2 is a schematic structural diagram of an ERP-based material delivery device according to an exemplary embodiment of the present invention, and as shown in fig. 2, an ERP-based material delivery device 1 includes: the acquisition module 11 acquires material delivery requirements and material inventory information; the storage module 12 traverses the material inventory information and stores the material inventory information meeting the material ex-warehouse requirement as a temporary reference list; the temporary reference list comprises instant stock data of the materials to be discharged; the generation module 13 calculates the on-line inventory data of the warehouse materials according to the temporary reference list and generates on-line inventory information; the ex-warehouse module 14 obtains a material ex-warehouse scheme according to the on-line inventory-warehouse information and the ex-warehouse rules.
According to the ERP-based material ex-warehouse device provided by the invention, the material inventory information is screened according to the material ex-warehouse requirement, the real-time inventory of the actual ex-warehouse unit is automatically calculated in real time according to the information on the current bill, and finally, the recommended ex-warehouse information can be automatically filled according to the ex-warehouse rule of the material, so that the single making flexibility is improved, the risk of ex-warehouse mistakes is reduced, and the ex-warehouse efficiency is improved.
In an embodiment, the material outlet requirement includes a material quantity requirement, and the ERP-based material outlet device 1 may be configured to: configuring an instant inventory start identifier on an inventory-leaving bill table body; wherein, an instant stock starting identifier corresponds to a material delivery requirement of a material; the acquiring module 11 may be correspondingly configured to: after acquiring a starting signal of an instant stock starting identifier, reading the material quantity requirement in the material delivery requirement and the material stock information in a database; wherein the stock information includes a stock name and stock availability.
In an embodiment, the ERP-based material delivery apparatus 1 may be configured to: associating the material names in the material warehouse-out and material inventory information, and establishing the connection between the material warehouse-out requirement and the material inventory information; wherein, the storage module 12 may be correspondingly configured to: extracting and integrating the material inventory information of the materials with the warehouse-out materials into a temporary reference list; wherein each row of the temporary reference list corresponds to an inventory organization.
In an embodiment, the generating module 13 may be configured to: calculating the instant stock data of the warehouse materials according to the temporary reference list; sorting the inventory organization in the temporary reference list according to the instant inventory data of the materials to be delivered and the material delivery requirements and a preset sorting rule; and generating the on-line inventory outlet information according to the arrangement sequence of the inventory organizations.
In an embodiment, the generating module 13 may be configured to: calculating the instant stock data of the warehouse materials according to the temporary reference list; matching the material delivery requirements and the material inventory information of each row according to the instant inventory data of the delivered materials; and generating the on-line inventory delivery information according to the matching value of the delivery materials and the material inventory information.
In an embodiment, the material delivery requirements include at least one line of material delivery requirements, and the method for obtaining the on-line inventory data may be configured to: reading material inventory information of the ex-warehouse materials in the source line, and acquiring inventory available quantity corresponding to the ex-warehouse materials in the database; reading the ex-warehouse quantity of the same ex-warehouse material in other rows; subtracting the quantity of the delivered warehouse in other rows from the available inventory quantity of the delivered warehouse materials, and taking the quantity of the delivered warehouse as the instant inventory data of the delivered warehouse materials in the source row.
In an embodiment, the material delivery scheme includes at least one line of material delivery information, and the delivery module 14 may be configured to: determining at least one row of material ex-warehouse information according to the instant material ex-warehouse information and the ex-warehouse rule, and filling the recommended ex-warehouse quantity after the material ex-warehouse information; and filling out the delivery bill and updating the material inventory information in the database according to the recommended delivery quantity and the material delivery information.
In an embodiment, the ERP-based material delivery apparatus 1 may be configured to: modifying the recommended ex-warehouse quantity; the method for acquiring the on-line inventory data may further include: and updating the temporary reference list according to the modified ex-warehouse quantity to obtain updated instant inventory data of the ex-warehouse materials.
In an embodiment, the ERP-based material delivery apparatus 1 may be configured to: comparing the obtained key fields of the material warehouse-out requirement and/or the material inventory information with preset key fields to obtain a comparison result; when the comparison result shows that at least one key field is missing, an incomplete prompt is sent out and material delivery requirements and/or material inventory information are returned.
The embodiment of the invention provides a material warehouse-out device based on ERP. The apparatus embodiments may be implemented by software, or may be implemented by hardware or a combination of hardware and software. In addition to the CPU, memory, network interfaces, and non-volatile storage, the device in which the apparatus of the embodiments is located may generally include other hardware, such as a forwarding chip responsible for processing the packet, and so on. Taking software implementation as an example, the device in a logic sense is formed by reading corresponding computer program instructions in a nonvolatile memory into a memory by a CPU of a device where the device is located.
According to another aspect of the present invention, there is provided a computer readable storage medium storing a computer program for executing the ERP-based material ex-warehouse method of any one of the above embodiments.
In addition to the methods and apparatus described above, embodiments of the invention may also be a computer program product comprising computer program instructions which, when executed by a processor, cause the processor to perform the steps in an ERP-based material ex-warehouse method according to various embodiments of the invention described in the "exemplary methods" section of this specification.
According to another aspect of the present invention, there is provided an electronic device including: a processor; a memory for storing processor-executable instructions; and the processor is used for executing the material ex-warehouse method based on the ERP in any embodiment.
Furthermore, embodiments of the invention may also be a computer-readable storage medium, having stored thereon computer program instructions, which when executed by a processor, cause the processor to perform the steps in an ERP-based material ex-warehouse method according to various embodiments of the invention described in the "exemplary methods" section of this specification.
The foregoing description of the preferred embodiments of the invention is not intended to be limiting, but rather to enable any modification, equivalent replacement, improvement or the like to be made within the spirit and principles of the invention.

Claims (10)

1. An ERP-based material delivery method is characterized by comprising the following steps:
acquiring material warehouse-out requirements and material inventory information;
traversing the material inventory information, and storing the material inventory information meeting the material ex-warehouse requirement as a temporary reference list;
calculating the instant stock data of the ex-warehouse materials according to the temporary reference list, and generating instant stock ex-warehouse information;
and obtaining a material delivery scheme according to the instant inventory delivery information and delivery rules.
2. The ERP-based material delivery method of claim 1, wherein the material delivery demand comprises a material quantity demand, and wherein prior to the obtaining the material delivery demand and the material inventory information, the ERP-based material delivery method comprises:
configuring an instant inventory start identifier on an inventory-leaving bill table body; wherein one of the instant inventory start identifiers corresponds to the material delivery demand of one material;
wherein, the obtaining the material delivery demand and the material inventory information includes:
after a starting signal of an instant stock starting identifier is obtained, reading the material quantity requirement in the material ex-warehouse requirement and the material stock information in a database; wherein the stock information includes a stock name and stock availability.
3. The ERP-based material delivery method of claim 1, wherein prior to said traversing the material inventory information, storing the material inventory information meeting the material delivery requirements as a temporary reference list, the ERP-based material delivery method comprises:
associating the material names in the material warehouse-out and the material inventory information, and establishing a connection between the material warehouse-out requirement and the material inventory information;
wherein the traversing the material inventory information, storing the material inventory information meeting the material ex-warehouse demand as a temporary reference list includes:
extracting and integrating the material inventory information of the ex-warehouse material into the temporary reference list; wherein each row of the temporary reference list corresponds to an inventory organization.
4. The ERP-based material ex-warehouse method of claim 3, wherein the calculating the on-line inventory data of the ex-warehouse material according to the temporary reference list, generating on-line inventory-ex-warehouse information comprises:
calculating the on-line inventory data of the ex-warehouse materials according to the temporary reference list;
sorting the inventory organization in the temporary reference list according to the instant inventory data of the ex-warehouse materials and the material ex-warehouse requirements and a preset sorting rule;
and generating the on-line inventory outlet information according to the arrangement sequence of the inventory organizations.
5. The ERP-based material ex-warehouse method of claim 3, wherein the calculating the on-line inventory data of the ex-warehouse material from the temporary reference list, generating on-line inventory-ex-warehouse information further comprises:
calculating the on-line inventory data of the ex-warehouse materials according to the temporary reference list;
matching the material delivery requirements and the material inventory information of each row according to the instant inventory data of the delivered materials;
and generating instant stock out-of-stock information according to the matching value of the out-of-stock material and the material stock information.
6. The ERP-based material delivery method of claim 1, wherein the material delivery requirements comprise at least one line of material delivery requirements, and the method of obtaining the on-line inventory data comprises:
reading the stock information of the ex-warehouse materials in the source line, and obtaining the corresponding stock available amount of the ex-warehouse materials in the database;
reading the ex-warehouse quantity of the same ex-warehouse material in other rows;
subtracting the quantity of the delivered from the other rows from the available stock quantity of the delivered materials, and obtaining the instant stock data of the delivered materials in the source row.
7. The ERP-based material delivery method of claim 1, wherein the material delivery scheme includes at least one line of material delivery information, and the obtaining the material delivery scheme according to the on-line material delivery information and the delivery rule includes:
determining at least one row of material ex-warehouse information according to the instant material ex-warehouse information and the ex-warehouse rule, and filling in recommended ex-warehouse quantity after the material ex-warehouse information;
and filling out an ex-warehouse bill and updating the material inventory information in a database according to the recommended ex-warehouse quantity and the material ex-warehouse information.
8. The ERP-based material delivery method of claim 7, further comprising:
modifying the recommended ex-warehouse quantity;
the method for acquiring the on-line inventory data further comprises the following steps:
and updating the temporary reference list according to the modified ex-warehouse quantity to obtain updated instant inventory data of the ex-warehouse materials.
9. The ERP-based material delivery method of claim 1, wherein after the obtaining the material delivery demand and the material inventory information, the ERP-based material delivery method further comprises:
comparing the obtained key fields of the material ex-warehouse requirement and/or the material inventory information with preset key fields to obtain a comparison result;
and when the comparison result shows that at least one key field is missing, sending out an incomplete prompt and returning the material delivery requirement and/or the material inventory information.
10. An ERP-based material delivery device, comprising:
the acquisition module is used for acquiring material warehouse-out requirements and material inventory information;
the storage module traverses the material inventory information and stores the material inventory information meeting the material ex-warehouse requirement as a temporary reference list; wherein the temporary reference list comprises on-line inventory data of the materials to be discharged;
the generation module is used for calculating the instant stock data of the ex-warehouse materials according to the temporary reference list and generating instant stock ex-warehouse information;
and the ex-warehouse module is used for obtaining a material ex-warehouse scheme according to the instant inventory ex-warehouse information and the ex-warehouse rule.
CN202311302104.3A 2023-10-09 2023-10-09 Material warehouse-out method and device based on ERP Pending CN117371910A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311302104.3A CN117371910A (en) 2023-10-09 2023-10-09 Material warehouse-out method and device based on ERP

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311302104.3A CN117371910A (en) 2023-10-09 2023-10-09 Material warehouse-out method and device based on ERP

Publications (1)

Publication Number Publication Date
CN117371910A true CN117371910A (en) 2024-01-09

Family

ID=89395708

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311302104.3A Pending CN117371910A (en) 2023-10-09 2023-10-09 Material warehouse-out method and device based on ERP

Country Status (1)

Country Link
CN (1) CN117371910A (en)

Similar Documents

Publication Publication Date Title
US8589257B2 (en) Method, system and apparatus for managing inventory
US8285580B2 (en) System and method for filtering exceptions generated by forecasting and replenishment engine
US7908186B2 (en) Distribution matrix in an allocation table
US7308416B2 (en) Single level bill of material available to promise
US20080120205A1 (en) Automatically processing inventory discrepancies
US20050235020A1 (en) Allocation table generation from assortment planning
US20070244765A1 (en) System and method for order fulfillment decisions
US8799293B2 (en) System and method for efficient storage destination determination in a storage facility
GB2265032A (en) Inventory management for combination goods.
US20050243792A1 (en) Synchronizing an allocation table with a procurement system
CN114140045B (en) Material management method, system, storage medium and equipment
US7209894B2 (en) Process delay monitoring system
US20080189195A1 (en) System and method for account reconciliation
KR102192429B1 (en) Goods Receipt and Issue Management System using binary management user interface
US20050160121A1 (en) Import and export expense calculation apparatus
CA2642702A1 (en) Product management system and methods
CN117371910A (en) Material warehouse-out method and device based on ERP
US20080313059A1 (en) Method and apparatus for a receiving, inspection, and supplier quality system
US20080288373A1 (en) Method for Assisting Selection of a Build Ahead Configuration For Use in Supplying an Ordered Product
JPH08137961A (en) Processing system and its managing method for information on product
CN116070842A (en) Management system based on medicine receiving
JPH05324685A (en) Stock controlling system for anticipative product
US7266517B2 (en) Method to create an inventory file with the application of warehouse management system
US11488100B2 (en) Load tracking computing platform and user interface
US20080082379A1 (en) Technical performance measures management process and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination