JP2020119116A - Inventory date determination program, inventory date determination device, and inventory date determination method - Google Patents

Abstract

A stocktaking date determination program, a stocktaking date determination device, and a stocktaking date determination method are provided, which are capable of suppressing discrepancies in inventory numbers at the time of settlement. [Solution] For each of a plurality of products, the number of products in stock on the first inventory date is used as an initial value, and the first inventory quantity reflecting the purchase and sales values of the products after the first inventory date is calculated, For each of the multiple products, the second inventory quantity reflecting the purchase and sales values of the product after the second inventory date, with the initial value of the inventory quantity of the product on the second inventory date after the first inventory date. is calculated, and for a product having a large difference between the first inventory quantity and the second inventory quantity among the plurality of products, a date closer to the settlement date for the plurality of products is determined as a candidate for the next and subsequent stocktaking dates. [Selection drawing] Fig. 14

Description

The present invention relates to an inventory date determination program, an inventory date determination device, and an inventory date determination method.

For example, in settlement of accounts conducted at retail stores and the like, it is required to minimize the difference between the logical inventory quantity and the actual inventory quantity at the time of settlement. For this reason, retail stores and the like generally carry out inventory of products on the same day as the settlement of accounts.

On the other hand, for example, when there are insufficient work resources for inventorying products or the number of inventory-targeted products is huge, it becomes difficult to inventory products on the same day as the closing of accounts. For this reason, retail stores and the like carry out inventory of products before the settlement of accounts, if necessary (for example, refer to Patent Documents 1 and 2).

JP 2002-366620 A JP, 11-134411, A

However, when the inventory of goods is performed before the settlement of accounts, there is a possibility that a difference (deviation) may occur between the logical inventory quantity and the actual inventory quantity at the time of settlement. For this reason, in retail stores such as the ones listed above, it is not possible to carry out inventory of merchandise before the settlement of accounts even if there are insufficient work resources or the number of merchandise to be inventoried is huge. There is.

Therefore, in one aspect, an object of the present invention is to provide an inventory date determination program, an inventory date determination device, and an inventory date determination method that are capable of suppressing a difference in the number of stocks at the time of settlement.

In one aspect of the embodiment, a first inventory reflecting the purchase and sales values of the product on and after the first inventory date with the stock number of products on the first inventory date as an initial value for each of the plurality of products. The stock quantity is calculated, and for each of the plurality of products, the stock quantity of the product on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales of the product after the second inventory date are performed. The second inventory quantity reflecting the value of is calculated, and for a product having a large difference between the first inventory quantity and the second inventory quantity of the plurality of products, a date closer to the closing date of the plurality of products. Causes the computer to execute the process of determining as a candidate for the next stocktaking date.

According to one aspect, it is possible to suppress the deviation of the inventory number at the time of settlement.

FIG. 1 is a diagram illustrating the configuration of the information processing system 10. FIG. 2 is a diagram illustrating a hardware configuration of the information processing device 1. FIG. 3 is a block diagram of functions of the information processing device 1. FIG. 4 is a flowchart illustrating an outline of the stocktaking date determination process according to the first embodiment. FIG. 5 is a flowchart illustrating details of the stocktaking date determination processing according to the first embodiment. FIG. 6 is a flowchart illustrating the details of the stocktaking date determination processing according to the first embodiment. FIG. 7 is a flowchart illustrating details of the stocktaking date determination processing according to the first embodiment. FIG. 8 is a flowchart illustrating the details of the stocktaking date determination process according to the first embodiment. FIG. 9 is a flowchart illustrating details of the stocktaking date determination processing according to the first embodiment. FIG. 10 is a flowchart illustrating the details of the stocktaking date determination process according to the first embodiment. FIG. 11 is a diagram illustrating a specific example of the inventory count 131, the logical inventory count 132, and the auxiliary inventory count 133. FIG. 12 is a diagram illustrating a specific example of the inventory count 131, the logical inventory count 132, and the auxiliary inventory count 133. FIG. 13 is a diagram illustrating a specific example of the inventory count 131, the logical inventory count 132, and the auxiliary inventory count 133. FIG. 14 is a diagram comparing a case where the management of the auxiliary inventory number 133 is not performed and a case where the management of the auxiliary inventory number 133 is performed. FIG. 15 is a diagram illustrating a specific example of the first adjustment day number information 134a. FIG. 16 is a diagram illustrating a specific example of the second adjustment day number information 134b. FIG. 17 is a diagram illustrating a specific example of the second adjustment day number information 134b. FIG. 18 is a diagram illustrating a specific example of the second adjustment day number information 134b. FIG. 19 is a diagram illustrating a specific example of the third adjusted days information 134c.

[Configuration of information processing system]
First, the configuration of the information processing system 10 will be described. FIG. 1 is a diagram illustrating the configuration of the information processing system 10.

The information processing system 10 illustrated in FIG. 1 includes an information processing device 1 and an operation terminal 3. The operation terminal 3 can access the information processing device 1 via the network NW.

The operation terminal 3 is, for example, one or more PCs (Personal Computers), and is a terminal that a person in charge of retail stores (hereinafter, also simply referred to as a person in charge) performs various operations on the information processing apparatus 1.

The information processing device 1 is, for example, one or more physical machines, and even when the inventory of goods is performed on the day before the settlement of accounts, the difference between the logical inventory number at the time of settlement and the actual inventory number is In order to suppress the occurrence of the above, a process of determining an inventory date for each product (hereinafter, also referred to as an inventory date determination process) is performed.

Specifically, for example, for each of a plurality of inventory target products, the information processing apparatus 1 sets the stock number of products on the first inventory date (for example, the last settlement date) as an initial value, and sets An inventory quantity (hereinafter, also referred to as a first inventory quantity or a logical inventory quantity) that reflects the purchase and sales values of the product is calculated. In addition, the information processing apparatus 1, for example, for each of the plurality of products to be inventoried, the number of products in stock on the second inventory date after the first inventory date (for example, the inventory date immediately before the last closing date). Is used as an initial value to calculate the stock quantity (hereinafter, also referred to as the second stock quantity or the auxiliary stock quantity) that reflects the purchase and sales values of the products after the second inventory date. Then, the information processing apparatus 1 determines a date closer to the settlement date as a candidate for the next stocktaking date for a product having a large difference between the calculated first inventory quantity and the second inventory quantity.

That is, the information processing device 1 according to the present embodiment manages two first stock quantities and second stock quantities, which are two logical stock quantities on different days. Then, the information processing device 1 identifies a product having a large difference between the first inventory quantity and the second inventory quantity as a commodity in which the difference between the logical inventory quantity and the actual inventory quantity is more likely to occur. After that, the information processing device 1 determines candidates for the stocktaking date of the specified product to be closer to the settlement date.

As a result, the information processing apparatus 1 can suppress the occurrence of the difference between the logical inventory quantity and the actual inventory quantity at the time of settlement. Therefore, the information processing device 1 can suppress the deviation of the stock number at the time of settlement.

