JP7291084B2 - Information processing device, inventory control method and inventory control program - Google Patents

Description

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

Patent Literature 1 describes a product allocation device or the like that realizes product allocation for the case where the stock quantity and the expected stock quantity of products are stored in units of origin.

JP 2007-018093 A

However, in companies (wholesale, retail, etc.) that accept orders even when there is no product inventory and reserve inventory at the time of arrival rather than at the time of receiving an order, the concept of inventory allocation differs depending on the main product handled (for example, mainly Depending on whether the product to be handled is a standard product or a new product scheduled to be sold in the future, the concept of calculating the number of available inventory will differ), but the inventory allocation that fits the company's thinking (specifically, the calculation of the number of available inventory) ) can be realized by simply changing settings, there has been no information processing system (application software).

The present invention has been made in view of the above, and information that makes it possible to manage inventory allocation (specifically, calculation of the number of available inventory) that matches the company's concept by simply changing settings. An object of the present invention is to provide a processing device, an inventory control method, and an inventory control program.

In order to solve the above-described problems and achieve the object, an information processing apparatus according to the present invention is an information processing apparatus including a control unit, and includes an actual inventory quantity and an order quantity allocated at the time of arrival based on the actual inventory quantity. , the number of orders to be allocated, which is the number of orders to be allocated at the time of arrival based on the actual inventory, and the number of allocable inventory, which is the number of inventory that can be allocated from the actual inventory, are managed for each product. The control unit registers a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the number of available stocks for allocation. and an inventory control means for generating or updating inventory data in accordance with a first setting when registration of order data of an ordered product is instructed, wherein the inventory control means receives an order. When the registration of the order data of the product is instructed, (1) the first setting is confirmed, and (2) if the confirmed first setting takes into consideration the number of orders to be allocated, When there is no inventory data in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity of the product is stored as the planned allocation order quantity, and the actual quantity is stored as the allocable stock quantity. Execute a first generation process of generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the scheduled allocation order quantity from the inventory quantity is stored, and storing the generated inventory data in the storage unit. , when the inventory data of the product is in the storage unit, update the planned allocation order quantity stored in the inventory data to the sum of the planned allocation order quantity and the order quantity, and store it in the inventory data. Update the allocated quantity of available inventory to the number obtained by subtracting the number of allocated orders stored in the relevant inventory data from the actual quantity of inventory stored in the relevant inventory data and the planned number of orders to be allocated after the update. (3) When the confirmed first setting does not take into consideration the number of orders to be allocated, and the inventory data of the product is not in the storage unit, the actual inventory quantity is set to zero. 0 is stored as the number of allocated orders, the number of orders is stored as the number of orders to be allocated, and the number obtained by subtracting the number of allocated orders from the actual inventory is stored as the number of available stocks. and executes a second generation process of storing the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, the allocation schedule stored in the inventory data The number of orders received is updated to the number obtained by adding the number of orders received to the number of orders scheduled to be allocated, and the number of allocable inventory stored in the inventory data is changed from the actual inventory stored in the inventory data to the inventory data. and executing a second update process to update the number obtained by subtracting the number of reserved orders stored in .

Further, the information processing apparatus according to the present invention is the information processing apparatus, wherein the control unit determines whether or not to take into account the planned allocation order quantity in the calculation of the allocatable inventory quantity or whether to follow the first setting. The inventory management means, when instructed to register the order data of the ordered product, (1) registers the second setting associated with the product. Confirm, and if the confirmed second setting conforms to the first setting, further confirm the first setting to determine whether or not to take into consideration the number of orders to be allocated, (2 ) When it is determined that the number of orders to be allocated should be taken into consideration, the first generation process is executed when the inventory data of the ordered product is not in the storage unit, and when the inventory data of the product is in the storage unit When it is determined that (3) the number of orders to be allocated is not taken into consideration, the second generation process is executed if the inventory data of the product is not in the storage unit, and the inventory of the product is determined. The second updating process is executed when data is in the storage unit.

