JP7565722B2 - Paid supply transaction management device, paid supply transaction management method, and paid supply transaction management program - Google Patents

Description

The present invention relates to a paid payment transaction management device, a paid payment transaction management method, and a paid payment transaction management program.

For example, there are transactions in which materials or semi-finished products are supplied to subcontractors for a fee and then repurchased after processing. This type of transaction is called a paid supply transaction. It is mainly seen in the automobile industry.
An example of a system for carrying out such paid payment transactions is disclosed in Japanese Patent Laid-Open No. 2003-233663.

JP 2002-288493 A

However, Patent Document 1 does not state anything about reducing the workload of personnel in paid supply transactions by linking the voucher at the time of supply with the voucher at the time of repurchase, thereby performing accurate and automatic offsetting processing.

The present invention has been made in consideration of the above, and aims to provide a paid payment transaction management device, a paid payment transaction management method, and a paid payment transaction management program that can reduce the workload of personnel in paid payment transactions by linking the voucher at the time of payment with the voucher at the time of repurchase, thereby performing accurate and automatic offset processing.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a paid supply transaction management device equipped with a control unit, the control unit comprising: paid supply data input means for inputting paid supply data including a supply date, paid supply number, item, supply quantity, supply unit price, supply amount, and current inventory quantity when materials are supplied; processing and payment data input means for inputting processed and payment data including a processing number, item, and payment quantity when processed products are repurchased; and paid supply settlement data input means for inputting paid supply settlement data including a paid supply number, processing number, item, settlement quantity, and settlement paid supply main amount calculated by the settlement quantity x supply unit price. The system is characterized by comprising a payment reconciliation data processing means, a scheduled collection data processing means for inputting scheduled collection data including the scheduled collection date, paid payment number, scheduled collection amount, quantity, unit price, and reconciled payment amount, a scheduled payment data processing means for inputting scheduled payment data including the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and reconciled payment amount, and an offsetting means for offsetting the scheduled collection amount of the scheduled collection data and the scheduled payment amount of the payment schedule data using the paid payment number and processing number as keys, respectively, for the reconciled paid payment main amount of the paid payment reconciliation data.

According to one aspect of the present invention, the paid payment reconciliation data processing means may reconcile the paid payment data with the paid payment reconciliation data on a first-in, first-out basis.

According to one aspect of the present invention, the paid payment reconciliation data processing means may update the current inventory of the paid payment data by subtracting the reconciliation quantity from the current inventory.

According to one aspect of the present invention, the offsetting means may offset the planned collection amount in the planned collection data with the reconciled paid payment amount in the paid payment reconciliation data based on a specified offsetting reference date, update the reconciled payment amount in the planned collection data, and update the reconciled payment amount in the planned payment data.

In order to solve the above-mentioned problems and achieve the object, the present invention provides a paid supply transaction management method executed by an information processing device equipped with a control unit, which includes a paid supply data input process executed by the control unit for inputting paid supply data including a supply date, paid supply number, item, supply quantity, supply unit price, supply amount, and current inventory quantity when materials are supplied, a processing data input process for inputting processed payment data including a processing number, item, and payment quantity when processed products are repurchased, and a paid supply settlement data input process for inputting paid supply data including a paid supply number, processing number, item, settlement quantity, and a settlement paid supply main amount calculated by the settlement quantity x supply unit price. The system is characterized by comprising: a paid payment reconciliation data processing step for inputting data on scheduled collection, a scheduled collection data processing step for inputting scheduled collection data including the scheduled collection date, paid payment number, scheduled collection amount, quantity, unit price, and reconciled payment amount; a scheduled payment data processing step for inputting scheduled payment data including the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and reconciled payment amount; and an offsetting step for offsetting the scheduled collection amount of the scheduled collection data and the scheduled payment amount of the payment scheduled data using the paid payment number and processing number as keys, respectively, for the reconciled paid payment amount of the paid payment reconciliation data.