[Hardware configuration of information processing system]
Next, the hardware configuration of the information processing system 10 will be described. FIG. 2 is a diagram illustrating a hardware configuration of the information processing device 1.

As shown in FIG. 2, the information processing device 1 includes a CPU 101 that is a processor, a memory 102, an external interface (I/O unit) 103, and a storage medium 104. The respective units are connected to each other via a bus 105.

The storage medium 104 has, for example, a program storage area (not shown) that stores a program 110 for performing the stocktaking date determination process. In addition, the storage medium 104 has, for example, a storage unit 130 (hereinafter, also referred to as an information storage area 130) that stores information used when performing the stocktaking date determination process. The storage medium 104 may be, for example, an HDD (Hard Disk Drive) or an SSD (Sokid State Drive).

The CPU 101 executes the program 110 loaded from the storage medium 104 into the memory 102 to perform the stocktaking date determination process.

The external interface 103 communicates with the operation terminal 3 via the network NW, for example.

[Functions of information processing system]
Next, the function of the information processing system 10 will be described. FIG. 3 is a block diagram of functions of the information processing device 1.

As shown in FIG. 3, the information processing apparatus 1 includes an information receiving unit 111, an information managing unit 112, a first information receiving unit 111, an information managing unit 112, and the like, by organically cooperating hardware such as the CPU 101 and the memory 102 with the program 110. Various functions including the 1 calculation unit 113, the second calculation unit 114, the candidate determination unit 115, and the information output unit 116 are realized.

Further, the information processing apparatus 1 stores, for example, as shown in FIG. 3, the inventory count 131, the logical inventory quantity 132, the auxiliary inventory quantity 133, and the adjusted days information 134 in the information storage area 130. The adjustment days information 134 includes first adjustment days information 134a, second adjustment days information 134b, and third adjustment days information 134c (hereinafter, also referred to as coefficient information 134c).

The information receiving unit 111 receives, for example, the inventory count 131 of each product input by the person in charge via the operation terminal 3. The inventory count 131 is, for example, information indicating the current inventory quantity of each product. That is, the information receiving unit 111 receives, for example, the inventory count 131 input by the person in charge when inventorying each product. In addition, the information receiving unit 111 receives, for example, the number of sales or the number of purchases of each product input by the person in charge via the operation terminal 3.

The information management unit 112 stores the inventory count 131 of each product received by the information reception unit 111 in the information storage area 130.

For each of the products, the first calculation unit 113 sets the inventory count 131 of the products on the first inventory date as an initial value, and the number of purchases and the number of sales received by the information reception unit 111 (for the products after the first inventory date). A logical inventory quantity 132 reflecting the purchase quantity and the sales quantity) is calculated. Then, the information management unit 112 stores the logical inventory quantity 132 stored by the first calculation unit 113 in the information storage area 130.

The second calculation unit 114 sets the inventory count 131 of products on the second inventory date after the first inventory date as an initial value for each of the products, and the purchase quantity and the sales quantity ( The number of attached stocks 133 that reflects the number of products purchased and the number of sales after the second inventory date is calculated. Then, the information management unit 112 stores the auxiliary inventory quantity 133 stored by the second calculation unit 114 in the information storage area 130.

The candidate determination unit 115 determines a date closer to the closing date as a candidate for the next stocktaking date for a product having a large difference between the logical inventory number 132 and the auxiliary inventory number 133 stored in the information storage area 130.

The information output unit 116 outputs the candidates for the next and subsequent stocktaking dates determined by the candidate determination unit 115. Specifically, the information output unit 116 outputs, to the operation terminal 3, candidates for the next and subsequent stocktaking dates determined by the candidate determination unit 115, for example. The adjustment number information 134 will be described later.

[Outline of First Embodiment]
Next, the outline of the first embodiment will be described. FIG. 4 is a flowchart illustrating an outline of the stocktaking date determination process according to the first embodiment.

As shown in FIG. 4, the information processing device 1 waits until the stocktaking date determination timing (NO in S1). The stocktaking date determination timing may be, for example, the timing at which the person in charge makes an input to start the stocktaking date determination processing via the operation terminal 3.

Then, when the inventory date determination timing comes (YES in S1), the information processing apparatus 1 sets the inventory count 131 of the products on the first inventory date as an initial value for each of the plurality of products, and sets the count after the first inventory date. A logical inventory quantity 132 reflecting the purchase and sales values of the products is calculated (S2).

Further, in this case, the information processing apparatus 1 reflects the purchase and sales values of the product after the second inventory date with the inventory count 131 of the products on the second inventory date as an initial value for each of the plurality of products. The auxiliary stock quantity 133 is calculated (S3).

Then, the information processing apparatus 1 sets a date closer to the closing date of a plurality of products for a product having a large difference between the logical inventory number 132 and the auxiliary inventory number 133 of the plurality of items as a candidate for the next inventory date. (S4).

As a result, the information processing apparatus 1 can suppress the occurrence of the difference between the logical inventory quantity and the actual inventory quantity at the time of settlement. Therefore, the information processing device 1 can suppress the deviation of the stock number at the time of settlement.

[Details of First Embodiment]
Next, details of the first embodiment will be described. 5 to 10 are flowcharts illustrating the details of the stocktaking date determination process according to the first embodiment. Further, FIG. 11 to FIG. 19 are diagrams for explaining the details of the stocktaking date determination processing in the first embodiment.

[Information storage processing]
First, a process of accumulating information input by a person in charge via the operation terminal 3 (hereinafter, also referred to as information accumulating process) will be described. FIG. 5 is a flowchart illustrating the information storage process.

As shown in FIG. 5, the information receiving unit 111 of the information processing device 1 waits until, for example, various information input by a person in charge via the operation terminal 3 is received (NO in S101). Specifically, the information receiving unit 111 waits, for example, until it receives any of the inventory count 131, the purchase count, the sales count, and the correction count (correction count for the past purchase count or sales count) of each product.

Then, when the information is received from the operation terminal 3 (YES in S101), the information management unit 112 stores the information received in the process of S101 in the information storage area 130 (S102).

[Information generation processing]
Next, a process of calculating the logical inventory number 132 and the auxiliary inventory number 133 (hereinafter, also referred to as information generation process) will be described. FIG. 6 is a flowchart illustrating the information generation process.

As shown in FIG. 6, the information receiving unit 111 waits until the information generation timing (NO in S111). The information generation timing may be a regular timing such as once a day.

Then, when the information generation timing has come (YES in S111), the first calculation unit 113 of the information processing device 1 refers to the various information stored in the information storage area 130, and determines the first information for each of the plurality of products. The logical inventory quantity 132 is calculated when the inventory quantity 131 of goods on one inventory day is used as an initial value (S112).

Specifically, the information management unit 112, for example, purchases the number of products, the number of sales, and the number of revisions of each product received in the process of S101 performed today (the number of purchases and the number of sales that occurred after the first inventory date). (The number of corrections for each item) is reflected in the logical inventory number 132 of each product calculated in the process of S112 performed yesterday, thereby calculating the logical inventory number 132 of each product.

Further, in this case, the second calculation unit 114 of the information processing device 1 refers to the various information stored in the information storage area 130, and for each of the plurality of products, the inventory count 131 of the products on the second stocktaking date. The auxiliary stock quantity 133 when the initial value is set is calculated (S113).

Specifically, the information management unit 112, for example, purchases the number of products, the number of sales, and the number of revisions of each product received in the process of S101 performed today (the number of purchases and the number of sales that occurred after the second inventory date). (The number of corrections for each item) is reflected on the associated inventory number 133 of each product calculated in the process of S112 performed yesterday to calculate the associated inventory number 133 of each product.

That is, the information management unit 112 reflects the number of corrections to the number of purchases and the number of sales that occurred between the first inventory date and the second inventory date only when the logical inventory number 132 is calculated.

As a result, the information management unit 112 sets the current logical inventory quantity (logical inventory quantity 132) when the inventory quantity 131 of goods on the first inventory day is set as the initial value, and the second inventory quantity after the first inventory day. It is possible to respectively calculate the current logical inventory quantity (supplementary inventory quantity 133) when the inventory count 131 of products for each day is set as an initial value.

After that, the information management unit 112 stores the logical inventory quantity 132 calculated in the process of S112 and the auxiliary inventory quantity 133 calculated in the process of S113 in the information storage area 130 (S114). Hereinafter, a specific example of the inventory count 131, the logical inventory quantity 132, and the auxiliary inventory quantity 133 stored in the information storage area 130 will be described.

[Specific examples of inventory count, logical inventory quantity and auxiliary inventory quantity]
11 to 13 are diagrams illustrating specific examples of the inventory count 131, the logical inventory count 132, and the auxiliary inventory count 133. Specifically, FIG. 11 is a diagram illustrating the product A, FIG. 12 is a diagram illustrating the product B, and FIG. 13 is a diagram illustrating the product C.

The information shown in FIG. 11 includes the “date” in which the date is stored, the “logical inventory” in which the logical inventory quantity 132 is stored, the “inventory” in which the inventory quantity 131 is stored, and the auxiliary inventory quantity 133. The item has “stored inventory” stored therein. Further, the information shown in FIG. 11 and the like has “excess/shortage” as an item in which a value calculated by subtracting the value stored in “logical inventory” from the value stored in “auxiliary inventory” is stored. Have. Note that the following description will be made assuming that the settlement date is February 28.

First, a specific example of the product A will be described.

For example, the number of purchases, sales, and revisions of product A that occurred on February 20 are reflected in the logical inventory number 132 of product A as of February 19 at 100 (pieces). In this case, as shown in FIG. 11, the information management unit 112 sets “100 (pieces)” in the “logical inventory” of the information (the information on the second line) in which “2/20” is stored in the “date”. Remember. Then, for example, when the inventory of the product A is not yet performed as of February 20, the information management unit 112 determines that “inventory” and “attachment” of the information in which “2/20” is stored in the “date”. "-" indicating that there is no information is stored in "inventory" and "insufficient".

Next, for example, the number of purchases, sales, and revisions of the product A that occurred on February 22 are reflected in the logical inventory quantity 132 of the product A as of February 21 as 95 (pieces). ), the information management unit 112 stores “100 (pieces)” in the “logical inventory” of the information in which “2/22” is stored in the “date” (information in the fourth row). Then, for example, when the inventory of the product A is performed on February 22, the information management unit 112 sets the inventory count of the product A in the “inventory” of the information in which “2/20” is stored in the “date”. "115 (pieces)" which is 131 is stored. Further, in this case, the information management unit 112 sets the inventory count 131 of the product A (the same number as the number stored in “inventory”) in the “auxiliary inventory” of the information in which “2/20” is stored in the “date”. ) Is stored, and “+20 (pieces)” is stored in “excess/shortage”.

