JP7446983B2 - Exchange rate usage reservation system, method and program - Google Patents

Description

The present invention relates to an exchange rate usage reservation system, method, and program.

Patent Document 1 discloses a debt management system as a background technology related to exchange rates. This debt management system includes a debt data receiving means, a currency changing means, a payment data creating means, and a foreign exchange profit/loss recording means. The debt data receiving means receives input of debt data in the first currency at the time of accounting for purchases. The currency change means accepts a change in currency to the effect that payment based on journal data in a first currency is to be made in a second currency. The payment data creation means creates payment data in the second currency. The foreign exchange gain/loss recording means calculates the difference between the yen-converted debt amount in the first currency and the yen-converted payment amount in the second currency, and records the difference as a foreign exchange gain/loss.

JP2009-301412A

There is a known transaction in which sales are recorded at a provisional exchange rate at the time of shipment or invoice, and then sales are recorded again at the official exchange rate after a predetermined period (for example, 10 days) from the shipping date to finalize the official sales. There is. In such transactions, sales can be recorded early, and the status of reaching sales targets can be confirmed early. Here, if the above-mentioned predetermined period is 10 days, the acceptance inspection at the customer is generally performed about 10 days after shipment from the factory, and the risk of fluctuations in sales due to returned goods or additional orders can be reduced.

In such transactions, when the official exchange rate is determined, the difference between the sales recorded at the tentative exchange rate and the sales recorded at the official exchange rate will be recorded, and the sales recorded at the tentative exchange rate will be corrected. There is a need to. However, when the number of target transactions is large, the burden on the operator is large. For this reason, sales are recorded at the provisional exchange rate for transactions where the elapsed date of a predetermined period from the shipping date crosses the end of the month, and for transactions where the elapsed date of the predetermined period from the shipping date falls within the month, the sales are recorded at the provisional exchange rate. In some cases, the official exchange rate was used instead of being recorded at the official exchange rate. As a result, there was an issue in which the achievement status of sales targets could only be checked on a monthly basis. Furthermore, the accounting methods for transactions in which a predetermined period of time has elapsed from the date of shipment crosses the end of the month and transactions in which the elapsed date of a predetermined period of time from the date of shipment falls within the same month are different, which complicates operations and can lead to recording errors. It could have happened.

The present invention has been made in view of the above problems, and its purpose is to provide a technique that allows early confirmation of sales.

In order to solve the above problems, the present invention uses the exchange rate of the ordered product, the ordered quantity of the ordered product, and the exchange rate of the predetermined period elapsed date from the shipping date of the ordered product. an information terminal that accepts input of an exchange rate usage reservation for calculating each sales; an order receipt including the ordered product and the ordered quantity; a storage unit that stores the exchange rate usage reservation and the predetermined period; At the time of shipping the ordered item, provisional sales for each ordered item are calculated using the exchange rate on the shipping date of the ordered item, and after the expiration date of the predetermined period, the exchange rate on the date on which the predetermined period has elapsed is calculated. using the exchange rate to calculate the final sales for each ordered product, calculate the difference between the final sales and provisional sales for each ordered product for which the input of the exchange rate usage reservation has been accepted, and create an adjustment slip for the calculated difference. and an arithmetic unit for creating.

According to the present invention, sales can be confirmed early.

FIG. 1 is a diagram illustrating an example of the overall configuration of an exchange rate reservation system. The figure which shows the hardware configuration example of an AP server. A diagram showing an example of a hardware configuration of a DB server. The figure which shows the hardware configuration example of the client terminal. The figure which shows the data structure example of an item master. The figure which shows the data structure example of a customer master. The figure which shows the data structure example of an exchange rate master. The figure which shows the data structure example of the unit price information table. The figure which shows the data structure example of the order receipt table. The figure which shows the data structure example of a billing slip table. The figure which shows the example of a data structure of a calendar information table. The figure which shows the example of an order receipt registration screen. The figure which shows the example of an order information search screen. The figure which shows the example of a billing slip registration screen. Flowchart showing order slip registration processing. 10 is a flowchart showing order information search condition transmission processing. Flowchart showing order information search processing. 5 is a flowchart showing order information reception display processing. Flowchart showing exchange rate search condition transmission processing. Flowchart showing exchange rate search processing. Flowchart showing the billing amount (yen) reception display processing. Flowchart showing billing slip registration processing. Flowchart showing official rate date calculation processing. Flowchart showing additional billing slip registration processing.

