DEPOSIT CALCULATION DEVICE, DEPOSIT CALCULATION METHOD, AND DEPOSIT CALCULATION PROGRAM

Abstract

To provide a deposit calculation apparatus configured to prevent failing to calculate a deposit for a container by automatically calculating the deposit when recording sales of a commodity, a deposit calculation method, and a deposit calculation program.SOLUTION: A deposit for a container is calculated by (1) acquiring a commodity code input at shipping instruction, a container code associated with the quantity of commodities, and the number of containers from inventory information including the commodity code, the quantity of commodities, the container code, and the number of containers, (2) acquiring a container unit price associated with the acquired container code from a unit price master including container codes and container unit prices and multiplying the acquired number of containers by the acquired container unit price when the sales of the commodity is recorded.SELECTED DRAWING: Figure 9

Description

[Technical field]

[0001] The present invention relates to a security money calculation device, a security money calculation method, and a security money calculation program. [Background technology]

[0002] Patent Document 1 discloses a management system that enables the efficient distribution of seafood and other produce using returnable containers provided by container rental companies, and also introduces a deposit system, thereby improving the recovery rate of returnable containers (see paragraph 0025 of Patent Document 1, etc.). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2006-160511 A Summary of the Invention [Problem to be solved by the invention]

[0004] In this way, in fields where product containers are collected from customers and reused, the value of the containers is often recorded as a deposit when recording product sales, and is collected from the customer. When the containers are returned safely by the customer, the deposit is returned in a common operation.

[0005] However, in order to record the container deposit, it is necessary to keep track of how much deposit is generated for each sale of each product, which makes management cumbersome and leads to the failure to record deposits.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a deposit calculation device, a deposit calculation method, and a deposit calculation program that can prevent the deposit from being overlooked by automatically calculating the deposit for a container when product sales are recorded. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the deposit calculation device of the present invention is provided with a control unit and a memory unit, which calculates a deposit for a collectable container that holds a product, which is initially recorded as sales when the product is sold, and which is returned to the customer when the container is collected from the customer. The memory unit stores inventory information including product identification data for identifying the product, product quantity, which is the quantity of the product, container identification data for identifying the container, and container quantity, which is the quantity of the containers, and a unit price master including the container identification data and the container unit price, which is the sales price of the container. The control unit is provided with a container information acquisition means that executes a process of acquiring, from the inventory information, container identification data and container quantity linked to the product identification data and product quantity input at the time of shipping instruction, and a deposit calculation means that, when sales of the product are recorded, acquires from the unit price master the container unit price linked to the container identification data acquired by the container information acquisition means, and further calculates the deposit by multiplying the container quantity acquired by the container information acquisition means by the acquired container unit price.

[0008] In addition, in the deposit calculation device of the present invention, the memory unit further stores a customer master including customer identification data for identifying a customer and a deposit classification which is a classification for identifying whether or not a deposit is generated, and a product master including the product identification data and the deposit classification, and the control unit further includes a deposit classification acquisition means for acquiring from the customer master the deposit classification linked to the customer identification data entered at the time of order input, and on the other hand, acquiring from the product master the deposit classification linked to the product identification data entered at the time of order input, and the container information acquisition means executes the processing only if both of the deposit classifications acquired by the deposit classification acquisition means are classifications indicating that the deposit will be generated.

[0009] In addition, in the security deposit calculation device of the present invention, the control unit is further characterized by having a payment request data generation means for generating payment request data, which is data for paying the security deposit to the customer, when collection of the container from the customer is completed.

[0010] In addition, the deposit calculation method of the present invention is a deposit calculation method executed by an information processing device equipped with a control unit and a memory unit, which calculates a deposit, which is an amount that is temporarily recorded as sales for a collectable container that holds a product when the product is sold and is returned to the customer when the container is collected from the customer, wherein the memory unit stores inventory information including product identification data for identifying the product, product quantity which is the quantity of the product, container identification data for identifying the container, and container quantity which is the quantity of the containers, and a unit price master including the container identification data and the container unit price which is the sales price of the containers, and the method includes a container information acquisition step executed by the control unit to execute a process to acquire from the inventory information the container identification data and container quantity linked to the product identification data and product quantity input at the time of shipping instruction, and a deposit calculation step to acquire, when the product is recorded as sales, the container unit price linked to the container identification data acquired in the container information acquisition step from the unit price master, and further calculate the deposit by multiplying the container quantity acquired in the container information acquisition step by the acquired container unit price.

