Physical distribution cost processing system, physical distribution cost processing method, and physical distribution cost processing program

Abstract

To efficiently manage a physical distribution cost that occurs in an intracompany transaction between an ordering company and a procurement company within a group company.SOLUTION: A physical distribution cost processing system includes: purchase input means for creating purchase data of a procurement company including a supplier, an ordering company, a commodity, a quantity, a unit price, a purchase amount, and a weight scale on the basis of order placement data of an ordering company including an ordering company, a supplier being a procurement company, a commodity, and a quantity, and creating physical distribution cost data including a physical distribution cost when a commodity arrives after order placement based on the purchase data; and physical distribution cost accounting processing means for creating claim data of a procurement company including a claim amount of physical distribution cost calculated on the basis of physical distribution cost setting information acquired from a first master with a procurement company, a claim destination being an ordering company, a commodity, a revenue item, an ordering company and a commodity as keys with reference to the first master on the basis of the purchase data and the physical distribution cost data.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a logistics cost processing system, a logistics cost processing method, and a logistics cost processing program. [Background technology]

[0002] For example, in a group of companies, logistics costs are incurred in transactions within the group. Conventionally, a system relating to transactions within a group of companies is disclosed in, for example, 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 describe anything about efficiently managing logistics costs incurred in internal transactions between an ordering company and a procurement company within a group of companies.

[0005] The present invention has been made in consideration of the above, and aims to provide a logistics cost processing system, a logistics cost processing method, and a logistics cost processing program that can efficiently manage logistics costs incurred in internal transactions between an ordering company and a procurement company within a group of companies. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a logistics cost processing system that includes a control unit and processes logistics costs associated with transactions among group companies, the control unit comprising: The system is configured to be able to access a first master in which logistics cost burden information for setting the burden of an ordering company, a product, and a logistics cost is registered in association with each other, and includes an order input means for inputting order data of the ordering company including order number, line number, ordering company, order date, supplier which is a procurement company, product, and quantity; a purchase input means for creating purchase data including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale based on the order data, and creating logistics cost data including purchase number, occurrence date, and logistics cost when the product arrives after an order based on the purchase data; and and a logistics cost accounting processing means for creating, based on the data, invoice data for the procurement company including the invoice amount and credit item of the logistics cost calculated based on logistics cost setting information acquired from the first master using the procurement company, the invoice recipient which is the ordering company, the invoice No., the invoice date, the product, the revenue item, the ordering company, and the product as keys, and payment data for the ordering company including the payment amount and credit item of the logistics cost calculated based on logistics cost setting information acquired from the first master using the ordering company, the payment No., the payment date, the payee which is the procurement company, the product, the expense item, the quantity, the unit price, the ordering company, and the product as keys.

[0007] According to one aspect of the present invention, the logistics cost burden information may include a logistics cost burden flag that specifies whether the logistics costs will be borne by the ordering company or the procurement company, and a logistics cost allocation method for determining the allocation ratio of the logistics costs of the ordering company.

[0008] According to another aspect of the present invention, the logistics cost accounting processing means may create accounting data for the procurement company, including the counterparty, debit / credit, account item, and amount, based on the billing data.

[0009] According to another aspect of the present invention, the logistics cost accounting processing means may create accounting data for the procuring company, including the counterparty, debit / credit, account item, and amount, based on the payment data.

[0010] Furthermore, according to one aspect of the present invention, the control unit may be further configured to be able to access a second master in which revenue / expense items, credit / debt items, and offsetting account items are registered in association with each other.

[0011] Furthermore, according to one aspect of the present invention, the procuring company's journal data may include a journal entry including a debit, the revenue item and amount of the billing data, a credit, the offsetting account item and amount obtained from the second master using the revenue item and credit item of the billing data as keys, and a debit / credit, the credit item and amount of the billing data.

[0012] Furthermore, according to one aspect of the present invention, the journal data of the ordering company may include a journal entry including a debit, the expense item and amount of the payment data, a credit, the offsetting account item and amount obtained from the second master using the expense item and debt item of the payment data as keys, and a debit / credit, the debt item and amount of the payment data.

[0013] In order to solve the above-mentioned problems and achieve the object, the present invention provides a logistics cost processing method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a first master containing logistics cost burden information for setting the ordering company, product, and logistics cost burden, and the control unit executes an order input process of inputting order data of the ordering company including order number, line number, ordering company, order date, supplier which is a procurement company, product, and quantity; The method includes a purchase input process for creating purchase data including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale based on the order data, and creating logistics cost data including purchase number, occurrence date, and logistics cost when the product arrives after an order is placed based on the purchase data; and a logistics cost accounting process for creating, based on the purchase data and the logistics cost data, billing data for the procurement company including a billing amount and credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the procurement company, billing destination which is the ordering company, billing number, billing date, product, revenue item, ordering company, and product as keys, and payment data for the ordering company including a payment amount and credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the ordering company, payment number, payment date, payee which is the procurement company, product, expense item, quantity, unit price, ordering company, and product as keys,.

