JPH11345268A - Inventory management data processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To eliminate a count mistake about the current count quantity of stock and to perform reliable inventory management by discriminating a count mistake when the difference between correction current count quantity of stock and the current count quantity of stock is equal to or more than count mistake discrimination value and forming inventory management in an executable way when it is equal to or less than the discrimination value. SOLUTION: A CPU 21 subtracts the sum of a sales number and an abandonment number which are read from the current count quantity of stock which is selected and is in past and calculates a correction current count quantity of stock. And, when the difference between the calculated correction current count quantity of stock and the current count quantity of stock at the moment is equal to or more than set count mistake discrimination value, it is discriminated that there is a count mistake in the current count quantity of stock. On the other hand, when it is discriminated that a count mistake does not exist, the CPU 21 compares the current count quantity of stock at the moment with logical quantity of stock at the moment and performs inventory management. In such a case, the current count quantity of stock is stored in an inventory file 23Z.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to the present invention in which the number of theoretical stocks at a certain point in time is calculated from the number of sales and the number of discards in the period from the point in time to the present, and the number of theoretical stocks actually counted. The present invention relates to an inventory management data processing system formed so that inventory management can be performed by comparing the counted inventory number.

[0002]

2. Description of the Related Art The present theoretical stock quantity Ntn obtained from the theoretical stock quantity Nt at a certain point in time by using the sales quantity Ns and the discard quantity Nl in the period from the current time to the present time;
2. Description of the Related Art An inventory management data processing system formed so as to enable inventory management by comparing a current count inventory number Ncn of a product actually counted on a product display shelf or the like is known.

For example, when a stock controller is provided with a stock controller to collectively manage the terminals connected to a plurality of terminals (for example, electronic cash registers) so as to be able to perform data communication and a stock management data processing system is constructed. , The number of sales Ns at each terminal can be accurately received. Also,
The discard number Nl is input, for example, while confirming the product whose expiration date has passed, and its absolute number is small, so the number Nl is correctly input. Thus, the theoretical stock number N at that time
t is also accurate.

[0004]

However, the present counted number of stocks Ncn can be counted by using a large absolute number and when the store is idle, or by time-sharing work or sharing work by a plurality of people. Counting errors are likely to occur because of the unique circumstances of each case. Whether it is correct or not must be counted again. However, it is impossible in actual operation to repeatedly perform a counting operation with a large labor and time burden. Thus, it has been pointed out that the credibility of the conventional inventory management method is doubtful.

An object of the present invention is to provide an inventory management data processing system capable of performing highly reliable inventory management by eliminating count errors in the current count inventory.

[0006]

According to the first aspect of the present invention, there is provided a method according to the present invention, which comprises calculating the number of theoretical stocks at a certain point in time from the number of theoretical stocks at a certain point in time using the number of sales and the number of discards in the period from the point in time to the present. In an inventory management data processing system formed so as to enable inventory management by comparing the actually counted current count inventory number, each current count inventory number at each time point and each sales number and discard number at each time point are stored. The current and past countable inventory count is made selectable, and the sum of the sales count and the discarded count for the period from the current time to the present is subtracted from the selected past current count count and adjusted. The count inventory quantity is formed to be computable, and if the difference between the corrected current count inventory quantity and the current current count inventory quantity is greater than or equal to the set count error determination value, It is formed so that it can be determined that there has been a mistake, and the present stock management can be executed by comparing the current count stock number at the present time and the theoretical stock number at the present time when it is determined that there was no count mistake. Inventory management data processing system.

In this invention, the current count stock number at the present time is input. Then, a past current count stock necessary for correcting the current count stock is selected. Then, a corrected current count inventory number is calculated by subtracting the sum of the sales number and the discarded number in the period from the time point to the present time from the selected past current count inventory number.

Here, when the difference between the calculated corrected current count inventory number and the current current count inventory number is equal to or greater than the set count error determination value, it is determined that a count error has occurred. In other words, the corrected current inventory count is determined by introducing the principle of calculating the theoretical inventory count.
If the current count is correct, the current count stock number and the corrected current count stock number should be the same.

