Order processing system, order processing method, and order processing program

Abstract

To enable a purchasing company to purchase the same commodity at a low cost when the same commodity is ordered from a plurality of ordering companies in a group company.SOLUTION: And order input means for inputting order data including an order number, an ordering company, an order date, a purchasing company in the group company, a row number, a product, an order quantity, a loose unit price which is a normal unit price, and an amount from a plurality of ordering companies in the group company, and generating procurement data including a procurement number, a row number, a purchase date, a supplier, a former order number, a former row number, a product, a purchase quantity, a purchase unit price, and a purchase amount based on a comparison result of an amount of an order lot number * a lot unit price calculated with reference to the order lot master for each product based on the order data and a total amount of loose unit prices * order quantities of the plurality of ordering companies.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to an order processing system, an order processing method, and an order processing program. [Background technology]

[0002] For example, in some cases, group companies (also called "group enterprises") establish purchasing companies (also called "procurement companies") to improve efficiency in procurement, such as by taking advantage of economies of scale to reduce costs. Conventionally, a system related to purchasing for group companies is known, for example, from Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2002-32447 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not mention anything about purchasing at low cost when a purchasing company receives orders for the same product from multiple ordering companies (for example, sales companies) within a group of companies.

[0005] The present invention has been made in consideration of the above, and aims to provide an order processing system, an order processing method, and an order processing program that enable a purchasing company within a group of companies to purchase the same product at low cost when the purchasing company receives orders for the same product from multiple ordering companies. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order processing system that includes a control unit and enables a purchasing company within a group company to place orders for the group companies collectively, the control unit being configured to be able to access a memory area that stores an order lot master that associates and registers supplier, product, order lot number which is the order unit, and lot unit price, and is characterized by having an order input means that inputs order data from multiple ordering companies within the group company, including order number, ordering company, order date, purchasing company within the group company, line number, product, order quantity, individual unit price which is the normal unit price, and amount, and stores it in the memory area, and generates procurement data that includes procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount based on the order data, for each product, and based on the result of comparing the amount of order lot number x lot unit price calculated by referring to the order lot master with the total amount of individual unit price x order quantity from the multiple ordering companies, and stores it in the memory area.

[0007] Furthermore, according to one aspect of the present invention, the order input means may, as the purchase quantity and purchase price, if the order quantity is less than or equal to the number of ordered lots, use the smaller of the amount of the number of ordered lots multiplied by the lot cost or the amount of the order quantity multiplied by the unit price for each item; if the order quantity is greater than the number of ordered lots, the order input means may calculate the "quotient" and "remainder" by dividing the order quantity by the number of ordered lots, and use the unit price for the "quotient" multiplied by the number of ordered lots; if the remainder is less than the unit price for each item divided by the unit price for each item multiplied by the number of ordered lots, the unit price for the "remainder" may be used; and if the remainder is greater than or equal to the unit price for each item divided by the unit price for each item multiplied by the number of ordered lots, the unit price for the remainder may be used;

[0008] According to one aspect of the present invention, the storage area may further store a virtual warehouse linking master that associates a virtual warehouse with an ordering company, the procurement data may further include a warehouse, and the order input means may set a virtual warehouse that is linked to the ordering company of the order data in the virtual warehouse linking master as the warehouse of the procurement data.

[0009] According to one aspect of the present invention, the storage area may further store inventory data including a warehouse specifying a virtual warehouse or a supplier's warehouse, a product, a stock quantity, and a unit, and when a product arrives from a supplier, a purchase input means may be provided that generates purchase data including a purchase number, a line number, a procurement number, a purchase date, a supplier, a warehouse, an original order number, an original line number, a product, a quantity, a purchase price, and a purchase amount based on the procurement data, and updates the inventory data based on the purchase data.

[0010] According to one aspect of the present invention, the purchase input means generates logistics cost data including a purchase number, a date of occurrence, and a total logistics cost, and performs a proportional calculation on the logistics cost data for each burden company, which is the ordering company or the purchasing company, that bears the logistics cost, and generates logistics cost allocation data including the purchase number, a date of occurrence, a burden company, a total logistics cost, the calculated proportionate logistics cost borne by the company, the product, and the quantity, and stores the data in the memory area.

[0011] In addition, according to one aspect of the present invention, the control unit may be provided with a journal entry creation means for creating journal entry data for the ordering company and purchasing company, including the counterparty, debit / credit, account item, and amount, based on the logistics cost allocation data.

[0012] According to another aspect of the present invention, the control unit further generates shipping instruction data including a shipping instruction number, an ordering company, a line number, a shipping date, a product, and a shipping quantity, and stores the generated shipping instruction data in the storage area. On the shipping input screen, the control unit extracts the shipping instruction data stored in the storage area that corresponds to a specified extraction condition, and displays the items of shipping date, shipping instruction number, line number, shipping company, product, shipping quantity, and shipping availability as a shipping slip. At this time, for "shipping availability," the control unit refers to the virtual warehouse linking master using the ordering company of the shipping instruction data as a key, acquires a virtual warehouse, and refers to the inventory data stored in the storage area. The inventory quantity is obtained using the acquired virtual warehouse and the product of the shipping instruction data as keys, and if the inventory quantity is greater than or equal to the shipping instruction quantity, it is displayed as "Available for shipment." If the inventory quantity is less than the shipping instruction quantity, it displays "Transfer processing required" if the supplier warehouse has inventory equal to the shipping instruction quantity for that product, and "Cannot be shipped" if the supplier warehouse does not have inventory equal to the shipping instruction quantity. Based on the shipping slip, shipping data including the shipping number, the ordering company which is the shipping destination, the warehouse from which the product was shipped, the shipping date, the row number, the product, and the quantity is generated and stored in the memory area. At this time, a shipping input means may be provided which does not create shipping data if the inventory quantity is less than the shipping instruction quantity.

[0013] Furthermore, according to one aspect of the present invention, the control unit may further generate transfer data including a transfer number, a line number, a shipping date, an outgoing warehouse which is a supplier warehouse, an incoming warehouse which is a virtual warehouse, a product, and a quantity when the "Shipment possibility" of the invoice to be shipped is "Transfer processing required" on the shipment input screen, and change the company that will bear the logistics cost allocation data to the ordering company linked to the incoming warehouse when the incoming warehouse of the transfer data is registered in the virtual warehouse linking master.

[0014] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an order processing method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a memory area storing an order lot master in which supplier, product, order lot number as an order unit, and lot unit price are registered in association with each other, and the method includes an order input process executed by the control unit to input order data including order number, ordering company, order date, purchasing company within the group company, line number, product, order quantity, bulk unit price as a normal unit price, and amount from multiple ordering companies within a group company, and store the input in the memory area, and based on the order data, generate procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount based on the comparison result between the order lot number x lot unit price calculated by referring to the order lot master and the total amount of the bulk unit price x order quantity from the multiple ordering companies, and store the generated procurement data in the memory area.

