JP4843628B2 - Inventory information processing equipment - Google Patents

Description

  The present invention relates to an inventory information processing apparatus used for inventory management of products in a store where the product is sold.

  At merchandise stores, the quantity of merchandise to be purchased is determined based on the theoretical stock quantity and actual stock quantity of each merchandise, and ordering work is performed. The above theoretical inventory quantity is calculated by subtracting the amount of goods delivered from the previous calculation to the current calculation and adding the quantity received from the previous calculation to the current calculation from the theoretical inventory calculated at the previous calculation. Is calculated. On the other hand, the actual number of stocks is counted by carrying out inventory for products existing in the store when the store is closed.

  Naturally, it is desirable that the theoretical inventory quantity and the actual inventory quantity coincide. However, due to miscounting of shoplifting and inventorying of products, and in stores that carry out inventory while the store is open, the act of returning the products that the customer had put into the basket at the time of the inventory to the display shelf after inventorying, etc. Depending on the case, the theoretical stock quantity and the actual stock quantity may not match. In order to prevent such discrepancies between the theoretical stock quantity and the actual stock quantity as much as possible, careful inventory was performed to grasp the exact actual stock quantity, or there was a discrepancy between the theoretical stock quantity and the actual stock quantity. Sometimes, when trying to find out where the actual stock quantity is short of the theoretical stock quantity, there is a problem that labor costs increase because of the manpower.

