Order entry device, order entry method, and order entry program

Abstract

To provide an order reception input apparatus, an order reception input method, and an order reception input program which can confirm a profit including logistics-related costs upon order reception.SOLUTION: An order reception input apparatus according to an embodiment of the present invention includes order reception input means for acquiring a delivery destination area from a first master using a delivery destination as a key when an inventory, an article, the number of ordered articles, a lot number, a shipment date, the delivery destination, and a delivery service are designated in order reception, acquiring a fare from a second master using the delivery service and the acquired delivery destination area as a key, acquiring a storage fee obtained by a unit price per day acquired from a third master using the inventory and the article as a key × (a difference between the shipment date and a reception date acquired from inventory data using the article and the lot number as a key), and calculating a profit including logistic costs based on the acquired fare and the acquired storage fee.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to an order entry device, an order entry method, and an order entry program. Background Art

[0002] For example, in the food industry that operates on the principle of small profits but quick turnover, it is important to reduce logistics-related costs. If the profit including logistics-related costs is not visible at the time of receiving an order, there are cases where, for example, discounts are provided without considering profits due to a long storage period in a warehouse, which ends up squeezing profits. Conventionally, as a system for calculating gross profit, there is Patent Document 1, for example. Prior Art Documents Patent Documents

[0003] [Patent Document 1] Japanese Unexamined Patent Application Publication No. 2018-160062 Summary of the Invention Problem to be Solved by the Invention

[0004] However, Patent Document 1 does not disclose anything regarding confirming a profit including logistics-related costs at the time of receiving an order.

[0005] The present invention has been made in view of the above, and an object of the present invention is to provide an order entry device, an order entry method, and an order entry program that enable confirmation of a profit including logistics-related costs at the time of receiving an order. Means for Solving the Problem

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides an order entry device equipped with a control unit, wherein the control unit is configured to access a first master registered as relating the delivery destination and the delivery destination area, a second master registered as relating the delivery service, the delivery destination area and the freight charge, a third master registered as relating the warehouse and the daily storage fee for each product, and inventory data including the warehouse, product, lot number and receiving date, and when an order is placed, the warehouse, product, order quantity, lot number, shipping date, delivery destination and delivery service are specified, the delivery destination area is obtained from the first master using the delivery destination as the key, the freight charge is obtained from the second master using the delivery service and the obtained delivery destination area as the key, the storage fee is obtained by multiplying the daily storage fee obtained from the third master using the warehouse and the product as the key by (the shipping date - the receiving date obtained from the inventory data using the product and the lot number as the key), and the gross profit including logistics costs is calculated based on the obtained freight charge and storage fee.

[0007] Furthermore, according to one aspect of the present invention, the gross profit including logistics costs may be calculated as sales amount - cost amount - freight charges - storage charges.

[0008] Furthermore, according to one aspect of the present invention, the third master includes a product master registered in association with a product and a temperature range for storage in a warehouse, and a storage fee unit price master registered in association with a warehouse, a temperature range for storage in a warehouse, and a daily storage fee, and the order input means may obtain the temperature range from the product master using the product as the key, and obtain the daily unit price obtained from the storage fee unit price master using the warehouse and the obtained temperature range as the keys.

[0009] Furthermore, according to one aspect of the present invention, the delivery service may include regular mail or airmail.