[0011] In addition, the deposit calculation program of the present invention is a deposit calculation program to be executed by an information processing device having a control unit and a memory unit, which calculates a deposit for a collectable container that holds a product, which is initially recorded as sales when the product is sold and is returned to the customer when the container is collected from the customer, wherein the memory unit stores inventory information including product identification data for identifying the product, product quantity which is the quantity of the product, container identification data for identifying the container, and container quantity which is the quantity of the containers, and a unit price master including the container identification data and the container unit price which is the sales price of the containers, and is characterized in that the program includes a container information acquisition step to be executed by the control unit, which executes a process to acquire container identification data and container quantity linked to the product identification data and product quantity input at the time of shipping instruction from the inventory information, and a deposit calculation step to acquire the container unit price linked to the container identification data acquired in the container information acquisition step from the unit price master when the product is sold, and further calculates the deposit by multiplying the container quantity acquired in the container information acquisition step by the acquired container unit price. Effect of the Invention

[0012] According to the present invention, by automatically calculating the container deposit when recording the product sales, it is possible to prevent the deposit from being overlooked. [Brief description of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a security money calculation device. [Diagram 2] FIG. 2 is a diagram showing an example of items of each master. [Diagram 3] FIG. 3 is a diagram illustrating an example of inventory information. [Figure 4] FIG. 4 is a diagram showing an example of an order entry screen and master data related to order entry (when a deposit is required). [Diagram 5] FIG. 5 is a diagram showing an example of an order entry screen and master data related to order entry (when no deposit is required). [Figure 6] FIG. 6 is a diagram illustrating an example of the generated order data. [Figure 7] FIG. 7 is a diagram showing an example of the shipping instruction input screen and the generated shipping instruction data. [Figure 8] FIG. 8 is a diagram showing an example of the shipping record input screen and the generated shipping data, etc. [Figure 9] FIG. 9 is a diagram showing an example of a sales input screen and a unit price master. [Figure 10] FIG. 10 is a diagram showing an example of the generated sales data and collection schedule data. [Figure 11] FIG. 11 is a diagram showing an example of a deposit input screen and generated deposit data, etc. [Figure 12] FIG. 12 is a diagram showing an example of the payment request input screen and the generated payment request data. [Figure 13] FIG. 13 is a diagram showing an example of the actual payment input screen and the actual payment data to be generated. [Figure 14] FIG. 14 is a diagram showing an example of a table summarizing the generated journal entries. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] Hereinafter, an embodiment of a security money calculation device, a security money calculation method, and a security money calculation 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 embodiment. Specific configurations and operations will be described below.

[0015] [1. Configuration] An example of the configuration of a security money calculation 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 a security money calculation device 100.

[0016] The security money calculation device 100 is a commercially available desktop personal computer. Note that the security money calculation 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, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0017] The security money calculation device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the security money calculation device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0018] The communication interface unit 104 communicatively connects the security money calculation 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 security money calculation 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.

[0019] 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 cooperates with a mouse to realize 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.

[0020] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0021] The memory unit 106 includes, for example, a customer master 106a, a product master 106b, a unit price master 106c, inventory information 106d, order data 106e, shipping instruction data 106f, shipping data 106g, sales data 106h, collection schedule data 106i, deposit data 106j, payment request data 106k, and actual payment data 106m.

[0022] In this embodiment, the deposit is an amount that is temporarily recorded as a sales amount for a returnable container that contains a product when the product is sold, and is returned to the customer when the container is returned from the customer. The container may be any returnable container, such as a bottle, a vial, a reel (bobbin, etc.), or a logistics pallet.

[0023] 2, 4, and 5, the customer master 106a includes, for example, customer identification data (customer code) for identifying a customer, and a security deposit classification for identifying whether or not a security deposit is required. The security deposit classification in the customer master 106a is classification (1) indicating that a security deposit is required for the customer, or classification (0) indicating that a security deposit is not required for the customer.

