JP7201907B2 - Stocktaking date determination program, stocktaking date determination device, and stocktaking date determination method - Google Patents

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 at a retail store or 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 take stock of merchandise on the same day as the settlement of accounts.

On the other hand, for example, when there is a shortage of work resources for taking inventory of products, etc., or when the number of products to be taken is enormous, it becomes difficult to take inventory of products on the same day as settlement of accounts. Therefore, in retail stores, etc., inventory of products is performed before settlement of accounts as necessary (see Patent Documents 1 and 2, for example).

Japanese Patent Application Laid-Open No. 2002-366620 JP-A-11-134411

However, if the inventory of products is performed before settlement of accounts, there is a possibility that there will be a difference (deviation) between the logical inventory quantity and the actual inventory quantity at the time of settlement. Therefore, in retail stores such as those mentioned above, even if there is a shortage of work resources or the number of products to be inventoried is enormous, it may not be possible to take stock of products before the settlement of accounts. There is

Accordingly, in one aspect, an object of the present invention is to provide a stocktaking date determination program, a stocktaking date determination device, and a stocktaking date determination method capable of suppressing deviations in inventory numbers at settlement.

In one aspect of the embodiment, for each of a plurality of commodities, the stock count of the commodities on the first stocktaking date is set as an initial value, and the purchase and sales values of the commodities after the first stocktaking date are reflected in the first The number of inventories is calculated, and for each of the plurality of commodities, the stock count of the commodities on the second stocktaking date after the first stocktaking date is set as an initial value, and the purchase and sales of the commodities after the second stocktaking date. Calculate the second inventory quantity that reflects the value of , and for the product with a large difference between the first inventory quantity and the second inventory quantity among the plurality of products, the date closer to the settlement date for the plurality of products is determined as a candidate for the next and subsequent stocktaking dates.

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

FIG. 1 is a diagram illustrating the configuration of an information processing system 10. As shown in FIG. FIG. 2 is a diagram for explaining the hardware configuration of the information processing device 1. As shown in FIG. FIG. 3 is a functional block diagram of the information processing apparatus 1. As shown in FIG. FIG. 4 is a flow chart for explaining an outline of stocktaking date determination processing according to the first embodiment. FIG. 5 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 6 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 7 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 8 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 9 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 10 is a flowchart for explaining the details of stocktaking date determination processing according to the first embodiment. FIG. 11 is a diagram for explaining specific examples of the number of inventories 131, the number of logical inventories 132, and the number of standing inventories 133. As shown in FIG. FIG. 12 is a diagram for explaining specific examples of the inventory count 131, the logical inventory count 132, and the standing inventory count 133. As shown in FIG. FIG. 13 is a diagram for explaining specific examples of the number of inventories 131, the number of logical inventories 132, and the number of standing inventories 133. As shown in FIG. FIG. 14 is a diagram comparing a case where the standing inventory quantity 133 is not managed and a case where the standing inventory quantity 133 is managed. FIG. 15 is a diagram illustrating a specific example of the first adjustment days information 134a. FIG. 16 is a diagram illustrating a specific example of the second adjustment days information 134b. FIG. 17 is a diagram illustrating a specific example of the second adjustment days information 134b. FIG. 18 is a diagram illustrating a specific example of the second adjustment days information 134b. FIG. 19 is a diagram illustrating a specific example of the third adjustment 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 an information processing system 10. As shown in FIG.

An information processing system 10 shown in FIG. 1 has 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 for performing various operations on the information processing apparatus 1 by a person in charge of a retail store or the like (hereinafter simply referred to as a person in charge).

The information processing device 1 is, for example, one or more physical machines, and even if the inventory of the product is performed on the day before the closing date, the difference between the logical inventory quantity and the actual inventory quantity at the time of closing In order to suppress the occurrence of this, processing for determining the stocktaking date for each product (hereinafter also referred to as stocktaking date determination processing) is performed.

Specifically, for example, for each of a plurality of products to be inventoried, the information processing device 1 sets the inventory quantity of the product on the first inventory date (for example, the previous closing date) as an initial value, and after the first inventory date An inventory quantity (hereinafter also referred to as a first inventory quantity or a logical inventory quantity) reflecting the purchase and sales values of the product is calculated. In addition, for example, for each of a plurality of products to be taken inventory, the information processing device 1 determines the number of products in stock on the second inventory date after the first inventory date (for example, the inventory date immediately before the previous closing date) is the initial value, the inventory quantity (hereinafter also referred to as the second inventory quantity or the attached inventory quantity) reflecting the purchase and sales values 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 and subsequent stocktaking dates for the product having a large difference between the calculated first inventory quantity and the second inventory quantity.

That is, the information processing apparatus 1 according to the present embodiment manages the first inventory quantity and the second inventory quantity, which are two logical inventory quantities based on different days. Then, the information processing device 1 identifies a product with a large difference between the first inventory quantity and the second inventory quantity as a product that is more likely to have a difference between the logical inventory quantity and the actual inventory quantity. After that, the information processing device 1 determines a date closer to the settlement date as a candidate for the inventory date of the specified product.

As a result, the information processing apparatus 1 can suppress the occurrence of a 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 inventory quantity 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 for explaining the hardware configuration of the information processing device 1. As shown in FIG.