[0010] Furthermore, according to one aspect of the present invention, the order input means registers order data having gross profit including order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery method, freight charges, storage charges, and logistics costs in a storage unit, and the control unit may further include order performance inquiry means that extracts and displays order data registered in the storage unit for a specified delivery destination on an inquiry screen displayed on the display unit.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention provides an order entry method executed by an information processing device equipped with a control unit, wherein the control unit is configured to access a first master registered as relating the delivery destination and the delivery destination area, a second master registered as relating the delivery service, the delivery destination area and the freight charge, a third master registered for each product as relating the warehouse and the daily storage fee, and inventory data including the warehouse, product, lot number and receiving date, and the control unit executes the order entry method when an order is received, including the warehouse, product, order quantity, The system is characterized by including an order entry process in which, when a lot number, shipping date, delivery destination, and delivery method are specified, the delivery destination area is obtained from the first master using the delivery destination as the key, the freight charges are obtained from the second master using the delivery method and the obtained delivery destination area as the keys, storage charges are obtained by multiplying the daily storage charge obtained from the third master using the warehouse and the product as the keys by (the shipping date - the arrival date obtained from the inventory data using the product and the lot number as the keys), and gross profit including logistics costs is calculated based on the obtained freight charges and storage charges.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention provides an order entry program for execution in an information processing apparatus equipped with a control unit, wherein the control unit is configured to access a first master registered as relating the delivery destination and the delivery destination area, a second master registered as relating the delivery service, the delivery destination area and the freight charge, a third master registered for each product as relating the warehouse and the daily storage fee, and inventory data including warehouse, product, lot number and receiving date, and the control unit, upon receiving an order, accesses the warehouse, product, order quantity, lot number, and shipping information. This is an order entry program for executing an order entry process in which, when the date, delivery destination, and delivery method are specified, the program retrieves the delivery area from the first master using the delivery destination as the key, retrieves the freight charge from the second master using the delivery method and the retrieved delivery area as the keys, retrieves the storage fee by multiplying the daily storage fee obtained from the third master using the warehouse and the product as the keys by (the shipping date - the arrival date obtained from the inventory data using the product and the lot number as the keys), and calculates the gross profit including logistics costs based on the retrieved freight charge and storage fee. [Effects of the Invention]

[0013] According to the present invention, it becomes possible to confirm the profit, including logistics-related costs, at the time of order placement. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the order entry device according to this embodiment. [Figure 2] Figure 2 shows an example of the data structure and relationships for freight master, delivery destination master, product master, storage fee unit price master, inventory data, order data, and storage fee work. [Figure 3] Figure 3 shows an example of the overall processing flow of the control unit of the order entry device according to this embodiment. [Figure 4] Figure 4 shows sample data to illustrate a specific example of the processing performed by the control unit of the order entry device according to this embodiment. [Figure 5] FIG. 5 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 7] FIG. 7 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 8] FIG. 8 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 9] FIG. 9 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 10] FIG. 10 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. [Figure 11] FIG. 11 is a diagram showing sample data for explaining a specific example of processing performed by a control unit of the order entry device according to the present embodiment. MODE 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 food industry that operates on a thin profit margin, it is important to reduce logistics-related costs. If the profit including logistics-related costs is not visible at the time of order acceptance, there are cases where, for example, discounts are offered without considering profit because the product has stayed in the warehouse for a long period of time, which ends up squeezing profit.

[0017] Therefore, in the present embodiment, by enabling the confirmation (visualization) of profit including logistics-related costs at the time of order acceptance, this information can be used as a guideline for improvement when similar orders are received from the next time onward.

[0018] Specifically, it is used to identify products and customers whose gross margin ratio is decreasing, and is utilized for changing subsequent delivery methods or for pricing (e.g., not indiscriminately discounting old products).

[0019] In the order entry device according to the present embodiment, logistics-related costs such as freight and storage fees can be held in the order entry in a unit-by-item basis. For freight, a freight master is used as a tariff. For storage fees, the storage period is calculated from inventory data, and the calculation is performed by multiplying the storage period by the unit price of a storage fee unit price master.

[0020] In the following description, food is taken as an example of a product, but the present invention is not limited to the food industry, and can also be applied to other industries such as machinery and steel.

[0021] [2. Configuration] An example of the configuration of an order entry device according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the order entry device according to the present embodiment.

[0022] The order entry device 100 is a commercially available desktop personal computer. Note that the order entry device 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and may be a portable information processing apparatus such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

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

[0024] The communication interface unit 104 connects the order entry 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 order entry 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).

[0025] 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, a mouse, a 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.

[0026] 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.

