JP2023114380A - Purchase management system, method for managing purchase, and purchase management program - Google Patents

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

The present invention relates to a purchase management system, a purchase management method, and a purchase management program.

For example, there are two types of product purchases: consumption purchases and purchase purchases. Depending on the product, it is determined whether it is a purchased product or a purchased product, but the person in charge has to change the work content for each attribute of the product, so the workload is heavy and the work efficiency is poor. Conventionally, there is Patent Document 1, for example, as a system related to digestion and stocking.

Japanese Unexamined Patent Application Publication No. 2004-21489

However, Patent Literature 1 does not describe anything about reducing the work load of the person in charge when the digested products arrive.

The present invention has been made in view of the above, and provides a purchase management system, a purchase management method, and a purchase management program that can reduce the work burden on the person in charge when consumed products arrive. intended to provide

In order to solve the above-described problems and achieve the object, the present invention provides a purchase management system comprising a control unit, wherein the control unit controls a product, an application start date of a product classification, a stocked product, or It is configured to allow access to the product master registered in association with the product classification that specifies the purchased product. Judging whether it is a purchased product or a purchased product, if it is a purchased product, it will be recorded as a purchase, and if it is a purchased product, it will not be recorded as a purchase. It is characterized by comprising a purchase processing means for recording the purchase in the purchase.

In addition, according to one aspect of the present invention, the purchase processing means, when goods arrive at the distribution warehouse, stores goods received at the distribution warehouse, including arrival date, goods, number of goods received, unit price, price, product category, and warehouse. , and the product classification is set by obtaining from the product master using the product and arrival date as keys. Purchasing data including name, number of purchases, unit price, amount of money, product classification, and warehouse may be created, and in the case of purchased goods in consumption, a first arrival processing means may be included which does not create purchase data. .

In addition, according to one aspect of the present invention, the purchase processing means, when shipping products to a store, stores a distribution data including shipping date, product, number of shipments, unit price, amount, product classification, source product classification, and warehouse. A shipping processing means may be included that creates warehouse shipping data and sets the product classification and the original product classification to be the same.

In addition, according to one aspect of the present invention, when merchandise arrives at a store, the purchase processing means, based on the distribution warehouse shipping data, stores the date of arrival, merchandise code, merchandise name, quantity of merchandise received, unit price, Create store arrival data including amount, consumption tax, product classification, original product classification, and warehouse, and automatically transfer the relevant product classification to purchased goods if the product classification of the distribution warehouse shipping data is a purchased item. The store receipt data may include a second receipt processing means for creating purchase data only for items whose original product category is the consumption purchase item.

Moreover, according to one aspect of the present invention, the store may include a store of a company operating multiple stores.

Further, in order to solve the above-described problems and achieve the object, the present invention provides a purchase management method executed by an information processing apparatus having a control unit, wherein It is configured to allow access to a product master registered in association with the application start date, the product category specifying the purchased product or purchased product, and is executed by the control unit when the product arrives at the distribution warehouse. By referring to the product master, based on the arrival date of the product, it is determined whether it is a purchased product or a purchased product. It is characterized by including a purchase processing step in which purchases are not recorded as purchases, but purchases are recorded as purchases when the purchased products are received at the store.

Further, according to one aspect of the present invention, the present invention is a purchase management program to be executed by an information processing apparatus having a control unit, wherein the control unit controls a product, an application start date of product classification, It is configured to be able to access a product master registered in association with a product category designating purchased products or purchased products, and the control unit refers to the product master when products arrive at the distribution warehouse. , based on the arrival date of the product, determine whether it is a purchased product or a purchased product, and if it is a purchased product, record it as a purchase. It is characterized by being a purchase management program for executing a purchase processing step of recording purchases when purchased goods are delivered to a store.

ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to reduce the work burden of the person in charge at the time of the arrival of digested goods.

