JP7821095B2 - Production area management device, production area management method, and production area management program - Google Patents

Description

The present invention relates to a production area management device, a production area management method, and a production area management program.

Patent Document 1 discloses a configuration in which, when ordering fresh produce such as vegetables or meat, the actual order quantity is compared with the inventory quantity, and if the inventory quantity meets the actual order quantity, the seller selects products from origins that meet the buyer's desired classification, such as domestic or imported, and allocates inventory; if the inventory quantity does not meet the actual order quantity, inventory is allocated in order of priority that is advantageous to the seller, such as lowest product cost.

Japanese Patent Application Laid-Open No. 2000-215233

However, the invention described in Patent Document 1 above had the problem that it was not possible to allocate inventory for orders from buyers that met the detailed origin specifications desired by the buyers without the intervention of the sellers.

The present invention was made in consideration of the above-mentioned problems, and aims to provide a production area management device, production area management method, and production area management program that can manage production areas set in advance at the request of customers in a master file, and automatically secure products from the relevant production area in response to orders for fresh foods, etc.

To solve the above-mentioned problems and achieve the objectives, the production area management device of the present invention is a production area management device equipped with a memory unit and a control unit. The memory unit comprises a production area management master that links products, customers, and production areas, and inventory storage means that stores inventory data that links the products, the production areas, and available allocation quantities. The control unit comprises an order acquisition means that acquires order data that sets the ordered products, order quantities, and order customers, an allocation determination means that determines whether the ordered products from the production area that meet the requirements of the order customer can be allocated based on the production area management master, the inventory data, and the order data, and an allocation result acquisition means that, when the allocation determination means determines that the ordered products are available for allocation, acquires an order allocation result that links the ordered products, the order customer, the production area, and the available allocation quantity.

Furthermore, in the production area management device according to the present invention, the production area management master is further set in association with a shipping period, and the order data is further set with an order shipping date.

Furthermore, in the production area management device according to the present invention, the production area management master is further linked to and set with a delivery destination, and the order data is further characterized in that the order delivery destination is set.

Furthermore, in the production area management device according to the present invention, the allocation determination means identifies a record in the production area management master in which the ordered product and the order customer in the order data are set based on the production area management master, the inventory data, and the order data, identifies the inventory data in which the production area of that record is set, and determines whether the ordered product from the production area that meets the requirements of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity.

In addition, in the production area management device of the present invention, the allocation result acquisition means is further characterized in that, when the allocation determination means does not identify the record in the production area management master in which the ordered product and the order customer in the order data are set and determines that allocation is not possible, it identifies the inventory data for the ordered product with the nearest expiration date and acquires a different allocation result set by linking the ordered product, the order customer, the production area set in the inventory data, and the allocation quantity.

In the production area management device according to the present invention, the allocation result acquisition means is further characterized in that, when the allocation determination means identifies the record in the production area management master in which the ordered product and the order customer of the order data are set, identifies the inventory data in which the production area of the record is set, and determines that the available allocation quantity set in the inventory data is lower than the ordered quantity, it acquires a below-allocation result set by linking the ordered product, the order customer, the production area, and the available allocation quantity.

Furthermore, in the production area management device of the present invention, the allocation result acquisition means further displays an inventory inquiry screen by production area on which the inventory data can be selected, and when selected inventory data is selected from the inventory data, acquires the selected allocation result set by linking the ordered product, the order customer, the selected production area set in the selected inventory data, and the allocation quantity.

Furthermore, in the production area management device of the present invention, the allocation result acquisition means displays an order entry screen on which an inventory search instruction for the inventory data can be entered, and when the inventory search instruction is entered, displays the production area-specific inventory inquiry screen on which the inventory data can be selected, and when the selected inventory data is selected from the inventory data, acquires the selected allocation result set by linking the ordered product, the order customer, the selected production area, and the allocation quantity.

Furthermore, in the production area management device according to the present invention, the allocation result acquisition means is further characterized in that it displays a warning message when the selected inventory data in which a non-set production area that is not set in the production area management master is selected from the inventory data on the production area-specific inventory inquiry screen.