According to one aspect of the present invention, there is provided a paid supply transaction program to be executed by an information processing device having a control unit, the control unit including a paid supply data input process for inputting paid supply data including a supply date, paid supply number, item, supply quantity, supply unit price, supply amount, and current inventory quantity when materials are supplied, a processing data input process for inputting processed payment data including a processing number, item, and payment quantity when processed products are repurchased, and a paid supply reconciliation data processing process for inputting paid supply reconciliation data including a paid supply number, processing number, item, reconciliation quantity, and reconciliation paid supply main amount calculated by reconciliation quantity x supply unit price. a payment schedule data processing step of inputting payment schedule data including the scheduled payment date, the payment schedule number, the scheduled payment amount, the quantity, the unit price, and the already-reconciled payment amount; a payment schedule data processing step of inputting payment schedule data including the scheduled payment date, the processing number, the scheduled payment amount, the quantity, the unit price, and the already-reconciled payment amount; and an offsetting step of offsetting the scheduled payment amount of the payment schedule data with the scheduled payment amount of the payment schedule data, using the payment schedule number and the processing number as keys, respectively, for the paid payment main amount of the paid payment offset data.

According to the present invention, in a paid supply transaction, by linking the voucher at the time of supply with the voucher at the time of repurchase, it is possible to realize accurate values and automatic offsetting.

FIG. 1 is a block diagram showing an example of the configuration of a paid supply transaction management device according to the present embodiment. FIG. 2 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the paid supply transaction management device in this embodiment. FIG. 3 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the paid supply transaction management device in this embodiment. FIG. 4 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the paid supply transaction management device in this embodiment. FIG. 5 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the paid supply transaction management device in this embodiment. FIG. 6 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the paid supply transaction management device in this embodiment.

Below, an embodiment of the paid payment transaction management device, paid payment transaction management method, and paid payment transaction management 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]
For example, there are transactions in which materials or semi-finished products are supplied to subcontractors for a fee and then repurchased after processing. This type of transaction is called a paid supply transaction. It is mainly seen in the automobile industry.
However, when offsetting such paid supply transactions, the person in charge had to match the unpaid amount (accounts receivable) with the accounts payable at the time of repurchase, confirm the supplied materials consumed each time, and manage the invoices separately to offset the amounts, which placed a large workload on the person in charge.

In this embodiment, therefore, in paid supply transactions, the voucher at the time of supply is linked to the voucher at the time of repurchase, and accurate values are used to automatically perform offsetting processing, reducing the workload of the person in charge. In this embodiment, automatic determination is performed on a first-in, first-out basis, which improves the validity of consumed supply materials and vouchers.

2. Configuration
The configuration of the paid supply transaction management device 100 according to this embodiment will be described with reference to Fig. 2. Fig. 2 is a block diagram showing an example of the configuration of the paid supply transaction management device 100 according to this embodiment. The paid supply transaction management device 100 according to this embodiment can be suitably used in companies that conduct paid supply transactions, such as in the automobile industry.

The paid payment transaction management device 100 is a commercially available desktop personal computer. The paid payment transaction management 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.

As shown in FIG. 3, the paid supply transaction management 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 paid supply transaction management device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the paid supply transaction management 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 paid supply transaction management 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). The data stored in the memory unit 106, which will be described later, may be stored in the server.

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 achieve 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. In addition, the act of a user displaying on the screen of the output device (monitor) 114 and operating the input device 112 may be referred to as "user operation via a UI."

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work 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, or an optical disk. The storage unit 106 also stores data files 106a, and the like.

Data file 106f is a file for storing various data such as paid payment data, processed receipt data, processed payment data, paid payment reconciliation data, scheduled collection data, and scheduled payment data. Paid payment data, processed receipt data, processed payment data, paid payment reconciliation data, scheduled collection data, and scheduled payment data are also referred to as "voucher data."

Paid payment data may include data such as payment date, paid payment number (document number), item, payment quantity, payment unit price, payment amount, and current inventory quantity (see Figure 3 (A)).