Further, in the information processing apparatus according to the present invention, in the information processing apparatus, when a product to be inquired is specified on an inventory inquiry screen, the control unit (1) confirms a first setting, (2) ) If the confirmed first setting takes into consideration the number of orders to be allocated, the actual number of orders stored in the inventory data of the product concerned will be converted to the number of orders already allocated stored in the inventory data. Execute the first calculation process to calculate the number of available inventory by subtracting the planned allocation order quantity stored in the inventory data, and (3) the confirmed first setting does not take into account the planned allocation order quantity. If it is, the second calculation process is performed to calculate the number of allocable inventory by subtracting the allocated order quantity stored in the inventory data from the actual inventory quantity stored in the inventory data of the product. and (4) inventory inquiry means for outputting the calculation result to the inventory inquiry screen.

Further, the information processing apparatus according to the present invention is the information processing apparatus, wherein the control unit determines whether or not to take into account the planned allocation order quantity in the calculation of the allocatable inventory quantity or whether to follow the first setting. When the product to be inquired is specified, the inventory inquiry means (1) confirms the second setting associated with the product, and confirms the second setting associated with the product, If the confirmed second setting conforms to the first setting, further confirm the first setting to determine whether or not to take into consideration the number of orders to be allocated, and If it is determined that the number is taken into consideration, the first calculation process is executed, (3) if it is determined that the number of orders to be allocated is not taken into account, the second calculation process is executed, and (4) Calculation result is output to the inventory inquiry screen.

Further, an inventory management method according to the present invention is an inventory management method executed by an information processing apparatus having a control unit, wherein the information processing apparatus controls the number of actual inventories and the number of orders allocated at the time of arrival based on the number of actual inventories. The number of orders that have been allocated, which is the number of products; The information processing device has a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the available stock quantity. an inventory management step of generating or updating inventory data according to a first setting when an instruction is given to register order data of the ordered product, which is registered and executed by the control unit; The management step is to (1) confirm the first setting, and (2) add the number of orders to be allocated to the confirmed first setting when the registration of the order data of the ordered product is instructed. , when there is no inventory data of the product in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, and the order quantity of the product is stored as the planned allocation order quantity, generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the scheduled allocation order quantity from the actual inventory quantity is stored as the available inventory quantity, and storing the generated inventory data in the storage unit; When the inventory data of the product is in the storage unit after the generation process is executed, the planned allocation order quantity stored in the inventory data is updated to the sum of the planned allocation order quantity and the order quantity. , the number of allocable inventory stored in the relevant inventory data is subtracted from the actual inventory quantity stored in the relevant inventory data by the number of allocated orders stored in the relevant inventory data and the planned number of orders to be allocated after the update. (3) In the case where the confirmed first setting does not take into consideration the number of orders to be allocated, when the inventory data of the product is not in the storage unit, Zero is stored as the number of actual inventory, zero is stored as the number of allocated orders, the number of orders is stored as the number of orders to be allocated, and the number obtained by subtracting the number of allocated orders from the actual number of inventory is stored as the number of available stocks. is stored, and a second generation process is executed to store the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, the inventory data is The number of orders to be allocated that is stored is updated to the number obtained by adding the number of orders to the number of orders that are to be allocated, and the number of allocable inventory stored in the inventory data is changed to the actual number that is stored in the inventory data. It is characterized by executing a second updating process of updating the inventory quantity to a quantity obtained by subtracting the allocated order quantity stored in the inventory data from the quantity of inventory.

Further, an inventory management program according to the present invention is an inventory management program to be executed by an information processing apparatus having a control unit, wherein the information processing apparatus includes an actual inventory quantity and an allocation at the time of arrival from the actual inventory quantity. The number of orders received, which is the number of orders, the number of orders to be allocated, which is the number of orders to be allocated at the time of arrival from the actual inventory, and the number of available inventory, which is the number of inventory that can be allocated from the actual inventory, for each product The information processing device is connected to a storage unit that stores inventory data for management, and the information processing device has a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the available inventory quantity. is registered, and an inventory management step of generating or updating inventory data according to a first setting when an instruction is given to register the order data of the ordered product for execution by the control unit, In the inventory control step, when the registration of the order data of the ordered product is instructed, (1) the first setting is confirmed, and (2) the confirmed first setting takes into consideration the number of orders to be allocated. When there is no inventory data of the product in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, and the order quantity of the relevant product is stored as the planned allocation order quantity. and generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the allocation scheduled order quantity from the actual inventory quantity is stored as the allocatable inventory quantity, and storing the generated inventory data in the storage unit. When the inventory data of the product is in the storage unit, the planned allocation order quantity stored in the inventory data is added to the planned allocation order quantity and the order quantity. Update the number of allocable inventory stored in the relevant inventory data from the actual inventory quantity stored in the relevant inventory data to the number of allocated orders stored in the relevant inventory data and the planned number of orders to be allocated after the update (3) If the confirmed first setting does not take into consideration the number of orders to be allocated, the inventory data of the product is not in the storage unit. Occasionally, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity is stored as the planned allocation order quantity, and the allocated order quantity is subtracted from the actual inventory quantity as the allocable inventory quantity. a second generation process for generating inventory data of the product in which the number is stored, storing the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, The number of orders to be allocated that is stored in the data is updated to the number obtained by adding the number of orders to the number of orders that are to be allocated, and the number of allocable inventory stored in the inventory data and executing a second update process for updating the number obtained by subtracting the allocated order quantity stored in the inventory data from the current actual inventory quantity.