The information processing apparatus 1 has a CPU 101 as a processor, a memory 102, an external interface (I/O unit) 103, and a storage medium 104, as shown in FIG. Each unit is 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 stocktaking date determination processing. The storage medium 104 also has a storage unit 130 (hereinafter also referred to as an information storage area 130) that stores information used when performing stocktaking date determination processing, for example. Note that 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 to the memory 102 to perform stocktaking date determination processing.

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

[Functions of information processing system]
Next, functions of the information processing system 10 will be described. FIG. 3 is a functional block diagram of the information processing apparatus 1. As shown in FIG.

As shown in FIG. 3, the information processing apparatus 1 includes an information reception unit 111, an information management unit 112, a second Various functions including a 1 calculation unit 113, a second calculation unit 114, a candidate determination unit 115, and an information output unit 116 are realized.

Further, the information processing apparatus 1 stores, for example, an inventory count 131, a logical inventory count 132, an attached inventory count 133, and adjustment days information 134 in the information storage area 130, as shown in FIG. 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 count 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. The information receiving unit 111 also receives, for example, the number of sales and 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 product, the first calculation unit 113 uses the product inventory count 131 on the first inventory date as an initial value, and calculates the number of purchases and sales received by the information reception unit 111 (the number of products after the first inventory date). A logical inventory quantity 132 reflecting the number of purchases and the quantity of sales) is calculated. The information management unit 112 then stores the logical inventory quantity 132 stored by the first calculation unit 113 in the information storage area 130 .

The second calculation unit 114 calculates the number of purchases and the number of sales ( A standing inventory quantity 133 reflecting the number of products purchased and the number of sales after the second stocktaking date is calculated. Then, the information management unit 112 stores the standing inventory quantity 133 stored by the second calculation unit 114 in the information storage area 130 .

The candidate determining unit 115 determines a date closer to the settlement date as a candidate for the next and subsequent stocktaking dates for products having a large difference between the logical inventory quantity 132 and the attached inventory quantity 133 stored in the information storage area 130 .

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

[Outline of the first embodiment]
Next, an outline of the first embodiment will be described. FIG. 4 is a flow chart for explaining an outline of stocktaking date determination processing 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 process via the operation terminal 3 .

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

Further, in this case, the information processing device 1, for each of the plurality of products, sets the number of product inventory 131 on the second inventory date as an initial value, and reflects the purchase and sales values of the products after the second inventory date. A standing inventory quantity 133 is calculated (S3).

After that, the information processing device 1 selects a date closer to the closing date of the plurality of products as a candidate for the next and subsequent stocktaking dates for the product having a large difference between the number of logical inventory 132 and the number of standing inventory 133 among the plurality of products. (S4).

As a result, the information processing apparatus 1 can suppress the occurrence of a 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 inventory quantity at the time of settlement.

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

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

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

Then, when 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, processing for calculating the logical inventory quantity 132 and the attached inventory quantity 133 (hereinafter also referred to as information generation processing) will be described. FIG. 6 is a flowchart for explaining information generation processing.

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

Then, when it is time to generate information (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 calculates the first value for each of the plurality of products. A logical inventory quantity 132 is calculated when the initial value is the inventory count 131 of the product on one inventory day (S112).

Specifically, the information management unit 112 stores, for example, the number of purchases, the number of sales, and the number of corrections (the number of purchases and the number of sales occurring after the first stocktaking date) of each product received in the processing of S101 performed today. ) is reflected in the logical inventory quantity 132 of each product calculated in the processing of S112 performed yesterday, to calculate the logical inventory quantity 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 calculates the inventory count 131 of the product on the second inventory date for each of the plurality of products. The number of standing inventory 133 in the case of the initial value is calculated (S113).

Specifically, the information management unit 112 stores, for example, the number of purchases, the number of sales, and the number of corrections of each product received in the processing of S101 performed today (the number of purchases and the number of sales occurring after the second stocktaking date ) is reflected in the standing inventory quantity 133 of each product calculated in the process of S112 performed yesterday, to calculate the standing inventory quantity 133 of each product.

That is, the information management unit 112 reflects the corrections to the number of purchases and the number of sales occurring between the first stocktaking date and the second stocktaking date only when calculating the logical stock quantity 132 .

As a result, the information management unit 112 calculates the current logical inventory number (logical inventory number 132) when the initial value is the inventory number 131 of the product on the first inventory day, and the second inventory after the first inventory day. It is possible to calculate the current logical inventory quantity (the standing inventory quantity 133) when the daily inventory count 131 is the initial value.

After that, the information management unit 112 stores the logical inventory quantity 132 calculated in the process of S112 and the attached inventory quantity 133 calculated in the process of S113 in the information storage area 130 (S114). Specific examples of the inventory count 131, the logical inventory count 132, and the standing inventory count 133 stored in the information storage area 130 will be described below.

[Concrete examples of inventory counts, logical inventory counts, and attached inventory counts]
11 to 13 are diagrams for explaining specific examples of the number of inventories 131, the number of logical inventories 132, and the number of standing inventories 133. FIG. Specifically, FIG. 11 is a diagram explaining the product A, FIG. 12 is a diagram explaining the product B, and FIG. 13 is a diagram explaining the product C. As shown in FIG.

The information shown in FIG. 11 and the like includes "date" in which the date is stored, "logical inventory" in which the number of logical inventory 132 is stored, "inventory" in which the number of inventory 131 is stored, and "inventory" in which the number of inventory 133 is stored. It has items such as "attached inventory" to be stored. Further, the information shown in FIG. 11 and the like has the item of "excess or deficiency" in which the value calculated by subtracting the value stored in the "logical inventory" from the value stored in the "standing inventory" is stored. have. In the following explanation, it is assumed that the settlement date is February 28th.

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

For example, if the number of purchases, the number of sales, and the number of corrections for product A that occurred on February 20 are reflected in the logical inventory quantity 132 of product A as of February 19, the number is 100 (pieces). In this case, as shown in FIG. 11, the information management unit 112 adds "100 (pieces)" to the "logical inventory" of the information (information on the second row) in which "2/20" is stored in the "date". Remember. Then, for example, when the inventory of product A has not yet been performed as of February 20, the information management unit 112 determines the "inventory" and "appended "-" indicating that the information does not exist is stored in "Inventory" and "Surplus/Shortage".

Subsequently, for example, the number of purchases, sales, and revisions of product A that occurred on February 22nd is reflected in the logical inventory quantity 132 of product A as of February 21st, and the number is 95 (pieces). ), the information management unit 112 stores “100 (pieces)” in the “logical inventory” of the information (information in the fourth row) in which “2/22” is stored in the “date”. Then, for example, when the inventory of product A is performed on February 22nd, the information management unit 112 adds the number of inventory of product A to the “inventory” of the information in which “2/20” is stored in the “date”. "115 (pieces)", which is 131, is stored. Furthermore, in this case, the information management unit 112 adds 131 (the same number as the number stored in ), which is "115 (pieces)", and "+20 (pieces)" is stored as "excess or deficiency".

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