The processed receipt data may include data such as the processing date, processing number (document number), item, receipt quantity, repurchase price, and repurchase amount (purchase amount) (see 3 (B)).

The processing and withdrawal data may include data on the processing date, processing number (document number), line number, item, and number of items to be withdrawn (see Figure 3 (C)).

The paid payment reconciliation data may include data such as the paid payment number, processing number (document number), line number, item, reconciliation quantity, and the paid payment amount (see Figure 3 (D)). The paid payment amount is calculated by multiplying the payment unit price by the reconciliation quantity.

The control unit 102 is a CPU or the like that controls the paid payment transaction management 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. In terms of function, the control unit 102 is equipped with a paid payment data processing unit 102a, a processed data processing unit 102b, a paid payment reconciliation data processing unit 102c, a collection schedule data processing unit 102d, a payment schedule data processing unit 102e, an offsetting processing unit 102f, and a screen display control unit 102g.

When materials are supplied to a manufacturing company, the paid supply data processing unit 102a inputs paid supply data including the supply date, paid supply number, item, supply quantity, supply unit price, supply amount, and current inventory quantity in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the input data in the data file 106a.

When buying back products (also called processed goods or finished products) made from materials supplied by a manufacturing company, the processing data processing unit 102b inputs, for example, processing acceptance data including the processing date, processing number, line number, item, acceptance quantity, repurchase price, and repurchase amount, and processing delivery data including the processing date, processing number, line number, item, and delivery quantity, in response to the operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the data in the data file 106a.

When buying back products (processed products) manufactured with materials supplied by the manufacturing company, the paid supply reconciliation data processing unit 102c creates paid supply reconciliation data including the paid supply number, processing number, item, reconciliation quantity, and reconciled paid supply main amount based on the paid supply data and processed payment withdrawal data, and stores this data in data file 106a. The paid supply reconciliation data processing unit 102c reconciles the paid supply data with the paid supply reconciliation data, and updates the current inventory of the paid supply data by subtracting the reconciliation quantity.

The scheduled collection data processing unit 102d inputs scheduled collection data, including the scheduled collection date, paid payment number, scheduled collection amount, quantity, unit price, and reconciled payment amount, in response to, for example, the operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the data in the data file 106a.

The payment schedule data processing unit 102e inputs payment schedule data including the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and reconciled payment amount, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the data in the data file 106a.

The offsetting processing unit 102f offsets the planned collection amount of the planned collection data and the planned payment amount of the planned payment data using the paid payment number and processing number as keys for the paid payment main amount of the paid payment offset data.

The offsetting processing unit 102f may offset the planned recovery amount of the planned recovery data with the reconciled paid payment amount of the paid payment reconciliation data based on the specified offsetting reference date, update the reconciled payment amount of the planned recovery data, and update the reconciled payment amount of the planned payment data. Update by the profit balance - the reconciled delivery material profit/loss amount.

The screen display control unit 102g controls the display of various display screens (e.g., input screens, automatic offset screens, etc.) displayed on the monitor 114 and the acceptance of input.

3. Specific examples of processing
A specific example of the process of the control unit 102 of the paid supply transaction management device 100 in this embodiment will be described with reference to Figures 1 to 6. Figures 2 to 6 are diagrams showing sample data. In the following description, the unit of monetary amount is always "yen", and the notation may be omitted.

Figure 2 shows an example of a paid payment transaction, showing an example of transactions from January to March (example of outlined voucher data). Here, we explain an example of first-in, first-out settlement.

In Figure 2, an example of data on transaction date, slip number, transaction type, item, quantity (pieces), unit price, and amount is shown. A purchase was made on date "1/1", with slip number "S01", transaction type "Purchase", item "Raw materials", quantity "10", unit price "@100 (purchase unit price)", and purchase amount "¥1,000". A paid supply was made on date "1/2", with slip number "Y01", transaction type "paid supply", item "Raw materials", quantity "10", unit price "@250 (supply unit price)", and payment amount "¥2,500". A repurchase of goods (processed goods) was made on date "1/31", with slip number "K01", transaction type "processing results", item "processed goods", quantity "8", unit price "@500 (repurchase unit price)", and repurchase amount "¥4,000". Here, eight raw materials are consumed.