Hereinafter, one embodiment of the present invention will be described in detail with reference to the drawings. It should be noted that this embodiment is merely an example for implementing the present invention, and does not limit the technical scope of the present invention.

FIG. 1 is a diagram showing an example of the overall configuration of an exchange rate usage reservation system according to the present embodiment.

The exchange rate usage reservation system 100 includes an AP server 102 as an example of a "calculation unit", a DB server 103 as an example of a "storage unit", and a plurality of client terminals 104 as an example of an "information terminal". . The AP server 102, the DB server 103, and the plurality of client terminals 104 are connected to each other by a network 101. The AP server 102 and the DB server 103 are installed indoors, such as in a data center. The client terminal 104 is, for example, a terminal such as a personal computer. The client terminal 104 receives order information, billing information, and a rate reservation as an "exchange rate reservation" for 10 days from now as an example of a "predetermined period elapsed date" from a salesperson.

FIG. 2 is a diagram showing an example of the hardware configuration of the AP server.

The AP server 102 includes a controller (control unit) 202, a memory 203, a communication control unit 204, and a storage unit 201. Each part is connected by a bus (BUS). The storage unit 201 includes, as a program 210, an order information search function 211, an exchange rate search function 212, an official rate date calculation function 213, and an additional billing slip registration function 214. The order search function 211 has a function of receiving search conditions from the client terminal 104, searching the order slip table based on the information to obtain order information, and transmitting the obtained order information to the client terminal 104. The exchange rate search function 212 receives search conditions from the client terminal 104, searches the exchange rate master based on the information, obtains the exchange rate, and calculates the billing amount (in yen) using the obtained exchange rate. It has a function of calculating and transmitting it to the client terminal 104. The official rate date calculation function 213 has a function of searching the order receipt table and customer master data based on the registered contents of the billing slip table, and updating the official rate date of the billing slip table. The additional billing slip registration function 214 has a function of searching the exchange rate master, calculating the difference, and registering an additional billing slip based on the registered contents of the billing slip table.

FIG. 3 is a diagram showing an example of the hardware configuration of the DB server.

The DB server 103 includes a controller (control unit) 302, a memory 303, a communication control unit 304, and a storage unit 301. Each part is connected by a bus (BUS). The storage unit 301 includes an item master 310, a customer master 311, an exchange rate master 312, a unit price information table 313, an order slip table 314, a billing slip table 315, and a calendar information table 316. The item master 310 stores item codes, item names, and item types in association with each other. The customer master 311 stores customer codes, customer names, and rate reservation days in association with each other. The exchange rate master 312 stores a conversion source currency, a conversion destination currency, an exchange rate, a valid start date, and a valid end date in association with each other. The unit price information table 313 stores unit price numbers, customer codes, item codes, unit prices, and currencies in association with each other. The order slip table 314 stores order numbers, order details, recipients, delivery dates, items, ordered quantities, prices, currencies, and rate reservations in association with each other. The billing slip table 315 includes the billing number, billing details, billing class, shipping date, order number, order details, shipping quantity, billing amount, billing currency, billing amount (yen), and formal information. The rate date and status are stored in association with each other. Calendar information table 316 stores system dates.

FIG. 4 is a diagram showing an example of the hardware configuration of a client terminal.

