JP2019108195A - Inventory securing cancellation apparatus, inventory securing cancellation method, and inventory securing storage medium - Google Patents

Abstract

To provide an inventory securing cancellation device, an inventory securing cancellation method and an inventory securing cancellation program, capable of automatically performing inventory securing cancellation for a commodity having a prescribed number of days elapsed from an inventory securing date of inventory.SOLUTION: In the present embodiment, (1) a reference number of days associated with the securing unit identification data contained in the secured data is acquired from the reference day master, and (2) whether or not the acquired elapsed reference number of days has elapsed is determined based on the securing date included in the secured data, and when it is determined that the elapsed time has elapsed (3), the reserved number in the secured data is subtracted from the reserved number in the inventory data associated with the inventory unit identification data included in the securing unit identification data contained in the secured data.SELECTED DRAWING: Figure 8

Description

  The present invention relates to an inventory securing release apparatus, an inventory securing release method, and an inventory securing release program.

  Patent Literature 1 discloses an inventory management system capable of performing inventory management in accordance with the circumstances on the side of purchase applicants of products and the circumstances on the sales side (see paragraph 0003 of Patent Literature 1).

Unexamined-Japanese-Patent No. 2010-003139

  In the field of such inventory management, for example, a person in charge of sales may sometimes carry out stock securing in order to hold stock of goods. Securing stock is normally performed for products that are expected to be sold, but if there is no plan to sell for some reason, the sales representative releases stock securing (reverting to the state of free stock) )There is a need.

  However, if a sales representative fails to release the inventory, forgets to do so, or if the inventory is secured and left untouched, etc., the product that should be able to be sold can not be sold. As a result, there was a problem that it would lead to the loss of sales opportunities.

  The present invention has been made in view of the above problems, and it is possible to automatically release stock securing for goods for which a predetermined number of days have passed from the stock securing date, and stock securing release To provide a method and an inventory release program.

  In order to solve the problems described above and achieve the object, the inventory securing cancellation device according to the present invention is a stock securing cancellation device including a control unit and a storage unit, and the storage unit is a target for securing inventory. Securing unit identifying data including inventory unit identifying data which is data for identifying the product which is the product and data for identifying the stock of the product, and an elapsed reference number of days which is a number of days serving as a reference for releasing the inventory. A reference date master including, securing unit identification data, a securing date representing a date when the stock of the product was secured, and a securing data representing a secured number representing the number of the products for which stock was secured, inventory unit identification data Inventory data including the secured number is stored, and the control unit takes a number of days from which the elapsed reference number of days linked to the securing unit identification data included in the secured data is acquired from the reference number of days master. In the case where the means, the determination means for determining whether or not the elapsed reference number of days acquired by the number of days from the securing date included in the securing data has elapsed, and the determining means determine that the time has elapsed Release means for releasing stock securing by subtracting the number of securing in the securing data from the number of securing in the inventory data associated with the stock unit identification data included in the securing unit identification data in the securing data; It is characterized by having.

  Further, in the inventory securing release device according to the present invention, the determination unit subtracts the elapsed reference number of days acquired by the number of days acquisition unit from the designated date to calculate a date after subtraction, and is included in the secured data. It is characterized in that when the securing date is before the date after the subtraction after the subtraction, it is determined that the above-mentioned elapses.

  Further, in the inventory securing and releasing apparatus according to the present invention, the inventory data further includes an allocatable number of the product, and when the control unit determines that the determination unit determines that the storage unit is in progress, the securing data is The information processing apparatus may further comprise addition means for adding the secured number in the secured data to the available number in the inventory data linked with the stock unit identified data included in the secured unit identification data.

  Further, in the stock securing release apparatus according to the present invention, when the control unit determines that the determination means has made the progress, stock unit identification data and the secure data included in the securement unit identification data in the secure data And a form creation means for creating form data including the secured number of

  Further, in the inventory securing and releasing apparatus according to the present invention, the securing unit identification data may be commodity department identification data for identifying a department to which the commodity belongs, commodity classification identification data for identifying the classification of the commodity, and the commodity. A product identification data for identifying a product, a securement number which is a number of securement of the product, sales representative identification data for identifying a sales representative of the product, and a transaction for identifying a supplier who carries out the transaction of the product It is at least one data selected from the group consisting of destination identification data, and the inventory unit identification data is the commodity identification data.

  Further, the stock securing releasing method according to the present invention is the stock securing releasing method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit identifies a product to be a target of stock securing. And a reference day master including a securing unit identification data including stock unit identification data which is data for identifying stock of the product and a lapse reference days which is a number of days serving as a basis for releasing the stock. Securing data including securing unit identification data, a securing date representing a date on which the product was secured in stock, and a secured number representing the number of the products for which the inventory was secured, inventory unit identification data and the secured number Inventory data, which is stored, and is executed by the control unit, from the reference day master to obtain a day number from which the elapsed reference day associated with the securement unit identification data included in the secure data is acquired And a determining step of determining whether the elapsed reference number of days acquired in the number of days from the securing date included in the securing data has passed, and the determining step determines that the determining step has elapsed In this case, a releasing step of releasing the stock securing by subtracting the number of securing in the securing data from the number of securing in the inventory data associated with the stock unit identification data included in the securing unit identification data in the securing data; And including.

  Further, the stock securing cancellation program according to the present invention is a stock securing cancellation program to be executed by an information processing apparatus including a control unit and a storage unit, and the storage unit identifies a product to be a target of stock securing. Reference day master including securing unit identification data including stock unit identification data which is data for identifying the stock of the product and data for identifying the stock of the product and an elapsed reference , Securement data including securement unit identification data, securement date representing the date when the inventory of the product was secured, and securement number representing the number of the products for which the inventory was secure, inventory unit identification data and securement number An inventory standard that contains inventory data, and is stored from the reference day master to be executed by the control unit. A step of obtaining a number, a step of determining whether or not the elapsed reference number of days acquired in the number of days acquired from the securing date included in the secured data has passed, and the step of determining If it is determined that the number of secured units in the secured data is subtracted from the secured number in the inventory data associated with the stock unit identification data included in the secured unit identification data, the release of the secured inventory is canceled. And a releasing step.

  ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to cancel stock securing about goods in which predetermined days have passed since the securing day of stock can be performed automatically.

