JP7458256B2 - Inventory management device, inventory management method, and inventory management program - Google Patents

Description

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

When companies that manufacture or sell products allocate inventory in response to orders from business partners, they often use the so-called "first-in, first-out" method. This "first in, first out" system is a method of allocating products in order from the oldest in stock. Conventionally, as a system that performs first-in, first-out, there is, for example, Patent Document 1.

Japanese Patent Application Publication No. 2008-105795

However, Patent Document 1 does not describe anything about including the arrival date in the lot number.

The present invention has been made in view of the above, and provides an inventory management device, an inventory management method, and an inventory management program that can reliably perform first-in, first-out inventory items by including the arrival date in the lot number. The purpose is to provide

In order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory management device including a storage section and a control section, wherein the storage section includes an inventory information table for storing inventory information. When stock is received, the control unit generates an in-house lot number including the arrival date for the incoming product, inputs the product, the generated in-house lot number, and quantity, and registers it in the inventory information. Inventory allocation means that refers to the inventory information and allocates the number of shipments in order of arrival date of internal lot number when shipping the target product, and includes the person in charge code of the target product whose sales have been input. Based on the in-house lot number, quantity, unit sales price, and cost of sales, for each in-house lot number, the in-house lot is calculated by subtracting the cost of sales from the unit sales price and multiplying the quantity. sales input means for calculating the gross profit for each number; the storage unit stores a master in which a person in charge code of a person in charge belonging to the department is registered for each department; The means refers to the master for the target product, detects a person in charge code of a person in charge belonging to a desired department, and extracts the in-house lot including the detected person in charge code out of the calculated gross profit. The gross profit of the number is set as the gross profit of the desired department .

Further, according to one aspect of the present invention, the in-house lot number may hold a department code instead of the person in charge code.

Further, in order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory management method that is executed by an information processing device that includes a storage unit and a control unit, and the storage unit includes inventory information. An inventory information table for storing an inventory information table is stored, and when the inventory is received by the control unit, an in-house lot number including the arrival date is generated for the incoming product, and the product, the generated in-house lot number, An input process in which the quantity is entered and registered in inventory information, an inventory allocation process in which when shipping the target product, the inventory information is referred to and allotted for the number of shipments in order of arrival date of internal lot number, and sales input. Based on the in-house lot number including the person in charge code, quantity, unit sales price, and cost of sales of the target product, the quantity is calculated by subtracting the cost of sales from the unit sales price for each in-house lot number. a sales input step of calculating the gross profit for each in-house lot number by performing a multiplication operation, and the storage unit stores, for each department, the person in charge code of the person in charge of the department. A registered master is stored, and in the sales input step, the master is referred to for the target product, and the person in charge code of the person in charge belonging to the desired department is detected, and the calculated gross profit is The method is characterized in that the gross profit of the in-house lot number including the detected person-in-charge code is set as the gross profit of the desired department .

Further, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides an inventory management device for causing an information processing device including a storage unit and a control unit to execute an inventory management device, wherein the storage unit includes an inventory management device. An inventory information table for storing information is stored, and the control unit generates an in-house lot number including the date of arrival for the incoming product at the time of inventory receipt, and stores the product, the generated in-house lot number, and quantity. an input process in which information is entered and registered in inventory information; an inventory allocation process in which when shipping the target product, the inventory information is referred to and reserved for the number of shipments in order of arrival date of the internal lot number; Based on the internal lot number including the person in charge code, quantity, unit sales price, and cost of sales of the target product, for each internal lot number, multiply the value obtained by subtracting the cost of sales from the unit sales price by the quantity. A sales input step of calculating the gross profit for each in-house lot number is executed by performing the calculation, and the person in charge code of the person in charge belonging to the department is registered in the storage unit for each department. In the sales input step, the sales input process refers to the master and detects the person in charge code of the person in charge of the desired department, and also calculates the amount of gross profit out of the calculated gross profit. , the step of setting the gross profit of the in-house lot number including the detected person-in-charge code as the desired gross profit of the department is executed.

The present invention has the advantage that by including the arrival date in the lot number, it is possible to ensure first-in, first-out ordering of stocked items.

FIG. 1 is a block diagram showing an example of the configuration of an information processing apparatus according to the present embodiment. FIG. 2 is a diagram showing an example of the configuration of a department master. FIG. 3 is a diagram for explaining automatic allocation processing of the control unit of the inventory management device according to the present embodiment. FIG. 4 is a diagram for explaining cost management of the control unit of the inventory management device according to the present embodiment.

