JP6678855B1 - Inventory management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: There is a problem that it is time-consuming to inspect a delivered package when the package is received. An object of the present invention is to provide an inventory management system that can reduce the trouble of receiving and shipping. The present invention provides an inventory information storage unit that stores inventory information of a first user, an arrival schedule data generation unit that generates arrival schedule data from at least package identification information and shipping information, and a first weight data of the package. A first weight data acquisition unit to acquire, a determination unit that determines whether or not the first weight data satisfies a predetermined condition, and the determination unit determines that the first weight data satisfies a predetermined condition. If it is determined that there is a stock arrival data generation unit that converts the planned arrival data into the received data, and inventory information that is converted to inventory information for updating the inventory information storage unit based on the received data An inventory management system is provided, which comprises: a generation unit. [Selection diagram] FIG.

Description

  The present invention relates to an inventory management system.

  2. Description of the Related Art Conventionally, inventory management in a company or a store is complicated, and a system for simplifying operations related to receiving and shipping has been proposed. For example, Patent Literature 1 discloses an invention related to a method for reducing labor in stocktaking, which has a total weight measuring unit for articles and calculates the number of articles from the total weight to determine the actual stock quantity. Have been.

JP 2004-20462 A

  By the way, there is a problem that it is necessary to inspect the delivered baggage when the baggage is received, which is troublesome. In addition, there is a problem that seamless exchange of data is not possible because information on packages and their contents uses different formats of data, for example, because the companies on the shipping side and the receiving side use different companies. Was.

  Therefore, an object of the present invention is to provide an inventory management system that can reduce labor for receipt and shipment.

In order to solve the above problems, according to a first aspect of the present invention, as described in claim 1, a stock information storage unit for storing stock information of a first user, and at least package identification information and shipping information An arrival data generation unit that generates arrival data from information, a first weight data acquisition unit that acquires first weight data of the package, and whether the first weight data satisfies a predetermined condition. A determination unit that determines, when the determination unit determines that the first weight data satisfies a predetermined condition, the received data generation unit that converts the planned arrival data into received data, A stock information generating unit for converting the stock information storage unit into stock information for updating based on the received data. According to this configuration, a simple inspection can be performed by making a determination based on the first weight data, the labor involved in the inspection can be reduced, and the received data can be seamlessly stored in the inventory information. It can be reflected in the storage unit.

According to a second aspect of the present invention, in order to solve the above problem, as described in claim 2, the arrival schedule data includes a second weight data acquisition unit before shipment of the package. The second weight data acquired by the first weight data, the determination unit performs the determination by comparing the difference between the first weight data and the second weight data, Inventory management system is provided. According to this configuration, the determination can be made from the relationship between the first weight data and the second weight data before shipment, and the inspection can be performed easily and with a certain degree of certainty.

To solve the above problem, according to a third aspect of the present invention, as described in claim 3, the determination unit calculates an estimated weight of the package based on the shipping information, An inventory management system is provided, wherein the determination is made by comparing the first weight data with the estimated weight. According to this configuration, the determination can be made from the relationship between the estimated weight based on the shipping information and the first weight data, and the inspection can be easily performed even when the weight data before shipping is not available. Can be.

According to a fourth aspect of the present invention, to solve the above-described problem, product information used by a second user shipping the package as described in claim 4; An inventory management system is further provided, further comprising a commodity / article correspondence unit for associating the commodity information with the commodity information. According to a fifth aspect of the present invention, as described in claim 5, the correspondence between the product information used by the second user shipping the package and the article information used by the first user And a correspondence information storage unit for storing the commodity information and the commodity information based on the information stored in the correspondence information storage unit. Is provided. According to a sixth aspect of the present invention, as described in claim 6, the shipping information includes image data of a product, and the product / article corresponding unit analyzes the image, An inventory management system is provided, wherein the merchandise information included in the shipping information is associated with the article information included in the inventory information storage unit. Further, according to a seventh aspect of the present invention, as described in claim 7, the commodity / article correspondence section includes at least a name, an increase / decrease in a handling quantity, and a type / attribute of another handling commodity / article. An inventory management system is provided, wherein the merchandise information is associated with the article information by calculating one or more similarities. According to such a configuration, even when the first user and the second user have different names or IDs indicating the same article, mutual data can be converted smoothly.

According to an eighth aspect of the present invention, there is provided an accounting information generating unit for generating accounting information based on the received data according to an eighth aspect of the present invention. An inventory management system is provided. According to such a configuration, it is possible to easily generate the accounting information when the inspection is completed, and it is possible to save the trouble of the accounting person.

According to a ninth aspect of the present invention, as described in claim 9, the stock information storage unit stores at least a stock quantity and an order condition for each article, and satisfies the order condition. An inventory management system further comprising an alert information generation unit that generates predetermined alert information for an article. According to such a configuration, it is not necessary to constantly monitor articles whose stock has decreased.