[0027] Furthermore, the storage unit 106 includes a freight master 106a, a delivery destination master 106b, a product master 106c, a storage fee unit price master 106d, a data table 106e, and a work table 106f. Figure 2 shows an example of the data structure and relationships of the freight master 106a, delivery destination master 106b, product master 106c, storage fee unit price master 106d, inventory data, order data, and storage fee work.

[0028] The fare master 106a (second master) can consist of tables that associate and register delivery services (code and / or name), delivery destination areas (code and / or name), fares, etc., including regular or air freight.

[0029] The delivery destination master 106b (first master) can consist of tables, etc., that register delivery destinations (code and / or name) and delivery destination areas (code and / or name) in association.

[0030] Product master 106c can consist of tables that associate and register product information (code and / or name) with the temperature range (code and / or name) for storage in the warehouse.

[0031] The storage fee unit price master 106d can consist of tables that associate and register warehouses (code and / or name), temperature zones (code and / or name), and daily unit prices.

[0032] The product master 106c and the storage fee unit price master 106d constitute a third master, and the product master 106c and the storage fee unit price master 106d may be configured separately or integrated, and may not have a "temperature zone" configuration.

[0033] Data table 106e is a table for storing various types of data, such as inventory data and order data.

[0034] Inventory data may include warehouse (code and / or name), product (code and / or name), lot number, and date of receipt.

[0035] Order data may include order number, order line number, delivery destination code, shipping service code, product code, lot number, shipping date, quantity ordered, sales amount, cost amount, freight charges, storage fees, and gross profit.

[0036] The work table 106f is a table used as the work area of ​​the control unit 102, and generates work data (intermediate data), and includes, for example, a storage fee work for calculating storage fees.

[0037] The storage fee worksheet may be configured to temporarily hold information such as the daily rate, shipping date, receiving date, and storage fee.

[0038] Returning to Figure 1, the control unit 102 is a CPU or similar component that comprehensively controls the order input 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.

[0039] The control unit 102 is configured to access the freight master 106a, delivery destination master 106b, product master 106c, storage fee unit price master 106d, data table 106e, and work table 106f, which are stored in the storage unit 106. Note that the freight master 106a, delivery destination master 106b, product master 106c, storage fee unit price master 106d, data table 106e, and work table 106f may be located elsewhere (for example, on the server 200), as long as the control unit 102 can access them.

[0040] Functionally, the control unit 102 comprises a master maintenance unit 102a, an inventory management unit 102b, an order input unit 102c, an order history inquiry unit 102d, and a screen display control unit 102e.

[0041] The master maintenance unit 102a performs settings such as data input, addition, deletion, and editing for the freight master 106a, delivery destination master 106b, product master 106c, and storage fee unit price master 106d, for example, in response to the operator's operations on the master maintenance screen (not shown) displayed on the monitor 114.

[0042] The inventory management department 102b updates the inventory data in data table 106e in accordance with the arrival and departure of goods from the warehouse.

[0043] The order entry unit 102c, for example, in response to an operator's operation on the order entry screen displayed on the monitor 114 (see Figure 10), when an order is placed and the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service are specified, retrieves the delivery area from a first master (e.g., delivery destination master 106b) using the delivery destination as the key, retrieves the freight charge from a second master (e.g., freight charge master 106a) using the delivery service and the retrieved delivery area as the keys, retrieves the storage charge by multiplying the daily unit price obtained from a third master (e.g., product master 106c and storage charge unit price master 106d) using the warehouse and product as the keys by the calculation (shipping date - arrival date obtained from inventory data using the product and lot number as the keys), calculates the gross profit including logistics-related costs based on the retrieved freight charge and storage charge, and registers order data having the gross profit including the order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery service, freight charge, storage charge, and logistics costs into the data table 106e.

[0044] The order entry unit 102c may calculate the gross profit, including logistics costs, as sales amount - cost amount - freight charges - storage fees.