The inventory management device, inventory management method, and inventory management program according to the embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
Previously, the arrival date at the time of arrival was not maintained as inventory information, and in order to achieve first-in, first-out at the time of inventory issue, system users had to arbitrarily specify inventory and make reservations. . However, due to input errors by each person in charge, a different inventory may be selected than the originally selected inventory, and the cost of sales may not always be appropriate. In other words, there was a problem in that it was not possible to carry out first-in, first-out inventory of products due to a mistake by the person in charge or the like.

In this embodiment, when inventory arrives, the arrival date is stored in the in-house lot number information, which is a system function. When inventory is released from the warehouse, the same products are sorted in in-house lot order according to the arrival date of the in-house lot number, and the number of items to be shipped is allocated, making it possible to reliably achieve first-in, first-out.

Furthermore, in this embodiment, by holding the person in charge code at the time of arrival in accordance with the in-house lot number information, it is possible to differentiate when the same product is handled by multiple departments. This has made it possible to evaluate inventory by in-house lot and reflect the cost of each receiving department in the cost of sales.

[2. composition]
An example of the configuration of the inventory management device according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of an inventory management device.

Inventory management device 100 is a commercially available desktop personal computer. Note that the inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but also a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may be an information processing device.

The inventory management device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the inventory management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the inventory management device 100 to the network 300 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 other devices via a communication line. Here, the network 300 has a function of connecting the inventory management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used.

Furthermore, the storage unit 106 includes an inventory information table 106a and a department master 106b. FIG. 2 is a diagram showing an example of the configuration of the department master 106b.

The inventory information table 106a is a table for storing inventory information. Inventory information may include, for example, data on products, in-house lot numbers, and quantities (numbers in stock).

As shown in FIG. 2, the department master 106b can be configured as a table in which department codes and staff codes are registered in association with each other. In the example shown in FIG. 2, staff code "T003" is registered for department code "B001," staff code "T004" is registered for department code "B002," and staff codes "T005" and "T006" are registered for department code "B003."

The control unit 102 is a CPU or the like that controls the inventory management device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute. Functionally, the control unit 102 includes an arrival input unit 102a, a shipping input unit 102b, an inventory allocation unit 102c, a purchase input unit 102d, and a sales input unit 102e.

For example, the arrival input unit 102a automatically generates an in-house lot number including the arrival date for an incoming product in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and inputs the product, arrival date, etc. , the generated in-house lot number and arrival data including the quantity (number of items received) are input and registered in the inventory information of the inventory information table 106a. The in-house lot number may further include a person in charge code. Furthermore, the in-house lot number may hold a department code instead of the person-in-charge code.

The shipment input unit 102b may, for example, input shipping data including the shipping date, product, and quantity (number of items to be shipped) for the products to be shipped in response to an operator's operation on an input screen (not shown) displayed on the monitor 114.

When shipping the target product, the inventory allocating unit 102c refers to the inventory information in the inventory information table 106a and allocates the number of items to be shipped in order of the arrival date of the internal lot number.

The purchase input unit 102d inputs, for example, the purchase date, department code, person in charge code, product, in-house lot number, and quantity (purchase) in response to an operator's operation on an input screen (not shown) displayed on the monitor 114. Purchase data including the quantity purchased) and purchase unit price are input and registered in the inventory information of the inventory information table 106a.

When entering sales, the sales input unit 102e calculates the gross profit for each in-house lot number (arrival date + person in charge code) for the target product. The sales input unit 102e may refer to the department master 106b to calculate the gross profit for each department to which the person in charge code of the in-house lot number belongs for the target product. Specifically, the sales input unit 102e inputs the sales date, department, product, quantity, in-house lot number, quantity, sales price, and cost of goods sold (= purchase price) in response to the operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and calculates the gross profit (= (sales price - sales cost) x quantity) for the in-house lot number of the product. Then, the sales input unit 102e refers to the department master 106b to calculate the gross profit for each product and department.

[3. Concrete example]
A specific example of the processing of the control unit 102 of the inventory management device 100 in this embodiment will be described with reference to FIGS. 1 to 4.

(3.1 Automatic reservation processing)
FIG. 3 is a diagram for explaining automatic allocation processing of the control unit 102 of the inventory management device 100 in this embodiment. With reference to FIG. 3, automatic allocation processing by the control unit 102 of the inventory management device 100 in this embodiment will be described.

In FIG. 3A, the arrival input unit 102a automatically generates an internal lot number of arrival date + person in charge code when a product arrives, and inputs the arrival date, person in charge code, product, in-house lot, and quantity. Enter the arrival data including the item and register it in the inventory information. Note that for product transfer input, in-house lot numbers may be automatically generated using a similar method.

