JP2020042487A - Order acceptance and sales managing device, order acceptance and sales managing method and order acceptance and sales managing program - Google Patents

Abstract

To provide an order acceptance and sales managing device, an order acceptance and sales managing method and an order acceptance and sales managing program which flexibly manage order acceptance and sales in accordance with an in-stock state at a warehouse, and which can create an alert or an error as needed.SOLUTION: According to this embodiment, (1) when all products having the same order number can be allocated from the same warehouse among the products in order data, an order acceptance record and a sales record are created so as not to create an alert or an error, (2) when the products having the same order number can be allocated from a plurality of warehouses among the products in the order data, the order acceptance record and the sales record are created so as to create an alert, and (3) when there are products that cannot be allocated by the ordered number among the products having the same order number in the order data, the order acceptance record is created so as to create an error.SELECTED DRAWING: Figure 2

Description

  The present invention relates to an order / sales management device, an order / sales management method, and an order / sales management program.

  Patent Literature 1 states, “If the quantity of shipping reservation order information is the number of batch units, for example, 100 pieces or more and it is not possible to satisfy the shipping reservation with only one lot, a plurality of plans are set according to the priority of timely supply. And allocating by dividing into lots ”(see paragraph 0153 of Patent Document 1).

JP 2003-91309 A

However, the inventory allocation disclosed in Patent Document 1 cannot meet the following requirements. In other words, in the logistics industry and the retail industry, order management and sales of products are often managed using order identification data (order numbers).
1. When all products in the same order number can be stocked from the same warehouse (for example, when goods A and B having the same order number A1000 can be stocked from the warehouse A).
→ Automatically create order data and sales data2. If all the products in the same order number can be allocated from multiple warehouses (for example, among products A and B having the same order number A1000, product A can be allocated from warehouse A and product B can be allocated). Is when inventory can be allocated from warehouse B)
→ Automatically create order data and sales data and generate a warning at the same time. In the case where an out-of-stock product occurs among all the products in the same order number (for example, among the products A and B having the same order number A1000, the product A can be reserved from the warehouse A, If inventory is not enough in warehouse B)
→ This is a request to flexibly manage orders and sales according to the stock status of the warehouse, such as automatically creating only order data and generating errors, and to generate warnings and errors as necessary.

  SUMMARY OF THE INVENTION The present invention has been made in view of the above problems, and provides flexible order and sales management according to the stock status of a warehouse, and can also generate a warning or error as needed. It is an object to provide a management device, an order / sales management method, and an order / sales management program.

  In order to solve the above-described problems and achieve the object, an order / sales management device according to the present invention is an order / sales management device including a control unit and a storage unit, wherein the storage unit identifies an order. Order identification data for identifying the product, order data including the product identification data for identifying the product, and the number of orders for the product, warehouse identification data for identifying the warehouse, product identification data, and the stock quantity of the product. Inventory data, and a priority master including priority set in the case where the warehouse is assigned as a destination and set for each product, and the control unit includes: For the product specified by the product identification data, of the warehouses specified by the warehouse identification data in the inventory data associated with the product identification data, Allocating means for allocating inventory by decreasing the number of stocks until the number of orders is reached, in order from the warehouse having the highest priority set for the goods to be ordered, and the allocation is performed by the allocating means. If all of the products having the same order identification data can be allocated from the same warehouse, based on the order data and the inventory data, the order identification data, the product identification data, and the warehouse to which the allocation is made First creating means for creating an order record and a sales record including the warehouse identification data and the number of stocks reduced from the warehouse; and the same order identification among the specified products as a result of the allocation by the allocation means. If data having data can be allocated from a plurality of warehouses, based on the order data and the inventory data, the order identification data and the A warning indicating that the allocation destination is a plurality of warehouses for the product having the same order identification data as the item identification data and the warehouse identification data for the warehouse that is the allocation destination and the number of stocks reduced from the warehouse; Second order creation means for creating an order record and a sales record including, and as a result of the assignment by the assignment means, among the identified products having the same order identification data, If there is a product that cannot be provided, the order identification data, the product identification data, and the fictitious warehouse identification data, which is the warehouse identification data for identifying a fictitious warehouse, based on the order data and the inventory data, and the identification. Including the number of ordered products and an error indicating that there is an item that cannot be allocated among products having the same order identification data. And a third creating means for creating a code.

  In the order / sales management device according to the present invention, the control unit may notify an operator of the order identification data and the product identification data included in the order record and the sales record created by the second creation unit. It is characterized by further comprising means.

  The order receiving / sales management device according to the present invention, wherein the control unit receives the instruction from the sales input screen and displays the order record created by the third creating means on the sales input screen. A real store that includes the order identification data and the product identification data in the displayed order record, and is the warehouse identification data for identifying a warehouse in which the fictitious warehouse identification data in the displayed order record exists. Has been changed to warehouse identification data, the number of orders in the displayed order record has been changed to the number of stocks that can be allocated from the existing warehouse, and the error in the displayed order record has been deleted. Sales record creation means for creating a sales record.

  In the order / sales management device according to the present invention, the order data is data created by an order from a customer on a website, and the order identification data identifies an order on the website. The order number is for making the order.

  An order / sales management method according to the present invention is an order / sales management method executed by an information processing apparatus including a control unit and a storage unit, wherein the storage unit includes an order identification for identifying an order. Order data including data and product identification data for identifying the product and the number of orders for the product, inventory data including warehouse identification data and product identification data for identifying the warehouse, and the number of products in stock, Priority masters including priority set in the case where the warehouse is to be allocated and including those set for each product, are stored, and executed by the control unit, the product in the order data For the product specified by the identification data, of the warehouse specified by the warehouse identification data in the inventory data associated with the product identification data, the warehouse specified by the priority order master An allocation step of reducing the number of stocks until the number of orders is reached, in order from the warehouse having the highest priority set for the goods, and as a result of the allocation in the allocation step, the specified product If all the items having the same order identification data can be allocated from the same warehouse, based on the order data and the inventory data, the order identification data, the product identification data, and A first creation step of creating an order record and a sales record including the warehouse identification data and the number of stocks reduced from the warehouse, and a result of the allocation in the allocation step, the same order identification data among the specified products. In the case where the item having the order can be allocated from a plurality of warehouses, the order identification is performed based on the order data and the inventory data. Data, the product identification data, and the warehouse identification data of the warehouse to which the allocation is made, and that the allocation destination is a plurality of warehouses for products having the same order identification data as the number of stocks reduced from the warehouse. A second creation step of creating an order record and a sales record including a warning that means, and a result of the allocation in the allocation step, as a result of the specified number of the specified goods having the same order identification data, If there is a product that cannot be allocated for the minute, based on the order data and the inventory data, the fictitious warehouse identification which is the warehouse identification data for identifying the order identification data, the product identification data, and the fictitious warehouse. It means that there is a product that has the same order identification data as the data and the number of orders of the specified product that cannot be allocated. And a third creation step of creating an order record including an error.

  An order / sales management program according to the present invention is an order / sales management program to be executed by an information processing apparatus including a control unit and a storage unit, wherein the storage unit includes an order for identifying an order. Order data including identification data and product identification data for identifying the product and the number of orders for the product, inventory data including warehouse identification data for identifying the warehouse, product identification data, and the number of products in stock; And a priority master including a priority set in the case where the warehouse is assigned as a destination and set for each product, and stored in the order data for the control unit to execute. For the product specified by the product identification data, of the warehouses specified by the warehouse identification data in the inventory data associated with the product identification data, In the order from the warehouse with the highest priority set for the specified product, in the allocation step of performing inventory allocation by reducing the number of stocks until the number of orders is reached, as a result of the allocation in the allocation step, If all of the specified products having the same order identification data can be allocated from the same warehouse, based on the order data and the inventory data, the order identification data, the product identification data, the allocation destination, A first creation step of creating an order record and a sales record including the warehouse identification data and the number of stocks reduced from the warehouse for the warehouse that has become a result of the allocation in the allocation step, If items having the same order identification data can be allocated from a plurality of warehouses, the order data and the inventory data Based on the order identification data, the product identification data, and the warehouse identification data for the warehouse to which the allocation was made, and the warehouse having the same order identification data as the number of stocks reduced from the warehouse, the allocation destination is a plurality of warehouses. A second creation step of creating an order record and a sales record including a warning indicating that the product has been identified, and as a result of the allocation in the allocation step, the identified product having the same order identification data When there is a product that cannot be allocated for the number of orders, based on the order data and the stock data, the warehouse identification data for identifying the order identification data, the product identification data, and the fictitious warehouse. Of the products having the same order identification data as the fictitious warehouse identification data and the number of orders of the specified product, which cannot be allocated And a third creation step of creating an order record including an error that means that an order exists.

  ADVANTAGE OF THE INVENTION According to this invention, while being able to perform flexible order receiving / sales management according to the stock situation of a warehouse, it produces the effect that a warning and an error can be generated as needed.

