Pass-through warehouse setting device, pass-through warehouse setting method, and pass-through warehouse setting program
The transit warehouse setting device automates the selection of transit warehouses by using a control unit to access classification masters, reducing the workload and improving efficiency in logistics operations.
Patent Information
- Application Number
- JP2023212527
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-12-15
- Publication Date
- 2025-06-26
AI Technical Summary
Conventional systems for determining transit warehouses in logistics operations are labor-intensive and difficult to manage, as they rely on human judgment for selecting the appropriate warehouse based on product and store classifications.
A transit warehouse setting device and method that utilize a control unit to access various masters (store master, product master, transit warehouse setting master) to automatically determine and set the transit warehouse based on combinations of store and product classifications, and prioritize warehouse selection using a priority setting master.
This solution significantly reduces the workload of personnel involved in shipping operations by automating the transit warehouse selection process, improving efficiency and accuracy in logistics operations.
Smart Images

Figure 2025096054000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a transit warehouse setting device, a transit warehouse setting method, and a transit warehouse setting program.
Background Art
[0002] For example, in a logistics operation where a supplier ships goods to a store, the goods may be delivered using a transit warehouse. Conventionally, as a system for delivering goods using a transit warehouse, there is, for example, 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, conventionally, since the person inputting the slip has been determining which warehouse to use as a transit, there has been a problem that the determination is difficult and the work load is large.
[0005] The present invention has been made in view of the above circumstances, and an object thereof is to provide a transit warehouse setting device, a transit warehouse setting method, and a transit warehouse setting program capable of reducing the work load of a person in charge when shipping from a supplier to a store using a transit warehouse.
Means for Solving the Problems
[0006] In order to solve the above-described problems and achieve the object, the present invention is a transit warehouse setting device for determining a transit warehouse when shipping goods from a supplier to a store using a transit warehouse, comprising a control unit. The control unit is configured to be able to access a store master in which a store, a store classification, and a store number are registered in association with each other, a product master in which a product and a variety classification are registered in association with each other, a transit warehouse, and a transit warehouse setting master in which a transit warehouse is registered in association with one or a plurality of combinations of a store, a store classification, a store number, and a variety classification. The device further includes a shipping request input means for inputting invoice information including an invoice number, a supplier, a receiving store, a product, and a quantity, and a transit warehouse setting means for determining and setting, as the transit warehouse to be used, the transit warehouse of a record of the transit warehouse setting master associated with one or a plurality of the store classification, store number obtained from the store master using the supplier and the receiving store as keys, and variety classification obtained from the product master using the product as a key, for the invoice information.
[0007] Further, according to one aspect of the present invention, the control unit is further configured to be able to access a priority setting master in which a combination of the presence or absence of settings of a supplier, a store classification, a store number, and a variety classification is associated with a priority order. When there are a plurality of records of the transit warehouse setting master associated with the above, for each record, the transit warehouse setting means may refer to the priority setting master to obtain the priority order, and determine the transit warehouse to be used as the transit warehouse of the record with the smallest priority order.
[0008] Further, according to one aspect of the present invention, the transit warehouse setting master may be configured such that a transit warehouse is set according to a store classification and a variety classification for the same supplier.
[0009] Further, according to one aspect of the present invention, the transit warehouse setting master may be configured such that a transit warehouse is set according to a supplier, a store classification, and a store number.
[0010] Further, according to one aspect of the present invention, the transit warehouse setting master may be configured such that a transit warehouse is set according to a store classification and a variety classification.
[0011] In order to solve the above-described problems and achieve the object, the present invention provides a method for setting a transit warehouse executed by an information processing apparatus including a control unit. The control unit is configured to be able to access a store master in which a store, a store classification, and a store number are registered in association with each other, a product master in which a product and a variety classification are registered in association with each other, a transit warehouse, and a transit warehouse setting master in which a transit warehouse is registered in association with one or a plurality of combinations of a store, a store classification, a store number, and a variety classification. The method includes a shipping request input step of inputting slip information including a slip number, a supplier, a receiving store, a product, and a quantity, which is executed by the control unit; and a transit warehouse setting step of determining and setting, as a transit warehouse, the transit warehouse of a record of the transit warehouse setting master to which one or a plurality of the store classification obtained from the store master using the supplier and the receiving store as keys and the variety classification obtained from the product master using the product as a key are associated with respect to the slip information.
[0012] In order to solve the above-described problems and achieve the object, the present invention provides a transit warehouse setting program for causing an information processing apparatus including a control unit to execute. The control unit is configured to be able to access a store master in which a store, a store classification, and a store number are registered in association with each other, a product master in which a product and a variety classification are registered in association with each other, a transit warehouse, and a transit warehouse setting master in which a transit warehouse is registered in association with one or a plurality of combinations of a store, a store classification, a store number, and a variety classification. The transit warehouse setting program is for causing the control unit to execute a shipping request input step of inputting slip information including a slip number, a supplier, a receiving store, a product, and a quantity, and a transit warehouse setting step of determining and setting, as a transit warehouse, the transit warehouse of a record of the transit warehouse setting master to which one or a plurality of the store classification obtained from the store master using the supplier and the receiving store as keys and the variety classification obtained from the product master using the product as a key are associated with respect to the slip information.
Effects of the Invention
[0013] According to the present invention, there is an effect that it is possible to reduce the workload of the person in charge when shipping from a supplier to a store using a transit warehouse.
Brief Description of Drawings
[0014]
Figure 1
Figure 2
Figure 3
Figure 4
Figure 5
Figure 6
Figure 7
Figure 8
Figure 9
Embodiments for Carrying Out the Invention
[0015] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by the present embodiment.
[0016] [1. Overview] For example, in the logistics operation where a supplier (e.g., a manufacturer) ships products to a store and the store receives the goods, it is common to use transit warehouses for efficient delivery. In this case, the operation rules often determine "which warehouse the logistics will go through". Here, "warehouse" refers to a place where inventory is stored, such as a store, head office, or central warehouse. Since the person inputting the vouchers determines which warehouse to route through based on product classification and store classification, the workload is large in the operation determined by human judgment.
[0017] Therefore, in this embodiment, it is possible to reduce the workload in the case of shipping from a supplier to a store using a transit warehouse.
[0018] Specifically, the transit warehouse setting device of this embodiment uses a transit warehouse setting master to determine the transit warehouse based on combinations of parameters such as the supplier, store classification, store business type, store number, and product type classification. In this case, when multiple transit warehouses are candidates, the transit warehouse is set according to the setting of the priority setting master.
[0019] The transit warehouse setting device of the present invention is applicable to various industries such as food, chemistry, distribution retail, and BtoC. In the following example, the case where the supplier is a manufacturer is taken as an example for explanation, but the present invention is not limited to this, and the supplier may be other than a manufacturer.
[0020] [2. Configuration] FIG. 1 is a block diagram showing an example of the configuration of the transit warehouse setting device 100 according to the present embodiment. In FIG. 1, the transit warehouse setting device 100 is a commercially available desktop personal computer. Note that the transit warehouse setting device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. The transit warehouse setting device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the transit warehouse setting device 100 is communicably connected via an arbitrary communication path.
[0021] The communication interface unit 104 communicably connects the transit warehouse setting device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the transit warehouse setting device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).
[0022] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as the monitor 114.
[0023] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. Further, the storage unit 106 stores a priority setting master 106a, a store master 106b, a product master 106c, a transit warehouse setting master 106d, slip information, transit warehouse information, etc. FIG. 2 is a diagram showing a configuration example of the priority setting master 106a. FIG. 3 is a diagram showing a configuration example of the store master 106b. FIG. 4 is a diagram showing a configuration example of the product master 106c. FIG. 5 is a diagram showing a configuration example of the transit warehouse setting master 106d.
[0024] The priority setting master 106a is a master that sets the priority order of the transit warehouse setting according to the presence or absence of settings for the supplier (supplier code and / or supplier name), store classification, store number, and product classification. As shown in FIG. 2, it can be composed of a table or the like in which combinations of the presence or absence of settings for the supplier, store classification, store number, and product classification are associated with the priority order and registered.
[0025] The store master 106b can be composed of a table or the like in which a store (store code and / or store name) is associated with the store classification and the store number and registered, as shown in FIG. 3.
[0026] The product master 106c can be composed of a table or the like in which a product (product code and / or product name) is associated with the product classification and registered, as shown in FIG. 4.
[0027] The transit warehouse setting master 106d is a master for determining the transit warehouse according to parameters such as the supplier, store classification, store number, and product classification. As shown in FIG. 5, it can be composed of a table or the like in which the transit warehouse is registered in association with the supplier, store classification, store number, and product classification.
[0028] For the transit warehouse setting master 106d, the transit warehouse may be set according to the store classification and product classification for the same supplier. Also, the transit warehouse may be set according to the supplier, store classification, and store number. Further, the transit warehouse may be set according to the store classification and product classification.
[0029] The voucher information may include the voucher number, line, supplier, receiving store, product, and quantity.
[0030] The transit warehouse information (also referred to as "shipment request information") may include the voucher number, line, supplier, receiving store, product, quantity, and transit warehouse.
[0031] Returning to FIG. 1, the control unit 102 is a CPU or the like that comprehensively controls the transit warehouse setting device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.
[0032] The priority setting master 106a, store master 106b, product master 106c, transit warehouse setting master 106d, voucher information, transit warehouse information, etc. stored in the storage unit 106 by the control unit 102 may be provided in other locations (for example, the server 200), as long as the control unit 102 can access them.
[0033] Functionally conceptually, the control unit 102 includes a master maintenance unit 102a, a shipment request input unit 102b, a transit warehouse setting unit 102c, and a screen display control unit 102d.
[0034] The master maintenance section 102a is for performing settings such as data input, addition, change, and update on the priority order setting master 106a, store master 106b, product master 106c, and transit warehouse setting master 106d according to, for example, the operations of the operator on a master maintenance screen (not shown) displayed on the monitor 114.
[0035] The shipping request input section 102b inputs voucher information according to the operations of the person in charge on a shipping request input screen (not shown) displayed on the monitor 114, for example, and stores it in the storage section 106.
[0036] The transit warehouse setting section 102c determines the transit warehouse to be used as the transit warehouse of the record of the transit warehouse setting master 106d to which one or more of the store classification obtained from the store master 106b using the supplier and the receiving store as keys and the variety classification obtained from the product master 106c using the product are linked for the items of the voucher information.
[0037] In this case, when there are multiple records in the linked transit warehouse setting master 106d, the transit warehouse setting section 102c may refer to the priority order setting master 106a for each record to obtain the priority order, and determine the transit warehouse to be used as the transit warehouse of the record with the smallest priority order.
[0038] When the transit warehouse setting section 102c determines the transit warehouse to be used, it creates transit warehouse information (shipping request information) with the transit warehouse added to the voucher information and stores it in the storage section 106.
[0039] The screen display control section 102d controls the display of various screens (for example, master maintenance screen, shipping request input screen, etc.) to be displayed on the monitor 114 and the reception of their inputs.
[0040] [3. Specific Example of Processing] Referring to FIGS. 1 to 9, a specific example of the processing of the control unit 102 of the transit warehouse setting device 100 in the present embodiment will be described. FIGS. 6 to 9 are diagrams showing specific examples (sample data) of the processing of the control unit 102 of the transit warehouse setting device 100 in the present embodiment. With reference to FIGS. 6 to 9, a transit warehouse discrimination image will be described.
[0041] (STEP1) Referring to FIG. 6, STEP1 will be described. In STEP1, data of each master used for transit warehouse discrimination is set. The master maintenance unit 102a sets data for the priority setting master 106a, the store master 106b, the product master 106c, and the transit warehouse setting master 106d, for example, according to operations of an operator on a master maintenance screen (not shown) displayed on the monitor 114.
[0042] FIG. 6(A) shows an example of the data of the priority setting master 106a. The priority setting master 106a has items for supplier, store classification, store number, and presence / absence of product classification setting, and priority. The smaller the value of the priority, the higher the priority is set. Regarding the settings of supplier, store classification, store number, and product classification, the more "yes" there are, the higher the priority is set. For example, in the first row, when the supplier is "yes", the store classification is "yes", the store number is "yes", and the product classification is "yes", the priority is "1", and in the second row, when the supplier is "no", the store classification is "yes", the store number is "yes", and the product classification is "yes", the priority is "2".
[0043] FIG. 6(B) shows an example of the data of the store master 106b. The store master 106b has items for store, store classification, and store number. In the example shown in the figure, in the first row, the store is "0081", the store classification is "A: Mass merchandiser", and the store number is "3: Brand S", and in the second row, the store is "1087", the store classification is "A: Mass merchandiser", and the store number is "5: Brand B".
[0044] Figure 6(C) shows a data example of the product master 106c. The product master 106c has items for products and variety classifications. In the example shown in the figure, the product is "S00001" and the variety classification is "141: Men's suit".
[0045] Figure 6(D) shows a data example of the transit warehouse setting master 106d. The transit warehouse setting master 106d has items for transit warehouses, suppliers, store classifications, store numbers, and variety classifications. "Store classification" is obtained from the store master 106b using the receiving store of the voucher information as a key. "Store format" is obtained from the store master 106b using the receiving store of the voucher information as a key. "Variety classification" is obtained from the product master 106c using the product of the voucher information as a key.
[0046] As examples of settings for the transit warehouse setting master 106d, (1) when different transit warehouses are set according to store classification and variety classification even for the same supplier, (2) when the transit warehouse is set according to the supplier (shipping source manufacturer), store classification, and store number, ···, (4) when the transit warehouse is set according to store classification and variety classification, etc.
[0047] In the example shown in the figure, as an example of (1) when different transit warehouses are set according to store classification and variety classification even for the same supplier, the first line shows the transit warehouse "3", supplier "0143", store classification "A", store number "-", variety classifications "141", "241", "341", "941", "176", "276", "376", "976". Also, as an example of (4) when the transit warehouse is set according to store classification and variety classification, the eighth line shows the transit warehouse "1", supplier "-", store classification "A", store number "-", variety classification "141".
[0048] (STEP2) Referring to Figure 7, STEP2 will be described. In STEP2, voucher information is input in the shipping request input. The shipping request input unit 102b stores the voucher information in the storage unit 106 in response to the operation of the person in charge on a shipping request input screen (not shown) displayed on the monitor 114, for example.
[0049] As shown in Fig. 7, the slip information has the following fields: slip number, line, supplier, receiving store, product, and quantity. In the example shown in the figure, the first line has the slip number "J001," line "1," supplier "0143," receiving store "0081," product "S00001," and quantity "1000."
[0050] (STEP 3) STEP 2 will be described with reference to Fig. 8. In STEP 2, the store master 106b and the product master 106c are referenced for the items of the entered slip information, and a linked record in the transit warehouse setting master 106d is obtained.
[0051] The transit warehouse setting unit 102c determines that the transit warehouse to be used is the one in the record of the transit warehouse setting master 106d that is linked to one or more of the store classification, store name, and product classification obtained from the product master 106c using the supplier and receiving store as keys for the items of the invoice information.
[0052] The following describes the first line of the slip information in Fig. 7 as an example. The store classification "A: Mass Merchandise Store" and the store name "3: Brand S" are obtained from the product master 106c using the receiving store "0081" as a key, and the product classification "141: Men's Suit" obtained from the product master 106c is obtained using the product "S00001" as a key.
[0053] A record of the transit warehouse setting master 106d that is linked to one or more of the supplier "0143", store category "A: mass retailer", store name "3: brand S", and product category "141: men's suits" is obtained. In this example, the record in the first row (transit warehouse "3", supplier "0143", store category "A", store name "-", product category "141") and the record in the eighth row (transit warehouse "1", supplier "-", store category "A", store name "-", product category "141") are obtained from the transit warehouse setting master 106d.
[0054] If only one record matches, set the transit warehouse to the transit warehouse that uses the transit warehouse of this record, and generate transit warehouse information. In this example, since multiple records match, the transit warehouse is set as follows.
[0055] (STEP4) Referring to FIG. 9, STEP4 will be described. In STEP4, based on the priority setting master 106a, the priority of the transit warehouse setting master 106d is obtained, and the transit warehouse that uses the transit warehouse of the record with the smallest priority value (highest priority) is set.
[0056] When there are multiple records in the associated transit warehouse setting master 106d, for each record, refer to the priority setting master 106a to obtain the priority, and determine that the transit warehouse that uses the transit warehouse of the record with the smallest priority is the transit warehouse.
[0057] FIG. 9(A) shows the records obtained from the transit warehouse setting master 106d (similar to FIG. 8). For the obtained records, refer to the priority setting master 106a to obtain the priority. As shown in FIG. 9(B), for the record of the transit warehouse "3", since the supplier is "0143", the store classification is "A", the store number is "-", and the product classification is "141", using the supplier "yes", the store classification "yes", the store number "none", and the product classification "yes" as keys, the priority "3" is obtained from the priority setting master 106a.
[0058] Also, for the record of the transit warehouse "1", since the supplier is "-", the store classification is "A", the store number is "-", and the product classification is "141", using the supplier "none", the store classification "yes", the store number "none", and the product classification "yes" as keys, the priority "7" is obtained from the priority setting master 106a. Among these, it is determined that the transit warehouse "3" with the lowest priority value of "3" is the transit warehouse to be used.
[0059] After determining the transit warehouse to be used, transit warehouse information is generated. FIG. 9(C) is a diagram showing a data example of the generated transit warehouse information (shipping request information). The transit warehouse information is obtained by adding the transit warehouse to be used to the invoice information, and includes items such as invoice number, line, supplier, receiving store, product, quantity, and transit warehouse. In the example shown in the figure, the first line has an invoice number of "J001", a line of "1", a supplier of "0143", a receiving store of "0081", a product of "S00001", a quantity of "1000", and a transit warehouse of "3". An order is placed with the supplier based on the transit warehouse information (shipping request information), and the products are shipped from the supplier to each store via the transit warehouse.
[0060] As described above, according to this embodiment, a store master 106b in which a store, store classification, and store number are associated and registered, a product master 106c in which a product and product category are associated and registered, a transit warehouse, and one or a plurality of combinations of a store, store classification, store number, and product category are associated and registered. A transit warehouse setting master 106d, a shipping request input unit 102b that inputs invoice information including invoice number, supplier, receiving store, product, and quantity, and for the invoice information, using the supplier and receiving store as keys, the store classification obtained from the store master 106b, and the store number. Since it includes a transit warehouse setting unit 102c that determines and sets the transit warehouse of the record of the transit warehouse setting master 106d to which one or a plurality of product categories obtained from the product master 106c are linked using the product as a key, it is possible to reduce the workload of the person in charge when shipping from the supplier to the store using the transit warehouse.
[0061] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to this embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of the enterprise, so it is possible to contribute to Goals 8 and 9 of the SDGs.
[0062] In addition, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.
[0063] In addition, according to the present embodiment, since it can contribute to strengthening control and governance, it becomes possible to contribute to Goal 16 of the SDGs.
[0064] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.
[0065] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.
[0066] In addition, regarding the information including the processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.
[0067] Regarding the transit warehouse setting device 100, each component shown in the figure is a functional concept, and it is not necessarily physically configured as shown in the figure.
[0068] For example, regarding the processing functions provided by the transit warehouse setting device 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the transit warehouse setting device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.
[0069] In addition, this computer program may be stored in an application program server connected to the transit warehouse setting device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.
[0070] Further, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.
[0071] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singularly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs typified by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.
[0072] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0073] Further, the transit warehouse setting device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the transit warehouse setting device 100 may be realized by installing software (including a program or data, etc.) for realizing the processing described in the present embodiment in the device.
[0074] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or a part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.
Explanation of Signs
[0075] 100 Transit warehouse setting device 102 Control unit 102a Master maintenance unit 102b Shipping request input unit 102c Transit warehouse setting unit 102d Screen display control unit 104 Communication interface unit 106 Storage unit 106a Priority order setting master 106b Store master 106c Product master 106d Transit warehouse setting master 108 Input / output interface unit 112 Input device 114 Output device 300 Network
Claims
1. A transit warehouse setting device that includes a control unit and determines a transit warehouse when shipping goods from a supplier to a store using a transit warehouse, wherein the control unit is configured to be able to access a store master in which stores, store classifications, and store numbers are registered in association with each other, a product master in which products and product type classifications are registered in association with each other, and a transit warehouse setting master in which a transit warehouse is registered in association with one or more combinations of a transit warehouse, a store, a store classification, a store number, and a product type classification, and includes a shipping request input means for inputting invoice information including an invoice number, a supplier, a receiving store, a product, and a quantity, and a transit warehouse setting means for determining and setting, as the transit warehouse to be used, the transit warehouse of a record in the transit warehouse setting master to which one or more product type classifications obtained from the product master using the product as a key and store classifications and store numbers obtained from the store master using the receiving store and the supplier as keys are associated with respect to the invoice information. A transit warehouse setting device characterized by comprising the above.
2. The control unit is further configured to be able to access a priority setting master in which combinations of the presence or absence of settings of a supplier, a store classification, a store number, and a product type classification are associated with priorities, and when there are a plurality of records in the transit warehouse setting master to which the above are associated, the transit warehouse setting means refers to the priority setting master for each record to obtain a priority, and determines, as the transit warehouse to be used, the transit warehouse of the record with the smallest priority. The transit warehouse setting device according to claim 1.
3. The transit warehouse setting master is characterized in that a transit warehouse is set according to a store classification and a product type classification for the same supplier. The transit warehouse setting device according to claim 1 or 2.
4. The transit warehouse setting master is characterized in that a transit warehouse is set according to a supplier, a store classification, and a store number. The transit warehouse setting device according to claim 1 or claim 2.
5. The transit warehouse setting master is characterized in that a transit warehouse is set according to a store classification and a product type classification. The transit warehouse setting device according to claim 1 or claim 2.
6. A transit warehouse setting method executed by an information processing device including a control unit, wherein the control unit is configured to be able to access a store master in which stores, store classifications, and store numbers are registered in association with each other, a product master in which products and product type classifications are registered in association with each other, A transit warehouse setting master that registers by associating a transit warehouse with one or more combinations of a store, store classification, store number, and product classification. It is configured to be accessible to. Executed in the control unit. A shipping request input step of inputting invoice information including invoice number, supplier, receiving store, product, and quantity. Regarding the invoice information, a transit warehouse setting step of determining and setting a transit warehouse that uses the transit warehouse of the record of the transit warehouse setting master to which one or more of the store classification obtained from the store master using the supplier and receiving store as keys, the store number, and the product classification obtained from the product master using the product as a key are associated. A transit warehouse setting method characterized by including the above.
7. A transit warehouse setting program for causing an information processing apparatus provided with a control unit to execute, The control unit, A store master that registers by associating a store, store classification, and store number. A product master that registers by associating a product and product classification. A transit warehouse setting master that registers by associating a transit warehouse with one or more combinations of a store, store classification, store number, and product classification. It is configured to be accessible to. In the control unit, A shipping request input step of inputting invoice information including invoice number, supplier, receiving store, product, and quantity. Regarding the invoice information, a transit warehouse setting step of determining and setting a transit warehouse that uses the transit warehouse of the record of the transit warehouse setting master to which one or more of the store classification obtained from the store master using the supplier and receiving store as keys, the store number, and the product classification obtained from the product master using the product as a key are associated. A transit warehouse setting program for causing the above to be executed.
Citation Information
Patent Citations
Delivery planning system and method
JP2004118577A
Delivery chain management system and method
JP2005539330A
Cost-calculating device and cost-calculating system
JP2006259868A
Physical distribution / payment proxy management system
JP2017016473A