In the example shown in Figure 3(A), the arrival data of "October 15th", person in charge code "T001", product "S001", in-house lot number "20191015T001", and quantity "8" are entered, and the inventory Register for information.

In FIG. 3(B), for the product "S001", the inventory information includes internal lot number "20191013T001", quantity "3", internal lot number "20191014T001", quantity "2", internal lot number "20191016T001", It is assumed that the quantity "6" has already been registered.

As shown in FIG. 3(B), the in-house lot number "20191015T001" and the quantity "8" input in FIG. 3(A) are registered (added) to the inventory information. At that time, each product is sorted by internal lot number (order of arrival date of internal lot number), and for product "S001", internal lot number is "20191013T001", quantity is "3", and internal lot number is "20191014T001". , quantity "2", in-house lot number "20191015T001", quantity "8", in-house lot number "20191016T001", quantity "6".

As shown in FIG. 4(C), the shipment input unit 102b performs shipment input and inputs the shipping date, product, and quantity. In the example shown in FIG. 4(C), the shipping date "October 17th", product "S001", and quantity "6" are input.

Next, the inventory allocation unit 102c performs automatic inventory allocation. In automatic inventory allocation, inventory is allocated based on inventory information on a first-in, first-out basis, that is, in order of in-house lot numbers (in order of arrival date of in-house lot numbers). Specifically, as shown in FIG. 4(D), for product "S001", in-house lot number "20191013T001", quantity "3", in-house lot number "20191014T001", quantity "2", and in-house lot number “20191015T001” and the quantity “1” are allocated in order.

The inventory information for product "S001" is updated to internal lot number "20191015T001" and quantity "7", and to internal lot number "20191016T001" and quantity "6".

Note that this automatic reservation may be performed for invoice input and product transfer input. Furthermore, in order to avoid allocating future inventory based on the shipping date at the time of shipment, it may be possible to allocate only the inventory on the date of arrival <shipment date of the in-house lot number. This is to prevent negative inventory over months. Further, inventory adjustment is possible through movement input, but in that case, it may be possible to input any in-house lot number. In this case, a date check may be provided for the character string to implement a mechanism to prevent the occurrence of artificially fraudulent in-house lot numbers.

(3.2 Cost management)
FIG. 4 is a diagram for explaining cost management by the control unit 102 of the inventory management device 100 in this embodiment. With reference to FIG. 4, cost management by the control unit 102 of the inventory management device 100 in this embodiment will be explained.

A function that calculates costs for each in-house lot number is implemented as a system standard, and by retaining a person-in-charge code in an in-house lot number, it is possible to manage costs for departments linked to the person-in-charge code, making it possible to calculate gross costs at the time of sales. It is possible to calculate profits for each sector.

As shown in FIG. 4(A), the purchase input unit 102d inputs purchase data including the purchase date, department code, person in charge code, product, in-house lot number, quantity, and purchase price, and registers the data in the inventory information. In the example shown in FIG. 4(A), the purchase data inputted are "October 15th", department "B001", person in charge code "T003", product "S001", in-house lot number "20191015T003", quantity "8", and purchase price "800 yen".

As shown in FIG. 4(B), the sales input unit 102e inputs the sales date, department, product, quantity, assigned in-house lot number, quantity, unit sales price, and cost of sales (=purchase unit price). Then, calculate the gross profit (=(sales unit price - cost of sales) x quantity) for the in-house lot number of the product. In the example shown in Figure 4(B), the sales date is "October 17th", the department is "B001", the product is "S001", the quantity is "6", the lot number within our company is "20191015T003", the quantity is "8", and the unit sales price is " 1,200 yen" and the cost of sales "800 yen," and calculate the gross profit of "2,400 yen (=(1,200 yen - 800 yen) x 6).

In addition, in the example of purchase input shown in Figure 4(C), purchase date "October 15", department "B002", person in charge code "T004", product "S001", internal lot number "20191015T004", Quantity "8" and purchase unit price "750 yen" are input.

In the example of sales input shown in Figure 4(D), the sales date is "October 17th", the department is "B002", the product is "S001", the quantity is "6", the lot number in our company is "20191015T004", and the unit sales price is "1200 yen". ”, the cost of sales “750 yen” is input, and the gross profit “2700 yen (=(1200-750)×6)” is calculated.

Next, for the product "S001", the gross profit is calculated for each department "B001" and "B002" to which the person in charge code of the in-house lot number belongs. According to the department master 106b in FIG. 2, in this example, only the person in charge code "T003" of the in-house lot number "20191015T003" is linked to "B001", so for the product "S001", the department "B001" The gross profit is 2400 yen. Similarly, since only the person in charge code "T004" of the in-house lot number "20191015T004" is linked to "B001", the gross profit of department "B002" for product "S001" is "2700 yen". It is.

