Purchase management system, purchase management method, and purchase management program

Abstract

To provide a purchase management system, a method for managing a purchase, and a purchase management program which can reduce the work load on a manager when a consumption product arrives.SOLUTION: The purchase management system according to an embodiment includes: a product master in which a product, the date of start of applying a product section, and a product section which specifies a consumption purchase product or a purchase product are related to one another to register; and purchase processing means for determining whether a product is a consumption purchase or a purchase product on the basis of the arrival date of the product with reference to the product master when the product arrives at a distribution warehouse, and counts the product as a purchase if the product is a purchase product and does not count the product as a purchase when the product is a consumption purchase product, and counts the product as a purchase when the consumption purchase product arrives at a shop.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a purchase management system, a purchase management method, and a purchase management program. [Background technology]

[0002] For example, there are two types of purchasing methods for products: consumption purchasing and purchase purchasing. The type of product is determined by the product, but the worker must change the work content for each attribute of the product, which increases the workload and reduces work efficiency. For example, Patent Document 1 is a conventional system related to consumption purchasing. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2004-21489 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not state anything about reducing the workload of the person in charge when used products arrive.

[0005] The present invention has been made in consideration of the above, and aims to provide a purchasing management system, a purchasing management method, and a purchasing management program that can reduce the workload of staff when used goods arrive. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the present invention provides a purchasing management system equipped with a control unit, which is configured to be able to access a product master in which a product, a start date for application of a product category, and a product category specifying a consumed purchase or a purchased item are registered in association with each other, and is characterized in that when a product arrives at a logistics warehouse, the product master is referenced and it is determined whether the product is a consumed purchase or a purchased item based on the arrival date of the product, and if it is a purchased item, it is recorded as a purchased item, and if it is a consumed purchase, it is not recorded as a purchased item, but is recorded as a purchased item when the consumed purchase arrives at the store.

[0007] In addition, according to one aspect of the present invention, the purchasing processing means inputs logistics warehouse purchasing data including the arrival date, product, quantity purchased, unit price, amount, product category, and warehouse when goods arrive at the logistics warehouse, and the product category is obtained and set from the product master using the product and arrival date as keys, and for the logistics warehouse purchasing data, if the product category is a purchased item, purchasing data including the purchase date, product, product name, quantity purchased, unit price, amount, product category, and warehouse is created, and if the product category is a consumed item, a first purchasing processing means is included that does not create purchasing data.

[0008] In addition, according to one aspect of the present invention, the purchasing processing means may include a shipping processing means that creates logistics warehouse shipping data including the shipping date, product, number shipped, unit price, amount, product category, original product category, and warehouse when shipping a product to a store, and sets the product category to the original product category.

[0009] In addition, according to one embodiment of the present invention, the purchasing processing means creates store purchasing data including the arrival date, product code, product name, quantity received, unit price, amount, consumption tax, product category, original product category, and warehouse based on the logistics warehouse shipping data when a product arrives at a store, and automatically transfers the product category to a purchased item if the product category in the logistics warehouse shipping data is a consumed purchase item, and may include a second purchasing processing means that creates purchasing data for the store purchasing data only for items whose original product category is a consumed purchase item.

[0010] According to another aspect of the present invention, the store may include a store of a company that operates multiple stores.

[0011] In addition, in order to solve the above-mentioned problems and achieve the objective, the present invention provides a purchasing management method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a product master in which a product, a start date of application of a product category, and a product category specifying a consumed purchase or a purchased item are registered in association with each other, and the control unit includes a purchasing processing step executed in the control unit, which, when a product arrives at a logistics warehouse, refers to the product master and determines whether the product is a consumed purchase or a purchased item based on the arrival date of the product, and if it is a purchased item, it is recorded as a purchased item, and if it is a consumed purchase, it is not recorded as a purchased item, but is recorded as a purchased item when the consumed purchase arrives at the store.

[0012] In addition, according to one aspect of the present invention, the present invention is a purchasing management program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to access a product master in which a product, a start date of application of a product category, and a product category specifying a consumed purchase or a purchased item are registered in association with each other, and the control unit is characterized in that when a product arrives at a logistics warehouse, the control unit refers to the product master and determines whether the product is a consumed purchase or a purchased item based on the arrival date of the product, and if it is a purchased item, it is recorded as a purchased item, and if it is a consumed purchase, it is not recorded as a purchased item, but is recorded as a purchased item when the consumed purchase arrives at a store. Effect of the Invention