Subsequently, for example, the number of purchases, sales, and revisions of product A that occurred on February 25, reflected in the logical inventory quantity of product A as of February 24, 132, is 113 (pieces ), the information management unit 112 stores “113 (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, the number of purchases, the number of sales, and the number of corrections for product A that occurred on February 25 (only the number of corrections to the number of purchases and sales that occurred after the inventory date) are calculated as of February 24. is 130 (pieces), the information management unit 112 adds " 130 (pieces)” is stored. Furthermore, in this case, the information management unit 112 stores "-" in the "inventory" of the information in which "2/25" is stored in the "date", and stores "+17 (pieces)" in the "excess/shortage". do.

Here, a different value (110 (pieces) and 113 (pieces)) are stored. The same value (130 (pieces)) is stored in the "Inventory". Therefore, in this case, the "excess or deficiency" of the information with the "date" of "2/24" and the "excess or deficiency" of the information with the "date" of "2/25" have different values (+20( (pieces) and +17 (pieces)) are stored.

That is, when the purchase quantity or the sales quantity of product A is corrected before the stocktaking date, the information management unit 112 reflects the correction only on the logical stock quantity 132 .

Next, for example, the number of purchases, sales, and revisions of product A that occurred on February 28, reflected in the logical inventory quantity of product A as of February 27, 132, is 105 (pieces). ), the information management unit 112 stores “105 (pieces)” in the “logical inventory” of the information (the tenth row information) in which “2/28” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of corrections for product A that occurred on February 28 (only the number of corrections to the number of purchases and sales that occurred after the inventory date) are calculated as of February 27. is 120 (pieces), the information management unit 112 stores "2/28" in the "date" in the "standing inventory" of the information. "120 (pieces)" is stored. Furthermore, in this case, the information management unit 112 stores "-" in the "inventory" of the information in which "2/28" is stored in the "date", and stores "+15 (pieces)" in the "excess/shortage". do.

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

That is, the information management unit 112 manages not only the number of logical stocks 132 but also the number of standing stocks 133, thereby managing corrections that occur between the inventory date and the closing date of each product. be possible. Description of other information included in FIG. 11 is omitted.

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

For example, if the number of purchases, the number of sales, and the number of corrections for product B that occurred on February 20 are reflected in the logical inventory quantity 132 of product A as of February 19, the number is 2800 (pieces). In this case, as shown in FIG. 12, the information management unit 112 adds "2800 (pieces)" to the "logical inventory" of the information (information on the second row) in which "2/20" is stored in the "date". Remember. Then, for example, when the inventory of product B has not yet been performed as of February 20, the information management unit 112 determines the "inventory", "additional "-" indicating that the information does not exist is stored in "Inventory" and "Surplus/Shortage".

Subsequently, for example, the number of purchases, sales, and revisions of product B that occurred on February 25, reflected in the logical inventory quantity of product B of 132 as of February 24, is 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 product B is performed on February 25, the information management unit 112 stores the inventory count of product B as 131 in the “inventory” of the information in which “2/25” is stored in the “date”. "2900 (pieces)" is stored. Furthermore, in this case, the information management unit 112 adds 131 (the same number as the number stored in ), which is "2900 (pieces)", and "+200 (pieces)" is stored as "excess or deficiency".

Subsequently, for example, the number of purchases, sales, and revisions of product B that occurred on February 28, reflected in the logical inventory quantity of product B of 132 as of February 27, is 2850 (pieces ), the information management unit 112 stores “2850 (pieces)” in the “logical inventory” of the information (the tenth row information) in which “2/28” is stored in the “date”. Then, for example, the number of purchases, the number of sales, and the number of corrections for product B that occurred on February 28 (only the number of corrections to the number of purchases and sales that occurred after the inventory date) are calculated as of February 27. is 3000 (pieces), the information management unit 112 stores "2/28" in the "date" in the "standing inventory" of the information. "3000 (pieces)" is stored. Furthermore, in this case, the information management unit 112 stores "-" in the "inventory" of the information in which "2/28" is stored in the "date", and stores "+150 (pieces)" in the "excess/shortage". do.

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

For example, if the number of purchases, the number of sales, and the number of corrections for product C that occurred on February 20 are reflected in the logical inventory quantity 132 of product C as of February 19, the number is 900 (pieces). In this case, as shown in FIG. 13, the information management unit 112 adds "900 (pieces)" to the "logical inventory" of the information (information on the second row) in which "2/20" is stored in the "date". Remember. Then, for example, when the inventory of product C has not yet been performed as of February 20, the information management unit 112 determines the "inventory" and "appended "-" indicating that the information does not exist is stored in "Inventory" and "Surplus/Shortage".

Next, for example, the number of purchases, sales, and revisions of product C that occurred on February 23rd is reflected in the logical inventory quantity of product C of 132 as of February 22nd, and the number is 950 (pieces). ), the information management unit 112 stores “950 (pieces)” in the “logical inventory” of the information (the information on the fifth line) in which “2/23” is stored in the “date”. Then, for example, when the inventory of product B is performed on February 23, the information management unit 112 stores 131 inventory counts of product C in the “inventory” of the information in which “2/23” is stored in the “date”. "960 (pieces)" is stored. Furthermore, in this case, the information management unit 112 adds 131 (the same number as the number stored in ) is stored as "960 (pieces)", and "-10 (pieces)" is stored as "excess or deficiency".

