CN109345173B - Method for determining material ex-warehouse data and related device - Google Patents
Method for determining material ex-warehouse data and related device Download PDFInfo
- Publication number
- CN109345173B CN109345173B CN201811160643.7A CN201811160643A CN109345173B CN 109345173 B CN109345173 B CN 109345173B CN 201811160643 A CN201811160643 A CN 201811160643A CN 109345173 B CN109345173 B CN 109345173B
- Authority
- CN
- China
- Prior art keywords
- warehouse
- warehousing
- last
- units
- auxiliary units
- 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.)
- Active
Links
Images
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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
Abstract
The embodiment of the application discloses a method for determining material ex-warehouse data, which comprises the following steps: acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry; acquiring the quantity of all the auxiliary units which are delivered from the warehouse after the last warehouse entry and before the current warehouse delivery; and determining the quantity of the auxiliary units for the warehouse-out at this time according to the quantity of the auxiliary units for the warehouse-out after the last warehouse-in and the quantity of the auxiliary units for the warehouse-out before the warehouse-out at this time after the last warehouse-in. The embodiment of the application also discloses a data processing device. The embodiment of the application provides a method, when the materials are completely delivered from the warehouse according to the basic unit quantity, namely the basic unit quantity of the warehouse is zero at the moment, and the auxiliary unit quantity is also zero through the automatic adjustment of tail difference at the moment. Need not artifical adjustment, improved work efficiency, reduced operating personnel's work burden.
Description
Technical Field
The present application relates to the field of information management, and in particular, to a method and a related apparatus for determining material warehouse-out data.
Background
With the development of science and technology, information technology and management ideas are perfectly fused together to form an Enterprise Resource Planning (ERP) system, namely, the ERP system is established on the basis of the information technology, integrates the information technology and advanced management ideas, and provides a management platform of decision means for enterprise employees and a decision layer through the systematic management ideas.
With the continuous development of society and economy, enterprises pay more attention to the management of materials in warehouses, wherein warehousing and ex-warehouse of the materials are the key parts of warehouse management. In actual business, a plurality of metering units are often used for metering materials, one condition is that the metering units used in different business links are different, for example, materials use different metering units in different stages of purchase, warehousing, sale, transportation and loading and unloading, and the metering units have conversion relations. One of the units is usually determined as the basic unit quantity and the remaining units are determined as the auxiliary unit quantities.
When the materials are completely discharged from the warehouse according to the basic unit quantity, namely the basic unit quantity stored at the moment is zero, the conversion relation exists between the basic unit quantity and the auxiliary unit quantity. At this time, the number of auxiliary units automatically calculated according to the conversion relation is rounded, the calculated number of the auxiliary units leaving the warehouse at the last time is not consistent with the number of the auxiliary units of the stock materials before the warehouse at the last time, and the inconsistent part is called tail difference. Due to the occurrence of the tail error, the ex-warehouse list cannot be stored, and the operator of the ERP system needs to modify and adjust the ex-warehouse list in a manual mode. When the types and the quantity of the materials discharged from the warehouse are large, frequent manual mode is used for modification and adjustment, the working efficiency is reduced, and the workload of operators is increased.
Disclosure of Invention
The embodiment of the application provides a method for determining material warehouse-out data and a related device, and the calculation tail difference of the number of auxiliary units is adjusted to the number of the auxiliary units which are warehouse-out at the last time, so that when the basic unit number is completely warehouse-out, the number of the auxiliary units is also completely warehouse-out. Need not artifical adjustment, improved work efficiency, reduced operating personnel's work burden.
In view of the above, a first aspect of the present application provides a method for determining material warehouse-out data, including:
acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry, wherein the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry is the quantity of all the auxiliary units of the discharged materials in the warehouse after the last material warehouse entry;
acquiring the quantity of all the auxiliary units taken out of the warehouse after the last warehousing and before the current warehouse-out, wherein the quantity of all the auxiliary units taken out of the warehouse after the last warehousing and before the current warehouse-out is the quantity of the auxiliary units taken out of the warehouse of the materials after the last warehousing and before the current warehouse-out;
and determining the quantity of the auxiliary units for the warehouse-out according to the quantity of the auxiliary units for the warehouse-out after the last warehouse-in and the quantity of the auxiliary units for the warehouse-out before the warehouse-out after the last warehouse-in.
With reference to the first aspect of the embodiment of the present application, in a first possible implementation manner of the first aspect, the acquiring the number of all ex-warehouse auxiliary units before the ex-warehouse of this time after the previous warehousing includes:
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the auxiliary unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing according to the basic unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing and the conversion rate.
With reference to the first possible implementation manner of the first aspect of the present application, in a second possible implementation manner of the first aspect, the calculating, according to the basic unit quantities of all ex-warehouses before the ex-warehouse of the current time after the previous warehousing and the conversion rate, the auxiliary unit quantities of all ex-warehouses before the ex-warehouse of the current time after the previous warehousing includes:
calculating the quantity of all the auxiliary units which are delivered before the delivery after the last warehousing by adopting the following method:
wherein, FOutSecQty represents the number of auxiliary units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, FOutBaseQty represents the number of basic units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, and a represents the conversion rate.
With reference to the first aspect of the present application, in a third possible implementation manner of the first aspect, the obtaining the number of all the auxiliary units ex-warehouse after the previous warehousing includes:
acquiring the quantity of auxiliary units which are stored immediately after the last warehousing, wherein the quantity of the auxiliary units which are stored immediately after the last warehousing is the quantity of the auxiliary units of the materials stored in the warehouse after the last warehousing of the materials;
acquiring the basic unit quantity of the warehouse-out of the time, wherein the basic unit quantity of the warehouse-out of the time is the basic unit quantity of the materials of the warehouse-out of the time;
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the materials are put into the warehouse and before the current ex-warehouse;
acquiring the basic unit quantity of the real-time stock after the last warehousing, wherein the basic unit quantity of the real-time stock after the last warehousing is the basic unit quantity of the materials stored in the warehouse after the last warehousing of the materials;
and calculating the quantity of all the auxiliary units which are delivered after the previous warehousing according to the quantity of the auxiliary units which are immediately stocked after the previous warehousing, the quantity of the basic units which are delivered at the present time, the quantity of all the basic units which are delivered before the current warehousing after the previous warehousing and the quantity of the basic units which are immediately stocked after the previous warehousing.
With reference to the third possible implementation manner of the first aspect of the present application, in a fourth possible implementation manner of the first aspect, the calculating, according to the number of auxiliary units in the immediate inventory after the previous warehousing, the number of basic units ex-warehouse this time after the previous warehousing and the number of basic units in the immediate inventory after the previous warehousing, the number of auxiliary units ex-warehouse after the previous warehousing includes:
calculating the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry by adopting the following method:
the fast ecqty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, the FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, the FBaseQty represents the number of basic units in the ex-warehouses at this time, the FOutBaseQty represents the number of basic units in all ex-warehouses before the ex-warehouses at this time after the previous warehousing, and the FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
With reference to the first aspect of the present application to the fourth possible implementation manner of the first aspect, in a fifth possible implementation manner of the first aspect, the determining the number of auxiliary units to be ex-warehoused this time according to the number of auxiliary units to be ex-warehoused all the time after the previous warehousing and the number of auxiliary units to be ex-warehoused all the time before the ex-warehousing this time after the previous warehousing includes:
calculating the quantity of the auxiliary units for the warehouse-out in the following way:
FSecQty=FASecQty-FOutSecQty;
the FSecQty represents the number of auxiliary units for the warehouse-out at this time, the fastecqty represents the number of auxiliary units for all warehouse-out after the last warehouse-in, the FOutSecQty represents the number of auxiliary units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, the FBegSecQty represents the number of auxiliary units for the immediate inventory after the last warehouse-in, the FBaseQty represents the number of basic units for the warehouse-out at this time, the foutbase qty represents the number of basic units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, and the FBegBaseQty represents the number of basic units for the immediate inventory after the last warehouse-in.
A second aspect of the present application provides a data processing apparatus comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry, and the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry is the quantity of all the auxiliary units discharged from the warehouse after the last material warehouse entry;
the acquisition module is further configured to acquire the number of auxiliary units that are delivered from the warehouse after the last warehousing and before the present delivery, where the number of auxiliary units that are delivered from the warehouse after the last warehousing and before the present delivery is the number of auxiliary units that are delivered from the warehouse after the last warehousing and before the present delivery;
and the determining module is used for determining the quantity of the auxiliary units discharged at this time according to the quantity of the auxiliary units discharged after the last warehousing and the quantity of the auxiliary units discharged before the current warehouse-out after the last warehousing, which are acquired by the acquiring module.
With reference to the second aspect of the present application, in a first possible implementation manner of the second aspect, the method includes:
the obtaining module is specifically configured to obtain the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing, where the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing is the basic unit quantity of the materials out of the warehouse before the ex-warehouse of the current time after the previous warehousing;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the auxiliary unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing according to the basic unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing and the conversion rate.
With reference to the first possible implementation manner of the second aspect, in a second possible implementation manner of the second aspect, the method includes:
the acquisition module is specifically configured to calculate the number of all ex-warehouse auxiliary units after the previous warehousing and before the current ex-warehouse by adopting the following method:
wherein, FOutSecQty represents the number of auxiliary units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, FOutBaseQty represents the number of basic units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, and a represents the conversion rate.
With reference to the second aspect, in a third possible implementation manner of the second aspect, the method includes:
the acquisition module is specifically configured to acquire the number of auxiliary units that are stocked immediately after the last warehousing, where the number of auxiliary units that are stocked immediately after the last warehousing is the number of auxiliary units of the material stored in the warehouse after the last warehousing of the material;
the obtaining module is specifically configured to obtain the basic unit quantity of the warehouse-out this time, where the basic unit quantity of the warehouse-out this time is the basic unit quantity of the materials of the warehouse-out this time;
the obtaining module is specifically configured to obtain the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the last warehousing, where the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the last warehousing is the basic unit quantity of the materials in the warehouse after the material is warehoused of the last time before the ex-warehouse of the current time;
the acquisition module is specifically configured to acquire a basic unit quantity of the real-time stock after the last warehousing, where the basic unit quantity of the real-time stock after the last warehousing is the basic unit quantity of the material stored in the warehouse after the last warehousing of the material;
the determining module is specifically configured to calculate the number of all the auxiliary units ex-warehouse after the previous warehousing according to the number of the auxiliary units in the real-time inventory after the previous warehousing, the number of the basic units ex-warehouse this time, the number of all the basic units ex-warehouse after the previous warehousing and the number of the basic units in the real-time inventory after the previous warehousing.
With reference to the third possible implementation manner of the second aspect of the present application, in a fourth possible implementation manner of the second aspect, the method includes:
the acquisition module is specifically configured to calculate the number of all the auxiliary units that have been delivered after the previous warehousing in the following manner:
the fast ecqty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, the FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, the FBaseQty represents the number of basic units in the ex-warehouses at this time, the FOutBaseQty represents the number of basic units in all ex-warehouses before the ex-warehouses at this time after the previous warehousing, and the FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
With reference to the second aspect to the fourth possible implementation manner of the second aspect, in a fifth possible implementation manner of the second aspect, the method includes:
the obtaining module is specifically configured to calculate the number of the auxiliary units for the warehouse-out in the following manner:
FSecQty=FASecQty-FOutSecQty;
the FSecQty represents the number of auxiliary units for the warehouse-out at this time, the fastecqty represents the number of auxiliary units for all warehouse-out after the last warehouse-in, the FOutSecQty represents the number of auxiliary units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, the FBegSecQty represents the number of auxiliary units for the immediate inventory after the last warehouse-in, the FBaseQty represents the number of basic units for the warehouse-out at this time, the foutbase qty represents the number of basic units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, and the FBegBaseQty represents the number of basic units for the immediate inventory after the last warehouse-in.
A third aspect of the present application provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method as described in the first aspect above.
A fourth aspect of the present application provides a computer-readable storage medium having stored therein instructions which, when run on a computer, cause the computer to perform the method according to the first aspect as described above.
A fifth aspect of the present application provides a computing device comprising: the system comprises a memory, a transceiver, a processor and a bus system;
wherein the memory is to store programs and instructions;
the transceiver is used for receiving or sending information under the control of the processor;
the processor is used for executing the program in the memory;
the bus system is used for connecting the memory, the transceiver and the processor so as to enable the memory, the transceiver and the processor to communicate;
the processor is configured to call program instructions in the memory to perform the method according to the first aspect.
According to the technical scheme, the embodiment of the application has the following advantages:
by the method, when the materials are completely delivered from the warehouse according to the basic unit quantity, namely the basic unit quantity of the warehouse is zero at the moment, the auxiliary unit quantity is also zero through the automatic adjustment of the tail difference at the moment. Need not artifical adjustment, improved work efficiency, reduced operating personnel's work burden.
Drawings
Fig. 1(a) is a schematic diagram of a framework for implementing an ERP system in an embodiment of the present application;
fig. 1(b) is another schematic diagram of a framework for implementing an ERP system in an embodiment of the present application;
FIG. 2 is a schematic diagram of an embodiment of a method for determining material warehouse-out data in the embodiment of the present application;
FIG. 3 is a schematic diagram of an embodiment of a data processing apparatus according to the present embodiment;
fig. 4 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making an invasive task, are within the scope of protection of the present application.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims of the present application and in the drawings described above, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The embodiment of the application provides a method for determining material warehouse-out data and a related device, and the calculation tail difference of the number of auxiliary units is adjusted to the number of the auxiliary units which are warehouse-out at the last time, so that when the basic unit number is completely warehouse-out, the number of the auxiliary units is also completely warehouse-out. Need not artifical adjustment, improved work efficiency, reduced operating personnel's work burden.
The application is applied to a warehouse management system in an ERP system. The warehouse management system is an important part of an EPR system, and effectively controls and tracks the whole logistics and cost management process of the warehouse business by warehousing businesses (including outsourcing warehousing, product warehousing, outsourcing warehousing, other warehousing and gift warehousing and the like), ex-warehouse businesses (including selling ex-warehouse, receiving a bill of material, outsourcing ex-warehouse, other ex-warehouse and gift ex-warehouse and the like), warehouse allocation and inventory adjustment (including inventory filling and inventory shortage damage), and the comprehensive application of the functions of batch management material correspondence, inventory checking, quality inspection management, virtual warehouse management, timely inventory management and the like, so that the complete enterprise warehouse information management is realized.
For ease of understanding, the following description will be made with reference to fig. 1(a) and 1 (b). Referring to fig. 1(a), fig. 1(a) is a schematic diagram of a framework for implementing the ERP system in the embodiment of the present application, and when the ERP system, which is used for executing the method for determining the material warehouse-out data and the data processing apparatus provided in the embodiment of the present application, is deployed in a computing device, a user may perform warehouse management operations by directly operating the ERP system in the computing device. Fig. 1(b) is another frame diagram for implementing an ERP system in this embodiment, where the ERP system running the method for determining material ex-warehouse data and the data processing device provided in this embodiment is deployed in a server in a computing device, and the computing device operates the ERP system running on the server through a command-line interface (CLI) or a Graphical User Interface (GUI) and performs warehouse management.
The computing devices in fig. 1(a) and 1(b) may be implemented in various forms, for example, a terminal device connected to a computer in which the ERP system is deployed, a Personal Digital Assistant (PDA), a Portable Media Player (PMP), a portable computer, a desktop computer, a smart phone, and the like as shown in the figure, and may be other wearable devices in which the ERP system is deployed besides the computing devices shown in the figure. The data information of the materials in the warehouse acquired by the computing equipment comprises the following steps: the data information of the material can be obtained intelligently through a sensor in the warehouse, wherein the computing equipment is connected with the sensor in the warehouse through a communication link, and the data information of the material can be recorded through manual statistics and the computing equipment, which is not limited herein. The manner in which the computing device and the server are connected may be a communication link. The communication link includes a wired communication link such as an optical fiber and a cable, and also includes a wireless communication link such as a microwave, wireless-fidelity (WI-FI) technology, a bluetooth or ZigBee protocol (ZigBee) technology, and the like, which is not limited herein. The data information of the material comprises: the name, the quantity, the grade and the specification of the materials, the conditions of entering and leaving the warehouse, the conditions of the warehouse and the like. It should be understood that the number of computing devices, the number of servers, the number of warehouses, and the content of interaction are all determined according to an actual scenario, and in an actual application, the number of computing devices, the number of servers, and the number of warehouses are not limited, and a server may be an independent server or a server cluster composed of a plurality of servers, and therefore, the number is not limited herein.
The quantity of the material includes the quantity of the basic unit and the quantity of the auxiliary unit, and the definitions of the quantity of the basic unit and the quantity of the auxiliary unit are illustrated below. Taking the material "wine" as an example, when the material "wine" is counted, the used measurement units can be: "liter", "bottle", "box" and "card" etc. In the ERP system applying the method for determining the material ex-warehouse data and the related device, for the case of multiple metering units, one metering unit is designated as a main metering unit and is called as a basic unit quantity, and other metering units are designated as auxiliary metering units and are called as auxiliary unit quantities.
Referring to fig. 2, fig. 2 is a schematic view of an embodiment of a method for determining material ex-warehouse data in an embodiment of the present application, including:
101. acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry;
in this embodiment, a computing device running an ERP system obtains the number of auxiliary units for all ex-warehouse materials after the last warehousing, where the number of auxiliary units for all ex-warehouse materials after the last warehousing is the number of auxiliary units for all ex-warehouse materials in a warehouse after the last warehousing, the number of auxiliary units for one ex-warehouse material is superposed every time when the materials are ex-warehouse, and when the materials are in-warehouse every time, the number of auxiliary units for all ex-warehouse materials after the last warehousing is cleared.
Specifically, for example, when 50 boxes of the material "wine" were put in storage for the last time, the basic unit number of putting in storage was 50 boxes, and the subsidiary unit number of the material "wine" was determined to be a bottle. The number of auxiliary units put in storage at this time was 300 bottles. The first time of delivery of 60 bottles, the second time of delivery of 60 bottles and the third time of delivery of 60 bottles. And at the moment of the third ex-warehouse, the quantity of all the ex-warehouse auxiliary units after the last ex-warehouse is 180 sum of the quantities of the first ex-warehouse auxiliary units, the second ex-warehouse auxiliary units and the third ex-warehouse auxiliary units. And when the material 'wine' is delivered out of the warehouse for the third time, warehousing the material, and after the material is warehoused for the last time, keeping the quantity of all auxiliary units delivered out of the warehouse to be 0.
102. Acquiring the quantity of all the auxiliary units which are delivered from the warehouse after the last warehouse entry and before the current warehouse delivery;
in this embodiment, a computing device running an ERP system obtains the number of auxiliary units that were taken out of the warehouse after the last warehousing and before the current warehouse-out, where the number of auxiliary units that were taken out of the warehouse after the last warehousing and before the current warehouse-out is the number of auxiliary units that were taken out of the warehouse after the last warehousing and before the current warehouse-out, after the last warehousing, the number of auxiliary units that were taken out of the warehouse will be superimposed every time when the materials except for the current warehouse-out are taken out of the warehouse, and when the materials are put into the warehouse every time, the number of auxiliary units that were taken out of the warehouse after the last warehousing and before the current warehouse-out will be reset.
Specifically, for example, when 50 boxes of the material "wine" were put in storage for the last time, the number of basic units put in storage was 50 boxes, and the number of auxiliary units put in storage at this time was 300 bottles. The first time of delivery of 60 bottles, the second time of delivery of 60 bottles and the third time of delivery of 60 bottles. At the time of the third ex-warehouse, the number of the auxiliary units for all ex-warehouses before the current ex-warehouse after the last warehousing is 120 which is the sum of the number of the auxiliary units for the first ex-warehouse and the number of the auxiliary units for the second ex-warehouse.
103. And determining the quantity of the auxiliary units for the warehouse-out at this time according to the quantity of the auxiliary units for the warehouse-out after the warehouse-in at the last time and the quantity of the auxiliary units for the warehouse-out before the warehouse-out at this time after the warehouse-in at the last time.
In this embodiment, after the computing device running the ERP system obtains the number of auxiliary units that have been delivered from the warehouse after the last warehouse entry and the number of auxiliary units that have been delivered from the warehouse before the warehouse exit after the last warehouse entry, the number of auxiliary units that have been delivered from the warehouse exit at this time may be determined according to the two numbers of auxiliary units.
Specifically, for example, when 50 boxes of the material "wine" were put in storage for the last time, the number of basic units put in storage was 50 boxes, and the number of auxiliary units put in storage at this time was 300 bottles. The first time of delivery of 60 bottles, the second time of delivery of 60 bottles and the third time of delivery of 60 bottles. At the time of the third ex-warehouse, the number of the auxiliary units ex-warehouse before the current ex-warehouse after the last ex-warehouse is 120 which is the sum of the number of the auxiliary units ex-warehouse for the first time and the number of the auxiliary units ex-warehouse for the second time, and the number of the auxiliary units ex-warehouse after the last ex-warehouse is 180 which is the sum of the number of the auxiliary units ex-warehouse for the first time, the number of the auxiliary units ex-warehouse for the second time and the number of the auxiliary units ex-warehouse for the. Therefore, the number of the auxiliary units for the warehouse-out at this time can be determined according to the number of the auxiliary units for the warehouse-out at this time after the warehouse-in at the last time and the number of the auxiliary units for the warehouse-out at all the warehouse-out after the warehouse-in at the last time, namely the unit number for the warehouse-out at the third time is 60.
In the embodiment of the application, the number of the auxiliary units taken out of the warehouse at this time can be determined according to the number of the auxiliary units taken out of the warehouse at this time after the last warehouse entry and the number of the auxiliary units taken out of the warehouse at last time after the warehouse entry, thereby avoiding the occurrence of tail error, avoiding manual adjustment, improving the working efficiency and reducing the workload of operators.
Optionally, on the basis of the embodiment corresponding to fig. 2, another optional embodiment of the method for determining the material ex-warehouse data provided in the embodiment of the present application includes:
before acquiring the auxiliary unit quantity of all ex-warehouses before the ex-warehouses of the current time after the previous warehousing, acquiring the basic unit quantity of all ex-warehouses before the ex-warehouses of the current time after the previous warehousing;
obtaining a conversion rate;
calculating the number of all the auxiliary units which are delivered out of the warehouse before the warehouse is delivered out of the warehouse after the warehouse is delivered for the last time according to the number of all the basic units which are delivered out of the warehouse before the warehouse is delivered out of the warehouse after the warehouse is delivered for the last time and the conversion rate;
in this embodiment, after the last warehousing, the number of basic units of all the ex-warehouses before the current ex-warehouse is the number of basic units of the materials in the warehouse after the last warehousing, the conversion rate is used to represent the conversion relationship between the number of auxiliary units and the number of basic units, and after the number of basic units of all the ex-warehouses before the current ex-warehouse after the last warehousing and the conversion rate are obtained, the number of auxiliary units of all the ex-warehouses before the current ex-warehouse after the last warehousing can be calculated.
Calculating the number of all the auxiliary units for ex-warehouse after the last warehousing and before the ex-warehouse of this time by adopting the following method:
wherein, FOUTSecQty represents the number of auxiliary units which are delivered from the warehouse after the last warehouse entry and before the warehouse delivery, FOUTBaseQty represents the number of basic units which are delivered from the warehouse after the last warehouse entry and before the warehouse delivery, and A represents the conversion rate.
Specifically, when the fundamental unit quantity, i.e., FOutBaseQty, of all ex-warehouses before the current ex-warehouse after the previous warehousing is equal to 500 and the conversion rate between the auxiliary unit quantity and the fundamental unit quantity is 0.8, the conversion rate is calculated according to the formula
The number of auxiliary units for all ex-warehouses before the ex-warehouses at the last time can be calculated
I.e., FOutSecQty equals 625.
In the embodiment of the present application, a method for calculating the number of auxiliary units according to the obtained number of basic units and the conversion rate is provided, which illustrates how the number of auxiliary units is obtained in the present application, and thus, the practicability of the scheme is increased.
Optionally, on the basis of the embodiment corresponding to fig. 2, another optional embodiment of the method for determining the material ex-warehouse data provided in the embodiment of the present application includes:
acquiring the quantity of auxiliary units which are immediately stored after the last warehousing;
acquiring the basic unit quantity of the warehouse-out;
acquiring the basic unit quantity of all ex-warehouses after the last warehousing and before the current ex-warehouse;
acquiring the number of the basic units of the real-time stock after the last warehousing;
and calculating the quantity of all the auxiliary units after the last warehousing according to the quantity of the auxiliary units immediately stored after the last warehousing, the quantity of the basic units taken out of the warehouse at this time, the quantity of the basic units taken out of the warehouse before the current warehousing after the last warehousing and the quantity of the basic units immediately stored after the last warehousing.
In this embodiment, the obtained basic unit quantity of the present warehouse-out is the basic unit quantity of the material of the present warehouse-out, the obtained basic unit quantities of all warehouse-out before the present warehouse-out after the previous warehouse-in are the basic unit quantities of the material in the warehouse-out before the present warehouse-out after the previous warehouse-in, and the obtained basic unit quantity of the material immediately stored after the previous warehouse-in is the basic unit quantity of the material stored in the warehouse-in after the previous warehouse-in. After the auxiliary unit quantity instantly stored after the previous warehousing, the basic unit quantity going out of the warehouse at the current time, the basic unit quantity going out of the warehouse before the current warehousing after the previous warehousing and the basic unit quantity instantly stored after the previous warehousing are obtained, calculating the auxiliary unit quantity going out of the warehouse after the previous warehousing according to the auxiliary unit quantity instantly stored after the previous warehousing, the basic unit quantity going out of the warehouse at the current time, the basic unit quantity going out of the warehouse after the previous warehousing before the current warehousing and the basic unit quantity instantly stored after the previous warehousing.
The number of auxiliary units in the instant stock after the last warehousing comes from an instant stock table in an ERP system applied to the application; the basic unit quantity of the warehouse-out comes from data input by a user in a data interface in the ERP system applied by the application; the basic unit quantity of all ex-warehouses before the ex-warehouse of the time after the last warehousing comes from an instant inventory table in the ERP system applied to the application. The instant inventory table is used for representing the warehouse in-out condition and the inventory condition of materials in a corresponding warehouse in the ERP system.
The method comprises the following steps of calculating the number of all the ex-warehouse auxiliary units after the last warehouse-in:
FASecQty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, FBaseQty represents the number of basic units in the current ex-warehouse, FOutBaseQty represents the number of basic units in all ex-warehouses before the current ex-warehouse after the previous warehousing, and FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
Specifically, when the FBegBaseQty, which is the basic unit quantity of the immediate inventory after the previous warehousing, is 600, the FBegSecQty, which is the auxiliary unit quantity of the immediate inventory after the previous warehousing, can be calculated according to the conversion rate of 0.8 and the formula
750 is obtained by calculation, when the basic unit quantity of all ex-warehouses before the ex-warehouse of the time after the previous warehousing, namely FOutBaseQty, is 500, and the basic unit quantity of the ex-warehouse of the time, namely FBaseQty, is 50, at this moment, according to a formula
Fastecqty is calculated to be 687.5.
In the embodiment of the application, a method for calculating the number of all the auxiliary units after the previous warehousing according to the obtained number of the basic units ex warehouse this time, the number of the auxiliary units in the instant warehousing after the previous warehousing, the number of all the basic units ex warehouse before the previous warehousing and the number of the basic units in the instant warehousing after the previous warehousing is provided, and how to obtain the number of the auxiliary units in the application and the practicability of the scheme are improved is described.
Optionally, on the basis of the embodiment corresponding to fig. 2, another optional embodiment of the method for determining the material ex-warehouse data provided in the embodiment of the present application includes:
acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry;
acquiring the quantity of all the auxiliary units which are delivered from the warehouse after the last warehouse entry and before the current warehouse delivery;
and calculating to obtain the number of the auxiliary units for the warehouse-out according to the obtained number of the auxiliary units for the warehouse-out after the last warehouse-in and the obtained number of the auxiliary units for the warehouse-out before the warehouse-out after the last warehouse-in.
In this embodiment, the number of auxiliary units for all ex-warehouses after the previous warehousing is obtained, and the number of auxiliary units for all ex-warehouses after the previous warehousing is the number of auxiliary units for all ex-warehouses after the previous warehousing, and the number of auxiliary units for all ex-warehouses immediately after the previous warehousing is obtained by calculation according to the number of basic units for the current ex-warehouses, the number of auxiliary units for immediate warehousing immediately after the previous warehousing, the number of basic units for all ex-warehouses before the current ex-warehouses after the previous warehousing, and the number of basic units for immediate warehousing immediately after the previous warehousing. And acquiring the quantity of all the auxiliary units taken out of the warehouse after the last warehouse entry and before the warehouse exit, wherein the quantity of all the auxiliary units taken out of the warehouse after the last warehouse entry and before the warehouse exit is the quantity of the auxiliary units of all the materials taken out of the warehouse after the last material warehouse entry and before the warehouse exit, and the quantity of all the auxiliary units taken out of the warehouse after the last warehouse entry and before the warehouse exit can be calculated according to the basic unit quantity and the conversion rate of all the materials taken out of the warehouse. The basic unit quantity of all ex-warehouses before the ex-warehouse of the previous time after the warehousing is a new variable obtained according to the instant inventory table in the ERP system applied to the application.
The method comprises the following steps of calculating the quantity of auxiliary units for warehouse-out at this time by adopting the following mode:
FSecQty=FASecQty-FOutSecQty;
FSecQty represents the number of auxiliary units in the warehouse at this time, FASecQty represents the number of auxiliary units in all warehouses after the warehouse is put in last time, FOUTSecQty represents the number of auxiliary units in all warehouses before the warehouse is put out last time after the warehouse is put in last time, FBegSecQty represents the number of auxiliary units in the warehouse immediately after the warehouse is put in last time, FBaseQty represents the number of basic units in the warehouse at this time, FOUTBaseQty represents the number of basic units in all warehouses before the warehouse is put out last time after the warehouse is put in last time, and FBegBaseQty represents the number of basic units in the warehouse immediately after the warehouse is put in last time.
The specific derivation process of the above formula is as follows:
the original calculation formula is subjected to equivalent transformation through a multiplicative commutative law,
the original calculation formula is subjected to equivalence transformation, a new variable FOutBaseQty is introduced,
according to the multiplication distribution law, making formula conversion to obtain auxiliary unit quantity calculation formula,
as a result of this, it is possible to,
it is thus possible to obtain,
FSecQty=FASecQty-FOutSecQty。
in the embodiment of the application, a method for calculating the number of the auxiliary units for the present ex-warehouse according to the number of the auxiliary units for the present ex-warehouse after the last warehousing and the number of the auxiliary units for the present ex-warehouse before the last warehousing is provided, because the number of the auxiliary units for the present ex-warehouse after the last warehousing is calculated from the number of the basic units for the present ex-warehouse after the last warehousing and the conversion rate, the obtained data has a tail difference caused by rounding, the number of the auxiliary units for the present ex-warehouse after the last warehousing is calculated from the number of the basic units for the present ex-warehouse after the last warehousing and the conversion rate, the obtained data also has a tail difference caused by rounding, and therefore when the two are subtracted, the tail difference is subtracted, so that the calculated number of the auxiliary units for the present ex-warehouse has no tail difference, the feasibility of the scheme is improved.
For the convenience of understanding, the following describes a method for determining material warehouse-out data and an application scenario of a related device in the present application with reference to table 1, as shown in the table, specifically:
TABLE 1
After one-time warehousing, the stock basic unit quantity of the material in the warehouse is 50, the conversion rate is 0.0040445, the stock auxiliary unit quantity can be calculated according to the stock basic unit quantity and the conversion rate, 7 decimal places of the auxiliary unit quantity are reserved according to the rounding rule and are 12362.4675485, at the moment, the real-time stock basic unit quantity is 50, and the real-time stock auxiliary unit quantity is 12362.4675485. And in the fourth warehouse-out process, the number of the auxiliary units in warehouse-out is equal to the sum of the number of the auxiliary units in the warehouse-out in the last warehouse-in process minus the number of the auxiliary units in the warehouse-out in the previous three times, namely the number of the auxiliary units in warehouse-out in the fourth warehouse-out process is 12362.4675485-4944.9870194-4944.9870194-1236.2467549 which is 1236.2467548 and is equal to the number of the auxiliary units in warehouse-out in the third warehouse-out process, and tail differences are eliminated in the calculation process.
It should be noted that the data in the list is obtained according to the actual application, and the data provided in this embodiment is only in an illustrative form and has no limiting meaning.
In the embodiment of the application, by adopting the scheme, when the warehouse is taken out for the last time and the basic unit quantity is completely taken out, the sum of the auxiliary unit quantity in the instant stock after the latest warehouse entry minus the auxiliary unit quantity during the previous warehouse exit for three times is used, and the calculated auxiliary unit quantity for the last warehouse exit, namely the fourth warehouse exit is obtained, because the auxiliary unit quantity in the instant stock after the latest warehouse entry is calculated by the basic unit quantity in the instant stock after the latest warehouse entry and the conversion rate, and the sum of the auxiliary unit quantities during the previous warehouse exit for three times is calculated by the sum of the basic unit quantity during the previous warehouse exit for three times and the conversion rate, tail differences generated by rounding off during the calculation of the two are mutually offset, the obtained auxiliary unit quantity during the last warehouse exit of the calculation result is equal to the auxiliary unit quantity of the warehouse after the third warehouse exit, the tail difference is eliminated. Under the condition that the basic unit quantity is completely delivered, the auxiliary unit quantity is also completely delivered without manual adjustment, so that the working efficiency is improved.
Referring to fig. 3, fig. 3 is a schematic diagram of an embodiment of a data processing apparatus 20 according to the present application, in which the data processing apparatus 20 includes:
the acquisition module 201 is configured to acquire the number of all the auxiliary units ex-warehouse after the last warehousing, where the number of all the auxiliary units ex-warehouse after the last warehousing is the number of all the auxiliary units ex-warehouse in the warehouse after the last warehousing;
the obtaining module 201 is further configured to obtain the number of auxiliary units for ex-warehouse after the last warehousing and before the current ex-warehouse, where the number of auxiliary units for ex-warehouse after the last warehousing and before the current ex-warehouse is the number of auxiliary units for ex-warehouse of the material in the warehouse after the last warehousing and before the current ex-warehouse;
the determining module 202 is configured to determine the number of the auxiliary units to be delivered at this time according to the number of the auxiliary units to be delivered after the previous warehousing and the number of the auxiliary units to be delivered before the current delivery after the previous warehousing, which are acquired by the acquiring module 201.
In this embodiment, the obtaining module 201 is configured to obtain the number of auxiliary units for all the materials leaving the warehouse after the last warehousing, where the number of auxiliary units for all the materials leaving the warehouse after the last warehousing is the number of auxiliary units for all the materials leaving the warehouse after the last warehousing; the obtaining module 201 is further configured to obtain the number of auxiliary units for ex-warehouse before the ex-warehouse of this time after the last warehousing, where the number of auxiliary units for ex-warehouse before the ex-warehouse of this time after the last warehousing is the number of auxiliary units for ex-warehouse of materials in the warehouse before the ex-warehouse of this time after the last warehousing of materials; the determining module 202 is configured to determine the number of the auxiliary units to be delivered at this time according to the number of the auxiliary units to be delivered after the previous warehousing and the number of the auxiliary units to be delivered before the delivery after the previous warehousing, which are acquired by the acquiring module 201.
In the embodiment of the application, the number of the auxiliary units taken out of the warehouse at this time can be determined according to the number of the auxiliary units taken out of the warehouse at this time after the last warehouse entry and the number of the auxiliary units taken out of the warehouse at last time after the warehouse entry, thereby avoiding the occurrence of tail error, avoiding manual adjustment, improving the working efficiency and reducing the workload of operators.
Alternatively, on the basis of the first alternative embodiment of the data processing device 20 corresponding to fig. 3, in the second alternative embodiment of the data processing device 20 provided in the embodiment of the present application,
the obtaining module 201 is specifically configured to obtain the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing, where the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing is the basic unit quantity of the materials in the warehouse out-warehouse of the current time after the previous warehousing;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the quantity of all the auxiliary units which are delivered before the delivery after the last warehousing according to the quantity of all the basic units which are delivered before the delivery after the last warehousing and the conversion rate.
In this embodiment of the application, the obtaining module 201 may calculate, according to the obtained basic unit number and the conversion rate of all ex-warehouses before the ex-warehouse of this time after the last warehousing, the number of auxiliary units of all ex-warehouses before the ex-warehouse of this time after the last warehousing, so as to improve the practicability of the scheme.
Alternatively, on the basis of the second alternative embodiment of the data processing device 20 corresponding to fig. 3, in a third alternative embodiment of the data processing device 20 provided in the embodiment of the present application,
the obtaining module 201 is specifically configured to calculate the number of all the auxiliary units going out of the warehouse after the last warehousing and before the current warehouse-out in the following manner:
wherein, FOUTSecQty represents the number of auxiliary units before the current warehouse-out after the last warehouse-in, FOUTBaseQty represents the number of basic units before the current warehouse-out after the last warehouse-in, and A represents the conversion rate.
In the embodiment of the present application, the process of calculating the number of all the auxiliary units to be delivered before the delivery of the current time after the last time of the delivery by the obtaining module 201 according to the calculation formula is specifically described, so that the feasibility of the scheme is improved.
Alternatively, on the basis of the first alternative embodiment of the data processing device 20 corresponding to fig. 3, in a fourth alternative embodiment of the data processing device 20 provided in the embodiment of the present application,
the obtaining module 201 is specifically configured to obtain the number of auxiliary units that are immediately stocked after the last warehousing, where the number of auxiliary units that are immediately stocked after the last warehousing is the number of auxiliary units of the material stored in the warehouse after the last warehousing;
the obtaining module 201 is specifically configured to obtain the basic unit quantity of the present ex-warehouse, where the basic unit quantity of the present ex-warehouse is the basic unit quantity of the present ex-warehouse;
the obtaining module 201 is specifically configured to obtain the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing, where the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the previous warehousing is the basic unit quantity of the materials in the warehouse out-warehouse of the current time after the previous warehousing;
the obtaining module 201 is specifically configured to obtain the basic unit quantity of the instant stock after the last warehousing, where the basic unit quantity of the instant stock after the last warehousing is the basic unit quantity of the material stored in the warehouse after the last warehousing;
the determining module 202 is specifically configured to calculate the number of all the auxiliary units ex-warehouse after the previous warehousing according to the number of the auxiliary units in the immediate inventory after the previous warehousing, the number of the basic units ex-warehouse this time, the number of all the basic units ex-warehouse after the previous warehousing before the current ex-warehouse, and the number of the basic units in the immediate inventory after the previous warehousing.
In the embodiment of the application, a method is provided, after acquiring the number of auxiliary units in real-time inventory after the last warehousing, the number of basic units in the current ex-warehouse, the number of all basic units in the current ex-warehouse after the last warehousing and the number of the basic units in the real-time inventory after the last warehousing, and calculating the number of all the auxiliary units in the last ex-warehouse according to the number of the auxiliary units in real-time inventory after the last warehousing, the number of the basic units in the current ex-warehouse, the number of all the basic units in the current ex-warehouse after the last warehousing and the number of the basic units in the real-time inventory after the last warehousing. The realization flexibility of the scheme is improved.
Alternatively, on the basis of the fourth alternative embodiment of the data processing device 20 corresponding to fig. 3, in a fifth alternative embodiment of the data processing device 20 provided in the embodiment of the present application,
the obtaining module 201 is specifically configured to calculate the number of all the auxiliary units going out of the warehouse after the last warehouse entry in the following manner:
wherein, FASecQty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, FBaseQty represents the number of basic units in the present ex-warehouse, FOutBaseQty represents the number of basic units in all ex-warehouses before the present ex-warehouse after the previous warehousing, and FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
In the embodiment of the application, a specific formula is provided for the auxiliary unit quantity immediately after the previous warehousing, the basic unit quantity at the present ex-warehouse, and the basic unit quantity immediately after the previous warehousing and after the previous ex-warehouse of all the basic unit quantities before the present ex-warehouse. And the number of all the auxiliary units which are delivered out of the warehouse after the last warehouse entry is calculated, so that the feasibility of the scheme is improved.
Optionally, on the basis of any one of the first optional embodiment to the fifth optional embodiment of the data processing device 20 corresponding to fig. 3, in a sixth optional embodiment of the data processing device 20 provided in the embodiments of the present application,
the obtaining module 201 is specifically configured to calculate the number of the auxiliary units to be delivered from the warehouse in the following manner:
FSecQty=FASecQty-FOutSecQty;
wherein FSecQty represents the number of auxiliary units in the warehouse at this time, FASecQty represents the number of auxiliary units in all warehouses after the warehouse is input last time, FOUTSecQty represents the number of auxiliary units in all warehouses before the warehouse is output last time after the warehouse is input last time, FBegSecQty represents the number of auxiliary units in the warehouse immediately after the warehouse is input last time, FBaseQty represents the number of basic units in the warehouse at this time, FOUTBaseQty represents the number of basic units in all warehouses before the warehouse is output last time after the warehouse is input last time, and FBegBaseQty represents the number of basic units in the warehouse immediately after the warehouse is input last time.
In the embodiment of the application, a specific formula is provided for calculating the number of the auxiliary units taken out of the warehouse at this time according to the number of the auxiliary units taken out of the warehouse after the last warehouse entry and the number of the auxiliary units taken out of the warehouse before the warehouse exit after the last warehouse entry, so that the practicability of the scheme is improved.
Fig. 4 is a schematic structural diagram of a data processing apparatus provided in an embodiment of the present application, which may have a relatively large difference due to different configurations or performances, and may include one or more processors (CPUs) 322 (e.g., one or more processors) and a memory 332, and one or more storage media 330 (e.g., one or more mass storage devices) storing an application 342 or data 344. Memory 332 and storage media 330 may be, among other things, transient storage or persistent storage. The program stored on the storage medium 330 may include one or more modules (not shown), each of which may include a series of instructions operating on a data processing apparatus. Still further, the central processor 322 may be configured to communicate with the storage medium 330 to execute a series of instruction operations in the storage medium 330 on the data processing apparatus 300.
The data processing device 300 may also include one or more power supplies 326, one or more wired or wireless network interfaces 350, one or more input-output interfaces 358, and/or one or more operating systems 341, such as Windows ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, and so forth.
The steps performed by the data processing apparatus in the above-described embodiments may be based on the data processing apparatus structure shown in fig. 4.
In the embodiment of the present application, the CPU 322 included in the data processing apparatus further has the following functions:
acquiring the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry, wherein the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry is the quantity of all the auxiliary units discharged from the warehouse after the last material warehouse entry;
acquiring the quantity of all the auxiliary units which are delivered from the warehouse after the last warehousing and before the current delivery, wherein the quantity of all the auxiliary units which are delivered from the warehouse after the last warehousing and before the current delivery is the quantity of the auxiliary units which are delivered from the warehouse after the last warehousing and before the current delivery;
and determining the quantity of the auxiliary units for the warehouse-out at this time according to the quantity of the auxiliary units for the warehouse-out after the warehouse-in at the last time and the quantity of the auxiliary units for the warehouse-out before the warehouse-out at this time after the warehouse-in at the last time.
Optionally, the CPU 322 is further configured to perform the following steps:
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the quantity of all the auxiliary units which are delivered before the delivery after the last warehousing according to the quantity of all the basic units which are delivered before the delivery after the last warehousing and the conversion rate.
Optionally, the CPU 322 is further configured to perform the following steps:
calculating the number of auxiliary units for warehouse-out before warehouse-out for the current time after warehouse-in by adopting the following method:
wherein, FOUTSecQty represents the number of auxiliary units before the current warehouse-out after the last warehouse-in, FOUTBaseQty represents the number of basic units before the current warehouse-out after the last warehouse-in, and A represents the conversion rate.
Optionally, the CPU 322 is further configured to perform the following steps:
acquiring the number of auxiliary units which are immediately stored after the last warehousing, wherein the number of the auxiliary units which are immediately stored after the last warehousing is the number of the auxiliary units of the materials stored in the warehouse after the last material warehousing;
acquiring the basic unit quantity of the warehouse-out at this time, wherein the basic unit quantity of the warehouse-out at this time is the basic unit quantity of the materials of the warehouse-out at this time;
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the ex-warehouse of the current time, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the ex-warehouse of the current time is the basic unit quantity of the materials in the warehouse out-warehouse after the last material warehousing and before the ex-warehouse of the current time;
acquiring the basic unit quantity of the materials stored immediately after the materials are stored for the last time, wherein the basic unit quantity of the materials stored immediately after the materials are stored for the last time is the basic unit quantity of the materials stored in the warehouse after the materials are stored for the last time;
and calculating the quantity of all the auxiliary units after the last warehousing according to the quantity of the auxiliary units immediately stored after the last warehousing, the quantity of the basic units taken out of the warehouse at this time, the quantity of the basic units taken out of the warehouse before the current warehousing after the last warehousing and the quantity of the basic units immediately stored after the last warehousing.
Optionally, the CPU 322 is further configured to perform the following steps:
calculating the number of all the ex-warehouse auxiliary units after the last warehouse-in by adopting the following method:
wherein, FASecQty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, FBaseQty represents the number of basic units in the present ex-warehouse, FOutBaseQty represents the number of basic units in all ex-warehouses before the present ex-warehouse after the previous warehousing, and FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
Optionally, the CPU 322 is further configured to perform the following steps:
calculating the quantity of the auxiliary units for the warehouse-out in the following way:
FSecQty=FASecQty-FOutSecQty;
wherein FSecQty represents the number of auxiliary units in the warehouse at this time, FASecQty represents the number of auxiliary units in all warehouses after the warehouse is input last time, FOUTSecQty represents the number of auxiliary units in all warehouses before the warehouse is output last time after the warehouse is input last time, FBegSecQty represents the number of auxiliary units in the warehouse immediately after the warehouse is input last time, FBaseQty represents the number of basic units in the warehouse at this time, FOUTBaseQty represents the number of basic units in all warehouses before the warehouse is output last time after the warehouse is input last time, and FBegBaseQty represents the number of basic units in the warehouse immediately after the warehouse is input last time.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical functional division, and in actual implementation, there may be other divisions, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a hardware form, and can also be realized in a software functional unit form.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computing device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (12)
1. A method for determining material ex-warehouse data is characterized by comprising the following steps:
acquiring the quantity of auxiliary units which are immediately stored after the last warehousing, wherein the quantity of the auxiliary units which are immediately stored after the last warehousing is the quantity of the auxiliary units of the materials stored in the warehouse after the last warehousing of the materials;
acquiring the basic unit quantity of the warehouse-out of this time, wherein the basic unit quantity of the warehouse-out of this time is the basic unit quantity of the materials of the warehouse-out of this time;
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
acquiring the basic unit quantity of the instant stock after the last warehousing, wherein the basic unit quantity of the instant stock after the last warehousing is the basic unit quantity of the material stored in the warehouse after the last warehousing of the material;
calculating the number of all the auxiliary units which are delivered out of the warehouse after the last warehousing according to the number of the auxiliary units which are immediately stocked after the last warehousing, the number of the basic units which are delivered out of the warehouse this time, the number of the basic units which are delivered out of the warehouse after the last warehousing and the number of the basic units which are immediately stocked after the last warehousing;
acquiring the quantity of all the auxiliary units for ex-warehouse after the last warehousing and before the current ex-warehouse, wherein the quantity of all the auxiliary units for ex-warehouse after the last warehousing and before the current ex-warehouse is the quantity of the auxiliary units for ex-warehouse of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
and determining the quantity of the auxiliary units for the warehouse-out at this time according to the quantity of the auxiliary units for the warehouse-out after the last warehouse-in and the quantity of the auxiliary units for the warehouse-out before the warehouse-out at this time after the last warehouse-in.
2. The method according to claim 1, wherein the obtaining of the number of auxiliary units for ex-warehouse before the ex-warehouse of this time after the previous warehousing comprises:
acquiring the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, wherein the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the auxiliary unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing according to the basic unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing and the conversion rate.
3. The method according to claim 2, wherein the calculating of the number of the auxiliary units for all ex-warehouses before the ex-warehouse of the current time after the previous warehousing according to the number of the basic units for all ex-warehouses before the ex-warehouse of the current time after the previous warehousing and the conversion rate comprises:
calculating the quantity of all the auxiliary units for ex-warehouse before ex-warehouse after the last warehousing by adopting the following method:
wherein, FOutSecQty represents the number of auxiliary units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, FOutBaseQty represents the number of basic units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, and a represents the conversion rate.
4. The method according to claim 1, wherein the calculating of the number of auxiliary units that have been delivered after the previous warehousing according to the number of auxiliary units that have been immediately stocked after the previous warehousing, the number of basic units that have been delivered this time, the number of basic units that have been delivered after the previous warehousing before the current warehousing and the number of basic units that have been immediately stocked after the previous warehousing comprises:
calculating the quantity of all the auxiliary units discharged from the warehouse after the last warehouse entry by adopting the following method:
the fast ecqty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, the FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, the FBaseQty represents the number of basic units in the ex-warehouses at this time, the FOutBaseQty represents the number of basic units in all ex-warehouses before the ex-warehouses at this time after the previous warehousing, and the FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
5. The method according to any one of claims 1 to 4, wherein the determining the number of the auxiliary units for the current warehouse-out according to the number of the auxiliary units for all warehouse-out after the previous warehouse-in and the number of the auxiliary units for all warehouse-out before the current warehouse-out after the previous warehouse-in comprises:
calculating the quantity of the auxiliary units for the warehouse-out in the following way:
FSecQty=FASecQty-FOutSecQty;
the FSecQty represents the number of auxiliary units for the warehouse-out at this time, the fastecqty represents the number of auxiliary units for all warehouse-out after the last warehouse-in, the FOutSecQty represents the number of auxiliary units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, the FBegSecQty represents the number of auxiliary units for the immediate inventory after the last warehouse-in, the FBaseQty represents the number of basic units for the warehouse-out at this time, the foutbase qty represents the number of basic units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, and the fbbaseqty represents the number of basic units for the immediate inventory after the last warehouse-in.
6. A data processing apparatus, comprising:
the acquisition module is used for acquiring the number of auxiliary units which are immediately stored after the last warehousing, wherein the number of the auxiliary units which are immediately stored after the last warehousing is the number of the auxiliary units of the materials stored in the warehouse after the last warehousing of the materials;
the obtaining module is further configured to obtain the basic unit quantity of the warehouse-out this time, where the basic unit quantity of the warehouse-out this time is the basic unit quantity of the materials warehouse-out this time;
the acquisition module is further configured to acquire the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the last warehousing, where the basic unit quantity of all the ex-warehouses before the ex-warehouse of the current time after the last warehousing is the basic unit quantity of the materials in the warehouse after the material is warehoused of the last time before the ex-warehouse of the current time;
the acquisition module is further configured to acquire a basic unit quantity of the instant stock after the last warehousing, where the basic unit quantity of the instant stock after the last warehousing is the basic unit quantity of the material stored in the warehouse after the last warehousing of the material;
the determining module is further used for calculating the quantity of all the auxiliary units which are delivered out of the warehouse after the previous warehouse entry according to the quantity of the auxiliary units which are immediately stored after the previous warehouse entry, the quantity of the basic units which are delivered out of the warehouse at the current time, the quantity of the basic units which are delivered out of the warehouse after the previous warehouse entry and the quantity of the basic units which are immediately stored after the previous warehouse entry;
the acquisition module is further configured to acquire the number of auxiliary units for ex-warehouse before the ex-warehouse of the current time after the previous warehousing, where the number of auxiliary units for ex-warehouse before the ex-warehouse of the current time after the previous warehousing is the number of auxiliary units for ex-warehouse of the materials in the warehouse before the ex-warehouse of the current time after the previous warehousing of the materials;
the determining module is further configured to determine the number of the auxiliary units to be delivered according to the number of the auxiliary units to be delivered after the previous warehousing and the number of the auxiliary units to be delivered before the current warehousing.
7. The data processing apparatus according to claim 6, comprising:
the obtaining module is specifically configured to obtain the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse, where the basic unit quantity of all the ex-warehouses after the last warehousing and before the current ex-warehouse is the basic unit quantity of the materials in the warehouse after the last warehousing and before the current ex-warehouse;
acquiring a conversion rate, wherein the conversion rate is used for expressing the conversion relation between the auxiliary unit quantity and the basic unit quantity;
and calculating the auxiliary unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing according to the basic unit quantity of all ex-warehouses before the ex-warehouses at the time after the previous warehousing and the conversion rate.
8. The data processing apparatus according to claim 7, comprising:
the acquisition module is specifically configured to calculate the number of all the auxiliary units ex-warehouse after the previous warehousing and before the current ex-warehouse in the following manner:
wherein, FOutSecQty represents the number of auxiliary units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, FOutBaseQty represents the number of basic units for all ex-warehouses after the previous warehousing and before the current ex-warehouse, and a represents the conversion rate.
9. The data processing apparatus according to claim 6, comprising:
the acquisition module is specifically configured to calculate the number of all the ex-warehouse auxiliary units after the last warehousing in the following manner:
the fast ecqty represents the number of auxiliary units in all ex-warehouses after the previous warehousing, the FBegSecQty represents the number of auxiliary units in the immediate inventory after the previous warehousing, the FBaseQty represents the number of basic units in the ex-warehouses at this time, the FOutBaseQty represents the number of basic units in all ex-warehouses before the ex-warehouses at this time after the previous warehousing, and the FBegBaseQty represents the number of basic units in the immediate inventory after the previous warehousing.
10. A data processing apparatus according to any one of claims 6 to 9, comprising:
the acquisition module is specifically configured to calculate the number of the auxiliary units for the warehouse-out in the following manner:
FSecQty=FASecQty-FOutSecQty;
the FSecQty represents the number of auxiliary units for the warehouse-out at this time, the fastecqty represents the number of auxiliary units for all warehouse-out after the last warehouse-in, the FOutSecQty represents the number of auxiliary units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, the FBegSecQty represents the number of auxiliary units for the immediate inventory after the last warehouse-in, the FBaseQty represents the number of basic units for the warehouse-out at this time, the foutbase qty represents the number of basic units for all warehouse-out before the warehouse-out at this time after the last warehouse-in, and the fbbaseqty represents the number of basic units for the immediate inventory after the last warehouse-in.
11. A computer-readable storage medium having stored therein instructions which, when run on a computer, cause the computer to perform the method of any one of claims 1 to 5.
12. A computing device, comprising: a memory, a transceiver, a processor, and a bus system;
wherein the memory is to store programs and instructions;
the transceiver is used for receiving or sending information under the control of the processor;
the processor is used for executing the program in the memory;
the bus system is used for connecting the memory, the transceiver and the processor so as to enable the memory, the transceiver and the processor to communicate;
the processor is configured to call program instructions in the memory to perform the method of any of claims 1 to 5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811160643.7A CN109345173B (en) | 2018-09-30 | 2018-09-30 | Method for determining material ex-warehouse data and related device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811160643.7A CN109345173B (en) | 2018-09-30 | 2018-09-30 | Method for determining material ex-warehouse data and related device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109345173A CN109345173A (en) | 2019-02-15 |
CN109345173B true CN109345173B (en) | 2021-06-08 |
Family
ID=65307703
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811160643.7A Active CN109345173B (en) | 2018-09-30 | 2018-09-30 | Method for determining material ex-warehouse data and related device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109345173B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114943422A (en) * | 2022-04-26 | 2022-08-26 | 南通万天信息科技有限公司 | Intelligent management method and system for textile industry warehouse |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101706916A (en) * | 2009-12-10 | 2010-05-12 | 金蝶软件(中国)有限公司 | Inventory accounting method and device |
CN106408235A (en) * | 2016-09-12 | 2017-02-15 | 济南浪潮高新科技投资发展有限公司 | Method for realizing material unit composite metering in supply chain system |
CN106485579A (en) * | 2016-10-21 | 2017-03-08 | 百望股份有限公司 | A kind of tax declaration method |
-
2018
- 2018-09-30 CN CN201811160643.7A patent/CN109345173B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101706916A (en) * | 2009-12-10 | 2010-05-12 | 金蝶软件(中国)有限公司 | Inventory accounting method and device |
CN106408235A (en) * | 2016-09-12 | 2017-02-15 | 济南浪潮高新科技投资发展有限公司 | Method for realizing material unit composite metering in supply chain system |
CN106485579A (en) * | 2016-10-21 | 2017-03-08 | 百望股份有限公司 | A kind of tax declaration method |
Also Published As
Publication number | Publication date |
---|---|
CN109345173A (en) | 2019-02-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN113239317A (en) | Method and device for determining order fulfillment warehouse | |
CN109447549B (en) | Method for determining material position and related device | |
CN110443531A (en) | The method and apparatus for determining the bit information of article in order | |
CN110796416B (en) | Industrial networking based order processing method and computer storage medium | |
CN103246958A (en) | Production concentrating operation system of provincial power metering center | |
CN112381485A (en) | Material demand plan calculation method and related equipment | |
CN113627847A (en) | Method and device for generating replenishment list | |
CN109345173B (en) | Method for determining material ex-warehouse data and related device | |
CN114841819A (en) | Method and device for determining claim settlement scheme, electronic equipment and storage medium | |
Lau et al. | A case-based roadmap for lateral transshipment in supply chain inventory management | |
US20170344943A1 (en) | Incentivized adjustment of optimal delivery route | |
CN116562588A (en) | Enterprise supply chain analysis system, method and equipment based on ERP | |
CN116151718A (en) | Overseas warehouse management system, method, equipment and storage medium | |
US20170091683A1 (en) | Database system for distribution center fulfillment capacity availability tracking and method therefor | |
JP5499113B2 (en) | Production plan adjustment support device, production plan adjustment support method, and production plan adjustment support program | |
CN110363558A (en) | A kind of method and apparatus generating commodity association message | |
CN110033292A (en) | Information output method and device | |
CN108764854A (en) | Project control method, apparatus, electronic equipment and medium | |
CN113628025A (en) | Bill generation method and device, computer equipment and storage medium | |
CN112351105B (en) | Cloud service evaluation method and device | |
CN111260269A (en) | Store order processing method and device for improving distribution efficiency | |
US20230206176A1 (en) | Demand and supply planning apparatus and demand and supply planning method | |
JP2004252710A (en) | Cost profit management system, method and program | |
CN114881443B (en) | Dye vat allocation scheme determination method, dyeing device and equipment | |
US20230045667A1 (en) | Systems and methods for supply chain management |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |