Exchange rate management device, exchange rate management method, and exchange rate management program

Abstract

To provide a conversion rate management device, a conversion rate management method, and a conversion rate management program capable of setting the conversion rate from foreign currency to yen currency according to the purpose for each slip.SOLUTION: A conversion rate management device according to the present embodiment includes: slip input means for inputting various slips; and conversion rate setting means for setting the conversion rate from foreign currency to yen currency. The conversion rate setting means is configured to be able to set the conversion rate to be applied for each slip in accordance with the purpose.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to an exchange rate management device, an exchange rate management method, and an exchange rate management program. Regarding. [Background technology]

[0002] For example, when registering actual results (e.g., orders, sales, purchases, etc.) denominated in foreign currency, conversion to yen is required. When converting to yen, exchange rates differ for each currency. For example, Patent Document 1 discloses a system for managing exchange rates. [Prior art documents] [Patent documents]

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

[0004] However, Patent Document 1 does not disclose anything about constructing a mechanism that allows the conversion rate from foreign currency to yen to be set according to the purpose for each slip.

[0005] The present invention has been made in consideration of the above problems, and aims to provide an exchange rate management device, an exchange rate management method, and an exchange rate management program that are capable of setting the conversion rate from foreign currency to yen according to the purpose for each voucher. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the present invention provides an exchange rate management device equipped with a control unit, the control unit comprising a voucher input means for inputting various vouchers, and an exchange rate setting means for setting the conversion rate from foreign currency to Japanese yen, and the exchange rate setting means is configured to be able to set the conversion rate to be applied for each voucher in accordance with the objective.

[0007] According to another aspect of the present invention, the various types of slips may be at least one of an order slip, a sales slip, an order slip, and a purchase slip.

[0008] According to one embodiment of the present invention, the exchange rate setting means may be configured to allow three types of setting: automatic setting using an exchange rate set in a master, setting of a spot rate manually input by an operator, and allocation of a forward exchange rate.

[0009] According to another aspect of the present invention, in the master, the rate categories of the conversion rate may be set separately for each currency.

[0010] According to another aspect of the present invention, the master may be capable of setting a rate category of the conversion rate to be set for each slip.

[0011] According to another aspect of the present invention, the rate categories may include an in-house rate and a TTM rate.

[0012] In addition, in order to solve the above-mentioned problems and achieve the objective, the present invention provides an exchange rate management method executed by an information processing device equipped with a control unit, and includes a voucher input process executed by the control unit for inputting various vouchers, and an exchange rate setting process for setting a conversion rate from a foreign currency to Japanese yen, and is characterized in that the exchange rate setting process is configured to enable the conversion rate to be applied for each voucher to be set according to the purpose.

[0013] In addition, in order to solve the above-mentioned problems and achieve the objective, the present invention provides an exchange rate management program to be executed by an information processing device equipped with a control unit, the control unit executing a voucher input process for inputting various vouchers, and an exchange rate setting process for setting a conversion rate from a foreign currency to Japanese yen, and the exchange rate setting process is configured to enable the conversion rate to be applied to each voucher to be set according to the purpose. Effect of the Invention

[0014] According to the present invention, it is possible to set the conversion rate from foreign currency to yen according to the purpose for each slip. [Brief description of the drawings]

[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an exchange rate management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the currency master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the configuration of the rate master. [Figure 4] FIG. 4 is a diagram for explaining a specific example 1 of the process of the control unit of the exchange rate management device in the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining specific example 2 of the process of the control unit of the exchange rate management device in the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example 3 of the process of the control unit of the exchange rate management device in the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example 3 of the process of the control unit of the exchange rate management device in the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example 3 of the process of the control unit of the exchange rate management device in the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0017] [1. Overview] When registering foreign currency denominated results (for example, orders, sales, purchases, etc.) in the core system, conversion to yen is required. When converting to yen, the exchange rate differs for each currency.

[0018] However, in the previous function, only the exchange rate at the time of the contract could be applied from receipt of orders to sales (ordering to purchase), and the range of exchange gains and losses at the time of settlement was large, which was a hindrance to accurate sales and profit forecasts. Also, until now, only one rate category could be used from receipt of orders to sales, and different exchange valuation settings were not possible.

[0019] Specifically, at the time of receiving or placing an order, the rate to be applied may not be clear (recording schedule is not yet determined). Also, the amount converted into yen may vary depending on the foreign currency rate used as the base for yen conversion, and the rules for the yen conversion rate to be applied may differ for each document (order, sales, purchase, procurement).