Next, for example, the number of purchases, sales, and revisions of product C that occurred on February 28, reflected in the logical inventory quantity 132 of product B as of February 27 is 935 (pieces). If there is, the information management unit 112 stores "935 (pieces)" in the "logical inventory" of the information (information on the tenth row) in which "2/28" is stored in the "date". Then, for example, the number of purchases, the number of sales, and the number of corrections for product C that occurred on February 28 (only the number of corrections to the number of purchases and sales that occurred after the inventory date) are calculated as of February 27. is 940 (pieces), the information management unit 112 stores "2/28" in the "date" in the "standing inventory" of the information. "940 (pieces)" is stored. Furthermore, in this case, the information management unit 112 stores "-" in the "inventory" of the information in which "2/28" is stored in the "date", and "-5 (pieces)" in the "excess/shortage". Remember.

[Concrete example when the attached inventory quantity is not managed]
Next, a specific example of not managing the attached inventory quantity 133 will be described. FIG. 14 is a diagram comparing a case where the standing inventory quantity 133 is not managed and a case where the standing inventory quantity 133 is managed. Specifically, FIG. 14A is a diagram for explaining a specific example in which the standing inventory quantity 133 is not managed, and FIG. It is a figure explaining a specific example. Note that the specific example shown in FIG. 14B has the same contents as the specific example described in FIG.

The information shown in FIG. 14A has items other than "standing inventory" among the items included in the information described in FIG. Also, the "excess and deficiency" in the information shown in FIG. 14A stores a value calculated by subtracting the value stored in the "logical inventory" from the value stored in the "inventory".

Specifically, the same values as the information described with reference to FIG. 11 are stored in the "date", "logical inventory", and "inventory" in the information shown in FIG. 14(A). In the information shown 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 that the difference between the inventory count 131 and the logical inventory count 132 on the settlement date (February 28) is, for example, "excess The information "+20 (pieces)" stored in "Insufficient" is specified.

On the other hand, in the case of the example shown in FIG. 14B (in the case of the example shown in FIG. 11), the information processing device 1 calculates the difference between the inventory count 131 and the logical inventory count 132 on the closing date (February 28). , for example, it is possible to specify "+15 (pieces)", which is the information stored in the "excess or deficiency" of the information with the "date" of "2/28".

That is, the information processing apparatus 1 manages not only the logical inventory quantity 132 but also the standing inventory quantity 133, so that even if the inventory of the product is performed before the settlement of accounts, the logical inventory at the time of settlement of accounts can be reduced. It is possible to suppress the occurrence of a deviation between the number 132 and the actual stock quantity.

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

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

Then, when the timing for determining the stocktaking date has come (YES in S11), the candidate determination unit 115 of the information processing device 1 determines the logical inventory quantity 132 and the attached inventory 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 the closing date of "2/28" is stored in the "date" (the information on the 10th row) has "+15 (days)" as the "excess or deficiency". is stored. Therefore, the candidate determining unit 115, for example, refers to the information illustrated in FIG. 11 and specifies "+15 (days)" as the difference for the product A. Similarly, the candidate determining unit 115, for example, refers to the information shown in FIGS. 12 and 13, and specifies “+150 (days)” and “−5 (days)” as the difference between the products B and C, respectively.

Subsequently, the candidate determination unit 115 calculates the sum of the absolute values of the differences calculated in the process of S12 (S13).

Specifically, the candidate determination unit 115 determines the sum of the absolute values of “+15 (days),” “+150 (days),” and “−5 (days),” which are the differences between the products A, B, and C, “170 (Days)” 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 determining unit 115 divides each of “15 (days),” “150 (days),” and “5 (days)” by “170 (days),” 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. Calculate