Furthermore, in the production area management device according to the present invention, the allocation result acquisition means further displays an order entry screen on which a confirmation instruction for the allocation result can be entered.

Furthermore, in the production area management device according to the present invention, the product is a perishable food product.

The production area management method of the present invention is a production area management method executed by a production area management device equipped with a memory unit and a control unit, wherein the memory unit comprises a production area management master that links products, customers, and production areas together, and inventory storage means that stores inventory data that links the products, the production areas, and available allocation quantities. The method includes an order acquisition step executed by the control unit that acquires order data that sets the ordered product, order quantity, and order customer; an allocation determination step that determines whether the ordered product from the production area that meets the requirements of the order customer can be allocated based on the production area management master, the inventory data, and the order data; and an allocation result acquisition step that, if it is determined that the ordered product is available for allocation in the allocation determination step, acquires an order allocation result that links the ordered product, the order customer, the production area, and the available allocation quantity together.

The production area management program of the present invention is a production area management program to be executed by a production area management device equipped with a memory unit and a control unit. The memory unit includes a production area management master that links products, customers, and production areas, and inventory storage means that stores inventory data that links the products, the production areas, and available allocation quantities. The control unit executes the following steps: an order acquisition step that acquires order data that sets the ordered product, order quantity, and order customer; an allocation determination step that determines whether the ordered product from the production area that meets the requirements of the order customer can be allocated based on the production area management master, the inventory data, and the order data; and an allocation result acquisition step that acquires the order allocation result that links the ordered product, the order customer, the production area, and the available allocation quantity, if it is determined that the ordered product can be allocated in the allocation determination step.

The present invention has the advantage of increasing customer satisfaction by enabling products from the correct origin to be shipped to customers with a specified origin, and reducing food waste by shipping on a first-in, first-out basis to customers without a specified origin. Furthermore, the present invention has the advantage of managing the origin of each product using a lot number, managing the origin of each customer, delivery destination (store/center), and shipping date in a master file, and automatically securing products from the appropriate origin for orders of fresh food. Furthermore, the present invention has the advantage of automating allocations based on the order destination area based on lot numbering rules. Furthermore, the present invention has the advantage of reducing excess orders of fresh food and reducing waste, addressing food waste, a key issue in the SDGs that companies are working to address. Furthermore, the present invention has the advantage of reducing lost sales opportunities and preventing sales declines.

FIG. 1 is a block diagram showing an example of the configuration of a production area management device according to this embodiment. FIG. 2 is a diagram showing an example of the production area management master in this embodiment. FIG. 3 is a diagram showing inventory data in this embodiment. FIG. 4 is a flowchart showing an example of processing performed by the production area management device in this embodiment. FIG. 5 is a flowchart showing an example of processing performed by the production area management device in this embodiment. FIG. 6 is a diagram showing an example of a production area management process in this embodiment. FIG. 7 is a diagram showing an example of a production area management process in this embodiment. FIG. 8 is a diagram showing an example of a production area management process in this embodiment. FIG. 9 is a diagram showing an example of a production area management process in this embodiment. FIG. 10 is a diagram showing an example of a production area management process in this embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to this embodiment.

[1. Overview]
First, an outline of the present invention will be described.

Traditionally, fresh food wholesalers often specify the origin of the product by business partner (customer/delivery destination) and season when placing an order (for example, if the customer is a high-end restaurant, a specific origin may be specified).

As a result, previously, the decision of which origin to ship products to which customer was left to the warehouse staff during shipping operations, and the number of shipments per origin was managed manually after picking using Excel (registered trademark) or similar. This meant that inventory management by origin was not possible, resulting in inventory waste due to over-ordering and lost sales opportunities due to under-ordering.

In this embodiment, the origin of each product is managed by lot number, and the origin is managed in master data for each customer, delivery destination (store/center), and shipping date. This provides a system that automatically secures products from the corresponding origin for fresh food orders. As a result, this embodiment allows for accurate inventory management of fresh food by origin.

2. Configuration
An example of the configuration of a production area management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a production area management device 100 according to this embodiment.

