JP7572985B2 - Delivery note creation device, delivery note creation method, and delivery note creation program - Google Patents

Description

The present invention relates to an invoice creation device, an invoice creation method, and an invoice creation program.

Patent Document 1 relates to a distribution inventory information providing system, and in particular discloses a system that generates and provides distribution inventory information based on information obtained from a traceability system, and also discloses that "distribution inventory" refers to inventory held by businesses in the product distribution process, such as wholesalers and retailers (see paragraph 0001 of Patent Document 1).

JP 2021-82365 A

As described in the above Patent Document 1, there are industries in which wholesalers (customers of the company) and retailers (delivery destinations of the company) exist in the distribution of goods.

In this type of industry, ideally, a company would only need to create its own delivery note (the delivery note that the company sends to the customer). However, in practice, the company often creates the delivery note that should be sent by the customer to the delivery destination "on behalf of" the customer. This type of delivery note is called a proxy delivery note. A proxy delivery note is attached, for example, when goods are delivered from the customer to the delivery destination.

However, in the past, invoices were created manually by in-house staff, which meant a high workload and a high risk of errors.

The present invention has been made in consideration of the above problems, and aims to provide an invoice creation device, an invoice creation method, and an invoice creation program that can create both company invoices and proxy invoices.

In order to solve the above-mentioned problems and achieve the object, the delivery note creation device of the present invention is a delivery note creation device having a control unit and a memory unit that can create a company delivery note, which is a delivery note that includes the amount of sales from the company to the customer, when the company delivers goods to a delivery destination via a customer, and an agent delivery note, which is a delivery note that includes the amount of sales from the customer to the delivery destination and is created by the company on behalf of the customer, and the memory unit stores customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price that is the unit price of the product when the company sells the product to the customer, and a delivery note that is a delivery note that is created by the customer on behalf of the customer. The control unit stores a unit price master including a delivery destination unit price which is the unit price of the commodity in the case where the commodity is sold first, and an agency master including the customer identification data, the delivery destination identification data, and a category for identifying whether or not the agency delivery note has been created, which is set for each combination of the customer and the delivery destination, and the control unit acquires from the unit price master a customer unit price and a delivery destination unit price which are linked to the customer identification data, delivery destination identification data, and commodity identification data inputted to the sales input screen, and acquires a sales quantity of the commodity from the company to the customer for each combination of the customer, the delivery destination, and the commodity by multiplying the customer unit price acquired by the unit price acquisition means by the number of sales of the commodity from the company to the customer for each combination of the customer, the delivery destination, and the commodity. a sales slip table generating means for calculating the sales slip table including the input customer identification data and the calculated sales amount corresponding to the input customer identification data by aggregating the sales amount calculated by the sales slip calculation means for each customer, the delivery destination, and the product, and generating a sales slip table including the input customer identification data and the calculated sales amount corresponding to the input customer identification data, and a sales slip table generating means for generating a sales slip table including the sales amount calculated by the sales slip calculation means for each customer, the delivery destination, and the product, and generating a sales slip table including the sales amount corresponding to the input customer identification data by aggregating the sales amount calculated by the sales slip calculation means for each customer, the delivery destination, and the product, and generating a sales slip table including the sales amount corresponding to the input customer identification data by aggregating the sales amount calculated by the sales slip calculation means for each customer, the delivery destination, and the product, The system is characterized by comprising: an agency sales slip table generating means for extracting only the sales amount corresponding to the agency target combination, which is a combination of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note will be created is set in the agent, and generating agency sales slip tables including the agency target combination and the sales amount extracted as corresponding to the agency target combination, for the number of the agency target combinations; a company delivery slip creating means for creating the company delivery slip including the customer identification data and the sales amount based on the sales slip table; and an agency delivery slip creating means for creating the agency delivery slip including the agency target combination and the sales amount based on the agency sales slip table, for the number of the agency target combinations.

In addition, in the delivery note creation device according to the present invention, the control unit calculates the sales amount from the company to the customer for each combination of the delivery destination and the product by aggregating the sales amount from the company to the customer for each combination of the delivery destination and the product calculated by the customer sales calculation means, and calculates the sales amount from the company to the customer for each combination of the delivery destination and the product by aggregating the sales amount from the customer to the delivery destination for each combination of the customer, the delivery destination and the product calculated by the delivery sales calculation means, The system further includes a delivery destination-specific product sales calculation means for calculating the amount of sales from the customer to the delivery destination for each combination of the delivery destination and the product, and a performance table creation means for creating a delivery destination-specific product sales performance table including the input delivery destination identification data, the input product identification data, the sales amount from the company to the customer for each combination of the delivery destination and the product calculated by the delivery destination-specific product sales calculation means, and the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product calculated by the delivery destination-specific product sales calculation means.