[0014] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention provides a logistics cost processing program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a first master in which logistics cost burden information for setting the burden of logistics costs is registered in association with an ordering company, a product, and the like, and the program includes an order input process for inputting order data of the ordering company, including an order number, a line number, the ordering company, an order date, a supplier that is a procurement company, a product, and a quantity, into the control unit; and creating purchase data, based on the order data, including a purchase number, a line number, a purchase date, a supplier, the ordering company, a product, a quantity, a unit price, a purchase amount, a unit weight, and a weight scale, and generating the logistics cost data, including a purchase number, a date of occurrence, and a logistics cost, when the product arrives after an order is placed based on the purchase data. and a logistics expense accounting processing process for creating billing data for the procurement company including a billing amount and credit item for logistics expenses calculated based on logistics expense setting information acquired from the first master using the procurement company, the bill-to-receiver which is the ordering company, the bill-to-receiver which is the ordering company, the bill-to-receiver, the bill No., the billing date, the product, the revenue item, the ordering company, and the product as keys, and payment data for the ordering company including a payment amount and credit item for logistics expenses calculated based on logistics expense setting information acquired from the first master using the ordering company, the payment No., the payment date, the bill-to-receiver which is the procurement company, the product, the expense item, the quantity, the unit price .... [Effects of the Invention]

[0015] According to the present invention, it is possible to efficiently manage logistics costs incurred in internal transactions between an ordering company and a procurement company within a group of companies. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a diagram for explaining a procurement company within a group of companies. [Figure 2] FIG. 2 is a block diagram showing an example of the configuration of the logistics expense processing system according to this embodiment. [Figure 3]FIG. 3 is a diagram illustrating an example of the configuration of the logistics cost burden setting master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the logistics cost offset setting master. [Figure 5] FIG. 5 is a flowchart for explaining an outline of the overall operation of the control unit of the physical distribution expense processing system according to this embodiment. [Figure 6] FIG. 6 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 7] FIG. 7 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 8A] FIG. 8A is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 8B] FIG. 8B is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 8C] FIG. 8C is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 8D] FIG. 8D is a diagram showing sample data for explaining a specific example of the processing of the control unit of the physical distribution expense processing system according to the present embodiment. [Figure 8E] FIG. 8E is a diagram showing sample data for explaining a specific example of the processing of the control unit of the logistics expense processing system according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION

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

[0018] [1. Overview] The outline of the present invention will be explained in the following order: [1-1. Logistics cost accounting and issues in intra-group transactions], [1-2. Solution], and [1-3. Effects].

[0019] [1-1. Logistics cost accounting and issues in intra-group transactions] For example, some group companies (also called "group enterprises") establish a "procurement company" to improve efficiency in procurement, such as by taking advantage of economies of scale to reduce costs. Here, a "procurement company" refers to a company that compiles order information within the group companies and is responsible for centralized procurement.

[0020] Figure 1 is a diagram for explaining a procurement company within a group company. For example, the procurement company accepts orders from ordering companies such as sales companies (e.g., Company A, Company B, and Company C) and purchases products from suppliers.

[0021] Logistics costs are a typical cost incurred when a procurement company procures goods from suppliers. With the recent rise in logistics costs, there is a need to accurately record and streamline logistics costs incurred within group companies.

[0022] However, in the past, when transactions occurred between group companies, data had to be registered for each company, which resulted in the hassle of double registration of logistics costs and reconciliation between companies.

[0023] [1-2. Solution] In this invention, in order to efficiently manage logistics costs incurred in internal transactions between an ordering company and a procurement company within a group of companies, the company that will bear the logistics costs for the logistics costs incurred by the procurement company is preset in the master data, and both companies are able to automatically create billing data and payment data for the logistics costs, as well as offset processing in accounting.

[0024] [1-3.Effects] Within a group of companies, the logistics costs incurred in internal transactions between the ordering company and the procurement company can be efficiently managed, improving business efficiency. Specifically, this prevents duplicate registration of logistics costs and enables accurate accounting of logistics costs, which in turn reduces labor costs and increases profits through labor savings.

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

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

[0027] The logistics expense processing system 100 is a commercially available desktop personal computer. Note that the logistics expense 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 logistics expense processing system 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units included in the logistics expense processing system 100 are connected to each other so that they can communicate with each other via any communication path.

[0029] The communication interface unit 104 communicatively connects the logistics expense 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 logistics expense 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 ordering company systems 400... are, for example, systems of companies A, B, and C, and are configured to be able to communicate data with the logistics expense 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] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0032] The storage unit 106 also stores a logistics cost burden setting master 106a, a logistics cost offset setting master 106b, order data, purchase data, logistics cost data, billing data, payment data, journal data, etc. Fig. 3 is a diagram showing an example of the configuration of the logistics cost burden setting master 106a. Fig. 4 is a diagram showing an example of the configuration of the logistics cost offset setting master 106b.