[0015] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an order processing program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a memory area that stores an order lot master in which supplier, product, order lot number as an order unit, and lot unit price are registered in association with each other, and the control unit executes an order input process in which the control unit inputs order data including order number, order originating company, order date, purchasing company within the group company, line number, product, order quantity, bulk unit price which is the normal unit price, and amount from multiple ordering companies within a group company and stores the order data in the memory area, and based on the order data, generates procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount based on the result of comparing the amount of order lot number x lot unit price calculated by referring to the order lot master for each product with the total amount of bulk unit price x order quantity from the multiple ordering companies, and stores the generated procurement data in the memory area. [Effects of the Invention]

[0016] According to the present invention, when a purchasing company within a group of companies receives orders for the same product from multiple ordering companies, it is possible to purchase the product at low cost. [Brief explanation of the drawings]

[0017] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an order processing system according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the configuration of the order lot master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the virtual warehouse linking master. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 13]FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 18] FIG. 18 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 19] FIG. 19 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. [Figure 20] FIG. 20 is a diagram for explaining a specific example of the processing of the control unit of the order processing system according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0018] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0019] [1. Overview] The outline of the present invention will be explained in the following order: [1-1. Background], [1-2. Problems], [1-3. Solution], [1-4. Effects], and [1-5. Processing Overview].

[0020] [1-1. Background] For example, some group companies (also called "group enterprises") establish purchasing companies (also called "procurement companies") to improve procurement efficiency, such as by taking advantage of economies of scale to reduce costs. The mission of purchasing companies is to purchase goods at lower costs, due to price competition with other companies and the impact of rising prices in recent years.

[0021] [1-2. Issues] However, within a group of companies, when a purchasing company receives orders for the same product from multiple ordering companies (for example, sales companies), the purchasing company places the order with the supplier at its own discretion, which sometimes results in an order being placed for each sales company individually, resulting in additional purchasing costs.

[0022] [1-3. Solution] In the present invention, when a purchasing company within a group of companies receives orders for the same product from multiple ordering companies, in order to purchase at low cost, the purchase requests from the ordering companies to the purchasing companies within the group of companies are aggregated, and when the purchasing company confirms the order with the supplier, the purchase company compares the unit price at the time of ordering lot x lot order with the unit price x unit price of individual order, and automatically generates the order and makes the order decision.

[0023] [1-4.Effects] According to the present invention, by consolidating the order information of ordering companies and realizing volume discounts, it is possible to reduce purchasing costs and increase profits.

[0024] [1-5. Processing Overview] The outline of the processing flow of the present invention is as follows. 1. Within each group company, multiple ordering companies place orders with purchasing companies. 2. The purchasing company aggregates the order data from multiple ordering companies, determines the order quantity and unit price, and creates procurement data. 3. When goods arrive, the purchasing company creates purchase data based on the procurement data. 4. The purchasing company creates shipping data for the selling company and makes the shipment. 5. If there is an additional shipping request, the purchasing company will ship from the inventory in the supplier's warehouse.

[0025] The present invention is widely applicable to cases where a group company has a purchasing company.

[0026] [2. Configuration] An example of the configuration of an order processing system 100 according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the order processing system 100. The order processing system 100 can be suitably used, for example, in a purchasing company (procurement company) within a group of companies. In the following example, within the group of companies, companies A, B, and C are ordering companies (for example, sales companies), and company D is a purchasing company. The supplier is company E.

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

[0028] The order processing system 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units comprised in the order processing system 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0029] The communication interface unit 104 communicatively connects the order processing system 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 the communication line. Here, the network 300 has a function of communicatively connecting the order processing system 100 with systems 400... of ordering companies and servers 200, etc., and is, for example, the Internet or a LAN (Local Area Network). The systems 400... of ordering companies are, for example, systems of companies A, B, and C, and are configured to be able to communicate data with the order processing system 100.

[0030] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Furthermore, "output" refers to outputting by the output device 114, and includes, for example, display output to the monitor 114, print output by the printer 114, and sending data to the outside.

[0031] The storage unit 106 (storage area) stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0032] The storage unit 106 also stores an order lot master 106a, a virtual warehouse linking master 106b, inventory data, order data, procurement data, purchase data, logistics cost data, logistics cost allocation data, shipping instruction data, journal data, etc. Fig. 2 is a diagram showing an example of the configuration of the order lot master 106a. Fig. 3 is a diagram showing an example of the configuration of the virtual warehouse linking master 106b.

[0033] The order lot master 106a is a master for setting a lot price that is cheaper than the normal unit price when a specified number of units are ordered, and can be configured as a table or the like that associates and registers the supplier (supplier code and / or supplier name), product (product code and / or product name), order lot number, and lot price, as shown in Fig. 2. In the example shown in the same figure, the first line contains the supplier code "E," product code "SH001," order lot number "100," and lot price "4,500 yen."

[0034] The virtual warehouse linking master 106b is a master for linking the virtual warehouse with the purchasing company and the ordering company (sales company), and can be configured as a table or the like in which the virtual warehouse, purchasing company, and sales company are associated and registered, as shown in Fig. 3. In the example shown in the same figure, the first row contains the virtual warehouse "VIA," purchasing company "D," and sales company "A."

[0035] By referencing the virtual warehouse linking master 106b, a virtual warehouse is set for the receiving warehouse and linked to the ordering company. Any increase in the original order quantity is entered into warehouse D of purchasing company D at a fixed value. The virtual warehouse is set up to ensure delivery to the ordering company.

[0036] The inventory data may include a warehouse (warehouse code and / or warehouse name), which may be a virtual warehouse or a supplier warehouse, a product (product code and / or product name), a stock quantity, and a unit.

