Movement instruction management device, movement instruction management method, and movement instruction management program
The movement instruction management system automates transaction classification and warehouse determination, addressing the inefficiencies in sales and rental operations by reducing manual workload and preventing inventory errors.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2024-09-26
- Publication Date
- 2026-04-07
AI Technical Summary
In industries that engage in both sales and rental businesses, such as construction, there is a lack of automated logic to determine transaction classification and shipping destinations, leading to increased workload and complexity in issuing movement instructions.
A movement instruction management system that utilizes a control unit to access part number, warehouse, and personnel masters, automatically determining transaction classification and warehouse ranks based on operator input, reducing the need for manual judgment.
Automated determination of transaction categories and warehouse destinations reduces the workload and prevents inventory mix-ups, enhancing efficiency in warehouse operations.
Smart Images

Figure 2026059634000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a movement instruction management device, a movement instruction management method, and a movement instruction management program.
Background Art
[0002] For example, there is an industry that conducts both sales and rental businesses. For example, in a factory (warehouse), when receiving a request to rent one prefabricated building from sales to a construction site, the columns and roof are moved to the site as rental assets, but curtains and blinds need to be shipped to the site as inventory assets because they are consumables. In addition, rental assets may be sold in a new state. Conventionally, as a system for giving movement instructions for warehouse inventory, for example, there is Patent Document 1.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, in a factory, depending on the items to be shipped, there may be a case where it is necessary to perform a process different from the process requested from sales, but since there is no logic for automatically determining the transaction classification in the details and the shipping source / destination, it is necessary to input by human judgment, and there is a problem that the work of the person in charge is complicated and the work load is high.
[0005] The present invention has been made in view of the above, and an object thereof is to provide a movement instruction management device, a movement instruction management method, and a movement instruction management program capable of reducing the work load of a person in charge when giving a movement instruction for a product in a warehouse when receiving a request from a requester in sales and rental businesses.
Means for Solving the Problems
[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a movement instruction management device equipped with a control unit that issues warehouse movement instructions when a request is received from a client in sales and rental operations, wherein the control unit is configured to access a part number master in which part numbers and asset classifications are registered in association with each other, a warehouse master in which warehouses, departments, and warehouse ranks defining warehouse types are registered in association with each other, and a processing classification list in which processing classifications, warehouse ranks of outgoing warehouses, and warehouse ranks of receiving warehouses are registered, and in response to the operator's operation on the movement instruction input screen, the device issues a movement instruction including the movement instruction number, processing classification, outgoing warehouse, and receiving warehouse based on the processing classification, department, outgoing warehouse, and receiving warehouse specified by the client. The system is characterized by having a movement instruction input means that creates detailed data including movement instruction number, actual processing
[0007] Furthermore, according to one aspect of the present invention, the processing categories may include new product sales, rental asset dispatch, and used product sales.
[0008] Furthermore, according to one aspect of the present invention, the warehouse rank may include inventory warehouses, rental asset warehouses, and virtual rental warehouses.
[0009] Furthermore, according to one aspect of the present invention, the control unit is further configured to access a master of personnel in which personnel and departments are registered in association, and when a personnel is specified on the movement instruction input screen, the department is retrieved from the master of personnel using the specified personnel as a key and automatically assigned.
[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention provides a movement instruction management method executed by a movement instruction management device that provides warehouse movement instructions when a request is received from a client in sales and rental operations, wherein the control unit is configured to be able to access a part number master, which is registered by associating part numbers and asset classifications; a warehouse master, which is registered by associating warehouses, departments, and warehouse ranks that define warehouse types; and a processing classification list, which is registered by processing classifications, warehouse ranks of outgoing warehouses, and warehouse ranks of receiving warehouses, and the control unit executes a movement instruction management method based on the processing classification, department, outgoing warehouse, and receiving warehouse of the client specified by the operator on the movement instruction input screen, and the movement instruction number, processing classification, outgoing warehouse, The process includes a movement instruction input step which creates movement instruction header data including warehouses and receiving warehouses, imports details including product number and quantity, retrieves warehouses from the warehouse master using the department as the key, determines the actual processing category based on the requester's processing category and the asset category obtained from the product number master using the product number as the key, retrieves the warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as the key, determines the warehouses corresponding to the retrieved warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse as the outgoing warehouse and receiving warehouse respectively, and creates movement instruction detail data including movement instruction number, actual processing category, product number, number of movement instructions, outgoing warehouse, and receiving warehouse.
[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention is a movement instruction management program to be executed by a movement instruction management device that provides movement instructions to a warehouse when a request is received from a client in sales and rental operations, the control unit being configured to access a part number master in which part numbers and asset classifications are registered in association with each other, a warehouse master in which warehouse ranks defining warehouses, departments, and warehouse types are registered in association with each other, and a processing classification list in which processing classifications, warehouse ranks of outgoing warehouses, and warehouse ranks of receiving warehouses are registered, and the control unit is configured to provide the movement instruction number, processing classification, outgoing warehouse, and receiving warehouse, based on the processing classification, department, outgoing warehouse, and receiving warehouse specified by the client in response to the operator's operation on the movement instruction input screen, including This is a movement instruction management program that executes a movement instruction input process, which involves creating movement instruction header data, importing details including part number and quantity, obtaining warehouses from the warehouse master using the department as the key, determining the actual processing category based on the requester's processing category and the asset category obtained from the part number master using the part number as the key, obtaining the warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as the key, determining the warehouses corresponding to the obtained warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse as the outgoing warehouse and receiving warehouse respectively, and creating movement instruction detail data including movement instruction number, actual processing category, part number, number of movement instructions, outgoing warehouse, and receiving warehouse. [Effects of the Invention]
[0012] According to the present invention, in sales and rental operations, it is possible to reduce the workload of the person in charge when giving instructions to move goods in the warehouse upon receiving a request from the client. [Brief explanation of the drawing]
[0013] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of a movement instruction management device. [Figure 2] Figure 2 is a diagram illustrating a specific example of the movement instruction input process in the movement instruction input unit. [Figure 3] FIG. 3 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 18]FIG. 18 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 19] FIG. 19 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 20] FIG. 20 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 21] FIG. 21 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 22] FIG. 22 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 23] FIG. 23 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 24] FIG. 24 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 25] FIG. 25 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 26] FIG. 26 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 27] FIG. 27 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit. [Figure 28] FIG. 28 is a diagram for explaining a specific example of the movement instruction input process of the movement instruction input unit.
Embodiments for Carrying Out the Invention
[0014] Hereinafter, embodiments of the movement instruction management device, movement instruction data creation method, and movement instruction data creation program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited by this embodiment.
[0015] [Summary of the Invention] The summary of the present invention will be described in the order of [1-1. Background and Problems], [1-2. Solution and Effects], and [1-3. Explanation of Terms in this Specification].
[0016] [1-1. Background / Issues] This invention is applicable to industries that engage in sales and rental businesses, such as the construction industry that sells and rents temporary housing and prefabricated buildings. The products handled by this invention can be broadly divided into the following two types.
[0017] (1) Inventory: Purchased goods and company-manufactured goods. These are shipped and sold for projects such as construction and demolition work. (2) Rental assets... These are mainly rented to construction sites and returned to the company warehouse when the rental period ends. Furthermore, whether they are inventory assets or rental assets depends on which warehouse they are stored in.
[0018] Traditionally, for example, when a sales representative requested the rental of a prefabricated building to a construction site, the pillars and roof were moved to the site as rental assets, but curtains and blinds, being consumables, had to be shipped to the site as inventory assets. Furthermore, rental assets were sometimes sold in new condition. In short, the factory had to perform different processing procedures depending on the item being shipped, depending on the specific item requested by sales.
[0019] However, previously, there was no logic to automatically determine the transaction type or the warehouse where the goods were shipped or received, so manual input was required. This resulted in cumbersome processing and a high workload for the person in charge.
[0020] [1-2. Solution and Effects] In this invention, the transaction classification of the details is automatically determined based on the asset classification stored in the product number master, and the outgoing warehouse and receiving warehouse are automatically determined from the automatically determined transaction classification, department, and warehouse rank information, thereby reducing the workload of personnel when issuing instructions for moving goods in warehouses during sales and rental operations.
[0021] According to the present invention, the transaction category and the warehouse to which items are shipped and received are automatically determined, eliminating the need for human judgment. This prevents inventory items from being mistakenly mixed into warehouses for rental assets and reduces the workload of the person in charge.
[0022] [1-3. Explanation of Terms Used in This Specification] (1) Sale of new products: Sell inventory assets and rental assets in new condition to construction sites. (2) Departure of rental assets... Depart the rental assets to the warehouse (site) where they are currently being rented. (3) Sale of used goods... The rental assets that were rented out as per the process in (2) are returned as used goods, assembled, and sold.
[0023] [2. Structure] An example of the configuration of the movement instruction management device 100 according to this embodiment will be described with reference to Figure 1. Figure 1 is a block diagram showing an example of the configuration of the movement instruction management device 100.
[0024] The mobile instruction management device 100 is a commercially available desktop personal computer. However, the mobile instruction management device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.
[0025] The movement instruction management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the movement instruction management device 100 is connected to communicate via any communication path.
[0026] The communication interface unit 104 connects the mobile instruction 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 a communication line. Here, the network 300 has the function of connecting the mobile instruction 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). Data such as various masters, which will be described later, may be stored in the server 200, for example.
[0027] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.
[0028] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.
[0029] The storage unit 106 stores, for example, a product number master 106a, a warehouse master 106b, a person in charge master 106c, a list of processing categories (also called "movement instruction categories"), and movement instruction data. The storage unit 106 also includes a conversion master for converting various codes and names, such as project codes (numbers) and project names, department codes and department names, and movement instruction category codes and movement instruction category names, which is referenced by the control unit 102 when converting codes and names.
[0030] The part number master 106a can consist of tables that register part numbers (part number codes and / or part number names) and asset categories in association.
[0031] Warehouse Master 106b can consist of tables that associate and register warehouses (warehouse code and / or warehouse name), department codes, and warehouse ranks that define the type of warehouse.
[0032] The Person in Charge Master 106c can consist of tables that associate and register persons in charge (person in charge code and / or person in charge name) and departments (department code and / or department name).
[0033] The processing category list may include the processing category (actual processing category), the outbound warehouse, the incoming warehouse, and the target asset category.
[0034] Movement instruction data consists of movement instruction header data and movement instruction detail data. The movement instruction header data may include the movement instruction number, processing category, movement instruction date, project (project number and / or project name), order number, person in charge (person in charge code and / or person in charge name), shipping warehouse (shipping warehouse code and / or shipping warehouse name), and receiving warehouse (receiving warehouse code and / or receiving warehouse name).
[0035] The movement instruction details data may include the movement instruction number, processing category, movement instruction date, order details number, product (product code and / or product name), number of items to be moved, shipping warehouse (shipping warehouse code and / or shipping warehouse name), and receiving warehouse (receiving warehouse code and / or receiving warehouse name).
[0036] The control unit 102 is a CPU or similar component that comprehensively controls the movement instruction management device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0037] The control unit 102 is configured to access the part number master 106a, warehouse master 106b, person in charge master 106c, processing category list, etc., which are stored in the storage unit 106. Note that the part number master 106a, warehouse master 106b, person in charge master 106c, processing category list, etc. may be located in another location (for example, on the server 200), as long as the control unit 102 can access them.
[0038] Functionally, the control unit 102 comprises a movement instruction input unit 102a, a master maintenance unit 102b, and a screen display control unit 102c.
[0039] The movement instruction input unit 102a executes movement instruction input processing. For example, in response to the operator's operation on the movement instruction input screen displayed on the monitor 114, if the requester's processing category, department, and outbound warehouse are specified, it creates movement instruction header data including the movement instruction number, processing category, product, outbound warehouse, and inbound warehouse and registers it in the storage unit 106. It also imports details including the product number and quantity, retrieves warehouses from the warehouse master 106b using the department as the key, determines the actual processing category based on the requester's processing category and the asset category obtained from the product number master 106a using the product number as the key, retrieves the warehouse rank of the outbound warehouse and the warehouse rank of the inbound warehouse from the processing category list using the determined actual processing category as the key, determines the warehouses corresponding to the retrieved warehouse rank of the outbound warehouse and the warehouse rank of the inbound warehouse as the outbound warehouse and inbound warehouse, and creates movement instruction detail data including the movement instruction number, actual processing category, product (product number), number of movement instructions (quantity), outbound warehouse, and inbound warehouse and registers it in the storage unit 106.
[0040] The processing categories may include new product sales, rental asset dispatch, and used product sales. The warehouse rank may include inventory warehouses, rental asset warehouses, and rental warehouses. If the processing category is "rental asset dispatch," you may set "virtual warehouse" as the receiving warehouse in the movement instruction header data and movement instruction detail data.
[0041] On the movement instruction input screen, when a person in charge is specified, the department may be automatically retrieved from the person in charge master 106c using the specified person in charge as the key and set accordingly.
[0042] The master maintenance unit 102b is used to input, add, change, and update data for the part number master 106a, warehouse master 106b, person in charge master 106c, and processing category list, in response to operator operations on a master maintenance screen (not shown).
[0043] The screen display control unit 102c controls the display and acceptance of input for various screens (for example, the master maintenance screen, the movement instruction input screen, the movement instruction detail input screen, etc.) to be displayed on the monitor 114.
[0044] [3. Specific Examples] A specific example of the movement instruction input processing of the movement instruction input unit 102a of the movement instruction management device 100 according to this embodiment will be described with reference to Figures 1 to 28. Figures 2 to 28 are diagrams illustrating a specific example of the movement instruction input processing of the movement instruction input unit 102a.
[0045] (Master settings) Figure 2 shows an example of the configuration of the part number master 106a. The part number master 106a can be composed of tables that associate and register part numbers (part number code and / or part number name) and asset categories. In the example shown in the figure, the first row contains part number code SHO001, part number name "corner pillar", and asset category "1: rental asset".
[0046] Figure 3 shows an example of the configuration of warehouse master 106b. Warehouse master 106b can be composed of tables that associate and register warehouse codes, warehouse names, department codes, and warehouse ranks. The warehouse ranks are "0: Inventory Warehouse," "1: Rental Asset Warehouse," and "2: Rental Warehouse (On-site)." "2: Rental Warehouse (On-site)" is a virtual warehouse that manages inventory currently rented to an on-site location and does not have a physical presence.
[0047] In the example shown in the diagram, the first row contains warehouse code S012, warehouse name "Kanazawa Factory House Inventory Warehouse", department code "C001", and warehouse rank "0: Inventory Warehouse".
[0048] Figure 4 shows an example of the configuration of the Person in Charge Master 106c. The Person in Charge Master 106c can be composed of tables that register personnel codes, personnel names, and department codes in association. In the example shown in the figure, the first row contains personnel code "10001", personnel name "Sato", and department code "C001".
[0049] (List of processing categories) Figure 5 shows an example of a processing category list. The processing category list may include the processing category (actual processing category), the warehouse from which the goods are shipped, the warehouse from which they are received, and the target asset category. In the example shown in the figure, the first row is: processing category "20: New product sales", warehouse from which goods are shipped "warehouse rank=0", warehouse from which goods are received "-", target asset category "0: inventory assets, 1: rental assets", the second row is: processing category "21: rental asset shipment", warehouse from which goods are shipped "warehouse rank=1", warehouse from which goods are received "warehouse rank=2", target asset category "1: rental assets", and the third row is: processing category "22: used goods sales", warehouse from which goods are shipped "warehouse rank=1", warehouse from which goods are received "-", target asset category "1: rental assets".
[0050] (Automatic logic for determining processing category) Figure 6 is a diagram illustrating the automatic processing classification logic. The movement instruction input unit 102a determines the actual processing classification based on the processing classification of the requester and the rental asset classification of the part number master 106a, using the automatic processing classification classification logic. The movement instruction input unit 102a has the automatic processing classification classification logic (program) shown in Figure 6 implemented in it. In Figure 6, for example, in the example shown in the first row, if the processing classification of the requester is "20: New product sales" and the rental asset classification of the part number master 106a is "0: Inventory assets", the actual processing classification is determined to be "20: New product sales 20".
[0051] (Warehouse retrieval logic) Figure 7 shows an example of warehouse acquisition logic. The movement instruction input unit 102a acquires a warehouse using the warehouse acquisition logic shown in Figure 7.
[0052] S1: Obtain the department code by referring to the employee master 106c from the employee listed on the movement instruction input screen. S2: Retrieve the warehouse that matches the department CD from warehouse master 106b. S3: Based on the automatic processing classification logic in Figure 6, the actual processing classification is determined based on the processing classification of the requester and the asset classification obtained from the part number master 106a using the part number as the key. Using the actual processing classification as the key, the warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse are obtained from the processing classification list. For the warehouses obtained in S2, the warehouses corresponding to the obtained warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse are determined as the outgoing warehouse and receiving warehouse, respectively.
[0053] If multiple matching warehouses are found in S3, or if no matching warehouse is found, an error message will be displayed and the details will not be imported.
[0054] The following explains how to input information for (1. New product sales), (2) Rental asset dispatch, and (3) Used product sales on the movement instruction input screen.
[0055] (1. New items for sale) Refer to Figures 8 to 14 to explain the case of selling new products. (1) The sales department requests the Kanazawa factory to sell new products. The Kanazawa factory accepts the request and enters the order on the movement instruction input screen. However, since the specific details of the shipment are not yet finalized, the order is accepted using a dummy product number.
[0056] Figure 8 shows an example of the display of a newly created movement instruction input screen 400. The movement instruction input screen 400 includes a header area for specifying the movement instruction number, movement instruction category, movement instruction date, project number, shipping date, person in charge, department in charge, outbound warehouse, inbound warehouse, and file path / file name; an item import button; an item details area for specifying the details of the movement instruction (line number, movement instruction category, product code, product name, outbound warehouse, inbound warehouse, quantity); and a registration button (not shown).
[0057] In the header area, the "Movement Instruction Number" is automatically assigned upon registration. When a "Responsible Person" is specified, the "Responsible Department" is automatically displayed by retrieving the department from the Responsible Person Master 106c using the specified person as the key. All other items are specified by the operator.
[0058] When the Import Details button is pressed, the details of the specified file path and file name are imported and displayed in the details area. When the Register button (not shown) is pressed, move instruction header data and move instruction detail data are created according to the input content (display content) of the move instruction input screen 400 and registered in the storage unit 106.
[0059] In this example, the header area specifies (displays) the following: Movement instruction category "20 New product sale", Movement instruction date "2024 / 7 / 12", Project No. "PJ0001 Site A New Construction House Erection Work", Shipping date "2024 / 7 / 30", Person in charge "10001 Sato", Department in charge "C001 Kanazawa Factory House", and Outbound warehouse "S012 Kanazawa Factory House Inventory Warehouse". Department in charge "C001" is automatically displayed after being retrieved from the person in charge master 106c using person in charge "10001 Sato" as the key.
[0060] In the details area, the following are specified: line number "1", movement instruction category "New item sale", product code "DAMMY", product name "Dummy part number", shipping warehouse "S012", and quantity "1". Since the shipping details are not yet finalized, a dummy product is specified.
[0061] In this example of input content, when the registration button (not shown) is pressed, the movement instruction header data and movement instruction detail data shown in Figure 9 are created and registered in the storage unit 106.
[0062] Figure 9 shows an example of movement instruction data. Movement instruction data consists of movement instruction header data and movement instruction detail data. Figure 9(A) shows an example of movement instruction header data, and Figure 9(B) shows an example of movement instruction detail data.
[0063] The movement instruction header data may include movement instruction number, processing category, movement instruction date, project number, order number, person in charge, outgoing warehouse code, outgoing warehouse name, receiving warehouse code, and receiving warehouse name. In the example shown in the figure, the movement instruction number is "IS0001", processing category is "New product sale", movement instruction date is "2024 / 7 / 12", project number is "PJ0001", order number is "JU0001", person in charge is "10001", outgoing warehouse code is "S012", outgoing warehouse name is "Kanazawa Factory House Inventory Warehouse", receiving warehouse code is " ", and receiving warehouse name is " ".
[0064] The transfer instruction details data may include transfer instruction number, processing category, transfer instruction date, order details number, product code, product name, transfer quantity, outbound warehouse code, outbound warehouse name, inbound warehouse code, and inbound warehouse name. In the example shown in the figure, the first row contains transfer instruction number "IS0001", processing category "New sale", transfer instruction date "2024 / 7 / 12", order details number "1", product code "DAMMY", product name "Dummy part number", transfer quantity "1", outbound warehouse code "S012", outbound warehouse name "Kanazawa Factory House Inventory Warehouse", inbound warehouse code " ", and inbound warehouse name " ".
[0065] (2) Once the outbound shipment details arrive, call up the transfer instruction slip in modification mode and import the details. Set the details import format (details) from the file path on the transfer instruction input screen.
[0066] Figure 10 shows an example of the display of the movement instruction input screen 400 in modification mode. When a movement instruction number is specified on the movement instruction input screen 400, the movement instruction header data and movement instruction detail data stored in the storage unit 106 are read and displayed using the movement instruction number as the key. Specify the file path and file name in the header area of the movement instruction input screen 400 and press the detail import button to import the detail import format 500 (for example, Excel data). In this example, the file path is "\\filepass..." and the file name is "New Sales_Import Format.xlsx".
[0067] The item import format 500 includes fields for part number code, part number name, quantity, outbound warehouse code, and inbound warehouse code. The part number code and quantity are required fields. In the example shown in the figure, the first line has part number code SHO001, part number name "corner pillar", and quantity "3".
[0068] (3) When the "Import Details" button is pressed, the movement instruction category, outbound warehouse, and inbound warehouse of the details are automatically determined and displayed in the details area. After the automatic determination, the operator can double-click on the details (row) in the details area to open the movement instruction details input screen and modify the values.
[0069] Figure 11 shows the part number master 106a, warehouse master 106b, person in charge master 106c, automatic determination of processing category, and processing category list. Here, we will explain the part number code SHO001, part number name "corner pillar", and quantity "3" on the first line of the detail import format 500. Warehouse "S012" that matches the department CD "C001" is obtained from warehouse master 106b, and according to the automatic determination of processing category logic, the actual processing category "20: new product sales" is determined based on the requester's processing category "20: product sales" and the asset category "1: rental asset" obtained from part number master 106a using part number "SHO001" as the key. Warehouse rank = 0 for the outgoing warehouse is obtained from the processing category list using the actual processing category "20: new product sales" as the key (no warehouse rank is set for the receiving warehouse), and in warehouse master 106b, the obtained warehouse "S012" has a warehouse rank = 0 set for the obtained outgoing warehouse, so warehouse "S012" is determined to be the outgoing warehouse. The same method for setting up the shipping warehouse for product codes SHO004 and SHO005 is available, so we will omit the explanation for that.
[0070] Figure 12 shows an example of the display of the move instruction input screen 400 after importing the details. As shown in Figure 12, the data for each detail is displayed in the detail area. For each detail, for example, you can double-click the target row in the detail area to display the move instruction detail input screen and modify the value. Figures 13(A) to (C) show examples of the display of the move instruction detail input screen for each detail SHO001, SHO004, and SHO005.
[0071] When the registration button (not shown) is pressed with the input content shown in Figure 12, the movement instruction header data and movement instruction detail data are updated as shown in Figure 14.
[0072] (2. Withdrawal of rental assets) Refer to Figures 15 to 21 to explain the case of rental asset retrieval. (1) The sales department requests the Kanazawa factory to sell new products. The Kanazawa factory accepts the request and enters the order on the movement instruction input screen. However, since the specific details of the shipment are not yet finalized, the order is accepted using a dummy product number.
[0073] Figure 15 shows an example of the display of a newly created movement instruction input screen 400. In this example, the header area specifies (displays) the movement instruction category "21 Rental Asset Dispatch", movement instruction date "2024 / 7 / 15", project number "PJ0002 B Temporary Housing Rental Construction", shipping date "2024 / 7 / 22", person in charge "10004 Kobayashi", department in charge "C004 Kanazawa Factory Rental Department", dispatch warehouse "S023 Kanazawa Factory Rental Asset Warehouse", and receiving warehouse "S024 Kanazawa Factory Rental Warehouse (Site)". The department in charge "C004" is automatically displayed after being retrieved from the person in charge master 106c using person in charge "10004 Kobayashi" as the key. In the case of rental asset dispatch, a virtual warehouse is specified in "Receiving Warehouse" to manage inventory that is currently being rented.
[0074] In the details area, the following are specified: line number "1", movement instruction type "rental asset outbound", product code "DAMMY", product name "dummy part number", outbound warehouse "S023", inbound warehouse "S024", and quantity "1". Since the outbound details are not yet finalized, a dummy product is specified.
[0075] In this example of input content, when the registration button (not shown) is pressed, the movement instruction header data and movement instruction detail data shown in Figure 16 are created and registered in the storage unit 106.
[0076] Figure 16(A) shows an example of the data in the movement instruction header. In the example shown in the figure, the movement instruction number is "IS0002", processing category is "Rental Asset Dispatch", movement instruction date is "2024 / 7 / 22", project number is "PJ0002", order number is "JU0002", person in charge is "10004", dispatch warehouse code is "S023", dispatch warehouse name is "Kanazawa Factory Rental Asset Dispatch", receiving warehouse code is "S024", and receiving warehouse name is "Kanazawa Factory Rental Warehouse (On-site)".
[0077] Figure 16(B) shows an example of the data for the movement instruction details. In the example shown in the figure, the first row contains the following information: Movement instruction number "IS0002", Processing category "Rental asset dispatch", Movement instruction date "2024 / 7 / 22", Order detail number "1", Product code "DAMMY", Product name "Dummy part number", Movement instruction quantity "1", Dispatch warehouse code "S023", Dispatch warehouse name "Kanazawa factory rental asset dispatch", Inbound warehouse code "S024", Inbound warehouse name "Kanazawa factory rental warehouse (on site)".
[0078] (2) Once the outbound shipment details arrive, call up the transfer instruction slip in modification mode and import the details. Set the import format from the file path on the transfer instruction input screen.
[0079] Figure 17 shows an example of the display of the movement instruction input screen 400 in modification mode. On the movement instruction input screen 400, when a movement instruction number is specified, the movement instruction header data and movement instruction detail data stored in the storage unit 106 are read and displayed using the movement instruction number as the key. Specify the file path and file name in the header area of the movement instruction input screen 400, and press the detail import button to import the detail import format 500 (for example, Excel data). In this example, the file path is "\\filepass..." and the file name is "rental asset outbound_import format.xlsx".
[0080] In the example shown in the figure, the first line of the item import format 500 has the product code SHO002, the product name "Main House", and the quantity "1".
[0081] (3) When the "Import Details" button is pressed, the movement instruction category, outbound warehouse, and inbound warehouse of the details are automatically determined and displayed in the details area. After the automatic determination, the operator can double-click the details to open the movement instruction details input screen and modify the values.
[0082] Figure 18 shows the part number master 106a, warehouse master 106b, employee master 106c, automatic determination of processing category, and processing category list. In this example, we will explain the part number code SHO002, part number name "Main House", and quantity "1" in the first line of the details. From warehouse master 106b, warehouses "S022, S023, S024" matching department CD "C004" are retrieved. Following the automatic processing classification logic, the actual processing classification "21: Rental Asset Issuance" is determined based on the requester's processing classification "21: Rental Asset Issuance" and the asset classification "1: Rental Asset" obtained from product code master 106a using product code "SHO002" as the key. Using the actual processing classification "21: Rental Asset Issuance" as the key, warehouse rank = 1 for the issuance warehouse and warehouse rank = 2 for the receiving warehouse are retrieved from the processing classification list. In warehouse master 106b, of the retrieved warehouses "S022, S023, S024", "S023" is determined to be an issuance warehouse because the retrieved warehouse rank = 1 is set for the issuance warehouse, and "S024" is determined to be a receiving warehouse because the retrieved warehouse rank = 2 is set for the receiving warehouse.
[0083] Figure 19 shows an example of the display of the move instruction input screen 400 after importing the details. As shown in Figure 19, the data for each detail is displayed in the detail area. For each detail, for example, you can double-click the target row in the detail area to display the move instruction detail input screen and set other items such as the move unit price. Figures 20(A) to (C) show examples of the display of the move instruction detail input screen for each detail SHO002, SHO003, and SHO004.
[0084] When the registration button (not shown) is pressed with the input content shown in Figure 19, the movement instruction header data and movement instruction detail data are updated as shown in Figure 21.
[0085] (3. Sales of used goods) Refer to Figures 22 to 28 to explain the case of selling used goods. (1) The sales department requests the Tokyo factory to sell used goods. The Tokyo factory accepts the request and enters the information on the movement instruction input screen. However, since the specific details of the shipment are not yet finalized, the information is entered using a dummy part number.
[0086] Figure 22 shows an example of the display of a newly created movement instruction input screen 400. In this example, the header area specifies (displays) the movement instruction category "22 Used goods sales", movement instruction date "2024 / 7 / 16", project number "PJ0003 Building C construction site erection work", shipping date "2024 / 8 / 6", person in charge "10008 Sakai", department in charge "B004 Tokyo factory rental department", and shipping warehouse "S005 Tokyo factory rental asset warehouse". The department in charge "B004" is automatically displayed after being retrieved from the person in charge master 106c using person in charge "10008 Sakai" as the key.
[0087] In the details area, the following are specified: line number "1", movement instruction type "rental asset dispatch", product code "DAMMY", product name "dummy part number", dispatch warehouse "S005", and quantity "1". Since the dispatch details are not yet finalized, a dummy product is specified.
[0088] In this example of input content, when the registration button (not shown) is pressed, the movement instruction header data and movement instruction detail data shown in Figure 23 are created and registered in the storage unit 106.
[0089] Figure 23(A) shows an example of the data in the movement instruction header. In the example shown in the figure, the movement instruction number is "IS0003", the processing category is "Used goods sale", the movement instruction date is "2024 / 7 / 16", the project number is "PJ0003", the order number is "JU0003", the person in charge is "10008", the shipping warehouse code is "S005", and the shipping warehouse name is "Tokyo Factory Rental Asset Warehouse".
[0090] Figure 16(B) shows an example of the data for the movement instruction details. In the example shown in the figure, the first row contains the movement instruction number "IS0003", processing category "Used goods sale", movement instruction date "2024 / 7 / 16", order details no. "1", product code "DAMMY", product name "Dummy part number", number of movement instructions "1", shipping warehouse code "S005", and shipping warehouse name "Tokyo factory rental asset warehouse".
[0091] (2) Once the outbound shipment details arrive, call up the transfer instruction slip in modification mode and import the details. Set the import format from the file path on the transfer instruction input screen.
[0092] Figure 24 shows an example of the display of the move instruction input screen 400 in modification mode. Specify the file path and file name in the header area of the move instruction input screen 400, and press the details import button to import the details import format 500 (for example, Excel data). In this example, the file path is "\\filepass..." and the file name is "Used Goods Sales_Import Format.xlsx".
[0093] In the example shown in the figure, the third line of the item import format 500 has the product code "SHO005", the product name "Blind", and the quantity "3".
[0094] (3) When the "Import Details" button is pressed, the details import format 500 is automatically determined, and the item movement instruction category, outbound warehouse, and inbound warehouse are displayed in the details area. After the automatic determination, the operator can double-click on an item (row) in the details area to open the movement instruction details input screen and modify the value.
[0095] Figure 25 shows the part number master 106a, warehouse master 106b, employee master 106c, automatic determination of processing category, and processing category list. In this example, we will explain the part number code "SHO005" and part number name "Blind" on the third line of the detail import format 500. From warehouse master 106b, warehouses "S004, S005, S006" that match department code "B004" are retrieved. Following the automatic processing classification logic, the actual processing classification "20: New product sales" is determined based on the requester's processing classification "22: Used goods sales" and the asset classification "0: Inventory" retrieved from product number master 106a using product number "SHO005" as the key. Using the actual processing classification "20: New product sales" as the key, the warehouse rank of the outgoing warehouse = 0 (no warehouse rank set for the receiving warehouse) is retrieved from the processing classification list. In warehouse master 106b, of the retrieved warehouses "S004, S005, S006", "S004" is determined to be the outgoing warehouse because the retrieved outgoing warehouse has a warehouse rank of 1.
[0096] Figure 26 shows an example of the display of the move instruction input screen 400 after importing the details. As shown in Figure 26, the data for each detail is displayed in the detail area. For each detail, for example, you can double-click the target row in the detail area to display the move instruction detail input screen and modify the details. Figures 27(A) to (C) show examples of the display of the move instruction detail input screen for each detail SHO001, SHO003, and SHO005.
[0097] When the registration button (not shown) is pressed with the input content in Figure 26, the movement instruction header data and movement instruction detail data are updated as shown in Figure 28.
[0098] As described above, according to this embodiment, a part number master 106a is registered with part numbers and asset classifications associated with each other, a warehouse master 106b is registered with warehouses, departments, and warehouse ranks defining warehouse types associated with each other, a processing category list is registered with processing categories, warehouse ranks for outgoing warehouses, and warehouse ranks for receiving warehouses, and in response to the operator's operation on the movement instruction input screen, movement instruction header data is created including the movement instruction number, processing category, outgoing warehouse, and receiving warehouse, based on the processing category, department, outgoing warehouse, and receiving warehouse of the requesting party specified, is created, and details including part numbers and quantities are imported, the warehouse is obtained from the warehouse master using the department as the key, and the processing category of the requesting party and the part number as the key are used to retrieve the item The system includes a movement instruction input unit 102a which determines the actual processing category based on the asset category obtained from the master data, retrieves the warehouse rank of the outgoing warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as a key, determines the warehouses corresponding to the retrieved warehouse rank of the outgoing warehouse and the receiving warehouse as the outgoing warehouse and receiving warehouse respectively for the retrieved warehouses, and creates movement instruction detail data including the movement instruction number, actual processing category, product number, number of movement instructions, outgoing warehouse, and receiving warehouse. Therefore, in sales and rental operations, it is possible to reduce the workload of the person in charge when issuing movement instructions for goods in a warehouse when a request is received from a client.
[0099] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.
[0100] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0101] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0102] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.
[0103] 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 by known methods.
[0104] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.
[0105] Furthermore, with respect to the movement instruction management device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.
[0106] For example, the processing functions of the movement instruction management device 100, particularly those performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the movement instruction management device 100 as needed. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0107] Furthermore, this computer program may be stored on an application program server connected to the movement instruction management device 100 via any network, and it is possible to download all or part of it as needed.
[0108] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, 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 Blu-ray (Registered Trademark) Discs.
[0109] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.
[0110] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0111] Furthermore, the movement instruction management device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the movement instruction management device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.
[0112] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]
[0113] 100 Movement instruction management device 102 Control Unit 102a Movement instruction input section 102b Master Maintenance Department 102c Screen display control unit 104 Communication Interface Section 106 Storage section 106a Part Number Master 106b Warehouse Master 106c Person in Charge Master 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks
Claims
1. A movement instruction management device equipped with a control unit that, in sales and rental operations, issues movement instructions for warehouses when a request is received from a client, The control unit, The part number master, which is registered with the part number and asset category associated, A warehouse master database is registered that associates warehouses, departments, and warehouse ranks that define warehouse types, A list of processing categories, which includes the processing category, the warehouse rank of the outgoing warehouse, and the warehouse rank of the receiving warehouse. It is configured to be accessible, A movement instruction management device characterized by comprising movement instruction input means, which, in response to the operator's operation on the movement instruction input screen, creates movement instruction header data including movement instruction number, processing category, shipping warehouse, and receiving warehouse based on the processing category, department, shipping warehouse, and receiving warehouse of the requesting party specified; also imports details including part number and quantity; retrieves warehouses from the warehouse master using the department as a key; determines the actual processing category based on the processing category of the requesting party and the asset category obtained from the part number master using the part number as a key; retrieves the warehouse rank of the shipping warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as a key; determines the warehouses corresponding to the obtained warehouse rank of the shipping warehouse and the warehouse rank of the receiving warehouse as the shipping warehouse and receiving warehouse, and creates movement instruction detail data including movement instruction number, actual processing category, part number, number of movement instructions, shipping warehouse, and receiving warehouse.
2. The movement instruction management device according to claim 1, characterized in that the processing categories include new product sales, rental asset dispatch, and used product sales.
3. The movement instruction management device according to claim 1 or 2, characterized in that the warehouse rank includes inventory warehouses, rental asset warehouses, and virtual rental warehouses.
4. The control unit further, It is configured to allow access to a master list of personnel who have been registered and associated with their respective departments. The movement instruction management device according to claim 1, characterized in that when a person in charge is specified on the movement instruction input screen, the department is retrieved from the person in charge master and automatically specified using the specified person in charge as the key.
5. A movement instruction management method is performed by a movement instruction management device equipped with a control unit, which issues movement instructions to a warehouse when a request is received from a client in sales and rental operations, The control unit, The part number master, which is registered with the part number and asset category associated, A warehouse master database is registered that associates warehouses, departments, and warehouse ranks that define warehouse types, A list of processing categories, which includes the processing category, the warehouse rank of the outgoing warehouse, and the warehouse rank of the receiving warehouse. It is configured to be accessible, The control unit is executed as follows: A movement instruction management method characterized by including a movement instruction input step, which involves creating movement instruction header data including movement instruction number, processing category, shipping warehouse, and receiving warehouse based on the processing category, department, shipping warehouse, and receiving warehouse specified by the requesting party in response to the operator's operation on the movement instruction input screen, and also importing details including product number and quantity, obtaining warehouses from the warehouse master using the department as a key, determining the actual processing category based on the requesting party's processing category and the asset category obtained from the product number master using the product number as a key, obtaining the warehouse rank of the shipping warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as a key, determining the warehouses corresponding to the obtained warehouse rank of the shipping warehouse and the warehouse rank of the receiving warehouse as the shipping warehouse and receiving warehouse, and creating movement instruction detail data including movement instruction number, actual processing category, product number, number of movement instructions, shipping warehouse, and receiving warehouse.
6. This is a movement instruction management program to be executed by a movement instruction management device equipped with a control unit, which issues movement instructions to a warehouse when a request is received from a client in sales and rental operations. The control unit, The part number master, which is registered with the part number and asset category associated, A warehouse master database is registered that associates warehouses, departments, and warehouse ranks that define warehouse types, A list of processing categories, which includes the processing category, the warehouse rank of the outgoing warehouse, and the warehouse rank of the receiving warehouse. It is configured to be accessible, The control unit, A movement instruction management program for executing a movement instruction input process, which involves creating movement instruction header data including movement instruction number, processing category, shipping warehouse, and receiving warehouse based on the processing category, department, shipping warehouse, and receiving warehouse specified by the requesting party in response to the operator's operation on the movement instruction input screen, importing details including part number and quantity, retrieving warehouses from the warehouse master using the department as the key, determining the actual processing category based on the requesting party's processing category and the asset category obtained from the part number master using the part number as the key, retrieving the warehouse rank of the shipping warehouse and the warehouse rank of the receiving warehouse from the processing category list using the determined actual processing category as the key, determining the warehouses corresponding to the obtained warehouse ranks of the shipping warehouse and receiving warehouse as the shipping warehouse and receiving warehouse, and creating movement instruction detail data including movement instruction number, actual processing category, part number, number of movement instructions, shipping warehouse, and receiving warehouse.
Citation Information
Patent Citations
Physical distribution management apparatus, physical distribution management method and physical distribution management program
JP2019066949A
Data generation device, data generation method and data generation program
JP2019204213A
Work support device, work support method, and work support program
JP2020017012A
Article arrangement support device, article arrangement support method and article arrangement support program
JP2020119022A
Transfer instruction data creation device, transfer instruction data creation method, and transfer instruction data creation program
JP2022086577A