[0020] Therefore, in this embodiment, a mechanism has been created that allows the conversion rate from foreign currency to yen to be set and stored according to the purpose for each slip.

[0021] Specifically, in this embodiment, (1) it is equipped with a function to set and store rates according to the purpose for each document, (2) the acquisition of exchange rates can be set in three ways: automatically acquired from the rate master, manually setting a spot rate, or allocating a forward exchange rate, (3) the initial rate categories to be used for orders / sales and purchases / orders can be set separately by currency, and (4) when registering orders through sales, the rate category to be set can be switched in the master settings.

[0022] As a result, (1) it is possible to manage the changes in sales and gross profit due to exchange rate fluctuations between the time of order and the time of sales. (2) By using different rate categories, it is possible to initially set and change the conversion rate type at the time of order and the time of sales. (3) By recalculating the sales amount based on the exchange rate at the time of sales, it is possible to grasp the correct sales amount and gross profit amount and reduce the fluctuation of exchange gain / loss at the time of settlement. (4) When entering orders and sales, a rate category different from that at the time of order can be automatically initially set according to the master settings, making it easy to operate with different rate categories.

[0023] Examples of how this embodiment can be used include: (1) order slips need to be tallied in yen to compare order performance / actual forecasts by department and person in charge, but there are cases where it is desirable to apply a uniform in-house rate that is not affected by fluctuations in exchange rates; (2) sales and purchase slips are reflected in the balance sheet as accounts receivable / accounts payable balances, so there are cases where it is desirable to apply the prevailing exchange rate to convert to yen more accurately. This is because it is desirable to apply the prevailing exchange rate to both sales and cost in order to grasp accurate gross profit.

[0024] [2. Configuration] An example of the configuration of the exchange rate management device 100 according to the present embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the exchange rate management device 100.

[0025] The exchange rate management device 100 is a commercially available desktop personal computer. Note that the exchange rate 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.

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

[0027] The communication interface unit 104 communicatively connects the exchange rate 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 communicatively connecting the exchange rate management device 100 and the server 200, and is, for example, the Internet or a LAN (Local Area Network).

[0028] The input device 112 and the output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function, and the input device 112 inputs information via the input / output interface unit 108 in response to an operator's operation. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. In addition, "output" refers to outputting from the output device 114, and includes, for example, display output to the monitor 114, print output from the printer 114, and transmission of data to the outside.

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

[0030] The storage unit 106 includes a currency master 106a, a rate master 106b, and a data file 106c. Fig. 2 is a diagram showing an example of the configuration of the currency master 106a. Fig. 3 is a diagram showing an example of the configuration of the rate master 106b.

[0031] As shown in Fig. 2, the currency master 106a can be configured with tables for registering data on the base currency, revision date, initial order rate, initial sales rate, initial order rate, and initial purchase rate in association with each other. In the currency master 106a, the rate category of the conversion rate can be set by currency. In addition, the rate category of the conversion rate set for each slip can be set. The rate categories are the in-house rate and TTM (current rate).

[0032] As shown in FIG. 3, the rate master 106b can be configured as a table or the like in which data on rate categories, revision dates, currencies, and rates are registered in association with each other.