[0037] The order data may include the order number, the ordering company within the group company (the ordering company's company code and / or ordering company name), the order date, the purchasing company within the group company (the purchasing company code and / or purchasing company name), the row number, the product (product code and / or product name), the quantity, the unit price (normal unit price), and the amount.

[0038] Procurement data may include procurement number, line number, purchase date, supplier code, warehouse (virtual warehouse or purchasing company warehouse), original order number, original line number, product code, product name, purchase quantity, purchase price (unit price or lot price), and purchase amount (= purchase price x purchase quantity).

[0039] The purchasing data may include purchase number, line number, call procurement number, purchase date, supplier (supplier code and / or supplier name), warehouse (warehouse code and / or warehouse name), original order number, original line number, product (product code and / or product name), quantity, unit price, and purchase amount.

[0040] The logistics cost data may include the purchase number, the date of occurrence, and the total logistics cost.

[0041] The distribution cost allocation data may include the purchase number, the date of occurrence, the company that bears the cost, the total distribution cost, the company's distribution cost, the product (product code and / or product name), and the quantity.

[0042] The shipping instruction data may include a shipping instruction number, a company (company code and / or company name), a line number, a shipping date, a product (product code and / or product name), and a quantity.

[0043] The shipping data may include a shipping number, a company (company code and / or company name), a shipping destination, a warehouse from which the goods are shipped, a shipping date, a line number, a product (product code and / or product name), and a quantity.

[0044] The journal data may include the company (company code and / or company name), journal entry number, journal entry line number, processing date, counterparty, debit / credit, account title, amount, and originating document number.

[0045] The transfer data may include a transfer number, a line number, a shipping date, a shipping warehouse, a receiving warehouse, a product (product code and / or product name), and a quantity.

[0046] The control unit 102 is a CPU or the like that performs overall control of the order processing system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0047] The control unit 102 is configured to be able to access the order lot master 106a, virtual warehouse linking master 106b, inventory data, order data, procurement data, purchase data, logistics cost data, logistics cost allocation data, shipping instruction data, journal data, etc. stored in the memory unit 106. Note that the order lot master 106a, virtual warehouse linking master 106b, inventory data, order data, procurement data, purchase data, logistics cost data, logistics cost allocation data, shipping instruction data, journal data, etc. may be provided in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0048] The control unit 102, in terms of functional concept, includes an order input unit 102a, a purchase input unit 102b, a shipment input unit 102c, a journal entry creation unit 102d, a movement input unit 102e, a screen display control unit 102f, and a master maintenance unit 102g.

[0049] For example, in response to access from the ordering company's system 400..., the order input unit 102a inputs order data from multiple ordering companies within the group company, including order number, ordering company, order date, purchasing company within the group company, line number, product, order quantity, bulk price which is the normal unit price, and amount, and stores the data in the memory unit 106.

[0050] Based on the order data stored in the memory unit 106, the order input unit 102a generates procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase price, and purchase amount for each product based on the comparison result between the amount of order lot number x lot unit price calculated by referring to the order lot master 106a and the total amount of the unit price x order quantity from multiple ordering companies, and stores the data in the memory unit 106.

[0051] In addition, the order input unit 102a may use the smaller of the amount of the number of ordered lots multiplied by the lot cost or the amount of the order quantity multiplied by the unit cost as the purchase quantity and purchase price if the order quantity is less than or equal to the number of ordered lots, or if the order quantity is greater than the number of ordered lots, calculate the ``quotient'' and ``remainder'' of the order quantity divided by the number of ordered lots, and use the unit cost for the ``quotient'' multiplied by the number of ordered lots, or use the unit cost for the ``remainder'' if the remainder is less than the unit cost of lot divided by the unit cost multiplied by the number of ordered lots, or use the unit cost for the remainder if the remainder is greater than or equal to the unit cost of lot divided by the unit cost multiplied by the number of ordered lots.

[0052] The procurement data may include a warehouse, and the order input unit 102a may set a virtual warehouse linked to the ordering company of the order data in the virtual warehouse linking master 106b as the warehouse of the procurement data.

[0053] For example, when goods arrive from a supplier, in response to an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, the purchase input unit 102b generates purchase data including purchase number, line number, procurement number, purchase date, supplier, warehouse, original order number, original line number, product, quantity, purchase price, and purchase amount based on the procurement data stored in the memory unit 106, stores the data in the memory unit 106, and updates the inventory data based on the purchase data.

[0054] In addition, the purchase input unit 102b generates logistics cost data including the purchase number, date of occurrence, and total logistics cost in response to, for example, an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, and stores the data in the memory unit 106.The purchase input unit 102b then performs a proportional allocation calculation for the logistics cost data for each burden company, which is the ordering company or the purchasing company, that bears the logistics cost, and generates logistics cost allocation data including the purchase number, date of occurrence, burden company, total logistics cost, the calculated proportionate logistics cost borne by the company, the product, and the quantity, and stores the data in the memory unit 106.

[0055] The journal entry creation unit 102d generates journal entry data for the ordering company and the purchasing company, including the counterparty, debit / credit, account item, and amount, based on the distribution cost allocation data, and stores the data in the storage unit 106.

[0056] The shipping input unit 102c generates shipping instruction data including the shipping instruction number, ordering company, line number, shipping date, product, and shipping quantity in response to, for example, an operator's operation on a shipping instruction input screen (not shown) displayed on the monitor 114, and stores the data in the memory unit 106.

[0057] The shipment input unit 102c extracts shipping instruction data stored in the storage unit 106 that meets the specified extraction conditions in response to, for example, an operator's operation on the shipment input screen (see FIG. 10) displayed on the monitor 114, and displays the items of shipping date, shipping instruction No., line No., shipper company, product, number of shipments, and whether or not to ship as a shipping slip. At this time, for "whether or not to ship," the unit 102c refers to the virtual warehouse linking master 106b using the ordering company of the shipping instruction data as a key to acquire a virtual warehouse, and then refers to the inventory data stored in the storage unit 106 to display the virtual warehouse. The inventory quantity is obtained using the warehouse and the product in the shipping instruction data as keys, and if the inventory quantity is greater than or equal to the shipping instruction quantity, it displays "Available for shipment", and if the inventory quantity is less than the shipping instruction quantity, it displays "Transfer processing required" if the supplier warehouse has inventory equal to the shipping instruction quantity for that product, or "Cannot be shipped" if the inventory does not equal the shipping instruction quantity, and based on the shipping slip, it generates shipping data including the shipping number, the ordering company which is the shipping destination, the warehouse from which the product was shipped, the shipping date, the row number, the product, and the quantity and stores it in the memory unit 106, and at this time, if the inventory quantity is less than the shipping instruction quantity, it does not create shipping data.

[0058] When the "Shipment possibility" of the shipping slip is "Transfer processing required" on the shipment input screen (see Figure 17), the transfer input unit 102e generates transfer data including the transfer number, line number, shipping date, the issuing warehouse which is the supplier warehouse, the receiving warehouse which is the virtual warehouse, the product, and the quantity, and stores it in the memory unit 106, and changes the company that will bear the logistics cost allocation data to the ordering company linked to the receiving warehouse if the receiving warehouse in the transfer data is registered in the virtual warehouse linking master 106b.

[0059] The screen display control unit 102f controls the display of various screens (for example, a purchase input screen, a shipping instruction input screen, a shipping input screen, etc.) displayed on the monitor 114 and the input therefor.