FIG. 1 is a block diagram showing an example of the configuration of the inventory securing and releasing apparatus. FIG. 2 is a diagram showing an example of the data configuration in the secured statement data and the inventory data. FIG. 3 is a diagram showing an example of a processing flow according to the present embodiment. FIG. 4 is a diagram showing an example of a slip of a product list for which stock securing has been canceled. FIG. 5 is a diagram showing an example of a data configuration in the deallocation setting master. FIG. 6 is a diagram showing an example of a data configuration example in secured statement data and inventory data. FIG. 7 is a diagram showing an example of details to be released for stock securing in the secured statement data. FIG. 8 shows an example of the data configuration in the secure statement data from which the items to be released from the stock removal have been deleted, and an example of the data configuration from the inventory data for which the secured number and the reallocable number of goods for which the inventory release was released are updated. FIG.

  Hereinafter, embodiments of the stock securing cancellation device, the stock securing canceling method, and the stock securing cancellation program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
In order reception work of goods, in order for each sales individual to hold stock, stock reservation can be performed on the system. When stock is secured, the stock continues to be out of stock for the order received after securing. In addition, stock securing is usually carried out when there is a possibility of receiving an order, but it may be carried out even if there is no possibility of receiving an order.

  Here, in the conventional sales management system, in order to treat the stock in the secured state as free stock (stock in which the secured state has been released), each individual in charge of sales was performing deletion processing of the secured data. It has been found that products that are not scheduled to be sold are left as they are secured.

  Therefore, in the present embodiment, for example, after a day set from the day when the secured state of stock is registered, sales are implemented by introducing a mechanism to forcibly return the secured stock to free stock by processing such as nighttime batch etc. It is possible to reduce the opportunity loss and improve the internal control rules. The specific configuration and operation will be described below.