As shown in FIG. 1, the production area management device 100 is a commercially available desktop personal computer. Note that the production area management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The production area management device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the production area management device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the production area 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 the function of communicating data with other devices via the communication line. Here, the network 300 has the function of connecting the production area management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in conjunction with a mouse. Note that, below, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The memory unit 106 stores various databases, tables, files, and the like. The memory unit 106 also stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The memory unit 106 includes a production area management master 106a and an inventory database 106b.

The production area management master 106a is a master that links products and production areas. Here, the production area management master 106a may be linked to products, customers, and production areas. The production area management master 106a may also be linked to shipping periods. The production area management master 106a may also be linked to delivery destinations. The products may also be perishable foods. The production area management master 106a may also be linked to shipping period start dates, shipping period end dates, production area codes, and/or production area names.

Here, an example of the production area management master 106a in this embodiment will be described with reference to Figure 2. Figure 2 is a diagram showing an example of the production area management master 106a in this embodiment.

As shown in Figure 2, in this embodiment, the origin management master 106a identifies the origin of each product for each customer, delivery destination, and shipping date.

Returning to Figure 1, inventory database 106b stores inventory data for products. Here, inventory database 106b may store inventory data that links products, origins, and available quantities. In addition, inventory data may be linked to lot numbers corresponding to warehouses and origins, expiration dates, and/or inventory quantities.

Here, an example of inventory data in this embodiment will be described with reference to Figure 3. Figure 3 is a diagram showing inventory data in this embodiment.

As shown in Figure 3, in the inventory data of this embodiment, the inventory management unit for products at each warehouse is the lot number (= origin code) that indicates the origin.

Returning to Figure 1, the control unit 102 is a CPU or the like that provides overall control of the production area management device 100. The control unit 102 has internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs. Functionally, the control unit 102 includes an order acquisition unit 102a, an allocation determination unit 102b, and an allocation result acquisition unit 102c.

The order acquisition unit 102a acquires order data that specifies the ordered product. Here, the order acquisition unit 102a may acquire order data that specifies the ordered product, order quantity, and order customer. The order data may also specify the order shipping date. The order data may also specify the order delivery destination. The order acquisition unit 102a may also display an order input screen.

The allocation determination unit 102b determines whether the ordered product can be allocated. Here, the allocation determination unit 102b may determine whether the ordered product, whose production area meets the requirements of the receiving customer, can be allocated based on the origin management master 106a, inventory data, and order data. Furthermore, the allocation determination unit 102b may identify a record in the origin management master 106a in which the ordered product and order customer in the order data are set, based on the origin management master 106a, inventory data, and order data, identify the inventory data in which the origin of that record is set, and determine whether the ordered product, whose production area meets the requirements of the receiving customer, can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity.

The allocation result acquisition unit 102c acquires the allocation result for the ordered product. Here, the allocation result acquisition unit 102c may acquire an order allocation result set by linking the ordered product, order customer, place of origin, and allocation quantity. Furthermore, if the allocation determination unit 102b does not identify a record in the place of origin management master 106a in which the ordered product and order customer in the order data are set and determines that allocation is not possible, the allocation result acquisition unit 102c may identify the inventory data for the ordered product with the nearest expiration date and acquire a different allocation result set by linking the ordered product, order customer, place of origin set in the inventory data, and allocation quantity. Furthermore, when the allocation determination unit 102b identifies a record in the production area management master 106a in which the ordered product and order customer of the order data are set, identifies inventory data in which the production area of the record is set, and determines that the available allocation quantity set in the inventory data is less than the ordered quantity, the allocation result acquisition unit 102c may acquire a below-allocation result set by linking the ordered product, order customer, production area, and the available allocation quantity. Furthermore, the allocation result acquisition unit 102c may display an inventory inquiry screen by production area on which inventory data can be selected, and when selected inventory data is selected from the inventory data, acquire a selected allocation result set by linking the ordered product, order customer, selected production area set in the selected inventory data, and allocated quantity. The allocation result acquisition unit 102c may also display an order entry screen on which an inventory search instruction for inventory data can be entered, and when an inventory search instruction is entered, display an inventory inquiry screen by origin on which inventory data can be selected, and when selected inventory data is selected from the inventory data, acquire a selected allocation result set by linking the ordered product, order customer, selected origin, and allocation quantity. Furthermore, the allocation result acquisition unit 102c may also display a warning message when selected inventory data is selected from the inventory data on the inventory inquiry screen with a non-set origin that is not set in the origin management master 106a. Furthermore, the allocation result acquisition unit 102c may also display an order entry screen on which a confirmation instruction for the allocation result can be entered.