According to a tenth aspect of the present invention, in order to solve the above-described problem, the alert information is provided to a supplier of the article, as described in claim 10. An inventory management system is provided. Further, according to an eleventh aspect of the present invention, as set forth in claim 11, an ordered data generation unit that generates ordered data relating to an article satisfying the order condition based on the alert information. An inventory management system is provided, further comprising: According to such a configuration, the supplier can grasp the stock status of the business partner, and can save each other's trouble in ordering.

  ADVANTAGE OF THE INVENTION According to the inventory management system of this invention, the labor of receipt / shipment can be reduced.

FIG. 1 is a diagram illustrating a configuration example of a system according to an embodiment of the present invention. FIG. 1 is a hardware configuration diagram of a system according to an embodiment of the present invention. It is a functional block diagram of a system by an embodiment of the invention. 4 is an example of stock information stored in a stock information storage unit 130. It is an example of arrival information stored in the arrival information storage unit 140. It is an example of shipping information stored in a shipping information storage unit 160. It is an example of article information stored in the article information storage unit 150. 5 is an operation flow according to the embodiment of the present invention. It is an example of received data-arrival schedule data. It is another example of received data-arrival schedule data.

The contents of the embodiment of the present invention will be listed and described. The present invention has the following configuration.
[Item 1]
A stock information storage unit for storing stock information of the first user;
An arrival schedule data generating unit that generates arrival schedule data from at least package identification information and shipping information;
A first weight data acquisition unit for acquiring first weight data of the package,
A determining unit that determines whether the first weight data satisfies a predetermined condition,
When the determination unit determines that the first weight data satisfies a predetermined condition, the received data generation unit that converts the planned arrival data into received data,
A stock information generating unit that converts the stock information into stock information for updating the stock information storage unit based on the received data;
An inventory management system, comprising:
[Item 2]
The arrival schedule data includes second weight data obtained by the second weight data obtaining unit before shipment of the package,
The inventory management system according to item 1, wherein the determination unit performs the determination by comparing a difference between the first weight data and the second weight data.
[Item 3]
The determination unit calculates an estimated weight of the package based on the shipping information,
3. The inventory management system according to item 1 or 2, wherein the determination is performed by comparing the first weight data with the estimated weight.
[Item 4]
Product information used by a second user shipping the package, and a product / article corresponding unit that associates product information used by the first user,
The inventory management system according to any one of Items 1 to 3, characterized in that:
[Item 5]
Product information used by a second user shipping the package, and a correspondence information storage unit that stores a correspondence relationship between article information used by the first user,
The product / article correspondence unit associates the product information with the product information based on information stored in the correspondence information storage unit.
Item 4. The inventory management system according to Item 4,
[Item 6]
The shipping information includes image data of a product,
The inventory management according to item 5, wherein the commodity / article correspondence unit associates the commodity information included in the shipping information with the commodity information included in the inventory information storage unit by analyzing the image. system.
[Item 7]
The product / article correspondence unit calculates at least the similarity of at least the name, the increase / decrease of the handling quantity, and the type / attribute of the other handling products / articles,
Characterized by associating the product information and the article information,
Item 4. The inventory management system according to item 4.
[Item 8]
The inventory management system according to any one of items 1 to 7, further comprising an accounting information generation unit that generates accounting information based on the received data.
[Item 9]
The inventory information storage unit stores at least inventory quantities and order conditions for each article,
9. The inventory management system according to any one of items 1 to 8, further comprising an alert information generation unit that generates predetermined alert information for an article that satisfies the order condition.
[Item 10]
The inventory management system according to item 9, wherein the alert information is provided to a supplier of the article.
[Item 11]
12. The inventory management system according to item 11, further comprising an ordered data generation unit that generates ordered data relating to an article satisfying the order condition based on the alert information.