[0013] According to the present invention, it is possible to reduce the workload of a person in charge when consumed products arrive. [Brief description of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a purchase management system according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the warehouse master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the configuration of the product master. [Figure 4] FIG. 4 is a flowchart for explaining an outline of the overall processing of the control unit of the purchase management system according to the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the purchase management system according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the purchase management system according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the purchase management system according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the process of the control unit of the purchase management system according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0016] [1. Overview] For example, in the restaurant industry, there is a management system called "consumption purchases," and there are cases where items do not count as purchases even when they arrive at the warehouse. Consumption purchases remain the assets of the supplier when they arrive at the warehouse, and are recorded as purchases when they arrive at the store. Purchased items become the company's assets when they arrive at the warehouse, and are recorded as purchases. For example, seasonal items are exclusive items, so they become purchases and are purchased items when they arrive at the warehouse. Here, "seasonal items" refer to items that can only be used during a specific season, such as Christmas-colored wrapping paper. "Exclusive items" are products that are custom-made for the company, such as products with a logo.

[0017] However, conventionally, logistics personnel are required to change the work content for each attribute of the product, which takes a lot of time to confirm and imposes a heavy workload.

[0018] Therefore, in this invention, in order to allow workers to proceed with processing without having to make any special decisions when goods arrive at the logistics warehouse or at the store, a product master is used to automatically determine whether a product arriving at the logistics warehouse is a consumed item or a purchased item, and when a consumed item arrives at the logistics warehouse, no purchase accounting is done, but when it arrives at the store, and when it is a purchased item, the purchase accounting is done when it arrives at the logistics warehouse, and when it arrives at the store it is treated as an inventory movement.

[0019] This will enable logistics and store staff to process items regardless of their attributes (whether they are purchased items or items to be consumed), improving work efficiency.

[0020] The purchase management system of the present invention is widely applicable to various types of businesses, such as businesses with multiple stores.

[0021] [2. Configuration] An example of the configuration of a purchase management system (logistics warehouse system) according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a purchase management system according to this embodiment.

[0022] The purchasing management system 100 is a commercially available desktop personal computer. The purchasing management system 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0023] The purchasing management system 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit of the purchasing management system 100 is communicatively connected via an arbitrary communication path.

[0024] The communication interface unit 104 communicatively connects the purchasing management system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the purchasing management system 100 to the store terminals 400... and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The store terminals 400... are terminals provided in each store, and are configured to be able to communicate with the purchasing management system 100.

[0025] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0027] The storage unit 106 includes a warehouse master 106a, a product master 106b, and a data file 106c. Fig. 2 is a diagram showing an example of the structure of the warehouse master 106a. Fig. 3 is a diagram showing an example of the structure of the product master 106b.

[0028] The warehouse master 106a can be configured as a table or the like in which warehouse codes, warehouse names, and warehouse classifications are registered in association with each other, as shown in FIG.

[0029] As shown in FIG. 3, the product master 106b can be configured as a table or the like in which product codes, product names, application start dates for the product categories, and product categories that specify purchased products or products to be consumed are registered in association with each other.

[0030] The data file 106c is a file for storing warehouse arrival data, purchase data, inventory data, warehouse shipping data, store arrival data, and the like.

[0031] The logistics warehouse arrival data may include arrival date, product code, product name, arrival quantity, unit price, amount, consumption tax, product category, and warehouse code. The product category is set by referencing the product master 106a, using the product and arrival date as keys, and by referencing the application start date and product category of the product master 106b to acquire the product category. The warehouse code is set by referencing the warehouse master 106a, and is the warehouse code of the logistics warehouse.

[0032] The purchase data may include purchase date, product code, product name, purchase quantity, unit price, amount, consumption tax, product category, and warehouse code.

[0033] The inventory data may include product code, product name, stock quantity, product category, and warehouse code.

[0034] The logistics warehouse shipping data may include shipping date, product code, product name, shipping quantity, unit price, amount, consumption tax, product category, original product category, and warehouse code.

[0035] The store arrival data may include arrival date, product code, product name, arrival quantity, unit price, amount, consumption tax, product category, original product category, and warehouse code. The warehouse code of the store is set by referring to the warehouse master 106a.

[0036] Returning to Fig. 1, the control unit 102 is a CPU or the like that performs overall control of the purchase management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs.

