JP2006164054A - Inventory data processing apparatus and inventory data processing program - Google Patents

Abstract

An object of the present invention is to make it possible to check whether or not a product has been forgotten to be executed before the inventory confirmation operation, thereby preventing the inventory confirmation operation from being redone.
A single product master file in which a department is set corresponding to a single product code of each product, an inventory input data file for accumulating and storing unconfirmed product inventory data, and an inventory for accumulating and storing confirmed product inventory data. A definite data file. For each department, the number of single items belonging to the department is counted with reference to the data of the single article master file. For each department, the number of single items for which inventory has been confirmed for the products belonging to that department is counted with reference to the data in the inventory confirmation data file. For each department, the number of single articles for which goods inventory data has already been entered is counted with reference to the data in the inventory input data file. The number of uninvented single items is calculated by subtracting the number of single inventoried items and the number of single-inventory input items from the number of master single items for each department. Output the number of uninvented single items by department.
[Selection] Figure 7

Description

  The present invention relates to an inventory data processing apparatus for determining product inventory data, and an inventory data processing program for causing a computer to function as the inventory data processing apparatus.

  In stores such as supermarkets, for example, the inventory quantity of each product is checked at the end of the month, and the inventory quantity, purchase quantity, and sales quantity of the month are checked for each product, so-called inventory work is periodically performed. There is a need.

  In order to carry out the inventory work efficiently, the inventory quantity of the product specified by the single product code is one by one by scanning the single product code (bar code) of the stock product with a scanner provided in a handy terminal or the like. There has been known a technique that is configured to be added so that the inventory quantity for each product can be easily aggregated (see, for example, Patent Document 1).

  Incidentally, product inventory data input using an input terminal such as a handy terminal is sent to a store controller, which is an upper server of a POS (Point Of Sales) system, for example. Then, when the inventory confirmation operation is performed in the store controller, it is stored in the database together with information on the inventory execution date.

On the other hand, the store controller database also counts and manages the purchase quantity and sales quantity of each product. Then, for example, when the store controller designates the year and month and instructs the output of the inventory slip, the stock quantity by product of the product that was invented in that year, the stock quantity at the time of the previous inventory of the product, the previous inventory An inventory form showing a list of the total purchase quantity and the total sales quantity in the period from the current time to the current inventory time is created and displayed or printed out. By inspecting the inventory form, the store manager can check whether or not each product is lost.
JP 2003-44939 A

  However, conventionally, although it is possible to check the presence or absence of a product for which inventory has been executed after the inventory confirmation operation has been performed, it has not been possible to check for the presence or absence of a product for which inventory has been forgotten. For this reason, it has been found that there is a product for which the inventory is forgotten to be executed after the confirmation operation, and the confirmation operation has to be performed again after inputting the inventory data of the product.

  The present invention has been made based on such circumstances, and the purpose of the present invention is to confirm the presence or absence of a product that has been forgotten to be executed before the inventory confirmation operation, and to repeat the inventory confirmation operation. It is an object of the present invention to provide an inventory data processing apparatus that can be prevented.

  Also, the present invention provides an inventory data processing program that can check whether or not a product has been forgotten to be executed before the inventory confirmation operation, and can implement an inventory data processing function on a computer that can prevent the inventory confirmation operation from being redone. It is what.

  The inventory data processing apparatus of the present invention captures and confirms the product inventory data such as the single product code and inventory quantity of the product for which inventory has been performed, and the department to which the product belongs corresponds to the single product code of each product. A set single product master file, an inventory input data file for accumulating and storing unconfirmed product inventory data, and an inventory confirmation data file for accumulating and storing confirmed product inventory data are provided. In addition, a master single item counting means that counts the number of single items belonging to the division for each category by referring to the data in the single item master file, and the number of single items that have been inventoried for the products belonging to the division for each division. Inventory counting unit that counts by referring to the data in the inventory confirmation data file, inventory input that counts the number of single items that have entered the product inventory data for the products belonging to that department by department, with reference to the data in the inventory input data file Single item number counting means and non-inventory single item calculation means for calculating the number of uninvented single items by subtracting the number of single inventory items and the number of inventory input single items from the master single item number for each department. By outputting the number of uninvented single items for each department calculated by the above, it is possible to check the presence or absence of a product that has been forgotten to be inventoried before the inventory confirmation operation.

  Further, the inventory data processing program of the present invention includes a single item master file in which a department to which a product belongs is set corresponding to a single item code of each item, a single item code of an item for which inventory has been performed, and a product inventory such as an inventory quantity. Classify each product on a computer that can access the inventory input data file that stores and stores unconfirmed product inventory data in the data and the inventory confirmation data file that stores and stores confirmed product inventory data in the product inventory data A function that counts the number of single items belonging to each department by referring to the data in the single item master file, and the number of single items that have been inventoried for products belonging to that department for each department, with reference to the data in the inventory confirmation data file Count the number of single items that have already been entered in the product inventory data for the products belonging to that department by department. A function to calculate the number of uninvented single items by subtracting the number of inventoried single items and the number of inventoried single items from the number of master single items calculated for each department, and a function for each department calculated by this function. It realizes the function to output the number of uninvented single items.

  According to the present invention in which such measures are taken, it is possible to provide an inventory data processing apparatus that can confirm whether or not a product has been forgotten to be executed before the inventory confirmation operation and can prevent the inventory confirmation operation from being performed again.

  In addition, it is possible to provide an inventory data processing program that can confirm on the computer the inventory data processing function that can confirm whether there is a product that has been forgotten to be executed before the inventory confirmation operation and can prevent the inventory confirmation operation from being redone.

