JP2023112876A - Sales management system, sales management method, and sales management program - Google Patents

Abstract

To accurately perform profit management in the case that transaction currency and contract currency are different.SOLUTION: A sales management system according to this embodiment comprises: order acceptance/placement input means for inputting order acceptance data including an accepted order number, a billing address, a product, contract currency, transaction currency, a contract sales amount, a transaction sales amount, a yen sales amount, a foreign currency profit, and a yen profit, and order placement data including a placed order number, a payee, the product, contract currency different from the transaction currency, the transaction currency, a contract purchasing amount, a transaction purchasing amount, a yen purchasing amount; sales input means for inputting sales data including a sales number, a billing address, the product, the contract sales amount, the transaction sales amount, the yen sales amount, the foreign currency profit, and the yen profit based on the accepted order data with respect to a sales accounting date being a timing when the yen value is fixed; and purchasing input means for inputting purchasing data including a purchasing number, the payee, the product, the contract purchasing amount, the transaction purchasing amount, and the yen purchasing amount based on the purchase data, with respect to a purchasing accounting date being the timing when the yen value is fixed.SELECTED DRAWING: Figure 5

Description

The present invention relates to a sales management system, a sales management method, and a sales management program.

For example, in the case of a transaction in which the period from the contract to the actual transaction is long and the exchange rate cannot be predicted, if the contract is made in the currency at the time of the transaction, the exchange risk is high. be. As a conventional sales management system, for example, there is Patent Document 1.

JP 2003-122255 A

However, Patent Literature 1 does not describe anything about how to perform profit management accurately when the transaction currency and the currency at the time of contract are different.

The present invention has been made in view of the above, and provides a sales management system, a sales management method, and a sales management program that enable accurate profit management when the transaction currency and the currency at the time of contract are different. for the purpose.

In order to solve the above-described problems and achieve the object, the present invention is a sales management system having a control unit, the control unit controls order receipt number, billing address, product, contract currency, transaction currency, Order data including contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit, purchase order number, payee, product, contract currency different from transaction currency, transaction currency, contract purchase amount, transaction purchase Order input means for inputting order data including amount and purchase amount in Japanese currency and registering it in a storage unit; Sales input means for inputting sales data including contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, and yen profit, and registering in the storage unit; Purchase including purchase number, payee, product, contract currency different from transaction currency, transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency based on the order data as the date of receipt and purchase input means for inputting data and registering it in the storage unit.

Further, according to one aspect of the present invention, the order data and the sales data may further include a foreign currency profit and a yen profit.

In addition, according to one aspect of the present invention, the product items of the order data and the purchase data include expenses, and only the price of the product is set in a currency at the time of contract that is different from the transaction currency, and the expenses are in the transaction currency. You can leave it as is.

Further, according to one aspect of the present invention, the control unit can further confirm the foreign currency profit and the yen profit from the order received and placed at the time of contract based on the received order data and order data registered in the storage unit. It is also possible to provide transaction-by-transaction income and expenditure inquiry means for outputting a transaction-by-transaction income and expenditure table at the time of contract.

In addition, according to one aspect of the present invention, the transaction-by-transaction income and expenditure inquiry means, based on the sales data and purchase data registered in the storage unit, calculates foreign currency profits and yen profits from sales and purchases at the time of accounting. You may decide to output the income and expenditure table by transaction at the time of accounting which can confirm .

Further, in order to solve the above-described problems and achieve the object, the present invention provides a sales management method executed by an information processing apparatus having a control section, wherein the control section executes an order number, Billing destination, product, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, foreign currency profit, order data including yen profit, order number, payee, product, contract currency different from transaction currency , order data including transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency are entered and registered in a storage unit; Enter sales data including sales number, billing address, product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit, and register in the storage unit and the purchase recording date as the purchase recording date, purchase number, payee, product, currency at the time of contract different from the transaction currency, transaction currency, contract purchase amount, transaction and a purchase input step of inputting purchase data including the purchase amount and the purchase amount in Japanese currency and registering them in the storage unit.

Further, in order to solve the above-described problems and achieve the object, the present invention provides a sales management program to be executed by an information processing apparatus having a control unit, wherein the control unit stores an order number, a billing address, , product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, order data including yen profit, order number, payee, product, contract currency different from transaction currency, transaction Order entry step of inputting order data including currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency and registering it in the storage unit, and based on the order data with the timing of yen confirmation as the sales recording date sales data including sales number, billing address, product, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, profit in foreign currency, profit in yen, and sales data to be registered in the storage unit Based on the above order data, the purchase order number, payee, product, currency different from the transaction currency, transaction currency, contract purchase amount, transaction purchase It is characterized by being a sales management program for executing a purchase input step of inputting purchase data including an amount and a purchase amount in Japanese currency and registering it in the storage unit.