FIG. 1 is a block diagram illustrating an example of the configuration of the order / sales management device. FIG. 2 is a diagram illustrating an example of a flowchart of a process according to the present embodiment. FIG. 3 is a diagram illustrating an example of the product master, the warehouse master, and the allocation priority master. FIG. 4 is a diagram showing an example of creating order data and sales data when there is ample stock. FIG. 5 is a diagram showing an example of creation of order data and sales data in a case where the allocation destination of a product in different order details is broken into a plurality of warehouses. FIG. 6 is a diagram illustrating an example of creation of order data and sales data in a case where the allocation destination of a product in the same order detail is broken into a plurality of warehouses. FIG. 7 is a diagram illustrating an example of creating order data and sales data when the stock is insufficient.

  Hereinafter, embodiments of an order / sales management apparatus, an order / sales management method, and an order / sales management program will be described in detail with reference to the drawings. The present invention is not limited by the embodiment.

[1. Overview]
In the case where data ordered by a customer on a Web site is linked to the system, the shipping warehouse is often set automatically by the system instead of being selected by the customer who is the orderer. Conventionally, when performing inventory allocation on the system, it has been confirmed whether or not there is available inventory in the warehouse after designating a product and a warehouse. However, since orders via a Web site are generated in large amounts on a daily basis, there are the following requests 1 and 2 in order to record sales by linking Web order data to the system.
1. When placing an order via the website, I want to restrict the warehouse to which the information is allocated. In addition, we want to prioritize the warehouse to which the product is allocated for each product.
2. In the case where the number of orders in the item> the number of inventory in one warehouse, if there is an inventory in another warehouse, it is desirable to divide the item so that goods can be shipped from a plurality of warehouses.

Therefore, in the present embodiment, for example, by including the following procedures 1 to 4, it is possible to respond to the above requirements 1 and 2.
1. The allocation priority order for each product and each warehouse is set in the master in advance.
2. In the case of ordering via a Web site, warehouses are selected in the order of the priority order of the set master, and a stock allocation check is performed.
3. If the allocation cannot be made in one warehouse, it is checked whether the inventory can be allocated from the warehouse having the next highest priority among the warehouses in the set master to the number of remaining orders. If all orders can be allocated, order data and sales data are created.
4. On the other hand, if an error occurs due to a shortage of stock and the number of orders cannot be allocated, only sales order data is created without creating sales data. In the case of shipment and sales, accounting is performed by referring to the created order data.