However, if there is a difference, it may be judged that there is a miscount in the current count inventory number. Therefore, the credibility of the inventory management executed using the current count inventory number for which it is unknown whether or not a count error has occurred is doubtful as in the conventional example. Thus, it should be recounted before performing inventory control. That is, count errors should be eliminated.

The set count error discrimination value can be set to, for example, "0" for a product with a small stock quantity and "2" for a product with a large stock quantity. An allowance is provided so as to avoid the occurrence of a loss that the time and labor required for the counting operation become larger than the actual profit if the value is always fixed strictly ("0"). That is, it is employed to expand operational adaptability.

[0011] When it is determined that there is no count error, the inventory management is executed by comparing the current counted inventory number with the current theoretical inventory number. So,
The credibility of inventory management results can be significantly increased. In other words, inventory management with high credibility can be performed by eliminating count errors in the current count inventory.

According to the invention of claim 2, the theoretical stock number at the present time obtained from the theoretical stock number at a certain point in time using the number of sales and the number of discards in the period from the present point to the present time is actually counted. In an inventory management data processing system formed so that inventory management can be performed by comparing the current count inventory number, an inventory file capable of storing the current count inventory number at each time point and each sales amount at each time point can be stored File, a discard file capable of storing the number of discards between each point in time, a selection means capable of selecting a past current count stock number, and a past current count stock selected by searching the sales file and the discard file. Reading means for reading the number of sales and discards in the period from the time corresponding to the number to the present, and sales data read from the selected past current count stock number. Current count inventory number calculation means for calculating the corrected current count inventory number by subtracting the sum of the number and the discarded number, and comparing the calculated corrected current count inventory number with the current current count inventory number and comparing the difference. Count error discriminating means for discriminating that there has been a count error when is greater than or equal to the set count error discrimination value, and present count inventory quantity and current theoretical stock quantity when it is determined that there was no count error. And an actual stock mismatch discriminating means for judging that the stock is not matched when the difference is equal to or greater than a set stock mismatch discrimination value.

In this invention, the current count stock number at the present time is input. Then, using the selection means, the past current count stock number necessary for correcting the current count stock number is selected from the past current count stock numbers stored in the stock file. However, the past current count inventory number stored in the inventory file is
For example, one before three days may be used.

[0014] Then, the reading means reads the sales file and the discard file, and reads the number of sales and the number of discards in the period from the time corresponding to the current count stock number selected in the past to the present time selected. Subsequently, the corrected current count stock quantity calculating means calculates the corrected current count stock quantity by subtracting the sum of the sales quantity and the discarded quantity read from the selected past current count stock quantity.

Here, when the difference between the calculated corrected current count inventory number and the current current count inventory number is equal to or greater than the set count error determination value, the count error determination means determines that the current count inventory count is equal to or smaller than the set count error determination value. It is determined that a count error has occurred. In other words, the corrected current inventory count is determined by introducing the principle of calculating the theoretical inventory count.
If the current count is correct, the current count inventory number and the corrected current count inventory number should be the same.

However, when there is a difference, it is determined that there is a miscount in the current count inventory. Therefore, the credibility of the inventory management executed using the currently counted inventory number, which may have caused a count error as in the conventional example, is doubtful. Thus, it should be recounted before performing inventory control.

The set count error discrimination value can be set to, for example, "0" for a product with a small stock quantity, and can be set to, for example, "2" for a product with a large stock quantity. An allowance is provided so as to avoid the occurrence of a loss in which the time and labor required for the counting work becomes larger than the actual profit if the value is always fixed strictly ("0"). That is,
Used to expand operational adaptability.

When it is determined by the count error determining means that there is no count error, the actual inventory mismatch determining means compares the current count inventory number with the current theoretical inventory number to execute inventory management. I do. In this way, the credibility of the result of inventory management can be significantly increased.