[0024] 2, 4, and 5, the product master 106b includes, for example, product identification data (product code) for identifying the product and the deposit category. The deposit category in the product master 106b is category (1) indicating that the deposit is required for the product, or category (0) indicating that the deposit is not required for the product.

[0025] Details will be described in [2. Specific example of processing] below, but if the customer master 106a and the product master 106b both have the security deposit category set to "1" for the combination of customer identification data and product identification data entered on the order entry screen, then the security deposit will be generated for that combination. In this way, by referencing the customer master 106a and the product master 106b, it is possible to automatically determine at the time of order entry whether the customer and product entered in the order are subject to the security deposit.

[0026] As shown in FIG. 2, FIG. 9, etc., the unit price master 106c includes, for example, container identification data (product code) for identifying the container, and a container unit price (unit price) which is the unit sales price of the container.

[0027] The inventory information 106d is data for storing the type and number of containers used for the product, for example, on a lot basis, when the product is manufactured. As shown in Figures 3, 7, and 8, the inventory information 106d includes the product identification data (product code (product)), the product quantity (quantity (product)) which is the quantity of the product, the lot identification data (lot number), the container identification data (product code (container)), and the container quantity (quantity (container)) which is the quantity of the containers.

[0028] The contents of the order data 106e, shipping instruction data 106f, shipping data 106g, sales data 106h, collection schedule data 106i, deposit data 106j, payment request data 106k and actual payment data 106m will be described in [2. Specific examples of processing] below.

[0029] The control unit 102 is a CPU or the like that comprehensively controls the security deposit calculation 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 based on these stored programs.

[0030] In terms of functional concept, the control unit 102 includes, for example, (1) a deposit category acquisition unit 102a as a deposit category acquisition means that acquires from the customer master a deposit category linked to the customer identification data entered at the time of order input, and acquires from the product master a deposit category linked to the product identification data entered at the time of order input; (2) a container information acquisition unit 102b as a container information acquisition means that executes a process of acquiring from the inventory information container identification data and container quantity linked to the product identification data and product quantity entered at the time of shipping instructions; (3) a deposit calculation unit 102c as a deposit calculation means that acquires from the unit price master a container unit price linked to the container identification data acquired by the container information acquisition means when sales of the product are recorded, and further calculates the deposit by multiplying the container quantity acquired by the container information acquisition means by the acquired container unit price; and (4) a payment request data generation unit 102d as a payment request data generation means that generates payment request data, which is data for payment of the deposit to the customer, when collection of the containers from the customer is completed.

[0031] The deposit category acquisition unit 102a acquires the deposit category linked to the customer identification data input at the time of order entry from the customer master 106a including the customer identification data and the deposit category. The deposit category acquisition unit 102a also acquires the deposit category linked to the product identification data input at the time of order entry from the product master 106b including the product identification data and the deposit category.

[0032] The container information acquisition unit 102b executes a process of acquiring the container identification data and the container quantity linked to the product identification data and the product quantity input at the time of the shipping instruction from the inventory information 106d including the product identification data, the product quantity, the container identification data, and the container quantity. Note that the container information acquisition unit 102b may execute the process only when both of the two deposit categories acquired by the deposit category acquisition unit 102a are category (1) indicating that the deposit is generated.

[0033] When the sales of the product are recorded, the deposit calculation unit 102c obtains the container unit price linked to the container identification data obtained by the container information acquisition unit 102b from the unit price master 106c, which includes the container identification data and the sales unit price, and further calculates the deposit by multiplying the container quantity obtained by the container information acquisition unit 102b by the obtained container unit price.

[0034] When collection of the container from the customer is completed, the payment request data generating unit 102d generates payment request data 106k which is data for payment of the deposit to the customer.

[0035] [2. Specific examples of processing] In this section, a specific example of the processing according to this embodiment will be described.