On the date "2/1", a purchase was made with the document number "S02", transaction type "Purchase", item "Raw materials", quantity "10", unit price "@120 (Purchase unit price)", and purchase amount "￥1,200". On the date "2/2", a paid supply was made with the document number "Y02", transaction type "Paid supply", item "Raw materials", quantity "10", unit price "@250 (Supply unit price)", and payment amount "￥2,500". On the date "2/28", the document number "K02", transaction type "Processing results", item "Processed goods", quantity "8", unit price "@500 (Repurchase unit price)", and repurchase amount "￥4,000". Here, 8 units of raw materials are cleared.

Next, we will explain the above transaction in detail.

The transactions in January will be explained with reference to Figures 3 and 4. Figures 3 and 4 are diagrams for explaining the transactions in January.

At the time of payment, paid payment data such as that shown in Figure 3 (A) is created. The paid payment data shown in Figure 3 (A) has the payment date "1/2", paid payment number "Y01", item "raw materials", payment quantity "10", payment unit price "250", payment amount "2500", and current stock quantity "10". The current stock quantity is managed for each payment slip.

At the time of repurchase, processed receipt data as shown in Figure 3 (B) is created. The processed receipt data shown in Figure 3 (B) has the processing date "1/31", processing number "K01", item "raw materials", received quantity "8", repurchase price "500", and repurchase amount "400". In addition, processed issuing data as shown in Figure 3 (C) is created. The processed issuing data shown in Figure 3 (C) has the processing number "K01", row number "1", item "raw materials", and issue quantity "8".

Based on the paid supply data and the processed payment data, paid supply reconciliation data as shown in Figure 3 (C) is created. The paid supply reconciliation data shown in Figure 3 (D) has the paid supply number "Y01", document number "K01", line number "1", item "raw materials", reconciliation quantity "8", and reconciled paid supply main amount "2000".

Here, the amount to be cleared "8" becomes the "number to be cleared" in the processed and cleared data. The amount of the cleared paid item "2000" = the unit price of the payment "250" x the amount to be cleared "8".

The paid payment data is cleared using the paid payment clearing data, and as shown in Figure 4 (A), the current quantity in the paid payment data ("10") is updated to "2" by subtracting the clearing quantity ("8") from the current quantity in stock ("10") ("2").

Scheduled collection data is created as shown in Figure 3 (D). The scheduled collection data shown in Figure 3 (D) has the scheduled collection date "3/31", paid payment number "Y01", transaction "paid payment", scheduled collection amount "2500", quantity "10", unit price "250", and cleared payment amount "0".

In addition, payment schedule data is created as shown in Figure 3 (E). The payment schedule data shown in Figure 3 (E) has the following schedule: payment schedule date "3/31", processing number "K01", transaction "processing", payment schedule amount "4000", quantity "8", unit price "500", and reconciled payment amount "0".

Figure 4 (A) is a diagram showing an example of an automatic offset processing screen. The automatic offset processing screen has a field for the operator to input the offset reference date. The offset processing unit 102f performs offsetting for offset reference dates that specify the scheduled collection date of the scheduled collection data and the scheduled payment date of the scheduled payment data. In the example shown in Figure 4 (A), since the offset reference date "3/31" has been input, offsetting is performed for the scheduled collection date "3/31" of the scheduled collection data and the scheduled payment date "3/31" of the scheduled payment data shown in Figure 4 (D) based on the offset reference date "3/31".

The paid payment amount "2000" in the paid payment reconciliation data is offset by the planned collection amount in the planned collection data and the planned payment amount in the planned payment data.

For the collection schedule data shown in Figure 4 (B), the paid payment reconciliation data is tallied by paid payment number "Y01", and the reconciled amount for paid payment number "Y01" is updated from "0" to "2000".

