JP2020181615A - Selling information device, amount retroaction method and amount retroaction program - Google Patents

Abstract

To provide a selling information device capable of performing collective update processing under certain conditions for a unit price of temporarily registered reception and payment, and to provide an amount retroaction method and an amount retroaction program.SOLUTION: In the embodiment, a selling information device is configured to: (1) refer to registered content of a stocking unit price master for retroaction for each stocking details to be retroacted; (2) when a corresponding stocking unit price master for retroaction exists, recalculate an amount and a consumption tax by adopting a price unit on the master; and (3) associate and update debt information and payment schedule information to stocking history information and a payment destination about a slip on the basis of a recalculated result.SELECTED DRAWING: Figure 2

Description

The present invention relates to a sales information device, an amount retroactive method, and an amount retroactive program.

Patent Document 1 states, "After conducting a commercial transaction, the content of the commercial transaction may be modified. For example, the business practice of the petrochemical industry is a post-price method. First, an annual contract is concluded for products such as naphtha at a tentative unit price, and billing and payment are made at a tentative price based on the quantity sold and purchased. At a later date, it is customary to determine a formal unit price in consideration of market conditions for each period, and to retroactively carry out tentatively decided commercial transactions and charge and pay the difference. (See paragraph 0124).

Japanese Unexamined Patent Publication No. 2002-41750

However, in the prior art, it has not been possible to perform a batch rewashing process under certain conditions for the temporarily registered unit price of receipt and payment.

The present invention has been made in view of the above problems, and is a sales information device, an amount retroactive method, and an amount retroactive method capable of collectively rewashing a temporarily registered unit price of receipts and payments under certain conditions. The purpose is to provide a program.

In order to solve the above-mentioned problems and achieve the object, the sales information device according to the present invention is a sales information device provided with a control unit, and the control unit is traded at a provisional unit price and a formal unit price. Is the formal unit price of the product, the product identification information of the product, the transaction classification of the product and the product identification information of the product including at least the application period of the formal unit price, the unit price of the product, the transaction classification of the product determined after the transaction. And the acquisition means for acquiring the formal unit price applied to the product included in the slip from the unit price master by comparing with the voucher including at least the transaction date of the product, and the acquisition means for acquiring the unit price included in the voucher. It is characterized by having a means of changing to the acquired unit price.

Further, in the sales information device according to the present invention, in the sales information device, the slip further includes the amount of goods and the quantity of goods, and the control unit has the unit price acquired by the acquisition means and the slip. A calculation means for calculating the product of the quantities included in the slip is further provided, and the changing means changes the amount of money included in the slip to the product calculated by the calculation means.

Further, in the sales information device according to the present invention, in the sales information device, the transaction category is a purchase category in which any one of a warehouse purchase and a direct purchase is set, and the applicable period is applicable. The start date and the application end date, the transaction date is the purchase date, and the unit price master is a delivery arrangement category and a product in which any one of a plurality of predefined categories regarding the way of delivery arrangement is set. Further includes the supplier identification information of the supplier, the slip further includes the delivery arrangement classification and the supplier identification information, and the acquisition means is the purchase included in the unit price master. When the condition that the classification, the delivery arrangement classification, the supplier identification information, and the product identification information match those included in the slip and the condition that the purchase date is after the application start date and before the application end date are satisfied. It is characterized in that a formal unit price is obtained from the unit price master.

Further, in the sales information device according to the present invention, in the sales information device, the unit price master can further store the shipping source identification information of the shipping source of the product and the delivery destination identification information of the delivery destination of the product. The slip further includes a shipping source identification information and a delivery destination identification information, and the acquisition means includes a condition that the purchase category included in the slip is a warehouse purchase and a shipment included in the unit price master. When the condition that the original identification information is not registered or matches the one included in the slip is further satisfied, or the condition that the purchase category included in the slip is a direct purchase and the shipping source included in the unit price master. Further, the condition that the identification information is unregistered or matches the one contained in the slip and the condition that the delivery destination identification information included in the unit price master is unregistered or matches the one contained in the slip are further added. When the condition is satisfied, the formal unit price is obtained from the unit price master.