[0036] [2-1. When entering an order] When an order is entered, the deposit category in the customer master 106a and the product master 106b is referenced, and if the deposit category in both masters is "1", then the deposit category on the order entry screen is set to "1". "1" means that a deposit is required. If the deposit category in the order information becomes 1 upon order entry, it will be determined in subsequent processing that a deposit is required. Below, we will explain the cases when a deposit is required and when it is not.

[0037] (1) If a security deposit is required First, let us consider the case where a deposit is required. As shown in the order entry screen in Figure 4, assume that the customer code "TK00001", the product code "A70100000BZ", the quantity "150 kg", and the unit price "4,470 yen" are entered.

[0038] In this case, the deposit category acquisition unit 102a acquires the deposit category "1" linked to the input customer code "TK00001" from the customer master 106a in Fig. 4. The deposit category acquisition unit 102a also acquires the deposit category "1" linked to the input product code "A70100000BZ" from the product master 106b in Fig. 4.

[0039] In this way, when the deposit classification obtained from both masters is "1", the deposit classification obtaining unit 102a sets "1" as the deposit classification on the order input screen of FIG.

[0040] (2) Cases where a security deposit is not required Next, we will explain the case where no deposit is required. As shown in the order entry screen of Figure 5, assume that the customer code "TK00001", the product code "A70200000BZ", the quantity "120 kg", and the unit price "4,850 yen" are entered.

[0041] In this case, the deposit category acquisition unit 102a acquires the deposit category "1" associated with the input customer code "TK00001" from the customer master 106a in Fig. 5. The deposit category acquisition unit 102a also acquires the deposit category "0" associated with the input product code "A70200000BZ" from the product master 106b in Fig. 5.

[0042] In this way, when at least one of the deposit classifications obtained from both masters is "0", the deposit classification obtaining unit 102a sets "0" as the deposit classification on the order input screen of FIG.

[0043] (3)Generating order data Then, based on the information entered in (1) and (2), order data 106e shown in Fig. 6 is generated. In order data 106e shown in Fig. 6, the order details in the first line (details for order number JUC0000001) are order details for a case where a deposit generated by the order input in (1) is required, whereas the order details in the second line (details for order number JUC0000002) are order details for a case where a deposit generated by the order input in (2) is not required.

[0044] [2-2. When shipping instructions are given] Next, based on the order details in the first line of the generated order data 106e, which state that a deposit is required, shipping instructions are input as shown in FIG.

[0045] Here, when the deposit category input in the shipping instruction is "1" as shown in FIG. 7, the container information acquisition unit 102b acquires the container code "TA" and the container quantity "2 units" from the inventory information 106d in FIG. 7 as information linked to the product code "A70100000BZ" and product quantity "150 kg" input in the shipping instruction. In this way, the inventory information 106d holds information such as which containers and how many to use for the product, and by allocating the inventory, it is possible to acquire information on the containers to be used for the corresponding order. Note that in this example, an example of acquiring container information using the product code and product quantity as keys has been described, but since the inventory information 106d also holds lot numbers, container information may be acquired using the lot number as a key.

[0046] Then, based on the input shipping instruction information and the acquired container information, shipping instruction data 106f shown in FIG. 7 is generated.

[0047] [2-3. When entering shipping results] Subsequently, when the shipment is completed, the shipping results are input as shown in FIG. 8 based on the generated shipping instruction data 106f.

[0048] Then, based on the information entered regarding the shipping record, shipping data 106g shown in FIG. 8 is generated.

[0049] [2-4. When entering sales] Next, when the sales are recorded, the sales are input based on the generated shipping data 106g as shown in Fig. 9. The unit price "72,500 yen" on the sales input screen is obtained by the security deposit calculation unit 102c described in the next paragraph.

[0050] The deposit calculation unit 102c obtains the container unit price "72,500 yen" linked to the container code "TA" obtained by the container information obtaining unit 102b from the unit price master 106c in FIG. 9, and sets it in the sales input screen in FIG.