[0045] The third master may consist of a product master 106c and a storage fee unit price master 106d. The order entry unit 102c may obtain the temperature range from the product master 106c using the product as the key, and obtain the daily unit price from the storage fee unit price master 106d using the warehouse and the obtained temperature range as the keys.

[0046] The order history inquiry unit 102d extracts and displays order data registered in data table 106e for the delivery destination specified by the operator on the order history inquiry screen displayed on monitor 114.

[0047] The screen display control unit 102e controls the display and input of various screens (for example, the master maintenance screen, the order entry screen, the order performance inquiry screen, etc.) displayed on the monitor 114.

[0048] [3. Specific examples] A specific example of the processing of the order entry device 100 in this embodiment will be explained with reference to Figures 1 to 11. Figures 3 to 11 are diagrams illustrating a specific example of the processing of the order entry device 100 in this embodiment.

[0049] (3-1. Overall Processing) Referring to Figure 3, an example of the overall processing of the control unit of the order entry device 100 in this embodiment will be explained. Figure 5 is a diagram illustrating an example of the overall processing of the control unit of the order entry device 100 in this embodiment.

[0050] In Figure 3, the master maintenance unit 102a performs the delivery destination master maintenance process (step S1). Specifically, in the delivery destination master maintenance process, the master maintenance unit 102a sets data in the delivery destination master 106b in response to the operator's operation on, for example, a master maintenance screen (not shown) displayed on the monitor 114.

[0051] The master maintenance unit 102a performs fare master maintenance processing (step S2). Specifically, in fare master maintenance processing, the master maintenance unit 102a sets data in the fare master 106a in response to operator operations on, for example, a master maintenance screen (not shown) displayed on the monitor 114.

[0052] The master maintenance unit 102a performs product master maintenance processing (step S3). Specifically, in product master maintenance processing, the master maintenance unit 102a sets data in the product master 106c in response to the operator's operation on, for example, a master maintenance screen (not shown) displayed on the monitor 114.

[0053] The master maintenance unit 102a performs storage fee unit price master maintenance processing (step S4). Specifically, in the storage fee unit price master maintenance processing, the master maintenance unit 102a sets data in the storage fee unit price master 106d in response to the operator's operation on, for example, a master maintenance screen (not shown) displayed on the monitor 114.

[0054] The order entry unit 102c executes the order entry process (step S5). During the order entry process, when entering an order, the freight charges are calculated based on the delivery destination master 106b and the freight charge master 106a. Additionally, storage charges are calculated using the storage charge work in data table 106e based on the product master 106c, storage charge unit price master 106d, and inventory data. Based on the freight charges and storage charges, a gross profit including logistics-related costs is calculated to simulate the balance sheet.

[0055] Specifically, in the order entry process, the order entry unit 102c, for example, in response to the operator's operation on the order entry screen displayed on the monitor 114 (see Figure 10), when an order is placed and the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery method are specified, retrieves the delivery area from the delivery destination master 106b using the delivery destination as the key, retrieves the freight rate from the freight rate master 106a using the delivery method and the retrieved delivery area as the keys, and retrieves the temperature zone and warehouse obtained from the product master 106c using the product as the key as the key. The storage fee is obtained by multiplying the daily unit price obtained from the storage fee unit price master 106d by (shipping date - arrival date obtained from inventory data using product and lot number as keys). Based on the obtained freight and storage fees, the gross profit (=sales amount - cost amount - freight - storage fee) including logistics-related costs (=freight + storage fee) is calculated, and order data with order number, order line number, product, quantity ordered, lot number, shipping date, delivery destination, delivery method, freight, storage fee, and gross profit including logistics-related costs is registered in data table 106e.

[0056] (3-2. Sample Data) Figures 4 to 11 are diagrams showing sample data to illustrate a specific example of the processing performed by the control unit 102 of the order entry device 100 according to this embodiment. Referring to Figures 4 to 11, a specific example of the processing performed by the control unit 102 of the order entry device 100 according to this embodiment will be explained. In the following explanation, all monetary units will be in "yen," and their notation will be omitted.