[0060] The master maintenance unit 102g is used to perform editing such as registering, adding, changing, and deleting data for the order lot master 106a and the virtual warehouse linking master 106b, for example, in response to an operator's operation on a master maintenance screen (not shown).

[0061] [3. Specific Examples] A specific example of the processing by the control unit 102 of the order processing system 100 in this embodiment will be described with reference to Figures 1 to 20. Figures 4 to 20 are diagrams for explaining a specific example of the processing by the control unit 102 of the order processing system 100 in this embodiment. In the following explanation, an example of the configuration of the order lot master 106a in Figure 2 and the virtual warehouse linking master 106b in Figure 3 will be used.

[0062] [3-1. Example 1] A first specific example will be described with reference to FIGS.

[0063] (Order entry processing) Ordering companies within a group of companies place orders with purchasing companies, which then aggregate the orders and purchase goods. Based on the order data, the order input unit 102a compares the amount calculated for each product by multiplying the number of ordered lots by the lot unit price with the total amount calculated by multiplying the unit price by the order quantity from multiple ordering companies, and generates procurement data including the procurement number, line number, purchase date, supplier, warehouse, original order number, original line number, product, purchase quantity, purchase price, and purchase amount, and stores the data in the storage unit 106. The "warehouse" sets a virtual warehouse linked to the ordering company in the order data in the virtual warehouse linking master 106b. Orders are placed with suppliers based on the procurement data.

[0064] In addition, the order input unit 102a may use the smaller of the amount of the number of ordered lots multiplied by the lot cost or the amount of the order quantity multiplied by the unit cost as the purchase quantity and purchase price if the order quantity is less than or equal to the number of ordered lots, or if the order quantity is greater than the number of ordered lots, calculate the ``quotient'' and ``remainder'' of the order quantity divided by the number of ordered lots, and use the unit cost for the ``quotient'' multiplied by the number of ordered lots, or use the unit cost for the ``remainder'' if the remainder is less than the unit cost of lot divided by the unit cost multiplied by the number of ordered lots, or use the unit cost for the remainder if the remainder is greater than or equal to the unit cost of lot divided by the unit cost multiplied by the number of ordered lots.