In order to deal with the above problems, for example, Patent Document 1 discloses an inventory processing system capable of correcting the theoretical stock quantity with the actual stock quantity by a predetermined method and keeping both errors within a consistent range. Has been.
Japanese Patent Laid-Open No. 11-134411

  By the way, in a store that is open 24 hours a day, such as a convenience store, it is necessary to perform inventory work in a short time so as not to hinder the business. Therefore, instead of taking inventory for all products registered on the product master, we take inventory for products that are actually on display shelves and backyards, count the actual stock, and then calculate the actual stock. There are stores that take the operational form of correcting the theoretical inventory quantity by number.

  At this time, since the product that has not been inventoried is not corrected by the actual stock quantity, even if the product does not already exist in the store, the theoretical stock quantity does not become “0” and the data is retained. End up. In addition, if a large amount of product data that does not actually exist in the store and the theoretical stock quantity is not “0” is accumulated, it becomes a heavy burden on the person who confirms the product. .

  The present invention has been made based on the circumstances as described above, and its purpose is to be able to correct the number of stocks of all products including non-existing products, and accurately grasp the number of stocks to qualify. It is to provide an inventory information processing apparatus that enables a large quantity of merchandise to be ordered.

  The inventory information processing apparatus according to the present invention includes a theoretical inventory storage unit that stores a theoretical inventory quantity for each product, a date storage unit that stores a date of the last inventory for each product, and a memory stored in the date storage unit. A product extracting means for extracting a product satisfying a predetermined condition for the date of the last inventory, a correcting means for correcting the number of theoretical stocks stored in the theoretical stock storage means for the product extracted by the product extracting means; It is characterized by comprising.

  According to the present invention in which such measures are taken, inventory information that can correct the inventory quantity of all products including non-existing products, accurately grasp the inventory quantity, and can place an order for a qualified quantity of products. A processing device can be provided.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. In addition, this Embodiment is an example which applied the inventory information processing apparatus 1 which concerns on this invention to the store server installed in merchandise sales stores, such as a convenience store.

  FIG. 1 is a block diagram showing a main configuration of the inventory information processing apparatus 1. The inventory information processing apparatus 1 includes a control unit 10 having a CPU (Central Processing Unit) as a control subject. The inventory information processing apparatus 1 connects a display device such as a display to display various statuses, connects an input device such as a keyboard and a pointing device, and receives an input from an operator. Wired to an output unit 13 that controls the printer 40 connected to the printer and performs predetermined printing, a handy terminal (H / T) 50 that is an inspection terminal used for inventory, and a POS (Point Of Sales) terminal (not shown) Alternatively, the communication unit 14 that performs wireless data transmission / reception, the storage unit 15 including a ROM (Read Only Memory), a RAM (Random Access Memory), and the like, and the inventory organizing unit 30 that is a main body that processes inventory information are controlled as described above. It is configured to be connected to the unit 10.

  The handy terminal 50 communicates with the communication unit 14 of the inventory information processing apparatus 1 in a wired or wireless manner, which is a display device capable of displaying various information when inventory of goods is performed in the store where the inventory information processing apparatus 1 is placed. A communication unit capable of performing at least one, an input device capable of inputting the quantity of products counted by taking inventory, and a storage unit for storing and holding the quantity of products input from the input device.

  At the time of inventory, the quantity of each product input by the operator to the handy terminal 50 is stored as inventory data 51 in the storage unit of the handy terminal. FIG. 2 is a schematic diagram illustrating an example of the structure of the inventory data 51. In the inventory data 51, an operator inputs the date when inventory was performed using the handy terminal 50, a PLU (Price Look Up) code that is a unique identifier assigned to each product type, and each PLU code. The quantity of the product is stored.

  The storage unit 15 of the inventory information processing apparatus 1 includes an inventory table 16 that stores the actual inventory quantity, an inventory performance table 17 that stores the theoretical inventory quantity, a condition table 18 that stores correction conditions for the theoretical inventory quantity, and a theoretical inventory. An inventory control information table 19 is provided for storing information on the product whose number is corrected.

  FIG. 3 is a schematic diagram illustrating an example of a data structure stored in the inventory table 16. The inventory table 16 stores the PLU code of each product, the actual inventory number of the product specified by each PLU code, and the registration date that is the date when the product specified by each PLU code was last invented. (Date storage means). Each data stored in the table 16 is updated when the inventory data 51 is received from the handy terminal 50 (details will be described later in the description of FIG. 7).

  FIG. 4 is a schematic diagram illustrating an example of a data structure stored in the inventory record table 17. The stock record table 17 is created on a daily basis, and stores the creation date, the PLU codes of all products handled by the store, and the theoretical stock number of the products specified by each PLU code (theoretical stock storage means).

  The theoretical stock quantity is based on the theoretical stock quantity of the commodity specified by the same PLU code stored in the previous day's actual inventory table 17 and the incoming and outgoing quantities from the time of creation of the table 17 on the previous day to the present. Is calculated. Further, the calculated theoretical stock quantity is replaced with the actual stock quantity of the products whose registration date is between the creation time of the table 17 on the previous day and the present time among the data stored in the inventory table 16. In other words, the theoretical inventory quantity of each product is corrected with the actual inventory quantity if the inventory has been carried out for the product, but otherwise it is not corrected and the same theoretical inventory quantity as the previous time. Will be held. The theoretical inventory number is retained until the inventory of the product is carried out thereafter.

  FIG. 5 is a schematic diagram illustrating an example of a data structure stored in the condition table 18. The condition table 18 stores inventory arrangement conditions for specifying products to be arranged by the inventory arrangement unit 30. In the present embodiment, as an example, “theoretical inventory quantity is not 0” and “three or more months have passed since the last inventory” are set as the inventory arrangement condition. However, the inventory control conditions are not limited to these, and may be set to other conditions by adding new conditions.

  FIG. 6 is a schematic diagram illustrating an example of a data structure stored in the inventory organization information table 19. The table 19 includes a PLU code of a product subject to inventory organization extracted by the inventory organization unit 30 from the inventory result table 17 according to the conditions of the condition table 18, and a product master (not shown) stored in the storage unit 15 with the PLU code. The product name, standard, and registration date that is the date when the product inventory was last performed are stored.

  Next, the inventory table update process executed by the inventory organizing unit 30 when the inventory information processing apparatus 1 receives the inventory data 51 from the handy terminal 50 via the communication unit 14 will be described with reference to FIGS. This will be specifically described with reference to FIG.

  FIG. 7 is a diagram showing a flow of processing executed by the inventory organizing unit 30 in the inventory table update processing. First, the inventory organizing unit 30 searches the inventory table 16 for the same PLU code as each PLU code included in the inventory data 51 in ST101, and updates the actual inventory number with the product quantity of the inventory data 51.

  That is, the product quantities “10”, “2”, “10” corresponding to the PLU codes “1001”, “1003”, “1004”, “1006”, “1008”, “1010” of the inventory data 51 shown in FIG. The actual stock quantity for the same PLU code in the inventory table 16 is updated with “3”, “16”, “6”, and “4”, respectively.

  Next, the inventory organizing unit 30 updates the registration date for the PLU code whose actual inventory quantity has been updated in the process of ST101 with the registration date of the inventory data 51 as ST102, and ends the update process.

  That is, the PLU codes “1001”, “1003”, “1004”, “1006”, “1008”, “1010” in the inventory table 16 with the registration date “2007/12/01” of the inventory data 51 shown in FIG. Update registration date for "".

  As described above, as a result of executing the inventory table update processing using the inventory data 51 shown in FIG. 2, for example, the inventory table 16 shown in FIG. 3 is obtained. In addition, the part updated by the said process in FIG. 3 is underlined and displayed.

  By updating the registration date of the inventory table 16 with the inventory data 51 as described above, the registration date for each PLU code in the inventory table 16 stores the date when the product specified by the PLU code was last invented. Will be.

  Next, the inventory arrangement process until the inventory arrangement unit 30 creates the inventory arrangement information table 19 using the inventory table 16, the inventory record table 17, and the condition table 18 is shown in FIGS. This will be specifically described with reference to FIG.

  FIG. 8 is a diagram showing a flow of processing executed by the inventory arranging unit 30 in the inventory arranging process. First, the inventory organizing unit 30 initializes parameters used for the inventory organizing process in ST201. Next, the inventory organizing unit 30 acquires a condition for extracting a product for inventory organizing from the condition table 18 in ST202.

  That is, it is acquired from the condition table 18 shown in FIG. 5 on the condition that (a) “theoretical inventory quantity is not 0” and (b) “three months or more have passed since the last inventory”.

  Next, the inventory organizing unit 30 extracts products to be subject to inventory organization from the inventory performance table 17 based on the conditions acquired from the condition table 18 in ST203 (product extracting means). That is, based on the condition (a) from the inventory record table 17 shown in FIG. 4, first, PLU codes “1001”, “1002”, “1003”, “1004”, “1005”, “1005”, “1005”, “1005”, “ 1006 "," 1007 "," 1008 "," 1009 ", and" 1010 "are extracted. Next, if the current date is, for example, December 1, 2007, the current date of these PLU codes is compared with the registration date of the inventory table 16 shown in FIG. “1005” and “1007”, which are PLU codes that have passed three months or more from the last inventory date, are extracted. Note that the order of extracting products based on the above conditions (a) and (b) may be reversed.

  Thereafter, the inventory organizing unit 30 determines whether or not there is a product extracted as an inventory organizing target in ST204. When there is extracted data (Yes in ST204), the inventory arrangement unit 30 adds the product extraction result to the inventory arrangement information table 19 in ST205.

  That is, the PLU codes “1005” and “1007” extracted from the inventory record table 17 shown in FIG. 4 are added to the inventory organization information table 19 and the product name and product standard specified by these PLU codes are entered from the product master. Further, the registration date specified by these PLU codes is acquired from the inventory table 16 and stored. As a result, the inventory control information table 19 shown in FIG. 6 is obtained.

  Next, the inventory organizing unit 30 stores the PLU code, the commodity name, the standard, the number of inventory before the organizing, the registration date, the creation date and time, the store code of the commodity extracted as the object of inventory organizing based on the inventory organizing information table 19 in ST206. And print data of the inventory organization confirmation list having the store name and the like (list creating means). Thereafter, the inventory organizing unit 30 outputs the print data of the inventory management list to the printer 40 via the output unit 13 in ST207 (list output unit). The printer 40 receiving the output of the print data of the inventory arrangement confirmation list prints and issues the list.

  Then, the operator confirms the issued inventory arrangement confirmation list and inputs an instruction as to whether or not to carry out inventory arrangement from an input device connected to the input unit 12.

  After ST207, the inventory organizing unit 30 stands by in a state of accepting the input by the operator as ST208 (instruction accepting means), and when it is determined that there is an instruction from the operator (Yes in ST208), the inventory organizing information as ST209. Based on the table 19, inventory adjustment is executed on the inventory result table 17 of the day, and the inventory adjustment process is terminated (correction means).

  Specifically, the above inventory adjustment searches for the same PLU code as the PLU code stored in the inventory adjustment information table 19 from the inventory result table 17 on the current day, and changes the theoretical inventory quantity for the PLU code to “0”. To do.

  At this time, FIG. 9 shows the result of inventory reduction performed on the inventory record table 17 shown in FIG. 4 based on the inventory control information table 19 shown in FIG. Note that portions updated by the processing in FIG. 9 are underlined.

  Here, when the inventory management unit 30 determines that there is no extracted data in the process of ST204 (No in ST204), an error message is displayed on the display device connected to the display unit 11 as ST210, and the inventory management is performed. End the process.

  Further, when it is determined in the process of ST208 that the operator has not instructed the execution of inventory arrangement (No in ST208), the inventory arrangement unit 30 ends the inventory arrangement process.

  In this way, even if there are many products whose theoretical inventory quantity is not “0” even though the products are not already present in the store, the inventory information processing apparatus 1 has the last product. Since the inventory table 16 holds the inventory date, it is possible to automatically extract products that have not been inventoried for a long period of time and are unlikely to exist in the store. Further, the operator can easily grasp such a product based on the inventory rearrangement confirmation list output from the printer 40.

  Furthermore, since the stock information processing apparatus 1 corrects the theoretical stock quantity of the product displayed in the stock check list by the stock management process, the labor spent on the check work of the product that is unlikely to exist in the store. Can be reduced.

  In addition, since the number of stocks of all products, including non-existing products, can be corrected, the person who orders the products can accurately grasp the number of stocks and place an order for a qualified quantity of products. .

  The present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage.

  For example, the last inventory date of each product is stored at the registration date and time of the inventory table 16, but the present invention is not limited to this, and a new table for holding the date is stored in the storage unit 15 or other storage device. You may make it memorize and memorize it there.

  In addition, even if the configuration is such that only the last inventory date of each product is stored without performing the inventory arrangement process shown in FIG. 8, the operator manually corrects the theoretical inventory quantity based on the stored date. Therefore, the object of the present invention can be achieved.

  Further, the condition extracted as the product for inventory control may be set to another condition by adding a new condition as described above with reference to FIG. The inventory information processing apparatus 1 can be used more effectively by setting appropriate conditions suitable for the operation form of each store.

  In the present embodiment, the inventory data 51, the inventory table 16, the inventory performance table 17, and the inventory organization information table 19 are configured to store dates such as a registration date and a creation date. It may be. Accordingly, a condition related to date and time may be added by setting the condition table 18.

  In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment.