In addition, conventionally, there have been the following requests 1 and 2 in order to record sales by linking Web order data to a system.
1. In the past, whether inventory allocation was possible or not was conventionally performed on a product-by-product basis.Even if allocation could be made from multiple warehouses, sales data would not be created due to an inventory shortage error. A mechanism was needed to enable creation.
2. Depending on the product and the contents of the order, there may be cases where it is not desired to ship from multiple warehouses, and a mechanism for generating an alert when inventory is allocated from multiple warehouses is required.

Therefore, in the present embodiment, for example, with respect to order data linked from a Web site, a stock allocation check can be performed by referring to a master that sets the allocation order for each product and each warehouse. Then, according to the inventory allocation result, order data and sales data are created as shown in the following 1 to 3.
1. If all the products in the same order number can be shipped from the same warehouse → Automatically create order data and sales data.
2. When goods in the same order number are allocated from multiple warehouses → Automatically create order data and sales data and generate a warning. Then, the salesperson confirms the warning and adjusts the warehouse and the number of orders as necessary.
3. If there is an out-of-stock product within the same order number → Only order data is automatically created and an out-of-stock error occurs. Then, the sales person confirms the contents of the error, adjusts the warehouse and the number of orders, and creates sales data.
Note that the flowchart of the processing is as shown in FIG. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
An example of a configuration of the order / sales management device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the order / sales management device 100.

  The order receiving / sales management device 100 is a commercially available desktop personal computer. Note that the order / sales management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, or the like. It may be a portable information processing device.

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

  The communication interface unit 104 communicably connects the order / sales management device 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 order receiving / sales management apparatus 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data of various masters and the like described below may be stored in the server 200, for example.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with a mouse can be used. In the following, the output device 114 may be described as a monitor 114 and the input device 112 may be described as a keyboard 112 or a mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for cooperating with an OS (Operating System) and giving instructions to a CPU (Central Processing Unit) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, and the like can be used.

  The storage unit 106 stores, for example, a product master 106a, a warehouse master 106b, an allocation priority master 106c as a priority master, order data 106d, current warehouse data 106e as inventory data, order data 106f, and sales data. Data 106g.

  As shown in FIG. 3, the product master 106a includes, for example, product identification data (product A and product B) for identifying the product.

  As shown in FIG. 3, the warehouse master 106b includes, for example, warehouse identification data (warehouses A to D and a dummy warehouse) for identifying the warehouse. The warehouse identification data is real warehouse identification data (warehouses A to D), which is the warehouse identification data for identifying an existing warehouse, and a fictitious warehouse identification, which is the warehouse identification data for identifying a fictitious warehouse. Data (dummy warehouse).

  As shown in FIG. 3, the allocation priority master 106c includes, for example, the priority in the case where the warehouse is used as the allocation destination, and includes the priority set for each product. For example, in the example of FIG. 3, for the product A, the warehouse A has the first priority, the warehouse B has the second priority, and the warehouse C has the third priority. On the other hand, in the example of FIG. 3, for the product B, the warehouse C is assigned the first priority, the warehouse B is assigned the second priority, the warehouse A is assigned the third priority, and the warehouse A is assigned the third priority. D is assigned the fourth priority. In this way, in the allocation priority master 106c, it is possible to set, for each product, which warehouse is to be the allocation destination with priority.

  As shown in FIGS. 4 to 7, the order data 106 d includes, for example, order identification data (Web order No.) for identifying an order, a line number of an order detail, the product identification data (product), and Includes the number of items ordered (quantity) and so on. The order data 106d is, for example, data created by an order from a customer on a website, and in this case, the order identification data is, for example, an order number for identifying an order on the website. is there.

  As shown in FIGS. 4 to 7, the current warehouse data 106e includes, for example, the warehouse identification data (warehouse), the product identification data (product), the number of stocks of the product (current warehouse), and the like. .

  The order data 106f includes an order record corresponding to one row of information as shown in FIGS. The order record is created based on the order data 106d and the current warehouse data 106e. The information included in the order record is described in [3. Specific Example of Processing].

  The order record includes one of the following three data statuses (error categories) according to the allocation status. In other words, "error classification: none" means that the allocation destination is the same warehouse for the product having the same order identification data, and the allocation destination is a plurality of warehouses for the product having the same order identification data. "Error category: warning *", which means that there is an error, and "error category: available," which means that there is an item that cannot be allocated among products having the same order identification data. is there. If the error category is "none", the order data 106f and the sales data 106g are both created. If the error category is "warning *", both the order data 106f and the sales data 106g are created, but a warning alert is notified to the person in charge. If the error category is "Yes", the order data 106f is created but the sales data 106g is not created, and the person in charge is notified of an error alert.

  The sales data 106g includes a sales record corresponding to one row of information as shown in FIGS. The sales record is created based on the order data 106d and the current warehouse data 106e. The information included in the sales record is described in [3. Specific Example of Processing]. The sales record includes one of “error category: none” and “error category: warning *” as the data status.

  The control unit 102 is a CPU or the like that controls the order receiving / sales management device 100 as a whole. 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 types of information processing based on the stored programs. Execute.

  The control unit 102 functionally conceptually specifies, for example, (1) a product specified by the product identification data in the order data by the warehouse identification data in the stock data associated with the product identification data. Out of the warehouses, as the allocation means for allocating inventory by decreasing the number of stocks in order from the warehouse having the highest priority set for the specified product in the priority order master until the number of orders is reached. The allocation unit 102a; and (2) when the allocation by the allocation means results in that all of the specified products having the same order identification data can be allocated from the same warehouse, the order data and the stock data Based on the order identification data, the product identification data, and the warehouse identification data for the warehouse to which the allocation was made and subtracted from the warehouse. A first creation unit 102b as first creation means for creating an order record and a sales record including the number of warehouses, and (3) the same order identification data among the specified products as a result of the assignment by the assignment means If it can be allocated from a plurality of warehouses, based on the order data and the inventory data, from the warehouse identification data and the warehouse for the order identification data, the product identification data and the warehouse to which the allocation was made A second creating unit as a second creating means for creating an order record and a sales record including a warning indicating that the allocation destination is a plurality of warehouses for the product having the same order identification data as the reduced inventory quantity. 102c; and (4) the order identification data and the product identification included in the order record and the sales record created by the second creating means. A notification unit 102d as notification means for notifying the operator of data; and (5) as a result of the allocation by the allocation means, as a result of the specified products having the same order identification data, If there is a product that cannot be allocated, based on the order data and the inventory data, the order identification data, the product identification data, and the fictitious warehouse identification data that is the warehouse identification data for identifying a fictitious warehouse. A third creating unit 102e as third creating means for creating an order record including an error indicating that there is an unallocated product among products having the same order identification data as the specified product order number and order identification data; (6) display means for displaying the order record created by the third creation means in response to an instruction from the sales input screen on the sales input screen; A display unit 102f as a column; and (7) a warehouse including the order identification data and the product identification data in the displayed order record, and identifying the warehouse where the fictitious warehouse identification data in the displayed order record exists. Has been changed to the actual warehouse identification data, which is the warehouse identification data to be executed, the number of orders in the displayed order record has been changed to the number of stocks that can be allocated from the existing warehouse, and the displayed A sales record creation unit 102g as sales record creation means for creating a sales record in which the error in the order record is deleted.

  The allocating unit 102a, for the product identified by the product name in the order data 106d, among the warehouses specified by the warehouse name in the current warehouse data 106e associated with the product name, the allocation specified in the allocation priority master 106c. Inventory allocation is performed by decreasing the number of stocks in order from the warehouse having the highest priority set for the commodities until the number of orders is reached.

  As a result of the allocation in the allocation unit 102a, the first creation unit 102b stores the order data 106d and the current warehouse data 106e in the case where all of the specified products having the same order number can be allocated from the same warehouse. Based on this, an order record and a sales record including an outgoing warehouse, which is the warehouse name of the warehouse to which the order number, the product name, and the allocation destination, and an outgoing number, which is the number of stocks reduced from the warehouse, are created.

  The second creating unit 102c, based on the order data 106d and the current warehouse data 106e, determines that the identified product having the same order number can be allocated from a plurality of warehouses as a result of the allocation by the allocation unit 102a. The order number, the product name, and the outgoing warehouse, which is the warehouse name of the warehouse to which the appropriation was made, and the product to which the same order number as the outgoing number, which is the number of stocks reduced from the warehouse, are allocated to a plurality of warehouses. Create an order record and a sales record that include a warning (error classification: warning *) that means that it has been turned on.

  The notification unit 102d notifies the operator of the order number and the product name included in the order record and the sales record created by the second creation unit 102c.

  As a result of the allocation in the allocation unit 102a, if there is a product that cannot be allocated for the number of orders among the specified products having the same order number as a result of the allocation in the allocation unit 102a, Based on the current warehouse data 106e, it means that there is a product that cannot be allocated among the products having the same order number as the order number, the product name, the warehouse name of the fictitious warehouse, and the order number of the specified product. Create an order record including an error (error classification: yes).

  The display unit 102f receives the instruction from the sales input screen and displays the order record created by the third creating unit 102e on the sales input screen.

  The sales record creation unit 102g includes the order number and the product name in the displayed order record, and the warehouse name of the imaginary warehouse in the displayed order record is changed to the warehouse name of the actual warehouse. The number of orders in the displayed order record has been changed to the number of stocks that can be allocated from the existing warehouse, and the error (error classification: present) in the displayed order record has been deleted (error (Changed to Category: None) Create a sales record.

[3. Specific example of processing]
In this section, a specific example of the process according to the present embodiment will be described. This item [3. Specific Example of Processing], the description will be made assuming that the specific contents of the product master 106a, the warehouse master 106b, and the allocation priority master 106c are as shown in FIG.

[3-1. When there is abundant stock]
First, processing when there is ample stock will be described in detail with reference to FIG.

(1) Processing for Commodity Specified by Web Order No .: A1000 Referring to the order data 106d in FIG. 4, the commodities specified by the Web order No .: A1000 are two products, a product A and a product B.

  First, a description will be given of the inventory allocation of the product A of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 4, the warehouses associated with the product A are the warehouse A and the warehouse C, but referring to the allocation priority master 106c in FIG. 3, the warehouse A is higher for the product A. It has priority (1). For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order number 10 of the product A of the Web order No: A1000 from the inventory number 20 of the product A in the warehouse A. After the stock allocation, the stock quantity of the commodity A in the warehouse A is 20−10 = 10.

  Next, a description will be given of the inventory allocation of the product B of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 4, the warehouse associated with the product B is only the warehouse A. For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order number 5 of the product B of the Web order No: A1000 from the inventory number 20 of the product B in the warehouse A. After the stock allocation, the stock quantity of the product B in the warehouse A is 20−5 = 15.

  As a result of the allocation by the allocation unit 102a, it was possible to allocate both the product A and the product B having the web order No: A1000 from the same warehouse (warehouse A).

  As described above, when all the commodities having the same Web order No. can be allocated from the same warehouse, the first creation unit 102b, as shown in the first line of the order data 106f in FIG. For the product A, the Web order No .: A1000, the product name: the product A, the warehouse name of the warehouse (corresponding to the outgoing warehouse) to which the allocation is made, the warehouse A, and the number of stocks reduced from the warehouse A ( (Corresponding): 10 and an error record: None. Further, as shown in the first line of the sales data 106g in FIG. 4, the first creating unit 102b, for the product A of the web order No .: A1000, the web order No .: A1000, the product name: the product A, and the allocation destination Then, a sales record including the warehouse name of the warehouse (corresponding to the warehouse to be released): warehouse A, the number of stocks (corresponding to the number of sales) reduced from warehouse A: 10, and the error category: none is created.

  In the same manner, as shown in the second row of the order data 106f and the sales data 106g in FIG. 4, the first creating unit 102b receives the order including “Error classification: None” for the product B of the web order No: A1000. Create records and sales records.

(2) Processing for Commodity Specified by Web Order No .: A1001 Next, the inventory allocation of the commodity A of the Web order No .: A1001 will be described. As described in (1), after stock allocation, the number of stocks of the product A in the warehouse A is ten. For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order 10 of the product A of the Web order No: A1001 from the stock number 10 of the product A in the warehouse A.

  As a result of the allocation by the allocation unit 102a, it was possible to allocate the goods A having the Web order No: A1001 from the warehouse A. As described above, when all the commodities having the same Web order No. can be allocated from the same warehouse, the first creation unit 102b sets the Web as shown in the third line of the order data 106f and the sales data 106g in FIG. For the product A of the order No: A1001, an order record and a sales record including “error classification: none” are created.

[3-2. When the allocation destination of products in different order details is split into multiple warehouses]
Next, the processing in the case where the allocation destination of the product in different order details is broken into a plurality of warehouses will be described in detail with reference to FIG.

(1) Processing for Commodity Specified by Web Order No .: A1000 Referring to the order data 106d in FIG. 5, the commodities specified by Web order No .: A1000 are two products, product A and product B.

  First, a description will be given of the inventory allocation of the product A of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 5, the warehouses associated with the product A are the warehouse A and the warehouse C, but referring to the allocation priority master 106c in FIG. 3, the warehouse A is higher for the product A. It has priority (1). For this reason, the allocation unit 102a performs inventory allocation by subtracting the order number 10 of the product A of the Web order No: A1000 from the inventory number 10 of the product A in the warehouse A. After the stock allocation, the stock quantity of the commodity A in the warehouse A becomes 10−10 = 0.

  Next, a description will be given of the inventory allocation of the product B of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 5, the warehouse associated with the product B is only the warehouse C. For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order number 5 of the product B of the web order No: A1000 from the inventory number 20 of the product B in the warehouse C. After the stock allocation, the stock quantity of the product B in the warehouse C is 20-5 = 15.

  As a result of the allocation by the allocation unit 102a, the products A and B having the Web order No .: A1000 can be allocated from a plurality of warehouses (warehouses A and C, respectively).

  As described above, when a product having the same Web order No. can be allocated from a plurality of warehouses, the second creating unit 102c, as shown in the first row of the order data 106f in FIG. For the product A, the Web order No .: A1000, the product name: the product A, the warehouse name of the warehouse (corresponding to the outgoing warehouse) to which the allocation is made: the warehouse A, and the number of stocks reduced from the warehouse A (corresponding to the number of orders) ): 10 and an order record including an error category: warning *. Further, as shown in the first row of the sales data 106g in FIG. 5, the second creating unit 102c, for the product A of the web order No .: A1000, the web order No .: A1000, the product name: the product A, and the allocation destination Then, a sales record including the warehouse name of the warehouse (corresponding to the unloading warehouse): warehouse A, the number of stocks (corresponding to the number of sales) reduced from warehouse A: 10, and the error category: warning * is created.

  In the same manner, the second creating unit 102c includes “error classification: warning *” for the product B of the web order No: A1000, as shown in the second line of the order data 106f and the sales data 106g in FIG. Create order and sales records.

  As described above, the second creation unit 102c includes the order record including the warning when the allocation destinations of the product A and the product B having the same Web order No .: A1000 are different warehouses, which are included in different order details. And create sales records.

  The notification unit 102d may notify the operator of “Web order No .: A1000” and “product name: product A, product B” included in the order record and the sales record created by the second creation unit 102c. Based on this notification, the operator refers to the order data 106f and the sales data 106g shown in FIG. 5, and the operator can determine that the allocation destinations of the product A and the product B having the same Web order No: A1000 are different warehouses. Can be grasped accurately and quickly. The operator may adjust the outgoing warehouse and the quantity included in the order record and the sales record shown in FIG. 5 as necessary.

(2) Processing for Commodity Specified by Web Order No .: A1001 Next, the inventory allocation of the commodity A of the Web order No .: A1001 will be described. As described in (1), the stock quantity of the commodity A in the warehouse A is 0 after the stock allocation. Here, as described in (1), referring to the current warehouse data 106e in FIG. 5, warehouses associated with the product A are the warehouse A and the warehouse C. For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order 10 of the product A of the Web order No: A1001 from the stock number 10 of the product A in the warehouse C.

  As a result of the allocation by the allocation unit 102a, it was possible to allocate the goods A having the Web order No: A1001 from the warehouse C. As described above, when the products having the same Web order No. can be allocated from the same warehouse, the second creating unit 102c sets the Web order as shown in the third line of the order data 106f and the sales data 106g in FIG. No: For the product A of A1001, an order record and a sales record including “error classification: none” are created.

[3-3. When the allocation destination of the product in the same order details is split into multiple warehouses]
Next, the processing in the case where the allocation destination of the product in the same order detail is broken into a plurality of warehouses will be described in detail with reference to FIG.

(1) Processing for Commodity Specified by Web Order No .: A1000 Referring to the order data 106d in FIG. 6, the commodities specified by Web order No .: A1000 are two products, product A and product B.

  First, a description will be given of the inventory allocation of the product A of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 6, the warehouses associated with the product A are the warehouse A and the warehouse C. However, referring to the allocation priority master 106c in FIG. 3, the warehouse A is higher for the product A. It has priority (1). For this reason, the allocation unit 102a performs the inventory allocation by subtracting 7 out of the 10 orders of the product A of the Web order No: A1000 from the 7 inventory of the product A in the warehouse A. After the stock allocation, the stock quantity of the commodity A in the warehouse A becomes 7−7 = 0.

  Subsequently, the allocating unit 102a allocates three unsuccessfully allocated products out of the ten orders of the product A with the Web order No: A1000. That is, the allocating unit 102a performs the inventory allocation by subtracting 3 which is the unallocated amount of the product A of the Web order No: A1000 from the stock quantity 20 of the product A in the warehouse C. After the stock allocation, the stock quantity of the commodity A in the warehouse C is 20-3 = 17.

  Next, a description will be given of the inventory allocation of the product B of the web order No: A1000. Referring to the current warehouse data 106e in FIG. 6, the warehouse associated with the product B is only the warehouse C. For this reason, the allocation unit 102a performs the inventory allocation by subtracting the order number 5 of the product B of the web order No: A1000 from the inventory number 20 of the product B in the warehouse C. After the stock allocation, the stock quantity of the product B in the warehouse C is 20-5 = 15.

  As a result of the allocation in the allocation unit 102a, of the 10 products A having the Web order No .: A1000, 7 can be allocated from the warehouse A, and the remaining 3 can be allocated from the warehouse C. Further, the allocation destination of the commodity B having the Web order No .: A1000 was the warehouse C.

  As described above, when a product having the same Web order No. can be allocated from a plurality of warehouses, the second creating unit 102c, as shown in the first line of the order data 106f in FIG. Web order No .: A1000, product name: product A, and warehouse name of the warehouse (corresponding to the outgoing warehouse) to which the allocation was made: warehouse A, and the number of stocks reduced from warehouse A for seven items of product A ( An order record including 7) and an error classification: warning * is created. In addition, as shown in the first line of the sales data 106g in FIG. 6, the second creation unit 102c, for seven items of the product A with the Web order No .: A1000, has the Web order No .: A1000 and the product name: the product A. And the warehouse name of the warehouse to which the allocation was made (corresponding to the outgoing warehouse): Warehouse A, the number of stocks reduced from Warehouse A (corresponding to the number of sales): 7, and the error category: Warning * Create

  In the same manner, the second creating unit 102c determines the remaining three items of the product A of the Web order No: A1000 as shown in the second and third lines of the order data 106f and the sales data 106g in FIG. And, for the product B of Web order No: A1000, an order record and a sales record including “error classification: warning *” are created.

  As described above, the second creating unit 102c can store the order record including the warning even when the allocation destination of the product A having the same Web order number: A1000 included in the same order details is a different warehouse. You can create sales records.

  The notification unit 102d may notify the operator of “Web order No .: A1000” and “product name: product A, product B” included in the order record and the sales record created by the second creation unit 102c. Based on this notification, the operator refers to the order data 106f and the sales data 106g shown in FIG. 6, and the operator can determine the allocation destinations for seven and three products A having the same Web order No .: A1000. Is a separate warehouse, and among the goods A and B having the same Web order No .: A1000, the allocation destinations for 7 goods A and all the goods B are different warehouses. Can be grasped accurately and quickly. The operator may adjust the outgoing warehouse and the quantity included in the order record and the sales record shown in FIG. 6 as necessary.

(2) Processing for Commodity Specified by Web Order No .: A1001 Next, the inventory allocation of the commodity A of the Web order No .: A1001 will be described. As described in (1), after the stock allocation, the stock quantity of the product A in the warehouse C is 17. For this reason, the allocation unit 102a performs inventory allocation by subtracting the order number 10 of the product A of the Web order No: A1001 from the inventory number 17 of the product A in the warehouse C.

  As a result of the allocation by the allocation unit 102a, it was possible to allocate the goods A having the Web order No: A1001 from the warehouse C. As described above, when the products having the same Web order No. can be allocated from the same warehouse, the second creating unit 102c sets the Web order as shown in the fourth line of the order data 106f and the sales data 106g in FIG. No: For the product A of A1001, an order record and a sales record including “error classification: none” are created.

[3-4. Insufficient inventory]
Finally, a process when the stock is insufficient will be described in detail with reference to FIG.

(1) Processing for Commodity Specified by Web Order No .: A1000 Specific numbers differ for inventory allocation of product A and commodity B specified by Web order No .: A1000 and creation of order record and sales record. However, since the processing method is the same as (1) of [3-1], the description is omitted. The order record and the sales record created for the product A having the Web order No: A1000 are shown in the first line of the order data 106f and the sales data 106g in FIG. 7, and are created for the product B having the Web order No: A1000. The order record and the sales record are shown in the second line of the order data 106f and the sales data 106g in FIG.

(2) Processing for Commodity Specified by Web Order No .: A1001 Next, the inventory allocation of the commodity A of the Web order No .: A1001 will be described. After the stock allocation in (1), the stock quantity of the product A in the warehouse A becomes the stock quantity 10−the order number of the product A of Web order No: A1000 = 10 = 0. Here, referring to the current warehouse data 106e of FIG. 7, the warehouses associated with the product A are the warehouse A and the warehouse C, and the stock quantity 5 of the product A in the warehouse C is the product A of the web order No: A1001. The number of orders has not reached 10 and inventory is insufficient.

  As described above, when there is a product that cannot be allocated for the number of orders among the products having the same Web order number, the third creating unit 102e performs the following processing as illustrated in the third line of the order data 106f in FIG. For the product A of the web order No .: A1001, the web order No .: A1001, the product name: the product A, the warehouse name of the fictitious warehouse: the dummy warehouse, the number of orders: 10, and the error category: yes Create an order record. As described above, when there is insufficient stock, there is no available warehouse, so the third creating unit 102e sets a dummy warehouse registered in advance in the warehouse master 106b of FIG. 3 in the order record. Note that the third creating unit 102e does not create a sales record for the product A of the web order No: A1001.

  When shipping and sales are to be performed based on an order record including a dummy warehouse, the operator issues an instruction from a sales input screen and calls the order record. Upon receiving an instruction from the sales input screen, the display unit 102f displays the order record including the dummy warehouse created by the third creating unit 102e on the sales input screen.

  Then, in the order record including the dummy warehouse displayed on the sales input screen, when the operator changes the warehouse (change of the product or quantity as necessary), the sales record creation unit 102g returns to FIG. As shown in the sales data registration, the dummy warehouse is changed to the warehouse C including the Web order No: A1001 and the product name: the product A, and the order number 10 is changed to 5 which is the stock number that can be allocated from the warehouse C. Create a sales record in which the error is deleted and the error category is "none". Thereby, when the stock is insufficient, it is possible to flexibly cope with shipping only a part (= 5 pieces) of an order quantity (= 10 pieces) from an appropriate warehouse.

[4. Summary]
As described above, according to the order / sales management device 100 according to the present embodiment, it is possible to perform flexible order / sales management according to the stock status of the warehouse, and to generate a warning or an error as needed.

[5. Other Embodiments]
The present invention may be embodied in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

  For example, among the processes described in the embodiment, all or some of the processes described as being performed automatically can be manually performed, or all of the processes described as being performed manually can be performed. Alternatively, a part thereof can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions of each processing, screen examples, and database configurations shown in the present specification and drawings are not described unless otherwise specified. Can be changed arbitrarily.

  Also, regarding the order / sales management device 100, the components shown in the drawings are functionally conceptual, and need not necessarily be physically configured as shown in the drawings.

  For example, all or any part of the processing functions provided in the order receiving / sales management device 100, particularly each processing function performed by the control unit, are realized by the CPU and a program interpreted and executed by the CPU. Or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in the present embodiment. It is read mechanically by the management device 100. That is, in a storage unit such as a ROM or a hard disk drive (HDD), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. The computer program is executed by being loaded into the RAM, and forms a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the order / sales management device 100 via an arbitrary network, and may be downloaded in whole or in part as needed. It is possible.

  Further, a program for executing the processing described in the present embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registered). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical and Digital, Digital, Digital and Digital), DVDs (Digital and Digital Digital, Digital and Digital) Any "portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as a source code or a binary code. The "program" is not necessarily limited to a single program, but may be distributed as a plurality of modules or libraries, or may achieve its function in cooperation with a separate program represented by an OS. Including things. It should be noted that a known configuration and procedure can be used for a specific configuration and reading procedure for reading a recording medium in each apparatus described in the embodiment, an installation procedure after reading, and the like.

  Various databases and the like stored in the storage unit are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. It stores programs, tables, databases, files for web pages, and the like.

  Further, the order / sales management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device to which an arbitrary peripheral device is connected. Further, the order / sales management apparatus 100 may be realized by mounting software (including a program or data) for realizing the processing described in the present embodiment on the apparatus.

  Further, the specific form of the distribution / integration of the apparatus is not limited to the illustrated one, and all or a part of the apparatus may be functionally or physically separated in arbitrary units according to various additions or the like or according to the functional load. Can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

  INDUSTRIAL APPLICABILITY The present invention is useful in, for example, an industry that performs inventory management and shipping using a plurality of warehouses, and is particularly useful in a logistics industry, a retail industry, and the like.