In addition, for the collection schedule data shown in Figure 4 (C), the paid payment settlement data processing number "K01" is tallied, and the settled payment amount for processing number "K01" is updated from "0" to "2000".

The transactions in February will be explained with reference to Figures 5 and 6. Figures 5 and 6 are diagrams for explaining transactions in February.

At the time of payment, as shown in Figure 5 (A), the following data is added to the second line of the paid payment data: payment date "2/2", paid payment number "Y02", item "raw materials", payment quantity "10", payment unit price "250", payment amount "2500", and current inventory quantity "10".

When repurchasing, as shown in Figure 5 (B), add the processing date "2/28", processing number "K02", line number "1", item "raw materials", and quantity "8" to the second line of the processing and issuing data.

For this payout quantity of "8", in order to settle the paid payment data starting with the earliest payment date, set the settlement quantity to "2" for paid payment number "Y01" and "6" for paid payment number "Y02" in the second and third lines of the paid payment settlement data as shown in Figure 5 (C).

Specifically, in the second line of the paid payment reconciliation data, add the paid payment number "Y01", document number "K02", line number "1", item "raw materials", reconciliation quantity "2", and reconciliation paid payment main amount "500". Here, reconciliation paid payment main amount "500" = payment unit price "250" x reconciliation quantity "2".

On the third line, add the paid supply number "Y02", document number "K02", line number "1", item "raw materials", amount to be cleared "6", and paid supply amount to be cleared "1500". Here, paid supply amount to be cleared "1500" = payment unit price "250" x amount to be cleared "6".

As shown in Figure 5 (A), the paid payment number "Y01" in the first line of the paid payment data is cleared with the paid payment number "Y01" in the second line of the paid payment clearing data, and the current quantity in stock "2" is updated to "0" by subtracting the clearing amount "2" from the current quantity in stock "2".

The paid payment number "Y02" on the second line of the paid payment data is settled with the paid payment number "Y02" on the third line of the paid payment settlement data, and the current quantity in stock "10" is updated to "4" by subtracting the settlement quantity "6" from the current quantity in stock "10".

As shown in Figure 5 (D), the following are added to the second line of the planned collection data: planned collection date "4/30", paid payment number "Y02", transaction "paid payment", planned collection amount "2500", quantity "10", unit price "250", and cleared payment amount "0".

As shown in Figure 5 (E), the following are added to the second line of the payment schedule data: scheduled payment date "4/30", processing number "K02", transaction "processing", scheduled payment amount "4000", quantity "8", unit price "500", and reconciled payment amount "0".

In the example of the automatic offset processing screen shown in Figure 6 (A), the offset reference date of "4/30" has been entered, so the offset is performed for the amount to be collected in the collection schedule data and the amount to be paid in the payment schedule data, based on the offset reference date of "4/30".

As shown in Figure 6 (D), the amount of paid payment to be settled in the paid payment settlement data (500 + 1500 = 2000) is offset by the amount to be collected in the scheduled collection data and the amount to be paid in the scheduled payment data.

For the collection schedule data shown in Figure 6 (B), the paid payment reconciliation data is tabulated using paid payment number "Y01" and the reconciled amount for paid payment number "Y01" is updated from "2000" to "2500". The paid payment reconciliation data is also tabulated using paid payment number "Y02" and the reconciled amount for paid payment number "Y02" is updated from "0" to "1500".

In addition, for the collection schedule data shown in Figure 6 (C), the paid payment settlement data processing number "K02" is tallied (500 + 1500 = 2000), and the settled payment amount for processing number "K02" is updated from "0" to "2000".