ADVANTAGE OF THE INVENTION According to this invention, there exists an effect that profit management can be performed correctly, when a transaction currency and a contract currency differ.

FIG. 1 is a diagram showing a processing image of the sales management system of this embodiment. FIG. 2 is a diagram for explaining functions for managing foreign currency transactions and inputting a contract currency different from the transaction currency. FIG. 3 is a diagram for explaining the visualization of the yen amount converted from the currency at the time of contract and the amount. FIG. 4 is a diagram for explaining the visualization of the yen amount converted from the currency at the time of contract and the amount. FIG. 5 is a block diagram showing an example of the configuration of the sales management system according to this embodiment. FIG. 6 is a diagram showing a flow for explaining an outline of the overall processing of the control unit of the sales management system according to this embodiment. FIG. 7 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to the present embodiment. FIG. 8 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 9 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 10 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 11 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 12 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 13 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment. FIG. 14 is a diagram for explaining a specific example of processing of the control unit of the sales management system according to this embodiment.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. overview]
For example, in the case of a transaction in which the period from the contract to the actual transaction is long and the exchange rate cannot be predicted, if the contract is made in the currency at the time of the transaction, the exchange risk is high. be.

Here, the "transaction currency" is the currency in which "actual" money is exchanged. The "contract currency" is the currency "on the contract". In general, the transaction currency is the currency at the time of contract, but sometimes contracts are made in a different currency than the transaction currency.

In the past, the contract currency could not be managed, and only the transaction currency was managed. Therefore, for example, when the transaction currency was yen and the contract currency was dollars, the correct profit could not be managed. In addition, when the transaction currency and the currency at the time of the contract are different, if the transaction cannot be managed in the currency at the time of the contract, it is difficult to see the original profit of the transaction and it is difficult to accurately manage the income and expenditure. In addition, it may unilaterally bear the risk of foreign exchange loss by fixing only the purchase cost in yen first. Specifically, for example, the manager was unable to manage the transaction correctly because the risk status of the transaction was not visualized, and the person in charge had to manage the status of the transaction outside the system, which made management complicated.

Therefore, in the present embodiment, in order to accurately manage profits in the sales management system when the transaction currency is different from the currency at the time of the contract, the timing of fixing the yen is set at the time when the transaction is recorded (at the same timing). Sometimes reduce the impact of foreign exchange risk fluctuation risk. More specifically, we have a data structure that can manage the “original profit of the transaction” (management of the currency at the time of contract) and an input function to realize it (management of foreign currency transactions and By building a currency input), we realized the visualization of the Japanese currency amount converted from the contract currency and amount.

FIG. 1 is a diagram showing a processing image of the sales management system of this embodiment. In FIG. 1, a company (for example, a trading company) made a contract to sell a product for $100 with a customer (overseas) in transaction currency "USD" and contract currency "USD". In addition, the company made a contract with the supplier (domestic) to purchase the product at the equivalent of 80 dollars in the transaction currency "yen" and the contract currency "USD". Here, the company's original profit is 20 dollars, but in order to reduce the risk of exchange rate fluctuations, the purchase recording date and the sales recording date are set as the yen settlement timings.

Points of the sales management system of this embodiment will be described with reference to FIGS. 2 to 4. FIG.

(1) Functions for managing foreign currency transactions and entering a contract currency different from the transaction currency Functions for managing foreign currency transactions and entering a contract currency different from the transaction currency will be described with reference to FIG. At the time of the sales contract, 1 dollar is 100 yen. In the billing destination master, "USD" is set as the transaction currency. Make a sales contract with a customer (billing party) for $100 in contract currency "USD" and transaction currency "USD". In this case, it is ¥10,000 in the local currency "JPY" (internal rate at the time of contract).

At the time of recording (sales), 1 dollar is 90 yen. Since the sales amount is $100, it is ¥9,000 in the local currency "JPY" (foreign exchange rate). Settlement shall be deposit "USD" and journal link "USD".

A case where the purchase contract is made in the transaction currency (USD) (yen is fixed) will be explained. In the payee master, the transaction currency is set to "JPY". Make a product purchase contract with the payee (supplier) for ¥8,000 in contract currency "JPY" and transaction currency "JPY". The profit in the domestic currency "JPY" is ¥2,000 (=¥10,000-¥8,000).

At the time of recording (purchase), the transaction currency "JPY" is fixed at the time of contract, so the purchase amount is the same as ¥8,000. The profit in the domestic currency "JPY" is ¥1,000 (=9,000-8,00), which is ¥1,000 less than the profit at the time of the contract. Settlement shall be payment “JPY” and journal linkage “JPY”.