<Details of Embodiment>
Hereinafter, embodiments of the present invention will be described with reference to the drawings.

  As shown in FIG. 1, an inventory management system 1 of the present invention executes information processing via communication with a first user terminal 2 and a second user terminal 3. The inventory management system 1 may be a general-purpose computer such as a workstation or a personal computer, or may be logically realized by cloud computing. It is assumed that the inventory management system 1 executes these functions as a so-called Web application.

  The first user terminal 2 and the second user terminal 3 use the service by executing information processing via communication with the inventory management system 1. Each of the first user terminal 2 and the second user terminal 3 may be a general-purpose computer such as a workstation or a personal computer, or may be a mobile communication device such as a smartphone.

  FIG. 2 is a diagram illustrating an example of a hardware configuration of the inventory management system 1. The inventory management system 1 includes at least a control unit 10, a memory 11, a storage 12, a transmission / reception unit 13, an input / output unit 14, and the like, and these are electrically connected to each other via a bus 15.

  The control unit 10 is an arithmetic device that controls the operation of the entire inventory management system 1, controls the transmission and reception of data between elements, and performs information processing and the like necessary for executing an application. For example, the control unit 10 is a CPU (Central Processing Unit), and executes programs and the like stored in the storage 12 and expanded in the memory 11 to execute each information processing.

  The memory 11 includes a main storage configured by a volatile storage device such as a DRAM (Dynamic Random Access Memory) and an auxiliary storage configured by a non-volatile storage device such as a flash memory or an HDD (Hard Disc Drive). . The memory 11 is used as a work area or the like of the processor 10, and stores a basic input / output system (BIOS) executed when the inventory management system 1 is started, various kinds of setting information, and the like.

  The storage 12 stores various programs such as application programs. A database storing data used for each process may be built in the storage 12.

  The transmission / reception unit 13 connects the inventory management system 1 to the network 3. The transmission / reception unit 13 may include a short-range communication interface of Bluetooth (registered trademark) and BLE (Bluetooth Low Energy).

  The input / output unit 14 is an information input device such as a keyboard and a mouse used as needed, and an output device such as a display.

  The bus 15 is commonly connected to the above elements, and transmits, for example, an address signal, a data signal, and various control signals.

  FIG. 3 is a diagram illustrating an example of a software configuration of the inventory management system 1. The inventory management system 1 includes an ordered data generation unit 101, a shipped data generation unit 102, a scheduled data generation unit 103, a determination unit 104, a received data generation unit 105, a commodity / article correspondence unit 106, a stock information generation unit 107, Receiving information updating unit 108, accounting information generating unit 109, alert information generating unit 110, first weight data obtaining unit 111, second weight data obtaining unit 112, inventory information storing unit 130, receiving information storing unit 140, article information storing Unit 150, a shipping information storage unit 160, and a product information storage unit 170.

  It should be noted that an ordered data generation unit 101, a shipped data generation unit 102, an arrival schedule data generation unit 103, a determination unit 104, a received data generation unit 105, a commodity / article correspondence unit 106, a stock information generation unit 107, an arrival information update unit 108, an accounting information generation unit 109, an alert information generation unit 110, a first weight data acquisition unit 111, and a second weight data acquisition unit 112 are programs in which the control unit 10 included in the inventory management system 1 is stored in the storage 12. Is read out to the memory 11 and executed, and the inventory information storage unit 130, the arrival information storage unit 140, the article information storage unit 150, the shipping information storage unit 160, and the product information storage unit 170 It is realized as a part of a storage area provided by at least one of them.

  In this specification, the side that orders and receives articles such as products is described as a first user, and the side that ships articles is described as a second user.

  The stock information storage unit 130 stores stock data held by the first user. FIG. 4 is an example of information stored in the inventory information storage unit 130. In the stock information, items such as an article name, a category, a storage location, a quantity, an order point, an update date, and an article ID are recorded for each article. In addition, a photograph of an article, a data creation date, an inventory date, and the like may be recorded, and can be appropriately selected. It may also include information on a QR code or barcode for reading information on these articles. Here, the order point is arbitrarily set for each article, and is a condition for performing the next order. The ordering point includes at least the condition relating to the timing of performing the next order, and may further include setting of the order quantity in one order. For example, with respect to the stock of 2L plastic bottles of water, a rule such as ordering five bottles when the stock becomes three bottles can be set as the order condition.

  The arrival information storage unit 140 stores data of the first user before ordering, ordered data, scheduled arrival data, arrived data, and the like. FIG. 5 is an example of information stored in the arrival information storage unit 140. In the arrival information, the arrival ID, arrival status, article name, article ID, quantity, total price, supplier, registration date, and the like are recorded for each article. These items can be appropriately selected, and other items such as image data can be added. Here, the arrival status is information indicating, for example, which state is “before ordering”, “ordered”, “planned to arrive”, or “arrivald” during the period from the ordering of the article to the completion of the arrival. is there. For example, before ordering, it means that the person in charge or the like has input ordering data, and that in-house settlement has not yet been completed. The order completed refers to the one after the order is completed and before the input of the data to be received. The arrival schedule indicates a shipment information received from a supplier. Arrived indicates that the arrival has been confirmed by inspection or the like. In addition to these, other statuses such as order cancellation and returned goods can be added as well, and if necessary, all statuses before ordering, ordered, and scheduled to be received are unified to "planned", etc. The user can make appropriate settings according to the operation.

  The shipping information storage unit 160 stores second-order received data, shipping schedule data, shipped data, and the like. FIG. 6 is an example of information stored in shipping information storage section 160. The shipping information records a shipping ID, a shipping status, a product name, a product ID, a quantity, a total amount, a business partner, a shipping date, and the like. These items can be appropriately selected, and other items such as image data can be added. Here, the shipment status is information indicating, for example, which of “order received”, “planned to be shipped”, and “shipped” during the period from the order of the article to the completion of the shipment. The order received indicates an order received from a business partner. The shipping schedule indicates the one whose shipping date has been confirmed. Shipped refers to one that has been prepared for packing and the like. In addition to these three statuses, other statuses such as order cancellation, return, etc. can be added, and if necessary, the user can unify the status of orders received and shipping to "shipping scheduled". It can be set appropriately according to the operation.

  The article information storage unit 150 stores information on articles held by the first user. FIG. 7 is an example of information stored in the article information storage unit 150. In the article information, information such as an article ID, a supplier, an order name, an order ID, a weight per unit, a purchase unit price, image data, bar code data, and the like are stored together with an article name used for management by the first user. You. These items can be appropriately selected. The information about the newly ordered article is registered in the article information storage section 150 as appropriate.

  The received data generator 101 generates received data based on order information from the first user. Acquisition of order information may be performed, for example, by reading an ordered data file in an arbitrary format such as a CSV file format, or by receiving ordered data issued by a first user via a cloud service. Good. The received data generator 101 can convert the received order information into received data. Further, when an order is received by telephone or verbally, the second user may directly generate the received data by directly inputting the data into the received data generator 101. In addition, the shipping information storage unit 160 is updated based on the generated received data. The shipment status of the newly ordered article is registered as "order received".

  Further, a shipping schedule data generating unit may be provided. The shipping schedule data can be generated for items for which shipment has been prepared and the shipping date has been determined among the ordered products. One or more order data can be combined into one shipment schedule data, or one order data can be divided into multiple shipment schedule data.

  The shipped data generation unit 102 generates shipped data. The shipped data includes, for each package, a package ID and information on an article to be packed. Further, it is preferable to include the weight data (second weight data) of the package. The second user may input these pieces of information into the shipped data acquisition unit.

  The arrival schedule data generation unit 103 generates arrival schedule data of an article to be received by the first user. The arrival schedule data includes the luggage ID and the shipping information of the article in the shipped data issued by the second user. Therefore, the arrival schedule data substantially corresponds to the shipped data issued by the second user. The acquisition of the shipped data may be performed by reading a shipped data file in a predetermined format such as a CSV file. The shipped data file such as a CSV file may be created by a second user or a third party such as an intermediary, or may be created by the first user himself. Further, the shipped data issued by the second user may be received via the cloud service. Furthermore, the shipped data may be obtained by the first user reading a QR code or the like including the shipped data such as the baggage information attached to the package delivered to the first user with the reading device. The information in the arrival information storage unit 140 can be updated based on the generated arrival schedule data. The arrival status of the article at the time when the arrival schedule data is acquired is “arrival schedule”.

  The first weight data acquisition unit is means for measuring the weight of the package on the first user side. The first weight data acquisition unit only needs to be able to measure the weight of the baggage, and can employ a known means.

  The second weight data acquisition unit is means for measuring the weight of the package on the second user side. The second weight data acquisition unit only needs to be able to measure the weight of the baggage, and can employ known means.

  The determination unit 104 is for simply inspecting the received package on the first user side. First, for the package having the same package ID, the determination unit 104 determines the weight of the package included in the arrival schedule data (measured by the second weight data acquisition unit) and the first user's first weight data acquisition unit. The obtained weight data is compared with the first weight data. When the first weight data and the second weight data satisfy a predetermined condition, it is determined that the articles registered in the arrival schedule data are packed as the quantity, and the inspection is completed. On the other hand, if the first weight data and the second weight data do not satisfy the predetermined condition, it is determined that the article registered in the arrival schedule data has not arrived, and a warning to that effect is issued. The predetermined condition may be set, for example, such that the difference between the two weight data is equal to or less than a predetermined value or equal to or less than a predetermined ratio.

  If the second weight data is not included in the arrival schedule data, the determination unit 104 performs a simple inspection by the following method. First, the determination unit 104 calculates the estimated weight of the entire package from the list of articles included in the arrival schedule data. The determination unit 104 searches the article information storage unit 150 for an article included in the arrival schedule data, and refers to the weight per unit of the article. Next, the weight of the quantity of the article is estimated by multiplying the quantity of the article included in the arrival schedule data by the weight per unit of the article. The estimated weight of the baggage can be calculated by carrying out all of these operations for each article and summing them up. Further, the actual weight data of the package received by the first weight data acquisition unit is acquired and compared with the estimated weight, and when the first weight data and the estimated weight satisfy a predetermined condition, the arrival schedule data It is determined that the articles registered in are packed as the quantity, and the inspection is completed. On the other hand, when the first weight data and the estimated weight do not satisfy the predetermined condition, it is determined that the article registered in the arrival schedule data has not arrived, and a warning to that effect is issued. The predetermined condition can be set, for example, such that the difference between the first weight data and the estimated weight is equal to or less than a predetermined value, or equal to or less than a predetermined ratio. At this time, the determination unit 104 can make a determination in consideration of the weight of an accessory other than an article such as a packing container such as a cardboard. For example, in the estimated weight, the average weight of the accessory registered in advance may be added, or the determination condition may be set so as to absorb the weight difference due to the accessory.

  The received data generation unit 105 converts the shipment information included in the scheduled arrival data, for which inspection by the determination unit 104 has been completed, into received data. If the weight of the package satisfies a predetermined condition as a result of the determination by the determination unit 104, the scheduled arrival data of the package is directly converted to the received data. In addition, when it is determined that some of the articles are not included as a result of the determination, the data to be received is corrected to generate the received data.

  The stock information generation unit 107 converts shipping information included in the received data into stock data in order to update the stock information storage unit 130 for the articles that have been inspected. When the simple inspection is performed by the determination unit 104, and it is determined that the articles registered in the scheduled arrival data are packed according to the quantity, the first user terminal asks whether to update the stock information. When a confirmation message is displayed and the first user inputs information indicating that the information may be updated, the inventory information generation unit 107 generates inventory data from the received data. Alternatively, the inventory data may be automatically generated without displaying the confirmation message. For example, when three pieces of milk are received, information for increasing the stock of three pieces of milk is generated. The inventory information storage unit 130 is updated with the generated inventory data.

  The arrival information updating unit 108 updates the arrival information storage unit 140 based on the received data. Among the articles registered in the arrival information storage unit 140, the articles whose status is "ordered" and "arrival scheduled" have been inspected and the status is updated to "arrival".

  The accounting information generator 109 generates accounting information based on the received data. The term "accounting information" as used herein includes information that is the basis for causing the accounting system used by the first user to execute the accounting process related to the current arrival. For example, based on the received data, journal data of “purchase” and “accounts payable” and date information are generated. When the purchase unit price for each article is stored in the article information storage unit 150, the purchase and payable amounts are referred to from the article information storage unit 150 for the articles included in the received data. The purchase price or the amount of accounts payable may be obtained by multiplying the purchase unit price by the quantity of goods received. The accounting information generation unit 109 can display a message on the first user terminal that confirms whether or not to link with the accounting system. When the first user performs an input indicating that the information can be interlocked, the accounting information generation unit 109 generates the accounting information and links the accounting information with the accounting system. The accounting system is not particularly limited, and the format of the accounting information can be generated according to the accounting system used.

  Here, in the system of the present invention, the generation of stock information, the update of stock information, and the generation of accounting information are performed directly from the shipping information contained in the inspection-scheduled incoming data without generating the received data. It may be.

  The product / article correspondence unit 106 associates the product information used by the second user with the product information used by the first user when the name or ID is different. The commodity / article correspondence unit 106 refers to the correspondence information storage unit that stores the correspondence between the commodity information and the commodity information, and associates the commodity information with the commodity information. The corresponding information storage unit to be referred to may be the above-described article information storage unit 150 or the product information storage unit 170, or may separately include a dedicated database. The association method will be described later.

  The alert information generation unit 110 generates predetermined alert information for articles that satisfy the order conditions. The stock information storage unit 130 may store order conditions for each article. The ordering condition is a setting that, when the remaining stock quantity of each article becomes equal to or less than a certain number, the next order is set, and may include setting of the order quantity when the next order is placed. For example, in the case of consumables or the like, it is possible to manage not to run out of stock by setting order conditions. The alert information generation unit 110 detects an article that satisfies the order condition among the articles stored in the stock information storage unit 130. The alert information is notified to either the first user or the second user. When the alert information is notified to the first user, for example, an e-mail or the like is notified to the first user terminal, or a message is displayed on the inventory management screen, or the color of the article information is changed. Notification is performed by setting a certain flag. Since the first user can recognize that the stock is running low, the first user performs the next ordering work as necessary.

  In addition, when the alert information is notified to the second user who is a supplier, the second user can recognize that the customer's stock is running low, and ship the product as necessary. Do the work. The alert information can specify a supplier (second user) of an article that satisfies the order condition and notify the second user. As the supplier of the article, for example, the previous supplier may be selected.

  Furthermore, if the first user and the second user are to automatically perform ordering / shipping procedures for an article that satisfies the order condition, the ordered data generation unit 101 determines whether the article satisfies the order condition. , Predetermined order-received data can be generated. For example, if the ordering condition for a 2L plastic bottle of water is "order three bottles when the remaining stock is three bottles", the alert information generation unit 110 determines that the remaining water bottle is three bottles. At this point, a second user who is a supplier of water is specified, and the second user is notified that the stock of water satisfies the order condition. Further, the ordered data generation unit 101 of the second user generates ordered data indicating that the first user orders five bottles of 2L water from the first user based on the order conditions.

  Next, the operation of the inventory management system 1 of the present invention will be described with reference to FIGS. Unless otherwise stated, the order of each step can be appropriately changed.

  First, the first user orders an article from the second user (S1). Various means such as telephone, facsimile, and e-mail can be used for ordering. On the first user side, ordered data is generated as necessary, and the received information storage unit 140 records the ordered data as the received status of the article is "ordered". FIG. 9A shows an example of ordered data. The ordered data can include information such as an article name, an article ID, an order quantity, a supplier, and an order date.