Note that the information held in the in-house lot number is not limited to the person in charge code, and instead of the person in charge code, a department code or department code may be held. For example, if a department or department does not have more than one person in charge, gross profit for each department or department can be calculated directly.

As explained above, when stock is received, the arrival input unit 102a generates an in-house lot number including the arrival date for the incoming product, inputs the product, the generated in-house lot number, and quantity, and registers it in inventory information; When shipping the target product, it is equipped with an inventory allocation unit 102c that refers to inventory information and allocates the number of shipments in order of the arrival date of the in-house lot number.By including the arrival date in the in-house lot number, It is possible to reliably carry out first-in, first-out inventory of inventory products.

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

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

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

Further, regarding the inventory management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the inventory management device 100, particularly each processing function performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is stored in the inventory management device as necessary. Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit 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 any network, and it is also possible to download all or part of it as necessary. be.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "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 EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

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

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 any peripheral device is connected. The inventory management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

100 Inventory management device 102 Control unit 102a Arrival input unit 102b Shipping input unit 102c Inventory allocation unit 102d Purchase input unit 102e Sales input unit 106 Storage unit 106a Inventory information table 106b Department master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 network

Claims (4)

An inventory management device comprising a storage unit and a control unit,
In the storage unit,
An inventory information table for storing inventory information is stored.
The control unit includes:
an input means for generating an in-house lot number including the arrival date for the incoming product at the time of stock receipt, inputting the product, the generated in-house lot number, and quantity, and registering it in inventory information;
When shipping the target product, an inventory allocation means refers to the inventory information and reserves the number of shipments in order of the arrival date of the internal lot number;
Based on the in-house lot number including the person in charge code, quantity, unit sales price, and cost of sales of the target product whose sales have been input, the cost of sales is subtracted from the unit sales price for each in-house lot number. Sales input means for calculating the gross profit for each in-house lot number by performing an operation of multiplying quantities;
The storage unit stores, for each department, a master in which the person in charge code of the person in charge belonging to the department is registered,
The sales input means refers to the master for the target product, detects a person in charge code of a person in charge who belongs to a desired department, and includes the detected person in charge code out of the calculated gross profit. setting the gross profit of the in-house lot number as the desired gross profit of the department;
An inventory management device featuring: 2. The inventory management device according to claim 1 , wherein the in-house lot number holds a department code instead of the person-in-charge code. An inventory management method executed by an information processing device including a storage unit and a control unit, the method comprising:
In the storage unit,
An inventory information table for storing inventory information is stored.
executed in the control unit,
An input step of generating an in-house lot number including the arrival date for the incoming product at the time of stock receipt, inputting the product, the generated in-house lot number, and quantity, and registering it in inventory information;
When shipping the target product, an inventory allocation process that refers to the inventory information and reserves the number of shipments in order of the arrival date of the internal lot number;
Based on the in-house lot number including the person in charge code, quantity, unit sales price, and cost of sales of the target product whose sales have been input, the cost of sales is subtracted from the unit sales price for each in-house lot number. a sales input step of calculating gross profit for each in-house lot number by performing an operation of multiplying quantities;
The storage unit stores, for each department, a master in which the person in charge code of the person in charge belonging to the department is registered,
In the sales input step, for the target product, the master is referred to, and the person in charge code of the person in charge belonging to the desired department is detected, and the detected person in charge code is included in the calculated gross profit. setting the gross profit of the in-house lot number as the desired gross profit of the department;
An inventory management method characterized by: An inventory management device for causing an information processing device including a storage unit and a control unit to execute,
In the storage unit,
An inventory information table for storing inventory information is stored.
In the control section,
An input step of generating an in-house lot number including the arrival date for the incoming product at the time of stock receipt, inputting the product, the generated in-house lot number, and quantity, and registering it in inventory information;
When shipping the target product, an inventory allocation process that refers to the inventory information and reserves the number of shipments in order of the arrival date of the internal lot number;
Based on the in-house lot number including the person in charge code, quantity, unit sales price, and cost of sales of the target product whose sales have been input, the cost of sales is subtracted from the unit sales price for each in-house lot number. executing a sales input step of calculating the gross profit for each in-house lot number by performing an operation of multiplying the quantity;
The storage unit stores, for each department, a master in which the person in charge code of the person in charge belonging to the department is registered,
In the sales input step, for the target product, the master is referred to, and the person in charge code of the person in charge belonging to the desired department is detected, and the detected person in charge code is included in the calculated gross profit. a step of setting the gross profit of the in-house lot number to the desired gross profit of the department;
Inventory management program to run.

Images