On the other hand, in the present embodiment, contracts and management are made in the transaction currency≠contract currency. Make a purchase contract with the payee (supplier) for $80 in the contract currency "USD" which is different from the transaction currency "JPY". The foreign currency profit at the time of contract is $20 (=$100-$80). Yen profit is ¥2,000.

At the time of recording (purchase), the yen is fixed, the contract currency is "USD", the purchase amount is $ 80, the transaction currency is "JPY", and the purchase amount is ¥ 7,200 (TTB at the time of purchase ). The foreign currency profit at the time of posting is $20 (=$100-$80). Yen profit is ¥1,800. In this case, the profit in yen is ¥800 more than when the contract is made in the transaction currency at the time of contract. In the present embodiment, foreign currency profit and yen profit can be managed at the time of contract and at the time of accounting.

(2) Visualization of Japanese currency amount converted from contract currency and amount Visualization of Japanese currency amount converted from contract currency and amount will be described with reference to FIGS. 3 and 4 . In this embodiment, the profit (foreign currency profit, yen profit) at the time of signing the contract and at the time of recording can be confirmed in the income and expenditure table for each transaction.

FIG. 3A shows an example of an income and expenditure table (order entry checklist) by transaction at the time of contract.
The income and expenditure table by transaction at the time of the contract (order entry checklist) contains slip information (order number, order number) and sales information (customer, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount) , purchase (purchase) information (vendor, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount) and profit (foreign currency profit, yen profit) items there is The income and expenditure table by transaction at the time of contract (order entry checklist) is created based on order data and order data, as will be described later.

FIG. 3(B) shows an example of a balance sheet for each transaction at the time of sale (sales input checklist).
The balance sheet by transaction at the time of sales (sales input checklist) contains slip information (sales number, purchase number) and sales information (customer, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount ), purchase (purchase) information (vendor, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount), and profit (foreign currency profit, yen profit). ing. The income and expenditure table by transaction at the time of contract (order entry checklist) is created based on sales data and purchase data, as will be described later.

In addition, in this embodiment, the transaction currency is the yen, the contract currency is the dollar, and expenses such as commissions and reimbursement expenses that are not related to product sales can be managed even in the case of yen, enabling accurate profit management for each transaction. It is possible. Specifically, the transaction currency ≠ contract currency is only the product amount, and we have also built a function that allows contracting expenses such as commissions and reimbursement expenses in the transaction currency. FIG. 4 is a diagram for explaining the profit (foreign currency profit, yen profit) of expenses such as commissions and reimbursement expenses.

In FIG. 4(B), the currency at the time of contract is "USD" only for the product price, and the currency at the time of contract is "JPY" for commissions and advance expenses. As shown in Fig. 4 (C), in the income and expenditure table by transaction at the time of contract, the profit for the product (foreign currency profit, yen profit), the amount of expenses (yen amount), and the profit (foreign currency profit, yen profit) to be able to confirm.

The sales management system of the present embodiment is suitable for companies that have many imports and exports, companies that use different currencies for selling and buying in matching transactions (sales transactions), companies that have a small profit margin for one transaction, It can be widely applied to companies with long periods until transactions and high profit fluctuation risks such as foreign exchange risks (companies that need to perform detailed profit management for each transaction).

[2. composition]
An example of the configuration of the sales management system according to this embodiment will be described with reference to FIG. FIG. 5 is a block diagram showing an example of the configuration of the sales management system according to this embodiment.

The sales management system 100 is a commercially available desktop personal computer. Note that the sales management system 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. It may be an information processing device.

The sales management system 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the sales management system 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the sales management system 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 another device via a communication line. Here, the network 300 has a function of connecting the sales management system 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As 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, and optical disks can be used.

The storage unit 106 also includes a billing destination master 106a, a payment destination master 106b, and a data file 106c.

The billing destination master 106a can be composed of a table or the like in which billing destination codes, billing destinations, and transaction currencies are associated and registered.

The payee master 106b can be composed of a table or the like in which payee codes, payees, and transaction currencies are associated and registered.

The data file 106c is a file for storing various data such as order data, order data, sales data, collection schedule data, purchase data, payment schedule data, deposit data, and payment data.

Order data can be composed of order header data and order detail data. Order header data includes order number, billing address, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit, foreign currency profit, and yen profit. You can

The order detail data may include order number, line number, product, contract sales amount, transaction sales amount, and Japanese currency sales amount.

The order data can be composed of order header data and order detail data. The order header data may include order number, payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount, foreign currency premium amount, and Japanese currency premium amount.

The order detail data may include order number, line number, product, contract purchase amount, transaction purchase amount, and Japanese currency purchase amount.

The sales data may consist of sales header data and sales detail data. Sales header data includes sales number, billing address, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, foreign currency profit, yen profit, foreign currency profit, and yen profit. You can

Sales detail data may include sales number, line number, product, contract sales amount, transaction sales amount, and sales amount in Japanese currency.

