JP2022027115A - Charged supply transaction management device, charged supply transaction managing method, and charged supply transaction managing program - Google Patents

Abstract

To reduce work load for a person in charge by carrying out a cancelling process at an accurate value as well as automatically by associating a slip for paying with a slip for redemption in a charged supply transaction.SOLUTION: A charged supply transaction management device includes: charged supply data input means for inputting charged supply data including a supplied date, charged supply number, item, number supplied, supply unit cost, supply amount, and present stock at time of supply of material; charged supply deletion data processing means for inputting charged supply deletion data including a charged supply number, process number, item, deletion quantity, and deletion charged supply body cost calculated by deletion quality×supply unit cost; and cancelling means for cancelling a recovery scheduled amount of recovery scheduled data and a payment scheduled amount of payment scheduled data with a charged supply number and a processing number as respective keys regarding the cancelling charged supply body amount of charged supply cancelling data.SELECTED DRAWING: Figure 1

Description

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

For example, there is a transaction in which materials and semi-finished products are provided to a subcontractor for a fee and then repurchased after processing, and this transaction is called a paid payment transaction. It is a transaction mainly in the automobile industry.
As a system for carrying out such a paid payment transaction, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2002-288494

However, in Patent Document 1, in the paid payment transaction, the work load of the person in charge is reduced by linking the slip at the time of payment and the slip at the time of repurchase to perform offset processing with an accurate value and automatically. Nothing is said about that.

The present invention has been made in view of the above, and in a paid payment transaction, by associating a slip at the time of payment with a slip at the time of repurchase, an accurate value and automatic offset processing can be performed by a person in charge. It is an object of the present invention to provide a paid payment transaction management device, a paid payment transaction management method, and a paid payment transaction management program capable of reducing the work load of the above.

In order to solve the above-mentioned problems and achieve the object, the present invention is a paid payment transaction management device provided with a control unit, and the control unit is used to supply a material with a payment date, a paid payment number, and an item. , Input the paid payment data including the number of payments, the unit price of payment, the amount of payment, and the current number of stocks. Processing withdrawal data input means and paid payment application data including paid payment number, processing number, item, application quantity, application quantity x application unit price Data processing means, scheduled collection data processing means for inputting scheduled collection data including scheduled collection date, paid payment number, scheduled collection amount, quantity, unit price, payment applied amount, scheduled payment date, processing number, payment schedule The payment schedule data processing means for inputting payment schedule data including the amount, quantity, unit price, and payment application amount, and the payment schedule data processing method for applying the paid payment application data, and the payment payment main unit amount, the paid payment number and processing number are used as keys, respectively. As a result, it is characterized by being provided with an offsetting means for offsetting the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data.

Further, according to one aspect of the present invention, the paid payment application data processing means may delete the paid payment data by first-in first-out with the paid payment application data.

Further, according to one aspect of the present invention, the paid payment application data processing means may update the current number of paid payment data by the current number of storage minus the amount of application.

Further, according to one aspect of the present invention, the offsetting means offsets the planned collection amount of the scheduled collection data with the applied paid payment main amount of the paid payment application data based on the designated offset reference date. , The payment application amount of the collection schedule data may be updated, and the payment application amount of the payment schedule data may be updated.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a paid payment transaction management method executed by an information processing apparatus provided with a control unit, and is a material executed by the control unit. At the time of payment, the paid payment data input process for inputting the paid payment data including the payment date, paid payment number, item, number of payments, payment unit price, payment amount, and current number of warehouses, and at the time of repurchase of processed products, the processing number, Processing that includes the processing and payout data including the item and the number of payouts. Paid payment application data processing process for inputting payment application data, and collection schedule data processing process for inputting collection schedule data including scheduled collection date, paid payment number, planned collection amount, quantity, unit price, and payment application amount The payment schedule data processing process for inputting the payment schedule data including the payment schedule date, processing number, payment schedule amount, quantity, unit price, and payment application amount, and the application payment main unit amount of the paid payment application data. The feature is that the data is provided with an offsetting process for offsetting the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data, using the paid payment number and the processing number as keys, respectively.

