JPH11242781A - Method for dealing with foreign currency in sale processing by pos terminal - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a sales processing by foreign currency by using a POS(point of sales) terminal to be installed at a retail store. SOLUTION: A currency conversion rate table in which a conversion rate between plural foreign currencies and yen currency is registered is previously provided in a memory 9, HS 10 in the POS terminal and when payment of a charge by the foreign currency registered in the currency conversion rate table is desired by a customer, amounts of the charge and change by the foreign currency by which the payment is desired by the customer is displayed on a customer display 1 by using the currency conversion rate table by the POS terminal.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for summarizing sales data at a POS terminal, which enables not only Japanese yen but also sales processing when a foreign currency is received.

[0002]

2. Description of the Related Art At present, for example, point-of-sale information management (Point-of-sales management) for managing sales information for each product at a retail store or the like.
(es, generally called POS) terminals are quite popular.
Conventionally, in POS terminals in Japan, it is assumed that all currency units of commodity price data are unified into "yen", and foreign currency (hereinafter, also simply referred to as foreign currency) of a different unit is used. The idea did not exist. Therefore, the product price data generated in the POS terminal is
The same value was always used for tabulation and various calculations.

[0003]

However, the above PO
According to the sales processing method in the S terminal, it is not possible to pay in a foreign currency or calculate change when a difference occurs in a foreign currency transaction in order to sell a product priced in "yen". There was a problem that the exchange rate of foreign currency to yen at the time could not be presented. In addition, if sales are made in foreign currency and there is a difference between the conversion rate at the time the foreign currency is received from the customer and the conversion rate at the time the foreign currency is received by the bank at the time of aggregation of this sales data In
There was also a problem that correct data aggregation could not be performed.

[0004]

According to the present invention, there is provided a method for dealing with foreign currencies in sales processing by a POS terminal, comprising: a POS terminal installed in a retail store in which a plurality of conversion rates for foreign currencies and yen are registered in advance. A conversion rate table is provided, and when the customer wants to pay the foreign currency registered in the currency conversion table, the POS terminal uses the currency conversion rate table to request that the customer pay. This is to notify the customer of the price and change amount in foreign currency. As a result, the retail store:
Sales of goods in foreign currencies registered in the currency conversion table become possible, and an increase in the amount of sales can be expected.

[0005]

FIG. 1 shows a P according to an embodiment of the present invention.
FIG. 3 is a hardware configuration diagram of an OS terminal. In FIG.
1 is a customer display, 2 is an operation panel such as an LCD touch panel, 3 is a POS keyboard, 4 is a barcode reader, 5 is a receipt printer, 6 is a journal printer, 7 is an RS232-C port, and 8 is a floppy disk drive. (FDD), 9 is a memory, and 10 is a hard disk (HD). In this embodiment, assuming that the foreign currency receives cash, the currency conversion rate is
A description will be given as a currency conversion rate when foreign currency of cash is converted into yen currency. Specifically, the currency conversion rate of the present embodiment is set based on the foreign currency to cash conversion rate at the bank when the foreign currency of cash received by the store is sold to the bank (the bank buys foreign currency). I have to. In addition, since the store prepares foreign currency change, the yen-to-foreign exchange rate when a foreign currency of cash is purchased from a bank (the bank sells foreign currency) is slightly different from the above-mentioned foreign currency-to-yen conversion rate. In addition, a common currency conversion rate is set for both, and change and the like are calculated. The handling of travel checks (TC) other than cash will be described later.

FIG. 2 is a diagram showing an example of registration of a currency conversion rate table in the memory 9 and the HD 10 of FIG. In a store where a POS terminal is installed, first, in the own store, which currency can be used is determined, and a currency conversion rate table as shown in FIG.
Then, the conversion rate from the corresponding currency to the yen currency is registered in the conversion rate column for each currency in the table. The exchange rates in this currency exchange rate table are usually updated every day before opening the store.However, if the exchange rates in the foreign currency exchange market are volatile, In addition to updating it in a timely manner, we will review it even when foreign currency deposits are actually converted to yen currency at banks. In addition, “1” in the column of whether or not there is a change for each currency in FIG. 2 indicates that change in the corresponding currency is prepared, and “0” indicates that change in the corresponding currency is not prepared (that is, change is performed in yen currency). ).

FIG. 3 is a flowchart showing a sales process at the time of foreign currency deposit according to the embodiment of the present invention. Numerical values following S in the figure indicate step numbers. FIG. 4 is a diagram showing a print example of a sales receipt at the time of foreign currency deposit according to the embodiment of the present invention. First, at the store, in order to enable sales in foreign currency, a plurality of currencies are converted into yen currencies in the conversion rate table and the presence or absence of change in the currency conversion rate table in the memory 9 or the HD 10 shown in FIG. The conversion rate to be used and whether or not change in the corresponding currency is prepared are registered in advance. Hereinafter, a method for dealing with foreign currency in sales processing by the POS terminal in FIG. 1 will be described with reference to FIG. 4 in accordance with the flowchart of FIG.