That is, when the inventory of the product A is performed, the information management unit 112 starts the management of the auxiliary inventory number 133 of the product A in addition to the management of the logical inventory number 132 of the product A.

Subsequently, for example, the number of purchases, sales, and revisions of the product A that occurred on February 25 are reflected in the logical inventory number 132 of the product A as of February 24, which is 113 (pieces). ), the information management unit 112 stores “113 (pieces)” in the “logical inventory” of the information (7th row) in which “2/25” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of revisions of the product A that occurred on February 25 (only the number of purchases and the number of revisions to the number of sales that occurred after the inventory date) are as of February 24. When the number reflected in the auxiliary inventory number 133 of the product A is 130 (pieces), the information management unit 112 adds “2/25” in the “date” to the “logical inventory” in the “logical inventory”. 130 (pieces)" is stored. Further, in this case, the information management unit 112 stores “−” in “inventory” of information in which “2/25” is stored in “date” and “+17 (pieces)” in “excess/shortage”. To do.

Here, the "logical inventory" of the information whose "date" is "2/24" and the "logical inventory" of the information whose "date" is "2/25" are different values (110 (pieces)). And 113 (pieces) are stored, the “supported inventory” of the information whose “date” is “2/24” and the “supported inventory” of the information whose “date” is “2/25” are stored. "Inventory" stores the same value (130 (pieces)). Therefore, in this case, different values (+20 (+20) for the “excess/shortage” of the information whose “date” is “2/24” and the “excess/shortage” of the information whose “date” is “2/25”, respectively. (Pieces) and +17 (pieces)) are stored.

That is, when a correction is made to the number of purchases or the number of sales of the product A that occurs before the stocktaking date, the information management unit 112 reflects the correction only to the logical inventory number 132.

Subsequently, for example, the number of purchases, sales, and revisions of the product A that occurred on February 28 are reflected in the logical inventory number 132 of the product A as of February 27 to be 105 (pieces). ), the information management unit 112 stores “105 (pieces)” in the “logical inventory” of the information (the 10th line) in which “2/28” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of revisions of the product A that occurred on February 28 (only the number of purchases and the number of revisions to the number of sales that occurred after the stocktaking date) are as of February 27. If the number of items A reflected in the supplemental inventory number 133 of the product A is 120 (pieces), the information management unit 112 adds the information of “2/28” to the “date” to the “attached inventory”. “120 (pieces)” is stored. Further, in this case, the information management unit 112 stores “−” in “inventory” of the information in which “2/28” is stored in “date” and “+15 (pieces)” in “excess/shortage”. To do.

Here, while “+20 (pieces)” is stored in “excess/shortage” of the information corresponding to the stocktaking date of the product A (information in which “2/22” is stored in “date”), "+15 (pieces)" is stored in "excess/shortage" of the information corresponding to the day (information in which "2/28" is stored in "date").

In other words, the information management unit 112 manages not only the logical inventory quantity 132 but also the auxiliary inventory quantity 133, so that the information management section 112 can manage the correction that occurs between the stocktaking date and the closing date of each product. It will be possible. Descriptions of other information included in FIG. 11 are omitted.

Next, a specific example of the product B will be described.