[0033] As shown in Fig. 3, the logistics cost burden setting master 106a can be configured as a table or the like that associates and registers the ordering company (ordering company code and / or ordering company name), product (product code and / or product name), and logistics cost burden information for setting the burden of logistics costs (for example, a logistics cost burden flag that specifies whether the ordering company or the procuring company will bear the logistics costs, and a logistics cost allocation method (quantity or amount) for determining the proportion of the ordering company's logistics costs to be allocated). The logistics cost burden flag is set to "0: the ordering company bears the logistics costs" or "1: the procuring company bears the logistics costs."

[0034] As shown in FIG. 4, the physical distribution cost offset setting master 106b can be configured as a table in which income / expense items, credit / debt items, and offsetting account items are associated and registered.

[0035] The order data may include order identification information (order number, line number), company (company code and / or company name), order date, supplier (supplier code (= procurement company) and / or supplier name), product (product code and / or product name), and quantity.

[0036] The supplier data may include supplier identification information (supplier number, line number), purchase date, supplier (supplier code and / or supplier name), ordering company (ordering company code and / or ordering company name), order identification information (original order number, original line number), product (product code and / or product name), quantity, unit price, purchase amount, unit weight, and weight scale.

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

[0038] The billing data may include the billing company (company code and / or company name), billing identification information (billing number), billing date, billing recipient (billing recipient code (= group company) and / or billing recipient name), product code, product name (revenue item), quantity, unit price, billing amount, and receivable item.

[0039] Payment data may include the paying company (company code and / or company name), payment identification information (payment number), payment date, payee (payee code (= procurement company) and / or payee name), product code, product name (expense item), quantity, unit price, payment amount, and debt item.

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

[0041] The control unit 102 is a CPU or the like that performs overall control of the logistics expense 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.

[0042] The control unit 102 is configured to be able to access the logistics cost burden setting master 106a, logistics cost offset setting master 106b, order data, purchase data, logistics cost data, billing data, payment data, journal data, etc. stored in the memory unit 106. Note that the logistics cost burden setting master 106a, logistics cost offset setting master 106b, order data, purchase data, logistics cost data, billing data, payment 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.

[0043] The control unit 102 conceptually includes an order input unit 102a, a purchase input unit 102b, a logistics cost calculation processing unit 102c, a master maintenance unit 102d, and a screen display control unit 102e.

[0044] For example, in response to access from the ordering company's system 400..., the order input unit 102a inputs the ordering company's order data, including order identification information (order number, line number), ordering company, order date, supplier (procurement company), product, and quantity, and stores it in the memory unit 106.

[0045] Based on the order data stored in the memory unit 106, the purchase input unit 102b creates purchase data for the procuring company, including purchase identification information (purchase number, purchase line), purchase date, supplier, ordering company, order identification information, product, quantity, unit price, purchase amount, unit weight, and weight scale, and stores the data in the memory unit 106.

[0046] When the product arrives after an order is placed based on the purchase data, the purchase input unit 102b creates logistics cost data including the purchase number, the date of occurrence, and the logistics cost based on the purchase data, and stores the data in the storage unit 106.

[0047] The logistics cost accounting processing unit 102c refers to the logistics cost burden setting master 106a based on the purchase data and logistics cost data, and creates billing data for the procurement company including the billing amount for logistics costs and the credit item calculated based on the logistics cost setting information obtained from the logistics cost burden setting master 106a using the billing company, the billing destination which is the ordering company, the billing number, the billing date, the product, the revenue item, the ordering company, and the product as keys, and stores the data in the memory unit 106.

[0048] The logistics cost accounting processing unit 102c refers to the logistics cost burden setting master 106a based on the purchase data and logistics cost data, and creates payment data for the ordering company including the payment amount for logistics costs and debt items calculated based on the logistics cost setting information obtained from the logistics cost burden setting master 106a using the ordering company, payment number, payment date, payee, product, expense item, quantity, unit price, ordering company and product as keys, and stores the data in the memory unit 106.

[0049] The logistics cost accounting processing unit 102c creates journal entry data including the counterparty, debit / credit, account item, and amount based on the billing data, and stores the data in the storage unit 106. The journal entry data may include a journal entry (offsetting journal entry) including the debit, the revenue item of the billing data, and amount, and an offsetting account item and amount obtained from the logistics cost offset setting master 106b using the counterparty, credit, the revenue item and credit item of the billing data as keys, and a journal entry (automatic offset journal entry) including the debit / credit, the credit item of the billing data, and amount.

[0050] The logistics expense accounting processing unit 102c creates journal entry data including the counterparty, debit / credit, account item, and amount based on the payment data, and stores the data in the storage unit 106. The journal entry data may include a journal entry (offsetting journal entry) including the counterparty, debit, expense item of the payment data, and amount, an offsetting journal entry including the offsetting account item and amount acquired from the logistics expense offset setting master 106b using the credit, expense item and debt item of the payment data as keys, and a journal entry (automatic offsetting journal entry) including the debit / credit, debt item of the payment data, and amount.

[0051] The master maintenance section 102d is used to perform editing such as registering, adding, changing, and deleting data in the logistics cost burden setting master 106a and the logistics cost offset setting master 106b, for example, in response to operator operations on a master maintenance screen not shown.

[0052] The screen display control unit 102e controls the display of various screens on the monitor 114 and the input thereto that are provided to the ordering company's system 400 . . .

[0053] [3. Specific Examples] 1 to 8E, a specific example of the processing by the control unit 102 of the logistics expense processing system 100 in this embodiment will be described. Fig. 5 is a diagram showing a flow for explaining an outline of the overall processing by the control unit 102 of the logistics expense processing system 100 in this embodiment.

[0054] [3-1. Overall processing] An overview of the overall processing of the control unit 102 of the logistics expense processing system 100 in this embodiment will be described with reference to Figure 5. The order input unit 102a executes order input processing (step S1). Specifically, in the order input processing, the order input unit 102a inputs order data of the ordering company, including order identification information (order number, line number), ordering company, order date, supplier (procurement company), product, and quantity, in response to access from the ordering company's system 400..., for example, and stores the data in the memory unit 106.

[0055] The purchase input unit 102b executes a purchase input process (step S2). Specifically, in the purchase input process, the purchase input unit 102b creates purchase data for the procuring company, including purchase identification information (purchase number, purchase line), purchase date, supplier, ordering company, order identification information, product, quantity, unit price, purchase amount, unit weight, and weight scale, based on the order data stored in the storage unit 106, and stores the data in the storage unit 106. In addition, when a product arrives after an order based on the purchase data is placed, the purchase input unit 102b creates logistics cost data, including the purchase number, occurrence date, and logistics cost, based on the purchase data, and stores the data in the storage unit 106.

[0056] The logistics expense accounting processing unit 102c executes logistics expense accounting processing (step S3). Specifically, in the logistics expense accounting processing, the logistics expense accounting processing unit 102c, based on the purchase data and logistics expense data stored in the storage unit 106, refers to the logistics expense burden setting master 106a, and creates billing data for the procurement company, including the billing amount for logistics expenses calculated based on logistics expense setting information acquired from the logistics expense burden setting master 106a using the billing company, the bill-to-be (the ordering company), the billing number, the billing date, the product, the revenue item, the ordering company, and the product as keys, and the credit item, and stores the created billing data in the storage unit 106. Also, based on the purchase data and logistics expense data, the logistics expense accounting processing unit 102c, based on the purchase data and logistics expense data, refers to the logistics expense burden setting master 106a, and creates payment data for the ordering company, including the payment amount for logistics expenses calculated based on logistics expense setting information acquired from the logistics expense burden setting master 106a using the ordering company, the payment number, the payment date, the payee, the product, the expense item, the quantity, the unit price, the ordering company, and the product as keys, and the credit item, and stores the created billing data in the storage unit 106.

[0057] Furthermore, the logistics cost accounting processing unit 102c creates journal entry data for the procurement company, including the counterparty, debit / credit, account item, and amount, based on the billing data, and stores the data in the storage unit 106. The journal entry data may include offset journal entries including the debit, the revenue item of the billing data, and amount, and the credit, the offsetting account item and amount acquired from the logistics cost offset setting master 106b using the revenue item and credit item of the billing data as keys, and automatic offset journal entries including the debit / credit, the credit item of the billing data, and amount.

[0058] Furthermore, the logistics expense accounting processing unit 102c creates journal entry data for the ordering company, including the counterparty, debit / credit, account item, and amount, based on the payment data, and stores this in the storage unit 106. The journal entry data may include a journal entry including the debit, expense item of the payment data, and amount, an offset journal entry including the credit, offsetting account item and amount acquired from the logistics expense offset setting master 106b using the expense item and debt item of the payment data as keys, and an automatic offset journal entry including the debit / credit, debt item of the payment data, and amount.

[0059] [3-2. Sample data] 6 to 8E are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the logistics expense processing system 100 in this embodiment. A specific example of the processing by the control unit 102 of the logistics expense processing system 100 in this embodiment will be described with reference to FIGS. 6 to 8E. In the following example, a case will be described in which the master data examples in FIGS. 3 and 4 are used.

[0060] The "procurement company" compiles the ordering information of each group company and centralizes transactions with suppliers. Each group company purchases from the "procurement company." In the following example, within the group of companies, companies A, B, and C are ordering companies, and company D is the procurement company.

[0061] (S1: Order entry process) A specific example of order input processing will be described with reference to Figure 6. Each ordering company places an order with a procurement company. The procurement company collects the order information from each ordering company.

[0062] Figure 6 is a diagram showing an example of order data registered by an ordering company. The order data has the following fields: order number, company code, order date, supplier code (= procurement company), row number, product code, product name, and quantity. In the example shown in the figure, the first row has order number "HA001," company code "A," order date "2024 / 1 / 24," supplier code (= procurement company) "D," row number "1," product code "SH001," product name "wine," and quantity "30 bottles."

[0063] (S2: Purchase input processing) A specific example of order entry processing will be explained with reference to Figure 7. The procurement company places an order with the supplier based on the order data registered by the ordering company, and when the goods actually arrive, the procurement company records the logistics cost data because logistics costs are incurred for each purchase number.

[0064] 7A is a diagram showing an example of purchase data. The purchase data includes the following fields: purchase number, line number, purchase date, supplier code, ordering company code, original order number, original line number, product code, product name, quantity, unit price, purchase amount, unit weight, and weighing scale. In the example shown in the figure, the first line contains purchase number "SINO1," line number "1," purchase date "2024 / 1 / 31," supplier code "SI001," ordering company code "A," original order number "HA001," original line number "1," product code "SH001," product name "wine," quantity "30 bottles," unit price "5,000 yen," purchase amount "150,000 yen," unit weight "1.00 kg," and weighing scale "30.00 kg."

[0065] Figure 7(B) is a diagram showing an example of logistics cost data. The logistics cost data has fields for purchase number, occurrence date, and logistics cost. In the example shown in the figure, the first line contains purchase number "SINO1," occurrence date "2024 / 1 / 31," and logistics cost "30,000 yen."

[0066] (S3: Logistics cost purchase input processing) 8A to 8E, a specific example of the logistics cost purchase input process will be described. When an item is shipped from a procurement company to an ordering company (sales input), billing data and payment data related to the logistics costs incurred between the ordering company and the procurement company are created in accordance with the logistics cost burden setting master 106a, and journal entries are created in financial accounting, and journal entry offsetting processes are performed.

[0067] 8A is a diagram showing an example of data of the logistics cost burden setting master 106a. The logistics cost burden setting master 106a is a master that sets whether the logistics costs incurred at the time of purchase by the procurement company are to be borne by the ordering company or the procurement company, and it is possible to set a logistics cost burden flag and a logistics cost allocation method for each ordering company code and product code.

[0068] The logistics cost burden setting master 106a includes fields for the ordering company code, product code, logistics cost burden flag, and logistics cost allocation method. The logistics cost burden flag is set to "0: ordering company bears logistics costs" and "1: procurement company bears logistics costs." In the example shown in the figure, the first line contains the ordering company code "A," the product code "SH001," the logistics cost burden flag "1," and the logistics cost allocation method "quantity." The second line contains the ordering company code "B," the product code "SH001," the logistics cost burden flag "0," and the logistics cost allocation method "quantity." The third line contains the ordering company code "C," the product code "SH001," the logistics cost burden flag "0," and the logistics cost allocation method "quantity." In this example, the logistics costs for purchasing for company A are borne by procurement company D, and the logistics costs for purchasing for companies B and C are borne by companies B and C themselves.

[0069] In accordance with the distribution cost burden setting master 106a, journal entries relating to distribution costs are recorded for each ordering company.

[0070] Here, purchase data for product code = "SH001" will be described as an example. Fig. 8B(A) is a diagram showing an example of purchase data (partial excerpt). Fig. 8B(B) is a diagram showing an example of logistics cost data (partial excerpt). Fig. 8A is a diagram showing an example of data in the logistics cost burden setting master 106a (partial excerpt).

[0071] Calculate the logistics costs borne by companies A, B, and C. Calculation is based on the settings in the logistics cost burden setting master 106a, the "Purchase No.", "Ordering Company No.", "Product Code", and "Quantity" in the purchase data, and the "Logistics Cost" in the logistics cost data. Since the logistics cost allocation method in the logistics cost burden setting master 106a is "Quantity", the "Quantity" in the purchase data is used.

[0072] Company A: "Logistics cost" in the logistics cost data × ("Quantity (Company A)" in the purchasing data ÷ "Quantity (Company A + Company B + Company C)" in the purchasing data) = 30,000 × (30 ÷ 100) = 9,000 yen Company B: "Logistics cost" in the logistics cost data × ("Quantity (Company B)" in the purchasing data ÷ "Quantity (Company A + Company B + Company C)") in the purchasing data = 30,000 × (20 ÷ 100) = 6,000 yen Company C: "Logistics cost" in the logistics cost data × ("Quantity (Company C)" in the purchasing data ÷ "Quantity (Company A + Company B + Company C)" in the purchasing data) = 30,000 × (50 ÷ 100) = 15,000 yen

[0073] In accordance with the settings of the logistics cost burden flag and logistics cost allocation method in the logistics cost burden setting master 106a, billing data and payment data are created.

[0074] Figure 8C (A) is a diagram showing an example of billing data. The billing data includes company code, billing number, billing date, billing destination code (= group company), product code, product name (revenue account), quantity, unit price, billing amount, and credit account. Since the [Logistics Cost Burden Flag] = "1" in the record where "Ordering Company Code" = "A" in the logistics cost burden setting master 106a, no billing will be made from Procurement Company D to Company A. Since the [Logistics Cost Burden Flag] = "1" in the records where "Ordering Company Code" = "B" and "C" in the logistics cost burden setting master 106a, billing will be made from Procurement Company D to Companies B and C. In the example shown in the figure, the first line contains the company code "D", invoice number "SEIBNO1", invoice date "2024 / 1 / 31", invoice code (= group company), "B", product code "BU001", product name (revenue account) "Received logistics costs", quantity "1", unit price "6,000 yen", invoice amount "6,000 yen", and receivables account "Accounts receivable".

[0075] Figure 8C (B) is a diagram showing an example of payment data. The payment data includes the company code, payment number, payment date, payee code (= procurement company), product code, product name (expense item), quantity, unit price, payment amount, and debt item. Since the [Logistics Cost Burden Flag] = "1" in the record where "Ordering Company Code" = "A" in the logistics cost burden setting master 106a, no payment will be made from Company A to Procurement Company D. Since the [Logistics Cost Burden Flag] = "1" in the records where "Ordering Company Code" = "B" and "C" in the logistics cost burden setting master 106a, payments will be made from Companies B and C to Procurement Company D. In the example shown in the figure, the first line contains the company code "B", payment number "SIHDNO1", payment date "2024 / 1 / 31", payment recipient code (= procurement company) "D", product code "BU002", product name (expense item) "Logistics Payment Costs", quantity "1", unit price "6,000 yen", invoice amount "6,000 yen", and debt item "Accounts Payable".

[0076] Journal entries are automatically created and offset according to the settings of the logistics cost burden flag and logistics cost allocation method in the logistics cost burden setting master 106a.

[0077] 8D(A) is a diagram showing an example of data in the logistics cost offset setting master 106b. The logistics cost offset setting master 106b has items for revenue / expense item, credit / debt item, and offsetting account item. In the example shown in the figure, the first line has the revenue / expense item "Payment logistics cost," the credit / debt item "Accounts receivable," and the offsetting account item "Intra-group logistics cost offset," while the second line has the revenue / expense item "Received / paid logistics cost," the credit / debt item "Accounts payable," and the offsetting account item "Intra-group logistics cost offset."

[0078] We will explain an example of accounting entries related to logistics costs incurred between Company A and Procurement Company D. Company A: No occurrence Company D: No occurrence (included in accounts payable to supplier "SI001")

[0079] Explain an example of accounting entry related to logistics costs incurred between Company B and Procurement Company D. The offset account used when offsetting logistics costs between group companies is set in the logistics cost offset setting master 106b. Journal entry data is created as follows based on the billing data and payment data.

[0080] - When creating journal data from billing data 1. The product name (revenue item) of the billing data and the receivable item of the billing data are used to refer to the logistics cost offset setting master 106b, and the offset account item is obtained. 2. Refer to the invoice data and create journal data. 3. Create journal entry data (offsetting journal entry) by referencing the offsetting account and invoice data obtained in 1.

[0081] - When creating journal data from payment data 1. The product name (expense item) of the payment data and the liability item of the payment data are used to refer to the logistics cost offset setting master 106b, and the offset account item is obtained. 2. Refer to the payment data and create journal data. 3. Create journal entry data (offsetting journal entry) by referencing the offsetting account and payment data obtained in 1.

[0082] The journal data includes the following fields: company code, journal entry number, journal entry line number, processing date, counterparty, debit / credit, account item, amount, and originating document number.

[0083] FIG. 8D(B) is a diagram showing an example of journal entry data generated by Company B. The first line is a journal entry (debit, account item "Payment Logistics Expenses") created based on the payment data in the first line of FIG. 8C(B). The second and third lines are journal entries created based on the payment data in the first line of FIG. 8C(B), with the second line being a debit, account item "Accounts Payable" (offset counterpart: journal entry number "SWKBO2", journal entry line number "1"), and the third line being a credit, account item "Accounts Payable" (offset counterpart: journal entry number "SWKBO1", journal entry line number "2"). The fourth line is a journal entry (credit side, account item "Intra-group logistics cost offset") that is created based on the payment data by obtaining the offsetting account item "Intra-group logistics cost offset" from the logistics cost offset setting master 106b using the product name (expense item) "Payment logistics cost" and the receivable item "Accounts payable" of the payment data in the first line of Figure 8C (B) as keys.

[0084] Figure 8D(C) is a diagram showing an example of journal entry data generated by Company D. Lines 1 and 4 are automatic offsetting journal entries created based on the billing data in line 1 of Figure 8C(A). Line 1 is a debit entry with the account item "Accounts Receivable" (offset counterpart: journal entry number "SWKDO2", journal entry line number "2"), and line 4 is a credit entry with the account item "Accounts Receivable" (offset counterpart: journal entry number "SWKDO1", journal entry line number "1"). Line 2 is a journal entry created based on the billing data in line 1 of Figure 8C(A) (credit entry with the account item "Receivable Logistics Expenses"). The third line is a journal entry (debit, account item "Intra-group logistics cost offset") that is created based on the billing data by obtaining the offsetting account item "Intra-group logistics cost offset" from the logistics cost offset setting master 106b using the product name (revenue item) "Received logistics cost" and the receivables item "Accounts receivable" of the billing data in the first line of Figure 8C (A) as keys.

[0085] Next, we will explain an example of accounting entries related to logistics costs incurred between Company C and Procurement Company D. FIG. 8E(A) is a diagram showing an example of journal entry data generated at Company C. The first line is a journal entry (debit, account item "Logistics Payments") created based on the payment data in the second line of FIG. 8C(B). The second and third lines are journal entries created based on the payment data in the second line of FIG. 8C(B), with the second line being a debit, account item "Accounts Payable" (offset counterpart: journal entry number "SWKCO2", journal entry line number "1"), and the third line being a credit, account item "Accounts Payable" (offset counterpart: journal entry number "SWKCO1", journal entry line number "2"). The fourth line is a journal entry (credit side, account item "Intra-group logistics cost offset") that is created based on the payment data, by retrieving the offsetting account item "Intra-group logistics cost offset" from the logistics cost offset setting master 106b using the product name (expense item) "Payment logistics cost" and the receivable item "Accounts payable" of the payment data in the second line of Figure 8C (B) as keys.

[0086] Figure 8E(B) is a diagram showing an example of journal entry data generated by Company D. Lines 1 and 4 are journal entries created based on the billing data in line 2 of Figure 8C(A). Line 1 is a debit entry with the account item "Accounts Receivable" (offset counterpart: journal entry number "SWKDO4", journal entry line number "2"), and line 4 is a credit entry with the account item "Accounts Receivable" (offset counterpart: journal entry number "SWKDO3", journal entry line number "1"). Line 2 is a journal entry created based on the billing data in line 2 of Figure 8C(A) (credit entry with the account item "Receivable Logistics Expenses"). The third line is a journal entry (debit, account item "Intra-group logistics cost offset") that is created based on the billing data by obtaining the offsetting account item "Intra-group logistics cost offset" from the logistics cost offset setting master 106b using the product name (revenue item) "Received logistics cost" and the receivables item "Accounts receivable" of the billing data in the second line of Figure 8C (A) as keys.

[0087] As described above, according to this embodiment, there are provided a logistics cost burden setting master 106a which associates and registers logistics cost burden information for setting the burden of ordering companies, products, and logistics costs; an order input unit 102a which inputs ordering data of ordering companies including order number, line number, ordering company, order date, supplier (procurement company), product, and quantity; a purchase input unit 102b which creates purchase data including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale based on the order data, and creates logistics cost data including purchase number, occurrence date, and logistics costs when products arrive after an order is placed based on the purchase data; and a purchase input unit 102b which, based on the purchase data and the logistics cost data, refers to the logistics cost burden setting master 106a and The system is equipped with a logistics expense accounting and logistics expense processing system 102c that creates invoicing data for the procurement company, including the invoice amount and credit item for logistics expenses calculated based on logistics expense setting information acquired from the first master using the procurement company, the ordering company (the invoice recipient), invoice number, invoice date, product, revenue item, ordering company, and product as keys, and payment data for the ordering company, including the payment amount and credit item for logistics expenses calculated based on logistics expense setting information acquired from the logistics expense burden setting master 106a using the ordering company, payment number, payment date, procurement company (the payee), product, expense item, quantity, unit price, ordering company, and product as keys, thereby enabling efficient management of logistics expenses incurred in internal transactions between ordering companies and procurement companies within a group of companies.

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

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

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

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

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

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

[0094] Furthermore, with regard to the physical distribution expense 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.

[0095] For example, all or any part of the processing functions of the logistics expense 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 logistics expense processing system 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

[0096] In addition, this computer program may be stored in an application program server connected to the physical distribution expense processing system 100 via any network, and all or part of it may be downloaded as needed.

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

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

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

[0100] The logistics expense 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 logistics expense processing system 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

[0101] 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]