3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[Place of Origin Control Processing]
An example of production area management processing in this embodiment will now be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of processing by the production area management device 100 in this embodiment.

As shown in FIG. 4, the order acquisition unit 102a displays the order input screen on the output device 114, and acquires the order data when the user enters the ordered product, order quantity, order customer, order delivery destination, and order shipping date on the order input screen via the input device 112 (step SA-1).

Then, the allocation determination unit 102b determines whether a record in the production area management master 106a corresponding to the order data can be identified (step SA-2).

If the allocation determination unit 102b determines that it cannot identify a record in the production area management master 106a corresponding to the order data (step SA-2: No), it transitions to step SA-3.

Then, the allocation result acquisition unit 102c identifies the inventory data for the ordered product with the nearest expiration date, and acquires the different allocation results that are set by linking the ordered product, the order customer, the origin set in the inventory data, and the allocation quantity (step SA-3).

Then, the allocation result acquisition unit 102c displays an order entry screen on the output device 114, which allows the user to enter a confirmation instruction for the allocation result. If the user enters a confirmation instruction on the order entry screen via the input device 112, the allocation result is registered (step SA-4) and the process ends.

On the other hand, if the allocation determination unit 102b determines that a record in the production area management master 106a corresponding to the order data can be identified (step SA-2: Yes), it transitions the process to step SA-5.

Then, the allocation determination unit 102b determines whether the available allocation quantity in the inventory data for which the origin of the record in the origin management master 106a corresponding to the order data is set is greater than or equal to the order quantity (step SA-5).

If the allocation determination unit 102b determines that the available allocation quantity is not greater than or equal to the order quantity (the available allocation quantity is less than the order quantity) (step SA-5: No), it transitions to step SA-6.

Then, the allocation result acquisition unit 102c acquires the underallocation result set by linking the ordered product, order customer, origin of the record in the origin management master 106a corresponding to the order data, and the available allocation quantity (step SA-6).

Then, the allocation result acquisition unit 102c determines whether the user has entered an inventory search instruction for inventory data on the order entry screen via the input device 112 (step SA-7).

If the allocation result acquisition unit 102c determines that an inventory search instruction has not been input (step SA-7: No), it transitions the process to step SA-4.

On the other hand, if the allocation result acquisition unit 102c determines that an inventory search instruction has been input (step SA-7: Yes), it discards the underallocation results and transitions to step SA-8.

Then, the allocation result acquisition unit 102c displays an inventory inquiry screen by origin on the output device 114, which allows the user to select inventory data. When the user selects selected inventory data from the inventory data via the input device 112, it acquires the selected allocation results linked to the ordered product, order customer, selected origin set in the selected inventory data, and allocation quantity (step SA-8), and proceeds to step SA-4.

On the other hand, if the allocation determination unit 102b determines that the available allocation quantity is greater than or equal to the order quantity (step SA-5: Yes), it transitions to step SA-9.

Then, the allocation result acquisition unit 102c acquires the order allocation result set by linking the ordered product, order customer, and production area of the record in the production area management master 106a corresponding to the order data, and the allocation quantity (step SA-9), and proceeds to step SA-4.

Now, the record identification process in this embodiment will be described with reference to Figure 5. Figure 5 is a flowchart showing an example of the process performed by the production area management device 100 in this embodiment.

As shown in FIG. 5, after processing in step SA-1, the allocation determination unit 102b determines whether it is possible to identify a record in the production location management master 106a in which the order data's ordered product, order customer, order delivery destination, and shipping period including the order shipment date are set (step SB-1). Here, in this embodiment, the production location management master 106a is referenced when the order shipment date is greater than or equal to the shipping period start date and the order shipment date is less than or equal to the shipping period end date, and if there are multiple matching records, the record with the most recent shipping period start date may be identified.