[0057] (Assumption data) Figure 4 shows an example of data from the fare master 106a. The fare master 106a includes items such as the delivery service code, delivery area, and fare. In the example shown in the figure, the first row is "HA001: Standard Delivery", delivery area "Kanto Area", and fare "800", the second row is "HA001: Standard Delivery", delivery area "Okinawa Area", and fare "900", and the third row is "HA002: Airmail", delivery area "Okinawa Area", and fare "2500".

[0058] Freight master 106a is not used for actual freight payments (it is for revenue and expenditure simulations), so it deliberately omits detailed information such as weight, origin, destination, and unloading fees to prioritize maintainability. Temperature zones are managed by separating them into different delivery codes. Regarding freight, by having a separate freight master for each physical distance to the delivery destination and each delivery method, it is possible to calculate accurate transportation costs for each transaction.

[0059] Figure 5 shows an example of data in the delivery destination master 106b. The delivery destination master 106b includes items such as delivery destination code and delivery destination area. In the example shown in the figure, the first row contains the delivery destination code "N001 Chiba Co., Ltd." and the delivery destination area "Kanto area," and the second row contains the delivery destination code "N002 Okinawa Co., Ltd." and the delivery destination area "Okinawa area."

[0060] Figure 6 shows an example of data in product master 106c. Product master 106c includes fields for product code and temperature range. In the example shown in the figure, the product code is "12345 Purchased Product A" and the temperature range is "C001 Room Temperature".

[0061] Figure 7 shows an example of data from the storage fee unit price master 106d. The storage fee unit price master 106d includes items such as warehouse code, temperature zone, and daily unit price. In the example shown in the figure, the first row is warehouse code "SO001 Kyobashi Warehouse", temperature zone "C001 Ambient Temperature", and daily unit price "10", the second row is warehouse code "SO001 Kyobashi Warehouse", temperature zone "C002 Refrigerated", and daily unit price "15", and the third row is warehouse code "SO001 Kyobashi Warehouse", temperature zone "C003 Frozen", and daily unit price "20".

[0062] Figure 8 shows an example of inventory data. The inventory data includes fields such as warehouse code, product code, lot number, and receiving date. In the example shown in the figure, the first row is: warehouse code "SO001 Kyobashi Warehouse", product code "12345 Purchased Product A", lot number "lot1234", receiving date "2021 / 12 / 14", the second row is: warehouse code "SO001 Kyobashi Warehouse", product code "12345 Purchased Product A", lot number "lot1235", receiving date "2022 / 1 / 13", and the third row is: warehouse code "SO001 Kyobashi Warehouse", product code "12345 Purchased Product A", lot number "lot1236", receiving date "2021 / 8 / 31".

[0063] Figure 9 shows an example (partial) of order data. The order data includes items such as order number, order line number, delivery destination code, shipping service code, product code, lot number, shipping date, quantity ordered, sales amount, cost amount, freight charges, storage fees, and gross profit. The order number, order line number, delivery destination code, shipping service code, product code, lot number, shipping date, quantity ordered, sales amount, and cost amount are entered, for example, by an operator on the order entry screen. Freight charges, storage fees, and gross profit are calculated by the order entry unit 102c at the time of order placement.

[0064] In the example shown in the figure, the first row contains product code "12345 Purchased Product A", delivery destination code "N001 Chiba Co., Ltd.", lot number "lot1234", and shipping date "2022 / 2 / 14", the second row contains product code "12345 Purchased Product A", delivery destination code "N002 Okinawa Co., Ltd.", lot number "lot1235", and shipping date "2022 / 2 / 13", and the third row contains product code "12345 Purchased Product A", delivery destination code "N002 Okinawa Co., Ltd.", lot number "lot1236", and shipping date "2022 / 1 / 31".