[2. Constitution]
An exemplary configuration of the inventory securing and releasing apparatus 100 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 securing and releasing apparatus 100. As shown in FIG.

  The inventory securing release device 100 is a commercially available desktop personal computer. The inventory securing and releasing apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a commercially available notebook personal computer, a portable digital assistant (PDA), a smartphone, a tablet personal computer, etc. It may be a type information processing apparatus.

  The stock securing cancellation apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the inventory securing release device 100 are communicably connected via any communication path.

  The communication interface unit 104 communicably connects the inventory securing cancellation 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 communicably connecting the inventory securing and releasing apparatus 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like. Note that data of various masters and the like described later may be stored in the server 200, for example.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described 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 central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), 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, for example, a security cancellation basic setting master 106 a as a reference day master, security specification data 106 b as security data, and inventory data 106 c.

  Here, securing unit identification data and inventory unit identification data will be described.

  The securing unit identification data is data for identifying a product to be secured for inventory. Specifically, as shown in the securing item data 106b of FIG. 6, the securing unit identification data identifies, for example, product department identification data (department) for identifying the department to which the product belongs, and the classification of the goods. Product classification identification data (product classification), product identification data (product) for identifying the product, a securement number which is a secure number of the product, sales representative identification data for identifying a sales representative of the product (Sales representative) and at least one data selected from a group consisting of six data of customer identification data (customer) for identifying a customer who trades the product.

  In the securing statement data 106b of FIG. 6, an example is shown in which the securing unit identification data is the six data (department, product classification, product, securing number, sales representative and customer). However, although not shown in the drawing, the securing unit identification data may be, for example, three pieces of data (division, sales representative and customer), or only the customer.

  Inventory unit identification data is data for identifying the inventory of the product. Specifically, the inventory unit identification data is, for example, commodity identification data (a commodity) or the like for identifying the commodity, as shown in the inventory data 106c of FIG.

  The securing unit identification data is a concept including inventory unit identification data. For example, in the example of FIG. 6, as shown in the securing item data 106b, the securing unit identification data is the department, the product classification, the product, the securing number, the sales representative and the customer, while the inventory unit identifying data However, as shown in the inventory data 106c of FIG. 6, it is a commodity, so it can be seen that the securing unit identification data is a broad concept including inventory unit identification data.

  Hereinafter, specific contents of each master and each data will be described.

  As shown in FIG. 5, the security cancellation basic setting master 106a includes, for example, security unit identification data (division, sales representative and product classification) and an elapsed reference number of days which is a standard of cancellation of inventory security. In the example shown in FIG. 5, the designation of the sales representative is optional (it is possible to designate the elapsed reference days for a specific sales representative), and when the sales representative is not set, Elapsed reference days may be determined using only the department as a key.

  As shown in FIG. 6, for example, as shown in FIG. 6, the securing item data 106b represents securing unit identification data (department, product classification, product, securing number, sales representative and customer) and the date on which inventory of the product was secured. It includes the day and the secured number representing the number of goods for which inventory has been secured. In the example of FIG. 6, the sales representative and the customer are optional. As shown in FIG. 2, the reservation details data 106 b may further include, for example, a warehouse code, a transfer completion category, a reserved count, an unallocated count, a transferred count, and the like. For example, although it is possible to carry out stock keeping for each department, sales representative and customer, it is subtracted from free stock by managing the number of reserved items for securing item data 106b, and securing item data 106b is automatically switched at the time of order receipt, and it will be in the state where allocation was performed to the number of orders from the securing state. Then, when the items in the secured item data 106b are deleted, the number of allocations becomes zero, and the state of free inventory returns.

  As shown in FIG. 6, the stock data 106c includes, for example, stock unit identification data (merchandise), the number of stocks of the goods, the secured number, and the allocatable number of the goods. The inventory data 106c may further include, for example, a warehouse code and a reserved number, as shown in FIG.

  The control unit 102 is a CPU or the like that controls the inventory securing and releasing apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 functionally and conceptually includes, for example, (1) a day acquisition unit 102 a as a day acquisition unit for acquiring an elapsed reference day associated with the securing unit identification data included in the securing data from the reference day master. (2) a determination unit 102b as a determination unit that determines whether or not the elapsed reference number of days acquired by the number of days acquisition unit has elapsed from the securement date included in the securement data; If it is determined that the above-mentioned passage has occurred, stock securing is performed by subtracting the number of securing in the securing data from the number of securing in the inventory data linked to the stock unit identifying data included in the securing unit identification data in the securing data. When the release unit 102c as the release means for releasing the An adding unit 102d as adding means for adding the securing number in the securing data to the available number in the inventory data associated with the stock unit identifying data included in the securing unit identifying data; (5) the progress in the determining means If it is determined that the document data is determined, the form creation unit 102e as form creation means for creating form data including the stock unit identification data included in the securement unit identification data in the securement data and the securement number in the securement data; Have. In addition, about the detail of the process which each part performs, the following [4. Specific Example of Processing].