The scheduled collection data may include a sales number, a line number, a product, a transaction collection scheduled amount, a Japanese currency collection scheduled amount, a transaction applied amount, and a Japanese currency applied amount.

The purchase data may consist of purchase header data and purchase detail data. The purchase header data may include purchase number, payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount, foreign currency premium amount, and Japanese currency premium amount. .

The purchase detail data may include purchase numbers, line numbers, products, contract purchase amounts, transaction purchase amounts, and Japanese currency purchase amounts.

The payment schedule data may include sales number, line number, product, transaction payment schedule amount, Japanese currency payment schedule amount, transaction applied amount, and Japanese currency applied amount.

The deposit data may include deposit number, billing party, transaction currency, and transaction deposit amount.

Payment data may include payment number, payee, transaction currency, and transaction payment amount.

The control unit 102 is a CPU or the like that controls the sales management system 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 is configured to be able to access a billing destination master 106a, a payment destination master 106b, and a data file 106c stored in the storage unit 106. FIG. Note that these master files may be provided in another location (for example, the server 200) as long as the control unit 102 can access them.

The control unit 102 functionally and conceptually includes an order input unit 102a, a sales input unit 102b, a purchase input unit 102c, a deposit input unit 102d, a payment input unit 102e, and a transaction-by-transaction balance inquiry unit 102f. A screen display control section 102g and a master maintenance section 102h are provided.

For example, the order input unit 102a receives an order number, billing address, product, contract currency, Order data including transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit is entered and registered in the data file 106c. Ordering data including time currency, transaction currency, contract purchase amount, transaction purchase amount, and Japanese currency purchase amount are entered and registered in the data file 106c.

For example, the sales input unit 102b, in response to an operator's operation or the like on a sales screen (not shown) displayed on the monitor 114, sets the timing of determining yen as the sales recording date, and based on the order data, enters the sales number, the invoice, and the like. Sales data including destination, product, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, profit in foreign currency, and profit in yen are entered and registered in the data file 106c. The sales input unit 102b also creates collection schedule data based on the sales data and registers it in the data file 106c.

The purchase input unit 102c, for example, according to an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, sets the timing of determining the yen as the purchase recording date, and based on the order data, Purchase data including purchase number, payee, product, contract currency different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency are entered and registered in the data file 106c. The purchase input unit 102c creates payment schedule data based on the purchase data and registers it in the data file 106c.

The order data and sales data may further include foreign currency earnings and yen earnings.

Product items in order data and purchase data include expenses (commissions, reimbursement expenses, etc.), and only the product price is set in the currency at the time of contract that is different from the transaction currency, and expenses remain in the transaction currency. may

The deposit input unit 102d inputs deposit data and registers it in the data file 106c in response to an operator's operation on a deposit input screen (not shown) displayed on the monitor 114, for example.

For example, the payment input unit 102e inputs payment data and registers it in the data file 106c in response to an operator's operation on a payment input screen (not shown) displayed on the monitor 114, or the like.

The transaction-by-transaction income and expenditure inquiry unit 102f, in response to the operator's operation on an inquiry screen (not shown) displayed on the monitor 114, based on the received order data and order data registered in the data file 106c, confirms the contract at the time of the contract. Display and output an income and expenditure table for each transaction at the time of contract that allows confirmation of foreign currency profit and yen profit from orders and orders.

In addition, the transaction-by-transaction balance inquiry unit 102f responds to the operator's operation on an inquiry screen (not shown) displayed on the monitor 114, based on the sales data and purchase data registered in the data file 106c. Display and output the income and expenditure table for each transaction at the time of posting that allows you to check the foreign currency profit and yen profit from sales and purchases at the time of posting.

The screen display control unit 102g controls the display and input of various screens displayed on the monitor 114 (for example, order input screen, sales input screen, purchase input screen, deposit input screen, payment input screen, inquiry screen, etc.). do.

For example, the master maintenance unit 102h inputs, adds, deletes, edits, etc. data to the billing destination master 106a and the payment destination master 106b in accordance with the operator's operation on the master maintenance screen displayed on the monitor 114. settings.

[3. Concrete example]
A specific example of the processing of the sales management system 100 according to the present embodiment will be described with reference to FIGS. 5 to 14. FIG. First, referring to FIG. 6, the outline of the overall processing of the sales management system 100 according to the present embodiment will be described. FIG. 6 is a diagram showing a flow for explaining an overview of the overall processing of the sales management system 100 according to this embodiment.