For example, the number of purchases, sales, and revisions of product B that occurred on February 20 are reflected in the logical inventory quantity 132 of product A as of February 19 at 2800 (pieces). 12, the information management unit 112 sets “2800 (pieces)” to the “logical inventory” of the information (the information on the second line) in which “2/20” is stored in the “date”, as shown in FIG. Remember. Then, for example, when the inventory of the product B has not been performed as of February 20, the information management unit 112 determines that “inventory” and “attachment” of information in which “2/20” is stored in “date”. "-" indicating that there is no information is stored in "inventory" and "insufficient".

Then, for example, the number of purchases, sales, and revisions of the product B that occurred on February 25 are reflected in the logical inventory quantity 132 of the product B as of February 24 as 2700 (pieces). ), the information management unit 112 stores “2700 (pieces)” in the “logical inventory” of the information (the information on the seventh line) in which “2/25” is stored in the “date”. Then, for example, when the inventory of the product B is performed on February 25, the information management unit 112 sets the inventory count 131 of the product B in the “inventory” of the information in which “2/25” is stored in the “date”. “2900 (pieces)” is stored. Further, in this case, the information management unit 112 sets the inventory count 131 of the product B (the same number as the number stored in the “inventory”) in the “attached inventory” of the information in which “2/25” is stored in the “date”. ) Is stored as "2900 (pieces)" and "+200 (pieces)" is stored as "excess/shortage".

Then, for example, the number of purchases, sales, and revisions of the product B that occurred on February 28 are reflected in the logical inventory quantity 132 of the product B as of February 27 as 2850 (pieces). ), the information management unit 112 stores “2850 (pieces)” in the “logical inventory” of the information (information on the 10th line) in which “2/28” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of revisions of the product B that occurred on February 28 (only the number of revisions to the number of purchases and the number of sales that occurred after the stocktaking date) are as of February 27. If the number of items B reflected in the supplementary inventory number 133 of the product B is 3000 (pieces), the information management unit 112 adds the information of “2/28” in the “date” to the “attached inventory”. “3000 (pieces)” is stored. Further, in this case, the information management unit 112 stores “−” in “inventory” of the information in which “2/28” is stored in “date” and “+150 (pieces)” in “excess/shortage”. To do.

Next, a specific example of the product C will be described.

For example, the number of purchases, sales, and revisions of product C that occurred on February 20 are reflected in the logical inventory number 132 of product C as of February 19 at 900 (pieces). In this case, the information management unit 112 sets "900 (pieces)" to the "logical inventory" of the information (the information on the second line) in which "2/20" is stored in the "date" as shown in FIG. Remember. Then, for example, when the inventory of the product C has not been performed as of February 20, the information management unit 112 determines that “inventory” and “attachment” of information in which “2/20” is stored in “date”. "-" indicating that there is no information is stored in "inventory" and "insufficient".

Subsequently, for example, the number of purchases, sales, and revisions of the product C that occurred on February 23 are reflected in the logical inventory number 132 of the product C as of February 22 as 950 (pieces). ), the information management unit 112 stores “950 (pieces)” in the “logical inventory” of the information (information in the fifth line) in which “2/23” is stored in the “date”. Then, for example, when the inventory of the product B is performed on February 23, the information management unit 112 sets the inventory count 131 of the product C in the “inventory” of the information in which “2/23” is stored in the “date”. “960 (pieces)” is stored. Further, in this case, the information management unit 112 sets the inventory count 131 of the product C (the same number as the number stored in “inventory”) in the “attached inventory” of the information in which “2/23” is stored in the “date”. ) Is stored, and “-10 (pieces)” is stored in “excess/shortage”.

Subsequently, for example, the number of purchases, sales, and revisions of the product C that occurred on February 28 are reflected in the logical inventory number 132 of the product B as of February 27, and the number is 935 (pieces). If there is, the information management unit 112 stores “935 (pieces)” in the “logical inventory” of the information (information on the 10th line) in which “2/28” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of revisions of the product C that occurred on February 28 (only the number of purchases and the number of revisions to the number of sales that occurred after the stocktaking date) are as of February 27. When the number of items C reflected in the supplemental inventory number 133 of the product C is 940 (pieces), the information management unit 112 sets the “date” to “the supplementary inventory” of the information in which “2/28” is stored. “940 (pieces)” is stored. Further, in this case, the information management unit 112 stores "-" in "inventory" of the information in which "2/28" is stored in "date" and "-5 (pieces)" in "excess/shortage". Remember.

[Specific example when the number of auxiliary stock is not managed]
Next, a specific example in which the management of the number of auxiliary stocks 133 is not performed will be described. FIG. 14 is a diagram comparing a case where the management of the auxiliary inventory number 133 is not performed and a case where the management of the auxiliary inventory number 133 is performed. Specifically, FIG. 14(A) is a diagram for explaining a specific example in the case where the management of the number of associated inventory 133 is not performed, and FIG. 14(B) is the case of managing the number of associated inventory 133. It is a figure explaining a specific example. The specific example shown in FIG. 14B has the same contents as the specific example described with reference to FIG.

The information illustrated in FIG. 14A includes items other than “attached inventory” among the items included in the information described in FIG. 11. Further, as the “excess/shortage” in the information shown in FIG. 14A, a value calculated by subtracting the value stored in “logical inventory” from the value stored in “inventory” is stored.

Specifically, the same values as the information described in FIG. 11 are stored in “date”, “logical inventory”, and “inventory” in the information shown in FIG. In the information illustrated in FIG. 14A, “+20 (pieces)” is stored in the “excess/shortage” of the information whose “date” is “2/22”.

Therefore, in this case, the information processing apparatus 1 determines, as the difference between the inventory quantity 131 and the logical inventory quantity 132 on the settlement date (February 28), for example, the “overage” of the information whose “date” is “2/22”. "+20 (pieces)" which is the information stored in "insufficient" is specified.

On the other hand, in the case of the example illustrated in FIG. 14B (in the case of the example illustrated in FIG. 11 ), the information processing apparatus 1 determines the difference between the inventory count 131 and the logical inventory count 132 on the settlement date (February 28). As an example, it is possible to specify "+15 (pieces)" which is the information stored in the "excess/shortage" of the information whose "date" is "2/28".

That is, the information processing apparatus 1 manages not only the logical inventory quantity 132 but also the auxiliary inventory quantity 133, so that even if the inventory of goods is performed before the closing of accounts, the logical inventory at the time of closing of accounts is completed. It is possible to suppress the occurrence of the gap between the number 132 and the actual inventory number.

[Details of stocktaking date determination processing]
Next, the details of the stocktaking date determination process will be described. 7 to 10 are flowcharts illustrating the details of the stocktaking date determination process.

As shown in FIG. 7, the information receiving unit 111 waits until the stocktaking date determination timing (NO in S11).

Then, when the stocktaking date determination timing has come (YES in S11), the candidate determination unit 115 of the information processing device 1 has the logical inventory quantity 132 and the auxiliary inventory stored in the information storage area 130 for each of the plurality of products. The difference from the number 133 is calculated (S12).