[0008] When a customer makes a purchase at a store, the total sales amount is displayed on the customer display 1 of the POS terminal at a yen price A (see S1 in FIG. 3). When the customer does not wish to pay foreign currency (NO in S2) and when the foreign currency the customer wants to pay is not registered in the currency conversion rate table (NO in S3), the normal payment in yen is made. Become. In addition, the customer wants to pay foreign currency (YES in S2)
In this case, if the foreign currency that the customer wants to pay is registered in the currency conversion rate table (YES in S3), the operator of the POS terminal declares the use of the foreign currency by key operation ( See S4).

When the use of the designated foreign currency is declared in S4 of FIG. 3, in the next S5, the yen price A displayed in S1 is displayed.
Is divided by the conversion rate of the corresponding currency in the currency conversion rate table to obtain the foreign currency price B. In this case, the quotient of the division result is rounded up to the nearest decimal point. For example, the quotient is $ 96.50
In this case, B is rounded up to $ 97.00. This is because, in the case of foreign currency, banknotes are exchanged at the bank, but coins are not exchanged. In S6 of FIG. 3, the difference C by rounding up the fraction is determined in consideration of the case where the quotient of the division result is rounded up to the decimal point in S5. That is, the difference C is calculated by multiplying the foreign currency price B obtained in S5 by the corresponding currency conversion rate and subtracting the yen price A from the product.

At S7 in FIG. 3, it is determined whether or not there is a difference C (ie, whether or not C is zero). If so, the foreign currency price B and the difference C are displayed on the customer display 1 at S8. Otherwise, in S9, only the foreign currency price B is displayed on the customer display 1. In S10 of FIG. 3, it is determined whether or not the customer wants to pay only a part of the price in foreign currency, and if so, the process proceeds to S11 and subsequent steps.
Move to the subsequent processing.

In S11 of FIG. 3, a partial deposit yen price D is obtained by multiplying the foreign currency deposit amount by the corresponding currency conversion rate, and then the above D is subtracted from the yen price A to obtain a balance E (yen price). Ask for. In S12 of FIG. 3, the balance E is displayed on the customer display 1, and in S13, the balance E is received in yen currency. Then, the process proceeds to S20.

In S14 of FIG. 3, the foreign currency deposit amount F is multiplied by the conversion rate of the corresponding currency to obtain a deposit yen converted amount G. In S15 of FIG. 3, it is determined whether or not a change has been returned for the deposit amount G, and if there is no change, the process proceeds to S20. If there is, it is determined in S16 whether or not the change of the corresponding foreign currency is prepared. Determine.

[0013] Then, if change of the corresponding foreign currency is prepared,
In S17 of FIG. 3, the foreign currency change I obtained by subtracting the foreign currency price B from the foreign currency deposit amount F is returned to the customer. If the change of the corresponding foreign currency is not prepared, the deposit yen conversion is performed in S18 of FIG. The change H obtained by subtracting the yen price A from the sum G is returned to the customer, and the process proceeds to S20.

At S20 in FIG. 3, a sales receipt as shown in FIG. 4 is output, and the transaction is terminated. In the deposit column of the sales receipt of FIG. 4, first, the dollar deposit amount ($ 99)
Then, the dollar-converted dollar amount converted into yen ($ 999, that is, S5B or S11D in FIG. 3), the dollar currency conversion rate into yen currency ($ 1 / $ 125), and The remaining amount in yen of the dollar currency ($ 999, that is, E in S13 of FIG. 3) and the total cash amount ($ 999, that is, the sum of the yen-converted amount and the remaining amount in yen) An example of printing is shown.

FIG. 5 is a flow chart showing the processing at the time of foreign currency deposit and the processing at the time of currency exchange according to the embodiment of the present invention, and the numeral following S in the figure indicates a step number. FIG. 6 is a diagram showing an example of cumulative daily sales and monthly cumulative sales according to the embodiment of the present invention;
FIG. 7 is a diagram showing an example of a foreign currency deposit log file according to the embodiment of the present invention, and FIG. 8 is a diagram showing an example of a rate history file for each foreign currency according to the embodiment of the present invention.

First, FIGS. 6 to 8 will be described. FIG.
In addition to a daily counter that stores various kinds of sales data information for one day, a monthly counter that accumulates this daily sales for one month (see FIG. 6), a foreign currency deposit A foreign currency deposit log file (see FIG. 7) for storing data for a relatively short period of time and a rate history file (see FIG. 8) for storing a history of changes in foreign currency conversion rates for a relatively long period of time are provided.