Further, in the sales information device according to the present invention, in the sales information device, the transaction category is a sales category in which any one of Kurade sales and direct delivery sales is set, and the applicable period is the application start date and the application start date. The application end date, the transaction date is the sales date, and the unit price master is a delivery arrangement category in which one of a plurality of predefined categories relating to the way of delivery arrangement is set, and a sales destination of the product. The sales destination identification information and the delivery destination identification information of the delivery destination of the product are further included, and the slip further includes the delivery arrangement classification, the sales destination identification information and the delivery destination identification information, and the acquisition means is The condition that the sales category, delivery arrangement category, sales destination identification information, delivery destination identification information, and product identification information included in the unit price master match those included in the slip, and the sales date are after the application start date and the application end date. It is characterized in that a formal unit price is obtained from the unit price master when the condition that it is before is satisfied.

Further, in the sales information device according to the present invention, in the sales information device, the unit price master can further store the shipping source identification information of the shipping source of the product, and the slip further stores the shipping source identification information. The acquisition means further includes a condition that the sales category included in the slip is Kurade sales and a condition that the shipping source identification information included in the unit price master matches that included in the slip. When the condition is satisfied, or when the condition that the sales category included in the slip is direct sales and the condition that the shipping source identification information included in the unit price master is unregistered or matches that included in the slip are further satisfied. , The formal unit price is obtained from the unit price master.

Further, the amount retroactive method according to the present invention is an amount retroactive method executed by a sales information device provided with a control unit, and is executed by the control unit and is traded at a provisional unit price and the formal unit price is the said. The unit price master and product identification information including at least the formal unit price of the product, the product identification information of the product, the transaction classification of the product and the application period of the formal unit price determined after the transaction, the unit price of the product, the transaction classification of the product and the product The acquisition step of acquiring the formal unit price applied to the product included in the slip from the unit price master and the unit price included in the slip were acquired in the acquisition step by comparing with the slip including at least the transaction date of. It is characterized by including a change step for changing to a unit price.

Further, the amount retroactive program according to the present invention is an amount retroactive program for being executed by a sales information device provided with a control unit, and is traded at a provisional unit price and formal unit price for being executed by the control unit. Is the formal unit price of the product, the product identification information of the product, the transaction classification of the product and the product identification information of the product including at least the application period of the formal unit price, the unit price of the product, the transaction classification of the product determined after the transaction. And the acquisition step of acquiring the formal unit price applied to the product included in the voucher from the unit price master by comparing with the voucher including at least the transaction date of the product, and the unit price included in the voucher in the acquisition step. It is characterized by including a change step for changing to the acquired unit price.

According to the present invention, it is possible to carry out a batch rewashing process under certain conditions with respect to the temporarily registered unit price of receipt and payment.

FIG. 1 is a diagram showing an outline of the sales unit price retroactive processing. FIG. 2 is a diagram showing an outline of the purchase unit price retroactive processing. FIG. 3 is a block diagram showing an example of the configuration of the sales information device 100. FIG. 4 is a diagram showing an example of the retroactive sales unit price master 106a. FIG. 5 is a diagram showing an example of the retroactive purchase unit price master 106b. FIG. 6 is a diagram showing an example of the sales data table 106c. FIG. 7 is a diagram showing an example of the purchase data table 106d. FIG. 8 is a diagram showing an example of the condition designation screen M. FIG. 9 is a flowchart showing an example of the main process executed by the sales information device 100 in the present embodiment. FIG. 10 is a diagram showing an example of condition designation. FIG. 11 is a diagram showing an example of the sales data table 106c. FIG. 12 is a diagram showing an example of condition designation. FIG. 13 is a diagram showing an example of the purchase data table 106d.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
The present embodiment relates to a function of retroactively updating the sales unit price and the purchase unit price in a business format that handles futures products.