The second user generates ordered data based on order data from the first user received by various means (S2). FIG. 9B is an example of the received order data obtained by converting the ordered data. The ordered data includes an article name, an article ID, and an order quantity corresponding to the ordered data. When the second user has a product name and a product ID used for management, the second user may rewrite or add a product name and a product ID corresponding to the product name. In addition, delivery destination information is newly added. Further, in the shipping information storage unit 160 of the second user, the order data is recorded with the shipping status of each item as "order received" based on the order received data.

  Next, shipping schedule data is generated for the article whose shipping date is determined. Further, the shipped data generation unit 102 generates shipped data for the article for which the second user has completed the shipment preparation (S3). In the shipped data, information on the articles packed in one packing container and the weight data (second weight data) of the one packing container are linked to the luggage ID assigned to each packing container. Registered. The second user acquires the second weight data by the second weight data acquiring unit for each packing container before shipping, and registers the second weight data in the shipped data. FIG. 9C shows an example of shipped data. In the shipping information storage unit 160 of the second user, the shipping status is updated to “shipped” for the articles ready for shipping.

  The first user's arrival schedule data generation unit 103 acquires the shipped data from the second user and generates the arrival schedule data (S4). The arrival schedule data includes a package ID, second weight data, and shipping information. FIG. 9D shows an example of arrival schedule data. In addition, the arrival status of the article in the arrival information storage unit 140 is updated to “arrival schedule”.

  Here, the arrival schedule data generation unit 103 may provide a step of acquiring the arrival schedule data immediately before or immediately after the shipment of the package, and comparing the arrival schedule data with the ordered data (S5). If the article and the quantity included in the scheduled arrival data do not match the ordered data, a message to that effect is displayed on the first user terminal and the second user terminal is notified (S6). The second user confirms the package to be shipped, if necessary, and corrects the contents.

  Generation of the arrival schedule data may be performed by reading a barcode or the like attached to a packaging container or the like of the package after the package actually reaches the first user. The first user reads a barcode or the like by a barcode or the like reading means, and acquires information on the article in the baggage and the weight data (second weight data) of the package together with the package ID.

  The first user obtains first weight data for the received package by the first weight data obtaining unit (S7).

  The determination unit 104 determines whether the obtained first weight data satisfies a predetermined condition (S8). For example, when the second weight data is included in the arrival schedule data, it is determined whether or not the difference between the first weight data and the second weight data satisfies a predetermined condition. On the other hand, when the second weight data is not included, the estimated weight of the package is calculated based on the scheduled arrival data. In calculating the estimated weight, first, the article information storage unit 150 is searched for each article included in the arrival schedule data, and the weight per unit is referred to. Next, the weight per unit is estimated by multiplying the weight per unit by the received quantity. The sum of the weight of each article for all the articles included in the arrival schedule data is the estimated weight of the package. The determining unit 104 determines whether the first weight data and the estimated weight satisfy a predetermined condition. Here, the estimated weight of the package itself may be added to the estimated weight in advance, or a difference due to the weight of the package itself under predetermined conditions may be added.

  When the first weight data satisfies the predetermined condition, it can be determined that all the articles included in the arrival schedule data have arrived in the package in the quantity. Conventionally, the first user had to perform the inspection work by counting the number of articles included in the baggage, but according to the present invention, the simple inspection can be performed simply by acquiring the first weight data. And the labor involved in the inspection work can be reduced.

  When the determination unit 104 determines that the first weight data satisfies the predetermined condition, a message or the like is displayed on the first user terminal to confirm whether the article according to the arrival schedule data may be received. Is also good. The first user performs an input to permit the arrival processing. The received data generation unit 105 converts the data to be received into received data (S9).