100 Order / sales management device 102 Control unit
102a allocation section
102b First creation unit
102c Second creation unit
102d notification section
102e Third creation unit
102f display unit
102g Sales record creation unit 104 Communication interface unit 106 Storage unit
106a Product master
106b warehouse master
106c Allocation priority master
106d Order data
106e Current library data
106f Order data
106g Sales data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

An order / sales management device including a control unit and a storage unit,
In the storage unit,
Order data including order identification data for identifying an order, product identification data for identifying a product, and the number of orders for the product,
Inventory data including warehouse identification data for identifying the warehouse, product identification data and the number of stocks of the product,
A priority master including priority set in the case where the warehouse is assigned as a destination and set for each product;
Is stored,
The control unit includes:
For the product specified by the product identification data in the order data, among the warehouses specified by the warehouse identification data in the inventory data associated with the product identification data, the product specified in the priority order master Allocation means for performing inventory allocation by decreasing the number of stocks until the number of orders is reached, in order from the warehouse having the highest priority set for,
As a result of the allocation by the allocation means, if all of the specified goods having the same order identification data can be allocated from the same warehouse, the order identification data is obtained based on the order data and the stock data. First creation means for creating an order record and a sales record including the warehouse identification data and the number of stocks reduced from the warehouse for the warehouse to which the product identification data and the allocation have been made,
As a result of the allocation by the allocation means, if the identified items having the same order identification data can be allocated from a plurality of warehouses, based on the order data and the inventory data, the order identification data and A warning indicating that the allocation destination is a plurality of warehouses for the product having the same order identification data as the product identification data and the warehouse identification data for the warehouse to which the allocation is made and the stock quantity reduced from the warehouse. A second creating means for creating an order record and a sales record including
As a result of the allocation by the allocation means, among the specified products having the same order identification data, if there is a product that cannot be allocated for the number of orders, based on the order data and the stock data, The order identification data, the product identification data, the fictitious warehouse identification data, which is the warehouse identification data for identifying the fictitious warehouse, and a product having the same order identification data as the number of orders of the specified product. A third creating means for creating an order record including an error that means that there is something that cannot be allocated,
Having,
Order and sales management device characterized by the following. The control unit includes:
Notifying means for notifying an operator of the order identification data and the product identification data included in the order record and the sales record created by the second creating means,
The order / sales management device according to claim 1, wherein: The control unit includes:
Display means for receiving the instruction from the sales input screen and displaying the order record created by the third creation means on the sales input screen,
A real warehouse that includes the order identification data and the product identification data in the displayed order record, and is the warehouse identification data for identifying a warehouse where the fictitious warehouse identification data in the displayed order record exists; Has been changed to identification data, the number of orders in the displayed order record has been changed to the number of stocks that can be allocated from the existing warehouse, and the error in the displayed order record has been deleted. Sales record creation means for creating sales records;
Further comprising:
The order / sales management device according to claim 1 or 2, wherein The order data is data created by an order on a website from a customer,
The order identification data is an order number for identifying an order on the website,
The order / sales management device according to any one of claims 1 to 3, characterized in that: An order / sales management method executed by an information processing device including a control unit and a storage unit,
In the storage unit,
Order data including order identification data for identifying an order, product identification data for identifying a product, and the number of orders for the product,
Inventory data including warehouse identification data for identifying the warehouse, product identification data and the number of stocks of the product,
A priority master including priority set in the case where the warehouse is assigned as a destination and set for each product;
Is stored,
Executed by the control unit,
For the product specified by the product identification data in the order data, among the warehouses specified by the warehouse identification data in the inventory data associated with the product identification data, the product specified in the priority order master An allocation step of performing inventory allocation by decreasing the number of stocks until the number of orders is reached, in order from the warehouse having the highest priority set for,
As a result of the allocation in the allocation step, if all of the specified products having the same order identification data can be allocated from the same warehouse, the order identification data is stored based on the order data and the inventory data. A first creation step of creating an order record and a sales record including the product identification data and the warehouse identification data for the warehouse to which the product was allocated and the number of stocks reduced from the warehouse,
As a result of the allocation in the allocation step, if the identified items having the same order identification data can be allocated from a plurality of warehouses, based on the order data and the inventory data, the order identification data and A warning indicating that the allocation destination is a plurality of warehouses for the product having the same order identification data as the product identification data and the warehouse identification data for the warehouse to which the allocation is made and the stock quantity reduced from the warehouse. A second creation step of creating an order and sales record including
As a result of the allocation in the allocation step, if there is a product that cannot be allocated for the number of orders among the specified products having the same order identification data, the product is determined based on the order data and the stock data. The order identification data, the product identification data, the fictitious warehouse identification data, which is the warehouse identification data for identifying the fictitious warehouse, and a product having the same order identification data as the number of orders of the specified product. A third creation step of creating an order record including an error that means that there is something that cannot be allocated,
Including,
Order management and sales management method. An order / sales management program to be executed by an information processing device including a control unit and a storage unit,
In the storage unit,
Order data including order identification data for identifying an order, product identification data for identifying a product, and the number of orders for the product,
Inventory data including warehouse identification data for identifying the warehouse, product identification data and the number of stocks of the product,
A priority master including priority set in the case where the warehouse is assigned as a destination and set for each product;
Is stored,
For causing the control unit to execute,
For the product specified by the product identification data in the order data, among the warehouses specified by the warehouse identification data in the inventory data associated with the product identification data, the product specified in the priority order master An allocation step of performing inventory allocation by decreasing the number of stocks until the number of orders is reached, in order from the warehouse having the highest priority set for,
As a result of the allocation in the allocation step, if all of the specified products having the same order identification data can be allocated from the same warehouse, the order identification data is stored based on the order data and the inventory data. A first creation step of creating an order record and a sales record including the product identification data and the warehouse identification data for the warehouse to which the product was allocated and the number of stocks reduced from the warehouse,
As a result of the allocation in the allocation step, if the identified items having the same order identification data can be allocated from a plurality of warehouses, based on the order data and the inventory data, the order identification data and A warning indicating that the allocation destination is a plurality of warehouses for the product having the same order identification data as the product identification data and the warehouse identification data for the warehouse to which the allocation is made and the stock quantity reduced from the warehouse. A second creation step of creating an order and sales record including
As a result of the allocation in the allocation step, if there is a product that cannot be allocated for the number of orders among the specified products having the same order identification data, the product is determined based on the order data and the stock data. The order identification data, the product identification data, the fictitious warehouse identification data, which is the warehouse identification data for identifying the fictitious warehouse, and a product having the same order identification data as the number of orders of the specified product. A third creation step of creating an order record including an error that means that there is something that cannot be allocated,
Including,
An order / sales management program characterized by:

Images