[0065] (S5: Order entry processing) A specific example of order entry processing will be explained with reference to Figures 10 and 11. For example, in response to the operator's operation on the order entry screen (see Figure 10) displayed on the monitor 114, when an order is placed, the order entry unit 102c retrieves the delivery area from the delivery area master 106b using the delivery area as the key, retrieves the freight charge from the freight charge master 106a using the freight charge master 106a using the freight charge master 106c using the temperature zone and warehouse as the key, and retrieves the storage charge unit price master using the temperature zone and warehouse as the key, based on the product used as the key. Storage fees are calculated by multiplying the daily unit price obtained from data table 106d by (the shipping date - the arrival date obtained from inventory data using the product and lot number as keys). Based on the obtained freight and storage fees, gross profit (= sales amount - cost amount - freight - storage fees) including logistics-related costs (= freight + storage fees) is calculated, and order data with gross profit including order number, order line number, product, quantity ordered, lot number, shipping date, delivery destination, delivery method, freight, storage fees, and logistics-related costs is registered in data table 106e.

[0066] Figure 10 shows an example of an order entry screen. The order entry screen consists of a header section, detail section, and footer section. In the header section, the operator specifies (enters) items such as order number, business location, order date, shipping date, customer, person in charge, warehouse, etc. In the detail section, each row number contains items such as product, quantity ordered, freight charge, unit price, sales amount, sales consumption tax, delivery destination, storage fee, consumption tax category, external tax, cost amount, gross profit, lot number, delivery method, standard delivery, and logistics cost.

[0067] The product, order quantity, unit price, sales amount, sales consumption tax, delivery destination, consumption tax category, external tax, cost amount, lot number, and delivery method are specified by the operator, for example. When the execution button (not shown) is pressed, the order input unit 102c retrieves the delivery destination area from the delivery destination master 106b using the delivery destination as the key, retrieves the freight charge from the freight charge master 106a using the delivery method and the retrieved delivery destination area as the keys, retrieves the temperature zone obtained from the product master 106c using the product as the key, and retrieves the storage charge from the storage charge unit price master 106d using the warehouse as the key, calculated as daily unit price × (shipping date - arrival date obtained from inventory data using the product and lot number as the keys), and calculates the logistics cost (= freight charge + storage charge) and gross profit including logistics cost (sales amount - cost amount - logistics cost) based on the retrieved freight charge and storage charge, and displays the freight charge, storage charge, logistics cost, and gross profit.

[0068] The footer section displays the total amount for each detail item (total amount per order number) as determined by the order entry unit 102c, along with the cost amount, gross profit, logistics costs (=total of freight and storage fees for each detail item), and gross profit including logistics costs (gross profit from the footer - logistics costs from the footer).

[0069] When the registration button (not shown) is pressed, order data corresponding to the screen content is displayed in data table 106e.

[0070] In the example shown in the diagram, the header section specifies the order number "J001", business location "100 Tokyo Head Office", order date "2022 / 2 / 13", shipping date "2022 / 2 / 14", customer "A001 △△ Trading Co., Ltd.", and warehouse "SO001 Kyobashi Warehouse".

[0071] Furthermore, for line number "1" in the details section, the following information is specified: Product "12345 Purchased Product A", Order Quantity "10 units", Sales Unit Price "1,000", Sales Amount "10,000", Sales Consumption Tax "200", Delivery Destination "N001 Chiba Co., Ltd.", Consumption Tax Classification "External Tax", Cost Amount "8,000", Lot Number "lot1234", and Delivery Method "HA001 Standard Delivery". When the execution button (not shown) is pressed, the order input unit 102c retrieves the delivery area "Kanto Area" from the delivery destination master 106b using the delivery destination "N001 Chiba Co., Ltd." as the key, and retrieves the freight charge "800" from the freight charge master 106a using the delivery method "HA001 Standard Delivery" and the retrieved delivery area "Kanto Area" as the keys.