[0102] 100 Logistics Cost Processing System 102 Control section 102a Order input section 102b Purchase Input Section 102c Logistics cost accounting processing section 102d Master Maintenance Department 102e Screen display control unit 104 Communication interface unit 106 Storage section 106a Logistics Cost Burden Setting Master 106b Logistics cost offset setting master 200 servers 300 Network 400 Ordering company's system

Claims

1. A logistics cost processing system for processing logistics costs associated with transactions among group companies, the system comprising: The control unit The system is configured to be able to access a first master in which order source companies, products, and logistics cost burden information for setting the burden of logistics costs are associated and registered, an order input means for inputting order data of an ordering company including an order number, a line number, an ordering company, an order date, a supplier which is a procurement company, a product, and a quantity; A purchasing input means for creating purchasing data for a procurement company based on the order data, including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale, and creating logistics cost data including purchase number, date of occurrence, and logistics cost when the product arrives after an order is placed based on the purchasing data; a logistics cost accounting processing means for creating, based on the purchase data and the logistics cost data, billing data for the procurement company including a billing amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the procurement company, the bill-to-recipient which is the ordering company, the billing No., the billing date, the product, the revenue item, the ordering company, and the product as keys, and payment data for the ordering company including a payment amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the ordering company, the payment No., the payment date, the payee which is the procurement company, the product, the expense item, the quantity, the unit price, the ordering company, and the product as keys; A logistics cost processing system comprising:

