JP7079676B2 - Warehouse management device, warehouse management method, and warehouse management program - Google Patents

Description

The present invention relates to an inventory management device, an inventory management method, and an inventory management program.

For example, in the cosmetics industry, when exporting overseas, it is necessary to set an expiration date according to the importing country. Patent Document 1 is a system for managing the inventory of cosmetics. In Patent Document 1,
[0017] "The system management headquarters 10 has excess or deficiency of required medicines, crude drugs, cosmetics directly or by interposing other companies, medicines, crude drugs, etc. supply group 14 to each pharmacy, drugstore, cosmetics store, etc. It can be supplied without any supply, and the inventory, quality, expiration date, etc. can be managed by the stored data of the system. Therefore, inventory management, quality control, and purchase management including the entire system of required medicines, crude drugs, and cosmetics are possible. , Sales management, etc. can be performed. "

Japanese Unexamined Patent Publication No. 2002-83050

However, Patent Document 1 does not describe anything about setting an expiration date for each customer or product type when allocating inventory of products.

The present invention has been made in view of the above, and is an inventory management device, an inventory management method, and an inventory management program capable of managing the expiration date for each business partner or product type when allocating inventory of products. The purpose is to provide.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management device provided with a control unit and a storage unit, and the storage unit is effective for each customer and / or for each product type classification. A master that registers the number of months and inventory data including the lot number, expiration date, and number of stocks for each product are stored, and the control unit responds to orders from domestic or overseas customers. An order data input unit that inputs order data including at least a customer, a product, an order date, and the number of orders, and based on the order data, create order data with reference to the inventory data and allocate inventory. In this case, referring to the master, the expiration date is calculated from the valid months and order date set in the corresponding customer and / or product classification, and the lot that satisfies the calculated expiration date in the inventory data. It is characterized by being equipped with an order data creation means for allocating a stock of numbers.

Further, according to the present embodiment, the master may further register the variety classification for each product.

Further, according to the present embodiment, the product may be a cosmetic product.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management method for causing an information processing apparatus provided with a control unit and a storage unit to execute the data, and the storage unit is good at it. A master that registers the number of valid months for each destination and / or type classification, and inventory data including the lot number, expiration date, and number of stocks for each product are stored, and are executed by the control unit in Japan. Or, in response to an order from an overseas customer, the order data input step for inputting order data including at least the customer, the product, the order date, and the number of orders, and the inventory data based on the order data. When creating order data by referring to and allocating inventory, the expiration date is calculated from the valid months set in the corresponding customer and / or type classification and the order date by referring to the master. Among the inventory data, the order data creation step of allocating the inventory of the lot number satisfying the calculated expiration date is included.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management program for causing an information processing apparatus including a control unit and a storage unit to execute the data, and the storage unit is good at it. A master in which the number of valid months is registered for each destination and / or type classification, and inventory data including the lot number, expiration date, and number of stocks for each product are stored. In the control unit, domestic or overseas Refer to the inventory data based on the order data and the order data entry step to enter the order data including at least the customer, the product, the order date, and the number of orders according to the order from the customer. When creating order data and allocating inventory, the expiration date is calculated from the effective months and order date set for the corresponding customer and / or type classification with reference to the master, and the inventory data. Among them, it is characterized by being an order data creation step for allocating inventory of lot numbers satisfying the calculated expiration date, and an inventory management program for executing.

According to the present invention, there is an effect that the expiration date can be managed for each customer or product type when the inventory of the product is allocated.

FIG. 1 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. FIG. 2 is a diagram showing a configuration example of a master and data. FIG. 3 is a diagram showing a flow for explaining the overall processing flow of the inventory management device according to the present embodiment. FIG. 4 is a diagram showing a display example for explaining an image of the distribution input process. FIG. 5 is sample data for explaining a process (effective inventory control at the time of automatic allocation) when an expiration date is set for each customer and / or for each type of product in the allocation input process.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
For example, in the cosmetics industry, when exporting overseas, it is necessary to set an expiration date according to the importing country. In addition, the expiration date differs depending on the variety of skin care products and the like. Some products have expiration dates managed, such as expiration dates and expiration dates, but there are cases where each customer wants to ship with the expiration date taken into consideration. For example, in the cosmetics industry, there is a three-year quality guarantee, so it is permitted under the Pharmaceutical Affairs Law to hide the expiration date, and it was not necessary to allocate products that were conscious of the expiration date in Japan, but we will export overseas. In some cases, an expiration date is required depending on the export destination.