If the allocation determination unit 102b determines that it can identify a record in the production location management master 106a that contains the order data's ordered product, order customer, order delivery destination, and shipping period including the order shipping date (step SB-1: Yes), it proceeds to step SA-5. In this embodiment, the production location management master 106a is referenced using the product code, customer, delivery destination, and shipping period, and inventory data is referenced using the obtained production location code = lot number. If the order quantity is less than or equal to the inventory quantity for the corresponding lot number, the product may be allocated. (Note that if the order quantity is greater than the inventory quantity for the corresponding lot number, an alert is displayed. After the alert is displayed, the product cannot be allocated, but the order slip can be registered in an unallocated state.)

On the other hand, if the allocation determination unit 102b determines that it cannot identify a record in the production area management master 106a that contains the order data's ordered product, order customer, order delivery destination, and shipping period including the order shipping date (step SB-1: No), it transitions to step SB-2.

Then, the allocation determination unit 102b determines whether it is possible to identify a record in the production area management master 106a that contains the ordered product, order customer, and shipping period including the order shipping date in the order data (step SB-2).

If the allocation determination unit 102b determines that it can identify a record in the production location management master 106a that contains the order data's ordered product, order customer, and shipping period including the order shipping date (step SB-2: Yes), it proceeds to step SA-5. In this embodiment, the production location management master 106a is referenced using the product code, customer, and shipping period, and inventory data is referenced using the obtained production location code = lot number. If the order quantity is less than or equal to the inventory quantity for the corresponding lot number, the product may be allocated. (Note that if the order quantity is greater than the inventory quantity for the corresponding lot number, an alert is displayed. After the alert is displayed, the product cannot be allocated, but the order slip can be registered in an unallocated state.)

On the other hand, if the allocation determination unit 102b determines that it cannot identify a record in the production area management master 106a that contains the order item, order customer, and shipping period including the order shipping date in the order data (step SB-2: No), it transitions to step SB-3.

Then, the allocation determination unit 102b determines whether it is possible to identify a record in the production area management master 106a in which the ordered product, order customer, and order delivery destination of the order data are set (step SB-3).

If the allocation determination unit 102b determines that it can identify a record in the production location management master 106a that contains the ordered product, order customer, and order delivery destination of the order data (step SB-3: Yes), it proceeds to step SA-5. In this embodiment, the production location management master 106a is referenced for the product code, customer, and delivery destination, and inventory data is referenced using the obtained production location code = lot number. If the order quantity is less than or equal to the inventory quantity for the corresponding lot number, the product may be allocated. (Note that if the order quantity is greater than the corresponding lot number, an alert is displayed. After the alert is displayed, the product cannot be allocated, but the order slip can be registered in an unallocated state.)

On the other hand, if the allocation determination unit 102b determines that it cannot identify a record in the production area management master 106a in which the ordered product, order customer, and order delivery destination of the order data are set (step SB-3: No), it transitions to step SB-4.

Then, the allocation determination unit 102b determines whether it is possible to identify the record in the production area management master 106a in which the ordered product and order customer in the order data are set (step SB-4).

If the allocation determination unit 102b determines that it can identify the record in the production location management master 106a in which the ordered product and order customer in the order data are set (step SB-4: Yes), it proceeds to step SA-5. In this manner, in this embodiment, the production location management master 106a is referenced for the product code and customer, and inventory data is referenced using the obtained production location code = lot number. If the order quantity is less than or equal to the inventory quantity for the corresponding lot number, the product may be allocated. (Note that if the order quantity is greater than the inventory quantity for the corresponding lot number, an alert is displayed. After the alert is displayed, the product cannot be allocated, but the order slip can be registered in an unallocated state.)

On the other hand, if the allocation determination unit 102b determines that it cannot identify the record in the production area management master 106a in which the ordered product and order customer in the order data are set (step SB-4: No), it transitions processing to step SA-3. Thus, in this embodiment, if a record cannot be obtained in steps SB-1 to SB-4, inventory data may be referenced, and the inventory with the lot number with the oldest expiration date may be allocated.

In this way, in this embodiment, when an order is entered, the product/customer references the production area management master 106a and checks the inventory data for the corresponding lot number to search for inventory. In steps SB-1 to SB-4, the order can be registered even if the item has not yet been allocated, but inventory data can also be referenced and allocation can be made from another production area.