The foreign currency deposit log file shown in FIG.
When a customer receives payment in a foreign currency registered in the currency conversion table of FIG. 2 at a retail store where an OS terminal is installed, the received date, type of currency, and amount of money received And the yen-converted amount at that time is recorded in the foreign currency deposit log file, and this is recorded for a relatively short period of time (for example, 2
Monthly) and correct the yen-converted amount of the corresponding foreign currency saved in the foreign currency deposit log file with the actual deposit amount at the time of converting the received foreign currency into yen currency, When the sales are accumulated, the yen-converted amount of the foreign currency corrected by the actual deposit amount in the foreign currency deposit log file is used as the sales amount.

The rate history file of FIG. 8 calculates the conversion rate between the relevant foreign currency and the yen currency at that time based on the actual deposit amount at the time of converting the foreign currency paid by the customer into the yen currency. At this time, the date, the type of foreign currency, and the conversion rate between the relevant foreign currency and the yen currency are recorded in the rate history file, and these are stored for a relatively long time (for example, about 6 months to 1 year). Based on the actual conversion rates at the time of the above currency exchange, the conversion rates in the currency conversion rate table shown in FIG. 2 are reviewed and updated to new conversion rates as necessary. It is also designed to predict future fluctuations in exchange rates.

Next, the processing of sales data at the time of foreign currency deposit and the processing at the time of currency exchange will be described with reference to FIGS. 6 to 8 in accordance with the flowchart of FIG. For POS terminals, memory 9 and HD
The daily counter in 10 is updated (see S31 in FIG. 5), and the sales data of the day is sequentially stored in the daily counter. Then, if there is a sales in foreign currency, the deposit amount of the foreign currency and the yen-converted amount are entered in the daily counter (see S32 in FIG. 5). As shown in FIG. 6, these data are used to enter the daily sales total in the monthly counter (see S33 in FIG. 5), as well as the type and amount of foreign currency sold for today, as shown in FIG. Then, the yen-converted amount is entered in the foreign currency deposit log file of FIG. 7 (see S34 of FIG. 5).

After the next day, the store converts the received foreign currency into yen at the bank, and based on the actual deposit amount at the time of the exchange,
Correct the yen-converted amount from the applicable foreign currency deposit amount at the time of sales written in the foreign currency deposit log file, and correct the yen-converted amount for the relevant foreign currency deposit amount entered in the monthly cumulative total (FIG. 5). S35).

Further, the currency conversion rate table of FIG. 2 is reviewed based on the yen conversion rate of the corresponding currency calculated from the actual deposit amount of the currency at the time of the exchange, and updated to a new yen conversion rate as necessary (FIG. 3). See S36). Further, the yen conversion rate of the corresponding currency calculated from the actual deposit amount of the yen currency at the time of the exchange is entered in the rate history file of FIG.

The correction processing of the foreign currency deposit log file and the monthly sales total at the time of currency exchange in S35 of FIG.
This will be described in detail in Section 4. First, the foreign currency deposit amount and the yen-converted amount at the time of sales are read from the foreign currency deposit log file (S in FIG. 5).
41). Next, the foreign currency deposit amount at the time of sales is converted into a yen amount at the conversion rate at the time of currency exchange (see S42 in FIG. 5).
Next, the yen-converted amount from the foreign-currency deposit amount in the foreign-currency deposit log file is corrected based on the yen-converted amount at the time of exchange (see S43 in FIG. 5). Next, the difference between the yen-converted amount at the time of currency exchange and the yen-converted amount at the time of sales is determined, and the monthly sales total is corrected based on the difference (see S4 in FIG. 5).

As described above in detail, according to the present embodiment, by registering in advance the abbreviations of available foreign currency, the conversion rate, and the presence / absence of change in the currency conversion rate table, the customer can pay in foreign currency. , The customer can be immediately informed of the desired foreign currency amount, change amount, and yen conversion rate. Also, when collecting the obtained foreign currency as sales data, save the foreign currency deposit data in the foreign currency deposit log file for about two months, and correct the yen conversion amount at the time of sales with the actual yen conversion amount when foreign currency is exchanged In addition, it is possible to obtain accurate monthly sales totals in yen currency. Further, by storing the yen conversion rate at the time of foreign currency exchange in the rate history file for a long period of time, it is possible to predict the future tendency of the currency conversion rate fluctuation.