2. The logistics cost processing system of claim 1, characterized in that the logistics cost burden information includes a logistics cost burden flag that specifies whether the logistics costs are to be borne by the ordering company or the procurement company, and a logistics cost allocation method for determining the allocation ratio of the logistics costs of the ordering company.

3. A logistics expense processing system as described in claim 1 or 2, characterized in that the logistics expense accounting processing means creates accounting data for the procurement company including the counterparty, debit / credit, account item, and amount based on the billing data.

4. A logistics expense processing system as described in claim 3, characterized in that the logistics expense accounting processing means creates accounting data for the procurement company including the counterparty, debit / credit, account item, and amount based on the payment data.

5. The control unit further 5. A logistics expense processing system according to claim 4, which is configured to be able to access a second master in which revenue / expense items, credit / debt items, and offsetting account items are associated and registered.

6. The logistics expense processing system of claim 5, characterized in that the procurement company's journal data includes a journal entry including a debit, the revenue item and amount of the billing data, a credit, the offsetting account item and amount obtained from the second master using the revenue item and credit item of the billing data as keys, and a debit / credit, the credit item and amount of the billing data.

7. The logistics expense processing system of claim 6, characterized in that the accounting data of the ordering company includes a debit, an accounting entry including the expense item and amount of the payment data, a credit, an offsetting account item and amount obtained from the second master using the expense item and debt item of the payment data as keys, and a debit / credit, an accounting entry including the debt item and amount of the payment data.