Therefore, it is possible to determine whether the count is correct or not at that time by simply selecting the past current count stock quantity by using the selection means, in addition to providing the same operation and effect as the case of the first aspect of the invention. Easy to handle.

The invention according to claim 3 is an inventory management data processing system provided with a list display control means for displaying a list of the current count stock numbers at each time point stored in the stock file on a display. It is.

[0021] In this invention, the list display control means displays a list of the current count stock numbers at each time point stored in the stock file on the display.

Therefore, in addition to providing the same operation and effect as in the case of the second aspect of the present invention, it is possible to consider the actual situation of operation such as considering the number of sales up to that point, You can select the current count of stock.

Further, the invention according to claim 4 is an inventory management data processing system which is formed so as to be able to display when a count error is determined by the count error determining means.

In this invention, when it is determined that the count error has occurred by the count error determining means, the fact is displayed. Therefore, in addition to providing the same operation and effect as in the case of the inventions of claims 2 and 3, the necessity of recounting can be quickly known.

Further, the invention of claim 5 is an inventory management data processing system which is formed so that each product can be listed up and printed out when the count error is determined by the count error determining means. is there.

In this invention, when it is determined that the count error has occurred by the count error determining means, each product is listed up and printed out. Therefore, in addition to providing the same operation and effect as in the inventions of claims 2 to 4, the necessity of recounting can be determined for each product, so that a quick counting operation can be performed on the product. Wasteful counting work can be eliminated.

Further, the invention according to claim 6 is an inventory management data processing system which is formed so as to be able to display when it is judged by the actual inventory mismatch discriminating means that there is a stock mismatch.

In this invention, when it is determined by the actual inventory mismatch determining means that the inventory does not match, that fact is displayed. Therefore, in addition to providing the same operational effects as in the inventions of claims 2 to 5, it is possible to further quickly determine an additional order or extend the order.

Further, according to a seventh aspect of the present invention, in the case where the actual stock mismatch discriminating means judges that the stocks do not match, the stock management data is formed so that each product can be listed up and printed out. It is a processing system.

In this invention, when it is determined that the stocks do not match by the actual stock mismatch determining means, each product is listed up and printed out. Therefore, in addition to providing the same operation and effect as in the case of the inventions of claims 2 to 6, it is possible to accurately examine each product with sufficient time.

[0031]

Embodiments of the present invention will be described below with reference to the drawings. The inventory management data processing system (20) is, as shown in FIG.
, Sales file 23S, discard file 23L, selection means (25), reading means (21, 22), corrected current count stock quantity calculation means (21, 22), and count error determination means (21, 22). ) And the actual inventory mismatch discriminating means (21, 22), and subtracts the sum of the number of sales Nst and the number of discards Nlt in the period from the current time to the present from the selected current count inventory Nco. The corrected current count stock number Ncnc is calculated so that it can be calculated. If the difference between the corrected current count stock number Ncnc and the current current count stock number Ncn is greater than or equal to the set count miss discrimination value (E1), a count error occurs. The current count stock number Ncn and the theoretical stock number Ntn at the present time when it is determined that there has been no error and it is determined that there is no count error are compared. To be running to be able to form an inventory management.

In FIG. 1, a store controller 20 constituting the inventory management data processing system includes a CPU 21
ROM 22, RAM 23, HDD 24, keyboard (K
B) An interface for a display (IND) 26 and a network (for example, a LAN) 1 including a display (IND) 26, a plurality of terminals (electronic cash registers) 10 can be collectively managed, and an inventory management function is provided.

In the RAM 23, a theoretical file 23T for storing the current theoretical stock quantity obtained from the theoretical stock quantity Nt at a certain point in time using the sales quantity Ns and the discard quantity Nl during the period from the current time to the present time. In addition to the above, there are four files required for executing the inventory management function according to the present invention, that is, the current count inventory number Nc at each time point.
File 23Z, which can store the number of sales Ns between each time, and a discard file 23L, which can store the number of discards Nl between each time. Backed up by