Specifically, in the information shown in FIG. 11, the information in which “2/28” which is the closing date is stored in the “date” (information in the 10th line) is “+15 (day)” as “excess/shortage”. Is remembered. Therefore, the candidate determination unit 115 refers to the information shown in FIG. 11, for example, and specifies “+15 (days)” as the difference between the products A. Similarly, the candidate determination unit 115 refers to the information shown in FIGS. 12 and 13, for example, and specifies “+150 (days)” and “−5 (days)” as the difference between the products B and C, respectively.

Then, the candidate determination part 115 calculates the sum total of the absolute value of the difference calculated by the process of S12 (S13).

Specifically, the candidate determination unit 115 is the sum total of the absolute values of “+15 (day)”, “+150 (day)”, and “−5 (day)” which are the differences between the products A, B and C, “170”. (Day)" is calculated.

Next, the candidate determination unit 115 calculates the ratio of the absolute value of the difference calculated in the process of S12 to the sum calculated in the process of S13 for each of the plurality of products (S14).

Specifically, the candidate determination unit 115 divides each of “15 (day)”, “150 (day)”, and “5 (day)” by “170 (day)” to obtain the product A, for example. "9(%)" is calculated as the ratio (approximate value), "88(%)" is calculated as the ratio (approximate value) of product B, and "3(%)" is calculated as the ratio (approximate value) of product C To calculate.

Then, the candidate determination unit 115 calculates the difference in the number of days between the second inventory date and the settlement date for each of the plurality of products (S15).

Specifically, the information shown in FIG. 11 indicates that the stocktaking date of the product A (the stocktaking date immediately before the closing date) is February 22, and the closing date of retail stores is February 28. There is. Therefore, the candidate determination unit 115 refers to the information shown in FIG. 11, for example, and calculates 6 days as the difference in the number of days of the product A. Similarly, the candidate determination unit 115 refers to the information shown in FIGS. 12 and 13, for example, and calculates 3 days and 5 days as the difference in the number of days of the product B and the product C, respectively.

Further, the candidate determination unit 115 determines the inventory date candidate for each of the plurality of products based on the difference calculated in the process of S14 and the number of days calculated in the process of S15 (S16). The details of the process of S16 will be described below.

[Details of processing in S16 (1)]
FIG. 9 is a flowchart illustrating details of the process of S16.

As shown in FIG. 9, the candidate determination unit 115 refers to the first adjustment day number information 134a stored in the information storage area 130, and for each of the plurality of products, the first adjustment date corresponding to the ratio calculated in the process of S14. The number of adjustment days is specified (S41). The first adjusted days information 134a is information in which the ratio calculated in the process of S14 and the adjusted days of the stocktaking date are associated with each other, and is, for example, information stored in advance in the information storage area 130 by the person in charge. Hereinafter, a specific example of the first adjustment day number information 134a will be described.

[Specific example of the first adjustment days information]
FIG. 15 is a diagram illustrating a specific example of the first adjustment day number information 134a.

The first adjusted days information 134a illustrated in FIG. 15 includes “item number” for identifying each piece of information, “ratio lower limit” for storing the lower limit of the ratio, “percent upper limit” for storing the upper limit of the ratio, and inventory. The item has “adjustment days” in which the number of adjustment days is stored.

Specifically, in the first adjustment days information 134a shown in FIG. 15, “0 (%)” is stored as the “ratio lower limit” and “0” as the “ratio upper limit” in the information whose “item number” is “1”. “5 (%)” is stored, and “0 (day)” is stored as the “adjustment days”.

In addition, in the first adjustment days information 134a illustrated in FIG. 15, “6 (%)” is stored as the “ratio lower limit” and “10” as the “ratio upper limit” in the information whose “item number” is “2”. (%)" is stored, and "1 (days)" is stored as the "adjustment days". Descriptions of other information included in FIG. 15 are omitted.

Therefore, for example, when “9(%)” is calculated as the ratio of the product A in the process of S14, the candidate determination unit 115 uses the “adjustment” of the information whose “item number” is “2” in the process of S41. "1 (day)" which is the information stored in "number of days" is specified.

Subsequently, the candidate determination unit 115 refers to the second adjusted days information 134b stored in the information storage area 130, and specifies the second adjusted days corresponding to the attribute of each retail store or the like for each of the plurality of products. (S42). The second adjusted days information 134b is information in which attributes such as retail points are associated with adjusted days of the stocktaking date, and is, for example, information stored in advance in the information storage area 130 by a person in charge. Hereinafter, a specific example of the second adjustment day number information 134b will be described.

[Specific example of second adjustment days information]
16 to 18 are diagrams illustrating specific examples of the second adjustment day number information 134b. The candidate determination unit 115 performs the process with reference to, for example, any of the second adjustment day number information 134b illustrated in FIGS. 16 to 18.

First, a specific example of the second adjusted days information 134b shown in FIG. 16 will be described.

The second adjustment day number information 134b illustrated in FIG. 16 stores “item number” identifying each piece of information, “area lower limit” in which the lower limit of the area of retail stores and the like is stored, and upper limit of the area of retail stores and the like. The items include an “area upper limit” and a “adjustment days” in which the adjustment days of the stocktaking date are stored. In the following description, "-" is stored in the column where no restriction is set.

Specifically, in the second adjustment days information 134b shown in FIG. 16, “1 (m ² )” is stored as the “area lower limit” in the information whose “item number” is “1”, and the “area upper limit” is stored. “10 (m ² )” is stored as, and “−1 (day)” is stored as “adjustment days”.

Further, in the second adjustment days information 134b shown in FIG. 16, “11 (m ² )” is stored as the “area lower limit” and “area upper limit” is stored in the information whose “item number” is “2”. “30 (m ² )” is stored, and “0 (day)” is stored as the “adjustment days”. Descriptions of other information included in FIG. 16 are omitted.

Therefore, for example, when the area of a retail store or the like is 40 (m ² ), the candidate determination unit 115 is stored in the “adjustment days” of the information whose “item number” is “3” in the process of S42. Information "1 (day)" is specified.

Next, a specific example of the second adjusted days information 134b shown in FIG. 17 will be described.

The second adjusted days information 134b shown in FIG. 17 includes “item number” identifying each piece of information, “commodity number lower limit” in which the lower limit of the number of products sold at retail stores and the like is stored, and sales at retail stores and the like. The items include an “upper limit of the number of products” in which the upper limit of the number of products to be stored is stored, and a “number of adjustment days” in which the number of adjustment days for the stocktaking date is stored.

Specifically, in the second adjusted days information 134b illustrated in FIG. 17, “1 (piece)” is stored as the “commodity number lower limit” in the information in which the “item number” is “1”, and the “commodity number upper limit” is stored. “1000 (pieces)” is stored as “”, and “−1 (day)” is stored as “adjustment days”.

Further, in the second adjusted days information 134b shown in FIG. 17, “1001 (pieces)” is stored as the “commodity number lower limit” and “product number upper limit” is stored in the information whose “item number” is “2”. “5000 (pieces)” is stored, and “0 (days)” is stored as the “adjustment days”. Descriptions of other information included in FIG. 17 are omitted.