FIG. 1 is a block diagram showing an example of the configuration of a purchase management system according to this embodiment. FIG. 2 is a diagram showing a configuration example of a warehouse master. FIG. 3 is a diagram showing a configuration example of a product master. FIG. 4 is a diagram showing a flow for explaining an outline of the overall processing of the control unit of the purchase management system according to this embodiment. FIG. 5 is a diagram for explaining a specific example of processing of the control unit of the purchase management system according to the present embodiment. FIG. 6 is a diagram for explaining a specific example of processing of the control unit of the purchase management system according to the present embodiment. FIG. 7 is a diagram for explaining a specific example of processing of the control unit of the purchase management system according to the present embodiment. FIG. 8 is a diagram for explaining a specific example of processing of the control unit of the purchase management system according to the present embodiment.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. overview]
For example, in the food service industry, there is a management form called consumption purchases, and there are cases where even if goods arrive at the warehouse, they are not purchased. Consumed purchases remain the assets of the supplier when they arrive at the warehouse, and are recorded as purchases when they arrive at stores. Purchased items are treated as company assets when they arrive at the warehouse, and are recorded as purchases. For example, seasonal items are exclusive items, so they are purchased when they arrive at the warehouse and are purchased. Here, "seasonal items" refer to items such as Christmas-colored wrapping paper that are available only in a specific season. The “dedicated product” is a product specially ordered by the company, such as a product with a logo.

However, conventionally, on the distribution side, the person in charge needs to change the work content for each attribute of the product.

Therefore, in the present invention, in order to allow the worker to proceed with the process without making any particular judgments when goods are received at the distribution warehouse and when goods are received at the store, the goods master is used so that the goods received at the distribution warehouse are the digested stocks. Alternatively, it automatically determines whether it is a purchased product, and does not record the purchase when it arrives at the distribution warehouse for the purchased product. It is structured so that it is accounted for, and store receipts are treated as inventory movements.

As a result, the person in charge of distribution and stores will be able to carry out processing regardless of the attribute of the product (whether it is a purchased product or a consumable product), making it possible to improve work efficiency.

The purchase management system of the present invention can be widely applied to industries such as companies operating multiple stores, for example.

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

The purchase management system 100 is a commercially available desktop personal computer. It should be noted that the purchase management system 100 is not limited to a stationary information processing device such as a desktop personal computer, but can also be used in mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smart phones, and tablet personal computers. type information processing device.

The purchase management system 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the purchase management system 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the purchase 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 another device via a communication line. Here, the network 300 has a function of connecting the purchase management system 100, 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 .

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As 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, and optical disks can be used.

The storage unit 106 also includes a warehouse master 106a, a product master 106b, and a data file 106c. FIG. 2 is a diagram showing a configuration example of the warehouse master 106a. FIG. 3 is a diagram showing a configuration example of the product master 106b.

As shown in FIG. 2, the warehouse master 106a can be composed of a table or the like in which warehouse codes, warehouse names, and warehouse divisions are associated and registered.

The product master 106b, as shown in FIG. 3, consists of a table or the like in which product codes, product names, application start dates for applying product categories, and product categories specifying purchased products or purchased products are associated and registered. can be done.

The data file 106c is a file for storing distribution warehouse receipt data, purchase data, inventory data, distribution warehouse shipment data, store receipt data, and the like.

The distribution warehouse arrival data may include arrival date, product code, product name, number of arrivals, unit price, amount, consumption tax, product classification, and warehouse code. The product classification is set by referring to the product master 106a, using the product and arrival date as keys, and referring to the application start date and product classification of the product master 106b to obtain the product classification. For the warehouse code, the warehouse code of the distribution warehouse is set by referring to the warehouse master 106a.

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

The inventory data may include product code, product name, inventory quantity, product category, and warehouse code.

The distribution warehouse shipping data may include shipping date, product code, product name, number of shipments, unit price, amount, consumption tax, product classification, original product classification, and warehouse code.

Store arrival data may include arrival date, product code, product name, number of arrivals, unit price, amount, consumption tax, product classification, original product classification, and warehouse code. As for the warehouse code, the warehouse code of the store is set by referring to the warehouse master 106a.

Returning to FIG. 1, the control unit 102 is a CPU or the like that controls the purchase management system 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 is configured to be able to access a warehouse master 106a, a product master 106b, and a data file 106c stored in the storage unit 106. FIG. Note that these master files may be provided in another location (for example, the server 200) as long as the control unit 102 can access them.

The control unit 102 functionally and conceptually includes a first arrival processing unit 102a, a shipment processing unit 102b, a second arrival processing unit 102c, an inventory inquiry unit 102d, a master maintenance unit 102e, and a screen display control unit. 102f and.

The first receipt processing unit 102a, the shipment processing unit 102b, and the second receipt processing unit 102c refer to the merchandise master 106b when merchandise arrives at the warehouse, and perform digestion processing based on the arrival date of the merchandise. Determine whether it is a purchased item or a purchased item, and if it is a purchased item, record it as a purchase. Configure purchase processing means for recording purchases.