[0033] Data file 106c is a file for storing various types of slips (for example, order slips (hereinafter referred to as "order data"), sales slips (hereinafter referred to as "sales data"), deposit slips (hereinafter referred to as "deposit data"), purchase slips (hereinafter referred to as "order data"), and purchase slips (hereinafter referred to as "purchase data").

[0034] The order data may include data such as the order number, product, order quantity, order date, foreign currency amount, expected sales date, yen amount, conversion rate, cost amount, and gross profit amount.The sales data may include data on the sales number, product, sales quantity, shipping date, foreign currency amount, sales date, yen amount, conversion rate, cost amount, and gross profit amount.The deposit data may include data on the deposit number, foreign currency deposit amount, deposit date, yen application amount, settlement rate, and exchange gain / loss.

[0035] The control unit 102 is a CPU or the like that performs overall control of the exchange rate 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 functional concepts, the control unit 102 includes a slip input unit 102a, an exchange rate setting unit 102b, a master maintenance unit 102c, and a screen display control unit 102d.

[0036] The slip input unit 102a inputs various slips (order data, sales data, deposit data, order data, purchase data, etc.) in response to, for example, operations performed by an operator via the input device 112 on an input screen displayed on the monitor 114, and stores the input data in a data file 106c.

[0037] The exchange rate setting unit 102b is for setting the exchange rate from foreign currency to yen, and is configured to be able to set the exchange rate to be applied to each slip according to the purpose. The exchange rate setting unit 102b sets the exchange rate to be applied to the order data, sales data, deposit data, order data, and purchase data. In this case, the exchange rate setting unit 102b can set three types of exchange rates: (1) automatic setting using the exchange rate set in the currency master 106a and the rate master 106b, (2) setting of a spot rate manually input by the operator, and (3) allocation of a forward exchange rate.

[0038] The master maintenance unit 102c performs editing such as inputting, adding, and changing data for the currency master 106a and the rate master 106b in response to an operator's operation via the input device 112 on a master maintenance screen (not shown) displayed on the monitor 114.

[0039] The screen display control unit 102d controls the display and input of various screens (eg, an order input screen, a sales input screen, a deposit input screen, an order input screen, a purchase input screen, a master maintenance screen, etc.) displayed on the monitor 114.

[0040] [3. Specific Examples] Specific examples of processing by control unit 102 of exchange rate management device 100 in this embodiment will be described with reference to Figs. 1 to 11. Fig. 4 is a diagram for explaining specific example 1. Fig. 5 is a diagram for explaining specific example 2. Figs. 6 to 8 are diagrams for explaining specific example 3. In the following example, a case will be described in which the conversion rates for orders and sales are automatically set according to the settings of the currency master 106a and the rate master 106b, and the conversion rate for deposits is set at the spot rate.

[0041] (Example 1) Specific example 1 will be described with reference to Fig. 4. In specific example 1, a case where data is managed in the same rate category will be described. Fig. 4(A) shows the process flow from order receipt, sales, and payment, as well as examples of order data, sales data, and payment data. Fig. 4(B) shows an example of registration of currency master 106a, and Fig. 4(C) shows an example of registration of rate master 106b.

[0042] In the example of currency master 106a shown in Figure 4 (B), the first line has the currency "JPY", revision date "2000 / 1 / 1", initial order rate "in-house rate", initial sales rate "in-house rate", initial order rate "in-house rate", and initial purchase rate "in-house rate", the second line has the currency "USD", revision date "2000 / 1 / 1", initial order rate "TTM", initial sales rate "TTM", initial order rate "TTM", and initial purchase rate "TTM", and the third line has the currency "EUR", revision date "2000 / 1 / 1", initial order rate "TTM", initial sales rate "TTM", initial order rate "TTM", and initial purchase rate "TTM".

[0043] In the example of rate master 106b shown in Figure 4 (C), the first line has rate category "TTM", revision date "2020 / 4 / 1", currency "USD", and rate "105.00", the second line has rate category "TTM", revision date "2020 / 5 / 1", currency "USD", and rate "106.00", and the third line has rate category "TTM", revision date "2020 / 6 / 1", currency "USD", and rate "107.00".

[0044] In FIG. 4(A), order input (step S1) is performed to input order data. For example, at the order receiving stage, the exchange rate setting unit 102b automatically sets "TTM" as the exchange rate set in the currency master 106a and the rate master 106b. This allows the yen-denominated sales and gross profit to be grasped at the rate conversion based on the order receiving date. Specifically, the initial order rate "TTM" is obtained from the currency master 106a using the currency "USD" as a key, and the exchange rate "105.00" is obtained and set from the rate master 106b using the rate category "TTM" and the order receiving date "2020 / 4 / 1" as keys.

[0045] In the example shown in Figure 4(A), the order data includes the order number "JU00001", order quantity "20 PCE", order date "2020 / 4 / 1", foreign currency amount "$1,000", expected sales date "2020 / 5 / 31", Japanese yen amount "￥105,000", conversion rate "105.00", cost amount "￥65,000", and gross profit amount "￥40,000".

[0046] Next, sales input (step S2) is performed to input sales data. The exchange rate setting unit 102b automatically sets "TTM" as the exchange rate set in the currency master 106a and the rate master 106b. This allows for a more accurate understanding of yen-denominated sales and gross profit by reconverting at the rate at the time of sales. Specifically, the initial sales rate "TTM" is obtained from the currency master 106a using the currency "USD" as a key, and the exchange rate "107.00" is obtained and set from the rate master 106b using the rate category "TTM" and the sales date "2020 / 6 / 1" as keys.

[0047] In the example shown in Figure 4(A), the sales data is as follows: sales number "UR00001", sales quantity "20 PCE", shipping date "2020 / 5 / 31", foreign currency amount "$1000", sales date "2020 / 6 / 1", Japanese yen amount "￥107,000", conversion rate "107.00", cost amount "￥65,000", and gross profit amount "￥42,000".

[0048] Next, the deposit input (step S3) is performed to input the deposit data. For example, the exchange rate setting unit 102b sets the spot rate "106.80" as the exchange rate in response to the input operation of the operator.

[0049] In the example shown in Figure 4 (A), the deposit data is as follows: deposit number "NY00001," foreign currency deposit amount "$500," deposit date "2020 / 6 / 30," yen application amount "￥53,400," settlement rate "106.80," and exchange rate gain / loss "-￥100."

[0050] (Example 2) Specific example 2 will be described with reference to Fig. 5. In specific example 2, a case where management is performed using different rate classes will be described. Fig. 5(A) shows a process flow from order receipt, sales, and payment, as well as examples of order data, sales data, and payment data. Fig. 5(B) shows an example of registration of currency master 106a, and Fig. 5(C) shows an example of registration of rate master 106b.

[0051] In the example of currency master 106a shown in Figure 5 (B), the first line has the currency "JPY", revision date "2000 / 1 / 1", initial order rate "in-house rate", initial sales rate "in-house rate", initial order rate "in-house rate", and initial purchase rate "in-house rate", the second line has the currency "USD", revision date "2000 / 1 / 1", initial order rate "in-house rate", initial sales rate "TTM", initial order rate "in-house rate", and initial purchase rate "TTM", and the third line has the currency "EUR", revision date "2000 / 1 / 1", initial order rate "in-house rate", initial sales rate "TTM", initial order rate "in-house rate", and initial purchase rate "TTM".

[0052] In the example of rate master 106b shown in Figure 5 (C), the first line has the rate category "company rate", revision date "2020 / 4 / 1", currency "USD", and rate "103.50", the second line has the rate category "TTM", revision date "2020 / 4 / 1", currency "USD", and rate "105.00", the third line has the rate category "TTM", revision date "2020 / 5 / 1", currency "USD", and rate "106.00", and the fourth line has the rate category "TTM", revision date "2020 / 6 / 1", currency "USD", and rate "107.00".

[0053] In FIG. 5(A), order input (step S11) is performed to input order data. For example, the exchange rate setting unit 102b automatically sets the "company rate" with the exchange rate set in the currency master 106a and the rate master 106b. This makes it easier to manage the comparison of forecast and actual results in yen currency throughout the year, since order data is accumulated at the company rate determined for each fiscal year. Specifically, the initial order rate "company rate" is obtained from the currency master 106a using the currency "USD" as a key, and the exchange rate "103.50" is obtained from the rate master 106b using the rate class "company rate" as a key, and set.

[0054] In the example shown in Figure 5 (A), the order data consists of the order number "JU00001", order quantity "20 PCE", order date "2020 / 4 / 1", foreign currency amount "$1,000", expected sales date "2020 / 5 / 31", Japanese yen amount "￥103,500", conversion rate "103.5 (applied internal rate)", cost amount "￥65,000", and gross profit amount "￥38,500".

[0055] Next, sales input (step S12) is performed to input sales data. The conversion rate setting unit 102b automatically sets "TTM" at the conversion rate set in the currency master 106a and the rate master 106b. This allows accurate understanding of accounts receivable, sales, and profits using the most recent conversion rate for sales data. Specifically, the initial sales rate "TTM" is obtained from the currency master 106a using the currency "USD" as a key, and the conversion rate "107.00" is obtained and set from the rate master 106b using the rate category "TTM" and sales date "2020 / 6 / 1" as keys.

[0056] In the example shown in Figure 5 (A), the sales data is as follows: sales number "UR00001", sales quantity "20 PCE", shipping date "2020 / 5 / 31", foreign currency amount "$1000", sales date "2020 / 6 / 1", Japanese yen amount "￥107,000", conversion rate "107.00", cost amount "￥65,000", and gross profit amount "￥42,000".

[0057] 5A, deposit input (step S13) is performed to input deposit data. For example, the exchange rate setting unit 102b sets the spot rate "106.80" as the exchange rate in response to an input operation by the operator.

[0058] In the example shown in Figure 5 (A), the deposit data is as follows: deposit number "NY00001," foreign currency deposit amount "$500," deposit date "2020 / 6 / 30," yen application amount "￥53,400," settlement rate "106.80," and exchange gain / loss "-￥100."

[0059] (Example 3) 6 to 8, a concrete example 3 will be described. In the concrete example 3, a screen display example will be described. The screen display example of the concrete example 3 has contents corresponding to those of the concrete example 2.

[0060] 6 is a diagram showing a display example of an order entry screen, on which order data can be entered.

[0061] The example of the order input screen shown in Figure 6 has a header area with input fields for the order number, base date, order date, delivery date, expected sales date, customer, base currency, and exchange rate, a foreign currency information button for displaying a foreign currency information confirmation screen, a details area for inputting details of the slip (product, sales price, sales amount, order quantity, cost amount, gross profit amount), and an area for displaying the total of the foreign currency amount and the yen amount. The conversion rate is automatically displayed as the value set in the currency master 106a and rate master 106b, and calculations are performed using this conversion rate. When the registration button (not shown) is pressed, Order data corresponding to the data on the screen is registered in the data file 106c.

[0062] When the foreign currency information button is pressed, a foreign currency information confirmation screen is displayed, and the exchange rate setting can be confirmed. For example, the initial order rate "company rate" for the base currency "USD" is obtained by setting the currency master 106a shown in Fig. 5(B), and the company rate "103.50" at the time of order "2020 / 4 / 1" is obtained and set from the rate master 106b shown in Fig. 5(C). Here, the setting is to obtain the company rate set annually at the time of order.

[0063] FIG. 7 is a diagram showing a display example of a sales input screen. In the sales input screen, sales data can be input. In the example of the order input screen shown in FIG. 7, there are input fields for the sales number, the order number, the base date, the shipping date, the delivery date, the sales date, the customer, the base currency, and the conversion rate, a header area having a foreign currency information button for displaying a foreign currency information confirmation screen, a details area for inputting details of the slip (product, sales price, sales amount, sales quantity, cost amount, gross profit amount), and an area for displaying the total of the foreign currency amount and the yen amount. The conversion rate is automatically displayed as a value set in the currency master 106a and the rate master 106b, and calculations are performed using this conversion rate. When a registration button (not shown) is pressed, the sales data corresponding to the data on the screen is registered in the data file 106c.

[0064] When the foreign currency information button is pressed, a foreign currency information confirmation screen is displayed, allowing the user to confirm the conversion rate setting. For example, the initial sales rate "TTM" for the base currency "USD" is obtained by setting the currency master 106a shown in FIG. 5(B), and the TTM rate "107.00" at the time of sales "2020 / 6 / 1" is obtained and set from the rate master 106b shown in FIG. 5(C). At the time of sales, conversion is performed using the most recently set rate. At this point, the rate can be reset, allowing for more precise yen sales and gross profit.

[0065] 8 is a diagram showing a display example of a deposit input screen. On the deposit input screen, deposit data can be input.

[0066] The example of the deposit input screen shown in Fig. 8 has a header area with input fields for deposit number, base date, deposit date, billing destination, base currency, and spot exchange rate, a details area for entering voucher details (voucher number, product, scheduled collection date, sales amount, and clearing amount), and an area displaying the total of the billing amount, clearing amount, yen clearing amount, and difference in profit and loss. The operator manually inputs the conversion rate, and calculations are performed using this conversion rate. When a registration button (not shown) is pressed, deposit data corresponding to the data on the screen is registered in the data file 106c. The difference between the yen-converted amount at the conversion rate at the time of sales and the yen-converted amount at the conversion rate at the time of deposit is recognized as exchange difference in profit and loss.

[0067] Although the conversion rate is set as a spot rate here, it can also be automatically set to a value set in the currency master 106a and the rate master 106b at the time of deposit.

[0068] As described above, in this embodiment, there is a voucher input unit 102a that inputs various vouchers, and a conversion rate setting unit 102b that sets the conversion rate from foreign currency to yen. Since the conversion rate setting unit 102b is configured so that the conversion rate to be applied to each voucher can be set according to the purpose, it becomes possible to set the conversion rate from foreign currency to yen for each voucher according to the purpose.

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

[0070] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

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

[0072] Moreover, with regard to the exchange rate management device 100, each of the components shown in the figures is merely a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0073] For example, the processing functions of the exchange rate 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 includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the exchange rate management device 100 as necessary. 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 HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

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

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