The present invention has the effect of making it possible to manage inventory allocation (specifically, calculation of the number of allocatable inventory) that matches the concept of the company by simply changing settings.

FIG. 1 is a diagram showing an example of the configuration of an inventory management device 100. As shown in FIG. FIG. 2 is a diagram showing an example of the first setting master 106a. FIG. 3 is a diagram showing an example of the second setting master 106b. FIG. 4 is a diagram showing an example of the received order data table 106c. FIG. 5 is a diagram showing an example of the inventory data table 106d. FIG. 6 is a diagram showing an example of an order registration screen MA. FIG. 7 is a diagram showing an example of an inventory inquiry screen MB.

Embodiments of an information processing apparatus, an inventory management method, and an inventory management program according to the present invention will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

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

The inventory management device 100 is constructed based on a commercially available desktop personal computer. Note that the inventory management device 100 is not limited to those constructed based on a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smart phone, or a tablet personal computer. It may also be constructed based on a portable information processing device such as.

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 communicably 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 another device via a communication line. Here, the network 300 has a function of connecting the inventory management apparatus 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). Note that the data stored in the storage unit 106 may be stored in the server device 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores a first setting master 106a, a second setting master 106b, an order data table 106c, an inventory data table 106d, and the like.

FIG. 2 is a diagram showing an example of the first setting master 106a. The first setting master 106a includes a first setting as to whether or not to consider the number of orders to be allocated when calculating the available stock quantity. Here, the number of available stocks is the number of stocks that can be allocated based on the number of actual stocks. be. In addition, the number of orders to be allocated is the number of orders to be allocated at the time of arrival from the actual inventory (Supplementary information: The number of orders is related to the orders received before the arrival of goods). Also, the setting value related to the first setting is, for example, a numerical value “0” indicating “not added” or a numerical value “1” indicating “added”.

Here, for example, an order can be accepted even if the product is out of stock, inventory allocation is performed at the time of arrival, not at the time of receiving the order, and new products scheduled to be sold in the future (for example, new apparel products scheduled to be sold in the future season). When the inventory management device 100 is used in a company (for example, a wholesaler or a retailer) that mainly handles custom-ordered products, etc., it is recommended to set the numerical value "1" indicating "addition" first. This is effective from the viewpoint that the registered orders can be allocated with priority.

Also, for example, a company that accepts orders even if there is no product inventory, reserves inventory at the time of arrival rather than at the time of ordering, and mainly handles standard products (for example, wholesalers and retailers), or companies that have no product inventory We will accept orders even if there is no inventory, and inventory allocation will be performed at the time of arrival, not at the time of receiving an order. When the inventory management device 100 is used by a company (for example, a wholesaler or a retailer) that should be avoided, setting the value "0" to indicate "do not take into account" is a good way to reduce lost sales or reduce inventory. It is effective from the viewpoint of increasing the turnover rate of

FIG. 3 is a diagram showing an example of the second setting master 106b. The second setting master 106b determines whether or not the planned allocation order quantity is taken into account in the calculation of the allocatable inventory quantity, or the first setting (specifically, the first setting stored in the first setting master 106a). setting value) is included for each product. Here, the setting value related to the second setting is, for example, a numerical value “0” indicating “according to the first setting”, a numerical value “1” indicating “not considering”, or a numerical value “ 2”, and so on. Note that the second setting master 106b is not an essential component in the inventory management device 100. FIG. In other words, the inventory management device 100 does not need to have the second setting master 106b.