Further, according to one aspect of the present invention, it is a paid payment transaction program for causing an information processing apparatus provided with a control unit to execute, and when the material is supplied in the control unit, the payment date, the paid payment number, and the item. , Input the paid payment data including the number of payments, the unit price of payment, the amount of payment, and the current number of stocks. Processing data input process and paid payment application data including paid payment application amount including paid payment number, processing number, item, application quantity, application quantity x payment unit price Scheduled collection data processing process for inputting scheduled collection data including scheduled collection date, paid payment number, scheduled collection amount, quantity, unit price, and payment applied amount, and scheduled payment date, processing number, and scheduled payment amount For the payment schedule data processing process for inputting payment schedule data including quantity, unit price, and payment application amount, and for the application payment main unit amount of the paid payment application data, the paid payment number and processing number are used as keys, respectively. It is characterized by being a paid transaction management program for executing an offsetting process that offsets the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data.

According to the present invention, in a paid payment transaction, by associating a slip at the time of payment with a slip at the time of repurchase, it is possible to realize an accurate value and automatic offset.

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

Hereinafter, embodiments of the paid payment transaction management device, the paid payment transaction management method, and the paid payment transaction management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
For example, there is a transaction in which materials and semi-finished products are provided to a subcontractor for a fee and then repurchased after processing, and this transaction is called a paid payment transaction. It is a transaction mainly in the automobile industry.
However, when offsetting is performed in such a paid payment transaction, the receivables (accounts receivable) and the accounts payable at the time of repurchase are matched, and each time, confirmation of the consumed supply materials and slips are managed separately to offset. The work load of the person in charge was heavy.

Therefore, in the present embodiment, in the paid payment transaction, the work load of the person in charge is reduced by linking the slip at the time of payment and the slip at the time of repurchase to perform offset processing with an accurate value and automatically. .. In the present embodiment, since the automatic determination is performed on a first-in, first-out basis, the validity of the consumed supply materials and slips can be improved.

[2. Constitution]
The configuration of the paid transaction management device 100 according to the present embodiment will be described with reference to FIG. FIG. 2 is a block diagram showing an example of the configuration of the paid transaction management device 100 according to the present embodiment. The paid payment transaction management device 100 according to the present embodiment can be suitably used in, for example, a company or the like that conducts paid payment transactions such as the automobile industry.

The paid transaction management device 100 is a commercially available desktop personal computer. The paid transaction management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, or the like. It may be a portable information processing device.

As shown in FIG. 3, the paid transaction management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the paid transaction management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the paid transaction management device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the paid transaction management device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage 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. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112. Further, the user displaying on the screen of the output device (monitor) 114 and operating the input device 112 may be described as "user operation via UI".

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. Further, the storage unit 106 stores the data file 106a and the like.

The data file 106f is a file for storing various data such as paid payment data, processing acceptance data, processing payout data, paid payment application data, collection schedule data, and payment schedule data. Paid payment data, processing acceptance data, processing withdrawal data, paid payment application data, collection schedule data, and payment schedule data are also referred to as "slip data".

The paid payment data may include data such as the payment date, the paid payment number (slip number), the item, the number of payments, the payment unit price, the payment amount, and the current number of stocks (see FIG. 3A).

The processing acceptance data may include data such as processing date, processing number (slip number), item, received quantity, repurchase unit price, repurchase amount (purchase amount) (see 3 (B)).

The processing payout data may include data on the processing date, processing number (slip number), line number, item, and number of payouts (see FIG. 3C).

The paid payment application data may include data such as a paid payment number, a processing number (slip number), a line number, an item, an application quantity, and an application paid payment main unit amount (see FIG. 3 (D)). .. The amount of paid application payment is calculated by multiplying the unit price of payment by the quantity of application.

The control unit 102 is a CPU or the like that collectively controls the paid transaction management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute. The control unit 102 functionally conceptually includes a paid payment data processing unit 102a, a processing data processing unit 102b, a paid payment application data processing unit 102c, a collection schedule data processing unit 102d, and a payment schedule data processing unit 102e. , The offset processing unit 102f and the screen display control unit 102g are provided.