Then, the candidate determining unit 115 calculates the difference in days between the second stocktaking 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 product A (the stocktaking date immediately before the closing date) is February 22nd, and the closing date of the retail store is February 28th. there is Therefore, the candidate determining unit 115, for example, refers to the information shown in FIG. 11 and calculates the difference in the number of days for product A as 6 days. Similarly, the candidate determination unit 115, for example, refers to the information shown in FIGS. 12 and 13, and calculates the difference in days between product B and product C as 3 days and 5 days, respectively.

Further, the candidate determination unit 115 determines candidates for stocktaking dates for each of the plurality of products based on the ratio calculated in the process of S14 and the difference in the number of days calculated in the process of S15 (S16). Details of the process of S16 will be described below.

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

The candidate determination unit 115 refers to the first adjustment days information 134a stored in the information storage area 130, as shown in FIG. The adjustment days are specified (S41). The first adjustment days information 134a is information that associates the ratio calculated in the process of S14 with the adjustment days of the stocktaking date, and is, for example, information stored in the information storage area 130 in advance by the person in charge. A specific example of the first adjustment days information 134a will be described below.

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

The first adjustment days information 134a shown in FIG. 15 includes an “item number” that identifies each piece of information, a “ratio lower limit” that stores the lower limit of the ratio, a “ratio upper limit” that stores the upper limit of the ratio, an inventory It has an item of "adjusted days" in which the number of adjusted days is stored.

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

In addition, in the first adjustment days information 134a shown in FIG. 15, for the information whose “item number” is “2”, “6 (%)” is stored as the “percentage lower limit” and “10 (%)” is stored as the “percentage upper limit”. (%)” is stored, and “1 (day)” is stored as the “adjustment days”. Description of other information included in FIG. 15 is omitted.

Therefore, for example, when "9 (%)" is calculated as the ratio of product A in the process of S14, the candidate determination unit 115 performs "adjustment Specify "1 (day)" which is the information stored in "number of days".

Subsequently, the candidate determination unit 115 refers to the second adjustment days information 134b stored in the information storage area 130, and specifies the second adjustment days corresponding to the attribute of each retailer for each of the plurality of products. (S42). The second adjustment days information 134b is information that associates the attributes of each retail point and the number of adjustment days of the stocktaking date, and is information that is stored in advance in the information storage area 130 by the person in charge, for example. A specific example of the second adjustment days information 134b will be described below.

[Specific example of second adjustment days information]
16 to 18 are diagrams for explaining specific examples of the second adjustment days information 134b. The candidate determination unit 115 performs processing by referring to, for example, any of the second adjustment days information 134b shown in FIGS. 16 to 18 .

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

The second adjustment days information 134b shown in FIG. 16 stores an "item number" that identifies each piece of information, an "area lower limit" that stores the lower limit of the area of the retail store, etc., and an upper limit of the area of the retail store, etc. and an "adjustment number of days" in which the number of adjustment days of the stocktaking date is stored as items. In the following description, it is assumed that "-" is stored in the columns with no restrictions.

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

In addition, in the second adjustment days information 134b shown in FIG. 16, in the information whose "item number" is "2", "11 (m ² )" is stored as the "minimum area" and "maximum area" is stored as " 30 (m ² )” is stored, and “0 (day)” is stored as the “adjustment days”. Description of other information included in FIG. 16 is omitted.

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

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

The second adjustment days information 134b shown in FIG. 17 includes an “item number” that identifies each piece of information, a “lower limit number of products” that stores the lower limit of the number of products sold at the retail store, etc., and It has items of "maximum number of products" in which the upper limit of the number of products to be stored and "adjustment days" in which the adjustment days of the stocktaking date are stored.

Specifically, in the second adjustment days information 134b shown in FIG. 17, in the information whose “item number” is “1”, “1 (piece)” is stored as the “lower limit number of products”, and “upper limit number of products” is stored. ” is stored as “1000 (pieces)”, and “-1 (day)” is stored as the “adjustment days”.

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

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

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

The second adjustment days information 134b shown in FIG. 18 stores an “item number” that identifies each piece of information, an “upper limit of number of people” that stores the upper limit of the number of people who perform inventory work, and a lower limit of the number of people who perform inventory work. and "number of adjustment days" in which the adjustment days of the stocktaking date are stored as items.

Specifically, in the second adjustment days information 134b shown in FIG. 18, for the information whose “item number” is “1”, “−” is stored as the “upper limit of the number of persons”, and “11 ( person)” is stored, and “−1 (day)” is stored as the “adjustment days”.

Further, in the second adjustment days information 134b shown in FIG. 18, for the information whose “item number” is “2”, “6 (persons)” is stored as the “maximum number of people” and “10 (persons)” is stored as the “minimum number of people”. (person)” is stored, and “0 (day)” is stored as the “adjustment days”. Description of other information included in FIG. 18 is omitted.

Therefore, for example, when the number of people who perform the inventory work is 20, the candidate determination unit 115 determines in the process of S42 that the information stored in the "adjustment days" of the information whose "item number" is "1". Specify "-1 (day)".

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

Specifically, for example, the difference in the number of days calculated in the process of S15 is "6 (days)", the first adjustment number of days for product A specified in the process of S41 is "2 (days)", and is "-1 (day)", the candidate determination unit 115 selects "6 (day)" to "2 (day)" and "-1 (day)". )” is subtracted to calculate “5 (days)”. Then, the candidate determination unit 115 determines a candidate for the stocktaking date of product A "five (days)" before the next closing date.