[0051] Here, since the deposit category in the shipping data 106g in FIG. 9 is "1", a sales statement of the deposit is automatically generated based on the container information. In this case, if the sales category in the sales input screen is "regular sales", a sales statement of the product is generated, whereas if the sales category in the sales input screen is "container deposit", a sales statement of the deposit is generated. Specifically, based on the information from the customer on the first line to the deposit category on the sixth line in the sales input screen, a sales statement of the product shown in the first line of the sales data 106h in FIG. 10 is generated, and based on the information from the customer on the eighth line to the deposit category on the last line in the sales input screen, a sales statement of the deposit shown in the second line of the sales data 106h in FIG. 10 is generated.

[0052] Subsequently, at the same time as recording the sales, the collection schedule data 106i in Fig. 10 is generated. The collection schedule details shown in the first line of the collection schedule data 106i in Fig. 10 are details generated based on the sales details of the products shown in the first line of the sales data 106h in Fig. 10, and the sales amount of the products, 670,500 yen, is calculated by calculating the product quantity 150 kg x product unit price 4,470 yen. The collection schedule details shown in the second line of the collection schedule data 106i in Fig. 10 are details generated based on the sales details of the deposit shown in the second line of the sales data 106h in Fig. 10, and the deposit amount 145,000 yen is calculated by the deposit calculation unit 102c by calculating the container quantity 2 x container unit price 72,500 yen.

[0053] In this manner, in this embodiment, the deposit can be automatically recorded as sales at the same time as the product sales are recorded. Also, in this embodiment, the deposit amount of 145,000 yen in the collection schedule data 106i is regarded as the container inventory, so that it is possible to grasp the inventory of containers lent out worth 145,000 yen.

[0054] Then, based on the sales data 106h in Fig. 10, the sales journal entry shown in the journal entry generation procedure "A" in Fig. 14 is generated. Depending on the sales category, it is determined whether to record the sales as merchandise sales or as a deposit.

[0055] [2-5. When entering deposit] Subsequently, when the payment is actually received from the business partner, the payment is input as shown in Fig. 11. Upon input of the payment, payment data 106j is generated as shown in Fig. 11.

[0056] Then, based on the deposit data 106j in Fig. 11, a deposit journal entry is generated as shown in the journal entry generation procedure "B" in Fig. 14. In a deposit journal entry, the debit account is determined by the deposit method, and at the deposit stage, the credit account is a suspense receipt.

[0057] When inputting a deposit, if a clearing receivable is selected in the collection schedule data 106i, the target receivable (scheduled collection) is cleared at the same time. In the collection schedule data 106i in Fig. 11, clearing is performed for both the product collection schedule and the deposit collection schedule, so that the unsettled amounts are both 0 yen.

[0058] Then, based on the collection schedule data 106i in FIG. 11 for which the reconciliation has been completed, a reconciliation journal entry for the accounts receivable and the guarantee is generated as shown in FIG. 14 by the journal entry generation procedure "C."

[0059] Through the above process, both the product price and the container deposit will be paid by the supplier. When the container is returned by the supplier, the following process will return the container deposit to the supplier.

[0060] [2-6. When entering a payment request] Subsequently, when the container is returned from the business partner, a request for payment of the deposit for the returned container is input, as shown in Fig. 12. In response to the input of the payment request, the payment request data generating unit 102d generates payment request data 106k for the returned container, as shown in Fig. 12.

[0061] Then, based on the payment request data 106k in Fig. 12, a reconciliation journal entry is generated as shown in the journal entry generation procedure "D" in Fig. 14. The reconciliation journal entry (journal entry for unpaid deposit) can be generated by specifying "container deposit", which is the payment category when paying the container deposit, on the payment request input screen in Fig. 12.

[0062] [2-7. When entering payment results] Finally, when the payment of the deposit for the returned container to the supplier is completed, the actual payment is input as shown in Fig. 13. By inputting the actual payment, actual payment data 106m is generated as shown in Fig. 13.

[0063] Then, based on the actual payment data 106m in FIG. 13, a reconciliation journal entry shown in the journal entry generation procedure "E" in FIG. 14 is generated.

[0064] [3. Summary of this embodiment] In this way, according to the deposit calculation device 100 of this embodiment, as explained in [2-4], the deposit for the container is automatically calculated and recorded as sales when the sales of the product are recorded, so that it is possible to prevent the deposit from being overlooked. Also, according to the deposit calculation device 100 of this embodiment, as explained in [2-4], the deposit amount in the collection schedule data 106i is regarded as the inventory amount of the container, so that it is possible to grasp the amount of the container lent.