In the past, it was possible to manage the expiration date for each product such as the expiration date and the expiration date, but it was not possible to manage the expiration date for each product type by business partner. Therefore, in order to properly distribute the inventory held, the requirement was not satisfied only by managing the expiration date for each product.

Therefore, in the present embodiment, instead of managing the expiration date for each product, the expiration date is set for each business partner and product type, and the system is controlled so that the shipment can be carried out in consideration of this.

The inventory distribution device of this embodiment can be applied not only to cosmetics but also to other industries such as medical instruments, chemical products, and foods when the deadline must be managed for each consuming country or business partner.

[2. Constitution]
An example of the inventory management device according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. In FIG. 1, the inventory management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the inventory management device 100 is communicably connected via an arbitrary communication path. The inventory management device 100 is a commercially available desktop personal computer. The inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

The communication interface unit 104 connects the inventory management device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the inventory management device 100 to the server 200 and a terminal device (not shown) so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as a monitor 114.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a product master 106a, an expiration date management master 106b for each customer type classification, a customer master 106c, an order data file 106d, an inventory data file 106e, and an order data file f. FIG. 2 is a diagram showing a configuration example of a master and data. The master can be divided or integrated. Therefore, the product master 106a, the expiration date management master 106b for each customer type classification, and the customer master 106c are not limited to the configuration shown in FIG.

The product master 106a is a master for defining the product type classification. As shown in FIG. 2, the product master 106a can be configured by a table or the like for registering data of the product code and the product classification code in association with each other.

The expiration date management master 106b for each customer type classification is a table for managing the expiration date for each customer and / or type category. As shown in FIG. 2, the expiration date management master 106b for each customer product type classification can be configured by a table or the like for registering the customer code, the product type classification code, and the data of the number of valid months in association with each other.

Customer master 106c, a master for defining domestic and international classification of customers. As shown in FIG. 2, the customer master 106c can be configured by a table or the like for registering a customer code and domestic / overseas classification data in association with each other.

The order data file 106d is a file for storing order data. As shown in FIG. 2, the order data includes an order header including order number, customer code, order date data, and an order statement including order number, order line number, warehouse code, product code, and order quantity data. It is composed of and.

The inventory data file 106e is a file for storing inventory data. The inventory data may include data on the warehouse code, the product code, the lot number, the expiration date, and the current number of stocks (allocation capacity).

The order data file 106f is a file for storing order data. The order data includes an order header including an order number, a customer code, and an order date, an order details including an order number, a line number, a warehouse code, a product code, a product classification code, and an order quantity, and an order number and a line number. , Detail number, warehouse code, product code, product classification code, number of orders, lot number, and order details including expiration date (see FIG. 5).

The order work is intermediate data created when order data is created by referring to the product master 106a, the expiration date management master 106b by customer type classification, the customer master 106c, and the inventory data based on the order data. Is. As shown in FIG. 2, the order work may include data of an order number, an order line number, a warehouse code, a customer code, a product classification code, a product code, an expiration date, and an order quantity.

The control unit 102 is a CPU or the like that comprehensively controls the inventory management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally and conceptually provided with an order data input unit 102a, an order data creation unit 102b, and a master maintenance unit 102c.

The order data input unit 102a inputs order data including at least the customer, the product, the order date, and the number of orders according to the order from the domestic or overseas customer, and stores the order data file 106d. .. For example, the order data input unit 102a may input the order data according to the operation of the operator on the input screen (not shown) displayed on the monitor 114 and store the order data in the order data file 106d.