In the above embodiment, the foreign currency received from the customer has been described as cash, but the processing when a travel check (TC) is received will be described. The foreign currency TC → yen conversion rate when selling TC received by a store to a bank (the bank buys TC) is different from the rate for cash, and requires a commission of about 1%. Therefore, two types of conversion rates, a currency conversion rate of cash and a currency conversion rate of TC, are set in the POS terminal in advance, or a predetermined conversion operation is performed from the currency conversion rate of cash to perform the TC conversion.
By calculating and using the currency conversion rate of T
When C is received, the same foreign currency correspondence processing as described above can be performed.

[0025]

As described above, according to the present invention, a POS terminal installed in a retail store is provided with a currency conversion rate table in which conversion rates for a plurality of foreign currencies and yen currencies are registered in advance. If the POS terminal wishes to pay the foreign currency registered in the currency conversion table, the POS terminal uses the currency conversion rate table to
Since the customer is notified of the price and change amount in the foreign currency that the customer has requested to pay, as a result, the retail store can sell goods in the foreign currency registered in the currency conversion table, and An increase in the amount can be expected.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a POS terminal according to an embodiment of the present invention.

FIG. 2 is a diagram showing a registration example of a currency conversion rate table in a memory and an HD of FIG. 1;

FIG. 3 is a flowchart showing sales processing at the time of foreign currency deposit according to the embodiment of the present invention.

FIG. 4 is a diagram showing a print example of a sales receipt when foreign currency is deposited according to the embodiment of the present invention.

FIG. 5 is a flowchart showing processing at the time of foreign currency deposit and processing at the time of currency exchange according to the embodiment of the present invention.

FIG. 6 is a diagram showing an example of cumulative daily sales and monthly cumulative sales according to the embodiment of the present invention.

FIG. 7 is a diagram showing an example of a foreign currency deposit log file according to the embodiment of the present invention.

FIG. 8 is a diagram showing an example of a rate history file for each foreign currency according to the embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Customer display 2 Operation panel 3 POS keyboard 4 Barcode reader 5 Receipt printer 6 Journal printer 7 RS232-C port 8 FDD (floppy disk drive) 9 Memory 10 HD (hard disk)

Claims (7)

[Claims] A POS terminal installed in a retail store has a currency conversion rate table in which conversion rates for a plurality of foreign currencies and yen currencies are registered in advance. The POS terminal notifies the customer of the price and change amount in the foreign currency that the customer has requested to pay by using the currency conversion rate table when the customer wants to pay the currency. The foreign currency handling method of sales processing by the POS terminal. 2. The exchange rate between a plurality of foreign currencies and yen currency registered in the currency exchange rate table is updated on a daily basis or in a timely manner in response to a change in exchange rate in a foreign currency exchange market. The P according to claim 1,
A method for handling foreign currency in sales processing by the OS terminal. 3. The change amount notified to the customer by the POS terminal is set in a foreign currency or a yen currency in accordance with the presence or absence of change in the corresponding foreign currency at the retail store. 3. A method for handling foreign currency in sales processing by the POS terminal according to 1 or 2. 4. The POS terminal is capable of notifying a customer of a conversion rate between a corresponding foreign currency and a yen currency by using the currency conversion rate table for a foreign currency the customer desires to pay. 4. The foreign currency handling method for sales processing by a POS terminal according to any one of claims 1 to 3. 5. In a retail store where the POS terminal is installed, when a customer receives payment in a foreign currency registered in the currency conversion table, the POS terminal uses the currency conversion table. 5. The method according to claim 1, wherein a deposit amount of the foreign currency, its yen conversion amount, and a conversion rate between the deposit foreign currency and the yen currency are printed in a deposit column of a sales receipt passed to the customer. A method for dealing with foreign currency in sales processing by a POS terminal according to claim 13. 6. At a retail store where the POS terminal is installed, when a customer receives payment in a foreign currency registered in the currency conversion table, the POS terminal receives the payment in a year. Record the date, currency type, deposit amount and the current yen-converted amount in the foreign currency deposit log file, save this for a certain period of time, and save the actual amount at the time of converting the received foreign currency into yen currency. Corrected the yen-converted amount of the relevant foreign currency saved in the foreign currency deposit log file according to the deposit amount of the foreign currency, and when performing monthly sales accumulation, the foreign currency corrected by the actual deposit amount in the foreign currency deposit log file 6. The foreign currency handling method for sales processing by a POS terminal according to any one of claims 1 to 5, wherein the yen-converted amount is used as the sales amount. 7. The POS terminal according to the actual deposit amount at the time of converting the received foreign currency into yen currency,
The conversion rate between the relevant foreign currency and the yen currency at that time is calculated, the date, type of foreign currency, and the conversion rate between the relevant foreign currency and the yen currency at this time are recorded in the rate history file, and this is fixed. 7. The method according to claim 6, wherein the sales processing is performed for a foreign currency in the POS terminal.