In this embodiment, the maintenance of each file is performed according to the procedures and procedures shown in FIGS. Input date using keyboard 25 (YE in ST10 of FIG. 2)
S) Then, when the current counted stock number Nc of each product actually counted on the product display shelf or the like is input (YES in ST11), the storage control means (CPU21, ROM22)
Stores the current count stock number Nc in the stock file 23Z in association with the date (ST12).

The input discard number Nl is stored in the discard file 23L (ST13, ST14). Terminal 1
The sales number Ns dated at 0 is stored in the sales file 23S when received from each terminal 10 (YES in ST16 of FIG. 4) (ST17).

Further, in the theoretical file 23T, a value (the theoretical stock quantity N
t) is stored as it is (ST20). However, the theoretical stock number Nt is updated (subtracted) every time the sales number Ns and the discard number Nl are stored thereafter (ST18, ST18).
ST15 in FIG. 2).

Here, when executing the stock management, the current count stock number Ncn at the present time is input (ST10 to ST12 in FIG. 2). This current count stock number Ncn
Is automatically selected as a correction target (Y in ST32 of FIG. 4).
ES).

Prior to this, in this embodiment, the list display control means (CPU 21, ROM 22) displays a list of the current count stock numbers Nc at each time point stored in the stock file 23Z on the display unit 26. (FIG. 4
ST30, ST31). Therefore, while taking into account, for example, the number of sales Ns up to that time, the selection unit (keyboard 25) is used to select the current count Ns.
One of the past current count stock numbers Nco required to correct cn is selected (YES in ST33).

Incidentally, the past current counted stock number Nc stored in the stock file 23Z may be, for example, one three days ago. In this case, an automatic selection method may be used.

Then, the reading means (CPU 21, ROM 2
2) The sales file 23S and the discard file 23L
Is searched, and the selected current count inventory number (N
co) The number of sales N in the period from the corresponding time to the present
The st and the discard number Nlt are read (ST34).

Subsequently, the corrected current count inventory number calculating means (CPU 21, ROM 22) reads the sales number Nst read from the selected past current count inventory number Nco.
And the sum (Nst + Nlt) of the discard number Nlt to calculate the corrected current count stock number Ncnc (ST
35). The corrected current count stock Ncnc is RA
It is temporarily stored in the work area of M23 (ST36).

Thus, the count error determining means (CPU
21, ROM 22) stores the calculated corrected current count stock number Ncnc and the current current count stock number Nc
If the difference from n is equal to or greater than the set count error determination value (E1), it is determined that the current count inventory number Ncn has a count error (YES in ST37 of FIG. 5).

The counting error discriminating means (21, 22)
If it is determined that a count error has occurred,
Count error display control means (CPU 21, ROM 22)
Is displayed on the display 26 (ST44). Therefore, the necessity of recounting can be quickly known.

Further, since each product having a count error is listed up and printed out (ST45) by operating a printer (not shown), a quick counting operation can be performed for each product, and a useless counting operation can be performed. Can be eliminated.

That is, the corrected current count stock number Ncnc
(For example, “245”) is obtained by introducing the principle of calculating the theoretical stock quantity Nt. Therefore, if the current count is correct, the current count stock quantity Ncn and the corrected current count stock quantity Ncnc are equal (““ 245 ").

However, the presence of the difference (for example, "3") means that the current count inventory number Ncn (for example, "242")
Alternatively, it is determined that a miscount has occurred in “258”). Therefore, the credibility of the inventory management executed by using the current count inventory number Ncn without knowing whether or not there is a count error as in the conventional example is doubtful. Thus, a recount operation should be performed before performing inventory control.

The set count error discrimination value E1 can be set to, for example, "0" for a product with a small stock quantity and "2" for a product with a large stock quantity. An allowance is provided so as to avoid the occurrence of a loss in which the time and labor required for the counting work becomes larger than the actual profit if the value is always fixed strictly ("0"). That is, it is employed to expand operational adaptability.

After re-entering the recounted current count inventory number Ncn, inventory management is started again (FIG. 4).
, It is determined that there is no count error (S in FIG. 5).
T37: NO).