(3-1. Overall processing)
In FIG. 6, the order input unit 102a executes order input processing (step S1). Specifically, in the order entry input process, the order entry input unit 102a, for example, according to the operator's operation on the order entry screen displayed on the monitor 114, receives the order number, billing address, product, contract, etc. input order data including current currency, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit, foreign currency profit, and yen profit, and register them in the data file 106c; In addition, enter order data including order number, payee, product, contract currency different from transaction currency, transaction currency, contract purchase amount, transaction purchase amount, purchase amount in Japanese currency, amount of miscellaneous charges in Japanese currency, and enter data file 106c.

The sales input unit 102b executes sales input processing (step S2). Specifically, in the sales input process, the sales input unit 102b, for example, according to the operator's operation on an input screen (not shown) displayed on the monitor 114, sets the yen confirmation timing as the sales recording date, Based on the order data, sales number, billing destination, product, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, foreign currency profit, yen profit, foreign currency profit, yen profit is input and registered in the data file 106c.

The purchase input unit 102c executes purchase input processing (step S3). Specifically, in the purchase input process, the purchase input unit 102c, for example, according to the operator's operation on an input screen (not shown) displayed on the monitor 114, records the timing of confirming the yen as the purchase. As a date, based on the order data, including the purchase number, payee, product, contract currency different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, purchase amount in Japanese currency, amount of miscellaneous charges in Japanese currency Purchase data is entered and registered in the data file 106c. The sales input processing S2 and purchase input processing S3 are independent processes.

The deposit input unit 102d executes a deposit input process (step S4). Specifically, in the deposit input process, the deposit input unit 102d inputs deposit data into the data file 106c in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example. register.

The payment input unit 102e executes payment receipt processing (step S5). Specifically, in the payment purchase process, the payment input unit 102e inputs payment data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and stores the data in the data file 106c. to register.

The transaction-by-transaction balance inquiry unit 102f executes transaction-by-transaction balance inquiry processing (step S6). Specifically, in the transaction-by-transaction income and expenditure inquiry process, the transaction-by-transaction income and expenditure inquiry unit 102f registers in the data file 106c according to the operator's operation on an inquiry screen (not shown) displayed on the monitor 114. Based on the order data and the order data, a balance table for each transaction at the time of contract is displayed and output so that the foreign currency profit and the yen profit from the order and the order at the time of the contract can be confirmed. After entering orders and orders, it is possible to immediately check the income and expenditure table for each transaction at the time of the contract.

In addition, the transaction-by-transaction balance inquiry unit 102f responds to the operator's operation on an inquiry screen (not shown) displayed on the monitor 114, based on the sales data and purchase data registered in the data file 106c. Display and output the income and expenditure table for each transaction at the time of posting that allows you to check the foreign currency profit and yen profit from sales and purchases at the time of posting.

(3-2. Sample data)
7 to 14 are diagrams showing sample data for explaining specific examples of processing of control unit 102 of sales management system 100 according to the present embodiment. A specific example of the processing of the control unit 102 of the sales management system 100 according to the present embodiment will be described with reference to FIGS. 7 to 14. FIG.

(master maintenance processing)
Referring to FIG. 7, master maintenance processing is executed. The master maintenance section 102h sets data for the billing destination master 106a and the payment destination master 106b, for example, according to the operator's operation on the master maintenance screen displayed on the monitor 114. FIG.

FIG. 7A shows an example of data in the billing destination master 106a. The billing destination master 106a has items of billing destination code, billing destination, and transaction currency. In the example shown in FIG. 7A, the billing destination code is "R001", the billing destination is "A (overseas)", and the transaction currency is "USD". Using the billing party as a key, the transaction currency "USD" of the billing party master 106a is set in the order data (order header data).

FIG. 7B shows an example of data of the payee master 106b. The payee master 106b has items of payee code, payee, and transaction currency. In the example shown in FIG. 7B, the payee code is "P001", the payee is "A (domestic)", and the transaction currency is "JPY". Using the payee as a key, the transaction currency "USD" of the payee master 106b is set in the order data (order header data).

(Order input processing S1)
The order input processing will be described with reference to FIG. For example, the order entry input unit 102a receives an order number, billing address, product, contract currency, transaction currency, contract sales amount, transaction Order data including sales amount, Japanese sales amount, foreign currency profit, yen profit, foreign currency profit, and yen profit are entered and registered in the data file 106c. Order data including contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount, and Japanese currency premium amount are entered and registered in the data file 106c. 13 and 14 show display examples of the order input screen. The exchange rate at this point is 1 dollar = 100 yen.

FIG. 8A shows an example of order header data. The order header data includes order number, billing address, contract currency, transaction currency, contract sales amount, transaction sales amount, sales amount in Japanese currency, foreign currency profit, yen profit, foreign currency profit, and yen profit. I have. In the example shown in FIG. 8(A), order number "JU001", billing destination "A (overseas)", contract currency "USD", transaction currency "USD", contract sales amount "$100", transaction sales amount " $100”, Japanese sales amount “¥10,000”, Foreign currency profit “$20”, Yen profit “¥2,000”, Foreign currency charge “$20”, Charged Yen profit “¥900” It's becoming