[0065] 4 is a diagram showing an example of order data. The order data may include an order number, an ordering company within a group company (the ordering company's company code and / or ordering company name), an order date, a purchasing company within a group company (the purchasing company code and / or purchasing company name), a line number, a product (product code and / or product name), a quantity, a unit price (normal unit price), and a price.

[0066] In the example shown in the figure, the first line contains the order number "HA001," the ordering company's company code "A," the order date "2024 / 3 / 10," the purchasing company code "D," the line number "1," the product code "SH001," the product name "wine," the quantity "25 bottles," the unit price "5,000 yen," and the amount "100,000 yen."

[0067] Next, we will explain how to determine the ordering method. The ordering method is determined as follows: The ordering data of ordering companies within the group is aggregated, and the ordering lot master 106a is referenced to compare the number of ordered lots x lot price and the order quantity x bulk price, to determine the purchase quantity (order quantity) and purchase price (order price), and generate procurement data.

[0068] 1. Compare the number of lots ordered x the lot price and the quantity ordered x the individual price. If the order quantity is less than or equal to the number of lots ordered, the unit price is determined as follows:

[0069] For product "SH001" Total order quantity = 25 + 20 + 50 = 95 Since the order lot size is less than 100 units, the cost will be compared with when ordering in a larger order lot size. Calculating based on the unit price, the purchase price would be 95 bottles x 5,000 yen = 475,000 yen. When calculated based on the lot price, the purchase price is 100 bottles x 4,500 yen = 450,000 yen. As mentioned above, it is cheaper to increase the quantity to the order lot number and place an order, so purchases are made at the lot price.

[0070] For product "SH002" Total order quantity = 10 + 20 + 50 = 80 Since the order lot size is less than 100, the cost will be compared with when ordering at the lot price. If calculated based on the unit price, the purchase price would be 80 bottles x 200 yen = 16,000 yen. When calculated based on the lot price, the purchase price is 100 bottles x 180 yen = 18,000 yen. As mentioned above, ordering at the individual unit price is cheaper, so purchases are made at the individual unit price.

[0071] If the order quantity is greater than the number of lots ordered, calculate the "quotient" and "remainder" by dividing the order quantity by the number of lots ordered, and then decide whether to use the unit price per unit or the lot price for the "remainder." In the following, the remainder of the required number of items (order quantity) divided by the number of lots ordered will be A, and the quotient (integer part) will be B.

[0072] (1) If A < lot price / individual price × number of lots ordered, the remainder will be ordered at the individual price. Purchase amount = (B × number of lots ordered × lot price) + (A × individual price).

[0073] (2) If A ≥ lot price / individual price × number of lots ordered, the order will be placed at the lot price. The purchase price will be (B + 1) × number of lots ordered × lot price.

[0074] For product "SH003" 55 pieces ÷ 30 pieces = "1" and remainder "25" 8000 yen ÷ 10000 yen × 30 = 24 From the above, (2)A ≧ lot price ÷ individual price × lot number, so we will use the lot price. The purchase amount is (1 + 1) × 30 units × 8,000 yen = 480,000 yen.

[0075] For product "SH004" 70 ÷ 50 = 1 and remainder 20 600 yen ÷ 800 yen × 50 = 37.5 From the above, (1) A < lot price / individual price × number of lots, so the individual price will be used. The purchase price is (1 x 50 bottles x 600 yen) + (20 bottles x 800 yen) = 46,000 yen.

[0076] Generate procurement data based on the calculation results of 2.1. By referencing the virtual warehouse linking master 106b, a virtual warehouse is set for the receiving warehouse and linked to the ordering company. Any increase in the original order quantity is entered into the purchasing company's warehouse at a fixed value. The virtual warehouse is set up to ensure delivery to the ordering company.

[0077] Fig. 5 shows an example of procurement data. The procurement data may include a procurement number, a line number, a purchase date, a supplier code, a warehouse code (a virtual warehouse or a supplier's warehouse), an original order number, an original line number, a product code, a product name, a purchase quantity, a purchase price (a price per unit or a price per lot), and a purchase amount (= a purchase price x a purchase quantity).

[0078] In the example shown in the figure, as shown in lines 1 to 4, for product code "SH001," an order lot size of "100 units" and a unit lot price of "4,500 yen" are to be placed, so the ordering companies "A, B, C" allocate quantities of "25 units, 20 units, 50 units" to virtual warehouses "VIA, VIB, VIC" respectively, and the remaining "5 units" are allocated to warehouse D of purchasing company D, with the purchase price set to the unit lot price of "4,500 yen."

[0079] Furthermore, as shown in lines 5 to 7, product code "SH002" will be ordered at a unit price of "200 yen", so the order quantities of "10 dozen, 20 dozen, 50 dozen" from ordering companies "A, B, C" will be assigned to virtual warehouses "VIA, VIB, VIC" respectively, and the purchase price will be the unit price of "200 yen".

[0080] Furthermore, as shown in lines 8 to 10, for product code "SH003", the order lot size is "30 units" x 2, and the unit price per unit lot is "8,000 yen", so the quantities of ordering companies "A" and "B" (20 units and 35 units) are assigned to virtual warehouses "VIA" and "VIB", respectively, and the remaining "5 units" is assigned to warehouse D of purchasing company D, with the unit price being the unit price per unit lot of "8,000 yen".

[0081] (Purchase entry processing) When goods arrive from a supplier, the purchase data is retrieved and the purchase is recorded. When goods arrive from a supplier, for example, in response to an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, the purchase input unit 102b generates purchase data including a purchase number, a line number, a purchase number, a purchase date, a supplier, a warehouse, an original order number, an original line number, a product, a quantity, a purchase price, and a purchase amount based on the purchase data stored in the storage unit 106, stores the data in the storage unit 106, and updates the inventory data based on the purchase data.

[0082] 6A is a diagram showing an example of purchase data. The purchase data may include a purchase number, a line number, a call procurement number, a purchase date, a supplier code, a warehouse code, an original order number, an original line number, a product code, a product name, a quantity, a unit price, and a purchase amount. In the example shown in the figure, the first line contains a purchase number "SINO1," a line number "1," a call procurement number "CHNO1," a purchase date "2024 / 3 / 15," a supplier code "E," a virtual warehouse "VIA," an original order number "HA001," an original line number "1," a product code "SH001," a product name "wine," a quantity "25 bottles," a unit price "4,500 yen," and a purchase amount "112,500 yen."

[0083] FIG. 6(B) is a diagram showing an example of inventory data. The inventory data may include a warehouse code, a product code, a product name, a stock quantity, and a unit. In the example shown in the figure, the first line is The warehouse code is "VIA", product code is "SH001", product name is "Wine", quantity in stock is "25", and unit is "bottles".

[0084] [3-2. Example 2] A second specific example will be described with reference to FIG.

[0085] (Purchase entry processing) The purchase entry process also generates logistics cost data and logistics cost allocation data. Logistics costs associated with purchases are recorded. Since logistics costs are incurred on a per-purchase-number basis, logistics cost data is recorded (logistics costs for purchases are entered on the purchase entry screen).

[0086] The purchase input unit 102b generates logistics cost data including the purchase number, the date of occurrence, and the total logistics cost in response to, for example, the operator's operation on the purchase input screen (not shown) displayed on the monitor 114, and stores the data in the memory unit 106. The purchase input unit 102b then performs a proportional calculation on the logistics cost data for each paying company, which is either the ordering company or the purchasing company, that will bear the logistics cost, and generates logistics cost allocation data including the purchase number, the date of occurrence, the paying company, the total logistics cost, the calculated proportional logistics cost borne by the company, the product, and the quantity, and stores the data in the memory unit 106.

[0087] Figure 7(A) is a diagram showing an example of logistics cost data. The logistics cost data may include a purchase number, an occurrence date, and a total logistics cost. In the example shown in the figure, the first line contains the purchase number "SINO1," the occurrence date "2024 / 3 / 15," and the total logistics cost "30,000 yen."

[0088] The recorded logistics cost data is allocated to each company that pays the costs, and the logistics cost allocation data is updated based on the logistics cost data. The companies that pay the logistics costs are as follows:

[0089] If the warehouse code is equal to the virtual warehouse in the virtual warehouse linking master 106b, the burden company is the ordering company (sales company). If the warehouse code is not equal to the virtual warehouse in the virtual warehouse linking master 106b, the burden company is the purchasing company.

[0090] The following explains the calculation of apportionment for each ordering company. Here, the calculation formula is written using product code "SH001" as an example. Company A: [Total logistics costs] of logistics cost data × ([Quantity (Company A)] of purchasing data ÷ [Quantity (Company A + Company B + Company C + Company D)] of purchasing data) = 30,000 × (25 ÷ 100) = 7,500 yen Company B: [Total logistics costs] in logistics cost data × ([Quantity (Company B)] in purchasing data ÷ [Quantity (Company A + Company B + Company C + Company D)] in purchasing data) = 30,000 × (20 ÷ 100) = 6,000 yen Company C: [Total logistics costs] of logistics cost data × ([Quantity (Company C)] of purchasing data ÷ [Quantity (Company A + Company B + Company C + Company D)] of purchasing data) = 30,000 × (50 ÷ 100) = 15,000 yen Company D: [Total logistics costs] of logistics cost data × [Quantity (Company D)] of purchasing data ÷ [Quantity (Company A + Company B + Company C + Company D)] of purchasing data = 30,000 × (5 ÷ 100) = 1,500 yen

[0091] Figure 7(B) shows an example of distribution cost allocation data. The distribution cost allocation data may include the purchase number, occurrence date, paying company, total distribution cost, company-paid distribution cost, product code, and quantity. In the example shown in the figure, the first line contains the purchase number "SINO1," the occurrence date "3 / 15 / 2024," the paying company "A," total distribution cost "30,000 yen," company-paid distribution cost "7,500 yen," product code "SH001," and quantity "25 units."

[0092] [3-3. Example 3] A third specific example will be described with reference to FIGS.

[0093] (Shipping instruction input processing) The shipping input unit 102c generates shipping instruction data including the shipping instruction number, ordering company, line number, shipping date, product, and shipping quantity in response to, for example, an operator's operation on a shipping instruction input screen (not shown) displayed on the monitor 114, and stores the data in the memory unit 106.

[0094] 8 is a diagram showing an example of shipping instruction data. The shipping instruction data may include a shipping instruction number, a company code, a row number, a shipping date, a product code, a product name, and a quantity. In the example shown in the figure, the first row contains the shipping instruction number "SUSI01," the company code "A," the row number "1," the shipping date "2024 / 3 / 17," the product code "SH001," the product name "Wine," and the quantity "25 bottles."

[0095] (Shipping entry processing) In the shipping entry process, products received by the purchasing company are sent to each ordering company. At the time of shipment, the distribution cost allocation data recorded at the time of purchase is automatically recorded as an advance payment.

[0096] The shipment input unit 102c extracts shipping instruction data stored in the storage unit 106 that meets the specified extraction conditions in response to, for example, an operator's operation on the shipment input screen (see FIG. 10) displayed on the monitor 114, and displays the items of shipping date, shipping instruction No., line No., shipper company, product, number of shipments, and whether or not to ship as a shipping slip. At this time, for "whether or not to ship," the unit 102c refers to the virtual warehouse linking master 106b using the ordering company of the shipping instruction data as a key to acquire a virtual warehouse, and then refers to the inventory data stored in the storage unit 106 to display the virtual warehouse. The inventory quantity is obtained using the warehouse and the product in the shipping instruction data as keys, and if the inventory quantity is greater than or equal to the shipping instruction quantity, it displays "Available for shipment", and if the inventory quantity is less than the shipping instruction quantity, it displays "Transfer processing required" if the supplier warehouse has inventory equal to the shipping instruction quantity for that product, or "Cannot be shipped" if the inventory does not equal the shipping instruction quantity, and based on the shipping slip, it generates shipping data including the shipping number, the ordering company which is the shipping destination, the warehouse from which the product was shipped, the shipping date, the row number, the product, and the quantity and stores it in the memory unit 106, and at this time, if the inventory quantity is less than the shipping instruction quantity, it does not create shipping data.

[0097] 9A shows an example of data in the virtual warehouse linking master 106b, and FIG. 9B shows an example of data in the inventory data. FIG. 10 shows an example of a display of the shipment input screen 600.

[0098] As shown in Figure 10, the shipping input screen 600 has an area for specifying extraction conditions such as shipping date and shipping destination company (ordering company), an area for displaying shipping documents that match the extraction conditions (shipping date, shipping instruction number, line number, shipping company, product code, number of items shipped, whether shipping is possible or not), a display button, and a registration button.

[0099] When the extraction conditions are specified and the display button is pressed, shipping instruction data that matches the extraction conditions is extracted and the shipping slip is displayed. When the register button is pressed, shipping data corresponding to the shipping slip is generated and stored in the memory unit 106. In the example shown in the figure, the shipping date "2024 / 3 / 17" is specified.

[0100] The shipping documents are extracted from the extraction conditions on the shipping entry screen. When the shipping documents are displayed, the inventory data is referenced to determine whether they can be shipped, and this is displayed in the shipping availability field. Shipping data is not created for items that cannot be shipped.

[0101] In the following, we will use the product code "SH001" of shipping instruction number "SUSI01" as an example. Using the company code "A" of the shipping instruction data as a key, the virtual warehouse linking master 106b is referenced to acquire the virtual warehouse "VIA," and the inventory data is referenced to acquire the inventory quantity "25" using the acquired virtual warehouse and the product of the shipping instruction data as keys.

[0102] The inventory data is compared with the shipping order quantity to determine whether the item can be shipped.

[0103] If the stock quantity is greater than or equal to the shipping instruction quantity, the shipping availability of the shipping slip will display "Available for shipping." If the stock quantity is less than the shipping instruction quantity, if there is enough stock in the supplier warehouse to meet the shipping instruction quantity, the shipping availability will display "Transfer processing required," and if there is no stock, "Cannot be shipped." Note that if the stock quantity is less than the shipping instruction quantity, shipping data will not be created. The case of "Transfer processing required" will be explained in [3-4. Specific example 4].

[0104] In this example, the shipping order quantity is "25" and the stock quantity is "25", so the shipping availability is displayed as "Available for shipping".

[0105] Figure 11(A) shows an example of shipping data. The shipping data may include a shipping number, company code, shipping destination, origin warehouse, shipping date, row number, product code, product name, and quantity. In the example shown in the figure, the first row contains a shipping number of "SUKA01," a company code of "A," a shipping destination of "A," an origin warehouse of "VIA," a shipping date of "2024 / 3 / 17," a row number of "1," a product code of "SH001," a product name of "wine," and a quantity of "25 bottles."

[0106] After creating the shipping data, the shipment input unit 102c updates the inventory data. Figure 11(B) shows the inventory data after the update. The inventory quantity in each warehouse is reduced by the shipping quantity in the shipping data.

[0107] The journal entry creation unit 102d generates journal entry data for the ordering company and the purchasing company, including the counterparty, debit / credit, account item, and amount, based on the distribution cost allocation data, and stores the data in the storage unit 106.

[0108] 12 is a diagram showing an example of distribution cost allocation data. Journal data between the ordering company and the purchasing company is created in the order of the records in the distribution cost allocation data. In the following example, the product code "SH001" is used as an example.

[0109] Figure 13 shows an example of journal entry data related to logistics costs incurred between Company A and Supplier D. Figure 13(A) shows an example of journal entry generated by Company A, and Figure 13(B) shows an example of journal entry generated by Company D. Journal entry data may include company code, journal entry number, journal entry line number, processing date, counterparty, debit / credit, account item, amount, and originating document number.

[0110] FIG. 13(A) is a diagram showing an example of journal entry data generated at Company A. The first line is a journal entry (debit, account item "Payment of logistics expenses (Company D)") created based on the first line of the logistics expense allocation data in FIG. 12. The second and third lines are automatic offsetting journal entries created based on the first line of the logistics expense allocation data in FIG. 12. The second line is a credit, account item "Accounts payable (Company D)" (offset counterpart: journal entry number = "SWKAO2", journal entry line number = "1"), and the third line is a debit, account item "Accounts payable (Company D)" (offset counterpart: journal entry number = "SWKAO1", journal entry line number = "2". The fourth line is a journal entry (credit, account item "Intra-group logistics expense offset (Company D)") created based on the first line of the logistics expense allocation data in FIG. 12.

[0111] Figure 13(B) is a diagram showing an example of journal entry data generated at Company D. The first and fourth lines are automatic offsetting journal entries created based on the first line of the logistics cost allocation data in Figure 12. The first line is a debit, account item "Accounts Receivable (Company A)" (offset counterpart: journal entry number = "SWKDO2", journal entry line number = "2"), and the fourth line is a credit, account item "Accounts Receivable (Company A)" (offset counterpart: journal entry number = "SWKDO1", journal entry line number = "1"). The second line is a journal entry created based on the first line of the logistics cost allocation data in Figure 12 (credit, account item "Received Logistics Costs (Company A)"). The third line is a journal entry created based on the first line of the logistics cost allocation data in Figure 12 (debit, account item "Intra-group Logistics Cost Offset (Company A)").

[0112] Figure 14 is a diagram showing an example of journal data related to logistics costs incurred between Company B and Supplier D. It is created based on the second row of the logistics cost allocation data in Figure 12. Figure 14(A) shows an example of journal data incurred by Company B, and Figure 14(B) shows an example of journal data incurred by Company D. Since it is created in the same way as Figure 13, detailed explanation will be omitted.

[0113] Figure 15 is a diagram showing an example of journal data related to logistics costs incurred between Company C and Supplier D. It is created based on the third row of the logistics cost allocation data in Figure 12. Figure 15(A) shows an example of journal data incurred by Company C, and Figure 15(B) shows an example of journal data incurred by Company D. Since it is created in the same way as Figure 13, detailed explanations are omitted.

[0114] [3-4. Example 4] Specific Example 4 will be described with reference to Figures 16 to 20. In Specific Example 4, a case where an additional shipping request is made will be described.

[0115] (Shipping instruction input processing) If there is a request for additional shipment, the quantity purchased will be increased from the order request in the aforementioned purchase input process, and the purchased goods will be shared among group companies, and the additional shipment request will be handled for goods stored in the purchasing company's warehouse.

[0116] Figure 16 shows an example of shipping instruction data created when an additional shipping request is made. In the example shown in the figure, the shipping instruction number is "SUSI01," the company code is "A," the row number is "3," the shipping date is "2024 / 3 / 17," the product code is "SH001," the product name is "wine," and the quantity is "5 bottles." Company A is requesting the shipment of an additional "5 bottles" of product code "SH001." We will now explain how to handle these "5 bottles."

[0117] (Shipping entry processing) As with the shipment input process, the shipment input screen 600 is launched to determine whether shipment is possible. Figure 17 shows an example of the display of the shipment input screen 600. In this example, the extraction conditions are the shipping date "2024 / 3 / 17" and the shipping destination company "A."

[0118] Using the company code "A" from the shipping instruction data as a key, the virtual warehouse linking master 106b is referenced to acquire the virtual warehouse "VIA," and the inventory data (Figure 11(B)) is referenced to acquire the inventory quantity "0" using the acquired virtual warehouse "VIA" and the product "SH001" from the shipping instruction data as keys. Although the inventory quantity "0" is less than the shipping instruction quantity "5 bottles," there is inventory of "5 bottles" in the supplier warehouse "D," so "Transfer processing required" is displayed in the shipping input screen 600 for the shipping availability of the shipping slip. If there is a line item with "Transfer processing required," the item is moved from the supplier warehouse to the virtual warehouse using the transfer input process, and then shipment input is performed again.

[0119] (Movement input processing) In the above-mentioned shipment entry process, if "Transfer processing required" is displayed in the shipping availability section of the shipping slip on the shipment entry screen 600, the inventory is transferred from the supplier warehouse to the ordering company's virtual warehouse. The transfer to the virtual warehouse is carried out to ensure the shipment is made to the ordering company that has requested the shipment.

[0120] When the "Shipping possibility" of the shipping slip is "Transfer processing required" on the shipment input screen (see FIG. 17), the transfer input unit 102e generates transfer data including the transfer number, line number, shipping date, issuing warehouse which is the supplier warehouse, receiving warehouse which is the virtual warehouse, product, and quantity, and stores it in the storage unit 106. If the receiving warehouse of the transfer data is registered in the virtual warehouse linking master 106b, the transfer input unit 102e changes the company that bears the logistics cost allocation data to the ordering company linked to the receiving warehouse. In addition, it updates the inventory data based on the transfer data.

[0121] FIG. 18(A) shows an example of data in the virtual warehouse linking master 106b, FIG. 18(B) shows an example of data of movement data to be created, and FIG. 18(C) shows an example of data of distribution cost allocation data to be updated.

[0122] Create transfer data as shown in Figure 18(B). The transfer data may include transfer number, row number, shipping date, originating warehouse, receiving warehouse, product code, product name, and quantity. In the example shown in the figure, the transfer number is "IDNO1", row number is "1", shipping date is "2024 / 3 / 18", originating warehouse is "D", receiving warehouse is "VIA", product code is "SH001", product name is "wine", and quantity is "5 bottles".

[0123] As shown in Figure 18(C), the logistics cost allocation data is updated. If the receiving warehouse (VIA in this example) of the transfer data is registered in the virtual warehouse linking master 106b, the burden company (D in this example) in the logistics cost allocation data is changed to the ordering company (A in this example) linked to the receiving warehouse (virtual warehouse). In the example shown in the same figure, in the fourth line, the burden company is updated from "D" to "A." Also, for product "SH001" in the inventory data, the inventory quantity for warehouse code "VIA" is updated from "0" to "5," and the inventory quantity for warehouse code "D" is updated from "5" to "0."

[0124] (Shipping entry processing) The item is shipped from the inventory moved to the virtual warehouse. In the transfer input process, the item is moved to the virtual warehouse in the inventory data, so it becomes "ready to ship." Figure 19(A) is a diagram showing an example of the display of the shipping input screen 600. Figure 19(B) is a diagram showing an example of the shipping data to be created.

[0125] As shown in Figure 19(A), if you launch the shipping input screen 600 again and specify the shipping date "2024 / 3 / 17" and the shipping destination company "A" as the extraction conditions, the shipping availability of the shipping slip will be displayed as "Shipable." Pressing the register button will create shipping data such as that shown in Figure 19(B). In the example shown in the figure, the first line contains the shipping number "SUKA04," company code "A," shipping destination "A," origin warehouse "VIA," shipping date "2024 / 3 / 18," line number "3," product code "SH001," product name "Wine," and quantity "5 bottles."

[0126] The journal entry creation unit 102d generates journal entry data for the ordering company and the purchasing company, including the counterparty, debit / credit, account item, and amount, based on the updated distribution cost allocation data, and stores the data in the storage unit 106.

[0127] Figure 20 is a diagram showing example data of journal entries related to logistics costs incurred between Company A and Supplier D. Figure 20(A) is a diagram showing an example of journal entries for Company A created based on the updated fourth line of the logistics cost allocation data in Figure 18(C), and Figure 20(B) is a diagram showing an example of journal entries created based on the updated fourth line of the logistics cost allocation data in Figure 18(C).

[0128] As described above, according to this embodiment, the system includes an order lot master 106a in which supplier, product, order lot number as an order unit, and lot price are registered in association with each other, and order data including order number, order originating company, order date, supplier company within the group company, line number, product, order quantity, bulk unit price as a normal unit price, and amount is input from a plurality of order originating companies within the group company, and stored in the memory unit 106. Based on the order data, the system generates procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase price, and purchase amount based on a comparison result between the order lot number x lot unit price amount calculated with reference to the order lot master 106a and the total amount of the bulk unit price x order quantity of the plurality of order originating companies, and stores the generated procurement data in the memory unit 106. Therefore, when a purchasing company within a group company receives orders for the same product from a plurality of order originating companies, it is possible to purchase the product at low cost.

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

[0130] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0131] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

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

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

[0135] Furthermore, with regard to the order processing system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0136] For example, all or any part of the processing functions of the order processing system 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the order processing system 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0137] This computer program may also be stored in an application program server connected to the order processing system 100 via any network, and all or part of it may be downloaded as needed.