Next, the stock information generating unit 107 generates stock information based on the shipping information included in the received data, and updates the stock information storage unit 130 (S10).

  Further, the arrival information updating unit 108 updates the arrival information storage unit 140 based on the shipping information included in the received data (S11). For the articles registered in the arrival information storage unit 140, the arrival status is changed from “scheduled arrival” to “arrival completed”.

  Further, the transaction information generation unit 109 generates transaction information based on the received data (S12). The accounting information includes information from which the accounting system is updated. With respect to the articles included in the received data, the purchase unit price is referred to from the article information storage unit 150 and multiplied by the received quantity and the purchase unit price, thereby accounting for “purchase”, “accounts payable” and the like for the arrival. Generate information. The generated accounting information is linked to a predetermined accounting system.

Next, a process in the case where the use name or ID for an article is different between the first user and the second user will be described. In such a case, the product / article correspondence unit 106 associates the product information used by the first user with the product information used by the second user. First, in the case where the first user matches the use name of the second user, when the first user provides ordered data to the second user, the product name and product ID of the second user are included in the ordered data. There is a need to. Also, when converting the shipped data provided by the second user into the data to be received, it is necessary to apply the corresponding used article name from the second user's product name and product ID. As an example, the first user manages an article with an article name of “200 mL of milk” and an article ID of “002”. On the second user side as a supplier, the article name of “200 ml of clean milk in Hokkaido” and the article ID of “200 GY0020 "will be described as an example.

  First, when the first user generates ordered data for the item name “200 ml of milk” and the item ID “002”, the item / item correspondence unit 106 sends the item to the selected item from the item information storage unit 150. Is referred to the product name and product ID of the supplier corresponding to. The product information storage unit 150 stores product information such as the product name and product ID of the supplier of the product in association with the product name and product ID. The ordered data can include the product name and product ID of the second user, product name “Hokkaido Clean Milk 200 mL” and product ID “GY0020” (FIG. 10A).

  The second user receives the ordered data and receives the product name “Hokkaido Clear Milk 200 mL” and the product ID “GY0020”, so that it can be directly converted to the ordered data (FIG. 10B). it can. The same product information is included in the shipped data.

  Subsequently, when the first user converts the shipped data obtained from the second user into the scheduled data, the product / article correspondence unit 106 determines the first user from the product name and the product ID included in the shipped data. It associates the article name and the article ID used by the company. Based on the product name and the product ID included in the shipped data, the product / product correspondence unit 106 can input the arrival schedule data by referring to the product name and the product ID from the product information storage unit 150. By clarifying the article name and the article ID in the arrival schedule data, it is possible to collate with the ordered data. Further, when updating the arrival information storage unit 140 and the stock information storage unit 130, the information is updated based on the article name and the article ID.

  Next, a case where the first user and the second user use different names for articles and the second user matches the first user's use name will be described. In this case, when converting the ordered data received from the first user into the ordered data, the product name and the product ID used by the company are specified from the product name and the product ID described in the ordered data. Must be converted to ordered data. Further, it is necessary to include the article name and the article ID in the shipped data provided to the first user.

  Here, in the product information storage unit 170 that stores product information handled by the second user, information such as the product name and the product ID at the business partner (delivery destination) is stored in association with each product. First, when generating the ordered data based on the order information from the first user, the product / article correspondence unit 106 uses the product information storage unit 170 of the second user based on the product name and the product ID included in the order information. Refers to the corresponding product name and product ID. Further, the article name and the article ID included in the ordering information can also be described in the shipped data. Since the article name and the article ID are described in the already-shipped data, the first user can directly convert the data into the scheduled arrival data.

  In addition to the method described above, a method of associating products using image recognition may be employed. First, the first user attaches image data of an article together with an article name or the like as ordered data. When the second user obtains the ordered data, the commodity / article correspondence unit 106 analyzes the image data of the articles included in the ordered data, specifies the commodity name and the commodity ID used by the company, and receives the ordered data. To reflect. Similarly, the second user attaches image data of a product together with the product name and the like to the shipping information in the shipped data. When the first user obtains the shipped data, the product / article corresponding unit 106 analyzes the image data of the product included in the shipping information, thereby specifying the product name and the product ID used by the company and converting the data into the scheduled arrival data. can do.

  As a means for specifying a product / article from the image data, a known image recognition method such as machine learning can be used. When using machine learning, a plurality of image data is read in advance for each product / article to be handled and stored in the article information storage unit 150, the product information storage unit 170, or another database. Then, features such as characters, shapes, colors, and patterns are extracted from the images included in the ordering data, and the product / article is specified.

  Further, a method of associating products by using a barcode can also be adopted. The barcode is a barcode such as a JAN code generally printed on a product or its package. Since the barcode is given as a unique number to the product, the barcode can be recognized in common by the first user and the second user. The barcode data is stored in the article information storage unit 150, the product information storage unit 170, or another database. In this case, the first user attaches barcode data of the article together with the article name and the like as ordered data. When the second user obtains the ordered data, the product / article corresponding unit 106 specifies the product name and the product ID of the company from the barcode data included in the ordered data, and reflects the product name and the product ID on the ordered data. Similarly, the second user attaches barcode data of the product along with the product name and the like to the shipping information in the shipped data. When the first user obtains the shipped data, the product / article correspondence unit 106 can specify the name of the product and the product ID used by the company from the barcode data included in the shipping information and reflect the specified product name and the product ID on the scheduled arrival data.