Here, the count error determining means (2)
If it is determined that there is no count error by (1, 22) (NO in ST37), the actual stock mismatch discrimination means (CPU21, ROM22) uses the current count stock number Ncn at the present time and the theoretical stock number Ntn at the current time. Are compared (ST39) to execute inventory management. In this way, the credibility of the result of inventory management can be significantly increased.

In this case, the current count stock number Ncn
Is determined to be correct, that is, the current count stock number Nc without any count mistake, and is stored in the stock file 23Z (ST42, ST43).

In this embodiment, the actual inventory mismatch discrimination means (21, 22) sets the difference between the current count inventory number Ncn, which has been determined as having no count error, and the current theoretical inventory number Ntn. Actual inventory mismatch discrimination value (E
2) In the case where it is equal to or more than (ST39), it is formed so that it is possible to determine that there is a physical inventory mismatch. That is, as in the case of the count error determination (ST37), this is adopted for expanding the adaptability in operation. E2 may be “0”.

The actual inventory mismatch discriminating means (21, 21)
2) When it is determined that there is a stock mismatch (ST)
39), the inventory mismatch display control means (CPU2
1, the ROM 22) displays this on the display 26 (ST
40). Therefore, since there is no inventory error even though there is no count error, it is possible to promptly make a decision such as additional ordering or postponement of the order as a countermeasure.

Further, the actual inventory mismatch discriminating means (21, 21)
If it is determined by 2) that the stocks do not match, each product is listed up and a printer (not shown)
Prints out the list (ST41). Therefore, the examination for each product can be performed accurately with sufficient time.

[0054]

According to the first aspect of the present invention, the corrected current count stock number calculated by using the selected past current count stock number and the sales number and the discard number in the period up to the present time is calculated. If the difference from the current count inventory number is equal to or greater than the set count error discrimination value, it is possible to determine that there is a count error, and if it is determined that there is no count error, the current count inventory number and the current theoretical inventory Since the inventory management data processing system is formed so that inventory management can be executed by comparing the number with the number, it is possible to eliminate count errors in the current count inventory number and perform highly reliable inventory management.

According to the second aspect of the present invention, an inventory file, a sales file, a discard file, a selection unit, a reading unit, a corrected current count inventory number calculation unit,
A counting mistake discriminating means and a physical discrepancy discriminating discriminating means, and using the selected past current count stock number and the number of sales and discards in the period from the current time to the present, the corrected current count stock number; If the difference between the corrected current count inventory number and the current current count inventory number is equal to or greater than the set count error determination value, it is possible to determine that there is a count error, and if it is determined that there is no count error, Since the inventory management data processing system is formed so as to be able to execute inventory management by comparing the current count inventory number with the current theoretical inventory number, it is possible to achieve the same effect as the invention of claim 1. Of course, it is easy to handle since it is possible to determine whether the count at that time is correct or not by simply selecting the past current count stock quantity using the selection means.

According to the third aspect of the present invention, the current count stock number at each time point stored in the inventory file can be displayed on the display as a list. In addition to providing the same effect as in the above case, it is possible to select the past current count stock number in consideration of actual operational circumstances such as, for example, considering the number of sales until then.

According to the fourth aspect of the present invention, when it is determined that a count error has occurred, that fact is formed so as to be able to be displayed, so that it is the same as the second and third aspects of the present invention. In addition to the effect, the necessity of recounting can be quickly known.

Further, according to the fifth aspect of the present invention, when it is determined that a count error has occurred, each product can be listed up and printed out. In addition to the effect similar to that of the invention, the necessity of recounting can be determined for each product, so that a quick counting operation can be performed on the product, and a useless counting operation can be eliminated.

Further, according to the invention of claim 6, when it is determined that the stocks do not match, it is formed so as to be able to display that fact, so that it is the same as the inventions of claims 2 to 5 In addition to the above advantages, it is possible to quickly determine whether to place an additional order or extend the order.