FIG. 8B shows a data example of order detail data. The order detail data has items of order number, line number, product, contract sales amount, transaction sales amount, and Japanese currency sales amount. In the example shown in FIG. 8B, order number "JU001", line number "1", product "Product A", contract sales amount "$100", transaction sales amount "$100", Japanese currency sales amount "¥10" , 000”.

FIG. 8C shows an example of order header data. The order header data includes items such as order number, payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount, foreign currency premium amount, and Japanese currency premium amount. In the example shown in FIG. 8(C), order number "HA001", payee "A (domestic)", contract currency "USD", transaction currency "JPY", contract purchase amount "$80", transaction purchase The amount is "¥8,000", the purchase amount in Japanese currency is "¥8,000", the amount of foreign currency is "-", and the amount of Japanese currency is "¥1,100".

FIG. 8D shows an example of order detail data. The order detail data includes items of order number, line number, commodity, contract purchase amount, transaction purchase amount, and Japanese currency purchase amount. Here, "merchandise" includes expenses such as commissions and reimbursement expenses in addition to the actual merchandise. Transaction currency ≠ contract currency is only the product amount, and expenses such as commissions and reimbursement expenses remain in the transaction currency.
In the example shown in FIG. 8(C), the first line has order number "HA001", line number "1", product "product A", contract purchase amount "$80", transaction purchase amount "$80". , Japanese currency purchase amount "¥8,000", the second line is the purchase order number "HA001", line number "2", product "commission", contract purchase amount "¥500 (in transaction currency)", transaction Purchasing amount "¥500 (in transaction currency)", Japanese currency purchasing amount "¥500", third line is order number "HA001", line number "3", product "reimbursement charges", contract purchase The amount is “¥600 (in the transaction currency)”, the transaction purchase amount is “¥600 (in the transaction currency)”, and the Japanese currency purchase amount is “¥600”.

(Sales input processing S2)
Sales input processing will be described with reference to FIG. For example, the sales input unit 102b, in response to an operator's operation or the like on a sales screen (not shown) displayed on the monitor 114, sets the timing of determining yen as the sales recording date, and based on the order data, enters the sales number, the invoice, and the like. Enter sales data including destination, product, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit, foreign currency profit, and yen profit. 106c. The sales input unit 102b also creates collection schedule data based on the sales data and registers it in the data file 106c. The exchange rate at this point is 1 dollar = 90 yen.

FIG. 9A shows an example of sales header data. The sales header data includes items such as sales number, billing address, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit, foreign currency profit, and yen profit. may contain. In the example shown in FIG. 9A, sales number "UR001", billing destination "A (overseas)", contract currency "USD", transaction currency "USD", contract sales amount "$100", transaction sales amount " $100”, Japanese sales amount “¥9,000”, Foreign currency profit “$20”, Yen profit “¥1,800”, Foreign currency profit “$20”, Yen profit “¥700” It's becoming

FIG. 9B shows an example of sales detail data. The sales detail data includes items of sales number, line number, product, contract sales amount, transaction sales amount, and sales amount in Japanese currency. In the example shown in FIG. 9B, sales number "UR001", line number "1", product "product A", contract sales amount "$100", transaction sales amount "$100", Japanese currency sales amount "¥9" , 000”.

FIG. 9C shows an example of collection scheduled data. The scheduled collection data includes items of sales number, line number, product, transaction collection scheduled amount, Japanese currency collection scheduled amount, transaction applied amount, and Japanese currency applied amount. In the example shown in FIG. 9(C), sales number "UR001", line number "1", product "Product A", expected transaction recovery amount "$100", expected Japanese currency recovery amount "¥9,000", transaction consumption The amount that has been applied is “$0”, and the amount that has been applied in Japanese currency is “¥0”.

(Purchase input processing S3)
The purchase input unit 102c, for example, according to an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, sets the timing of determining the yen as the purchase recording date, and based on the order data, Enter purchase data including purchase number, payee, product, contract currency different from transaction currency, transaction currency, contract purchase amount, transaction purchase amount, purchase amount in Japanese currency, amount of miscellaneous charges in Japanese currency, and enter data file 106c. The purchase input unit 102c creates payment schedule data based on the purchase data and registers it in the data file 106c. The exchange rate at this point is 1 dollar = 90 yen.

FIG. 10A is a diagram showing an example of purchase header data. The purchase header data has the following items: purchase number, payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount, foreign currency premium amount, and Japanese currency premium amount. . In the example shown in FIG. 10(A), the purchase number "SI001", the payee "A (domestic)", the contract currency "USD", the transaction currency "JPY", the contract purchase amount "$80", the transaction specification The amount received is "¥7,200", the amount purchased in Japanese currency is "¥7,200", the amount of foreign currency charges is "-", and the amount of Japanese currency charges is "¥1,100".