The first receipt processing unit 102a updates the warehouse master 106a and the merchandise master 106b in response to an operator's operation on an input screen (not shown) displayed on the monitor 114 when merchandise arrives at the warehouse. By referring to it, create distribution warehouse arrival data including arrival date, product (product code and/or product name), number of arrivals, unit price, amount, product classification, warehouse (warehouse code and/or warehouse name), and save the data Register in file 106c. The product category is obtained and set by referring to the application start date and product category in the product master 106b using the product and arrival date as keys. For the warehouse code, the warehouse code of the distribution warehouse is set by referring to the warehouse master 106a. Also, the first receipt processing unit 102a updates the inventory data in the data file 106c based on the distribution warehouse receipt data.

In addition, for example, the first receipt processing unit 102a responds to an operator's operation on an input screen (not shown) displayed on the monitor 114, regarding the distribution warehouse receipt data, if the product classification is a purchased product, , the purchase is accounted for, and purchase data including purchase date, product (product code and/or product name), purchase quantity, unit price, amount, product classification, and warehouse code is created and registered in the data file 106c. , If the product classification is consumable purchases, purchases are not recorded and purchase data is not created.

When shipping products to a store, the shipping processing unit 102b, for example, according to an operator's operation on an input screen (not shown) displayed on the monitor 114, stores the shipping date, product (product code and/or product name), the number of shipments, the unit price, the amount of money, the product category, the source product category, and the warehouse code. The product classification and the original product classification shall be the same.

The products in the distribution warehouse shipping data are transported from the distribution warehouse to the store. Also, the shipment processing unit 102b updates the inventory data in the data file 106c based on the distribution warehouse shipment data. The store terminal 400 notifies the purchase management system 100 (the second receipt processing unit 102c) of the arrival of the merchandise of the distribution warehouse shipping data to the store.

When the second arrival processing unit 102c receives a notification from the store terminal 400 that the product of the distribution warehouse shipping data has arrived at the store, the second arrival processing unit 102c calculates the arrival date, product (product code and/or product code) based on the distribution warehouse shipping data. name), number of arrivals, unit price, amount, product category, original product category, and warehouse code, and register it in the data file 106c. At that time, if the product classification of the distribution warehouse shipping data is "purchased goods", it is automatically transferred to "purchased goods".

In addition, the second receipt processing unit 102c accounts for the purchase only for store receipt data whose source product category is "consumed purchase", creates purchase data, and registers the data in the data file 106c. do. Also, the second arrival processing unit 102c updates the inventory data in the data file 106c based on the store arrival data.

The inventory inquiry unit 102d, for example, inquires the inventory data registered in the data file 106c according to the operator's operation on the inventory inquiry screen displayed on the monitor 114. FIG.

For example, 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 accordance with the operator's operation on the master maintenance screen displayed on the monitor 114. I do.

The screen display control unit 102f controls the display and input of various screens (for example, receipt entry screen, shipment screen, purchase entry screen, inventory inquiry screen, master maintenance screen, etc.) displayed on the monitor 114 .

[3. Concrete example]
A specific example of the processing of the purchase management system 100 according to the present embodiment will be described with reference to FIGS. 1 to 8. FIG. First, with reference to FIG. 4, an outline of the overall processing of the purchase management system 100 according to the present embodiment will be described. FIG. 4 is a diagram showing a flow for explaining an overview of the overall processing of the purchase management system 100 according to this embodiment. In the following explanation, the units of all amounts are assumed to be "yen", and the notation thereof is omitted.

In FIG. 4, when merchandise arrives at the distribution warehouse, the first arrival processing unit 102a executes first arrival processing (step S1). Specifically, in the first arrival processing, the first arrival processing unit 102a performs arrival input, for example, according to the operator's operation on an input screen (not shown) displayed on the monitor 114, By referring to the warehouse master 106a and the product master 106b, distribution warehouse arrival data is created and registered in the data file 106c. The product category is obtained and set by referring to the application start date and product category in the product master 106b using the product and arrival date as keys. For the warehouse code, the warehouse code of the distribution warehouse is set by referring to the warehouse master 106a. Also, the first receipt processing unit 102a updates the inventory data in the data file 106c based on the distribution warehouse receipt data.

Next, in the first receipt processing, the first receipt processing unit 102a performs bulk purchase accounting. Data is created and registered in the data file 106c, and if the product category is the consumption purchase product, the purchase is not accounted for and the purchase data is not created.