The client terminal 104 includes a display section 402, a controller (control section) 403, a memory 404, a communication control section 405, and a storage section 401. The storage unit 401 includes, as programs 410, an order slip registration function 411, an order information search condition transmission function 412, an order information reception display function 413, an exchange rate search condition transmission function 414, and an invoice amount (yen currency) reception and display function. 415 and a billing slip registration function 416. The order slip registration function 411 has a function of transmitting order slip registration data input to the display section 402. The order information search condition transmission function 412 has a function of displaying an order information search screen on the display unit 402 and a function of transmitting input search conditions. The order information reception display function 413 receives the order information obtained from the DB server 103 by the order information search function 211 based on the search conditions input by the order information search condition transmission function 412, and displays the order information on the display section 402. Has a function. The exchange rate search condition transmission function 414 has a function of transmitting the search conditions input to the display section 402. The billed amount (yen) reception and display function 415 has a function of acquiring exchange rate information from the DB server 103 using the exchange rate search function 212 based on the search conditions input using the exchange rate search condition transmission function 414 . Further, the billed amount (yen) reception and display function 415 has a function of receiving the content of calculating the billed amount (yen) based on the acquired exchange rate information, and displays the billed amount (yen) on the display section 402. The billing slip registration function 416 has a function of transmitting billing slip registration data input to the display section 402.

FIG. 5 is a diagram showing an example of the data structure of an item master included in the DB server.

The item master 310 is a table that stores, as item values (column values), the item code 501 of the ordered item to be traded, the item name 502 of the ordered item, and the item type 503 of the ordered item. Item master 310 is updated when item name 501 and item type 503 are changed. As shown in FIG. 5, the item master 310 stores an item code 501, an item name 502, and an item type 503 in association with each other. The item code 501 is a number that uniquely identifies the item of the ordered item. Item name 502 is the name of item code 501. The item type 503 manages the characteristics of the ordered item.

As an example, the first line of the item master 310 will be explained. The first line relates to "H0001" as the item code 501 of the ordered product to be traded. In this first line, the item name 502 is "item name 1" and the item type 503 is "product".

FIG. 6 is a diagram showing an example of the data structure of a customer master included in the DB server.

The customer master record 311 includes, as item values (column values), a customer code 601 with which a transaction is made, a customer name 602 as an example of a "contractor", and a rate reservation number of days 603 as an example of a "predetermined period". This is a table that stores . The customer master 311 is updated when the customer name 602 and the number of rate reservation days 603 are changed. As shown in FIG. 6, the customer master 311 stores a customer code 601, a customer name 602, and a rate reservation number of days 603 in association with each other. The customer code 601 is a number that uniquely identifies the customer. The customer name 602 is the name of the customer code 601. The number of days for rate reservation 603 is a lead time that indicates how many days after the shipping date of the ordered product the exchange rate is to be adopted as the official rate when reserving the use of the exchange rate. Note that the customer code 601 may be a customer code, and the customer name 602 may be a customer name. Further, the client terminal 104 may accept a change in the number of reserved days 603 for rate use. Thereby, even if the transaction environment changes, the number of reserved days 603 for rate use can be appropriately set.

As an example, the first line of the customer master 311 will be explained. The first line is related to the customer code 601 "T901". This first line means that the customer name 602 is "Business Partner 1" and the number of exchange rate reservation days 603 is "10 days."

FIG. 7 is a diagram showing an example of the data structure of the exchange rate master included in the DB server.

The exchange rate master 312 is a table that stores exchange rates when converting foreign currencies into yen. The exchange rate master 312 is updated in accordance with daily exchange rate fluctuations. As shown in FIG. 7, the exchange rate master 312 includes a conversion source currency 701, a conversion target currency 702, a conversion rate 703, a valid start date 704, and a valid end date 705 as item values (column values). , are stored in association with each other. The conversion source currency 701, the conversion destination currency 702, and the effective start date 704 are keys that uniquely identify exchange rate information. The conversion source currency 701 is expressed as a transaction currency as an example of a "first currency" in a foreign currency transaction. The conversion destination currency 702 represents a currency that is converted from the conversion source currency 701 into a transaction currency as an example of a "second currency" for managing sales in a foreign currency transaction. The effective start date 704 represents the start date of the effective period of the exchange rate. The valid end date 705 represents the end date of the valid period of the exchange rate. The exchange rate 703 represents the exchange rate within the validity period.