FIG. 10B is a diagram showing an example of purchase detail data. The purchase detail data includes items such as purchase number, line number, commodity, contract purchase amount, transaction purchase amount, and Japanese currency purchase amount.
Transaction currency ≠ contract currency is only the product amount, and expenses such as commissions and reimbursement expenses remain in the transaction currency. In the example shown in FIG. 10(B), the first line contains purchase number "SI001", line number "1", product "product A", contract purchase amount "$80", transaction purchase amount "7, 200", purchase amount in Japanese currency "¥7,200", second line is purchase number "SI001", line number "2", product "commission", contract purchase amount "¥500 (in transaction currency)" ”, Transaction purchase amount “¥500 (in transaction currency)”, Japanese currency purchase amount “¥500”, 3rd line is purchase number “SI001”, line number “3”, product “reimbursement charges” , contract purchase amount “¥600 (in transaction currency)”, transaction purchase amount “¥600 (in transaction currency)”, and Japanese currency purchase amount “¥600”.

FIG. 10C shows an example of payment schedule data. The scheduled payment data includes items of sales number, line number, product, transaction payment amount, scheduled payment amount in Japanese currency, transaction applied amount, and Japanese currency applied amount. In the example shown in FIG. 10(B), the first line contains the purchase number "SI001", the line number "1", the product "Product A", the expected transaction payment amount "¥7,200", and the expected payment amount in Japanese currency " ¥7,200”, transaction reconciled amount “¥0”, Japanese currency reconciled amount “¥0”, 2nd line is purchase number “SI001”, line number “2”, product “promotion”, transaction Expected payment amount "¥500", planned payment amount in Japanese currency "¥500", transaction applied amount "¥0", Japanese currency applied amount "¥0", third line is purchase number "SI001", line Number "3", Product "Reimbursement charges", Transaction payment amount expected to be "¥600", Japanese currency payment expected amount "¥600", Transaction cleared amount "¥0", Japanese currency cleared amount "¥0" It's becoming

(Payment input processing S4)
The deposit input process will be described with reference to FIG. The deposit input unit 102d inputs the deposit data to the data file 106c in response to the operator's operation on a deposit input screen (not shown) displayed on the monitor 114, for example, when there is a deposit from the billing party. to register. Also, the deposit input unit 102d updates the collection schedule data in the data file 106c based on the deposit data.

FIG. 11A shows an example of deposit data. The payment data includes items of payment number, billing destination, transaction currency, and transaction payment amount. In the example shown in FIG. 11A, the payment number is "NY001", the billing destination is "A (overseas)", the transaction currency is "USD", and the transaction payment amount is "$100". FIG. 11B shows an example of the updated collection schedule data.

(Payment deposit processing S5)
The payment/receipt processing will be described with reference to FIG. For example, the payment input unit 102e inputs payment data and registers it in the data file 106c in response to an operator's operation on a payment input screen (not shown) displayed on the monitor 114, or the like. Also, the payment input unit 102e updates the payment schedule data in the data file 106c based on the payment data.

FIG. 12A shows an example of payment data. The payment data includes items of payment number, payee, transaction currency, and transaction payment amount. In the example shown in FIG. 12A, the payment number is SH001, the payee is "A (domestic)", the transaction currency is "JPY", and "¥8,300". FIG. 12B shows an example of updated payment schedule data.

(Balancing process by transaction S6)
The transaction-by-transaction income and expenditure inquiry process will be described with reference to FIGS. The transaction-by-transaction income and expenditure inquiry unit 102f refers to order data and order data registered in the data file 106c in response to an operator's operation or the like on an inquiry screen (not shown) displayed on the monitor 114. Display and output the income and expenditure table by transaction at the time of contract that allows confirmation of foreign currency profit and yen profit from orders and orders. For example, it is possible to output an income and expenditure table for each transaction at the time of contract, using slip information, billing destination and payment destination as keys.

The income and expenditure table by transaction at the time of the contract consists of slip information (order number, order number), sales information (customer, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount), and purchase (purchase ) information (payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount) and profit (foreign currency profit, yen profit) items (Fig. 3 ( A)). In the case of the above example, the data in the first row of the income and expenditure table by transaction at the time of contract in FIG. 3A is output.

In addition, the transaction-by-transaction balance inquiry unit 102f responds to the operator's operation on an inquiry screen (not shown) displayed on the monitor 114, based on the sales data and purchase data registered in the data file 106c. Display and output the income and expenditure table for each transaction at the time of posting that allows you to check the foreign currency profit and yen profit from sales and purchases at the time of posting. For example, it is possible to output an income and expenditure table for each transaction at the time of contract, using slip information, billing destination and payment destination as keys.