As described above, according to this embodiment, the paid supply transaction management device is equipped with a control unit, and the control unit includes a paid supply data processing unit 102a that inputs paid supply data including the supply date, paid supply number, item, supply quantity, supply unit price, supply amount, and current inventory quantity when materials are supplied, a processing data processing unit 102b that inputs processed and paid-out data including the processing number, item, and paid-out quantity when processed products are repurchased, a paid supply reconciliation data processing unit 102c that inputs paid supply reconciliation data including the paid supply number, processing number, item, reconciliation quantity, and paid-out main amount calculated by reconciliation quantity x paid unit price, and a scheduled collection date, paid supply number, scheduled collection amount, quantity, unit price, and payment reconciliation data processing unit 102d that inputs paid supply reconciliation data including the paid supply number, processing number, item, reconciliation quantity, and payment reconciliation data calculated by the payment quantity x payment unit price. The system includes a scheduled collection data processing unit 102d that inputs scheduled collection data including the repaid amount, a scheduled payment data processing unit 102e that inputs scheduled payment data including the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and repaid payment amount, and an offsetting processing unit 102f that offsets the scheduled collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data using the paid payment number and processing number as keys, respectively, for the repaid paid payment main amount of the paid payment reconciliation data. Therefore, in paid payment transactions, by linking the voucher at the time of payment with the voucher at the time of repurchase, accurate values and automatic offsetting processing can be performed, thereby reducing the workload of the person in charge.

4. 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 paid payment transaction management 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 paid supply transaction management device 100, particularly the processing functions performed by the control unit 102, 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 paid supply transaction management 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 paid payment transaction management device 100 via any network, and it may be possible to download all or part of it 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, or may 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 106 are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The paid supply transaction management 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 paid supply transaction management 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 may be implemented in any combination, or the embodiments may be implemented selectively.

100 Paid payment transaction management device 102 Control unit 102a Paid payment data processing unit 102b Processed data processing unit 102c Paid payment settlement data processing unit 102d Collection schedule data processing unit 102e Payment schedule data processing unit 102f Offsetting processing unit 102g Screen display control unit 104 Communication interface unit 106 Storage unit 106a Data file 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