[0065] Here, some of the containers used to store the products (pallets, reels, bottles, etc.) are expensive, and it is difficult to add these to the product price, so they are collected and reused. In order to increase the collection rate, a deposit is often placed on the containers, and the deposit is returned when the containers are collected.

[0066] However, with this type of operation, problems arose such as failure to record deposits, and the complicated management of where the containers were shipped, how many were shipped, how many were returned, and how many containers remained to be collected, resulting in a low collection rate.

[0067] Therefore, in this embodiment, for example, the following functions are implemented. ●The number of containers used when packaging a product can be entered, managed as inventory information, and automatically calculated based on theoretical values. ●When a product is sold, the container information at the time of packaging is referenced and recorded on the sales details, and container inventory is automatically recorded at the shipping warehouse. When containers are collected, the container inventory can be moved from the shipping warehouse to which the containers are collected to our own warehouse. ●The container information listed in the sales details can be recorded as a guarantee account by setting the guarantee unit price in the sales price master. ●The product price and the security deposit are charged together, and the security deposit amount can be transferred to the deposit at the time of payment. ●It is now possible to calculate the return amount of the received security deposit based on data on how many were collected from where in the container collection information and the security deposit unit price in the sales price master. By treating the remaining deposit balance as inventory, the inventory status of containers can be visualized and unnecessary container arrangements can be prevented, enabling the efficient use of company assets.

[0068] In this way, in this embodiment, container information is managed as inventory information, and sales details are automatically generated when products are sold, eliminating the oversight of deposit requests (accounting). Also, in this embodiment, container inventory is automatically accounted for in the shipping warehouse, and inventory is transferred when collection is reported, making it possible to manage container inventory.

[0069] To sum up, in this embodiment, in order to meet the demand to make accounting entries for the deposit at the same time as the sales are recorded, the deposit can be recorded as sales at the same time by setting the master data at the same time as the sales of the product are recorded. Also, in this embodiment, in order to be able to manage the inventory of returnable containers, the movement data of the container inventory is created at the same time as the sales of the deposit are recorded, and the containers can be made into inventory in the customer's warehouse.

[0070] [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 goals 8 and 9 of the SDGs.

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

[0072] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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

[0075] In addition, 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 may be changed as desired unless otherwise specified.

[0076] Furthermore, with regard to the security money calculation device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0077] For example, the processing functions of the security money calculation 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 an information processing device to execute the processes described in this embodiment, and is mechanically read by the security money calculation 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.

[0078] In addition, this computer program may be stored in an application program server connected to the security money calculation device 100 via any network, and it is also possible to download all or part of it as necessary.

[0079] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.

[0080] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, 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 as multiple modules or libraries, and a program that works 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, may use well-known configurations and procedures.

[0081] The various databases etc. stored in the memory unit 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 etc. used for various processes and providing websites.

[0082] The security money calculation 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 security money calculation device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0083] 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 functionally or physically distributed and integrated in any unit according to 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. [Industrial Applicability]

[0084] The present invention is useful, for example, in industries that handle returnable containers, typically in the chemical industry and food industry. [Explanation of symbols]