The paid payment data processing unit 102a receives the payment date, the paid payment number, the item, and the number of payments according to the operation of the operator on the input screen (not shown) displayed on the monitor 114 when the material is supplied to the manufacturing company. , Payment unit price, payment amount, and paid payment data including the current number of stocks are input and registered in the data file 106a.

The processing data processing unit 102b can be used by an operator on an input screen (not shown) displayed on the monitor 114 when repurchasing a product (also referred to as a processed product or product) manufactured from a material supplied by a manufacturing company. Input processing acceptance data including processing date, processing number, line number, item, received quantity, repurchase unit price, and repurchase amount, and processing withdrawal data including processing date, processing number, line number, item, and number of payouts. Then, it is stored in the data file 106a.

When the product (processed product) manufactured from the material supplied by the manufacturing company is repurchased, the paid payment application data processing unit 102c shall use the paid payment data and the processing payout data to obtain the paid payment number, processing number, item, and consumption. Paid payment application data including the included quantity and the applied paid payment main unit amount is created and stored in the data file 106a. The paid payment application data processing unit 102c deletes the paid payment data with the paid payment application data, and updates the current number of the paid payment data by the current number of warehouses minus the application quantity.

The collection schedule data processing unit 102d, for example, responds to an operator's operation on an input screen (not shown) displayed on the monitor 114, and receives a collection schedule date, a paid payment number, a collection schedule amount, a quantity, a unit price, and payment application. The collection schedule data including the paid amount is input and stored in the data file 106a.

The payment schedule data processing unit 102e, for example, responds to an operator's operation on an input screen (not shown) displayed on the monitor 114, and has a payment schedule date, a processing number, a payment schedule amount, a quantity, a unit price, and payment application completed. Payment schedule data including the amount is input and stored in the data file 106a.

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

The offset processing unit 102f offsets the estimated collection amount of the scheduled collection data with the application amount of the paid payment application data based on the designated offset reference date, and the payment application amount of the collection schedule data. May be updated to update the payment cleared amount of the payment schedule data. Balance of profit-Updated by the amount of profit or loss of material to be delivered.

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

[3. Specific example of processing]
A specific example of the processing of the control unit 102 of the paid transaction management device 100 in the present embodiment will be described with reference to FIGS. 1 to 6. 2 to 6 are diagrams showing sample data. In the following explanation, the unit of the amount of money is all "yen", and the notation may be omitted.

FIG. 2 is a diagram showing an example of a paid payment transaction, and shows an example of a transaction from January to March (an example of schematic slip data). Here, an example of performing application on a first-in, first-out basis will be described.

FIG. 2 shows an example of transaction date, slip number, transaction type, item, quantity (piece), unit price, and amount data. The purchase is made on the date "1/1", the slip number "S01", the transaction type "purchase", the item "raw material", the quantity "10", the unit price "@ 100 (purchase unit price)", and the purchase. The deposit amount is "1,000 yen". Paid payment is made on the date "1/2", slip number "Y01", transaction type "paid payment", item "raw material", quantity "10", unit price "@ 250 (payment unit price)", payment The amount is "¥ 2,500", the product (processed product) is repurchased on the date "1/31", the slip number "K01", the transaction type "processing record", and the item "processing". The product is "good", the quantity is "8", the unit price is "@ 500 (repurchase unit price)", and the repurchase amount is "4,000 yen". Here, eight consumptions are made for the raw materials.

The purchase was made on the date "2/1", the slip number "S02", the transaction type "purchase", the item "raw material", the quantity "10", the unit price "@ 120 (purchase unit price)", The purchase price is "¥ 1,200". Paid payment is made on the date "2/2", slip number "Y02", transaction type "paid payment", item "raw material", quantity "10", unit price "@ 250 (payment unit price), payment amount" It is "2,500 yen". On the date "2/28", the slip number "K02", transaction type "processing record", item "processed product", quantity "8", unit price "@ 500 (repurchase unit price)", repurchase amount "¥ 4," It is "000". Here, eight consumptions are made for the raw materials.