For example, in the present embodiment, on the (A1) condition specification screen, the conditions of the sales slip to be retroactively targeted this time are selected, (A2) the billing completion check of the target slip is performed, and (A3) the target sales slip is checked. Check if (Details) is in the exclusive state, and if (A4) is not in the exclusive state, the sales slip (in the case of direct delivery, the purchase slip) containing the details to be retroactive is processed in retroactive unit price. Set it to the exclusive state as being executed, (A5) refer to the registered contents of the retroactive sales unit price master for each target sales item, and (A6) if the corresponding retroactive sales unit price master exists, the unit price on the master It is adopted to recalculate the amount and consumption tax, (A7) overwrite the sales data update operator ID with the unit price retroactive processing execution operator ID, and (A8) release the exclusive state of the target sales slip (see FIG. 1). ). In the process of (A2), in the case of the request provisional tightening / confirmation state, the slip may be internally excluded from the processing target so that an error does not occur. Further, in the process of (A3), if there is a slip in the exclusive state, an error may be generated. Further, in the process of (A6), the sales history information regarding the slip, the claim information for the billing destination, and the collection schedule information may be linked and re-examined as a result of the recalculation. Further, in the process of (A6), when one of the slips having a plurality of details is retroactively targeted, even if the slip information is changed with the contents after the amount of the one detail is changed. Good.

Further, for example, in the present embodiment, on the (B1) condition specification screen, the condition of the purchase slip to be retroactively targeted this time is selected, (B2) the billing completion check of the target slip is performed, and (B3) the target. Check if the purchase slip (details) is in the exclusive state, and if (B4) is not in the exclusive status, the purchase slip (sales slip in the case of direct delivery) including the details to be retroactively sent. Is set to the exclusive state as the unit price retroactive processing is being executed, and (B5) the registered contents of the retroactive purchase unit price master are referred to for each purchase item that is the target of retrospective, and (B6) the corresponding retroactive purchase unit price master is If it exists, the unit price on the master is adopted to recalculate the amount and consumption tax, and (B7) In the case of retroactive purchase slips linked to sales, the cost and gross profit amounts in the sales data are also washed. Instead, (B8) the update operator ID of the purchase data is overwritten with the unit price retroactive processing execution operator ID, and (B9) the exclusive state of the target purchase slip is released (see FIG. 2). In the process of (B2), if the payment is closed / confirmed, the slip may be internally excluded from the process so that an error does not occur. Further, in the process of (B3), if there is a slip in the exclusive state, an error may be generated. Further, in the process of (B6), the purchase history information related to the slip, the debt information to the payee, and the payment schedule information may be linked and rewritten as the result of the recalculation. Further, in the process of (B6), when one of the slips having a plurality of details is retroactively targeted, even if the slip information is changed with the contents after the amount of the one detail is changed. Good.

[2. Constitution]
An example of the configuration of the sales information device according to the present embodiment will be described with reference to FIG. 3 and the like. FIG. 3 is a block diagram showing an example of the configuration of the sales information device 100.

The sales information device 100 is a commercially available desktop personal computer in which a sales information system (sales management system) is introduced. The sales information device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

The sales information device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the sales information device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the sales information device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the sales information device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, an intranet, a LAN (Local Area Network), or the like.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a retroactive sales unit price master 106a, a retroactive purchase unit price master 106b, a sales data table 106c, and a purchase data table 106d.

The retroactive sales unit price master 106a (corresponding to the unit price master of the present invention) includes a sales category (corresponding to the sales category of the present invention), a delivery category (corresponding to the delivery arrangement category of the present invention), and a customer (sales destination of the present invention). (Corresponding to identification information), delivery destination (corresponding to delivery destination identification information of the present invention), product (corresponding to product identification information of the present invention), own warehouse, shipping base (corresponding to shipping source identification information of the present invention), application It is a table containing data such as a start date (corresponding to the application start date of the present invention), an application end date (corresponding to the application end date of the present invention), and a unit sales price (corresponding to the formal unit price of the present invention). (See FIG. 4). Here, two sales categories, "Kuraide sales" and "direct sales", are defined in advance. In addition, based on the way of delivery arrangements, three delivery categories, "arrangement before customer", "arrangement in-house", and "arrangement by supplier" are defined in advance. Here, "arrangement before the customer" means that there is a delivery arrangement request from the "delivery destination of the product" (for example, the final delivery destination) ahead of the customer in the commercial distribution. "In-house arrangement" refers to the delivery arrangement by our company. "Supplier arrangement" refers to the case where the oil wholesaler (mainly the manufacturer) requests the specification of the delivery method at the time of direct delivery.