[0076] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0077] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0078] The exchange rate 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 exchange rate management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.

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

[0080] 100 Exchange Rate Control Device 102 Control section 102a Voucher input section 102b Exchange rate setting section 102c Master Maintenance Department 102d Screen display control unit 104 Communication interface section 106 Storage section 106a Currency Master 106b Rate Master 106c Data File 200 Servers 300 Network

Claims

1. An exchange rate management device including a storage unit and a control unit, The storage unit includes: A currency master in which a base currency, an initial rate for receiving orders or placing orders, and an initial rate for sales or purchases are associated and registered; The rate master is a registered combination of rate class, revision date, currency, and currency rate. is stored, The control unit is A slip input means for inputting a receipt or order slip and a sales or purchase slip; A conversion rate setting means for setting a conversion rate from a foreign currency to Japanese yen; Equipped with The conversion rate setting means In the case of an order or purchase order slip, an initial rate for the order or purchase is obtained from the currency master using the currency of the order or purchase order slip as a key, and a conversion rate is obtained from the rate master using the obtained initial rate for the order or purchase order and the contract date of the order or purchase order slip as keys, and set the conversion rate; In the case of a sales or purchase invoice, the exchange rate management device obtains an initial sales or purchase rate from the currency master using the currency of the sales or purchase invoice as a key, and obtains and sets a conversion rate from the rate master using the obtained initial sales or purchase rate and the recording date of the sales or purchase invoice as keys.