Furthermore, with reference to Figures 2, 3, and 6, an example of production area management processing in the case where the production area management master 106a in this embodiment exists and allocation is possible will be described. Figure 6 is a diagram showing an example of production area management processing in this embodiment.

As shown in Figure 6, in this embodiment, when the shipping date, sales date, customer, delivery destination, product code, and order quantity are entered on the order entry screen, the origin management master 106a shown in Figure 2 is referenced, record (1) is obtained, and the inventory data for origin code "1" shown in Figure 3 is referenced. Since "order quantity (100 units) <= inventory quantity (500 units)", the lot number and allocation quantity are reflected on the order entry screen.

Furthermore, with reference to Figures 2, 3, and 7, an example of production area management processing in the case where the production area management master 106a in this embodiment does not exist will be described. Figure 7 is a diagram showing an example of production area management processing in this embodiment.

As shown in Figure 7, in this embodiment, when the shipping date, sales date, customer, delivery destination, product code, and order quantity are entered on the order entry screen, the production area management master 106a shown in Figure 2 is referenced, and since no record is obtained, the inventory data shown in Figure 3 is referenced, and the record (3) with the oldest expiration date is obtained, and the lot number and allocation quantity are reflected on the order entry screen.

Furthermore, with reference to Figures 2, 3, and 8 to 10, an example of production area management processing in the case where production area management master 106a in this embodiment exists and allocation is not possible will be described. Figures 8 to 10 are diagrams showing an example of production area management processing in this embodiment.

As shown in Figure 8, in this embodiment, when the shipping date, sales date, customer, delivery destination, product code, and order quantity are entered on the order entry screen, the origin management master 106a shown in Figure 2 is referenced, record (3) is obtained, and the inventory data for origin code "3" shown in Figure 3 is referenced. Since "order quantity (200 units) > inventory quantity (150 units)", an alert is displayed. Note that in this embodiment, if the register button is pressed after the alert is displayed, the lot number and allocation quantity are reflected on the order entry screen. Here, the allocation quantity is set to the maximum number that can be allocated in the inventory data.

As shown in FIG. 9, in this embodiment, when the inventory search button is pressed on the order entry screen, the origin-specific inventory inquiry screen is displayed. When the row of the origin to be changed is double-clicked on the origin-specific inventory inquiry screen, a warning message is displayed stating, "An origin that does not exist in the origin management master by supplier and shipping date has been specified. Do you want to continue processing?" Here, in this embodiment, if a master registration has been made for allocation to another customer, a warning display may be executed to prevent the allocation from being made to another customer without permission. In other words, in this embodiment, if an origin that does not exist in the origin management master 106a is specified when entering an order, a warning message is displayed.

As shown in Figure 10, in this embodiment, the lot number and allocation quantity for the origin selected on the origin-specific inventory inquiry screen are reflected on the order entry screen.

In this way, in this embodiment, when an order slip is registered, the production area management master 106a is referenced and the product with the lot number (product area) is allocated. Here, the production area management master 106a in this embodiment may be set to be variable as a reference key, such as "specify only customer/delivery destination" or "specify only customer." Also, in this embodiment, if there is no registration in the production area management master 106a, product allocation for the lot (product area) may be performed in order of oldest expiration date.

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

Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to SDGs goals 12, 13, and 15.

Furthermore, this embodiment can contribute to strengthening control and governance, thereby contributing to Goal 16 of the SDGs.

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

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

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

Furthermore, with regard to the production area management device 100, the components shown in the figure are functional concepts and do not necessarily have to be physically configured as shown.

For example, all or any part of the processing functions of the production area management device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the production area management device 100 as needed. In other words, a computer program that works in conjunction with the OS to issue commands to the CPU and perform various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and works in conjunction with the CPU to form the control unit.

This computer program may also be stored on an application program server connected to the production area management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and more. This includes any "portable physical media" such as a Blu-ray Disc (registered trademark) and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. It should be noted that a "program" is not necessarily limited to a single structure, but also includes a distributed structure consisting of multiple modules or libraries, or a structure that achieves its function by working in conjunction with a separate program, such as an OS. The specific structure and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known structures and procedures.