That is, in this case, the candidate determination unit 115 selects a candidate for the inventory date closer to the next settlement date for the product with a relatively larger difference between the logical inventory quantity 132 and the attached inventory quantity 133 on the previous settlement date. decide. In addition, the candidate determination unit 115 further adjusts the candidates for the inventory date according to the amount of labor required for inventory (the area of the retail store, the products sold at the retail store, the number of people who perform inventory work, etc.).

As a result, the information processing apparatus 1 can suppress the occurrence of a 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 inventory quantity at the time of settlement.

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

The candidate determination unit 115 refers to the third adjustment days information 134c stored in the information storage area 130, as shown in FIG. Identify (S51). The third adjustment days information 134c is information that associates the difference calculated in the process of S15 with the coefficient used for adjusting the inventory date. be. A specific example of the third adjustment days information 134c will be described below.

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

The third adjustment days information 134c shown in FIG. 19 includes an "item number" that identifies each piece of information, a "days difference" that stores the difference in the number of days calculated in the process of S15, and a coefficient that is used to adjust the stocktaking date. is stored as an item.

Specifically, in the third adjustment days information 134c shown in FIG. 19, for the information whose “item number” is “1”, “0 (days)” is stored as the “day difference” and “ 1.5” is stored.

In addition, in the third adjustment days information 134c shown in FIG. 19, for the information whose "item number" is "2", "1 (day)" is stored as the "day difference" and "1. 4” is stored.

Furthermore, in the third adjustment days information 134c shown in FIG. 19, for the information with the "item number" of "6", "5 (days) or more" is stored as the "day difference", 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 for product A in the process of S15, the candidate determination unit 115 selects the information whose "item number" is "6" in the process of S51. Specify "1.0" which is the information stored in "Coefficient".

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 product A in the process of S14 and "1.0" is specified in the process of S51, the candidate determination unit 115 determines "9 (%)" %)” is calculated.

Then, the candidate determining 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 days information 134a described with reference to FIG. "1 (day)" which is the information stored in the "adjustment days" of the information whose is "2" is specified.

After that, the candidate determination unit 115 selects the day on which the difference in the number of days calculated in the process of S15 for each of the plurality of products is adjusted by the first adjustment days specified in the process of S53 as a candidate for the stocktaking day. Determine (S54).

Specifically, for example, if the difference in the number of days calculated in the process of S15 is "6 (days)" and the first adjustment number of days for product A specified in the process of S53 is "1 (days)," The candidate determination unit 115 calculates “5 (days)” by subtracting “1 (days)” from “6 (days)”. Then, the candidate determination unit 115 determines a candidate for the stocktaking date of product A "five (days)" before the next closing date.

That is, for example, when the ratio calculated in S14 is the same even though the difference in the number of days for product A calculated in the process of S15 is smaller than the difference in the number of days for product B, the candidate determination unit 115 It is preferable to determine that the discrepancy between the logical inventory quantity 132 and the actual inventory quantity on the settlement date is greater for product A than for product B.

Therefore, the candidate determining unit 115 determines candidates for the stocktaking date by using, for example, the difference in days between the previous closing date and the stocktaking date immediately before that closing date.

Returning to FIG. 8, the candidate determination unit 115 determines whether or not there is a product for which the candidate for the stocktaking date determined in the process of S16 is later than the closing date (S21).

As a result, if it is determined that there is a product whose stocktaking date candidate determined in the process of S16 is later than the settlement date (YES in S22), the candidate determination unit 115 determines that the product determined to exist in the process of S21 The corresponding stocktaking date candidate is changed to the closing date (S23).

Specifically, for example, while the next settlement date is February 28, if the candidate for the inventory date corresponding to the product determined to exist in the process of S21 is March 2, the candidate determination unit 115 determines February 28, which is the next closing date, as a candidate stocktaking date.

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

On the other hand, if it is determined that there is no product for which the inventory date candidate determined in the process of S16 is later than 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 candidate stocktaking date determined in the processing of S16 or the candidate stocktaking date changed in the processing of S23 (S24). Specifically, the information output unit 116 outputs, to the operation terminal 3, information indicating the candidate stocktaking date determined in the processing of S16 or the candidate stocktaking date changed in the processing of S23, for example.

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, the person in charge determines, for example, whether or not to adopt the candidate stocktaking date of each product whose information is output to the operation terminal 3 as the stocktaking date of each product.

As described above, the information processing apparatus 1 according to the present embodiment, for example, for each of a plurality of products to be inventoried, sets the inventory quantity of the product on the first inventory date (for example, the previous settlement date) as an initial value, A logical inventory quantity 132 is calculated that reflects the purchase and sales values of the product after one inventory day. In addition, for example, for each of a plurality of products to be taken inventory, the information processing device 1 determines the number of products in stock on the second inventory date after the first inventory date (for example, the inventory date immediately before the previous closing date) is the initial value, the number of standing inventory 133 reflecting the purchase and sales values of the products after the second stocktaking date is calculated. Then, the information processing apparatus 1 determines a date closer to the settlement date as a candidate for the next and subsequent stocktaking dates for the product having a large difference between the calculated logical inventory quantity 132 and the attached inventory quantity 133 .