Hereinafter, the best mode for carrying out the present invention will be described with reference to the drawings.
In this embodiment, the inventory data processing program according to the present invention is installed in a computer that functions as a store controller, which is a host server of the POS system, so that the computer functions as an inventory data processing apparatus. .

  FIG. 1 is a block diagram showing a main configuration of an inventory data processing system according to the present embodiment. This system includes a computer main body 10 functioning as a store controller, an operation input unit 20 such as a keyboard and a mouse connected to the computer main body 10, and a display such as a liquid crystal display and a CRT display connected to the computer main body 10. The unit 30 includes a POS terminal 40 which is an input terminal for merchandise sales data and merchandise purchase data, and a handy terminal 50 which is an input terminal for merchandise inventory data.

  The computer main body 10 includes a communication interface unit 11, an arithmetic processing unit 12, a program storage unit 13, a data storage unit 14, an input / display control unit 15, a display buffer 16 and the like in order to realize an inventory data processing function according to the present invention. It has.

  The communication interface unit 11 has a function of taking in merchandise sales data such as a single item code and a sale number of merchandise registered for sale from the POS terminal 40 connected via the communication line 41. In addition, it has a function of fetching product inventory data such as a single product code and an inventory quantity of a product for which inventory has been performed from the handy terminal 50 connected via the communication line 51. The communication interface unit 11 is configured by a LAN board, for example.

  The arithmetic processing unit 12 performs various types of arithmetic processing based on a program stored in the program storage unit 13, and can access a data file stored in the data storage unit 14 during the arithmetic processing. The arithmetic processing unit 12 is constituted by a CPU, for example.

  The program storage unit 13 stores an inventory data processing program according to the present invention. The inventory data processing program has its substance recorded on a computer-readable recording medium such as a CD-ROM or a flexible disk, and is read by a medium reader provided in the computer main body 10, whereby the program storage unit 13. Is written to. Alternatively, the entity is downloaded to the computer main body 10 via the communication lines 41 and 51 which are transmission media, and written into the program storage unit 13. The program storage unit 13 is composed of, for example, a ROM, EPROM, HDD device or the like.

  The input / display control unit 15 has a function of fetching data input via the operation input unit 20 and supplying the data to the arithmetic processing unit 12, and a function of reading display data from the display buffer 16 and displaying it on the display unit 30. is doing. The input / display control unit 15 includes, for example, an input / output interface and a driver.

  The data storage unit 14 has a function of storing data files such as a department master file 61, a single product master file 62, an inventory input data file 63, and an inventory confirmation data file 64. The data storage unit 14 is configured by a nonvolatile storage device such as an HDD device or a memory card.

  As shown in FIG. 2, the department master file 61 is a data file that stores a department name and an uninventory processing classification code for each department code for classifying each product. Here, the uninventory process classification code = 1 corresponds to a process of determining the inventory quantity of a product that has not been inventoried with a product belonging to the department by “0”. The uninventory processing classification code = 0 determines the inventory quantity of a product that has not been inventoried for a product belonging to the relevant department as the calculated value on the book, which is obtained by subtracting the sales quantity from the value obtained by adding the purchased quantity to the previous inventory quantity. Corresponds to processing. The uninventory processing classification code = 2 is determined as “0” when the number of uninventoried single items described later is “0”, and other than “0”, if the number of uninvented items is “0”. In the case of, this corresponds to the process of confirming with the calculated value on the book.

  As shown in FIG. 3, the single product master file 62 corresponds to the single product code of each product set for each product, and the department code and single product name to which the product belongs, the inventory confirmation quantity, the purchase quantity, and the sales quantity. Is a data file for storing. The inventory confirmation quantity is an inventory quantity determined for each product in the latest inventory confirmation processing. The purchase quantity is a total purchase quantity for each product after the latest inventory confirmation process, and is updated based on data accumulated in the data storage unit 14 by an operation input from the operation input unit 20. The sales volume is the total sales volume for each product after the latest inventory confirmation process, and is updated based on the product sales data fetched from the POS terminal 40.

  As shown in FIG. 4, the inventory input data file 63 is a data file for accumulating and storing inventory input data including items such as an inventory execution date, a single item code, a department code, a case quantity, a loose quantity, and an input quantity. The case quantity, the rose quantity, and the input quantity are inventory quantities, and are included in the commodity inventory data taken from the handy terminal 50.

  As shown in FIG. 5, the inventory confirmation data file 64 is a data file for accumulating and storing inventory confirmation data including items of a single item code, an inventory execution date, and the number of inventory.

  Therefore, in the present embodiment, product inventory data such as a single product code and an inventory quantity of the product inventoried at the handy terminal 50 is input, and this product inventory data is input to the computer main body 10 via the communication line 51. Then, the arithmetic processing unit 12 creates inventory input data from the unconfirmed product inventory data and additionally stores it in the inventory input data file 63.

  When the product purchase data and product sales data registered at the POS terminal 40 are taken into the computer main body 10 via the communication line 41, the arithmetic processing unit 12 is based on the product purchase data and product sales data. The purchase quantity and sales quantity of the single article master file 62 are updated.

  Further, when the execution of the inventory confirmation job is instructed by the operation input of the operation input unit 20, the arithmetic processing unit 12 starts the inventory data processing program stored in the program storage unit 13 and is shown in the flowchart of FIG. The process of the procedure is to be executed.

  First, the arithmetic processing unit 12 displays an inventory confirmation condition screen on the display unit 30 as ST (step) 1 and waits for the execution date and the inventory confirmation condition of the inventory department to be input. If the inventory confirmation condition is input by the operation input of the operation input unit 20, the arithmetic processing unit 12 selects one inventory department that is the inventory confirmation condition as ST2. And the process of ST3-ST14 is performed with respect to this selection department.

  That is, in ST3, the department master file 61 is searched to obtain the department code, department name, and uninventory processing classification code of the selected department. In ST4, the single item number counter A, the stocktaking number counter B, and the single stock number counter C prepared in advance are all reset to “0”. In ST5, the single product master file 62 is searched in order from the first record to search for a single product code belonging to the selected department. If the corresponding single product code is detected, the arithmetic processing unit 12 counts up the single product number counter A by “1” as ST8 (master single product number counting means).

  Also, in ST9, the inventory confirmation data file 64 is searched in order from the first record, and the execution date of the inventory confirmation condition is set as the inventory execution date, and whether the inventory confirmation data in which the single item code matches the corresponding single item code is stored. Judge whether or not. If it is stored, the stock count counter B is incremented by “1” in ST10 (inventory count single product count means).

  Further, as ST11, the inventory input data file 63 is searched in order from the first record, and the execution date of the inventory confirmation condition is set as the inventory execution date, and whether the inventory input data whose single product code matches the corresponding single product code is stored. Judge whether or not. If it is stored, the stock count counter C is incremented by "1" as ST12 (inventory input single product count means).

  When the single item master file 62 has been searched up to the last record, the arithmetic processing unit 12 calculates the uninvented single item number D by the following equation (1) as ST13 (uninventory single item number calculating means).