[0037] The control unit 102 is configured to be able to access the warehouse master 106a, the product master 106b, and the data file 106c stored in the storage unit 106. These master files may be provided in other locations (e.g., the server 200) as long as they are accessible by the control unit 102.

[0038] The control unit 102 conceptually includes a first receiving processing unit 102a, a shipping processing unit 102b, a second receiving processing unit 102c, a stock inquiry unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

[0039] The first receiving processing unit 102a, the shipping processing unit 102b, and the second receiving processing unit 102c constitute a purchasing processing means which, when a product arrives at the warehouse, refers to the product master 106b to determine whether the product is a consumed purchase item or a purchased item based on the arrival date of the product, and if it is a purchased item, it is recorded as a purchased item, and if it is a consumed purchase item, it is not recorded as a purchased item, but is recorded as a purchased item when the consumed purchase item arrives at the store.

[0040] When an item arrives at the warehouse, the first receiving processing unit 102a creates logistics warehouse receiving data including the arrival date, item (item code and / or item name), arrival quantity, unit price, amount, item category, and warehouse (warehouse code and / or warehouse name) by referring to the warehouse master 106a and item master 106b in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106c. The item category is acquired and set by referring to the application start date and item category in the item master 106b using the item and arrival date as keys. The warehouse code is set by referring to the warehouse master 106a and setting the warehouse code of the logistics warehouse. The first receiving processing unit 102a also updates the inventory data in the data file 106c based on the logistics warehouse receiving data.

[0041] In addition, the first incoming goods processing unit 102a, for example, in response to operator operations on an input screen (not shown) displayed on the monitor 114, for the logistics warehouse incoming goods data, if the product category is a purchased item, records the purchase and creates purchasing data including the purchase date, product (product code and / or product name), purchase quantity, unit price, amount, product category, and warehouse code, and registers this in the data file 106c, and if the product category is a consumed purchase, does not record the purchase and does not create purchasing data.

[0042] When shipping a product to a store, the shipping processing unit 102b creates logistics warehouse shipping data including the shipping date, product (product code and / or product name), shipping quantity, unit price, amount, product category, original product category, and warehouse code in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106c and transmits it to the store terminal 400 of the shipping destination store. The product category and the original product category are assumed to be the same.

[0043] The product of the logistics warehouse shipping data is transported from the logistics warehouse to the store. The shipping processing unit 102b updates the inventory data in the data file 106c based on the logistics warehouse shipping data. When the product of the logistics warehouse shipping data arrives at the store, the store terminal 400 notifies the purchase management system 100 (the second arrival processing unit 102c) of the arrival.

[0044] When the second arrival processor 102c receives a notification from the store terminal 400 that a product in the warehouse shipping data has arrived at the store, it creates store arrival data including the arrival date, product (product code and / or product name), arrival quantity, unit price, amount, product category, original product category, and warehouse code based on the warehouse shipping data, and registers it in the data file 106c. At this time, if the product category in the warehouse shipping data is "purchased product," it automatically changes the product category to "purchased product."

[0045] In addition, the second receiving processing unit 102c records the purchase of only those items whose original product category is "purchased goods consumed" in the store receiving data, creates purchase data, and registers it in the data file 106c. In addition, the second receiving processing unit 102c updates the inventory data in the data file 106c based on the store receiving data.

[0046] The stock inquiry unit 102d inquires about stock data registered in the data file 106c in response to, for example, an operator's operation on a stock inquiry screen displayed on the monitor 114.

[0047] The master maintenance unit 102e performs settings such as input, addition, deletion, and editing of data for the warehouse master 106a and the product master 106b in response to an operator's operation on a master maintenance screen displayed on the monitor 114, for example.

[0048] The screen display control unit 102f controls the display and input of various screens (for example, an arrival input screen, a shipping screen, a purchase input screen, an inventory inquiry screen, a master maintenance screen, etc.) displayed on the monitor 114.

[0049] [3. Specific Examples] Specific examples of processing by the purchasing management system 100 in this embodiment will be described with reference to Fig. 1 to Fig. 8. First, an overview of the overall processing by the purchasing management system 100 in this embodiment will be described with reference to Fig. 4. Fig. 4 is a diagram showing a flow for explaining the overview of the overall processing by the purchasing management system 100 in this embodiment. In the following description, all monetary amounts will be expressed in units of "yen" and the unit of "yen" will be omitted.