Therefore, for example, when the number of products sold at a retail store or the like is 2000 (pieces), the candidate determination unit 115 sets the “number of adjustment days” of the information whose “item number” is “2” in the process of S42. The stored information “0 (day)” is specified.

Next, a specific example of the second adjusted days information 134b shown in FIG. 18 will be described.

The second adjusted days information 134b illustrated in FIG. 18 stores “item number” for identifying each piece of information, “upper limit of number of persons who stores the upper limit of the number of persons who carry out inventory work, and lower limit of the number of persons who perform inventory work. The items are a “lower limit of the number of people” and a “adjusted number of days” in which the adjusted number of days of inventory is stored.

Specifically, in the second adjusted days information 134b illustrated in FIG. 18, "-" is stored as the "upper limit of the number of people" and "11 (the lower limit of the number of people)" is stored in the information in which the "item number" is "1". “Person)” is stored, and “−1 (days)” is stored as the “adjustment days”.

In addition, in the second adjusted days information 134b illustrated in FIG. 18, “6 (person)” is stored as the “upper limit of the number” and “10” is set as the “lower limit of the number” in the information whose “item number” is “2”. (Person)" is stored, and "0 (day)" is stored as the "adjustment days". Descriptions of other information included in FIG. 18 are omitted.

Therefore, for example, when the number of persons who perform the stocktaking work is 20, the candidate determination unit 115 is the information stored in the “adjustment days” of the information whose “item number” is “1” in the process of S42. "-1 (day)" is specified.

Returning to FIG. 9, the candidate determination unit 115, for each of the plurality of products, with respect to the difference in the number of days calculated in the process of S15, the first adjustment days specified in the process of S41 and the second adjusted days specified in the process of S42. The day when the adjustment with the number of adjustment days is performed is determined as a candidate for the stocktaking date (S43).

Specifically, for example, the difference in the number of days calculated in the process of S15 is "6 (days)", the first adjusted number of days of the product A specified in the process of S41 is "2 (days)", and S42. When the second adjustment days of the product A specified by the process of No. 1 is “−1 (day)”, the candidate determination unit 115 determines from “6 (Sun)” to “2 (Sun)” and “−1 (Day)”. )” is calculated to calculate “5 (day)”. Then, the candidate determination unit 115 determines candidates for the inventory date of the product A before "5 (Sun)" of the next settlement date.

That is, in this case, the candidate determination unit 115 makes the candidates for the stocktaking date closer to the next closing date as the products having the larger difference between the logical inventory number 132 and the auxiliary inventory number 133 on the previous closing date. decide. Further, the candidate determination unit 115 further adjusts the candidates for the stocktaking date based on the amount of labor required for stocktaking (area of the retail store, products sold at the retail store, the number of people performing the stocktaking work, and the like).

As a result, the information processing apparatus 1 can suppress the occurrence of the difference between the logical inventory quantity and the actual inventory quantity at the time of settlement. Therefore, the information processing device 1 can suppress the deviation of the stock number at the time of settlement.

[Details of S16 Process (2)]
FIG. 10 is a flowchart illustrating the details of the process of S16. The process of S16 shown in FIG. 10 is a process different in content from the process of S16 described in FIG.

As shown in FIG. 10, the candidate determination unit 115 refers to the third adjusted day number information 134c stored in the information storage area 130, and determines the coefficient corresponding to the difference calculated in the process of S15 for each of the plurality of products. Specify (S51). The third adjustment day number information 134c is information in which the difference calculated in the process of S15 is associated with the coefficient used for adjusting the stocktaking date, and is, for example, information stored in advance in the information storage area 130 by the person in charge. is there. Hereinafter, a specific example of the third adjusted days information 134c will be described.

[Specific example of third adjustment days information]
FIG. 19 is a diagram illustrating a specific example of the third adjusted days information 134c.

The third adjusted days information 134c shown in FIG. 19 includes “item number” for identifying each piece of information, “days difference” in which the difference in days calculated in the process of S15 is stored, and a coefficient used for adjustment of the stocktaking date. Is stored as a “coefficient”.

Specifically, in the third adjusted number-of-days information 134c illustrated in FIG. 19, “0 (day)” is stored as the “number of days difference” and “coefficient” is set as “coefficient” in the information whose “item number” is “1”. 1.5” is stored.

In addition, in the third adjusted days information 134c illustrated in FIG. 19, “1 (day)” is stored as the “difference in days” and “1. 4” is stored.

Further, in the third adjusted days information 134c shown in FIG. 19, “5 (days) or more” is stored as the “number of days difference” in the information whose “item number” is “6”, and “1” is stored as the “coefficient”. . 0” is stored. Description of other information included in FIG. 19 is omitted.

Therefore, for example, when “6 (days)” is calculated as the number of days difference of the product A in the process of S15, the candidate determination unit 115 determines that the “item number” is “6” in the process of S51. "1.0" which is the information stored in the "coefficient" is specified.

Returning to FIG. 10, the candidate determination unit 115 calculates the product of the ratio calculated in the process of S14 and the coefficient specified in the process of S51 (S52).

Specifically, for example, when “9 (%)” is calculated as the ratio of the product A in the process of S14 and “1.0” is specified in the process of S51, the candidate determination unit 115 determines that “9( %)” is calculated.

Then, the candidate determination unit 115 refers to the first adjustment days information 134a stored in the information storage area 130, and specifies the first adjustment days corresponding to the product calculated in the process of S52 for each of the plurality of products. (S53).

Specifically, for example, when “9 (%)” is calculated in the process of S52, the candidate determination unit 115 refers to the first adjustment day number information 134a described in FIG. 15, and “item number”, for example. “1 (day)” that is the information stored in the “adjustment days” of the information that is “2” is specified.

After that, the candidate determination unit 115 regards the difference in the number of days calculated in the process of S15 for each of the plurality of products as the inventory date candidate by adjusting the first adjusted number of days specified in the process of S53. It is determined (S54).

Specifically, for example, when the difference in the number of days calculated in the process of S15 is “6 (day)” and the first adjusted number of days of the product A specified in the process of S53 is “1 (day)”, The candidate determination unit 115 calculates “5 (day)” by subtracting “1 (day)” from “6 (day)”. Then, the candidate determination unit 115 determines candidates for the inventory date of the product A before "5 (Sun)" of the next settlement date.

That is, for example, when the difference in the number of days of the product A calculated in the process of S15 is smaller than the difference in the number of days of the product B, but the ratio calculated in the process of S14 is the same, the candidate determination unit 115 It is preferable to judge that the difference between the logical inventory quantity 132 and the actual inventory quantity on the product closing date of the commodity A is larger than that of the commodity B.

Therefore, the candidate determination unit 115 determines the inventory date candidate by using, for example, the difference in number of days between the last settlement date and the inventory date immediately before the settlement date.