FIG. 4 is a diagram showing an example of the received order data table 106c. The order data table 106c includes an order code, an order date, a product code, a product name, the number of orders received (quantity), and the like. Note that the order data table 106c is not an essential component of the inventory management device 100. FIG. In other words, the inventory management device 100 does not have to include the order data table 106c.

FIG. 5 is a diagram showing an example of the inventory data table 106d. The inventory data table 106d includes product code, product name, actual inventory quantity, planned allocation quantity of orders, quantity of already allocated orders, quantity of allocable inventory, and the like. Here, the allocated order quantity is the quantity of order received at the time of arrival from the actual inventory quantity (Supplementary note: the order quantity is related to orders received prior to the arrival of goods).

Returning to FIG. 1, the control unit 102 is a CPU or the like that controls the inventory management device 100 in a centralized manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally and conceptually includes a first setting registration unit 102a, a second setting registration unit 102b, an inventory management unit 102c, an inventory inquiry unit 102d, and the like.

The first setting registration unit 102a registers a first setting (specifically, a setting value related to the first setting). For example, the first setting registration unit 102a allows the operator to register a first setting (specifically, a setting value related to the first setting) via a predetermined screen (not shown).

The second setting registration unit 102b registers a second setting (specifically, a setting value related to the second setting) for each product. For example, the first setting registration unit 102a allows the operator to register the second setting (specifically, the setting value related to the second setting) for each product via a predetermined screen (not shown). Note that the second setting registration unit 102b is not an essential component in the inventory management device 100. FIG. In other words, the inventory management device 100 does not have to include the second setting registration section 102b.

The inventory management unit 102c sets the first setting (specifically, the first setting Inventory data is generated or updated according to the setting value related to the first setting stored in the master 106a.

Specifically, the inventory management unit 102c sets the first setting (specifically, (setting value related to the first setting stored in the first setting master 106a).

Then, the inventory management unit 102c stores the inventory data of the ordered product in the storage unit 106 (specifically, the inventory data table 106d) when the confirmed first setting takes into consideration the number of orders to be allocated. If not, the first generation process is executed, and if the inventory data of the ordered product is in the storage unit 106 (specifically, the inventory data table 106d), the first update process is executed.

In addition, the inventory management unit 102c confirms that the confirmed first setting (specifically, the setting value related to the first setting stored in the first setting master 106a) does not take into consideration the number of orders to be allocated. In this case, when the inventory data of the ordered product is not stored in the storage unit 106 (specifically, the inventory data table 106d), the second generation process is executed, and the inventory data of the ordered product is stored in the storage unit 106 (specifically, the inventory data table 106d). is in the inventory data table 106d), a second update process is executed.

Here, the first generation process stores zero as the actual inventory quantity, stores zero as the allocated order quantity, stores the order quantity of the ordered product as the planned allocation order quantity, and stores the actual quantity as the allocable stock quantity. Generate inventory data of the ordered product in which the number obtained by subtracting the allocated order quantity and the allocated order quantity from the inventory quantity is stored, and store the generated inventory data in the storage unit 106 (specifically, the inventory data table 106d). It is a process to

In addition, the first update process updates the scheduled allocation order quantity stored in the inventory data of the ordered product to the number obtained by adding the order quantity of the ordered product to the planned allocation order quantity, and updates the inventory data to the number obtained by subtracting the allocated order quantity stored in the relevant inventory data from the actual quantity of inventory stored in the relevant inventory data and the updated allocation planned order quantity. processing.

In the second generation process, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity of the ordered product is stored as the planned allocation order quantity, and the actual inventory quantity is stored as the allocable inventory quantity. This is a process of generating inventory data of ordered products in which the number obtained by subtracting the allocated order quantity from the number is stored, and storing the generated inventory data in the storage unit 106 (specifically, the inventory data table 106d).

In addition, the second update process updates the scheduled allocation order quantity stored in the inventory data of the ordered product to the number obtained by adding the order quantity of the ordered product to the planned allocation order quantity, and updates the inventory data It is a process of updating the allocable inventory quantity stored in the , to the number obtained by subtracting the allocated order quantity stored in the inventory data from the actual inventory quantity stored in the inventory data.

When the inventory management device 100 includes the second setting master 106b, the inventory management unit 102c instructs the registration of the order data of the ordered product on the order registration screen (for example, the order registration screen MA shown in FIG. 6). Then, the following processes (11) to (13) may be executed.

(11) Confirm the second setting (specifically, the setting value related to the second setting stored in the second setting master 106b) associated with the ordered product (specifically, product code or product name) If the confirmed second setting conforms to the first setting, then the first setting (specifically, the set value related to the first setting stored in the first setting master 106a) By confirming, it is determined whether or not to consider the number of orders to be allocated.
(12) When it is determined that the number of orders to be allocated is taken into consideration, if the inventory data of the ordered product is not in the storage unit 106 (specifically, the inventory data table 106d), the first generation process is executed, When the inventory data of the product is in the storage unit 106 (specifically, the inventory data table 106d), the first update process is executed.
(13) When it is decided not to consider the number of orders to be allocated, if the inventory data of the ordered product is not in the storage unit 106 (specifically, the inventory data table 106d), the second generation process is executed to When the inventory data of the purchased product is in the storage unit 106 (specifically, the inventory data table 106d), the second update process is executed.

When a product to be inquired is specified on an inventory inquiry screen (for example, the inventory inquiry screen MB shown in FIG. 7), the inventory inquiry unit 102d changes the first setting (specifically, the first setting stored in the first setting master 106a). setting value related to the first setting), and if the confirmed first setting takes into account the number of orders to be allocated, the first calculation process is executed, and the confirmed first setting If the setting does not consider the number of orders to be allocated, the second calculation process is executed, and the calculation result is output to the inventory inquiry screen.