Further, the product / article correspondence unit 106 can associate the product name used by the first user with the product name used by the second user using machine learning. A simple example is shown below. For example, if the second user sets the product name at the time of shipment to "Tapioca" and the first user erroneously registers the product name as "Tapioya", the names are formally different, so they are associated as they are. Can not do. However, for the product name "Tapioca", "Tapioya" has the same three characters out of four characters, the recent increase in the quantity handled is similar, and the other inventories on the receiving side are juice and other products. By comprehensively judging information such as dealing with beverages, it is possible to judge that there is a high possibility that “Tapioya” corresponds to the product name “Tapioca”. On the other hand, even if an industrial product with the product name “Tapion” is received, other data within the same company will be analyzed, and the products that have shipped “Tapion” will mainly be shipped to other companies. If it is an industrial product, it can be determined that “Tapion” is not tapioca.
In this way, by referring to the inventory data of a plurality of first users and second users in the cloud data, at least one of at least the name, the increase / decrease in the handling quantity, and the types / attributes of other handling products / articles By calculating the degree of similarity, it can be inferred that a certain article name and a product name indicate the same thing. When using this function, for example, when the first user receives shipping information and generates scheduled arrival data, the product name included in the shipping information corresponds to which article in the first user's inventory information. It is possible to guess and recommend.

  In the above example, the article name and the article ID are both used for the first user, and both the product name and the product ID are used for the second user. However, only either the name or the ID may be used. As described above, when the article name and the article name do not match between the first user and the second user, the article and article correspondence unit 106 may associate the article and the article by referring to the article information storage unit 150 or the article information storage unit 170. Since it is possible, mutual ordering data can be used smoothly.

  The embodiment described above is merely an example for facilitating the understanding of the present invention, and is not intended to limit and interpret the present invention. The present invention can be changed and improved without departing from the spirit thereof, and it goes without saying that the present invention includes equivalents thereof.