The order data creation unit 102b performs distribution input processing. In the distribution input process, order data is created by referring to inventory data based on order data, and when inventory data is assigned, it is set to the corresponding customer and / or product classification by referring to the master. The expiration date is calculated from the number of valid months and the order date, and the inventory of the lot number that meets the calculated expiration date is allocated from the inventory data.

The master maintenance unit 102f responds to an operation by an administrator or the like on a master maintenance screen (not shown) displayed on the monitor 114, and is a product master 106a, an expiration date management master 106b for each customer type classification, and a customer master 106c. It is for editing, adding, changing, etc. of data for.

[3. Concrete example]
A specific example of the processing of the inventory management device 100 according to the present embodiment will be described with reference to FIGS. 1 to 5. FIG. 3 is a diagram showing a flow for explaining the overall processing flow of the inventory management device 100 according to the present embodiment.

With reference to FIG. 3, the flow of the entire processing of the inventory management device 100 according to the present embodiment will be described. In FIG. 3, first, the order data input unit 102a collects orders from domestic or overseas customers, and inputs order data including at least the customer, the product, the order date, and the number of orders. It is stored in the order data file 106d (step S1).

The order data creation unit 102b performs distribution input processing (step S2), and creates order data based on order data and inventory data. In this case, in the case of products for which lot management is performed, lots are automatically allocated on a first-in, first-out basis. However, if there is an expiration date set for each customer and / or type classification, automatic allocation will be made on a first-in, first-out basis from lots with more than the number of valid months.

The order data creation unit 102b stores the created order data in the order data file 106f (step S3). After that, the shipping process based on the order data is performed (step S4).

FIG. 4 is a diagram showing a display example for explaining an image of the distribution input process. In FIG. 4A, order data for which order data has not been created is displayed on the screen. When the data is displayed, the rod automatic allocation process is executed. In the example of the distribution input screen 400 shown in FIG. 4 (A), the input category, the office, the warehouse, the input field 401 of the shipping date, and the area 402 for setting the extraction conditions (shipping date, distribution pattern). , An area 403 for displaying the extraction result and a display button 404 are provided.

When the display button 404 is pressed, the data matching the extraction conditions of the input field 401 and the area 402 is displayed in the area 403, and the rod automatic allocation process is executed. In the area 403, the product code, the product name, the current number of stocks, the number of orders, the number of inputs, and excess / deficiency data are displayed.

In the example shown in FIG. 4A, in the input field 401, the input category “1: normal allocation”, the business establishment “00001: sample business establishment”, the warehouse “0000000003: shipping warehouse”, and the shipping date “2018/04 /” 01 "is displayed.

In the area 402, the shipping date "2018/04/01" and the distribution pattern "000000011: American corporate group" are input.

In area 403, the extraction results are the product code "D18912", the product name "Sample D-18", the current number of stocks "100", the number of orders "60", the number of inputs "60", and the excess / deficiency "40". Code "T36178", product name "sample T-36", current stock quantity "270", order quantity "80", input quantity "80", excess / deficiency "190", product code "X91564", product name "sample" "X-91", the current number of stocks is "150", the number of orders is "50", the number of inputs is "50", and the excess or deficiency is "100".

As shown in FIG. 4C, for example, as shown in FIG. 4C, the distribution group setting image may be registered in association with the customer code belonging to the distribution pattern and the data of the customer name for each distribution pattern. .. In the example shown in the figure, the distribution pattern "0000000011: American corporate group" belongs to the customer code "0000002014: American A Co., Ltd.", the customer code "0000002015: American B Co., Ltd.", and so on. There is.

FIG. 4B is a diagram showing an example of the rod automatic allocation processing result confirmation screen 500. In the example shown in the figure, when the shipping warehouse “0000000003” is specified, the customer code, the customer name, the product code, the lot number, the expiration date, and the quantity data are displayed. In the first line, the customer code "000002014", the customer name "America A Co., Ltd.", the product code "D18912", the lot number "D2A19", the expiration date "2019/12/31", and the quantity "60" are 2. In the line, customer code "000002014", customer name "America A Co., Ltd.", product code "Sample T-36", lot number "H1F19", expiration date "2019/12/31", quantity "70" However, in the third line, the customer code "000002014", the customer name "America A Co., Ltd.", the product code "T36178", the lot number "H1F20", the expiration date "2020/12/31", and the quantity "10" are , ... is displayed.