[3. Processing Overview]
In this item, an outline (process flow) of the process according to the present embodiment will be described with reference to FIG.

  First, as shown in “stock securing data batch cancellation process” in FIG. 3, information such as warehouse, goods, department, person in charge, customer, securing registration date etc. is specified, and extraction of the item from securing statement data 106b Do. At this time, it is possible to set such that a specification prior to ○ day from the reference date (for example, today's date) is to be a target for stock cancellation (target for deletion).

  When the information is designated, as shown in FIG. 3, the specification to be deleted is extracted with reference to the reservation release basic setting master 106a and the reservation specification data 106b. In the security release basic setting master 106a, it is possible to set a lapse reference number of days for each department and product category, or for each department, sales representative, and product category. As a result, it is possible to automatically determine the elapsed reference days (secured deadline days) by product category (using indicators such as the inventory turnover rate).

  When the specification to be deleted is extracted, the reservation specification data 106b becomes the reservation specification data 106b (the security specification Del in FIG. 3) from which the extracted specification to be deleted is deleted.

  The items extracted as the items to be deleted are automatically output as PDF data or the like as a form, as shown in the “list of items to be confirmed for deletion” in FIG. The specification extracted as the deletion target may be notified to the person in charge by e-mail or the like.

[4. Specific example of processing]
Hereinafter, specific examples of the process according to the present embodiment will be described in detail with reference to FIGS. 4 to 8.

[4-1. Acquisition process of days]
The number of days acquisition unit 102a acquires, from the security cancellation basic setting master 106a, the elapsed reference number of days associated with the security unit identification data included in the security description data 106b.

  Specifically, in the security specification data 106b of FIG. 6, the security unit identification data is a department, a product classification, a product, a security number, a sales representative, and a customer. In the second specification (the specification is information in a single horizontal line in the security specification data 106b) of the security specification data 106b of FIG. 6, the combination of the division and the product classification that is a part of the security unit identification data is Male outerwear and manufacturer products. Here, referring to the security cancellation basic setting master 106 a in FIG. 5, the passage reference days associated with the department “male outer” and the product classification “manufacturer product” are “eight days”. For this reason, the day number acquisition unit 102a acquires 8 days as the elapsed reference number of days for the second line of the detail line data 106b of FIG.

  Similarly, the day acquisition unit 102a acquires 8 days and 20 days as the elapsed reference days for the specifications of the third and sixth lines of the secure statement data 106b of FIG. 6, respectively.

  For the specification of the first line of the securing item data 106b of FIG. 6, referring to the securing cancellation basic setting master 106a of FIG. 5, the passage reference days linked with the department “male outer” and the item classification “PB goods” The sales representative "Ito" in the specification of the first line of the securing statement data 106b in Fig. 6 and the sales representative in the securing cancellation basic setting master 106a in Fig. 5 are two of "5 days" and "3 days". In this case, the day acquisition unit 102a does not match the “Yokoyama”, and in this case, the first line record in which the sales representative is blank in the security cancellation basic setting master 106a of FIG. The elapsed reference number of days “five days” of one horizontal row in the master 106 a is acquired.

  For the specification of the fourth line of the securing item data 106b of FIG. 6, referring to the securing cancellation basic setting master 106a of FIG. 5, the passage reference days linked with the department “male outer” and the item classification “PB goods” Although the sales representative in the specification of the fourth line of the secure statement data 106b of FIG. 6 is blank although there are two of “5 days” and “3 days”, in this case, the day acquiring unit 102a The lapse reference number of days “5 days” of the record in the first line in which the sales representative is blank in the security cancellation basic setting master 106 a is acquired.

  As for the specification of the fifth line of the secured item data 106b of FIG. 6, the section “bedding” and the product category “manufacturer product” do not exist in the secured cancellation basic setting master 106a of FIG. 102a does not acquire an elapsed reference number of days.

Summarizing the above, the day acquiring unit 102a can acquire the elapsed reference days shown below for the specifications of the first to fourth lines and the sixth line of the secure statement data 106b of FIG. 6, respectively.
Detail of 1st line Detail of 5th day 2nd line Detail of 3rd day 8th line Detail of 4th day 8th line Detail of 6th day

[4-2. Determination process]
The determination unit 102 b determines whether the elapsed reference number of days acquired by the number of days acquisition unit 102 a has passed from the securing date included in the securing statement data 106 b. In other words, the determination unit 102b identifies the items to be deleted (targets for releasing the inventory) based on the “secured date” included in the secured statement data 106b and the “elapsed reference number of days” included in the secured release basic setting master 106a. Do.

  Specifically, when the reference date to be the determination reference is September 7, the first line of the securing statement data 106b in FIG. The elapsed reference number of days (5 days) acquired in has passed. Therefore, as indicated by hatching in FIG. 7, the determination unit 102b determines that the first line of the specification has passed.

  Similarly, for the details of the fourth line of the secured statement data 106b in FIG. 6, as of September 7, the elapsed reference number of days (five days) acquired by the number of days acquiring unit 102a from the secured day (September 1) is It has passed. In addition, as for the specification of the sixth line of the secured statement data 106b in FIG. 6, as of September 7, the elapsed reference number of days (20 days) acquired by the day acquiring unit 102a from the secured date (August 16) has passed doing. Therefore, as indicated by hatching in FIG. 7, the determination unit 102b determines that the specifications of the fourth line and the sixth line have also elapsed.

  On the other hand, about the second line of the securing statement data 106b of FIG. 6, as of September 7, the passage reference days (8 days) acquired by the days acquiring unit 102a from the securing date (August 31) ) Has not passed. In addition, for the details of the third line of the secured statement data 106b in FIG. 6, as of September 7, the passage reference days (8 days) acquired by the days acquiring unit 102a from the secured date (August 31) has passed I did not. Therefore, the determination unit 102b determines that the details of the second line and the third line have not elapsed.

  In addition, about the specification of the 5th line of the securing description data 106b of FIG. 6, since it can not acquire passage reference | standard number of days as it demonstrated by [4-1], it is not the object of determination.

  Summarizing the above, as indicated by hatching in FIG. 7, the determination unit 102 b determines the specifications of the first, fourth, and sixth lines of the secure statement data 106 b of FIG. It is determined that the acquired elapsed reference number of days has elapsed.

  The determination unit 102b may perform the determination as described above, but may perform the determination according to the following calculation formula.

  That is, the determination unit 102b subtracts the elapsed reference number of days acquired by the number of days acquisition unit 102a from the designated date to calculate the date after subtraction, and the subtraction date before the subtraction date from which the securing date included in the securing statement data 106b is subtracted. If it is, it may be determined that the above has elapsed.

  Specifically, when the designated date is set to September 7, for the specification of the first line of the secure statement data 106b of FIG. Since subtraction will result in September 7-5 September 2nd, September 2 becomes the date after subtraction. Here, the securing date (August 31) included in the specification of the first line of the securing statement data 106b of FIG. 6 is before the date after the subtraction (September 2). Therefore, the determination unit 102b determines that, for the first line of the specification, the elapsed reference number of days acquired by the number of days acquisition unit 102a has elapsed from the securing date. The same calculation can be performed for the specifications of the fourth and sixth lines of the secured specification data 106b of FIG. 6, and thus the detailed description will be omitted.

  On the other hand, for the specification of the second line of the secured statement data 106b in FIG. 6, when the elapsed reference number of days acquired by the day number acquiring unit 102a is subtracted from the designated date, September 7th-8th = 8th As it will be 30th, August 30th will be the date after subtraction. Here, the securing date (August 31) included in the specification of the second line of the securing statement data 106b of FIG. 6 is not before the date after subtraction (August 30). Therefore, the determination unit 102b determines that the elapsed reference number of days acquired by the number of days acquiring unit 102a has not elapsed from the securing date for the second line of the specification. The same calculation can be performed for the specification of the third line of the secured specification data 106b in FIG. 6, and thus the detailed description will be omitted.

  The determination section 102b is a secure statement data in which the specifications of the first, fourth, and sixth lines of the secure statement data 106b determined to have passed the elapsed reference number of days acquired by the day acquisition unit 102a from the secure date 106b (shown in FIG. 8) may be created.