The retroactive purchase unit price master 106b (corresponding to the unit price master of the present invention) is a purchase classification (corresponding to the purchase classification of the present invention), a delivery arrangement classification (corresponding to the delivery arrangement classification of the present invention), and a supplier code. (Corresponding to the supplier identification information of the present invention), Warehouse (shipping base) code (corresponding to the shipping source identification information of the present invention), Delivery destination code (corresponding to the delivery destination identification information of the present invention), Product code (corresponding to the present invention) The product identification information of the present invention, the application start date (corresponding to the application start date of the present invention), the application end date (corresponding to the application end date of the present invention), and the purchase body unit price (corresponding to the formal unit price of the present invention). It is a table containing information such as (corresponding) (see FIG. 5). Here, two purchase categories, "Kurairi purchase" and "Direct purchase", are defined in advance. In addition, three delivery arrangement categories, "arrangement before customer", "in-house arrangement", and "supplier arrangement", are defined in advance based on the way of delivery arrangement.

The sales data table 106c (including the slip of the present invention) contains a number for identifying a record, a sales office, a sales number, a line number, a sales date, a sales classification, a CD (delivery arrangement classification code), a delivery arrangement classification, It is a table containing information such as a customer, a delivery destination, a warehouse (own warehouse), a product, a warehouse CD (shipping base code), a shipping base, a closing state, a unit sales price, a sales amount, and a sales quantity (see FIG. 6). Here, the information on the shipping base is obtained from the purchase data table 106d. The sales number is a number for identifying the sales slip. The line number is a number for identifying the details included in the sales slip.

The purchase data table 106d (including the slip of the present invention) contains a number for identifying a record, a purchase place, a purchase number, a line number, a purchase date, a purchase classification, and a CD (delivery arrangement classification code). , Delivery arrangement classification, supplier, warehouse CD (shipping base code), shipping base, warehouse (own warehouse), product, closing status, delivery destination, purchase unit price, purchase amount and purchase quantity, etc. It is a table (see FIG. 7). Here, the delivery destination information is obtained from the sales data table 106c. The purchase number is a number for identifying the purchase slip. The line number is a number for identifying the details included in the purchase slip.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The control unit 102 is a CPU or the like that collectively controls the sales information device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally includes a retroactive target data acquisition unit 102a, a retroactive unit price acquisition unit 102b including the acquisition means of the present invention, and a retroactive processing unit 102c including the calculation means and the changing means of the present invention. There is.

The retroactive target data acquisition unit 102a acquires the sales slip data to be retroactively targeted from the sales data table 106c according to the designated conditions. Further, the retroactive target data acquisition unit 102a acquires the purchase slip data to be retroactively targeted from the purchase data table 106d according to the designated conditions. Regarding the processing performed by the retroactive target data acquisition unit 102a, the following [4. Specific example of processing] will be described in detail.

The retroactive unit price acquisition unit 102b compares the retroactive sales unit price master 106a with the retroactive target sales slip data acquired by the retroactive target data acquisition unit 102a, and is applied to the retroactive target sales slip data from the retroactive sales unit price master 106a. Get the unit price. Specifically, the retroactive unit price acquisition unit 102b refers to the retroactive sales unit price master 106a for each retroactive target sales slip data (record) acquired by the retroactive target data acquisition unit 102a, and refers to the retroactive unit price corresponding to each record. (Sales unit price) is acquired.

The retroactive unit price acquisition unit 102b compares the retroactive purchase unit price master 106b with the retroactive target purchase slip data acquired by the retroactive target data acquisition unit 102a, and from the retroactive purchase unit price master 106b, the retroactive purchase slip. Get the unit price applied to the data. Specifically, the retroactive unit price acquisition unit 102b corresponds to each record by referring to the retroactive purchase unit price master 106b for each retroactive target purchase slip data (record) acquired by the retroactive target data acquisition unit 102a. Acquire the retroactive unit price (purchase main unit price).

Regarding the processing performed by the retroactive unit price acquisition unit 102b, the following [4. Specific example of processing] will be described in detail.