D = A− (B + C) (1)
In equation (1), A is the value of the single product counter, B is the value of the stock count counter, and C is the value of the single stock counter.

  Thereafter, the arithmetic processing unit 12 calculates from ST14 the department code and department name of the selected department, the individual product counter A, the stock count counter B, and the stock count counter C, and these counter values. The number D of uninventory single items is stored in the display buffer 16.

  Each time the arithmetic processing unit 12 selects one inventory department that is the inventory confirmation condition, the arithmetic processing unit 12 repeatedly executes the processes of ST3 to ST14 for the selected department. Then, if each process of ST3 to ST14 is executed for all the inventory departments specified in the inventory confirmation condition as ST15, the arithmetic processing unit 12 displays an inventory confirmation confirmation screen based on the data of the display buffer 16 as ST16. The display is output to the unit 30 (output means).

  One display example of the inventory confirmation screen is shown in FIG. As shown in the figure, on the inventory confirmation screen 70, for each department specified in the inventory confirmation condition, the master single item number A, the inventoried single item number B, the inventory input single item number C, the uninvented single item number D, and the uninventory processing classification A list 71 along with the code is displayed. In addition, an execution button 72 as a declaration means for declaring that the product inventory data is confirmed and a cancel button 73 for canceling the confirmation of the product inventory data are displayed.

  After displaying and outputting the inventory confirmation screen, the arithmetic processing unit 12 waits for either the cancel button 73 or the execution button 72 to be operated as ST17 and ST18. When it is detected that the execution button 72 is operated by an operation input from the operation input unit 20, the arithmetic processing unit 12 executes an inventory confirmation process as ST19. That is, all the inventory input data stored in the inventory input data file 63 is converted into inventory confirmation data and additionally registered in the inventory confirmation data file 64. Then, the data in the inventory input data file 63 is cleared. Further, the inventory confirmation number corresponding to the corresponding single item code in the single item master file 62 is updated to the current inventory number (confirmation processing means).

  After that, if the processing unit 12 deletes the inventory confirmation screen 70 from the display unit 30 in ST20, the present inventory confirmation operation is terminated.

  On the other hand, when the cancel button 73 is operated instead of the execution button 72 on the inventory confirmation screen 70, the arithmetic processing unit 12 displays the inventory confirmation screen 70 from the display unit 30 without executing the inventory confirmation processing. Erase and end the current inventory confirmation operation.

  In the present embodiment configured as described above, the inventory confirmation condition can be input by starting the inventory data processing program on the computer main body 10. Here, when the execution date (for example, November 2004) and the inventory confirmation condition of the inventory department (for example, department 10, 20, 30, 40) are input, the department master file 61, the single article master file 62, and the inventory input data file 63 are entered. For example, an inventory confirmation screen 70 shown in FIG. 7 is displayed on the display unit 30 by each data stored in the inventory confirmation data file 64.

  The operator knows the following from the master unit number A, the inventoried unit number B, the inventory input unit number C, the uninventory unit number D and the uninventory processing category displayed on the inventory confirmation screen 70. That is, the number of single items of products belonging to each department can be determined from the master single item number A. The number of single items for which the inventory has already been confirmed in the execution year among the products belonging to the division can be found from the number B of the single inventory completed. From the inventory input single item number C, it is possible to know the number of individual products for which the inventory has been entered for each department and the inventory data has been entered among the products belonging to that department. From the number of uninvented single items D, it is possible to know the number of single items of products that have not yet been invented in the execution year among the products belonging to that department for each department. From the uninventory processing category, it is possible to know a determination method for a product that is not inventoried among products belonging to the department for each department.

  Therefore, the operator can easily know that, for a department in which the number D of uninventory single items is not “0”, the inventory for the number D of uninventory single items among the products belonging to the department has not yet been performed. As a result, if the inventory is not confirmed, the cancel button 73 on the screen 70 may be operated by operating the mouse of the operation input unit 20, for example.

  In addition, if the number D of uninventoried items in all the inventory departments is “0”, it can be easily determined that there is no product forgotten to execute the inventory. In that case, the inventory confirmation process is executed by operating the execution button 72 of the screen 70.

  As described above, according to the present embodiment, it is possible to confirm the presence / absence of a product that has been forgotten to be executed prior to the inventory confirmation operation, so that it is possible to prevent the inventory confirmation operation from being performed again. In addition, after confirming the presence / absence of a product forgot to execute inventory from the inventory confirmation confirmation screen 70, the inventory confirmation processing can be executed by operating the execution button 72 displayed on the screen 70, so that the operability is good.

  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, in the above-described embodiment, the present invention has been described as a processing device for inventory data generated in an inventory operation at one store. However, a higher-level server formed by connecting store controllers of a plurality of stores online, for example, a headquarter server It is good also as an apparatus which gives the function of this invention and processes the inventory data which generate | occur | produced in the inventory business in a some store centrally. In this case, it is possible to configure such that a store code specifying one store is input as the inventory confirmation condition.

  In the above embodiment, the inventory confirmation confirmation screen 70 displays not only the uninvented single item number D but also the master single item number A, the inventoried single item number B, the inventory input single item number C, etc., but at least the uninvented single item number D The effect of the present invention can be achieved by displaying. Further, the output means is not limited to the display means, and for example, a printer may be connected to the computer main body 10 for printout.

  Further, the method for acquiring the sales quantity is not limited to the method for acquiring from the POS terminal 40, and the data input by the operation input unit 20 of the computer main body 10 is held in the data storage unit 14. May be.

  Also, the method of registering the inventory quantity is not limited to registration from the handy terminal 50, and the inventory input data input by the operation input unit 20 of the computer main body 10 is held in the inventory input data file 63. May be.

  In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, the constituent elements over different embodiments may be combined.