As an example, the first line of the customer master 311 will be explained. The first line is related to the conversion source currency 701 being "USD" and the conversion destination currency 702 being "JPY". This first line means that the conversion rate 703 is "109.55", the effective start date 704 is "2020/01/01", and the effective end date 705 is "9999/12/31".

FIG. 8 is a diagram showing an example of the data structure of a unit price information table included in the DB server.

The unit price information table 313 is a table that stores the unit price of the transaction contract with the customer. The unit price information table 313 is updated when the unit price is changed at the time of unit price contract. As shown in FIG. 8, the unit price information table 313 associates a unit price number 801, customer code 802, item code 803, unit price 804, and currency 805 as item values (column values). Remember. The unit price number 801 is a number that uniquely identifies unit price information. A customer code 802 represents a customer with whom a sales contract has been made for the ordered item. The item code 803 represents the item of the ordered product for which the sales contract has been made. The unit price 804 represents the transaction price of the ordered product at the time of the sales contract. Currency 805 represents the transaction currency at the time of the sales contract.

As an example, the first row of the unit price information table 313 will be explained. The first line relates to a unit price number 801 of "5300001" and a customer code 802 of "T901." This first line means that the item code 803 is "H0001," the unit price 804 is "127.2," and the currency 805 is "USD."

FIG. 9 is a diagram showing a data configuration diagram of an order receipt table included in the DB server.

The order receipt table 314 is a table that stores order receipts. The order receipt table 314 is updated when an order receipt for a business partner is registered. As shown in FIG. 9, the order slip table 314 includes item values (column values) such as order number 901, order details 902, vendor 903, delivery date 904, item 905, order quantity 906, and price. 907, currency 908, and rate reservation 909 are stored in association with each other. The order number 901 is a number that uniquely identifies the order slip. The order details 902 is a number that uniquely identifies the details of the order slip. The order recipient 903 represents the buyer and seller of the ordered item. The delivery date 904 represents the delivery date for buying and selling the ordered product. Item 905 represents the item of the ordered product to be bought and sold. The ordered quantity 906 represents the quantity of ordered items to be bought and sold. The price 907 represents the price of the ordered item to be bought and sold. Currency 908 represents the currency used for buying and selling. Rate reservation 909 indicates whether or not there is a rate reservation after the ordered product is shipped.

As an example, the first row of the order receipt table 314 will be explained. The first line relates to the order number 901 "10001". In this first line, the order details 902 is "10", the customer 903 is "T901", the delivery date 904 is "2019/12/28", the item 905 is "H0001", and the order quantity 906 is "5". ” means that the price 907 is “636.0”, the currency 908 is “USD”, and the rate reservation 909 is “ON”.

FIG. 10 is a diagram showing a data configuration diagram of a billing slip table included in the DB server.

The billing slip table 315 is a table that stores billing slips. The billing slip table 315 is updated when a billing slip is registered based on a delivery note to a business partner. As shown in FIG. 10, the billing slip table 315 includes item values (column values) such as billing number 1001, billing details 1002, billing class 1003, shipping date 1004, order number 1005, and order details 1006. , a shipped quantity 1007, an invoiced amount 1008, an invoiced currency 1009, an invoiced amount (yen) 1010, an official rate date 1011, and a status 1012 are stored in association with each other. The billing number 1001 is a number that uniquely identifies the billing slip. The billing details 1002 is a number that uniquely identifies the details of the billing slip. Billing classification 1003 represents the sales recording classification. The shipping date 1004 represents the date of accounting posting. Order number 1005 represents the order number referenced by the billing number. Order details 1006 represents the order details referenced by the billing number. The shipped quantity 1007 represents the billed quantity for billing to the business partner. The billed amount 1008 represents the amount for the billed quantity. Billing currency 1009 represents the currency for the billing amount. The billed amount (yen) 1010 represents the amount obtained by converting the billed amount in foreign currency into Japanese yen. The official rate date 1011 represents the date when the transaction rate is confirmed. The status 1012 represents the processing status of the target record, and is updated when the target record is processed.