Further, according to the invention of claim 7, when it is determined that the stocks do not match, the respective products are formed so as to be listed up and printed out. In addition to the effects similar to those of the inventions described above, it is possible to perform the examination for each product with a sufficient time and accurately.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a flowchart (1) for explaining a file maintenance operation.

FIG. 3 is a flowchart (2) for explaining a file maintenance operation.

FIG. 4 is a flowchart (1) for explaining an inventory management operation.

FIG. 5 is a flowchart (2) for explaining an inventory management operation.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 10 Terminal 20 Store controller (inventory management data processing system) 21 CPU (reading means, corrected current count stock number calculating means, count mistake determining means, actual stock mismatch determining means, list display control means) 22 ROM (reading means, corrected) Current RAM count calculating means, count error determining means, actual inventory mismatch determining means, list display controlling means) 23 RAM 23T theoretical file 23Z stock file 23S sales file 23L discard file 24 HDD 25 keyboard (selecting means) 26 display Nc Each current count stock number Ncn Current count stock number at the time Ncn Selected past current count stock number Ncnc Corrected current count stock number Ns Sales number Nl Discarded number Ntn Current theoretical stock number E1 Setting count misjudgment value E2 Setting actual Inventory Match discrimination value

Claims (7)

[Claims] The present invention compares a theoretical stock quantity at a present time obtained from a theoretical stock quantity at a certain point in time using the number of sales and the number of discards in a period from the present time to the present time with a current count stock quantity actually counted. In the inventory management data processing system that is configured to be able to manage inventory, the current count inventory number at each time point, the sales number and discard number between each time point can be stored, and the past current count inventory number can be selected In addition to the above, the sum of the number of sales and the number of discards in the period from the current time to the present is subtracted from the selected current count inventory number to form a corrected current count inventory number. If the difference between the corrected current count inventory number and the current current count inventory number is greater than or equal to the set count error determination value, it is now possible to determine that a count error has occurred. Together are made, the current count inventory and the current inventory management data processing system for comparing the theoretical inventory is executable to form said inventory management of the current when it is determined that the count mistake was not. 2. A comparison between the theoretical stock number at the present time obtained from the theoretical stock number at a certain point in time and the number of sales and discards in the period from the present point to the present time and the current count stock number actually counted. In the inventory management data processing system formed so as to be able to perform inventory management, a stock file capable of storing the current count inventory number at each time point, a sales file capable of storing each sales amount at each time point, File that can store the number of discards during the period, selection means that can select the past current count stock number, and a file from the time corresponding to the past current count stock number selected by searching the sales file and the discard file to the present. A reading means for reading the number of sales and discards during the period, and a sum of the number of sales and discards read from the selected past current count stock number. Means for calculating the corrected current count inventory number by calculating the corrected current count inventory quantity, and comparing the calculated corrected current count inventory quantity with the current current count inventory quantity and determining that the difference is greater than or equal to the set count error determination value. Count error discriminating means for discriminating that there was a count error in a certain case, and comparing the current count stock number at present and the theoretical stock number at present when no count error was discriminated, and setting the difference An inventory management data processing system provided with a practical inventory mismatch discriminating means for discriminating a stock mismatch when the difference is equal to or greater than a stock mismatch discrimination value. 3. The inventory management data processing system according to claim 2, further comprising: a list display control means for displaying a list of the current count inventory numbers at each time point stored in the inventory file on a display. 4. The inventory management data processing system according to claim 2, wherein when the count error determining means determines that a count error has occurred, the count error data is displayed. 5. The product according to claim 2, wherein each of the commodities can be listed up and printed out when the count error judging means judges that a count error has occurred. Inventory management data processing system described in. 6. The apparatus according to claim 2, wherein when the actual stock mismatch discrimination means determines that the stock is not matched, the fact is displayed so as to be displayed.
Inventory management data processing system described in section. 7. The product according to claim 2, wherein when the actual stock mismatch discriminating means judges that the stock does not match, the respective commodities can be listed up and printed out.
An inventory management data processing system according to any one of claims 1 to 6.