[0138] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0139] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

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

[0141] The order processing system 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 any peripheral device is connected. The order processing system 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0142] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0143] 100 Order Processing System 102 Control section 102a Order input section 102b Purchase Input Section 102c Shipping Input Section 102d Journal Entry Preparation Department 102e Movement input section 102f Screen display control unit 102g Master Maintenance Department 104 Communication interface unit 106 Storage section 106a Order lot master 106b Virtual warehouse linking master 200 servers 300 Network 400 Ordering company's system

Claims

1. An order processing system including a control unit for a purchasing company within a group company to collectively place orders for the group companies, The control unit The system is configured to be able to access a storage area that stores order lot master data that associates and registers supplier, product, order lot number (order unit), and lot unit price. an order processing system characterized by comprising an order input means for inputting order data including order number, order originating company, order date, purchasing company within the group company, line number, product, order quantity, bulk unit price which is the normal unit price, and amount from a plurality of ordering companies within a group company, and storing the data in the memory area; and for generating procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount based on the order data and comparing the amount of order lot number x lot unit price calculated by referring to the order lot master for each product with the total amount of bulk unit price x order quantity from the plurality of ordering companies, and storing the generated procurement data in the memory area.

2. The order input means inputs the purchase quantity and purchase price as follows: If the order quantity is less than or equal to the number of lots ordered, the smaller of the order quantity x lot price or the order quantity x bulk price will be used. The order processing system of claim 1, wherein if the order quantity > the number of ordered lots, the "quotient" and "remainder" are calculated by dividing the order quantity by the number of ordered lots, and the lot price is used for the "quotient" x the number of ordered lots, and if the remainder < the lot price ÷ the individual price x the number of ordered lots, the individual price is used for the "remainder", and if the remainder ≥ the lot price ÷ the individual price x the number of ordered lots, the lot price is used.