[0085] 100 Deposit calculation device 102 Control section 102a Deposit Division Acquisition Section 102b Container information acquisition unit 102c Deposit Calculation Department 102d Payment request data generation unit 104 Communication interface section 106 Storage section 106a Customer Master 106b Product master 106c Unit Price Master 106d Stock Information 106e Order Data 106f Shipping Instruction Data 106g Shipping Data 106h Sales Data 106i Scheduled collection data 106j Deposit data 106k payment request data 106m Payment history data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A deposit calculation device including a control unit and a storage unit, the deposit being an amount to be temporarily recorded as sales for a collectable container that contains a product when the product is sold and to be returned to the customer when the container is collected from the customer, the deposit calculation device comprising: The storage unit includes: inventory information including product identification data for identifying the product, a product quantity that is a quantity of the product, container identification data for identifying the container, and a container quantity that is a quantity of the container; A unit price master including the container identification data and a container unit price which is a sales unit price of the container; A customer master including customer identification data for identifying a customer and a security deposit classification for identifying whether or not a security deposit has been generated; A product master including the product identification data and the deposit classification; is stored, The control unit is a container information acquiring means for acquiring, from the inventory information, container identification data and container quantity associated with the product identification data and product quantity input at the time of shipping instruction; a guarantee calculation means for obtaining, from the unit price master when recording the sales of the product, a container unit price associated with the container identification data obtained by the container information obtaining means, and further calculating the guarantee by multiplying the container quantity obtained by the container information obtaining means by the obtained container unit price; a deposit classification acquisition means for acquiring, from the customer master, a deposit classification associated with the customer identification data input at the time of order input, and acquiring, from the product master, a deposit classification associated with the product identification data input at the time of order input; Equipped with the container information acquisition means executes the process only when both of the two deposit categories acquired by the deposit category acquisition means are categories indicating that a deposit is required; A security deposit calculation device comprising:

2. The control unit is a payment request data generating means for generating, when collection of the container from the customer is completed, payment request data which is data for payment of the deposit to the customer; Further comprising:

2. The security money calculation device according to claim 1 .

3. A method for calculating a deposit, which is executed by an information processing device having a control unit and a storage unit, for calculating a deposit for a collectable container that contains a product, the deposit being an amount that is temporarily recorded as sales when the product is sold and is returned to a customer when the container is collected from the customer, the method comprising: The storage unit includes: inventory information including product identification data for identifying the product, a product quantity that is a quantity of the product, container identification data for identifying the container, and a container quantity that is a quantity of the container; A unit price master including the container identification data and a container unit price which is a sales unit price of the container; A customer master including customer identification data for identifying a customer and a security deposit classification for identifying whether or not a security deposit has been generated; A product master including the product identification data and the deposit classification; is stored, Executed by the control unit, a container information acquisition step of acquiring, from the inventory information, container identification data and container quantity associated with the product identification data and product quantity input at the time of shipping instruction; a guarantee calculation step of acquiring, from the unit price master, a container unit price associated with the container identification data acquired in the container information acquisition step when recording the sales of the product, and calculating the guarantee by multiplying the container quantity acquired in the container information acquisition step by the acquired container unit price; a deposit classification acquisition step of acquiring, from the customer master, a deposit classification associated with the customer identification data input at the time of order input, and acquiring, from the product master, a deposit classification associated with the product identification data input at the time of order input; Including, the container information acquisition step executes the process only when both of the two deposit categories acquired in the deposit category acquisition step are categories indicating that a deposit is required; A method for calculating a security deposit, comprising:

4. A deposit calculation program to be executed by an information processing device having a control unit and a storage unit, the program calculating a deposit for a collectable container that contains a product, the deposit being an amount that is temporarily recorded as sales when the product is sold and is returned to the customer when the container is collected from the customer, the program comprising: The storage unit includes: inventory information including product identification data for identifying the product, a product quantity that is a quantity of the product, container identification data for identifying the container, and a container quantity that is a quantity of the container; A unit price master including the container identification data and a container unit price which is a sales unit price of the container; A customer master including customer identification data for identifying a customer and a security deposit classification for identifying whether or not a security deposit has been generated; A product master including the product identification data and the deposit classification; is stored, To cause the control unit to execute a container information acquisition step of acquiring, from the inventory information, container identification data and container quantity associated with the product identification data and product quantity input at the time of shipping instruction; a guarantee calculation step of acquiring, from the unit price master, a container unit price associated with the container identification data acquired in the container information acquisition step when recording the sales of the product, and calculating the guarantee by multiplying the container quantity acquired in the container information acquisition step by the acquired container unit price; a deposit classification acquisition step of acquiring, from the customer master, a deposit classification associated with the customer identification data input at the time of order input, and acquiring, from the product master, a deposit classification associated with the product identification data input at the time of order input; Including, the container information acquisition step executes the process only when both of the two deposit categories acquired in the deposit category acquisition step are categories indicating that a deposit is required; A deposit calculation program characterized by:

Images