[4-3. Release processing]
If the release unit 102c determines that the determination unit 102b has passed, the securement data 106b is secured based on the securement number in the inventory data 106c linked to the inventory unit identification data included in the securement unit identification data in the securement data data 106b. Release the stock by subtracting the number.

  Specifically, in the security specification data 106b and the inventory data 106c of FIG. 6, the stock unit identification data is a commodity name. About the specification of the 1st line of reservation detailed data 106b of Drawing 6, a trade name is jacket PB01. Here, referring to the stock data 106c of FIG. 6, the secured number associated with the product name "jacket PB01" is "10". On the other hand, as shown in FIG. 6, the secured number included in the first line of the secured statement data 106b of FIG. 6 is “10”. Therefore, the cancellation unit 102c calculates 10−10 = 0 by subtracting 10 which is the secured number in the secured item data 106b from 10 which is the secured number in the inventory data 106c, and the stock of “jacket PB01” is stored. Release the reservation. The record of “jacket PB01” (the record is information of one horizontal line in the stock data 106c) after releasing the stock is shown surrounded by a frame in the stock data 106c of FIG.

  Similarly, the release section 102c releases the stock securing of "jacket PB02" also for the specification of the fourth line of the securing description data 106b of FIG. The details of the “jacket PB02” after releasing the stock are shown in a box in the stock data 106c of FIG. Further, similarly, the cancellation unit 102c cancels the securing of the stock of the “character pencil set” also for the specification of the sixth line of the securing description data 106b of FIG. The details of the “character pencil set” after releasing the stock are shown in a box in the stock data 106 c of FIG. 8.