In addition, the invoice creation method according to the present invention is a method executed by an information processing device having a control unit and a storage unit, which is capable of creating an invoice including the amount of sales from the company to the customer when the company delivers goods to a delivery destination via a customer, and an agent invoice including the amount of sales from the customer to the delivery destination and created by the company on behalf of the customer, and the storage unit stores customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price which is the unit price of the product when the company sells the product to the customer, and a customer unit price which is the unit price of the product when the customer sells the product to the delivery destination. and an agency master including the customer identification data, the delivery destination identification data, and a category for identifying whether or not the agency delivery note has been created, which is set for each combination of the customer and the delivery destination, and a unit price acquisition step executed by the control unit is to acquire, from the unit price master, a customer unit price and a delivery destination unit price linked to the customer identification data, delivery destination identification data, and product identification data input to the sales input screen, and calculate a sales amount from the company to the customer for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the company to the customer for each combination of the customer, the delivery destination, and the product by the customer unit price acquired in the unit price acquisition step. a customer sales calculation step of calculating a sales amount from the customer to the customer for each combination of the customer, the customer, and the product by multiplying the sales quantity of the product from the customer to the customer for each combination of the customer, the customer, and the product by the customer unit price acquired in the unit price acquisition step; a sales slip table generation step of calculating the sales amount from the company to the customer by aggregating the sales amount calculated in the customer sales calculation step for each customer, and generating a sales slip table including the customer identification data input and the calculated sales amount corresponding to the customer identification data input; The method includes an agency sales slip table generation step of extracting only the sales amount corresponding to the agency target combination, which is a combination of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note will be created is set in the agent, and generating agency sales slip tables including the agency target combination and the sales amount extracted as corresponding to the agency target combination, for the number of agency target combinations; an agency delivery slip creation step of creating the agency delivery slip including the customer identification data and the sales amount based on the sales slip table; and an agency delivery slip creation step of creating the agency delivery slip including the agency target combination and the sales amount based on the agency sales slip table, for the number of agency target combinations.

In addition, the delivery note creation program of the present invention is a delivery note creation program to be executed by an information processing device having a control unit and a storage unit, which is capable of creating a company delivery note, which is a delivery note including the amount of sales from the company to the customer, when the company delivers goods to a delivery destination via a customer, and an agent delivery note, which is a delivery note including the amount of sales from the customer to the delivery destination and is created by the company on behalf of the customer, in the case where the company delivers goods to the delivery destination from the company, and the storage unit stores customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price which is the unit price of the product when the company sells the product to the customer, and a customer unit price which is the unit price of the product when the customer sells the product to the delivery destination. and an agent master including the customer identification data, the agent identification data, and a category for identifying whether or not the agent delivery note is to be created, which is set for each combination of the customer and the agent, and a unit price acquisition step for causing the control unit to execute the step of acquiring, from the unit price master, a customer unit price and a agent unit price associated with the customer identification data, the agent identification data, and the product identification data input to the sales input screen, and multiplying the number of sales of the product from the company to the customer for each combination of the customer, the agent, and the product by the customer unit price acquired in the unit price acquisition step. a customer sales calculation step of calculating a sales amount from the customer to the customer for each combination of the customer, the customer, and the product by multiplying the sales quantity of the product from the customer to the customer for each combination of the customer, the customer, and the product by the customer unit price acquired in the unit price acquisition step; a sales slip table generation step of calculating the sales amount from the company to the customer by aggregating the sales amounts calculated in the customer sales calculation step for each customer, and generating a sales slip table including the customer identification data input and the calculated sales amount corresponding to the customer identification data input; The method includes an agency sales slip table generation step of extracting only the sales amount corresponding to the agency target combination, which is a combination of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note will be created is set in the agency master, and generating agency sales slip tables including the agency target combination and the sales amount extracted as corresponding to the agency target combination, for the number of agency target combinations; a company delivery slip creation step of creating the company delivery slip including the customer identification data and the sales amount based on the sales slip table; and an agency delivery slip creation step of creating the agency delivery slip including the agency target combination and the sales amount based on the agency sales slip table, for the number of agency target combinations.

The present invention has the advantage of being able to create both company delivery notes and proxy delivery notes.

FIG. 1 is a block diagram showing an example of the configuration of an invoice creation device. FIG. 2 is a diagram showing an example of items in the unit price master, the agency master, and the sales information table. FIG. 3 is a conceptual diagram showing the relationships in a transaction between the company, its customers, and its customers. FIG. 4 is a diagram showing an example of a processing flow according to the present embodiment. FIG. 5 is a diagram showing an example of a sales input screen. FIG. 6 is a diagram showing an example of a sales statement input screen. FIG. 7 is a diagram showing an example of a screen for creating an invoice. FIG. 8 is a diagram showing an example of the created substitute delivery note. FIG. 9 is a diagram showing an example of the unit price master and the substitution master. FIG. 10 is a diagram illustrating an example of a sales information table. FIG. 11 is a diagram showing an example of a sales slip table and an agency sales slip table. FIG. 12 is a diagram showing an example of a screen for creating a product sales performance table by delivery destination. FIG. 13 is a diagram showing an example of the created product sales performance table by delivery destination.

Below, an embodiment of a delivery note creation device, a delivery note creation method, and a delivery note creation program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiment.

[1. Overview]
In the food industry, for example, there are often companies that issue invoices between the companies that actually deliver to the account holder. In this case, the account holder is the customer of the company, so ideally it would be sufficient to create sales invoices only for the account holder, but in practice, it is common for the company to create invoices on behalf of the company that will be the delivery recipient (the customer of the customer) and attach them when delivering the goods.

Such a transaction will be explained with reference to Figure 3. As shown in Figure 3, the company creates and sends its own invoice (a delivery note sent from the company to its customer) to its customer. The sales amount on the company's invoice is the transaction amount from the company to the customer. On the other hand, as shown in Figure 3, the company creates and sends an agency invoice (a delivery note that should be sent from the company's customer to the delivery destination) on behalf of the customer to the delivery destination. The sales amount on the agency invoice is the transaction amount from the company's customer to the delivery destination.

However, traditionally, invoices were created manually by in-house staff, which meant a high workload and a high risk of errors.

Therefore, in this embodiment, for example, in the agency master, it is possible to set whether or not to create an agency invoice for each combination of customer and delivery destination. Then, for combinations where the "Yes" category is set, an agency delivery note can be automatically created.