8. A logistics expense 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 first master in which order source companies, products, and logistics cost burden information for setting the burden of logistics costs are associated and registered, Executed in the control unit: an order input process for inputting order data of the ordering company including an order number, a line number, an ordering company, an order date, a supplier which is a procurement company, a product, and a quantity; A purchase input process for creating purchase data for a procurement company based on the order data, including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale, and creating logistics cost data including purchase number, occurrence date, and logistics cost when the product arrives after an order is placed based on the purchase data; a logistics cost accounting process for creating, with reference to the first master, based on the purchase data and the logistics cost data, billing data for the procurement company including a billing amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the procurement company, the bill-to-recipient which is the ordering company, the billing No., the billing date, the product, the revenue item, the ordering company, and the product as keys, and payment data for the ordering company including a payment amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the ordering company, the payment No., the payment date, the payee which is the procurement company, the product, the expense item, the quantity, the unit price, the ordering company, and the product as keys, and A logistics cost processing method comprising:

9. A physical distribution cost 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 first master in which order source companies, products, and logistics cost burden information for setting the burden of logistics costs are associated and registered, The control unit an order input process for inputting order data of the ordering company including an order number, a line number, an ordering company, an order date, a supplier which is a procurement company, a product, and a quantity; A purchase input process for creating purchase data for a procurement company based on the order data, including purchase number, line number, purchase date, supplier, ordering company, product, quantity, unit price, purchase amount, unit weight, and weight scale, and creating logistics cost data including purchase number, occurrence date, and logistics cost when the product arrives after an order is placed based on the purchase data; a logistics cost accounting process for creating, with reference to the first master, based on the purchase data and the logistics cost data, billing data for the procurement company including a billing amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the procurement company, the bill-to-recipient which is the ordering company, the billing No., the billing date, the product, the revenue item, the ordering company, and the product as keys, and payment data for the ordering company including a payment amount and a credit item for logistics costs calculated based on logistics cost setting information acquired from the first master using the ordering company, the payment No., the payment date, the payee which is the procurement company, the product, the expense item, the quantity, the unit price, the ordering company, and the product as keys, and A logistics cost processing program for executing the above.

Images