As an example, the first row of the billing slip table 315 will be explained. In the first line, the bill number 1001 is related to "190001". In this first line, the billing details 1002 is "10", the billing class 1003 is "rate reservation", the shipping date 1004 is "2019/12/28", the order number 1005 is "10001", and the order details 1006 is "10", shipping quantity 1007 is "5", billing amount 1008 is "636.0", billing currency 1009 is "USD", billing amount (yen) 1010 is "68662.56", official rate date 1011 is “2020/01/07”, meaning that the status 1012 is “processed”.

FIG. 11 is a diagram showing a data configuration diagram of a calendar information table included in the DB server.

Calendar information table 316 is a table that stores date information. Calendar information table 316 stores system date 1101. System date 1101 represents the current date and is updated when the actual date changes.

As an example, the first row of the calendar information table 316 will be explained. The first line means that the system date 1101 is "2020/1/7".

FIG. 12 is a diagram showing an example of an order slip registration screen provided on a client terminal.

The order receipt registration screen 1200 is displayed on the display unit 402 of the client terminal 104. Into the order slip registration screen 1200, order information for which the user has decided on a contract is input. On the order slip registration screen 1200 shown in FIG. 12, an order number is entered in an input field 1202, a recipient is entered in an input field 1203, a delivery date is entered in an input field 1204, and a rate reservation is entered in an input field 1205. Further, on the order slip registration screen 1200, the order details are entered in the input field 1206, the item is entered in the input field 1207, the order quantity is entered in the input field 1208, the price is entered in the input field 1209, and the currency is entered in the input field 1210, and the register button 1201 is pressed. Then, the order receipt table 314 is updated.

FIG. 13 is a diagram showing an order information search screen included in the client terminal.

Order information search screen 1300 is displayed on display unit 402 of client terminal 104. An order information search is input to the order information search screen 1300. On the order information search screen 1300 shown in FIG. 13, the order number is entered in the input field 1302, and the execution button 1301 is pressed. This starts the order information search process by the order information search function 211 shown in FIG. 16, and transitions to the billing slip registration screen 1400 shown in FIG. 14.

FIG. 14 is a diagram showing a billing slip registration screen included in the client terminal.

Billing slip registration screen 1400 is displayed on display unit 402 of client terminal 104. Billing information is entered into the billing slip registration screen 1400 by the user after shipping is completed. On the billing slip registration screen 1400 shown in FIG. 14, the shipping date is input into the input section 1404, and the rate conversion button 1402 is pressed. As a result, the exchange rate search process by the exchange rate search function 212 shown in FIG. 19 is started. The exchange rate search function 212 acquires an exchange rate and displays the billing amount (in yen) calculated using the acquired exchange rate. When the registration button 1401 on the billing slip registration screen 1400 shown in FIG. 14 is pressed, the billing slip table is updated.

FIG. 15 is a flowchart showing the order slip registration process by the order slip registration function provided in the client terminal.

The order slip registration function 411 acquires the order information input on the order information registration screen 1200 (FIG. 12). The order information includes an order number 1202, a customer 1203, a delivery date 1204, a rate reservation 1205, an order details 1206, an item 1207, an order quantity 1208, a price 1209, and a currency 1210. The order receipt registration function 411 transmits the acquired order information to the AP server 102 and updates the order receipt table 314 (S1501).

FIG. 16 is a flowchart showing order information search condition transmission processing by the order information search condition transmission function provided in the client terminal.

The order information search condition transmission function 412 acquires the order number 1302 input on the order information search screen 1300 (FIG. 13) and transmits it to the AP server 102 (S1601).

FIG. 17 is a flowchart showing order information search processing by the order information search function provided in the AP server.