Here, the first calculation process is based on the number of actual stocks stored in the inventory data of the specified product, the number of allocated orders stored in the inventory data, and the scheduled allocation orders stored in the inventory data. This is a process of calculating the number obtained by subtracting the number as the number of available inventory.

In addition, the second calculation process is a process of calculating the number obtained by subtracting the allocated order quantity stored in the inventory data from the actual inventory quantity stored in the inventory data of the designated product as the allocatable inventory quantity. is.

In addition, when the inventory management device 100 has the second setting master 106b, the inventory inquiry unit 102d, when the product to be inquired is designated on the inventory inquiry screen (for example, the inventory inquiry screen MB shown in FIG. 7), the following (21) to (23) may be executed.

(21) Confirm the second setting (specifically, the setting value related to the second setting stored in the second setting master 106b) associated with the designated product, and confirm that the confirmed second setting is the second setting. If it conforms to one setting, the first setting (specifically, the setting value related to the first setting stored in the first setting master 106a) is confirmed, so that the number of orders to be allocated Decide whether or not to add
(22) If it is determined that the planned number of orders to be allocated should be considered, the first calculation process is executed, and if it is determined not to consider the number of planned orders to be allocated, the second calculation process is executed.
(23) Output the calculation result to the inventory inquiry screen.

[2. Specific example of processing]
Here, a specific example of processing executed by the inventory management device 100 will be described.

For example, assuming the following (A1) to (C1), order data for a new apparel product scheduled to be sold in the future received an order at an exhibition (order date "2019/7/19", product code " 500001", product name "T-shirt (20SS)" and number of orders received "10") is instructed on an order registration screen (for example, order registration screen MA shown in FIG. 6), inventory management The unit 102c executes the first generation process, and as a result, the inventory data table 106d includes the product code "500001", the product name "T-shirt (20SS)", the actual inventory quantity "0", and the allocation planned order quantity "10". , the number of reserved orders "0" and the number of available stocks "-10" are stored. In this case, since the expected number of orders to be allocated is taken into account in the calculation of the quantity of inventory that can be allocated, orders for this exhibition can be preferentially allocated even after the stock arrives.

(A1) The first setting master 106a stores a numerical value "1" indicating "addition" as a setting value related to the first setting.
(B1) In the second setting master 106b, the product code "500001" and the product name "T-shirt (20SS)" of the new apparel product scheduled to be sold in the future and the setting value related to the second setting "according to the first setting ” is stored as a numerical value “0”.
(C1) The inventory data of the new apparel product scheduled to be sold in the future is not stored in the inventory data table 106d.