[0050] In FIG. 4, when a product arrives at a logistics warehouse, the first receiving processing unit 102a executes the first receiving processing (step S1). Specifically, in the first receiving processing, the first receiving processing unit 102a performs receiving input, and creates logistics warehouse receiving data by referring to the warehouse master 106a and the product master 106b in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106c. The product category is acquired and set by referring to the application start date and product category in the product master 106b using the product and the arrival date as keys. The warehouse code is set by referring to the warehouse master 106a and setting the warehouse code of the logistics warehouse. The first receiving processing unit 102a also updates the inventory data in the data file 106c based on the logistics warehouse receiving data.

[0051] Next, in the first receiving process, the first receiving processing unit 102a performs a lump-sum purchase accounting, and for the logistics warehouse receiving data, if the product category is a purchased item, the purchasing is accounted for, purchasing data is created and registered in the data file 106c, and if the product category is a consumable purchase item, the purchasing is not accounted for, and purchasing data is not created.

[0052] The shipping processing unit 102b executes shipping processing (step S2). Specifically, in the shipping processing, the shipping processing unit 102b creates logistics warehouse shipping data in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, registers the data in the data file 106c, and transmits the data to the store terminal 400 of the store at the shipping destination. The product in the logistics warehouse shipping data is transported from the logistics warehouse to the store. The shipping processing unit 102b also updates the inventory data in the data file 106c based on the logistics warehouse shipping data. When the product in the logistics warehouse shipping data arrives at the store, the store terminal 400 notifies the purchase management system 100 (the second arrival processing unit 102c) of the fact.

[0053] The second receiving processing unit 102c executes the second receiving processing (step S3). Specifically, in the second receiving processing, when the second receiving processing unit 102c receives a notification from the store terminal 400 that the product in the logistics warehouse shipping data has arrived at the store, it inputs the receiving information, creates store receiving data based on the logistics warehouse shipping data, and registers it in the data file 106c. At that time, it changes the product category from "purchased product" to "purchased product". It also changes the warehouse code from "logistics warehouse: B100" to "store warehouse: T100".

[0054] In the second receiving process, the second receiving processing unit 102c performs a bulk purchase accounting, and for the store receiving data, the second receiving processing unit 102c accounts for the purchases only for those whose original product category is "consumption purchase goods", creates purchase data, and registers it in the data file 106c. The second receiving processing unit 102c also updates the inventory data in the data file 106c based on the store receiving data.

[0055] (3-2. Sample data) 5 to 8 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the purchase management system 100 according to the present embodiment. A specific example of the processing by the control unit 102 of the purchase management system 100 according to the present embodiment will be explained with reference to Figs. 5 to 8.

[0056] (S1: First shipping process) The first shipping process will be described with reference to Figures 5 and 6. The first receiving processing unit 102a inputs receiving information, and creates logistics warehouse receiving data by referring to the warehouse master 106a and the product master 106b in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106c. The first receiving processing unit 102a also updates the inventory data in the data file 106c based on the logistics warehouse receiving data.

[0057] FIG. 5(A) shows an example of data in the warehouse master 106a, FIG. 5(B) shows an example of data in the product master 106b, and FIG. 5(C) shows an example of data in the logistics warehouse receiving data.

[0058] As shown in Fig. 5(A), the warehouse master 106a has the items of warehouse code, warehouse name, and warehouse category. In the example shown in Fig. 5(A), the first line has the warehouse code "B100", the warehouse name "logistics warehouse", and the warehouse category "warehouse", and the second line has the warehouse code "T100", the warehouse name "store warehouse", and the warehouse category "store".

[0059] As shown in FIG. 5B, the product master 106b includes the following items: product code, product name, application start date to which the product category is applied, and product category items that specify the purchased product or the consumed purchase. In the example shown in FIG. 5B, the first line includes the product code "S100", the product name "10 kg of flour", the application start date "2021 / 1 / 1", and the product category "purchased product", the second line includes the product code "S200", the product name "10 L of salad oil", the application start date "2021 / 1 / 1", the product category "consumption purchase product", and the third line includes the product code "S200", the product name "10 L of salad oil", the application start date "2021 / 6 / 15", and the product category "purchased product". For the product "S200: 10 L of salad oil", the product category "consumption purchase product" will be applied from "2021 / 1 / 1" and will be switched to the product category "purchased product" from "2021 / 6 / 15".