The order information search function 211 receives the value of the order number 1302 transmitted from the client terminal 104 (S1701). Next, the order information search function 211 searches the order number 901 in the order slip table 314 using the received order number 1302 as a key, and extracts the order information of the corresponding record (S1702). Next, the order information search function 211 transmits the extracted order information to the client terminal 104 (S1703).

FIG. 18 is a flowchart showing order information reception and display processing by the order information reception and display function provided in the client terminal.

The order information reception display function 413 receives the order information transmitted from the AP server 102 (S1801). The order information includes the order recipient 1405, rate reservation 1406, order number 1407, order details 1408, item 1409, billing quantity 1410, billing amount 1411, and billing currency 1412. Next, the order information reception display function 413 displays the received order information on the display unit 402 (billing slip registration screen 1400) (S1802).

FIG. 19 is a flowchart showing exchange rate search condition transmission processing by the exchange rate search condition transmission function provided in the client terminal.

The exchange rate search condition sending function 414 acquires the shipping date 1404, the billing amount 1411, and the billing currency 1412 input on the billing slip registration screen 1400 (FIG. 14), and transmits them to the AP server 102 (S1901).

FIG. 20 is a flowchart showing exchange rate search processing by the exchange rate search function provided by the AP server.

The exchange rate search function 212 receives the values of the shipping date 1404, billing amount 1411, and billing currency 1412 transmitted from the client terminal 104 (S2001). Next, the exchange rate search function 212 uses the received shipping date 1404 and billing currency 1412 as keys to search for the conversion source currency 701, valid start date 704, and valid end date 705 in the exchange rate master 312, and searches for the corresponding The conversion rate of the record is acquired (S2002). Next, the exchange rate search function 212 multiplies the acquired exchange rate by the received billed amount 1411 (S2003). Next, the exchange rate search function 212 transmits the multiplication result to the client terminal 104 as the billed amount (yen) 1010 (S2004).

FIG. 21 is a flowchart showing the billed amount (yen coin) reception and display processing by the billed amount (yen coin) reception and display function of the client terminal.

The billed amount (yen) reception display function 415 receives the billed amount (yen) 1413 transmitted from the AP server 102 (S2101). The billed amount (yen) reception display function 415 displays the received billed amount (yen) 1413 on the display unit 402 (billing slip registration screen 1400) (S2102).

FIG. 22 is a flowchart showing the billing slip registration process by the billing slip registration function provided in the client terminal.

The billing slip registration function 416 acquires billing information input from the billing slip registration screen 1400 (FIG. 14). The billing information includes billing number 1403, shipping date 1404, supplier 1405, rate reservation 1406, order number 1407, order details 1408, item 1409, billing quantity 1411, billing amount 1411, billing currency 1412, and billing amount (yen) 1413. be. The billing slip registration function 416 transmits the acquired billing information to the AP server 102 and updates the billing slip table 315 of the DB server 102 (step S2201).

FIG. 23 is a flowchart showing official rate date calculation processing by the official rate date calculation function provided in the AP server.

The official rate date calculation function 213 acquires the value of the system date 1101 from the calendar information table 316 upon regular activation. (S2301). Next, the official rate date calculation function 213 searches the shipping date 1004 of the billing slip table 315 using the acquired system date 1101 as a key, and searches for the order number 1005, order details 1006, and official rate date 1011 of the corresponding record. (S2302). Next, if the official rate date 1011 of the extracted record is not set (S2303: YES), the official rate date calculation function 213 searches the order slip table 314 using the order number 1005 and order details 1006 as keys, The order recipient 903 and rate reservation 909 of the corresponding record are acquired (S2304). If the official rate date of the extracted record is set (S2303: NO), the official rate date calculation function 213 moves to the next record.