A paid supply transaction management device including a control unit for managing a paid supply transaction in which a material is supplied to a manufacturing company for a fee and the manufacturing company repurchases a product produced by processing the material,
The control unit is
a paid supply data input means for inputting paid supply data including a supply date, a paid supply number, an item, a supply quantity, a supply unit price, a supply amount, and a current stock quantity when a material is supplied, and registering the input data in a storage unit;
a processing and paying data input means for inputting processing and paying data including a processing number, a product item, and a payout quantity at the time of repurchasing the processed product, and registering the processing and paying data in the storage unit;
a paid payment reconciliation data processing means for inputting paid payment reconciliation data including a paid payment number, a processing number, an item, a reconciliation quantity to be reconciled, and a paid payment main amount to be reconciled calculated by multiplying the reconciliation quantity by a payment unit price based on the paid payment data and the processed payment data registered in the storage unit, and registering the input data in the storage unit;
a collection schedule data processing means for inputting collection schedule data including a collection schedule date, a paid payment number, a collection schedule amount, a quantity, a unit price, and a cleared payment amount, and registering the data in the storage unit;
a payment schedule data processing means for inputting payment schedule data including a payment settled amount, which is an amount obtained by aggregating the settled paid payment main amount of the paid payment settlement data using a scheduled payment date, a processing number, a scheduled payment amount, a quantity, a unit price, and a processing number as keys, and registering the payment schedule data in a storage unit;
an offsetting means for offsetting the paid payment main amount of the paid payment clearing data registered in the storage unit with the paid payment number and processing number of the same record as keys, respectively, against the planned recovery amount of the paid payment scheduled data registered in the storage unit with the paid payment number as a key and the planned payment amount of the payment scheduled data registered in the storage unit with the processing number as a key;
A paid payment transaction management device comprising: The paid payment transaction management device according to claim 1, characterized in that the paid payment reconciliation data processing means performs reconciliation on a first-in, first-out basis in date order using the paid payment reconciliation data registered in the storage unit. The paid payment transaction management device according to claim 1 or 2, characterized in that the paid payment reconciliation data processing means updates the current stock quantity of the paid payment data registered in the storage unit by the current stock quantity minus the reconciliation quantity of the paid payment reconciliation data. The paid payment transaction management device according to any one of claims 1 to 3, characterized in that the offsetting means offsets the planned collection amount of the planned collection data registered in the storage unit with the paid payment amount cleared in the paid payment clearing data registered in the storage unit based on the offsetting reference date specified by the operator, updates the cleared deposit amount of the planned collection data registered in the storage unit, and updates the cleared payment amount of the planned payment data registered in the storage unit. A paid supply transaction management method for managing a paid supply transaction in which a material is supplied to a manufacturing company for a fee and the manufacturing company repurchases a product produced by processing the material, the method being executed by an information processing device having a control unit, the method comprising:
Executed in the control unit:
a paid supply data input process for inputting paid supply data including a supply date, a paid supply number, an item, a supply quantity, a supply unit price, a supply amount, and a current stock quantity when a material is supplied, and registering the input data in a storage unit;
a processing and paying-out data input step of inputting processing and paying-out data including a processing number, an item, and a pay-out quantity at the time of repurchasing the processed product and registering the data in the storage unit;
a paid payment reconciliation data processing step of inputting paid payment reconciliation data including a paid payment number, a processing number, an item, a reconciliation quantity to be reconciled, and a paid payment main amount to be reconciled calculated by multiplying the reconciliation quantity by a payment unit price based on the paid payment data and the processed payment data registered in the storage unit, and registering the input data in the storage unit;
a collection schedule data processing step of inputting collection schedule data including a collection schedule date, a paid payment number, a collection schedule amount, a quantity, a unit price, and a reconciled payment amount and registering the input data in the storage unit;
a payment schedule data processing step of inputting payment schedule data including a payment settled amount, which is an amount obtained by aggregating the settled paid payment main amount of the paid payment settlement data using the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and processing number as keys, and registering the input data in a storage unit;
an offsetting step of offsetting the paid payment main amount of the paid payment clearing data registered in the storage unit with the paid payment number and processing number of the same record as keys, respectively, with the planned recovery amount of the paid payment scheduled data registered in the storage unit with the paid payment number as a key, and the planned payment amount of the payment scheduled data registered in the storage unit with the processing number as a key;
A method for managing a payment transaction, comprising: A paid supply transaction management program for managing a paid supply transaction in which a material is supplied to a manufacturing company for a fee and the manufacturing company repurchases a product produced by processing the material, the program being executed by an information processing device having a control unit, the program comprising:
The control unit,
a paid supply data input process for inputting paid supply data including a supply date, a paid supply number, an item, a supply quantity, a supply unit price, a supply amount, and a current stock quantity when a material is supplied, and registering the input data in a storage unit;
a processing and paying-out data input step of inputting processing and paying-out data including a processing number, an item, and a pay-out quantity at the time of repurchasing the processed product and registering the data in the storage unit;
a paid payment reconciliation data processing step of inputting paid payment reconciliation data including a paid payment number, a processing number, an item, a reconciliation quantity to be reconciled, and a paid payment main amount to be reconciled calculated by multiplying the reconciliation quantity by a payment unit price based on the paid payment data and the processed payment data registered in the storage unit, and registering the input data in the storage unit;
a collection schedule data processing step of inputting collection schedule data including a collection schedule date, a paid payment number, a collection schedule amount, a quantity, a unit price, and a reconciled payment amount and registering the input data in the storage unit;
a payment schedule data processing step of inputting payment schedule data including a payment settled amount, which is an amount obtained by aggregating the settled paid payment main amount of the paid payment settlement data using the scheduled payment date, processing number, scheduled payment amount, quantity, unit price, and processing number as keys, and registering the input data in a storage unit;
an offsetting step of offsetting the paid payment main amount of the paid payment clearing data registered in the storage unit with the paid payment number and processing number of the same record as keys, respectively, with the planned recovery amount of the paid payment scheduled data registered in the storage unit with the paid payment number as a key, and the planned payment amount of the payment scheduled data registered in the storage unit with the processing number as a key;
A paid transaction management program for executing the above.

Images