2. The conversion rate setting means further comprises:

2. The exchange rate management device according to claim 1, wherein the device is configured so that an operator can manually input a spot rate or a forward exchange rate allocation.

3. The control unit further comprises:

3. The exchange rate management device according to claim 1, further comprising a means for calculating the difference between the yen-equivalent amount converted at the exchange rate at the time of sale and the yen-equivalent amount converted at the deposit rate at the time of deposit as exchange gain or loss.

4. A method for managing exchange rates executed by an information processing device having a storage unit and a control unit, comprising: The storage unit includes: A currency master in which a base currency, an initial rate for receiving orders or placing orders, and an initial rate for sales or purchases are associated and registered; The rate master is a registered combination of rate class, revision date, currency, and currency rate. is stored, Executed in the control unit, A slip input process for inputting an order receipt or purchase slip and a sales or purchase slip; A conversion rate setting step of setting a conversion rate from the foreign currency to the Japanese yen; Including, In the conversion rate setting step, In the case of an order or purchase order slip, an initial rate for the order or purchase is obtained from the currency master using the currency of the order or purchase order slip as a key, and a conversion rate is obtained from the rate master using the obtained initial rate for the order or purchase order and the contract date of the order or purchase order slip as keys, and set the conversion rate; In the case of a sales or purchase invoice, the method for managing exchange rates is characterized in that an initial sales or purchase rate is obtained from the currency master using the currency of the sales or purchase invoice as a key, and a conversion rate is obtained from the rate master using the obtained initial sales or purchase rate and the posting date of the sales or purchase invoice as keys, and then set.

5. A conversion rate management program for execution by an information processing device having a memory unit and a control unit, The storage unit includes: A currency master in which a base currency, an initial rate for receiving orders or placing orders, and an initial rate for sales or purchases are associated and registered; The rate master is a registered combination of rate class, revision date, currency, and currency rate. is stored, The control unit, A slip input process for inputting an order receipt or purchase slip and a sales or purchase slip; A conversion rate setting step of setting a conversion rate from the foreign currency to the Japanese yen; This is an exchange rate management program for executing In the conversion rate setting step, In the case of an order or purchase order slip, an initial rate for the order or purchase is obtained from the currency master using the currency of the order or purchase order slip as a key, and a conversion rate is obtained from the rate master using the obtained initial rate for the order or purchase order and the contract date of the order or purchase order slip as keys, and set the conversion rate; In the case of a sales or purchase invoice, the exchange rate management program obtains an initial sales or purchase rate from the currency master using the currency of the sales or purchase invoice as a key, and obtains and sets a conversion rate from the rate master using the obtained initial sales or purchase rate and the recording date of the sales or purchase invoice as keys.

Images