The retroactive processing unit 102c recalculates the sales amount included in the retroactive target sales slip data based on the sales unit price acquired by the retroactive unit price acquisition unit 102b and the quantity included in the retroactive target sales slip data, and acquires the sales amount. Based on the sales unit price and the recalculated sales amount, the sales unit price and the sales amount included in the retroactive sales slip data are refreshed (updated).

The retroactive processing unit 102c recalculates the purchase amount included in the retroactive target purchase slip data based on the purchase main unit price acquired by the retroactive unit price acquisition unit 102b and the quantity included in the retroactive target purchase slip data. , Based on the acquired purchase unit price and the recalculated purchase amount, the purchase unit price and purchase amount included in the retroactive purchase slip data are refreshed (updated).

Regarding the processing performed by the retroactive processing unit 102c, the following [4. Specific example of processing] will be described in detail.

[3. Screen configuration example]
Here, a configuration example of the condition specification screen M will be described with reference to FIG. The screen shown in FIG. 8 is for allowing the operator to select the sales slip data to be retroactively targeted in the sales unit price retroactive processing described later.

The condition specification screen M has an area 1 for inputting the range of the sales office, an area 2 for inputting the range of the sales date, an area 3 for inputting the range of the sales category, and a delivery arrangement category. Area 4 for inputting the range, area 5 for inputting the range of the sales person, area 6 for inputting the range of the customer, and area 7 for inputting the range of the delivery destination. Area 8 for inputting the range of the shipping base, area 9 for inputting the range of the company's warehouse, area 10 for inputting the range of products, and area 11 for inputting the range of the sales number. , And an area 12 for displaying the progress of processing executed by each processing unit of the control unit 102.

The condition specification screen for allowing the operator to select the purchase slip data to be retroactively selected in the purchase unit price retroactive processing described later is the screen M shown in FIG. 8 with the following changes and deletions. May be good.
-Changed area 1 to area 3, area 5, and area 11 so that the range of each range of purchase place, purchase date, purchase classification, purchase person, and purchase number can be input.
-Deleted area 6 and area 9.

[4. Specific example of processing]
Specific examples of the sales unit price retroactive processing and the purchase unit price retroactive processing carried out in the present embodiment will be described with reference to FIGS. 9 to 13 and the like.

[4-1. Specific example of retroactive sales unit price]
A specific example of the sales unit price retroactive processing will be described with reference to FIGS. 9 to 11 and the like. FIG. 9 is a flowchart showing an example of the main process executed by the sales information device 100 in the present embodiment. In this description, it is assumed that the data shown in FIG. 6 is stored in the sales data table 106c.

[Step S1: Acquisition of retroactive target data]
The retroactive target data acquisition unit 102a acquires the sales slip data to be retroactively targeted from the sales data table 106c according to the conditions input on the condition specification screen M. Specifically, when the input sales category is "Kuraide sales", the retroactive target data acquisition unit 102a is good at the input sales office, sales date, sales category, delivery arrangement category, sales person, and specialty. Use the destination, delivery destination, own warehouse, product, and sales number as conditions to narrow down the sales slip data that includes the same data as the conditions. In addition, when the input sales category is "direct sales", the retroactive target data acquisition unit 102a has the input sales office, sales date, sales category, delivery arrangement category, sales person, customer, and delivery destination. , Shipping base, product, and sales category are used as conditions to narrow down sales slip data that includes the same data as the conditions.

For example, when the condition shown in FIG. 10 is specified on the condition specification screen M, the sales slip data including the data in the thick frame shown in FIG. 11 is selected from the sales slip data stored in the sales data table 106c. To be acquired. In FIG. 11, No. The record of No. 4 is No. 4 selected as a retroactive target. The same slip as the record of 3, but No. Since the data of the company's warehouse included in the record of 4 is different from the specified one, No. Record 4 is not selected as a retroactive target. That is, No. as sales detail data. Record 4 is not retroactive. However, retroactively occurs for the slip of the sales number "A110" including the record. Further, in FIG. 11, No. 8 and No. As for the record 9, since the data of the shipping base is not registered at the time of inputting the sales, the data of the shipping base is not registered. Therefore, when the range of the shipping base is specified on the condition specification screen M, these records are not selected. However, if the range of the shipping base is not entered on the condition specification screen M, the data of all the shipping bases are unconditionally selected.