Next, the above transaction will be described in detail.

The January transaction will be described with reference to FIGS. 3 and 4. 3 and 4 are diagrams for explaining the January transaction.

At the time of payment, paid payment data as shown in FIG. 3A is created. The paid payment data shown in FIG. 3 (A) includes the payment date “1/2”, the paid payment number “Y01”, the item “raw material”, the number of payments “10”, the payment unit price “250”, and the payment amount “2500”. Currently, the number of warehouses is "10". The current number of stocks is managed for each payment slip.

At the time of repurchase, processing acceptance data as shown in FIG. 3B is created. The processing acceptance data shown in FIG. 3B includes the processing date "1/31", the processing number "K01", the item "raw material", the received quantity "8", the repurchase unit price "500", and the repurchase amount "400". It has become. Further, the processing and payout data as shown in FIG. 3C is created. The processing payout data shown in FIG. 3C has a processing number “K01”, a line number “1”, an item “raw material”, and a number of payouts “8”.

Based on the paid payment data and the processing payout data, the paid payment application data as shown in FIG. 3C is created. The paid payment application data shown in FIG. 3 (D) includes the paid payment number "Y01", the slip number "K01", the line number "1", the item "raw material", the application quantity "8", and the application paid payment main body. The amount is "2000".

Here, the application quantity "8" is the "number of payouts" of the processing payout data. The amount of paid payment for application "2000" = unit price of payment "250" x quantity of application "8".

The paid payment data is applied using the paid payment application data, and as shown in FIG. 4 (A), the current number of paid payment data "10" is changed to the current number of warehouses "10" -the amount of application. Update to "2" by "8".

Scheduled collection data is created as shown in FIG. 3 (D). The data to be collected shown in FIG. 3D is the scheduled collection date "3/31", the paid payment number "Y01", the transaction "paid payment", the planned collection amount "2500", the quantity "10", and the unit price "250". , The amount of payment applied is "0".

In addition, payment schedule data as shown in FIG. 3 (E) is created. The payment schedule data shown in FIG. 3 (E) includes the scheduled payment date "3/31", the processing number "K01", the transaction "processing", the scheduled payment amount "4000", the quantity "8", the unit price "500", and the payment. The applied amount is "0".

FIG. 4A 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 offsets the data on the offset reference date in which the scheduled collection date of the scheduled collection data and the scheduled payment date of the scheduled payment data are specified. In the example shown in FIG. 4A, since the offset reference date “3/31” is input, the collection schedule data shown in FIG. 4D is collected with reference to the offset reference date “3/31”. The scheduled date "3/31" and the scheduled payment date "3/31" of the scheduled payment data are offset.

Application of paid payment application data With respect to the paid payment main unit amount "2000", the collection schedule amount of the collection schedule data and the payment schedule amount of the payment schedule data are offset.

For the data to be collected shown in FIG. 4 (B), the paid payment application number "Y01" is used for totaling, and the payment applied amount of the paid payment number "Y01" is changed from "0" to "2000". Update to.

In addition, the data to be collected shown in FIG. 4C is aggregated by the processing number "K01" of the paid payment application data, and the payment application amount of the processing number "K01" is changed from "0" to "2000". Update to.

The February transaction will be described with reference to FIGS. 5 and 6. 5 and 6 are diagrams for explaining the transaction in February.

At the time of payment, as shown in Fig. 5 (A), the payment date "2/2", the paid payment number "Y02", the item "raw materials", the number of payments "10", and the payment unit price are shown in the second line of the paid payment data. Add data of "250", payment amount "2500", and current number of stocks "10".

At the time of repurchase, as shown in FIG. 5 (B), the processing date "2/28", the processing number "K02", the line number "1", the item "raw material", and the number of payouts are shown in the second line of the processing payout data. Add "8".

Regarding the number of payouts "8", in order to apply from the data with the earliest payment date of the paid payment data, as shown in FIG. 5 (C), in the second and third lines of the paid payment application data. , For the paid payment number "Y01", set the application quantity to "2", and for the paid payment number "Y02", set the application quantity to "6".