Returning to FIG. 8, the candidate determination unit 115 determines whether or not there is a product whose inventory date candidate determined in the process of S16 is after the closing date (S21).

As a result, when it is determined that there is a product whose inventory date candidate determined in the process of S16 is after the closing date (YES in S22), the candidate determination unit 115 selects the product determined to exist in the process of S21. The corresponding inventory date candidate is changed to the settlement date (S23).

Specifically, for example, when the next settlement date is February 28, but the stocktaking date candidate corresponding to the product determined to exist in the process of S21 is March 2, the candidate determination unit 115 decides February 28, which is the next settlement date, as a candidate for the stocktaking date.

As a result, the information processing device 1 can prevent the stocktaking date of each product from being set after the closing date.

On the other hand, when it is determined that there is no product whose inventory date candidate determined in the process of S16 is after the settlement date (NO in S22), the candidate determination unit 115 does not perform the process of S23.

After that, the information output unit 116 of the information processing device 1 outputs the inventory date candidates determined in the process of S16 or the inventory date candidates changed in the process of S23 (S24). Specifically, the information output unit 116 outputs, to the operation terminal 3, information indicating, for example, the inventory date candidate determined in S16 or the inventory date candidate changed in S23.

After that, the person in charge determines the stocktaking date of each product by referring to the information output to the operation terminal 3, for example. Specifically, for example, the person in charge determines whether or not to adopt the inventory date candidate of each product whose information is output to the operation terminal 3 as the inventory date of each product.

As described above, the information processing apparatus 1 according to the present embodiment uses, for example, the stock number of products on the first stocktaking date (for example, the last closing date) as the initial value for each of the plurality of products to be stocked as the initial value. The logical stock quantity 132 reflecting the purchase and sales values of the goods after one stocktaking date is calculated. In addition, the information processing apparatus 1, for example, for each of the plurality of products to be inventoried, the number of products in stock on the second inventory date after the first inventory date (for example, the inventory date immediately before the last closing date). Is used as an initial value, and the number of auxiliary stocks 133 reflecting the values of the purchase and sales of the products after the second inventory date is calculated. Then, the information processing apparatus 1 determines a date closer to the settlement date as a candidate for the next inventory date for a product having a large difference between the calculated logical inventory number 132 and the auxiliary inventory number 133.

That is, the information processing apparatus 1 according to the present embodiment manages two logical inventory quantities 132 and an associated inventory quantity 133, which are two logical inventory quantities on different days. Then, the information processing apparatus 1 regards a product having a large difference between the logical inventory number 132 and the auxiliary inventory number 133 on the settlement date as a product in which the difference between the logical inventory number 132 and the actual inventory number is more likely to occur. Identify. After that, the information processing device 1 determines candidates for the stocktaking date of the specified product to be closer to the settlement date.

As a result, the information processing apparatus 1 can suppress the occurrence of the difference between the logical inventory quantity and the actual inventory quantity at the time of settlement. Therefore, the information processing device 1 can suppress the deviation of the stock number at the time of settlement.

The above embodiments are summarized as the following supplementary notes.

(Appendix 1)
With respect to each of the plurality of products, with the initial stock quantity of the goods on the first inventory date, the first stock quantity reflecting the purchase and sales values of the goods after the first inventory date is calculated,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the inventory quantity,
Among products of the plurality of products, for products having a large difference between the first inventory quantity and the second inventory quantity, a date closer to the closing date of the plurality of products is determined as a candidate for the next stocktaking date,
An inventory date determination program characterized by causing a computer to execute processing.

(Appendix 2)
In Appendix 1,
The first inventory date is the first settlement date for the plurality of products,
In the process of calculating the first inventory quantity, the first inventory quantity on the second settlement date following the first settlement date is calculated,
In the process of calculating the second inventory quantity, the second inventory quantity on the second settlement date is calculated,
In the determining process, a date closer to the third settlement date next to the second settlement date is determined as the inventory date candidate for the product having the large difference.
An inventory date determination program characterized by the following.

(Appendix 3)
In Appendix 1,
In the determining process,
Calculating the sum of the differences corresponding to each of the plurality of products,
For each of the plurality of products, calculate the ratio of the difference to the total sum,
Based on the calculated ratio, determine the inventory date candidates for each of the plurality of products,
An inventory date determination program characterized by the following.

(Appendix 4)
In Appendix 3,
In the determining process,
The inventory date candidates for products with a higher proportion are determined to be closer to the closing date.
An inventory date determination program characterized by the following.

(Appendix 5)
In Appendix 3,
The second inventory date is different for each of the plurality of products,
An inventory date determination program characterized by the following.

(Appendix 6)
In Appendix 5,
In the determining process,
Calculating the difference in the number of days between the second inventory date and the settlement date for each of the plurality of products;
Based on the calculated ratio and the difference in the number of days, determine the inventory date candidates for each of the plurality of products,
An inventory date determination program characterized by the following.

(Appendix 7)
In Appendix 6,
In the determining process,
A first value corresponding to the calculated ratio, which is information in which the ratio and the number of days are associated with each other, and which refers to the storage unit that stores the first adjustment information in which the smaller value ratio is associated with the larger number of days Specify the number of days for each of the plurality of products,
It is information in which the area of the sales floor of the product is associated with the number of days, and the storage unit that stores the second adjustment information in which the smaller the value of the area is associated with the smaller number of days is referred to Identify the second number of days corresponding to the sales floor area,
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following.

(Appendix 8)
In Appendix 6,
In the determining process,
A first value corresponding to the calculated ratio, which is information in which the ratio and the number of days are associated with each other, and which refers to the storage unit that stores the first adjustment information in which the smaller value ratio is associated with the larger number of days Specify the number of days for each of the plurality of products,
It is information in which the number of products and the number of days are associated with each other, and the number of products of the plurality of products is referred to by referring to the storage unit that stores the second adjustment information in which the smaller the number of products is associated with the smaller number of days. Identify the second number of days corresponding to
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following.

(Appendix 9)
In Appendix 6,
In the determining process,
A first value corresponding to the calculated ratio, which is information in which the ratio and the number of days are associated with each other, and which refers to the storage unit that stores the first adjustment information in which the smaller value ratio is associated with the larger number of days Specify the number of days for each of the plurality of products,
The plurality of products are referred to by referring to the storage unit that stores the second adjustment information, which is information in which the number of people who inventory goods is associated with the number of days, and the smaller the number of people is, the more the number of days is associated with Specify the second number of days corresponding to the number of people
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following.

(Appendix 10)
In Appendix 6,
In the determining process,
A first unit corresponding to the calculated difference in the number of days by referring to the storage unit that stores the coefficient information in which the number of days and the coefficient are associated with each other Specifying a coefficient for each of the plurality of products,
It is the information in which the ratio and the number of days are associated with each other, and the smaller the percentage of the value is, the more the number of days associated with the adjustment information is stored. Specify a first number of days corresponding to the product for each of the plurality of products,
For each of the plurality of products, the second number of days is calculated by subtracting the first number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined as a day when the calculated second number of days is traced back from the closing date.
An inventory date determination program characterized by the following.