Next, if the value of the acquired rate reservation 909 is set to ON (S2305: YES), the official rate date calculation function 213 uses the extracted customer 903 as a key to calculate the customer code 601 of the customer master 311. is searched and the rate reservation days 603 of the corresponding customer master 311 is obtained (S2306). Next, the official rate date calculation function 213 adds the number of rate reservation days 603 acquired from the customer master 311 to the shipping date 1004 of the billing slip table 315 to calculate the official rate date (S2307). If the value of the rate reservation 909 is set to OFF (S2305: NO), the official rate date calculation function 213 adds 0 to the shipping date 1004 of the billing slip table 315 to calculate the official rate date (S2308 ). Next, the official rate date calculation function 213 transmits the calculated official rate date to the AP server 102, and updates the official rate date 1011 in the billing slip table 315 of the DB server 102 (S2309).

FIG. 24 is a flowchart showing additional billing slip registration processing by the additional billing slip registration function provided by the AP server.

The additional billing slip registration function 214 acquires the value of the system date 1101 from the calendar information table 316 at regular activation (S2401). Next, the additional billing slip registration function 214 searches the official rate date 1011 of the billing slip table 315 using the acquired system date 1101 as a key, and extracts the billing amount 1008 and billing currency 1009 of the corresponding record ( S2402).

Next, the additional billing slip registration function 214 uses the acquired official rate date 1101 and billing currency 1009 as keys to set the conversion source currency 701, valid start date 704, and valid end date 705 of the exchange rate master 312. Search and obtain the conversion rate 703 of the corresponding record within the validity period (S2403). Next, the additional billing slip registration function 214 multiplies the billing amount 1008 in the billing slip table 315 by the conversion rate 703 obtained from the exchange rate master 312 to calculate the billing amount (in yen) (S2404). Next, the additional billing slip registration function 214 subtracts the billing amount (yen) 1010 of the billing slip table 315 from the billing amount (yen) calculated in S2404, and calculates the difference (S2405). Next, the additional billing slip registration function 214 updates the status 1012 of the acquired billing slip table 315 to Processed. Next, the additional billing slip registration function 214 transmits the difference calculated in S2404 to the AP server 102, and additionally updates the billing slip table 315 of the DB server 102 (2406). Next, the additional billing slip registration function 214 updates the status 1012 of the acquired billing slip table 315 to Processed (S2407).

The additional billing slip registration function 214 updates the status 1012 of the acquired billing slip table 315 to processed, then sends the difference calculated in S2404 to the AP server 102 and adds it to the billing slip table 315 of the DB server 102. May be updated.

According to this configuration, the exchange rate usage reservation system 100 includes a client terminal 104, a DB server 103, and an AP server 102. The client terminal 104 calculates sales for each ordered item using the item 1207 of the ordered item, the ordered quantity 1208 of the ordered item, and the exchange rate 10 days after the rate reservation days 603 have passed from the shipping date of the ordered item. Input of rate reservation 1205 is accepted. The DB server 103 stores an order slip table 314 that includes an item 905 of the ordered product, an ordered quantity 906, and a rate reservation 909, and a customer master 311 that includes the number of days for rate reservation 603. The AP server 102 calculates provisional sales for each ordered product using the exchange rate on the shipping date of the ordered product when shipping the ordered product, and calculates provisional sales for each ordered product after the 10th day using the exchange rate 10 days later. Confirmed sales are calculated, the difference between confirmed sales and provisional sales for each ordered item for which input of rate reservation 1205 has been accepted is calculated, and an adjustment slip for the calculated difference is created.

This makes it possible to further reduce the burden on those in charge of transactions with foreign countries, and to confirm sales at an early stage.

An order slip registration screen 1200 is displayed on the client terminal 104, which accepts input of the item 1207 of the ordered product, the ordered quantity 1208, the customer 1203, and the rate usage reservation 1205. Thereby, the contents to be registered in the order receipt table 314 can be confirmed on one screen.

An embodiment of the present invention has been described above. According to the above embodiment, a certain effect can be achieved regardless of the software used, and prompt sales confirmation by field workers can be realized. Further, the present invention is not limited to this, and various changes can be made without departing from the gist thereof.

When the client terminal 104 receives a rate reservation 1205 for a customer 602 whose rate reservation days 603 is stored in the DB server 103, the client terminal 104 displays on the order receipt registration screen 1200 that the input of the rate reservation 1205 has been accepted. good. This saves the effort of inputting rate reservations.