Further, for example, assuming the following (A2) to (C2), the order data of standard apparel items ordered at the exhibition (order date "2019/7/19", product code "100001" , order data including the product name "T-shirt (standard)" and order quantity "10") is instructed on the order registration screen (for example, the order registration screen MA shown in FIG. 6), the inventory management unit 102c executes the second update process, and as a result, the number of orders to be allocated and the number of available stocks in the inventory data stored in the inventory data table 106d are updated to "10" and "5", respectively. In this case, since the expected number of orders to be allocated is not taken into account in the calculation of the available inventory quantity, the available inventory quantity remains "5" as a result, and even if there is an additional follow-up order for the standard apparel item, it will be possible to allocate it. Become.

(A2) The first setting master 106a stores a numerical value "0" indicating "not considered" as a setting value related to the first setting.
(B2) A numerical value indicating the product code "100001" and the product name "T-shirt (standard)" of the standard apparel item and "according to the first setting" as the setting value related to the second setting in the second setting master 106b. "0" is stored.
(C2) In the inventory data table 106d, the inventory data of the standard apparel item (product code "100001", product name "T-shirt (standard)", actual inventory quantity "5", planned allocation order quantity "0", allocation completed) inventory data including the order quantity "0" and the allocable inventory quantity "5") is stored.

For example, in the case of an exhibition, orders are accepted without inventory, so data on unallocated orders (orders scheduled to be allocated) is accumulated. "If you handle a lot of standard products, calculate the number of available inventory without taking into account the number of orders that you plan to allocate, and if you handle a lot of new products that you plan to sell in the future, consider the number of orders that you plan to allocate. According to the type of products handled by the company, it is possible to set whether or not to take unallocated orders (orders scheduled to be allocated) into account in the calculation of allocatable inventory.