[Step S2: Acquisition of retroactive unit price]
The retroactive unit price acquisition unit 102b refers to the retroactive sales unit price master 106a for each sales slip data acquired in step S1 and acquires the retroactive unit price (sales main unit price) applied to the products included in each sales slip data. To do.

Note that the conditions for acquiring the sales unit price differ depending on the sales category data included in the sales slip data, as shown below.

Specifically, when the retroactive unit price acquisition unit 102b has the sales category included in the sales slip data = "warehouse sales", the "sales category, delivery arrangement category, customer, delivery destination, etc. included in the sales slip data". The warehouse (own warehouse) and the product match those included in the retroactive sales unit price master, and the retroactive sales unit price master. The application start date is before the sales date and is the latest date. " Get the record of the sales unit price master.

Further, when the sales category included in the sales slip data = "direct sales", the retroactive unit price acquisition unit 102b records the conditions from the retroactive sales unit price master 106a in the following order (11) and (12). To get.
(11) "Sales classification, delivery arrangement classification, customer, delivery destination and product included in sales slip data match those included in the retroactive sales unit price master, and the retroactive sales unit price master. Warehouse (shipping base) ) Is unregistered and the retroactive sales unit price master. The application start date is before the sales date and is the latest date ”, and the record of the retroactive sales unit price master is acquired.
(12) "Sales classification, delivery arrangement classification, customer, delivery destination, product and warehouse (shipping base) included in the sales slip data match those included in the retroactive sales unit price master, and the retroactive sales unit price Master. Acquire a record of the retroactive sales unit price master that satisfies the condition that the application start date is before the sales date and is the latest date.

[Step S3: Retroactive processing]
The retroactive processing unit 102c replaces (updates) the sales unit price included in the sales slip data with the retroactive unit price (sales main unit price) acquired in step S2, and changes the sales amount included in the sales slip data to step S2. By substituting the product of the retroactive unit price (sales body unit price) and the quantity included in the sales slip data, the data of the sales unit price and the sales amount included in the sales slip data (including the case of sales detail data) can be re-recorded. create. Here, when the quantity is zero, such sales slip data is not subject to processing. Further, if the retroactive unit price cannot be acquired in step S2 or if the retroactive unit price acquired in step S2 is zero yen, the washing is not performed.

With the above, [4-1. Specific example of retroactive sales unit price processing] is completed.

[4-2. Specific example of purchase unit price retroactive processing]
A specific example of the purchase unit price retroactive processing will be described with reference to FIGS. 9, 12, 13, 13, and the like. In this description, it is assumed that the data shown in FIG. 7 is stored in the purchase data table 106d. Further, in this description, [4-1. Specific example of retroactive sales unit price] The same as the explanation in] may be omitted.

[Step S1: Acquisition of retroactive target data]
The retroactive target data acquisition unit 102a acquires the purchase slip data to be retroactively targeted from the purchase data table 106d according to the conditions input on the condition specification screen M. Specifically, when the input purchase category is "Kurairi purchase", the retroactive target data acquisition unit 102a has the input purchase establishment, purchase date, purchase category, delivery arrangement category, and so on. Use the purchaser, supplier, shipping base, product, and purchase number as conditions to narrow down the purchase slip data that contains the same data as the conditions. In addition, when the input purchase category is "direct purchase" and the delivery arrangement category is "supplier arrangement", the retroactive target data acquisition unit 102a has entered the purchase place and purchase date. , Purchase classification, delivery arrangement classification, purchaser, supplier, shipping base, product, delivery destination, and purchase number are used as conditions to narrow down the purchase slip data that includes the same data as the conditions. In addition, when the input purchase category is "direct purchase" and the delivery arrangement category is "in-house arrangement" or "pre-customer arrangement", the retroactive target data acquisition unit 102a is the input purchase business. Purchasing slip data containing the same data as the conditions, using the place, purchase date, purchase classification, delivery arrangement classification, purchaser, supplier, shipping base, product, and purchase number as conditions. Narrow down.