Specifically, in the second line of the paid payment application data, the paid payment number "Y01", the slip number "K02", the line number "1", the item "raw material", the application quantity "2", and the application Add the paid main unit amount "500". Here, the amount of paid payment for application "500" = unit price of payment "250" x quantity of application "2".

The paid payment number "Y02", the slip number "K02", the line number "1", the item "raw material", the application quantity "6", and the application paid payment main unit amount "1500" are added to the third line. Here, the amount of paid payment for application "1500" = unit price of payment "250" x quantity of application "6".

As shown in FIG. 5A, the paid payment number “Y01” in the first line of the paid payment data is cleared by the paid payment number “Y01” in the second line of the paid payment application data, and the current warehouse is stored. The number "2" is updated to "0" by the current number of stocks "2" -the application quantity "2".

Regarding the paid payment number "Y02" in the second line of the paid payment data, the payment is applied with the paid payment number "Y02" in the third line of the paid payment application data, and the current number of stocks "10" is changed to the current number of stocks "10". 10 ”-Update to“ 4 ”by the application quantity“ 6 ”.

As shown in FIG. 5D, the second line of the scheduled collection data includes the scheduled collection date “4/30”, the paid payment number “Y02”, the transaction “paid payment”, the planned collection amount “2500”, and the quantity. "10", unit price "250", and payment applied amount "0" are added.

As shown in FIG. 5 (E), the second line of the scheduled payment data includes the scheduled payment date "4/30", the processing number "K02", the transaction "processing", the scheduled payment amount "4000", and the quantity "8". , The unit price "500", and the payment applied amount "0" are added.

In the example of the automatic offset processing screen shown in FIG. 6A, since the offset reference date “4/30” is input, the estimated collection amount of the data to be collected is set based on the offset reference date “4/30”. Offset the payment schedule amount of the payment schedule data.

As shown in FIG. 6 (D), application of paid payment application data With respect to the paid payment main unit amount "500" + "1500" = "2000", the collection scheduled amount of the scheduled collection data and the payment scheduled amount of the payment scheduled data To offset.

The data to be collected shown in FIG. 6 (B) is aggregated by the paid payment number "Y01" of the paid payment application data, and the payment applied amount of the paid payment number "Y01" is changed from "2000" to "2500". , And the data is aggregated by the paid payment number "Y02" of the paid payment application data, and the payment application amount of the paid payment number "Y02" is updated from "0" to "1500".

In addition, the data to be collected shown in FIG. 6C is aggregated with the processing number "K02" of the paid payment application data (500 + 1500 = 2000), and the payment application amount of the processing number "K02" is set to "K02". Update from "0" to "2000".

As described above, according to the present embodiment, it is a paid payment transaction management device provided with a control unit, and the control unit includes a payment date, a paid payment number, an item, and a number of payments when the material is supplied. Paid payment data processing unit 102a for inputting paid payment data including payment unit price, payment amount, and current number of warehouses, and processing data processing for inputting processing payout data including processing number, item, and number of payouts when repurchasing processed products. Part 102b and the paid payment application data processing unit that inputs the paid payment application data including the paid payment main unit amount calculated by the paid payment number, processing number, item, application quantity, application quantity × payment unit price. The collection schedule data processing unit 102d for inputting the collection schedule data including the collection schedule data including the collection schedule date, the paid payment number, the collection schedule amount, the quantity, the unit price, and the payment application amount, and the payment schedule date, processing number, and payment schedule amount. , The payment schedule data processing unit 102e for inputting payment schedule data including quantity, unit price, and payment application amount, and the payment schedule data processing unit 102e, and the payment payment main unit amount for the payment application application data, the paid payment number and processing number are used as keys, respectively. Since it is equipped with an offset processing unit 102f that offsets the planned collection amount of the scheduled collection data and the scheduled payment amount of the payment scheduled data, the slip at the time of payment and the slip at the time of repurchase are linked in the paid payment transaction. As a result, it is possible to reduce the work load of the person in charge by performing the offset processing with an accurate value and automatically.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or the processes described as being manually performed may be performed. All or part of it can be done automatically by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the paid 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, with respect to the processing functions included in the paid transaction management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the transaction is paid as necessary. It is read mechanically by the management device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the paid transaction management device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the paid 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. Further, the paid transaction management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Paid payment transaction management device 102 Control unit 102a Paid payment data processing unit 102b Processing data processing unit 102c Paid payment application data processing unit 102d Collection schedule data processing unit 102e Payment schedule data processing unit 102f Offset 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)