In addition, in this embodiment, for example, by making it possible to compare the amount of sales from the company to the customer with the amount of sales from the customer to the delivery destination, it is possible to grasp the actual amount of products that the delivery destination actually purchased from the customer out of the products that the company delivered to the customer.

This embodiment is useful, for example, in industries where a company's customers and its delivery destinations may be different. Specifically, it is useful in the food industry, wholesale industry, mass retailer industry, machinery industry, steel industry, trading company industry, and construction industry. This embodiment is also useful in industries where there is a trade flow that consolidates orders, such as cooperatives. The specific configuration and operation are described below.

2. Configuration
An example of the configuration of the delivery note creation device 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 delivery note creation device 100.

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

The invoice creation device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the invoice creation device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the invoice creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the invoice creation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

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 home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. 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, or the like.

The memory unit 106 includes, for example, a unit price master 106a, an agency master 106b, a sales information table 106c, a sales slip table 106d, and an agency sales slip table 106e.

According to the delivery note creation device 100 of this embodiment, when a company delivers goods to a delivery destination via a customer, it is possible to create a company delivery note, which is a delivery note that includes the amount of sales from the company to the customer, and an agency delivery note, which is a delivery note that includes the amount of sales from the customer to the delivery destination and is created by the company on behalf of the customer.

As shown in Figures 2 and 9, the unit price master 106a includes, for example, customer identification data (customer code) for identifying the customer, delivery destination identification data (delivery destination code) for identifying the delivery destination, product identification data (product code) for identifying the product, a customer unit price which is the unit price of the product when the product is sold from the company to the customer, and a delivery destination unit price which is the unit price of the product when the product is sold from the customer to the delivery destination.

As shown in Figures 2 and 9, the agency master 106b includes, for example, the customer identification data (customer code), the delivery destination identification data (delivery destination code), and a classification (agency voucher presence/absence) for identifying whether or not the agency delivery note is to be created, which is set for each combination of the customer and the delivery destination.

The category (with or without agency voucher) is either "with", which means that the agency delivery note will be created, or "without", which means that the agency delivery note will not be created. In agency master 106b in FIG. 9, the category "with" is set for the combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd." and the combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd.", so that the agency delivery note will be created for those two combinations.

The sales information table 106c is a table that is the basis for generating the sales slip table 106d and the agency sales slip table 106e. As shown in FIG. 2 and FIG. 9, the sales information table 106c includes, for example, the sales number, the sales line number, the customer identification data (customer code), the delivery destination identification data (delivery destination code), the product identification data (product code), the shipping date, the delivery date, the sales quantity, the sales amount (sales amount) from the company to the customer, the cost amount, the gross profit, the sales amount from the customer to the delivery destination (delivery destination sales), and the like.

The sales slip table 106d is the table from which the company's delivery note is created. As shown in FIG. 11, the sales slip table 106d includes, for example, the sales number, the customer identification data (customer code), the delivery destination identification data (delivery destination code), the sales amount (sales amount) from the company to the customer, the cost amount, the gross profit, etc.

The agency sales slip table 106e is the table from which the agency delivery note is created. As shown in FIG. 11, the agency sales slip table 106e includes, for example, the sales number, the customer identification data (customer code), the delivery destination identification data (delivery destination code), and the sales amount (sales amount) from the customer to the delivery destination.

The control unit 102 is a CPU or the like that provides overall control of the invoice creation device 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.