For example, when the condition shown in FIG. 12 is specified on the condition specification screen M, the purchase slip data including the data in the thick frame shown in FIG. 13 among the purchase slip data stored in the purchase data table 106d. Is selected and acquired. In addition, in FIG. 13, No. No. 8 records are selected as retroactive targets. The same slip as the record of 7, but No. Since the data of the shipping base included in the record of No. 8 is different from the specified one, No. Eight records are not selected for retrospective. That is, No. as purchase details data. Eight records are not retroactive. However, retroactively occurs for the slip of the purchase number "S120" including the record. Further, in FIG. 13, No. 5 and No. For the record of 6, the data of the shipping base was not registered at the time of purchase input, and No. 12 and No. Since the shipping base data is not registered for the 13 records at the time of sales input, the shipping base data is in an unregistered state. Therefore, when the range of the shipping base is specified on the condition specification screen M, these records are not selected. However, if the range of the shipping base is not entered on the condition specification screen M, the data of all the shipping bases are unconditionally selected. Further, in FIG. 13, No. The 19 records are not selected because the closing status data is "payment closed". On the other hand, No. For the 20 records, the closing status data is "billing closed" (that is, the corresponding sales slip is billed closed), but it is selected. That is, when the data of the closing state included in the purchase data table 106d is "payment closed", it is excluded from the selection target regardless of the condition specified on the condition specification screen M.

[Step S2: Acquisition of retroactive unit price]
The retroactive unit price acquisition unit 102b refers to the retroactive purchase unit price master 106b for each purchase slip data acquired in step S1, and the retroactive unit price (purchase main body) applied to the products included in each purchase slip data. Unit price) is acquired.

The conditions for acquiring the purchase unit price differ depending on the purchase category data and the delivery arrangement category data included in the purchase slip data, as shown below.

Specifically, when the purchase category = "Kurairi purchase" included in the purchase slip data, the retroactive unit price acquisition unit 102b performs the retroactive purchase unit price in the following order (21) and (22). A record satisfying the conditions is acquired from the master 106b.
(21) “Purchase classification, delivery arrangement classification, supplier and goods included in the purchase slip data match those included in the retroactive purchase unit price master, and the retroactive purchase unit price master. Warehouse ( The shipping base) is not registered, and the retroactive purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date. ” Get the record of the unit price master.
(22) "Purchase classification, delivery arrangement classification, supplier, product, warehouse (shipping base) included in the purchase slip data match those included in the retroactive purchase unit price master, and retroactive purchase. Acquire the record of the retroactive purchase unit price master that satisfies the condition that "the purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date".