[0060] As shown in Fig. 5(C), the logistics warehouse arrival data includes the following fields: arrival date, product code, product name, arrival quantity, unit price, amount, consumption tax, product category, and warehouse code. The product category is set by referencing the product master 106b, using the product code and arrival date as keys, and by referencing the application start date and product category of the product master 106b. The warehouse code is set to the warehouse code "B100" of the logistics warehouse, by referencing the warehouse master 106a.

[0061] In the example of logistics warehouse arrival data shown in Figure 5 (C), the second line contains the arrival date "2021 / 6 / 14," product code "S200," product name "Salad oil 10L," quantity received "10," unit price "20,000," amount "200,000," consumption tax "16,000," product category "Consumption purchase," and warehouse code "B100."

[0062] For the product category, the first line uses the arrival date "2021 / 6 / 14" and product code "S100" as keys, and since the application start date in product master 106b is "2021 / 1 / 1" and the product category is "Purchased item", the product category "Purchased item" is obtained and set. For the second line, the arrival date "2021 / 6 / 14" and product code "S200" as keys, and since the application start date in product master 106b is "2021 / 1 / 1" and the product category is "Consumed purchase item", the product category "Consumed purchase item" is obtained and set.

[0063] For the third line, the arrival date "2021 / 6 / 15" and product code "S100" are used as keys, and since the application start date in product master 106b is "2021 / 1 / 1" and the product category is "Purchased item", the product category "Purchased item" is obtained and set. For the fourth line, the arrival date "2021 / 6 / 15" and product code "S200" are used as keys, and since the application start date in product master 106b is "2021 / 6 / 15" and the product category is "Purchased item", the product category "Purchased item" is obtained and set. In this way, for product code "S200", the product category changes on the application start date.

[0064] Next, the first incoming goods processing unit 102a performs a lump-sum purchase accounting, and for the logistics warehouse incoming goods data, if the product category is a purchased item, it accounts for the purchase, creates purchase data and registers it in the data file 106c, and if the product category is a consumable purchase item, it does not account for the purchase, and does not create purchase data.

[0065] Figure 6(A) shows the data that is subject to lump-sum purchase accounting for logistics warehouse arrival data. If the warehouse is "B100: logistics warehouse" and the product category is "consumption purchases," lump-sum purchase accounting is not performed. In the example shown in Figure 6(A), the second line is not lump-sum purchased because the warehouse is "B100: logistics warehouse" and the product category is "consumption purchases." Lines 1, 3, and 4 have the product category "purchased items," so lump-sum purchase accounting is performed.

[0066] 6B shows an example of purchase data, which includes the following fields: purchase date, product code, product name, purchase quantity, unit price, amount, consumption tax, product category, and warehouse code. In the example shown in Figure 6 (B), the first line contains the purchase date "2021 / 6 / 14," product code "S100," product name "10kg of flour," purchase quantity "10," unit price "10,000," amount "100,000," consumption tax "8,000," product category "Purchased item," and warehouse code "B100."

[0067] FIG. 6(C) shows an example of inventory data (as of June 15, 2021). The inventory inquiry unit 102d can inquire about inventory data in the data file 106c. The inventory data has fields for product code, product name, stock quantity, product category, and warehouse code. In the example shown in the figure, the first line contains the product code "S100", the product name "10 kg of flour", the stock quantity "18", the product category "purchased item", and the warehouse code "B100". Purchased items that have been consumed are not recorded as purchases, but are counted as inventory. Unsorted items are not recorded as payables.

[0068] (S2: Shipping process) The shipping process will be described with reference to Fig. 7. The shipping processing unit 102b creates logistics warehouse shipping data in response to, for example, an operator's operation on a shipping input screen (not shown) displayed on the monitor 114, and registers the data in a data file 106c and transmits the data to the store terminal 400 of the store at the shipping destination.

[0069] FIG. 7(A) is a diagram showing an example of logistics warehouse shipping data. The logistics warehouse shipping data includes the following items: shipping date, product code, product name, shipping quantity, unit price, amount, consumption tax, product category, original product category, and warehouse code. In the example shown in FIG. 7(A), the third line contains the shipping date "2021 / 6 / 18", product code "S200", product name "Salad oil 10L", shipping quantity "10", unit price "20,000", amount "200,000", consumption tax "16,000", product category "Consumed purchase", old product category "Consumed purchase" warehouse code "B100". The product category and old product category are set to be the same.