That is, the information processing apparatus 1 according to the present embodiment manages the logical inventory quantity 132 and the attached inventory quantity 133, which are two logical inventory quantities based on different days. Then, the information processing device 1 regards the product having a large difference between the logical inventory quantity 132 and the standing inventory quantity 133 on the closing date as a product that is more likely to have a difference between the logical inventory quantity 132 and the actual inventory quantity. Identify. After that, the information processing device 1 determines a date closer to the settlement date as a candidate for the inventory date of the specified product.

As a result, the information processing apparatus 1 can suppress the occurrence of a 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 inventory quantity at the time of settlement.

The above embodiments are summarized as follows.

(Appendix 1)
For each of a plurality of products, with the number of products in stock on the first inventory date as the initial value, the first inventory quantity reflecting the purchase and sales values of the products after the first inventory date is calculated,
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the number of stocks,
For products 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.
A stocktaking date determination program characterized by causing a computer to execute processing.

(Appendix 2)
In Appendix 1,
The first stocktaking 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 account closing date following the first closing date is calculated,
In the process of calculating the second inventory quantity, calculating the second inventory quantity on the second closing date,
In the determining process, a date closer to the third closing date next to the second closing date is decided as a candidate for the stocktaking date for the product with the large difference.
An inventory date determination program characterized by:

(Appendix 3)
In Appendix 1,
In the process of determining,
calculating the sum of the differences corresponding to each of the plurality of products;
calculating the ratio of the difference to the total for each of the plurality of products;
Determining the candidate stocktaking date for each of the plurality of products based on the calculated ratio;
An inventory date determination program characterized by:

(Appendix 4)
In Appendix 3,
In the process of determining,
Determining the candidate for the inventory date of the product with the higher ratio to a date closer to the closing date;
An inventory date determination program characterized by:

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

(Appendix 6)
In Appendix 5,
In the process of determining,
For each of the plurality of products, calculating the difference in the number of days between the second stocktaking date and the closing date,
Determining candidates for the inventory date for each of the plurality of products based on the calculated ratio and the difference in the number of days;
An inventory date determination program characterized by:

(Appendix 7)
In Appendix 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the area of the product sales floor and the number of days are associated with each other, and in which the area having a smaller value is associated with the number of days having a smaller value, Identifying a second number of days corresponding to the area of the sales floor,
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by:

(Appendix 8)
In Appendix 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the number of products and the number of days are associated with each other, and the smaller the number of products, the second adjustment information is associated with the smaller number of days, and the number of products of the plurality of products. Identify the second number of days corresponding to
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by:

(Appendix 9)
In Appendix 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the number of persons and the number of days for performing inventory of the product are associated with each other, the number of persons having a smaller value is associated with the number of days having a larger value, and the plurality of products are stored. Identify the second number of days corresponding to the number of people who perform inventory of
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by:

(Appendix 10)
In Appendix 6,
In the process of determining,
A storage unit that stores coefficient information in which the number of days and the coefficient are associated with each other, and the number of days with a smaller value is associated with a coefficient with a larger value. identifying a coefficient for each of the plurality of commodities;
The ratio and the number of days are associated with each other, and the ratio between the calculated ratio and the first coefficient is calculated by referring to the storage unit that stores the adjustment information that is associated with the number of days with a larger value for a smaller ratio. identifying a first number of days corresponding to the product for each of the plurality of commodities;
For each of the plurality of products, calculating the second number of days by subtracting the first number of days from the difference in the number of days;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated second number of days from the settlement date;
An inventory date determination program characterized by:

(Appendix 11)
For each of a plurality of products, a first calculation for calculating a first inventory quantity reflecting purchase and sales values of the product after the first stocktaking date, using the product inventory quantity on the first stocktaking date as an initial value Department and
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 a second calculation unit that calculates the number of stocks;
Candidate determination for determining a date closer to the closing date of the plurality of commodities as a candidate for the next and subsequent stocktaking dates for the commodities having a large difference between the first inventory quantity and the second inventory quantity among the plurality of commodities. having a part and
An inventory date determination device characterized by:

(Appendix 12)
In Appendix 11,
The candidate determination unit is
calculating the sum of the differences corresponding to each of the plurality of products;
calculating the ratio of the difference to the total for each of the plurality of products;
Determining the candidate stocktaking date for each of the plurality of products based on the calculated ratio;
An inventory date determination device characterized by:

(Appendix 13)
In Appendix 12,
The candidate determination unit is
Determining the candidate for the inventory date of the product with the higher ratio to a date closer to the closing date;
An inventory date determination device characterized by:

(Appendix 14)
For each of a plurality of products, with the number of products in stock on the first inventory date as the initial value, the first inventory quantity reflecting the purchase and sales values of the products after the first inventory date is calculated,
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the number of stocks,
For products 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.
A stocktaking date determination method characterized by causing a computer to execute processing.

(Appendix 15)
In Appendix 14,
In the determining step,
calculating the sum of the differences corresponding to each of the plurality of products;
calculating the ratio of the difference to the total for each of the plurality of products;
Determining the candidate stocktaking date for each of the plurality of products based on the calculated ratio;
An inventory date determination method characterized by:

(Appendix 16)
In Appendix 15,
In the determining step,
Determining the candidate for the inventory date of the product with the higher ratio to a date closer to the closing date;
An inventory date determination method characterized by:

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

Claims (12)