REFERENCE SIGNS LIST 1 inventory management server 2 first user terminal 3 second user terminal 4 network 101 ordered data generation unit 102 shipped data generation unit 103 scheduled data generation unit 104 determination unit 105 received data generation unit 106 commodity / article correspondence unit 107 inventory Information generating unit 108 Receiving information updating unit 109 Accounting information generating unit 110 Alert information generating unit 111 First weight data obtaining unit 112 Second weight data obtaining unit 130 Inventory information storage unit
140 arrival information storage unit 150 article information storage unit 160 shipping information storage unit 170 product information storage unit

Claims (5)

An inventory management system for a first user receiving a package from a second user who is a shipper of the package,
For an article held by the first user, an article name and / or an article ID, and a stock information storage unit that stores stock information of the article,
An arrival information storage unit that stores an arrival status in association with at least an article name and / or an article ID of an article ordered by the first user;
For the goods held by the first user, at least the goods name and / or goods ID, weight per unit, and the goods name and / or goods ID when ordering to the second user are the goods name and / or goods ID If different, an article information storage unit that stores a corresponding product name and / or product ID of the specific second user;
If the product name and / or product ID included in the shipping information of the package obtained from the second user is different from the product name and / or product ID in the inventory information storage unit, the package obtained from the second user Based on the product name and / or product ID included in the shipping information, a product / product corresponding unit that reads out a corresponding product name and / or product ID from the product information storage unit;
The generation and shipments of goods that are included in the shipment information, on the basis of which the read article name and / or article ID, the Stock data, including an article name and / or article ID of Stock and Stock quantity Receiving schedule data generation unit to be
A first weight data acquisition unit that measures first weight data of the package received by the first user,
The weight per unit is read from the article information storage unit for each article included in the scheduled arrival data, and the estimated weight of the parcel is calculated by multiplying the expected weight per unit by the weight per unit, and the first weight data is calculated. A determination unit that determines that inspection has been completed when the difference between the estimated weight and the predetermined weight is equal to or less than a predetermined value or equal to or less than a predetermined ratio;
When the determination unit determines that the inspection has been completed,
A received data generation unit that generates received data based on the expected arrival data, wherein the name of an already-received article is based on an article name and / or an article ID in the expected arrival data and the expected arrival quantity. And / or a received data generation unit that generates received data including an article ID and a received quantity,
A stock information generating unit that generates information for increasing the stock quantity of the article in the stock information storage unit by the received quantity based on the received data;
For an article name and / or an article ID in the received data, an arrival information update unit that updates the arrival status in the arrival information storage unit from information indicating that the item has not been received to information indicating that the item has been received,
An inventory management system, comprising: An inventory management system for a first user receiving a package from a second user who is a shipper of the package,
For an article held by the first user, an article name and / or an article ID, and a stock information storage unit that stores stock information of the article,
An arrival information storage unit that stores an arrival status in association with at least an article name and / or an article ID of an article ordered by the first user;
An article information storage unit that stores at least an article name and / or an article ID, a weight per unit, and a plurality of reference image data of the article for the article held by the first user;
If the product name and / or product ID included in the shipping information of the package obtained from the second user is different from the product name and / or product ID in the inventory information storage unit, the package obtained from the second user By extracting at least one of the character, shape, color, and pattern feature amounts from the product image data included in the shipping information of the corresponding item, and comparing the extracted feature amount with the reference image data, the corresponding item name and / or Or a commodity / article corresponding unit for reading the article ID;
The generation and shipments of goods that are included in the shipment information, on the basis of which the read article name and / or article ID, the Stock data, including an article name and / or article ID of Stock and Stock quantity Receiving schedule data generation unit to be
A first weight data acquisition unit that measures first weight data of the package received by the first user,
The weight per unit is read from the article information storage unit for each article included in the scheduled arrival data, and the estimated weight of the parcel is calculated by multiplying the expected weight per unit by the weight per unit, and the first weight data is calculated. A determination unit that determines that inspection has been completed when the difference between the estimated weight and the predetermined weight is equal to or less than a predetermined value or equal to or less than a predetermined ratio;
When the determination unit determines that the inspection has been completed,
A received data generation unit that generates received data based on the expected arrival data, wherein the name of an already-received article is based on an article name and / or an article ID in the expected arrival data and the expected arrival quantity. And / or a received data generation unit that generates received data including an article ID and a received quantity,
A stock information generating unit that generates information for increasing the stock quantity of the article in the stock information storage unit by the received quantity based on the received data;
For an article name and / or an article ID in the received data, an arrival information update unit that updates the arrival status in the arrival information storage unit from information indicating that the item has not been received to information indicating that the item has been received,
An inventory management system, comprising: The inventory management system according to claim 1, further comprising an accounting information generation unit configured to generate accounting information based on the received data. The inventory information storage unit stores at least inventory quantities and order conditions for each article,
The inventory management system according to any one of claims 1 to 3, further comprising an alert information generating unit that generates predetermined alert information for an article that satisfies the order condition. The inventory management system according to claim 4, wherein the alert information is provided to a supplier of the article.