[4-4. Addition processing]
When it is determined that the adding unit 102d has elapsed in the determining unit 102b, the adding unit 102d determines, in the secured item data 106b, the available number in the inventory data 106c linked with the inventory unit identification data included in the secured unit identification data in the secured item data 106b. Add the secured number.

  Specifically, for the specification of the first line of the secured statement data 106b of FIG. 6, the product name, which is inventory unit identification data, is the jacket PB01. Here, referring to the stock data 106c of FIG. 6, the allocatable number associated with the product name "jacket PB01" is "0". On the other hand, as shown in FIG. 6, the secured number included in the first line of the secured statement data 106b of FIG. 6 is “10”. Therefore, the adding unit 102d calculates 0 + 10 = 10 by adding 10 which is the secured number in the secured description data 106b to 0 which is the assignable number in the inventory data 106c. The record of “jacket PB01” after the addition is shown by being framed in the stock data 106c of FIG.

  Similarly, the adding unit 102d performs addition on "jacket PB02" also for the specification of the fourth line of the secured description data 106b of FIG. The record of “jacket PB02” after the addition is shown by being framed in the stock data 106c of FIG. Further, similarly, the adding unit 102d performs addition on the “character pencil set” also for the specification of the sixth line of the secured description data 106b in FIG. The record of the “character pencil set” after the addition is shown by being framed in the stock data 106c of FIG.

  As described above, as described in [4-3] and [4-4], the number of secured in the inventory data 106c is subtracted (minus the number of secured in the description deleted in the secured statement data 106b (released inventory)) (minus And the available number in the inventory data 106c is added (plus).

[4-5. Form creation processing]
If it is determined that the determination unit 102b has passed, the form creation unit 102e creates form data including inventory unit identification data included in the securement unit identification data in the secure statement data 106b and the securement number in the secure statement data 106b. .

  Specifically, for the specification of the first line of the secured statement data 106b in FIG. 6, the product name, which is inventory unit identification data, is the jacket PB01, and the secured number is 10. Therefore, as shown in the first record from the top of the form data in FIG. 4, the form creation unit 102e creates form data including the product name “jacket PB01” and the quantity “10 sheets” indicating the secured number. Do.

  Similarly, as to the second line of the specification data 106b of FIG. 6, the form creation unit 102e also refers to the product name "jacket PB02" as shown in the second record from the top of the form data of FIG. Form data including a quantity "20" indicating the secured number is created. Further, the form creation unit 102e similarly applies to the item name "character pencil" as shown in the third record from the top of the form data of FIG. 4 also for the specification of the sixth line of the secured statement data 106b of FIG. Create form data including "set" and a quantity "100 set" indicating the secured number.

[4-6. Summary]
As described above, according to the inventory securing and releasing apparatus 100 according to the present embodiment, it is possible to automatically release the inventory securing for the product for which the predetermined number of days has passed since the securing date of the inventory. Thereby, for example, it is possible to reduce the loss of sales opportunity caused by being left in a state of being stocked.

[5. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

  For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, with regard to the inventory securing and releasing apparatus 100, each component shown in the drawings is functionally conceptual and does not necessarily have to be physically configured as shown.

  For example, all or any part of the processing functions included in the inventory securing and releasing apparatus 100, in particular each processing function performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU. May also be implemented as wired logic hardware. The program is stored in a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the stock reservation is released as necessary. The device 100 is mechanically read. 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 such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, the computer program may be stored in an application program server connected to the inventory releasing apparatus 100 via any network, and all or part of them may be downloaded as needed. It is.

  Further, the program for executing the processing 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" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (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. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

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

  Further, the inventory securing and releasing apparatus 100 may be configured as an information processing apparatus such as a known personal computer or a work station, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. In addition, the inventory securing and releasing apparatus 100 may be realized by mounting software (including a program or data, etc.) that causes the apparatus to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is useful in all industries and industries, but is particularly useful in the industry where sales persons with inventory and sales are represented, such as the wholesale industry and the trading company industry.

100 stock securing release device 102 control unit
102a Day acquisition part
102b Judgment part
102c Release part
102d Adder
102e Form creation unit 104 Communication interface unit 106 Storage unit
106a Releasing Basic Setting Master
106b Secured Item Data
106c Inventory data 108 Input / output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

An inventory securing and releasing apparatus comprising a control unit and a storage unit, wherein
The storage unit
Data for identifying a product to be secured for inventory, which is data for identifying the inventory of the product, secured unit identification data including inventory unit identification data, and the number of days serving as a basis for releasing the secured inventory A standard days master including elapsed standard days and
Securement data including securement unit identification data, a securement date representing a date on which the securement of inventory for the product is performed, and a securement number representing the number of the products for which the securement of inventory is performed,
Inventory data, including inventory unit identification data and the number of reservations,
Is stored,
The control unit
Day acquisition means for acquiring, from the reference days master, a passage reference days linked to the securing unit identification data included in the securing data;
A determination unit that determines whether the elapsed reference number of days acquired by the number of days acquisition unit has elapsed from the security date included in the security data;
When it is determined by the determination means that the progress has occurred, the securing number in the securing data is subtracted from the securing number in the inventory data linked with the stock unit identification data included in the securing unit identification data in the securing data. Release means for releasing the inventory by
To provide
A stock release device characterized by The determination means
The date after subtraction is calculated by subtracting the elapsed reference number of days acquired by the number of days acquisition means from the designated date, and the securing date included in the securing data is equal to or less than the date after subtraction. To determine that
The inventory securing and releasing apparatus according to claim 1, characterized in that The inventory data further includes an allocatable number of the product,
The control unit
If it is determined by the determination means that the elapsed time is determined, the secured number in the secured data is added to the allocatable number in the inventory data associated with the stock unit identification data included in the secured unit identification data in the secured data. Further comprising adding means;
The inventory securing and releasing device according to claim 1 or 2, characterized in that The control unit
A form creation means is further provided for creating form data including inventory unit identification data included in the securement unit identification data in the securement data and the securement number in the securement data when it is determined by the determination means that the progress has occurred. about,
The inventory securing and releasing apparatus according to any one of claims 1 to 3, characterized in that Product unit identification data for identifying a division to which the item belongs, item classification identification data for identifying a category of the item, item identification data for identifying the item, and item identification data for securing the item to which the item belongs At least one selected from the group consisting of a securement number which is a securement number, sales representative identification data for identifying a salesperson of the product, and supplier identification data for identifying a supplier who carries out a transaction of the product. It is one data,
The stock unit identification data is the commodity identification data,
The inventory securing and releasing apparatus according to any one of claims 1 to 4, characterized in that An inventory securing cancellation method executed by an information processing apparatus including a control unit and a storage unit, the method comprising:
The storage unit
Data for identifying a product to be secured for inventory, which is data for identifying the inventory of the product, secured unit identification data including inventory unit identification data, and the number of days serving as a basis for releasing the secured inventory A standard days master including elapsed standard days and
Securement data including securement unit identification data, a securement date representing a date on which the securement of inventory for the product is performed, and a securement number representing the number of the products for which the securement of inventory is performed,
Inventory data, including inventory unit identification data and the number of reservations,
Is stored,
Executed by the controller
A days acquisition step of acquiring, from the reference days master, an elapsed reference days associated with the security unit identification data included in the security data;
A determination step of determining whether or not the elapsed reference number of days acquired in the number of days acquisition step has elapsed from the day of security included in the security data;
When it is determined in the determination step that the progress has occurred, the securing number in the securing data is subtracted from the securing number in the inventory data linked with the stock unit identification data included in the securing unit identification data in the securing data. Release step to release the stock by
Including
How to release inventory that is characterized by It is a stock securing cancellation program for making an information processor provided with a control part and a storage part perform, and.
The storage unit
Data for identifying a product to be secured for inventory, which is data for identifying the inventory of the product, secured unit identification data including inventory unit identification data, and the number of days serving as a basis for releasing the secured inventory A standard days master including elapsed standard days and
Securement data including securement unit identification data, a securement date representing a date on which the securement of inventory for the product is performed, and a securement number representing the number of the products for which the securement of inventory is performed,
Inventory data, including inventory unit identification data and the number of reservations,
Is stored,
For the control unit to execute
A days acquisition step of acquiring, from the reference days master, an elapsed reference days associated with the security unit identification data included in the security data;
A determination step of determining whether or not the elapsed reference number of days acquired in the number of days acquisition step has elapsed from the day of security included in the security data;
When it is determined in the determination step that the progress has occurred, the securing number in the securing data is subtracted from the securing number in the inventory data linked with the stock unit identification data included in the securing unit identification data in the securing data. Release step to release the stock by
Including
A stock release program characterized by

Images