The shipping processing unit 102b executes shipping processing (step S2). Specifically, in the shipping process, the shipping processing unit 102b creates distribution warehouse shipping data according to an operator's operation or the like on an input screen (not shown) displayed on the monitor 114, and stores the data in the data file. 106c and transmits to the shop terminal 400 of the shop of the shipping destination. The products in the distribution warehouse shipping data are transported from the distribution warehouse to the store. Also, the shipment processing unit 102b updates the inventory data in the data file 106c based on the distribution warehouse shipment data. The store terminal 400 notifies the purchase management system 100 (the second receipt processing unit 102c) of the arrival of the merchandise of the distribution warehouse shipping data to the store.

The second arrival processing unit 102c executes second arrival processing (step S3). Specifically, in the second arrival processing, when the second arrival processing unit 102c receives a notification from the store terminal 400 that the merchandise of the distribution warehouse shipping data has arrived at the store, it performs arrival input, Based on the shipping data, store receipt data is created and registered in the data file 106c. At that time, the product classification is changed from "purchased goods" to "purchased goods". Also, the warehouse code is changed from "distribution warehouse: B100" to "store warehouse: T100".

In addition, in the second receipt processing, the second receipt processing unit 102c performs batch purchase accounting, and regarding the store receipt data, purchases are accounted only for those items whose original product category is "purchased goods". Then, purchase data is created and registered in the data file 106c. Also, the second arrival processing unit 102c updates the inventory data in the data file 106c based on the store arrival data.

(3-2. Sample data)
5 to 8 are diagrams showing sample data for explaining specific examples of processing of the control unit 102 of the purchase management system 100 according to the present embodiment. A specific example of the processing of the control unit 102 of the purchase management system 100 according to the present embodiment will be described with reference to FIGS. 5 to 8. FIG.

(S1: First shipping process)
The first shipping process will be described with reference to FIGS. 5 and 6. FIG. The first receipt processing unit 102a performs receipt input, for example, refers to the warehouse master 106a and the product master 106b in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, The distribution warehouse receipt data is created and registered in the data file 106c. Also, the first receipt processing unit 102a updates the inventory data in the data file 106c based on the distribution warehouse receipt data.

FIG. 5A shows an example of data of the warehouse master 106a, FIG. 5B shows an example of data of the product master 106b, and FIG.

The warehouse master 106a, as shown in FIG. 5A, has items of warehouse code, warehouse name, and warehouse division. In the example shown in FIG. 5A, the first line is the warehouse code "B100", the warehouse name is "distribution warehouse", the warehouse category is "warehouse", and the second line is the warehouse code "T100", the warehouse name is "store warehouse". ”, and the warehouse division is “store”.

As shown in FIG. 5(B), the product master 106b has items of product code, product name, application start date to which the product category is applied, and product category specifying purchased product or consumption purchase product. In the example shown in FIG. 5B, the first line is the product code "S100", the product name "flour 10 kg", the application start date "2021/1/1", the product classification "purchased product", and the second line is , product code "S200", product name "salad oil 10L", application start date "2021/1/1", product category "consumer stock", the third line is the product code "S200", product name "salad oil 10L" ”, the application start date is “2021/6/15”, and the product category is “purchased product”. For the product "S200: Salad oil 10L", the product classification "purchased goods for consumption" will be applied from "2021/1/1", and the product classification will be changed to "purchased goods" from "2021/6/15".

As shown in FIG. 5(C), the distribution warehouse arrival data includes the items of arrival date, product code, product name, number of arrivals, unit price, amount, consumption tax, product category, and warehouse code. The product classification is set by referring to the product master 106b, using the product code and arrival date as keys, and referring to the application start date and product classification of the product master 106b to acquire and set the product classification. For the warehouse code, the warehouse code "B100" of the distribution warehouse is set by referring to the warehouse master 106a.

In the example of the distribution warehouse receipt data shown in FIG. 5(C), the second line has the date of receipt "2021/6/14", the product code "S200", the product name "salad oil 10L", the number of arrivals "10", and the unit price. "20,000", amount of money "200,000", consumption tax "16,000", product classification "consumer stock", warehouse code "B100".

As for the product classification, the first row uses the arrival date "2021/6/14" and the product code "S100" as keys, the application start date "2021/1/1" of the product master 106b, and the product classification "purchased product". Therefore, the product category “Purchased product” is acquired and set. For the second line, the product master 106b uses the date of arrival “June 14, 2021” and the product code “S200” as keys, and the application start date “January 1, 2021” and the product classification “purchased goods”. Therefore, obtain and set the product category "Consumed purchases".