The control unit 102 has, in terms of its functional concept, for example: (1) a unit price acquisition unit 102a as a unit price acquisition means for acquiring, from the unit price master, a customer unit price and a delivery destination unit price that are linked to the customer identification data, delivery destination identification data, and product identification data entered on the sales input screen; (2) a customer sales calculation unit 102b as a customer sales calculation means for calculating the amount of sales from the company to the customer for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the company to the customer for each combination of the customer, the delivery destination, and the product by the customer unit price acquired by the unit price acquisition means; and (3) a customer sales calculation unit 102c as a customer sales calculation means for calculating the amount of sales from the company to the customer for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by the delivery destination unit price acquired by the unit price acquisition means. (4) a sales slip table generating unit 102d as a sales slip table generating means for calculating the sales amount from the company to the customer by aggregating the sales amount calculated by the customer sales calculation means for each customer, and generating a sales slip table including the input customer identification data and the calculated sales amount corresponding to the input customer identification data; (5) extracting only the sales amount corresponding to an agent target combination, which is a combination of the customer identification data and the ship-to-customer identification data for which a classification indicating that an agent delivery note will be created is set in the agent master, from the sales amount calculated by the customer sales calculation means, and extracting the agent target combination and the sales amount extracted as corresponding to the agent target combination; (6) an agency sales slip table generating unit 102e as agency sales slip table generating means that generates agency sales slip tables including the customer identification data and the sales amount based on the sales slip table, (7) an agency delivery note creating unit 102g as agency delivery note creating means that creates agency delivery notes including the agency target combinations and the sales amounts based on the agency sales slip table, for the number of agency target combinations, and (8) aggregating the sales amounts from the company to the customer for each combination of the customer, the delivery destination, and the product calculated by the customer sales calculation means, for each combination of the delivery destination and the product, thereby calculating the sales amounts from the company to the customer for each combination of the delivery destination and the product. On the other hand, the system includes a delivery destination-specific product sales calculation unit 102h as delivery destination-specific product sales calculation means for calculating the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product by aggregating the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product calculated by the delivery destination sales calculation means for each combination of the delivery destination and the product, and (9) a result table creation unit 102i as a result table creation means for creating a delivery destination-specific product sales result table including the input delivery destination identification data, the input product identification data, the sales amount from the company to the customer for each combination of the delivery destination and the product calculated by the delivery destination-specific product sales calculation means, and the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product calculated by the delivery destination-specific product sales calculation means. Note that the contents of the processing executed by each unit are described in the following [3. This will be explained in [Specific examples of processing].

3. Specific examples of processing
In this section, a specific example of the process according to this embodiment will be described. As a flow of the process according to this embodiment, as shown in FIG. 4, a sales information table 106c is generated by inputting sales data and referring to the unit price master 106a and the agency master 106b. Next, as shown in FIG. 4, a sales slip table 106d and an agency sales slip table 106e are generated based on the generated sales information table 106c. However, the agency sales slip table 106e is generated only when an agency slip (agency delivery note) needs to be created. Then, as shown in FIG. 4, a company delivery note is generated based on the generated sales slip table 106d, and an agency delivery note is generated based on the generated agency sales slip table 106e. However, a company delivery note is generated regardless of whether an agency slip (agency delivery note) is created, whereas an agency delivery note is generated only when the agency sales slip table 106e exists.

The process is explained in detail below, dividing it into the creation of a delivery note and the creation of a sales report by product and delivery destination.

[3-1. Creating a delivery note]
In this section, the creation of the company's delivery note and the proxy delivery note will be explained with reference to Figs. 5 to 11. In this section, a case is assumed in which the company delivers goods to the delivery destinations "Chiba Co., Ltd.", "Okinawa Co., Ltd.", and "Kochi Co., Ltd." through the customer "△△ Bussan," and the company creates a company delivery note including the sales amount from the company to "△△ Bussan," a proxy delivery note including the sales amount from the company to "Chiba Co., Ltd.", and a proxy delivery note including the sales amount from the company to "Okinawa Co., Ltd." In this section, the unit price master 106a and the proxy master 106b are assumed to be registered in advance with the contents shown in Fig. 9.

(1) Unit Price Acquisition Process The unit price acquisition unit 102a acquires, from the unit price master 106a, the customer unit price and the delivery destination unit price associated with the customer identification data, delivery destination identification data, and product identification data input on the sales input screen.

Specifically, as shown in the sales input screen of FIG. 5, the customer "A001: △△ Bussan" and the delivery destination "N001: Chiba Co., Ltd." are entered, and as shown in the sales detail input screen of FIG. 6 (which is considered to be included in the sales input screen in a broad sense), the product "12345: Product A" is entered by the company's staff. In this case, the unit price acquisition unit 102a acquires the customer unit price of 800 yen and the delivery destination unit price of 1,000 yen from the unit price master 106a of FIG. 9 as the unit prices associated with the customer code "A001: △△ Bussan", the delivery destination "N001: Chiba Co., Ltd.", and the product "12345: Product A".

In a similar manner, the unit price acquisition unit 102a acquires a customer unit price of 800 yen and a delivery destination unit price of 1,100 yen as unit prices associated with the customer "A001: △△ Bussan", delivery destination "N002: Okinawa Co., Ltd.", and product "12345: Product A", and also acquires a customer unit price of 800 yen and a delivery destination unit price of 1,100 yen as unit prices associated with the customer "A001: △△ Bussan", delivery destination "N003: Kochi Co., Ltd.", and product "12345: Product A".

(2) Sales to Customer Calculation Processing The sales to customer calculation unit 102b calculates the amount of sales from the company to the customer for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the company to the customer for each combination of the customer, the delivery destination, and the product by the customer unit price acquired by the unit price acquisition unit 102a.

Specifically, assume that 10 units (as shown in the sales details input screen in FIG. 6), 1 unit (not shown in the screen example), and 1 unit (not shown in the screen example) are entered as the sales quantities from the company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Chiba Co., Ltd.", and the product A. In this case, the sales to customer calculation unit 102b uses the customer unit price of 800 yen acquired by the unit price acquisition unit 102a to calculate "(10 units x customer unit price 800 yen) + (1 unit x customer unit price 800 yen) + (1 unit x customer unit price 800 yen)" = "8,000 yen + 800 yen + 800 yen" = 9,600 yen. The calculated 9,600 yen is the sales amount from the company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Chiba Co., Ltd.", and the product A.

In a similar manner, the sales to customer calculation unit 102b calculates 9,600 yen as the sales amount from the company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Okinawa Co., Ltd.", and product A, and also calculates 9,600 yen as the sales amount from the company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Kochi Co., Ltd.", and product A.

(3) Sales to Delivery Destination Calculation Processing The sales to delivery destination calculation unit 102c calculates the amount of sales from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by the delivery destination unit price acquired by the unit price acquisition unit 102a.

Specifically, assume that 10 units (as shown on the sales details input screen in FIG. 6), 1 unit (not shown on the screen example), and 1 unit (not shown on the screen example) are entered as the sales quantities from △△ Bussan to △△ Bussan for product A. In this case, the sales to destination calculation unit 102c uses the destination unit price of 1,000 yen acquired by the unit price acquisition unit 102a to calculate "(10 units x destination unit price 1,000 yen) + (1 unit x destination unit price 1,000 yen) + (1 unit x destination unit price 1,000 yen)" = "10,000 yen + 1,000 yen + 1,000 yen" = 12,000 yen. The calculated amount of 12,000 yen will be the sales revenue from △△ Bussan to "Chiba Co., Ltd." for the customer "△△ Bussan", the delivery destination "Chiba Co., Ltd.", and product A.

In this example, we have explained the case where the sales figures from our company to △△ Bussan and the sales figures from △△ Bussan to "Chiba Co., Ltd." are the same, but it goes without saying that the sales figures for the two parties may be different.

In a similar manner, the destination sales calculation unit 102c calculates 13,200 yen as destination sales from △△ Bussan to "Okinawa Co., Ltd." for the customer "△△ Bussan," the destination "Okinawa Co., Ltd.", and product A, and also calculates 13,200 yen as destination sales from △△ Bussan to "Kochi Co., Ltd." for the customer "△△ Bussan," the destination "Kochi Co., Ltd.", and product A.

Then, a sales information table 106c shown in FIG. 10 is generated, which includes the sales amount calculated in (2) and the delivery sales etc. calculated in (3). Of the three sales information tables 106c shown in FIG. 10, the top table is a table for the customer "△△ Bussan", delivery destination "Chiba Co., Ltd." and product A, the middle table is a table for the customer "△△ Bussan", delivery destination "Okinawa Co., Ltd." and product A, and the bottom table is a table for the customer "△△ Bussan", delivery destination "Kochi Co., Ltd." and product A.

(4) Sales slip table generation process The sales slip table generation unit 102d calculates the sales amount from the company to the customer by aggregating the sales amounts calculated by the customer sales calculation unit 102b for each customer, and generates a sales slip table 106d that includes the input customer identification data and the calculated sales amount corresponding to the input customer identification data.

Specifically, in (2), the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Chiba Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen, in (2), the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Okinawa Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen, in (2), the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Kochi Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen.

In this case, the sales slip table generation unit 102d calculates 28,800 yen by aggregating these three sales amounts in the unit of customer "△△ Bussan." In other words, the sales amount from our company to "△△ Bussan" is 28,800 yen.

Then, the sales slip table generation unit 102d generates the sales slip table 106d shown in FIG. 11, which includes the customer "△△ Bussan" entered on the sales input screen in FIG. 5, the calculated sales amount of 28,800 yen corresponding to the customer "△△ Bussan," and so on.

(5) Agency sales slip table generation process The agency sales slip table generation unit 102e extracts only the sales amounts corresponding to agency target combinations, which are combinations of the customer identification data and the delivery destination identification data for which the category “Yes” is set in the agency master 106b, meaning that the agency delivery note will be created, from the sales amounts calculated by the delivery destination sales calculation unit 102c, and generates agency sales slip tables 106e containing the agency target combinations and the sales amounts extracted as corresponding to the agency target combinations, the number of which is the same as the number of agency target combinations.

Specifically, in (3), the destination sales from △△ Bussan to "Chiba Co., Ltd." for the customer "△△ Bussan," the destination "Chiba Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 12,000 yen, in (3), the destination sales from △△ Bussan to "Okinawa Co., Ltd." for the customer "△△ Bussan," the destination "Okinawa Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 13,200 yen, and in (3), the destination sales from △△ Bussan to "Kochi Co., Ltd." for the customer "△△ Bussan," the destination "Kochi Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 13,200 yen.

Now, referring to the agency master 106b in Figure 9, the agency voucher presence/absence category "Yes" is set for the combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd.", and the combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd.". Therefore, the combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd.", and the combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd." are target combinations for agency.

In this case, the agency sales slip table generating unit 102e extracts the delivery sales of 12,000 yen corresponding to the agency target combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd.", and the delivery sales of 13,200 yen corresponding to the agency target combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd." In contrast, the agency sales slip table generating unit 102e does not extract the delivery sales of 13,200 yen corresponding to the customer "△△ Bussan" and delivery destination "Kochi Co., Ltd.".

Then, the agency sales slip table generating unit 102e generates agency sales slip table 106e (Chiba) shown in FIG. 11, which includes the agency target combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd.", and the delivery destination sales of 12,000 yen extracted as corresponding to the agency target combination, and agency sales slip table 106e (Okinawa) shown in FIG. 11, which includes the agency target combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd.", and the delivery destination sales of 13,200 yen extracted as corresponding to the agency target combination.

In other words, since there are two possible combinations, two agency sales slip tables 106e are also created.

(6) Company Invoice Creation Process The company invoice creation unit 102f creates the company invoice including the customer identification data and the sales amount based on the sales slip table 106d.

Specifically, the company's delivery note creation unit 102f creates a company's delivery note that includes the customer "△△ Bussan" and the sales amount of 28,800 yen from the company to "△△ Bussan" based on the sales slip table 106d shown in FIG. 11 that was generated by the sales slip table generation unit 102d in (4).

(7) Agency Delivery Note Creation Process The agency delivery note creation unit 102g creates the agency delivery notes, each including the agency target combination and the sales amount, for the number of agency target combinations based on the agency sales slip table 106e.

Specifically, the agency delivery note creation unit 102g generates an agency delivery note based on the agency sales slip table 106e (Chiba) shown in FIG. 11 generated by the agency sales slip table generation unit 102e in (5), which includes the agency target combination of customer "△△ Bussan" and delivery destination "Chiba Co., Ltd.", and the delivery destination sales of 12,000 yen from △△ Bussan to "Chiba Co., Ltd."

The agency delivery note creation unit 102g also generates an agency delivery note based on the agency sales slip table 106e (Okinawa) shown in FIG. 11, which was generated by the agency sales slip table generation unit 102e in (5), and which includes the agency target combination of customer "△△ Bussan" and delivery destination "Okinawa Co., Ltd.", and the delivery destination sales of 13,200 yen from △△ Bussan to "Okinawa Co., Ltd.".

In other words, since there are two possible combinations, two delivery notes will also be created.

The company's own delivery note described in (6) and the proxy delivery note described in (7) can be created by instructing on the delivery note creation screen shown in FIG. 7. It is also possible to adjust the layout of the proxy delivery note by changing the layout settings on this screen.

An example of a created proxy delivery note is shown in Figure 8. The created proxy delivery note is attached to the delivered goods, for example, when the goods are delivered from the customer to the delivery destination.

As described above in section [3-1], the delivery note creation device 100 according to this embodiment can create both company delivery notes and proxy delivery notes. This eliminates the need for company staff to manually create proxy delivery notes as was the case in the past, for example, which significantly improves work efficiency and also significantly reduces the risk of mistakes.

[3-2. Creating a sales performance table by product and delivery destination]
In this section, the creation of a product sales performance table by delivery destination will be described with reference to FIG. 12 and FIG.

(1) Sales calculation process by product and delivery destination The sales calculation unit 102h by product and delivery destination calculates the sales amount from the company to the customer for each combination of the customer, the delivery destination, and the product, calculated by the sales to customer calculation unit 102b, by adding up the sales amount from the company to the customer for each combination of the delivery destination and the product.

Specifically, in (2) of [3-1], the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Chiba Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen, in (2) of [3-1], the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Okinawa Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen, and in (2) of [3-1], the sales amount from our company to △△ Bussan for the customer "△△ Bussan", the delivery destination "Kochi Co., Ltd.", and the product A calculated by the customer sales calculation unit 102b is 9,600 yen.

In this case, the sales calculation unit for product by delivery destination 102h calculates the sales amount from the company to △△ Bussan for the delivery destination "Chiba Co., Ltd." and product A as 9,600 yen by aggregating these three sales amounts by delivery destination and product, calculates the sales amount from the company to △△ Bussan for the delivery destination "Okinawa Co., Ltd." and product A as 9,600 yen, and calculates the sales amount from the company to △△ Bussan for the delivery destination "Kochi Co., Ltd." and product A as 9,600 yen.

In a similar manner, the sales calculation unit 102h for each product by delivery destination calculates the sales amount from the company to △△ Bussan for the delivery destination "Chiba Co., Ltd." and product B as 8,800 yen, the sales amount from the company to △△ Bussan for the delivery destination "Chiba Co., Ltd." and product C as 12,000 yen, the sales amount from the company to △△ Bussan for the delivery destination "Okinawa Co., Ltd." and product B as 4,400 yen, the sales amount from the company to △△ Bussan for the delivery destination "Okinawa Co., Ltd." and product C as 6,000 yen, the sales amount from the company to △△ Bussan for the delivery destination "Kochi Co., Ltd." and product B as 4,400 yen, and the sales amount from the company to △△ Bussan for the delivery destination "Kochi Co., Ltd." and product C as 4,000 yen.

The results calculated in the previous two paragraphs are summarized in the "Sales Amount" column in the sales performance table by product and delivery destination in Figure 13. The results shown in this column are, simply put, the sales amount from our company to our customers by delivery destination and product.

The product sales by delivery destination calculation unit 102h calculates the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product by aggregating the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product calculated by the delivery destination sales calculation unit 102c.

Specifically, in (3) of [3-1], the destination sales from △△ Bussan to "Chiba Co., Ltd." for the customer "△△ Bussan," the destination "Chiba Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 12,000 yen, in (3) of [3-1], the destination sales from △△ Bussan to "Okinawa Co., Ltd." for the customer "△△ Bussan," the destination "Okinawa Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 13,200 yen, and in (3) of [3-1], the destination sales from △△ Bussan to "Kochi Co., Ltd." for the customer "△△ Bussan," the destination "Kochi Co., Ltd.", and product A calculated by the destination sales calculation unit 102c is 13,200 yen.

In this case, the sales calculation unit 102h for each product and destination calculates the sales for the three destinations by destination and product, and calculates the sales for the destination "Chiba Co., Ltd." to "Chiba Co., Ltd." for the destination "Chiba Co., Ltd." and product A to "Okinawa Co., Ltd." as 12,000 yen, the sales for the destination "Okinawa Co., Ltd." to "Okinawa Co., Ltd." for the destination "Okinawa Co., Ltd." and product A to 13,200 yen, and the sales for the destination "Kochi Co., Ltd." to "Kochi Co., Ltd." for the destination "Kochi Co., Ltd." and product A to 13,200 yen.

In a similar manner, the sales by product calculation unit 102h calculates the sales by product to "Chiba Co., Ltd." for the destination "Chiba Co., Ltd." and product B from △△ Bussan to "Chiba Co., Ltd." as 10,000 yen, calculates the sales by product to "Chiba Co., Ltd." for the destination "Chiba Co., Ltd." and product C from △△ Bussan to "Chiba Co., Ltd." as 15,000 yen, and calculates the sales by product to "Okinawa Co., Ltd." and product B from △△ Bussan to "Okinawa Co., Ltd." as 15,000 yen. The above is calculated as 5,600 yen, the sales from △△ Bussan to "Okinawa Co., Ltd." for the destination "Okinawa Co., Ltd." and product C are calculated as 8,000 yen, the sales from △△ Bussan to "Kochi Co., Ltd." for the destination "Kochi Co., Ltd." and product B are calculated as 6,000 yen, and the sales from △△ Bussan to "Kochi Co., Ltd." for the destination "Kochi Co., Ltd." and product C are calculated as 5,000 yen.

The results calculated in the previous two paragraphs are summarized in the "Sales to Delivery Destination" column in the sales performance table by product and delivery destination in Figure 13. The results shown in this column are, simply put, the sales amounts from customers to delivery destinations (sales to delivery destination) by delivery destination and by product.

(2) Performance table creation process The performance table creation unit 102i creates a performance table of product sales by delivery destination, which includes the input delivery destination identification data, the input product identification data, the sales amount from the company to the customer for each combination of the delivery destination and the product calculated by the product sales by delivery destination calculation unit 102h, and the sales amount from the customer to the delivery destination for each combination of the delivery destination and the product calculated by the product sales by delivery destination calculation unit 102h.

Specifically, the performance table creation unit 102i creates a performance table of product sales by destination shown in FIG. 13, which includes the delivery destination, the product, the sales volume, the sales amount from the company to the customer by delivery destination and by product calculated in (1) by the product sales by delivery destination calculation unit 102h, and the sales amount from the customer to the delivery destination by delivery destination and by product calculated in (1) by the product sales by delivery destination calculation unit 102h (sales to the delivery destination).

The sales performance table by product by delivery destination can be created by instructing it on the screen for creating the sales performance table by product by delivery destination shown in FIG. 12.

As described above in section [3-2], the delivery note creation device 100 according to this embodiment can create a sales performance table by product and delivery destination that includes not only the sales amount from the company to the customer, but also the sales amount from the customer to the delivery destination (delivery destination sales).

Conventionally, it was only possible to manage the results for each delivery destination using the aggregated value of the company's sales amount (i.e., it was only possible to calculate the information shown in the "Sales amount" column in the table of product sales results by delivery destination in Figure 13). As a result, the data was aggregated based on the company's shipments, and the company's personnel were unable to grasp which delivery destinations purchased the company's products and for how much.

In contrast, in this embodiment, it is now possible to tally up the delivery cost to the delivery destination (i.e., it is now possible to calculate the information shown in the "Delivery destination sales" column in the table of product sales performance by delivery destination in FIG. 13). This allows the company's personnel to know which delivery destination purchases the company's products and for how much. As a result, the company's personnel can plan and propose, for example, campaigns, inventory, OEM (original equipment manufacturing), and direct sales to delivery destinations for products that are frequently purchased by delivery destinations (supermarkets, retail stores, etc.).

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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 a known method.

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

In addition, with regard to the delivery note creation device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the invoice creation device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the invoice creation device 100 as necessary. 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 give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the invoice creation device 100 via any network, and all or part of it may be downloaded as needed.

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

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., 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.

The invoice creation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The invoice creation device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful, for example, in the food industry, wholesale industry, mass retailer industry, machinery industry, steel industry, trading company industry, and construction industry.

100 Delivery note creation device 102 Control unit
102a Unit Price Acquisition Section
102b Customer sales calculation unit
102c Sales to delivery destination calculation unit
102d Sales slip table generation unit
102e Agent sales slip table generating unit
102f In-house delivery note preparation department
102g Delivery Note Creation Department
102h Sales calculation section for each product by delivery destination
102i performance table creation unit 104 communication interface unit 106 storage unit
106a Unit Price Master
106b Alternate Master
106c Sales information table
106d Sales slip table
106e: agent sales slip table 108: input/output interface unit 112: input device 114: output device 200: server 300: network

Claims (4)

A delivery note creation device including a control unit and a storage unit, which is capable of creating an invoice including a sales amount from the company to the customer when the company delivers goods to a delivery destination via a customer, and an agent delivery note including a sales amount from the customer to the delivery destination and created by the company on behalf of the customer,
The storage unit includes:
a unit price master including customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price which is the unit price of the product when the product is sold from the company to the customer, and a delivery destination unit price which is the unit price of the product when the product is sold from the customer to the delivery destination;
an agency master including the customer identification data, the delivery destination identification data, and a classification for identifying whether or not the agency delivery note is to be created, the classification being set for each combination of the customer and the delivery destination;
is stored,
The control unit is
a unit price acquisition means for acquiring, from the unit price master, a customer unit price and a delivery destination unit price associated with the customer identification data, delivery destination identification data, and product identification data inputted on the sales input screen;
a customer sales calculation means for calculating a sales amount from said company to said customer for each combination of said customer, said delivery destination, and said product by multiplying the number of sales of said product from said company to said customer for each combination of said customer, said delivery destination, and said product by the customer unit price acquired by said unit price acquisition means;
a sales calculation means for calculating a sales amount from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by the delivery destination unit price acquired by the unit price acquisition means;
a sales slip table generating means for calculating the sales amount from said company to said customer by aggregating the sales amount calculated by said customer sales calculation means for each customer, and generating a sales slip table including said input customer identification data and said calculated sales amount corresponding to said input customer identification data;
an agency sales slip table generating means for extracting only the sales amounts corresponding to the agency target combinations, which are combinations of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note is to be created is set in the agency master, from the sales amounts calculated by the delivery destination sales calculation means, and generating agency sales slip tables including the agency target combinations and the sales amounts extracted as those corresponding to the agency target combinations, the number of which corresponds to the number of agency target combinations;
a company invoice creation means for creating the company invoice including the customer identification data and the sales amount based on the sales slip table;
an agency invoice creation means for creating agency invoices including the agency target combinations and the sales amounts, the number of which corresponds to the number of agency target combinations, based on the agency sales slip table;
To have
A delivery note creation device comprising: The control unit is
a sales calculation means for calculating a sales amount from the company to the customer for each combination of the delivery destination and the product by aggregating the sales amount from the company to the customer for each combination of the delivery destination and the product calculated by the sales calculation means for the customer, and calculating a sales amount from the company to the customer for each combination of the delivery destination and the product by aggregating the sales amount from the customer to the delivery destination for each combination of the customer, the delivery destination and the product calculated by the sales calculation means for the customer, the delivery destination and the product,
a result table creation means for creating a delivery destination-specific product sales result table including the input delivery destination identification data, the input commodity identification data, the sales amount from the company to the customer for each combination of the delivery destination and the commodity calculated by the delivery destination-specific product sales calculation means, and the sales amount from the customer to the delivery destination for each combination of the delivery destination and the commodity calculated by the delivery destination-specific product sales calculation means;
Further comprising:
2. The delivery note creation device according to claim 1, A delivery note creation method executed by an information processing device having a control unit and a storage unit, which is capable of creating a company delivery note, which is a delivery note including a sales amount from the company to the customer, and an agent delivery note, which is a delivery note including a sales amount from the customer to the delivery destination and is created by the company on behalf of the customer, when a product is delivered from the company to a delivery destination via a customer, comprising:
The storage unit includes:
a unit price master including customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price which is the unit price of the product when the product is sold from the company to the customer, and a delivery destination unit price which is the unit price of the product when the product is sold from the customer to the delivery destination;
an agency master including the customer identification data, the delivery destination identification data, and a classification for identifying whether or not the agency delivery note is to be created, the classification being set for each combination of the customer and the delivery destination;
is stored,
The control unit:
a unit price acquisition step of acquiring, from the unit price master, a customer unit price and a delivery destination unit price associated with the customer identification data, delivery destination identification data, and product identification data inputted on the sales input screen;
a customer sales calculation step of calculating a sales amount from said company to said customer for each combination of said customer, said delivery destination, and said product by multiplying the number of sales of said product from said company to said customer for each combination of said customer, said delivery destination, and said product by the customer unit price acquired in said unit price acquisition step;
a delivery destination sales calculation step of calculating a sales amount from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by the delivery destination unit price acquired in the unit price acquisition step;
a sales slip table generating step of calculating the sales amount from said company to said customer by aggregating the sales amount calculated in said customer sales calculation step for each customer, and generating a sales slip table including said input customer identification data and said calculated sales amount corresponding to said input customer identification data;
an agency sales slip table generating step of extracting only the sales amounts corresponding to the agency target combinations, which are combinations of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note is to be created is set in the agency master, from the sales amounts calculated in the delivery destination sales calculation step, and generating agency sales slip tables including the agency target combinations and the sales amounts extracted as those corresponding to the agency target combinations, the number of which corresponds to the agency target combinations;
a company invoice creation step of creating the company invoice including the customer identification data and the sales amount based on the sales slip table;
an agency invoice creation step of creating agency invoices including the agency target combination and the sales amount for the number of the agency target combinations based on the agency sales slip table;
To carry out
A method for creating a delivery note, comprising: A delivery note creation program to be executed by an information processing device having a control unit and a storage unit, which is capable of creating a company delivery note, which is a delivery note including a sales amount from the company to the customer, and an agent delivery note, which is a delivery note including a sales amount from the customer to the delivery destination and created by the company on behalf of the customer, when a product is delivered from the company to a delivery destination via a customer,
The storage unit includes:
a unit price master including customer identification data for identifying the customer, delivery destination identification data for identifying the delivery destination, product identification data for identifying the product, a customer unit price which is the unit price of the product when the product is sold from the company to the customer, and a delivery destination unit price which is the unit price of the product when the product is sold from the customer to the delivery destination;
an agency master including the customer identification data, the delivery destination identification data, and a classification for identifying whether or not the agency delivery note is to be created, the classification being set for each combination of the customer and the delivery destination;
is stored,
To cause the control unit to execute
a unit price acquisition step of acquiring, from the unit price master, a customer unit price and a delivery destination unit price associated with the customer identification data, delivery destination identification data, and product identification data inputted on the sales input screen;
a customer sales calculation step of calculating a sales amount from said company to said customer for each combination of said customer, said delivery destination, and said product by multiplying the number of sales of said product from said company to said customer for each combination of said customer, said delivery destination, and said product by the customer unit price acquired in said unit price acquisition step;
a delivery destination sales calculation step of calculating a sales amount from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by multiplying the number of sales of the product from the customer to the delivery destination for each combination of the customer, the delivery destination, and the product by the delivery destination unit price acquired in the unit price acquisition step;
a sales slip table generating step of calculating the sales amount from said company to said customer by aggregating the sales amount calculated in said customer sales calculation step for each customer, and generating a sales slip table including said input customer identification data and said calculated sales amount corresponding to said input customer identification data;
an agency sales slip table generating step of extracting only the sales amounts corresponding to the agency target combinations, which are combinations of the customer identification data and the delivery destination identification data for which a classification indicating that the agency delivery note will be created is set in the agency master, from the sales amounts calculated in the delivery destination sales calculation step, and generating agency sales slip tables including the agency target combinations and the sales amounts extracted as those corresponding to the agency target combinations, the number of which corresponds to the agency target combinations;
a company invoice creation step of creating the company invoice including the customer identification data and the sales amount based on the sales slip table;
an agency invoice creation step of creating agency invoices including the agency target combination and the sales amount for the number of the agency target combinations based on the agency sales slip table;
containing,
A delivery note creation program characterized by the above.

Images