[0072] Furthermore, the temperature zone "C001 Ambient Temperature" is retrieved from the product master 106c using product "12345 Purchased Product A" as the key, and the daily unit price "10" is retrieved from the storage fee unit price master 106d using temperature zone "C001 Ambient Temperature" and warehouse "SO001 Kyobashi Warehouse" as the keys. Then, the storage fee "620" is calculated by multiplying the retrieved daily unit price "10" by (shipping date "2022 / 2 / 14" - arrival date "2021 / 12 / 14" obtained from inventory data using product "12345 Purchased Product A" and lot number "lot1234" as the keys). Finally, the logistics cost "1,420 (=800 + 620)" is calculated. In addition, the gross profit including logistics costs "580 (= Sales amount "10,000 - Cost amount "8,000" - Logistics cost "1,420")" is calculated. Then, the calculated freight charges of "800", storage fees of "620", logistics costs of "1,420", and gross profit of "580" are displayed.

[0073] The same method is used for line numbers "2" and "3" in the details section. In the example shown in the diagram, for example, for line number "3" with delivery destination "N002 Okinawa" and shipping method "HA002 Air freight," it is possible to see at the time of order acceptance that the gross profit is a deficit of "-2,030" and to negotiate the unit price.

[0074] In the example shown in Figure 10, when the registration button (not shown) is pressed, order data as shown in Figures 11(A) to (C) is registered in data table 106e.

[0075] Figure 11(A) shows the case of standard delivery to a nearby delivery location (Chiba), Figure 11(B) shows the case of standard delivery to a remote delivery location (Okinawa), and Figure 11(C) shows the case of air freight delivery to a remote delivery location (Okinawa).

[0076] While a profit may appear to be made based on the gross profit of the product alone, it's crucial to understand the total profit including freight and storage costs at the time of order placement. If the profit including logistics costs isn't clear at the time of order placement, there's a risk of offering discounts or other measures without considering profitability, simply because of the long waiting period, ultimately putting pressure on profits. By being able to confirm the profit including logistics costs at the time of order placement, it becomes possible to make rational decisions regarding discounts on products and select delivery methods during negotiations for future transactions.

[0077] The order history inquiry unit 102d extracts and displays order data registered in data table 106e for the delivery destination specified by the operator on the order history inquiry screen displayed on monitor 114.

[0078] Figure 11(D) shows an example of the output of an order history inquiry, and in this figure, an example of the output when the delivery destination "N002 Okinawa Co., Ltd." is specified.

[0079] By checking order performance by delivery destination through the order history inquiry, it is possible to identify anomalies in gross profit from the same delivery destination and use this as a starting point for investigating the cause and making improvements. In this example, it is assumed that the gross profit in the second row of order performance deteriorated because it was delivered by air freight. This can be used to negotiate higher rates for future air travel, or to negotiate against using air travel altogether.

[0080] As explained above, according to this embodiment, the system includes a first master registering the delivery destination and delivery destination area in association, a second master registering the delivery service, delivery destination area, and freight charges in association, a third master registering the warehouse and daily storage fee for each product in association, and an order input unit 102c that, when an order is placed and the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery service are specified, retrieves the delivery destination area from the first master using the delivery destination as the key, retrieves the freight charges from the second master using the delivery service and the retrieved delivery destination area as the keys, retrieves the storage fee by multiplying the daily unit price obtained from the third master using the warehouse and product as the keys by (shipping date - arrival date obtained from inventory data using the product and lot number as the keys), and calculates gross profit including logistics costs based on the retrieved freight charges and storage fees. It will be possible to confirm the profit, including logistics-related costs, at the time of order placement.

[0081] [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.

[0082] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0083] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0084] [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.

[0085] 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.

[0086] 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.

[0087] Furthermore, with respect to the order entry device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0088] For example, the processing functions of the order entry device 100, particularly those performed in 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 the information processing device to execute the processing described in this embodiment, and is mechanically read by the order entry device 100 as needed. That is, a storage unit such as 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.

[0089] Furthermore, this computer program may be stored on an application program server connected to the order entry device 100 via any network, and it is possible to download all or part of it as needed.

[0090] 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.

[0091] 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.

[0092] 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.