The block diagram which shows the principal part structure of the inventory data processing system in one embodiment of this invention. The schematic diagram which shows the example of a data structure of the department master file in FIG. The schematic diagram which shows the data structure example of the single item master file in FIG. The schematic diagram which shows the data structural example of the inventory input data file in FIG. The schematic diagram which shows the example of a data structure of the inventory confirmation data file in FIG. The flowchart which shows the process sequence at the time of the inventory data processing program start of the arithmetic processing part in FIG. The top view which shows an example of an inventory confirmation confirmation screen.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 10 ... Computer main body, 11 ... Communication interface part, 12 ... Arithmetic processing part, 13 ... Program storage part, 14 ... Data storage part, 15 ... Input / display control part, 16 ... Display buffer, 20 ... Operation input part, 30 ... Display unit 40 ... POS terminal 50 ... handy terminal 61 ... department master file 62 ... single item master file 63 ... inventory input data file 64 ... inventory confirmation data file 70 ... inventory confirmation confirmation screen

Claims (5)

In the inventory data processing device that takes in and confirms product inventory data such as the single product code and inventory quantity of the product that has been inventoried,
A single product master file in which the department to which the product belongs is set corresponding to the single product code of each product,
An inventory input data file for accumulating and storing the unconfirmed product inventory data;
An inventory confirmation data file for accumulating and storing the confirmed product inventory data;
Master single product number counting means for counting the number of single items belonging to the department classified by each category with reference to the data of the single item master file,
An inventory-completed single item counting means for counting the number of single-items that have been inventoried for products belonging to that department by the department with reference to the data of the inventory-confirmed data file;
Inventory input single item counting means for counting the number of single items for which the product inventory data has been input with reference to the data of the inventory input data file for the products belonging to the department for each department,
The number of single inventory items calculated by the inventory single item number counting means and the number of single inventory input items calculated by the inventory input single item counting means from the master single item number calculated by the inventory division single item number counting means for each department The uninventory single item number calculating means for subtracting and calculating the uninventory single item number,
An output means for outputting the number of uninventory single items for each department calculated by the uninventory single item number calculating means;
An inventory data processing apparatus comprising: A declarative declaration means for declaring finalization of product inventory data;
A confirmation processing unit for registering and confirming unconfirmed product inventory data stored in the inventory input data file in the inventory confirmation data file when the confirmation of the product inventory data is declared by the confirmation declaration unit; Equipped,
2. The inventory data processing apparatus according to claim 1, wherein the confirmation declaration unit is valid after the output unit outputs the number of unconfirmed single items by department. A display device;
The inventory data processing apparatus according to claim 2, wherein the output unit displays and outputs a list of the number of uninventoried single items by department on the display device.   4. The button for selecting whether or not to confirm the product inventory data is displayed on the screen of the departmental uninventory single product list displayed and output on the display device. Inventory data processing device. The single product master file in which the department to which the product belongs is set corresponding to the single product code of each product, and the undetermined product inventory data among the product inventory data such as the single product code and inventory quantity of the product that has been inventoried A computer capable of accessing an inventory input data file to be stored and stored and an inventory determination data file to store and store the confirmed product inventory data among the product inventory data;
A function for counting the number of single items belonging to the department for each division into which each product is classified with reference to the data of the single item master file;
A function for counting the number of single items that have been confirmed for inventory for products belonging to that department for each department by referring to the data of the inventory confirmation data file;
A function of counting the number of single items that have been entered in the product inventory data for the products belonging to that department for each department with reference to the data in the inventory input data file,
A function of calculating the number of uninvented single items by subtracting the number of inventoried single items and the number of inventory input single items from the number of master single items calculated for each department;
A function to output the number of uninvented single items by department calculated by this function,
Inventory data processing program to realize.

Images