Here, when taking into account unallocated orders (orders scheduled to be allocated) in the calculation of the allocatable inventory and making allocations and shipments based on the allocatable inventory, many standard products are handled and exhibitions are held. When it is assumed that there is inventory that can be sold, it is not possible to know whether there is inventory that can be sold due to unallocated orders (orders scheduled to be allocated) at the exhibition (Reason: At the exhibition, orders are received without inventory, and then (Because orders are placed at 12:00 a.m., it takes time for inventory to arrive and to be ready for allocation), resulting in loss of sales. Therefore, in this embodiment, it is possible to change the setting of whether or not to take into consideration unallocated orders (orders scheduled to be allocated) in the calculation of the number of allocatable inventory, based on the fact that each company has a different way of thinking about inventory allocation. By doing so, it is possible to reduce lost sales and increase the inventory turnover rate.

In addition, if there are many customer orders, it is necessary to calculate the number of available stocks that can be allocated in order to create a situation where "an order is received when there is no stock and the stock is received, but it is not allocated by other orders". It is effective to consider allocation orders (orders scheduled to be allocated). As a result, the previously registered customer order can be preferentially reserved. Also, if you are ordering furniture, in order to avoid the situation where "orders with long delivery times are also included in the allocation schedule orders, other orders with short delivery times cannot be allocated and shipped". It is effective not to take unallocated orders (orders scheduled to be allocated) into account when calculating the quantity of inventory that can be allocated. This allows allocation to be made at any time.

[3. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above 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 automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

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

For example, the processing functions of the inventory management device 100, particularly the processing functions performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. 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 the inventory management device as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the inventory management apparatus 100 via any network, and it is possible to download all or part of it as necessary. be.

Also, the 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, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc, etc. shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single structure, but is distributed as a plurality of 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 the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

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. It stores programs, tables, databases, files for web pages, and so on.

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 arbitrary peripheral devices are connected. Also, the inventory management device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is particularly useful for inventory management in companies (for example, wholesalers, retailers, etc.) that accept orders even when there is no product in stock and reserve inventory at the time of receipt of goods rather than at the time of receipt of orders.

100 inventory management device 102 control unit
102a first setting registration unit
102b second setting registration unit
102c Inventory Control Department
102d inventory inquiry unit 104 communication interface unit 106 storage unit
106a first configuration master
106b second configuration master
106c Order data table
106d inventory data table 108 input/output interface unit 112 input device 114 output device 200 server device 300 network

Claims (6)

An information processing device comprising a control unit,
The number of orders received, which is the number of orders allocated at the time of arrival based on the actual number of stocks, the number of orders to be allocated, which is the number of orders to be allocated at the time of arrival based on the actual number of inventories, and the number of orders to be allocated from the actual number of stocks It is connected to a storage unit that stores inventory data for managing the number of available inventory that is the number of available inventory and the number of available inventory for each product,
The control unit
a first setting registering means for registering a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the quantity of inventory that can be allocated;
inventory management means for generating or updating inventory data in accordance with a first setting when registration of order data for an ordered product is instructed;
When the inventory management means is instructed to register the order data of the ordered product, (1) the first setting is confirmed, and (2) the confirmed first setting takes into account the number of orders to be allocated. When there is no inventory data of the product in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, and the order quantity of the relevant product is stored as the planned allocation order quantity. and generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the allocation scheduled order quantity from the actual inventory quantity is stored as the allocatable inventory quantity, and storing the generated inventory data in the storage unit. When the inventory data of the product is in the storage unit, the planned allocation order quantity stored in the inventory data is added to the planned allocation order quantity and the order quantity. Update the number of allocable inventory stored in the relevant inventory data from the actual inventory quantity stored in the relevant inventory data to the number of allocated orders stored in the relevant inventory data and the planned number of orders to be allocated after the update (3) If the confirmed first setting does not take into consideration the number of orders to be allocated, the inventory data of the product is not in the storage unit. Occasionally, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity is stored as the planned allocation order quantity, and the allocated order quantity is subtracted from the actual inventory quantity as the allocable inventory quantity. a second generation process for generating inventory data of the product in which the number is stored, storing the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, The number of orders to be allocated that is stored in the data is updated to the number obtained by adding the number of orders to the number of orders that are to be allocated, and the number of allocable inventory stored in the inventory data executing a second update process for updating the actual inventory quantity to the quantity obtained by subtracting the allocated order quantity stored in the relevant inventory data from the actual quantity in stock;
An information processing device characterized by: The control unit
further comprising a second setting registering means for registering for each product a second setting as to whether or not the planned allocation order quantity is taken into account in the calculation of the allocatable inventory quantity or whether the first setting is followed;
When the registration of the order data of the ordered product is instructed, the inventory management means (1) confirms the second setting associated with the product, and the confirmed second setting conforms to the first setting. If the number of orders to be allocated is determined by further confirming the first setting, (2) if it is decided to take into consideration the number of orders to be allocated, the order If the inventory data of the purchased product is not in the storage unit, the first generation process is executed, and if the inventory data of the product is in the storage unit, the first update process is executed. When it is determined not to take into consideration, the second generation process is executed when the inventory data of the product is not in the storage unit, and the second update process is executed when the inventory data of the product is in the storage unit. matter,
The information processing apparatus according to claim 1, characterized by: The control unit
When the product to be inquired is specified on the inventory inquiry screen, (1) the first setting is confirmed, and (2) if the confirmed first setting takes into consideration the number of orders to be allocated, , the number obtained by subtracting the number of allocated orders stored in the relevant inventory data and the number of scheduled orders stored in the relevant inventory data from the actual inventory quantity stored in the inventory data of the relevant product is taken as the allocable inventory quantity. Execute the first calculation process to calculate, and (3) if the confirmed first setting does not take into consideration the number of orders to be allocated, the actual inventory quantity stored in the inventory data of the product concerned (4) inventory inquiry means for executing a second calculation process for calculating the number obtained by subtracting the number of reserved orders stored in the inventory data as the number of available stocks, and (4) outputting the calculation result to the inventory inquiry screen; matter,
3. The information processing apparatus according to claim 1 or 2, characterized by: The control unit
further comprising a second setting registering means for registering for each product a second setting as to whether or not the planned allocation order quantity is taken into account in the calculation of the allocatable inventory quantity or whether the first setting is followed;
When the product to be inquired is specified, the inventory inquiry means (1) confirms the second setting associated with the product, and the confirmed second setting conforms to the first setting. In that case, further confirm the first setting to determine whether or not to take into account the planned number of orders to be allocated. (3) executing the second calculation process when it is determined not to consider the number of orders to be allocated; (4) outputting the calculation result to the inventory inquiry screen;
4. The information processing apparatus according to claim 3, characterized by: An inventory management method executed by an information processing device comprising a control unit,
The information processing device stores an actual inventory quantity, an allocated order quantity that is the quantity of orders allocated at the time of arrival from the actual quantity of inventory, and a scheduled allocation quantity of orders that is the quantity of orders that is scheduled to be allocated at the time of arrival from the actual quantity of inventory. is connected to a storage unit for storing inventory data for managing the number of available inventory, which is the number of inventory that can be allocated from the number of actual inventory, for each product;
The information processing device registers a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the number of available stocks,
executed by the control unit;
including an inventory management step of generating or updating inventory data in accordance with a first setting when registration of order data of the ordered product is instructed;
In the inventory control step, when the registration of the order data of the ordered product is instructed, (1) the first setting is confirmed, and (2) the confirmed first setting takes into consideration the number of orders to be allocated. When there is no inventory data of the product in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, and the order quantity of the relevant product is stored as the planned allocation order quantity. and generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the allocation scheduled order quantity from the actual inventory quantity is stored as the allocatable inventory quantity, and storing the generated inventory data in the storage unit. When the inventory data of the product is in the storage unit, the planned allocation order quantity stored in the inventory data is added to the planned allocation order quantity and the order quantity. Update the number of allocable inventory stored in the relevant inventory data from the actual inventory quantity stored in the relevant inventory data to the number of allocated orders stored in the relevant inventory data and the planned number of orders to be allocated after the update (3) If the confirmed first setting does not take into consideration the number of orders to be allocated, the inventory data of the product is not in the storage unit. Occasionally, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity is stored as the planned allocation order quantity, and the allocated order quantity is subtracted from the actual inventory quantity as the allocable inventory quantity. a second generation process for generating inventory data of the product in which the number is stored, storing the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, The number of orders to be allocated that is stored in the data is updated to the number obtained by adding the number of orders to the number of orders that are to be allocated, and the number of allocable inventory stored in the inventory data executing a second update process for updating the actual inventory quantity to the quantity obtained by subtracting the allocated order quantity stored in the relevant inventory data from the actual quantity in stock;
An inventory management method characterized by: An inventory management program to be executed by an information processing device having a control unit,
The information processing device stores an actual inventory quantity, an allocated order quantity that is the quantity of orders allocated at the time of arrival from the actual quantity of inventory, and a scheduled allocation quantity of orders that is the quantity of orders that is scheduled to be allocated at the time of arrival from the actual quantity of inventory. is connected to a storage unit for storing inventory data for managing the number of available inventory, which is the number of inventory that can be allocated from the number of actual inventory, for each product;
The information processing device registers a first setting as to whether or not to take into consideration the number of orders to be allocated when calculating the number of available stocks,
for causing the control unit to execute
including an inventory management step of generating or updating inventory data in accordance with a first setting when registration of order data of the ordered product is instructed;
In the inventory control step, when the registration of the order data of the ordered product is instructed, (1) the first setting is confirmed, and (2) the confirmed first setting takes into consideration the number of orders to be allocated. When there is no inventory data of the product in the storage unit, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, and the order quantity of the relevant product is stored as the planned allocation order quantity. and generating inventory data of the product in which the number obtained by subtracting the allocated order quantity and the allocation scheduled order quantity from the actual inventory quantity is stored as the allocatable inventory quantity, and storing the generated inventory data in the storage unit. When the inventory data of the product is in the storage unit, the planned allocation order quantity stored in the inventory data is added to the planned allocation order quantity and the order quantity. Update the number of allocable inventory stored in the relevant inventory data from the actual inventory quantity stored in the relevant inventory data to the number of allocated orders stored in the relevant inventory data and the planned number of orders to be allocated after the update (3) If the confirmed first setting does not take into consideration the number of orders to be allocated, the inventory data of the product is not in the storage unit. Occasionally, zero is stored as the actual inventory quantity, zero is stored as the allocated order quantity, the order quantity is stored as the planned allocation order quantity, and the allocated order quantity is subtracted from the actual inventory quantity as the allocable inventory quantity. a second generation process for generating inventory data of the product in which the number is stored, storing the generated inventory data in the storage unit, and when the inventory data of the product is in the storage unit, The number of orders to be allocated that is stored in the data is updated to the number obtained by adding the number of orders to the number of orders that are to be allocated, and the number of allocable inventory stored in the inventory data executing a second update process for updating the actual inventory quantity to the quantity obtained by subtracting the allocated order quantity stored in the relevant inventory data from the actual quantity in stock;
An inventory management program characterized by

Images