(Appendix 11)
For each of the plurality of products, the first calculation is to calculate the first stock number that reflects the purchase and sales values of the product after the first stocktaking date, with the stock number of the product on the first stocktaking date as an initial value. Department,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2nd calculation part which calculates the stock quantity,
For a product having a large difference between the first inventory quantity and the second inventory quantity among the plurality of goods, a candidate determination for determining a date closer to the closing date of the plurality of goods as a candidate for the next stocktaking date And a section,
An inventory date determination device characterized in that

(Appendix 12)
In Appendix 11,
The candidate determination unit,
Calculating the sum of the differences corresponding to each of the plurality of products,
For each of the plurality of products, calculate the ratio of the difference to the total sum,
Based on the calculated ratio, determine the inventory date candidates for each of the plurality of products,
An inventory date determination device characterized in that

(Appendix 13)
In Appendix 12,
The candidate determination unit,
The inventory date candidates for products with a higher proportion are determined to be closer to the closing date.
An inventory date determination device characterized in that

(Appendix 14)
With respect to each of the plurality of products, with the initial stock quantity of the goods on the first inventory date, the first stock quantity reflecting the purchase and sales values of the goods after the first inventory date is calculated,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the inventory quantity,
Among products of the plurality of products, for products having a large difference between the first inventory quantity and the second inventory quantity, a date closer to the closing date of the plurality of products is determined as a candidate for the next stocktaking date,
A method for determining an inventory date, characterized by causing a computer to execute a process.

(Appendix 15)
In Appendix 14,
In the determining step,
Calculating the sum of the differences corresponding to each of the plurality of products,
For each of the plurality of products, calculate the ratio of the difference to the total sum,
Based on the calculated ratio, determine the inventory date candidates for each of the plurality of products,
A method for determining an inventory date, which is characterized in that

(Appendix 16)
In Appendix 15,
In the determining step,
The inventory date candidates for products with a higher proportion are determined to be closer to the closing date.
A method for determining an inventory date, which is characterized in that

1: Information processing device 3: Operating terminal 10: Information processing system NW: Network

Claims (12)

With respect to each of the plurality of products, with the initial stock quantity of the goods on the first inventory date, the first stock quantity reflecting the purchase and sales values of the goods after the first inventory date is calculated,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the inventory quantity,
Among products of the plurality of products, for products having a large difference between the first inventory quantity and the second inventory quantity, a date closer to the closing date of the plurality of products is determined as a candidate for the next stocktaking date,
An inventory date determination program characterized by causing a computer to execute processing. In claim 1,
The first inventory date is the first settlement date for the plurality of products,
In the process of calculating the first inventory quantity, the first inventory quantity on the second settlement date following the first settlement date is calculated,
In the process of calculating the second inventory quantity, the second inventory quantity on the second settlement date is calculated,
In the determining process, a date closer to the third settlement date next to the second settlement date is determined as the inventory date candidate for the product having the large difference.
An inventory date determination program characterized by the following. In claim 1,
In the determining process,
Calculating the sum of the differences corresponding to each of the plurality of products,
For each of the plurality of products, calculate the ratio of the difference to the total sum,
Based on the calculated ratio, determine the inventory date candidates for each of the plurality of products,
An inventory date determination program characterized by the following. In claim 3,
In the determining process,
The inventory date candidates for products with a higher proportion are determined to be closer to the closing date.
An inventory date determination program characterized by the following. In claim 3,
The second inventory date is different for each of the plurality of products,
An inventory date determination program characterized by the following. In claim 5,
In the determining process,
Calculating the difference in the number of days between the second inventory date and the settlement date for each of the plurality of products;
Based on the calculated ratio and the difference in the number of days, determine the inventory date candidates for each of the plurality of products,
An inventory date determination program characterized by the following. In claim 6,
In the determining process,
It is the information in which the ratio and the number of days are associated with each other. Specify the number of days for each of the plurality of products,
It is information in which the area of the sales floor of the product is associated with the number of days, and the storage unit that stores the second adjustment information in which the smaller the value of the area is associated with the smaller number of days is referred to Identify the second number of days corresponding to the sales floor area,
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following. In claim 6,
In the determining process,
A first value corresponding to the calculated ratio, which is information in which the ratio and the number of days are associated with each other, and which refers to the storage unit that stores the first adjustment information in which the smaller value ratio is associated with the larger number of days Specify the number of days for each of the plurality of products,
It is information in which the number of products and the number of days are associated with each other, and the number of products of the plurality of products is referred to by referring to the storage unit that stores the second adjustment information in which the smaller the number of products is associated with the smaller number of days. Identify the second number of days corresponding to
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following. In claim 6,
In the determining process,
A first value corresponding to the calculated ratio, which is information in which the ratio and the number of days are associated with each other, and which refers to the storage unit that stores the first adjustment information in which the smaller value ratio is associated with the larger number of days Specify the number of days for each of the plurality of products,
The plurality of products are referred to by referring to the storage unit that stores the second adjustment information, which is information in which the number of people who inventory goods is associated with the number of days, and the smaller the number of people is, the more the number of days is associated with Specify the second number of days corresponding to the number of people
For each of the plurality of products, the third number of days is calculated by subtracting the first number of days and the second number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined on a day when the calculated third number of days goes back from the closing date.
An inventory date determination program characterized by the following. In claim 6,
In the determining process,
A first unit corresponding to the calculated difference in the number of days by referring to the storage unit that stores the coefficient information in which the number of days and the coefficient are associated with each other Specifying a coefficient for each of the plurality of products,
It is the information in which the ratio and the number of days are associated with each other, and the smaller the percentage of the value is, the more the number of days associated with the adjustment information is stored. Specify a first number of days corresponding to the product for each of the plurality of products,
For each of the plurality of products, the second number of days is calculated by subtracting the first number of days from the difference in the number of days,
For each of the plurality of products, a candidate for the stocktaking date is determined as a day when the calculated second number of days is traced back from the closing date.
An inventory date determination program characterized by the following. For each of the plurality of products, the first calculation is to calculate the first stock number that reflects the purchase and sales values of the product after the first stocktaking date, with the stock number of the product on the first stocktaking date as an initial value. Department,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2nd calculation part which calculates the stock quantity,
For a product having a large difference between the first inventory quantity and the second inventory quantity among the plurality of goods, a candidate determination for determining a date closer to the closing date of the plurality of goods as a candidate for the next stocktaking date And a section,
An inventory date determination device characterized in that With respect to each of the plurality of products, with the initial stock quantity of the goods on the first inventory date, the first stock quantity reflecting the purchase and sales values of the goods after the first inventory date is calculated,
For each of the plurality of products, the stock number of products on the second inventory date after the first inventory date is used as an initial value, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the inventory quantity,
Among products of the plurality of products, for products having a large difference between the first inventory quantity and the second inventory quantity, a date closer to the closing date of the plurality of products is determined as a candidate for the next stocktaking date,
A method for determining an inventory date, characterized by causing a computer to execute a process.

Images