Further, when the retroactive unit price acquisition unit 102b has the purchase category = "direct purchase" included in the purchase slip data and the delivery arrangement = "supplier" included in the purchase slip data, the following Records satisfying the conditions are acquired from the retroactive purchase unit price master 106b in the order of (31) to (34).
(31) “Purchase classification, delivery arrangement classification, supplier and goods included in the purchase slip data match those included in the retroactive purchase unit price master, and the retroactive purchase unit price master. Warehouse ( (Shipping base) and retroactive purchase unit price master. The delivery destination is not registered, and the retroactive purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date. The record of the retroactive purchase unit price master that satisfies the condition of "is" is acquired.
(32) “Purchase classification, delivery arrangement classification, supplier, product and warehouse (shipping base) included in the purchase slip data match those included in the retroactive purchase unit price master, and the retroactive purchase Receipt unit price master. Delivery destination is not registered and retroactive purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date. " Get the record of the purchase unit price master.
(33) "The purchase classification, delivery arrangement classification, supplier, product, warehouse (shipping base) and delivery destination included in the purchase slip data match those included in the retroactive purchase unit price master, and Unit price master. Warehouse (shipping base) is not registered, and retroactive purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date. " , Get the record of the retroactive purchase unit price master.
(34) "Purchase classification, delivery arrangement classification, supplier, product, warehouse (shipping base) and delivery destination included in the purchase slip data match, and the retroactive purchase unit price master. Application start date is Acquire the record of the retroactive purchase unit price master that satisfies the condition "before the purchase date and the latest date included in the purchase slip data".
In other words, since the retroactive purchase unit price master side allows the delivery destination = "no registration", the master that the delivery destination has not registered first makes an application, and then again for the retroactive target slip. , Perform the application with the master for which detailed conditions including the delivery destination are set.

In addition, the retroactive unit price acquisition unit 102b has the purchase category included in the purchase slip data = "direct purchase" and the delivery arrangement included in the purchase slip data = "in-house" or "before the customer". If there is, records satisfying the conditions are acquired from the retroactive purchase unit price master 106b in the order of (41) and (42) below.
(41) “Purchase classification, delivery arrangement classification, supplier, product and warehouse (shipping base) included in the purchase slip data match those included in the retroactive purchase unit price master, and the retroactive purchase Receipt unit price master. Delivery destination is not registered and retroactive purchase unit price master. The application start date is before the purchase date included in the purchase slip data and is the latest date. " Get the record of the purchase unit price master.
(42) "Purchase classification, delivery arrangement classification, supplier, product, warehouse (shipping base), and delivery destination included in the purchase slip data match those included in the retroactive purchase unit price master, and A record of the retroactive purchase unit price master that satisfies the condition that "the application start date is before the purchase date included in the purchase slip data and is the latest date" is acquired.

[Step S3: Retroactive processing]
The retroactive processing unit 102c replaces (updates) the purchase unit price included in the purchase slip data with the retroactive unit price (purchase main unit unit price) acquired in step S2, and the purchase amount included in the purchase slip data. Is included in the purchase slip data (including the case of purchase details data) by replacing the product with the product of the retroactive unit price (purchase main unit price) acquired in step S2 and the quantity included in the purchase slip data. Recreate the purchase unit price and purchase amount data. Here, when the quantity is zero, such purchase slip data is not subject to processing. Further, if the retroactive unit price cannot be acquired in step S2 or if the retroactive unit price acquired in step S2 is zero yen, the washing is not performed. In addition, when the purchase category included in the purchase slip data is "direct purchase", the cost and gross profit items included in the corresponding sales slip data are also updated.

With the above, [4-2. Specific example of purchase unit price retroactive processing] is completed.

[5. Summary of this embodiment and other embodiments]
As described in detail above, the present embodiment relates to a retroactive update function for "sales / purchase unit price" in a business format that handles futures products. In the case of a corporate format that handles futures products, the unit price is fixed (determined) after a certain period of time has passed, but in this embodiment, the unit price of the temporarily registered receipts and payments is collectively rewashed under certain conditions. It will be possible to do. Specifically, in the present embodiment, (1) the sales unit price is rewashed by the retroactive batch renewal process, (2) the purchase unit price is rewashed by the retroactive batch renewal process, (3). It is possible to create conditions for attaching unit prices (retroactive unit price master).

Until now, in the case of a business format that handles futures-related products (for example, energy, sugar, or wheat, etc.), it is necessary to reclassify sales slips for a certain period of time according to certain rules, but all of them have certain conditions. There was no processing function to change the unit price. Therefore, it is troublesome to manually call up the past slips and correct them one by one.

Therefore, in the present embodiment, by adopting the above-described configuration and processing, it has succeeded in significantly reducing the labor required so far.

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

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

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

Further, with respect to the sales information device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the sales information device 100, particularly each processing function performed by the control unit, all or any part thereof may be realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the sales information apparatus is required. Read mechanically to 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in the application program server connected to the sales information device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. is there.

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

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

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

Further, the sales information 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 an arbitrary peripheral device is connected. Further, the sales information device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

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

The present invention is particularly useful in industries dealing with futures products.

100 Sales information device 102 Control unit 102a Retroactive target data acquisition unit 102b Retroactive unit price acquisition unit 102c Retroactive processing unit 104 Communication interface unit 106 Storage unit 106a Retroactive sales unit price master 106b Retroactive purchase unit price master 106c Sales data table 106d Purchase data Table 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (1)

It is a sales information device equipped with a control unit.
The control unit
From the unit price master that includes at least the formal unit price of the product that is traded at the provisional unit price and the formal unit price is determined after the transaction, the product identification information of the product, the transaction classification of the product, and the application period of the formal unit price, the product of the product An acquisition means for acquiring the formal unit price corresponding to each item for each item included in the slip including the identification information, the unit price of the product, the transaction category of the item, and the item including at least the transaction date of the item.
A sales information device including a changing means for changing the unit price included in the slip to the unit price acquired by the acquisition means.

Images