It is a paid transaction management device equipped with a control unit.
The control unit
When the material is supplied, the paid payment data input means for inputting the paid payment data including the payment date, the paid payment number, the item, the number of payments, the payment unit price, the payment amount, and the current number of warehouses,
A processing and payout data input means for inputting processing and payout data including a processing number, an item, and the number of payouts when repurchasing a processed product.
Paid payment application data processing means for inputting paid payment application data including the paid payment main unit amount calculated by the paid payment number, processing number, item, application quantity, application quantity x payment unit price,
A collection schedule data processing means for inputting collection schedule data including the collection schedule date, paid payment number, collection schedule amount, quantity, unit price, and payment applied amount,
A payment schedule data processing method for inputting payment schedule data including the payment schedule date, processing number, payment schedule amount, quantity, unit price, and payment cleared amount,
Applying the paid payment application data With respect to the paid payment main unit amount, using the paid payment number and the processing number as keys, the offsetting means for offsetting the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data, respectively.
A paid transaction management device characterized by being equipped with. The paid payment transaction management device according to claim 1, wherein the paid payment application data processing means applies the paid payment data on a first-in, first-out basis using the paid payment application data. The paid payment transaction management device according to claim 1 or 2, wherein the paid payment application data processing means updates the current number of paid payment data by the current number of stocks minus the amount of application. The offsetting means offsets the planned collection amount of the scheduled collection data with the application amount of the paid payment application data and the payment application amount of the collection schedule data based on the designated offset reference date. The paid payment transaction management device according to any one of claims 1 to 3, wherein the payment is updated and the payment applied amount of the payment schedule data is updated. It is a paid transaction management method executed by an information processing device equipped with a control unit.
Executed by the control unit,
A paid payment data input process that inputs paid payment data including the payment date, paid payment number, item, number of payments, unit price of payment, amount of payment, and current number of warehouses at the time of material supply.
A processing data input process that inputs processing and payout data including the processing number, item, and number of payouts when repurchasing processed products,
Paid payment application data processing process for inputting paid payment application data including the paid payment main unit amount calculated by the paid payment number, processing number, item, application quantity, application quantity x payment unit price,
The collection schedule data processing process for inputting the collection schedule data including the collection schedule date, paid payment number, collection schedule amount, quantity, unit price, and payment applied amount,
Payment schedule data processing process for inputting payment schedule data including payment schedule date, processing number, payment schedule amount, quantity, unit price, and payment cleared amount,
Regarding the application of the paid payment application data, the offsetting process that offsets the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data by using the paid payment number and the processing number as keys, respectively.
A paid transaction management method characterized by being equipped with. It is a paid transaction management program to be executed by an information processing device equipped with a control unit.
In the control unit
A paid payment data input process that inputs paid payment data including the payment date, paid payment number, item, number of payments, unit price of payment, amount of payment, and current number of warehouses at the time of material supply.
A processing data input process that inputs processing and payout data including the processing number, item, and number of payouts when repurchasing processed products,
Paid payment application data processing process for inputting paid payment application data including the paid payment main unit amount calculated by the paid payment number, processing number, item, application quantity, application quantity x payment unit price,
The collection schedule data processing process for inputting the collection schedule data including the collection schedule date, paid payment number, collection schedule amount, quantity, unit price, and payment applied amount,
Payment schedule data processing process for inputting payment schedule data including payment schedule date, processing number, payment schedule amount, quantity, unit price, and payment cleared amount,
Regarding the application of the paid payment application data, the offsetting process that offsets the planned collection amount of the scheduled collection data and the scheduled payment amount of the scheduled payment data by using the paid payment number and the processing number as keys, respectively.
A paid transaction management program for running.

Images