As for the third line, the arrival date "2021/6/15", the product code "S100" as a key, the application start date "2021/1/1" of the product master 106b, and the product classification "purchased product". Therefore, acquire and set the product category “purchased product”. For the fourth line, the arrival date "2021/6/15" and the product code "S200" are used as keys, and in the product master 106b, the application start date is "2021/6/15" and the product classification is "purchased product". Therefore, acquire and set the product category “purchased product”. In this way, for the product code "S200", the product category is switched according to the application start date.

Next, the first receipt processing unit 102a performs collective purchase accounting, and regarding the receipt data at the distribution warehouse, if the product category is a purchased item, the purchase is accounted for, purchase data is created, and a data file is created. 106c, and if the product category is a consumption purchase, the purchase is not accounted for and purchase data is not created.

FIG. 6(A) shows data to be collectively accounted for purchases in the distribution warehouse receipt data. If the warehouse is "B100: distribution warehouse" and the product category is "consumed purchases", purchases are not included in the lump sum purchase. In the example shown in FIG. 6A, in the second row, the warehouse is "B100: distribution warehouse" and the product classification is "consumed purchases", so purchases are not recorded collectively. Lines 1, 3, and 4 are classified as "purchased goods", so they are collectively accounted for.

FIG. 6B shows an example of purchase data. The purchase data includes the items of purchase date, product code, product name, purchase quantity, unit price, amount, consumption tax, product classification, and warehouse code.
In the example shown in FIG. 6B, the first row contains the purchase date "2021/6/14", the product code "S100", the product name "flour 10 kg", the purchase quantity "10", and the unit price "10, 000", amount "100,000", consumption tax "8,000", product category "purchased product", warehouse code "B100".

FIG. 6C shows an example of inventory data (as of June 15, 2021). The inventory inquiry unit 102d can inquire the inventory data of the data file 106c. The inventory data includes the items of product code, product name, inventory quantity, product category, and warehouse code. In the example shown in the figure, the first line has the product code "S100", the product name "flour 10 kg", the inventory quantity "18", the product category "purchased product", and the warehouse code "B100". Consumed purchases are not counted as purchases, but are counted as inventory. Unfinished work is not accounted for as a liability.

(S2: shipping processing)
The shipping process will be described with reference to FIG. For example, the shipment processing unit 102b creates distribution warehouse shipment data in response to an operator's operation on a shipment input screen (not shown) displayed on the monitor 114, registers it in the data file 106c, and sets the shipment destination. to the store terminal 400 of the store.

FIG. 7A is a diagram showing an example of distribution warehouse shipping data. The distribution warehouse shipping data includes items of shipping date, product code, product name, number of shipments, unit price, amount, consumption tax, product classification, original product classification, and warehouse code. In the example shown in FIG. 7(A), the third line contains the shipping date "2021/6/18", the product code "S200", the product name "salad oil 10L", the number of shipments "10", and the unit price "20,000". , amount “200,000”, consumption tax “16,000”, product category “consumption purchase”, old product category “consumption purchase” warehouse code “B100”. Set the product classification and the old product classification to be the same.

(S3: Second receipt processing)
The second receipt processing will be described with reference to FIGS. 7 and 8. FIG. When receiving a notification from the store terminal 400 that the product of the distribution warehouse shipping data has arrived at the store, the second arrival processing unit 102c performs reception input and creates store arrival data based on the distribution warehouse shipping data. and register it in the data file 106c. At that time, the product category will be changed from "purchased goods" to "purchased goods". Also, the warehouse code is changed from "distribution warehouse: B100" to "store warehouse: T100".

FIG. 7B is a diagram showing an example of store arrival data. The store arrival data includes the items of arrival date, product code, product name, number of products received, unit price, amount, consumption tax, product classification, original product classification, and warehouse code. In the example shown in FIG. 7(B), the third line contains the arrival date "2021/6/18", the product code "S200", the product name "salad oil 10L", the number of arrivals "10", and the unit price "20,000". , amount "200,000", consumption tax "16,000", product category "purchased product", old product category "purchased goods for consumption", warehouse code "T100". At the time of arrival at the store, the product classification is automatically transferred from "purchased goods" to "purchased goods". The old product categories remain unchanged.

Next, the second incoming goods processing unit 102c performs collective purchase accounting, and, with respect to the store incoming goods data, only those whose original product category is "consumed purchased goods" are recorded as purchases, and the purchase data is recorded. created and registered in the data file 106c. Also, the second arrival processing unit 102c updates the inventory data in the data file 106c based on the store arrival data.