The income and expenditure table by transaction at the time of recording consists of slip information (sales number, purchase number), sales information (invoice destination, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount), and purchase (sales amount). input) information (payee, contract currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount) and profit (foreign currency profit, yen profit) items (Fig. 3) (B)). In the case of the above example, the data in the first row of the income and expenditure table by transaction at the time of accounting in FIG. 3B is output.

As described above, according to the present embodiment, order data including order number, billing destination, product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit , order number, payee, product, contract currency different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency, and register them in the data file 106c. With the order input unit 102a, the sales number, billing destination, product, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese sales amount, foreign currency, etc. A sales input unit 102b for inputting sales data including profit and profit in yen and registering it in the data file 106c. , a purchase input unit 102c for inputting purchase data including currency at the time of contract different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase amount and registering it in the data file 106c. Therefore, it is possible to accurately manage profits when the transaction currency and the contract currency are different.

[4. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the sales management system 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions of the sales management system 100, particularly the processing functions performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and can be stored in the sales management system as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the sales management system 100 via any network, and all or part of it can be downloaded as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc, etc. shall include any "portable physical medium".

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

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Sales management system 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 arbitrary peripheral devices are connected. Moreover, the sales management system 100 may be implemented by installing software (including programs, data, etc.) that implements the processing described in the present embodiment in the device.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

100 sales management system 102 control unit 102a order entry input unit 102b sales input unit 102c purchase input unit 102d payment input unit 102e payment input unit 102f income and expenditure inquiry unit by transaction 102g screen display control unit 102h master maintenance unit 104 communication interface unit 106 storage Section 106a Invoice Master 106b Payment Master 106c Data File 108 Input/Output Interface Section 112 Input Device 114 Output Device 200 Server 300 Network

Claims (7)

A sales management system comprising a control unit,
The control unit
Order data including order number, billing party, product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit, order number, payee, product, transaction currency are different Order entry input means for inputting and registering order data including contract currency, transaction currency, contract purchase amount, transaction purchase amount, and Japanese purchase amount in a storage unit;
Based on the order data, sales number, billing destination, product, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit sales input means for inputting sales data including
Based on the above order data, the purchase number, payee, product, currency at the time of contract that is different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency purchase input means for inputting purchase data including a payment amount and registering it in the storage unit;
A sales management system characterized by comprising: 2. The sales management system according to claim 1, wherein said order data and said sales data further include a foreign currency profit and a yen profit. 1. Item of goods in said order data and said purchase data includes expenses, only the price of goods is set in a currency at the time of contract different from the transaction currency, and the expenses remain in the transaction currency. Or the sales management system according to 2. The control unit further
A transaction-by-transaction income and expenditure inquiry means for outputting a transaction-by-transaction income and expenditure table at the time of contract that enables confirmation of foreign currency profit and yen profit from the order received and ordered at the time of the contract based on the order data and order data registered in the storage unit The sales management system according to any one of claims 1 to 3, characterized by: The transaction-by-transaction income and expenditure inquiry means creates a transaction-by-transaction income and expenditure table at the time of recording that enables confirmation of foreign currency profits and yen profits from sales and purchases at the time of recording, based on the sales data and purchase data registered in the storage unit. 5. The sales management system according to claim 4, wherein the information is output. A sales management method executed by an information processing device having a control unit,
Executed in the control unit,
Order data including order number, billing party, product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit, order number, payee, product, transaction currency are different an order entry step of entering order data including contract currency, transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency and registering them in a storage unit;
Based on the order data, sales number, billing destination, product, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit a sales input step of inputting sales data including
Based on the above order data, the purchase number, payee, product, currency at the time of contract that is different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency a purchase input step of inputting purchase data including a payment amount and registering it in the storage unit;
A sales management method comprising: A sales management program to be executed by an information processing device having a control unit,
In the control unit,
Order data including order number, billing party, product, contract currency, transaction currency, contract sales amount, transaction sales amount, Japanese currency sales amount, foreign currency profit, yen profit, order number, payee, product, transaction currency are different an order entry step of entering order data including contract currency, transaction currency, contract purchase amount, transaction purchase amount, and purchase amount in Japanese currency and registering them in a storage unit;
Based on the order data, sales number, billing destination, product, currency at the time of contract, transaction currency, contract sales amount, transaction sales amount, Japanese yen sales amount, foreign currency profit, yen profit a sales input step of inputting sales data including
Based on the above order data, the purchase number, payee, product, currency at the time of contract that is different from the transaction currency, transaction currency, contract purchase amount, transaction purchase amount, Japanese currency a purchase input step of inputting purchase data including a payment amount and registering it in the storage unit;
Sales management program for executing

Images