The AP server 102 may calculate the final sales for each ordered item after 10 days using the exchange rate after 10 days. This allows you to confirm sales as quickly as possible.

In the above embodiment, the rate reservation number of days 603 was 10 days. The rate reservation number of days 603 is not limited to this, and may be from one day to several months.

100... Exchange rate usage reservation system, 102... AP server, 103... DB server, 104... Client terminal, 311... Customer master, 314... Order slip table, 602... Customer, 603... Rate reservation days, 905... Item, 906...Order quantity, 909...Rate reservation, 1200...Order slip registration screen, 1205...Rate reservation, 1207...Item, 1208...Order quantity

Claims (7)

An exchange rate usage reservation that calculates the sales for each ordered item using the ordered item, the ordered quantity of the ordered item, and the exchange rate on the day when a predetermined period has passed from the shipping date of the ordered item. An information terminal that accepts input,
a storage unit that stores an order receipt including the ordered product and the ordered quantity, the exchange rate usage reservation, and the predetermined period;
At the time of shipping the ordered item, the exchange rate on the shipping date of the ordered item is used to calculate provisional sales for each ordered item, and after the predetermined period elapses, the exchange rate on the day when the predetermined period elapses is used to calculate the a calculation unit that calculates the confirmed sales for each ordered item, calculates the difference between the confirmed sales and the provisional sales for each ordered item for which the input of the exchange rate usage reservation has been received, and creates an adjustment slip for the calculated difference; An exchange rate usage reservation system comprising; The storage unit stores the predetermined period for each customer of the ordered product,
The information terminal receives a change to the predetermined period stored in the storage unit,
The exchange rate usage reservation system according to claim 1. The information terminal displays an order slip registration screen that accepts input of the ordered product, the ordered quantity, the order destination, and the exchange rate reservation.
The exchange rate usage reservation system according to claim 2. When the information terminal receives the exchange rate usage reservation from the customer for which the predetermined period is stored in the storage unit, the information terminal displays on the order receipt registration screen that the input of the exchange rate usage reservation has been accepted. do,
The exchange rate usage reservation system according to claim 3. The calculation unit calculates the confirmed sales for each ordered item using the exchange rate on the day when the predetermined period has elapsed.
The exchange rate usage reservation system according to claim 1. An exchange rate usage reservation method using an exchange rate usage reservation system, the method comprising:
The exchange rate usage reservation system is
An exchange rate usage reservation that calculates the sales for each ordered item using the ordered item, the ordered quantity of the ordered item, and the exchange rate on the day when a predetermined period has passed from the shipping date of the ordered item. accept input,
storing an order receipt including the ordered product and the ordered quantity, the exchange rate usage reservation, and the predetermined period;
Calculate provisional sales for each ordered item using the exchange rate on the shipping date of the ordered item at the time of shipping the ordered item,
After the elapsed date of the predetermined period, the finalized sales for each ordered product are calculated using the exchange rate on the day the predetermined period has elapsed, and the finalized sales and the A reservation method using exchange rates that calculates the difference in provisional sales and creates an adjustment slip for the calculated difference. A program to be executed by an exchange rate usage reservation system,
In the exchange rate usage reservation system,
An exchange rate usage reservation that calculates the sales for each ordered item using the ordered item, the ordered quantity of the ordered item, and the exchange rate on the day when a predetermined period has passed from the shipping date of the ordered item. a step of accepting input;
storing an order receipt including the ordered product and the ordered quantity, the exchange rate usage reservation, and the predetermined period;
calculating provisional sales for each ordered item using the exchange rate on the shipping date of the ordered item when shipping the ordered item;
After the elapsed date of the predetermined period, the finalized sales for each ordered product are calculated using the exchange rate on the day the predetermined period has elapsed, and the finalized sales and the An exchange rate usage reservation program that executes the steps of calculating a difference in provisional sales and creating an adjustment slip for the calculated difference for each customer.

Images