3. The storage area further includes: The virtual warehouse linking master, which associates the virtual warehouse with the ordering company, is stored. The procurement data further includes a warehouse; 3. The order processing system according to claim 1, wherein the order input means sets a virtual warehouse linked to the ordering company of the order data in the virtual warehouse linking master in the warehouse of the procurement data.

4. The storage area further includes: Inventory data including warehouse, product, stock quantity, and unit, specifying the virtual warehouse or supplier's warehouse, is stored. The order processing system according to claim 3, further comprising a purchase input means for generating purchase data including purchase number, line number, procurement number, purchase date, supplier, warehouse, original order number, original line number, product, quantity, purchase price, and purchase amount based on the procurement data when goods arrive from a supplier, and updating the inventory data based on the purchase data.

5. The order processing system of claim 4, characterized in that the purchase input means generates logistics cost data including a purchase number, an occurrence date, and a total logistics cost, and calculates a proportional distribution of the logistics cost data for each burden company, which is the ordering company or the purchasing company, that bears the logistics cost, and generates logistics cost allocation data including the purchase number, an occurrence date, a burden company, a total logistics cost, the calculated proportionately distributed logistics cost borne by the company, the product, and the quantity, and stores this in the memory area.

6. The control unit The order processing system according to claim 5, further comprising a journal entry creation means for creating journal entry data for the ordering company and purchasing company, including counterparty, debit / credit, account item, and amount, based on the logistics cost allocation data.