FIG. 8(A) shows data to be collectively recorded for purchases in store arrival data. If the warehouse is "T100: store warehouse", purchases are recorded collectively only if the original product category is "consumed purchases". In the example shown in FIG. 8A, in the third line, the warehouse is "T100: store warehouse" and the old product classification is "purchased goods for consumption", so purchases are recorded collectively. Lines 1 and 2 are not included in bulk purchases because the old product classification is "purchased goods".

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

FIG. 8C shows an example of inventory data (as of June 18, 2021).

As described above, according to the purchase management system 100 of the present embodiment, when a product arrives at the distribution warehouse, the product master 106b is referred to, and based on the date of arrival of the product, the purchased product is determined. If it is a purchased product, it is recorded as a purchase, and if it is a purchased product, it is not recorded as a purchase. Since it is decided to record it, it is possible to reduce the work burden on the person in charge when the digested product arrives.

[4. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the purchase management system 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the purchase management system 100, particularly the processing functions performed by the control unit, are implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and purchase management is performed as necessary. It is read mechanically by system 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

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 possible to download all or part of it as necessary. is.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc, etc. shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single structure, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage 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. It stores programs, tables, databases, files for web pages, and so on.

The purchase 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 arbitrary peripheral devices are connected. Also, the purchase management system 100 may be implemented by installing software (including programs, data, etc.) that implements the processing described in the present embodiment in the device.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

100 purchase management system 102 control unit 102a first arrival processing unit 102b shipment processing unit 102c second arrival processing unit 102d inventory inquiry unit 102e master maintenance unit 102f screen display control unit 104 communication interface unit 106 storage unit 106a warehouse master 106b Product master 106c data file 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (7)

A purchase management system comprising a control unit,
The control unit
It is configured so that you can access the product master registered in association with the product, the application start date of the product category, and the product category that specifies the purchased product or purchased product.
When a product arrives at the distribution warehouse, the product master is referred to, and based on the arrival date of the product, it is determined whether it is a purchased product or a purchased product. A purchase management system characterized by comprising purchase processing means for recording purchases when the purchased goods are delivered to a store without registering them as purchases if they are purchased goods for consumption. The purchase processing means
When a product arrives at the distribution warehouse, input the arrival date, product, number of arrivals, unit price, amount, product category, and warehouse arrival data. Acquired from the master and set, for the relevant distribution warehouse arrival data, if the product classification is purchased goods, the purchase date, product, product name, purchase quantity, unit price, amount, product classification, and warehouse purchase 2. The purchase management system according to claim 1, further comprising a first receipt processing means that prepares data and does not prepare purchase data in the case of purchased goods that have been consumed. The purchase processing means
When shipping products to stores, create distribution warehouse shipping data including shipping date, product, number of shipments, unit price, amount, product classification, original product classification, warehouse, and assume that the product classification and the original product classification are the same. 3. The purchase management system according to claim 2, further comprising means for processing shipments. The purchase processing means
When the product arrives at the store, based on the distribution warehouse shipping data, create store arrival data including arrival date, product, number of arrivals, unit price, amount, consumption tax, product classification, original product classification, warehouse, If the product classification of the distribution warehouse shipping data is consumable purchase goods, the product classification is automatically transferred to purchased goods, and for the above-mentioned store arrival data, only those whose original product classification is consumable purchase goods are purchased. 4. The purchase management system according to claim 3, further comprising second receipt processing means for creating data. 5. The purchase management system according to any one of claims 1 to 4, wherein the stores include stores of a company operating multiple stores. A purchase management method executed by an information processing device having a control unit,
The control unit
It is configured so that you can access the product master registered in association with the product, the application start date of the product category, and the product category that specifies the purchased product or purchased product.
Executed in the control unit,
When a product arrives at the distribution warehouse, the product master is referred to, and based on the arrival date of the product, it is determined whether it is a purchased product or a purchased product. A purchase management method characterized by including a purchase processing step of not recording purchases in the case of consumption purchases, but recording purchases when the consumption purchases are received at a store. A purchase management program to be executed by an information processing device having a control unit,
The control unit
It is configured so that you can access the product master registered in association with the product, the application start date of the product category, and the product category that specifies the purchased product or purchased product.
In the control unit,
When a product arrives at the distribution warehouse, the product master is referred to, and based on the arrival date of the product, it is determined whether it is a purchased product or a purchased product. A purchase management program for executing a purchase processing step in which purchases are recorded when the purchased goods are received at a store without being recorded as purchases when the purchased goods are consumed at stores.

Images