FIG. 5 is sample data for explaining a process (effective inventory control at the time of automatic allocation) when an expiration date is set for each customer and / or for each type of product in the allocation input process. With reference to FIG. 5, a data example of processing when there is an expiration date setting for each customer and / or for each type classification in the distribution input processing will be described.

In FIG. 5, it is assumed that the following data are set for the expiration date management master 106b, the product master a, and the inventory data for each customer type classification.

In the example of the expiration date management master 106b for each customer product type shown in FIG. 5A, the customer code “000000214” is set to the number of valid months “18”, and the customer code “000041” and the product type are set. The number of effective months "30" is set in the classification "D0001".
If both the customer code and the product classification are set, the product classification takes precedence. Therefore, for the product classification "D0001", the effective number of months "30" is used, and for products other than the product classification "D0001", the effective month "18" of the customer code "00000214" is used.

In the example of the product master 106a shown in FIG. 5B, the product classification code “T0001” is registered for the product code “T36178”, and the product classification code “D0001” is registered for the product code “D18912”.

In the example of the inventory data shown in FIG. 5 (E), the inventory of the warehouse code “0000000003” is shown. Regarding the product code "T36178", the rod number "H1F18", the expiration date "2018/12/31", the number that can be allocated "80", the rod number "H1F19", the expiration date "2019/12/31", the number that can be allocated. It is "70", the rod number "H1F20", the expiration date "2020/12/31", and the number that can be allocated "200". For the product code "D18912", the rod number "D2A18", the expiration date "2018/12/31", the number of possible allocations "40", the rod number "D2A19", the expiration date "2019/12/31", and the allocation The possible number is "65", the rod number is "D2A20", the expiration date is "2020/12/31", and the available number is "100".

When the above data is set, the order data created when the order data as shown in FIG. 5C is input will be described.

In the example of the order data shown in FIG. 5 (C), first, the order header has the order number “BD1Z00139258”, the customer code “0000002014”, and the order date “2018/04/01”.

The order details are order number-line number "BD1Z001392581", warehouse code "0000000003", product code "T36178", order quantity "80", order number-line number "BD1Z00139252-2", warehouse code "0000000003". , The product code is "D18912" and the number of orders is "60".

An order work is created in the process of distribution input processing. In the order work, the "product classification code" corresponding to the product code is acquired from the product master 106a, and the expiration date is calculated from the order date of the order header + the expiration date of the customer product type classification expiration date management master 106b.

In the example shown in FIG. 5D, the expiration date of the order number-line number "BD1Z00139255-1" (product code "T36178", product classification code "T0001") in the first line is the order date "2018 /". With "04/01" + valid months "18 months", it becomes "2020/09/14". Regarding the order number-line number "BD1Z00139252-2" in the second line (product code "D18912", product classification code "D0001"), the order date is "2018/04/01" + the number of valid months is "30 months". Then, it becomes "2020/09/14".

Since the order number of one line-line number "BD1Z00139255-1" has the number of orders "80" and the expiration date "2019/09/14", the rod number "H1F19" satisfying the expiration date of the inventory data is valid. Of the deadline "2019/12/31", the number of possible allocations "70", "H1F20", the expiration date "2020/12/31", and the number of possible allocations "200", "70" in the order of rod number, Allocate "10" pieces.

Regarding the order number-line number "BD1Z00139252-2" (product code "D18912", product classification code "D0001"), the number of orders is "60" and the expiration date (shortest) is "2020/09/14". , "60" out of the rod number "D2A20" that satisfies the expiration date of the inventory data, the expiration date "2020/12/31", and the available number "100".

By the above processing, order data as shown in FIG. 5 (F) is created. In the example of the order data shown in FIG. 5 (F), the order header data has the order number "A01Z00098127", the customer code "00000214", and the order date "2018/04/01".