7. The control unit further Shipping instruction data including shipping instruction number, ordering company, line number, shipping date, product, and shipping quantity is generated and stored in the storage area, and on the shipping input screen, the shipping instruction data stored in the storage area that corresponds to the specified extraction conditions is extracted, and the items of shipping date, shipping instruction number, line number, shipping company, product, shipping quantity, and shipping availability are displayed as a shipping target slip, and at this time, for "shipping availability," the ordering company of the shipping instruction data is used as a key, the virtual warehouse is referenced to the virtual warehouse linking master, and the inventory data stored in the storage area is referenced, and the virtual warehouse and the product of the shipping instruction data are displayed.

6. The ordering processing system according to claim 5, further comprising a shipping input means for obtaining the inventory quantity using the item as a key, and displaying "Available for shipment" if the inventory quantity is greater than or equal to the shipping instruction quantity, and for displaying "Transfer processing required" if the purchasing company's warehouse has inventory equal to the shipping instruction quantity for the item, and "Cannot be shipped" if the purchasing company does not have inventory equal to the shipping instruction quantity, and generating shipping data including the shipping number, the ordering company which is the shipping destination, the warehouse from which the item was shipped, the shipping date, the row number, the item, and the quantity based on the shipping slip and storing it in the memory area, and at this time not generating shipping data if the inventory quantity is less than the shipping instruction quantity.

8. The control unit further The order processing system according to claim 7, further comprising a transfer input means for generating transfer data including a transfer number, a line number, a shipping date, a supplier warehouse which is an output warehouse, a virtual warehouse which is an input warehouse, a product, and a quantity when the "Shipment possibility" of the invoice to be shipped is "Transfer processing required" on the shipping input screen, and changing the company that will bear the logistics cost allocation data to the ordering company linked to the input warehouse when the input warehouse of the transfer data is registered in the virtual warehouse linking master.

9. An order processing method executed by an information processing device having a control unit, The control unit The system is configured to be able to access a storage area that stores order lot master data that associates and registers supplier, product, order lot number (order unit), and lot unit price. Executed in the control unit: an order input step of inputting order data including order number, order originating company, order date, purchasing company within the group company, line number, product, order quantity, bulk unit price which is the normal unit price, and amount from a plurality of ordering companies within a group company, and storing the input data in the storage area; and generating procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount based on the order data for each product, calculated by referring to the order lot master and comparing the amount of the bulk unit price x order quantity from the plurality of ordering companies, and storing the generated procurement data in the storage area.

10. An order processing program to be executed by an information processing device having a control unit, The control unit The system is configured to be able to access a storage area that stores order lot master data that associates and registers supplier, product, order lot number (order unit), and lot unit price. The control unit An order processing program for executing an order input process in which order data including order number, order originating company, order date, purchasing company within the group company, line number, product, order quantity, bulk unit price which is the normal unit price, and amount is input from multiple ordering companies within a group company, and stored in the memory area, and based on the order data, procurement data including procurement number, line number, purchase date, supplier, original order number, original line number, product, purchase quantity, purchase unit price, and purchase amount is generated and stored in the memory area based on the result of comparing, for each product, the amount of order lot number x lot unit price calculated by referring to the order lot master with the total amount of bulk unit price x order quantity from the multiple ordering companies.

Images