[0093] Furthermore, the order entry device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the order entry device 100 may be implemented by installing software (including programs or data, etc.) that realizes the processing described in this embodiment on the device.

[0094] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, 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]

[0095] 100 Order Entry Device 102 Control Unit 102a Master Maintenance Department 102b Inventory Management Department 102c Order Entry Section 102d Order History Inquiry Department 102e Screen display control unit 104 Communication Interface Section 106 Storage section 106a Fare Master 106b Delivery destination master 106c Product Master 106d Storage Fee Unit Price Master 106e Data Table 106f Work Table 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. An order entry device equipped with a control unit, The control unit, The first master, which is registered by associating the delivery destination with the delivery destination area, A second master database is registered that associates the delivery service, the delivery area, and the freight charges. A third master database is registered that associates each product with a warehouse and a daily storage fee. Inventory data including warehouse, product, lot number, and receiving date, It is configured to be accessible, An order entry device characterized by comprising an order entry means that, in response to the operator's operation on the order entry screen, when an order is placed, the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery method are specified, retrieves the delivery destination area from the first master using the delivery destination as the key, retrieves the freight charge from the second master using the delivery method and the retrieved delivery destination area as the key, retrieves the storage charge by multiplying the daily storage charge obtained from the third master using the warehouse and product as the key by (the shipping date - the arrival date obtained from the inventory data using the product and lot number as the key), and calculates and displays the gross profit including logistics costs based on the retrieved freight charge and storage charge.

2. The order entry device according to Claim 1, characterized in that the gross profit including logistics costs is calculated as sales amount - cost amount - freight charges - storage charges.

3. The order entry device according to claim 1, characterized in that the delivery service includes regular mail or air mail.

4. The order input means registers order data having gross profit including order number, order line number, product, order quantity, lot number, shipping date, delivery destination, delivery method, freight charges, storage charges, and logistics costs in the storage unit, The control unit further, The order input device according to any one of claims 1 to 3, characterized in that it is equipped with an order history inquiry means that extracts and displays order data registered in the storage unit for a specified delivery destination on an inquiry screen displayed on the display unit.

5. An order input method executed by an information processing device equipped with a control unit, The control unit, The first master, which is registered by associating the delivery destination with the delivery destination area, A second master database is registered that associates the delivery service, the delivery area, and the freight charges. A third master database is registered that associates each product with a warehouse and a daily storage fee. Inventory data including warehouse, product, lot number, and receiving date, It is configured to be accessible, The control unit executes: An order entry method characterized by including an order entry process in which, in response to the operator's operation on the order entry screen, when an order is placed, the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery method are specified, the delivery destination area is obtained from the first master using the delivery destination as the key, the freight charges are obtained from the second master using the delivery method and the obtained delivery destination area as the keys, storage charges are obtained by multiplying the daily storage charge obtained from the third master using the warehouse and product as the keys by (the shipping date - the arrival date obtained from the inventory data using the product and lot number as the keys), and the gross profit including logistics costs is calculated and displayed based on the obtained freight charges and storage charges.

6. An order entry program to be executed by an information processing device equipped with a control unit, The control unit, The first master, which is registered by associating the delivery destination with the delivery destination area, A second master database is registered that associates the delivery service, the delivery area, and the freight charges. A third master database is registered that associates each product with a warehouse and a daily storage fee. Inventory data including warehouse, product, lot number, and receiving date, It is configured to be accessible, The control unit, An order entry program for executing an order entry process in which, in response to the operator's operation on the order entry screen, when an order is placed, the warehouse, product, order quantity, lot number, shipping date, delivery destination, and delivery method are specified, the program retrieves the delivery destination area from the first master using the delivery destination as the key, retrieves the freight charge from the second master using the delivery method and the retrieved delivery destination area as the key, retrieves the storage charge by multiplying the daily storage charge obtained from the third master using the warehouse and product as the key by (the shipping date - the arrival date obtained from the inventory data using the product and lot number as the key), and calculates and displays the gross profit including logistics costs based on the retrieved freight charge and storage charge.

Images