The order details are order number-line number "A01Z00098127-1", warehouse code "0000000003", product code "T36178", product classification code "T0001", order quantity "80", and order number-line number "A01Z00098127-2". , Warehouse code "0000000003", product code "D18912", product classification code "D0001", and order quantity "60".

The order details are order number-line number-detail number "A01Z00098127-1-1", warehouse code "0000000003", product code "T36178", product classification code "T0001", order quantity "70", rod number "H1F19". , Expiration date "2019/12/31", order number-line number-detailed number "A01Z00098127-1-2", warehouse code "0000000003", product code "T36178", product classification code "T0001", number of orders " 10 ”, rod number“ H1F20 ”, expiration date“ 2019/12/31 ”, order number-line number-detailed number“ A01Z00098127-2-1 ”, warehouse code“ 00000000003 ”, product code“ D18912 ”, product classification The code is "D0001", the number of orders is "60", the rod number is "D2A20", and the expiration date is "2020/12/31".

As described above, according to the present embodiment, the master in which the number of valid months is registered for each customer and / or the type classification, and the inventory data including the lot number, the expiration date, and the number of stocks for each product. , The order data input unit 102a for inputting order data including at least the customer, the product, the order date, and the number of orders according to the order from the domestic or overseas customer, and the inventory based on the order data. When creating order data by referring to the data and allocating inventory, the expiration date is calculated from the valid months and order date set in the corresponding customer and / or product classification by referring to the master. , The order data creation unit 102b for allocating the inventory of the lot number satisfying the calculated expiration date among the above inventory data, so that the expiration date can be set for each customer or product type when allocating the inventory of the product. It becomes possible to manage.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the inventory management device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the inventory management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the inventory management apparatus is required. Read mechanically to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit 106 such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the inventory management device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. be.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the inventory management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or the like. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Inventory management device 102 Control unit 102a Order data input unit 102b Order data creation unit 102c Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Product master 106b Expiration date management master by customer type classification 106c Customer master 106d Order data file 106e Stock data file 106f Order data file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

An inventory management device equipped with a control unit and a storage unit.
In the storage unit
With the master who registered the number of valid months for each customer and / or each type classification,
Inventory data including lot number, expiration date, and inventory quantity for each product,
Is stored,
The control unit
An order data entry unit that inputs order data including at least the customer, product, order date, and number of orders, depending on the order from domestic or overseas customers.
Based on the order data, when order data is created with reference to the inventory data and inventory is allocated, the number of valid months set for the corresponding customer and / or type classification with reference to the master. And the order data creation means that calculates the expiration date from the order date and allocates the inventory of the lot number that meets the calculated expiration date from the above inventory data.
An inventory management device characterized by being equipped with. The inventory management device according to claim 1, wherein the master further registers a variety classification for each product. The inventory management device according to claim 1 or 2, wherein the product is a cosmetic product. It is an inventory management method for causing an information processing device equipped with a control unit and a storage unit to execute.
In the storage unit
With the master who registered the number of valid months for each customer and / or each type classification,
Inventory data including lot number, expiration date, and inventory quantity for each product,
Is stored,
It is executed by the control unit.
An order data entry step to enter order data, including at least the customer, product, order date, and number of orders, depending on the order from the domestic or overseas customer.
Based on the order data, when order data is created with reference to the inventory data and inventory is allocated, the number of valid months set for the corresponding customer and / or type classification with reference to the master. And the order data creation step that calculates the expiration date from the order date and allocates the inventory of the lot number that meets the calculated expiration date from the above inventory data.
A warehouse management method characterized by including. It is an inventory management program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
With the master who registered the number of valid months for each customer and / or each type classification,
Inventory data including lot number, expiration date, and inventory quantity for each product,
Is stored,
In the control unit
An order data entry step to enter order data, including at least the customer, product, order date, and number of orders, depending on the order from the domestic or overseas customer.
Based on the order data, when order data is created with reference to the inventory data and inventory is allocated, the number of valid months set for the corresponding customer and / or type classification with reference to the master. And the order data creation step that calculates the expiration date from the order date and allocates the inventory of the lot number that meets the calculated expiration date from the above inventory data.
An inventory management program to run.

Images