The various databases stored in the memory unit 106 are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

The production area management device 100 may also be configured as an information processing device such as a known personal computer or workstation, or as an information processing device connected to any peripheral device. The production area management device 100 may also be implemented by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

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

The present invention is useful in industries that handle fresh food, such as the wholesale industry, transportation industry, warehousing industry, and food industry.

REFERENCE SIGNS LIST 100 Production area management device 102 Control unit 102a Order acquisition unit 102b Allocation determination unit 102c Allocation result acquisition unit 104 Communication interface unit 106 Storage unit 106a Production area management master 106b Stock database 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (15)

A production area management device including a memory unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
The control unit
an order acquisition means for acquiring order data that includes an ordered product, an ordered quantity, and an order customer;
an allocation determination means for identifying a record of the production area management master in which the ordered product and the order customer of the order data are set based on the production area management master, the inventory data, and the order data, identifying the inventory data in which the production area of the record is set, and determining whether the ordered product of the production area that meets the demand of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition means for acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when the allocation determination means determines that allocation is possible, and for identifying the inventory data of the ordered product with the nearest expiration date when the allocation determination means does not identify the record in the place of origin management master in which the ordered product and the order customer of the order data are set and determines that allocation is not possible; and
A production area management device comprising: A production area management device including a memory unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
The control unit
an order acquisition means for acquiring order data that includes an ordered product, an ordered quantity, and an order customer;
an allocation determination means for identifying a record of the production area management master in which the ordered product and the order customer of the order data are set based on the production area management master, the inventory data, and the order data, identifying the inventory data in which the production area of the record is set, and determining whether the ordered product of the production area that meets the demand of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition means for acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when the allocation determination means determines that allocation is possible, and for identifying the record in the place of origin management master in which the ordered product and the order customer of the order data are set, and for identifying the inventory data in which the place of origin of the record is set, and for acquiring a below-allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when the allocation determination means determines that the allocation-available quantity set in the inventory data is less than the ordered quantity;
A production area management device comprising: A production area management device including a memory unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
The control unit
an order acquisition means for acquiring order data that includes an ordered product, an ordered quantity, and an order customer;
an allocation determination means for determining whether the ordered product from the production area that satisfies the request of the order-receiving customer can be allocated based on the production area management master, the inventory data, and the order data;
an allocation result acquisition means for acquiring an order allocation result set by linking the ordered product, the order receiving customer, the production area, and the allocation quantity when the allocation determination means determines that allocation is possible, displaying an inventory inquiry screen by production area on which the inventory data can be selected, and when selected inventory data is selected from the inventory data, acquiring a selected allocation result set by linking the ordered product, the order receiving customer, the selected production area set in the selected inventory data, and the allocation quantity;
A production area management device comprising: The production area management master includes:
Furthermore, shipping periods are linked and set,
The order data is
4. The production area management device according to claim 1, further comprising a shipping date set for the order. The production area management master includes:
Furthermore, delivery destinations are linked and set,
The order data is
4. The production area management device according to claim 1, further comprising a setting for a delivery destination of the order. The allocation result acquisition means
4. The production area management device according to claim 3, wherein, when the allocation determination means determines that allocation is possible, the order allocation result, which is set by linking the ordered product, the order customer, the production area, and the allocation quantity, is acquired , and an order input screen is displayed on which an inventory search instruction for the inventory data can be input, and when the inventory search instruction is input, the production area-specific inventory inquiry screen on which the inventory data can be selected is displayed, and when the selected inventory data is selected from the inventory data, the selected allocation result, which is set by linking the ordered product, the order customer, the selected production area, and the allocation quantity, is acquired. The allocation result acquisition means
Furthermore, the production area management device according to claim 3 or 6, characterized in that when the selected inventory data is selected from the inventory data on the production area inventory inquiry screen, a warning message is displayed when a non - set production area that is not set in the production area management master is set. The allocation result acquisition means
4. The production area management device according to claim 1, further comprising an order entry screen on which a confirmation instruction for the allocation result can be entered. The said product is
4. The production area management device according to claim 1, wherein the product is fresh food. A production area management method to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
Executed in the control unit:
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of identifying a record of the production location management master in which the ordered product and the order customer of the order data are set based on the production location management master, the inventory data, and the order data, identifying the inventory data in which the production location of the record is set, and determining whether the ordered product of the production location that meets the request of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition step for acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the order can be allocated; and for acquiring a different allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the record in the place of origin management master in which the ordered product and the order customer of the order data are set is not identified and the order cannot be allocated ;
A production area management method comprising: A production area management method to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
Executed in the control unit:
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of identifying a record of the production location management master in which the ordered product and the order customer of the order data are set based on the production location management master, the inventory data, and the order data, identifying the inventory data in which the production location of the record is set, and determining whether the ordered product of the production location that meets the request of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition step of acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the order can be allocated; identifying the record of the place of origin management master in which the ordered product and the order customer of the order data are set, identifying the inventory data in which the place of origin of the record is set, and when it is determined that the available allocation quantity set in the inventory data is lower than the order quantity, acquiring a below-allocation result set by linking the ordered product, the order customer, the place of origin, and the available allocation quantity ;
A production area management method comprising: A production area management method to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
Executed in the control unit:
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of determining whether or not the ordered product from the production area that satisfies the request of the order-receiving customer can be allocated based on the production area management master, the inventory data, and the order data;
an allocation result acquisition step of acquiring an order allocation result set by linking the ordered product, the order receiving customer, the production area, and the allocation quantity when it is determined that allocation is possible in the allocation determination step, displaying an inventory inquiry screen by production area on which the inventory data can be selected, and when selected inventory data is selected from the inventory data, acquiring a selected allocation result set by linking the ordered product, the order receiving customer, the selected production area set in the selected inventory data, and the allocation quantity;
A production area management method comprising: A production area management program to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
In the control unit,
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of identifying a record of the production location management master in which the ordered product and the order customer of the order data are set based on the production location management master, the inventory data, and the order data, identifying the inventory data in which the production location of the record is set, and determining whether the ordered product of the production location that meets the request of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition step for acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the order can be allocated; and for acquiring a different allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the record in the place of origin management master in which the ordered product and the order customer of the order data are set is not identified and the order cannot be allocated ;
A production area management program to implement this. A production area management program to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
In the control unit,
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of identifying a record of the production location management master in which the ordered product and the order customer of the order data are set based on the production location management master, the inventory data, and the order data, identifying the inventory data in which the production location of the record is set, and determining whether the ordered product of the production location that meets the request of the order customer can be allocated based on a comparison between the available allocation quantity set in the inventory data and the order quantity;
an allocation result acquisition step of acquiring an order allocation result set by linking the ordered product, the order customer, the place of origin, and the allocation quantity when it is determined in the allocation determination step that the order can be allocated; identifying the record of the place of origin management master in which the ordered product and the order customer of the order data are set, identifying the inventory data in which the place of origin of the record is set, and when it is determined that the available allocation quantity set in the inventory data is lower than the order quantity, acquiring a below-allocation result set by linking the ordered product, the order customer, the place of origin, and the available allocation quantity ;
A production area management program to implement this. A production area management program to be executed by a production area management device having a storage unit and a control unit,
The storage unit
A production area management master that links products, customers, and production areas,
an inventory storage means for storing inventory data that is set by linking the product, the place of origin, and the available quantity;
Equipped with
In the control unit,
an order acquisition step for acquiring order data including an order item, an order quantity, and an order customer;
an allocation determination step of determining whether or not the ordered product from the production area that satisfies the request of the order-receiving customer can be allocated based on the production area management master, the inventory data, and the order data;
an allocation result acquisition step of acquiring an order allocation result set by linking the ordered product, the order receiving customer, the production area, and the allocation quantity when it is determined that allocation is possible in the allocation determination step, displaying an inventory inquiry screen by production area on which the inventory data can be selected, and when selected inventory data is selected from the inventory data, acquiring a selected allocation result set by linking the ordered product, the order receiving customer, the selected production area set in the selected inventory data, and the allocation quantity;
A production area management program to implement this.