[0070] (S3: Second receiving process) The second receiving process will be described with reference to Figures 7 and 8. When the second receiving process unit 102c receives a notification from the store terminal 400 that the product in the logistics warehouse shipping data has arrived at the store, it inputs the receiving information, creates store receiving data based on the logistics warehouse shipping data, and registers it in the data file 106c. At that time, it changes the product category from "purchased product" to "purchased product". It also changes the warehouse code from "logistics warehouse: B100" to "store warehouse: T100".

[0071] FIG. 7(B) is a diagram showing an example of store arrival data. Store arrival data includes the following fields: arrival date, product code, product name, arrival quantity, unit price, amount, consumption tax, product category, original product category, and warehouse code. In the example shown in FIG. 7(B), the third line contains the arrival date "2021 / 6 / 18", product code "S200", product name "Salad oil 10L", arrival quantity "10", unit price "20,000", amount "200,000", consumption tax "16,000", product category "Purchased goods", old product category "Consumed purchase goods", and warehouse code "T100". When the goods arrive at the store, the product category is automatically transferred from "Purchased and Consumed Goods" to "Purchased Goods". The old product category remains the same.

[0072] Next, the second receiving processing unit 102c performs a bulk purchase accounting, and for the store receiving data, only those whose original product category is "consumption purchase goods" are included in the purchase accounting, and the purchase data is created and registered in the data file 106c. The second receiving processing unit 102c also updates the inventory data in the data file 106c based on the store receiving data.

[0073] Figure 8(A) shows data that is subject to lump-sum purchase accounting for store arrival data. If the warehouse is "T100: Store warehouse", lump-sum purchase accounting is performed only if the original product category is "Consumed purchases". In the example shown in Figure 8(A), the third line is lump-sum purchased because the warehouse is "T100: Store warehouse" and the old product category is "Consumed purchases", but the first and second lines do not include lump-sum purchase accounting because the old product category is "Purchased goods".

[0074] Figure 8(B) shows an example of purchase data. In the example shown in Figure 8(B), the purchase date is "2021 / 6 / 18", the product code is "S200", the product name is "salad oil 10L", the purchase quantity is "10", the unit price is "20,000", the amount is "200,000", the consumption tax is "16,000", the product category is "purchased goods", the old product category is "consumption purchase goods", and the warehouse code is "T100".

[0075] Figure 8(C) shows an example of inventory data (as of June 18, 2021).

[0076] As described above, according to the purchasing management system 100 of this embodiment, when a product arrives at the logistics warehouse, the product master 106b is referenced to determine whether the product is a consumable purchase or a purchased item based on the arrival date of the product. If the product is a purchased item, it is recorded as a purchased item, and if the product is a consumable purchase, it is not recorded as a purchased item, but is recorded as a purchased item when it arrives at the store. This makes it possible to reduce the workload of the person in charge when consumable products arrive.

[0077] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0078] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of goals 12, 13, and 15 of the SDGs.

[0079] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0080] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0081] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0082] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0083] Furthermore, with regard to the purchase management system 100, the components shown in the figures are merely functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0084] For example, the processing functions of the purchasing management system 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the purchasing management system 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.

[0085] In addition, this computer program may be stored in an application program server connected to the purchase management system 100 via any network, and it is also possible to download all or part of it as needed.

[0086] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0087] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0088] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0089] The purchasing management system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The purchasing management system 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0090] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0091] 100 Purchase Management System 102 Control section 102a First receiving processing section 102b Shipping Department 102c Second receiving processing section 102d Stock Inquiry Section 102e Master Maintenance Department 102f Screen display control unit 104 Communication interface section 106 Storage section 106a Warehouse Master 106b Product master 106c Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A purchasing management system including a control unit, The control unit is The system is configured to be able to access a product master that is registered by associating a product, a product category application start date, and a product category that specifies a consumed purchase or purchased product, A purchasing processing means is provided for, when a commodity arrives at the logistics warehouse, referring to the commodity master, determining whether the commodity is a consumption purchase or a purchased item based on the arrival date of the commodity, and if it is a purchased item, recording it as a purchase, and if it is a consumption purchase, not recording it as a purchase, but recording it as a purchase when the consumption purchase arrives at the store, The purchasing processing means includes: a first arrival processing means for inputting, when an item arrives at the logistics warehouse, logistics warehouse arrival data including the arrival date, item, arrival quantity, unit price, amount, item category, and warehouse, and for setting the item category by obtaining it from the item master using the item and arrival date as keys, and for the logistics warehouse arrival data, if the item category is a purchased item, creating purchase data including the purchase date, item, item name, purchase quantity, unit price, amount, item category, and warehouse, and for a consumed purchased item, not creating purchase data; a shipping processing means for creating logistics warehouse shipping data including a shipping date, product, shipping quantity, unit price, amount, product category, original product category for holding consumed purchases or purchased products designated by the product category when the product is shipped to the store, and a warehouse when the product is shipped to the store, and setting the product category and the original product category to be the same when the product is shipped to the store; A purchasing management system comprising:

2. The purchasing processing means includes: A purchasing management system as described in claim 1, characterized in that when goods arrive at a store, store arrival data including the arrival date, product, quantity arrived, unit price, amount, consumption tax, product category, original product category, and warehouse is created based on the logistics warehouse shipping data, and the product category is automatically transferred to a purchased item if the product category in the logistics warehouse shipping data is a consumed purchase item, and purchasing data is created only for those store arrival data whose original product category is a consumed purchase item.

3. 3. The purchasing management system according to claim 1, wherein the stores include stores of a company that operates multiple stores.

4. A purchase management method executed by an information processing device having a control unit, The control unit is The system is configured to be able to access a product master that is registered by associating a product, a product category application start date, and a product category that specifies a consumed purchase or purchased product, The control unit executes: When a commodity arrives at the logistics warehouse, the commodity master is referred to, and based on the arrival date of the commodity, it is judged whether the commodity is a consumption purchase or a purchase item, and if it is a purchase item, it is recorded as a purchase item, and if it is a consumption purchase item, it is not recorded as a purchase item, and the consumption purchase item is recorded as a purchase item when it arrives at the store, The purchasing process step includes: a first receiving processing step in which, when goods arrive at the logistics warehouse, logistics warehouse receiving data including the receiving date, goods, number of goods received, unit price, amount, goods category, and warehouse is input, the goods category is obtained and set from the goods master using the goods and the receiving date as keys, and for the logistics warehouse receiving data, if the goods category is a purchased goods, purchase data including the purchase date, goods, goods name, number of goods purchased, unit price, amount, goods category, and warehouse is created, and if the goods category is a consumed purchased goods, purchase data is not created; a shipping process step of creating logistics warehouse shipping data including a shipping date, product, shipping quantity, unit price, amount, product category, original product category for holding consumed purchases or purchased products designated by the product category when the product is shipped to the store, and a warehouse when the product is shipped to the store, and setting the product category and the original product category to be the same when the product is shipped to the store; A purchasing management method comprising:

5. A purchase management program to be executed by an information processing device having a control unit, The control unit is The system is configured to be able to access a product master that is registered by associating a product, a product category application start date, and a product category that specifies a consumed purchase or purchased product, The control unit, a purchase management program for executing a purchase processing step in which, when a commodity arrives at a logistics warehouse, the commodity master is referenced, and it is determined based on the arrival date of the commodity whether the commodity is a consumption purchase or a purchase item, and if the commodity is a purchase item, the purchase is recorded as a purchase item, and if the commodity is a consumption purchase item, the purchase is not recorded as a purchase item, and the consumption purchase item is recorded as a purchase item when it arrives at a store, The purchasing process step includes: a first receiving processing step in which, when goods arrive at the logistics warehouse, logistics warehouse receiving data including the receiving date, goods, number of goods received, unit price, amount, goods category, and warehouse is input, the goods category is obtained and set from the goods master using the goods and the receiving date as keys, and for the logistics warehouse receiving data, if the goods category is a purchased goods, purchase data including the purchase date, goods, goods name, number of goods purchased, unit price, amount, goods category, and warehouse is created, and if the goods category is a consumed purchased goods, purchase data is not created; a shipping process step of creating logistics warehouse shipping data including a shipping date, product, shipping quantity, unit price, amount, product category, original product category for holding consumed purchases or purchased products designated by the product category when the product is shipped to the store, and a warehouse when the product is shipped to the store, and setting the product category and the original product category to be the same when the product is shipped to the store; A purchasing management program comprising:

Images