The block diagram which shows the principal part structure of the inventory information processing apparatus in one Embodiment of this invention. The schematic diagram which shows an example of the structure of the inventory data in the embodiment. The schematic diagram which shows an example of the data structure of the inventory table in the embodiment. The schematic diagram which shows an example of the data structure of the inventory performance table in the embodiment. Schematic diagram showing an example of the data structure of the condition table in the same embodiment The schematic diagram which shows an example of the data structure of the inventory control information table in the embodiment. The flowchart of the inventory table update process in the embodiment. The flow chart of inventory arrangement processing in the embodiment. The inventory performance table which is the result of inventory arrangement in the embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Inventory information processing apparatus, 10 ... Control part, 11 ... Display part, 12 ... Input part, 13 ... Output part, 14 ... Communication part, 15 ... Memory | storage part, 16 ... Inventory table, 17 ... Inventory performance table, 18 ... Condition table, 19 ... Inventory arrangement information table, 30 ... Inventory arrangement section, 40 ... Printer, 50 ... Handy terminal, 51 ... Inventory data

Claims (6)

Theoretical inventory storage means that stores the theoretical inventory quantity for each product,
A date storage means for storing the last inventory date for each product;
A product extracting unit for extracting a product in which the date of the last inventory stored in the date storage unit satisfies a predetermined condition;
Correction means for correcting the number of theoretical stocks stored in the theoretical stock storage means for the products extracted by the product extraction means;
An inventory information processing apparatus comprising:   2. The product extracting unit extracts a product on condition that a predetermined period has elapsed from a date when the current date is the last stocked date stored in the date storage unit. Inventory information processing equipment.   The commodity extraction means is provided on the condition that the current date has passed a predetermined period from the last inventory date stored in the date storage means, and the theoretical inventory number stored in the theoretical inventory storage means is not zero. The inventory information processing apparatus according to claim 1, wherein a commodity is extracted as:   The inventory information according to any one of claims 1 to 3, wherein the correction unit sets a theoretical stock quantity stored in the theoretical stock storage unit of the product extracted by the product extraction unit to 0. Processing equipment. List creation means for creating a list of products extracted by the product extraction means;
List output means for outputting the list created by the list creation means;
The inventory information processing apparatus according to claim 1, further comprising: After the list output means outputs the list, it further comprises an instruction receiving means for receiving an instruction as to whether or not to perform correction by the correction means,
The said correction | amendment means correct | amends the theoretical inventory number of the said theoretical inventory memory | storage means with respect to the goods extracted by the said goods extraction means, only when the said instruction | indication reception means receives an instruction | indication. Inventory information processing equipment.

Images