For each of a plurality of products, with the number of products in stock on the first inventory date as the initial value, the first inventory quantity reflecting the purchase and sales values of the products after the first inventory date is calculated,
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the number of stocks,
When the difference between the first inventory quantity and the second inventory quantity corresponding to the first product among the plurality of products is larger than the difference corresponding to the second product among the plurality of products, the second The next and subsequent stocktaking dates for each of the plurality of products so that the next and subsequent stocktaking date candidates for one product are closer to the settlement date than the next and subsequent stocktaking date candidates for the second product. determine candidates for
A stocktaking date determination program characterized by causing a computer to execute processing. In claim 1,
The first stocktaking 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 account closing date following the first closing date is calculated,
In the process of calculating the second inventory quantity, calculating the second inventory quantity on the second closing date,
In the determining process, when the difference corresponding to the first product is greater than the difference corresponding to the second product, the next and subsequent inventory date candidates for the first product are those for the second product. determining a candidate for the next and subsequent stocktaking dates for each of the plurality of commodities so as to be a date closer to the third closing date following the second closing date than the next and subsequent stocktaking date candidates ;
An inventory date determination program characterized by: In claim 1,
In the process of determining,
calculating the sum of the differences corresponding to each of the plurality of products;
calculating the ratio of the difference to the total for each of the plurality of products;
Determining the candidate stocktaking date for each of the plurality of products based on the calculated ratio;
An inventory date determination program characterized by: In claim 3,
In the determining process, if the ratio corresponding to the first product is greater than the ratio corresponding to the second product, the next and subsequent inventory date candidates for the first product are those for the second product. Determining candidates for subsequent stocktaking dates for each of the plurality of products so that the dates are closer to the settlement date than the candidates for subsequent stocktaking dates ;
An inventory date determination program characterized by: In claim 3,
The second stocktaking date is different for each of the plurality of products,
An inventory date determination program characterized by: In claim 5,
In the process of determining,
For each of the plurality of products, calculating the difference in the number of days between the second stocktaking date and the closing date,
Determining candidates for the inventory date for each of the plurality of products based on the calculated ratio and the difference in the number of days;
An inventory date determination program characterized by: In claim 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the area of the product sales floor and the number of days are associated with each other, and in which the area having a smaller value is associated with the number of days having a smaller value, Identifying a second number of days corresponding to the area of the sales floor,
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by: In claim 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the number of products and the number of days are associated with each other, and the smaller the number of products, the second adjustment information is associated with the smaller number of days, and the number of products of the plurality of products. Identify the second number of days corresponding to
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by: In claim 6,
In the process of determining,
Information in which a ratio and a number of days are associated with each other, and the first adjustment information corresponding to the calculated ratio is referenced by referring to the storage unit that stores the first adjustment information that is associated with the number of days with a larger value as the ratio of a smaller value. specifying a number of days for each of the plurality of products;
By referring to the storage unit storing the second adjustment information, which is information in which the number of persons and the number of days for performing inventory of the product are associated with each other, the number of persons having a smaller value is associated with the number of days having a larger value, and the plurality of products are stored. Identify the second number of days corresponding to the number of people who perform inventory of
calculating a third number of days 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;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated third number of days from the settlement date;
An inventory date determination program characterized by: In claim 6,
In the process of determining,
A storage unit that stores coefficient information in which the number of days and the coefficient are associated with each other, and the number of days with a smaller value is associated with a coefficient with a larger value. identifying a coefficient for each of the plurality of commodities;
The ratio and the number of days are associated with each other, and the ratio between the calculated ratio and the first coefficient is calculated by referring to the storage unit that stores the adjustment information that is associated with the number of days with a larger value for a smaller ratio. identifying a first number of days corresponding to the product for each of the plurality of commodities;
For each of the plurality of products, calculating the second number of days by subtracting the first number of days from the difference in the number of days;
For each of the plurality of commodities, the candidate for the stocktaking date is determined on the day preceding the calculated second number of days from the settlement date;
An inventory date determination program characterized by: For each of a plurality of products, a first calculation for calculating a first inventory quantity reflecting purchase and sales values of the product after the first stocktaking date, using the product inventory quantity on the first stocktaking date as an initial value Department and
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 a second calculation unit that calculates the number of stocks;
When the difference between the first inventory quantity and the second inventory quantity corresponding to the first product among the plurality of products is larger than the difference corresponding to the second product among the plurality of products, the second The next and subsequent stocktaking dates for each of the plurality of products so that the next and subsequent stocktaking date candidates for one product are closer to the settlement date than the next and subsequent stocktaking date candidates for the second product. a candidate determination unit that determines candidates for
An inventory date determination device characterized by: For each of a plurality of products, with the number of products in stock on the first inventory date as the initial value, the first inventory quantity reflecting the purchase and sales values of the products after the first inventory date is calculated,
For each of the plurality of products, the initial value is the number of products in stock on the second inventory date after the first inventory date, and the purchase and sales values of the products after the second inventory date are reflected. 2 Calculate the number of stocks,
When the difference between the first inventory quantity and the second inventory quantity corresponding to the first product among the plurality of products is larger than the difference corresponding to the second product among the plurality of products, the second The next and subsequent stocktaking dates for each of the plurality of products so that the next and subsequent stocktaking date candidates for one product are closer to the settlement date than the next and subsequent stocktaking date candidates for the second product. determine candidates for
A stocktaking date determination method characterized by causing a computer to execute processing.

Images