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

Abstract

PROBLEM TO BE SOLVED: To provide a selling information device capable of performing collective update processing of a unit price of temporarily registered reception and payment, and to provide an amount retroaction method, and an amount retroaction program.SOLUTION: In the case of finding that a corresponding to a stocking unit price master for retroaction exists with reference to registered contents of stocking unit price master for retroaction for each stocking detail to be retroacted, an amount and a consumption tax are recalculated by adopting a price unit on the master, debt information and payment schedule information to stocking history information and a payment destination about the slip are also matched and updated on the basis of a result of the recalculation.SELECTED DRAWING: Figure 2

Description

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

  Japanese Patent Application Laid-Open No. 2004-133620 “In some cases, after executing a commercial transaction, the content of the commercial transaction is corrected. For example, business customs in the petrochemical industry are post-price determination methods. First, an annual contract is signed for a product 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 decide the official unit price in consideration of the market situation every period, and to retroactively make provisional transactions and charge and pay the difference. (See paragraph 0124).

JP 2002-41750 A

  However, in the prior art, it is not possible to perform batch cleaning processing under certain conditions with respect to the temporarily registered unit price.

  The present invention has been made in view of the above-described problems, and is a sales information device, a retroactive amount method, and a retroactive amount of money that can be batch-replaced under certain conditions with respect to a temporarily registered unit price. The purpose is to provide a program.

  In order to solve the above-described problems and achieve the object, a sales information device according to the present invention is a sales information device including a control unit, and the control unit is traded at a tentative unit price and an official unit price. The unit price master and product identification information, product unit price, product transaction category, including at least the official unit price of the product determined after the transaction, product product identification information, product transaction category and official unit price application period And an acquisition means for obtaining a formal unit price applied to the product included in the slip from the unit price master, and a unit price included in the slip by the acquisition means And changing means for changing to the acquired unit price.

  In the sales information device according to the present invention, in the sales information device, the slip further includes a product amount and a product quantity, and the control unit acquires the unit price acquired by the acquisition unit and the slip. And calculating means for calculating the product of the quantities included in the slip, wherein the changing means changes the amount of money included in the slip to the product calculated by the calculating means.

  Further, in the sales information device according to the present invention, in the sales information device, the transaction classification is a purchase classification in which any one of warehouse purchase and direct delivery purchase is set, and the application period is applied. The delivery date and application end date, the transaction date is a purchase date, and the unit price master is set to one of a plurality of predefined categories relating to the way delivery is arranged. The supplier further includes supplier identification information of the supplier, the slip further includes a delivery arrangement category and supplier identification information, and the acquisition means is a supplier included in the unit price master. When the condition that the classification, delivery arrangement classification, supplier identification information and 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, The unit price master Obtaining a et formal bid, it characterized.

  Further, in the sales information device according to the present invention, in the sales information device, the unit price master is capable of further storing shipping source identification information of a product shipping source and delivery destination identification information of a delivery destination of the product, The voucher further includes shipping source identification information and delivery destination identification information, and the acquiring means includes a condition that the purchase classification included in the voucher is a warehouse purchase and a shipment included in the unit price master. If the original identification information is unregistered or further matches the condition included in the slip, or if the purchase classification included in the slip is direct delivery and the shipping source included in the unit price master The condition that the identification information is unregistered or matches the one included in the slip and the delivery destination identification information included in the unit price master is unregistered or included in the slip If it meets further condition that matches as, obtaining a formal bid from the bid master, characterized by.

  Further, in the sales information device according to the present invention, in the sales information device, the transaction classification is a sales classification in which any one of Kurade sales and direct sales is set, and the application period includes an application start date and The application end date, the transaction date is a sales date, and the unit price master is a delivery arrangement category in which any one of a plurality of predefined categories relating to the way of delivery arrangement is set. The customer identification information and the delivery destination identification information of the delivery destination of the product are further included, and the slip further includes a delivery arrangement category, a customer identification information and a delivery destination identification information, and the acquisition means includes: The condition that the sales classification, delivery arrangement classification, sales destination identification information, delivery destination identification information, and product identification information included in the unit price master coincide with those included in the slip, and the sales date is after the application start date and If the condition that applies end date is earlier, to obtain a formal bid from the bid master, characterized by.

  In the sales information device according to the present invention, in the sales information device, the unit price master is capable of further storing shipping source identification information of a shipping source of a product, and the slip further includes the shipping source identification information. The acquisition means further includes a condition that the sales category included in the slip is Kuride sales and a condition that the shipping source identification information included in the unit price master matches that included in the slip. When satisfying the condition that the sales category included in the voucher is direct sales and the condition that the shipping source identification information included in the unit price master is not registered or matches the one included in the voucher And obtaining an official unit price from the unit price master.

  In addition, 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, which is executed by the control unit and is traded at a temporary unit price and an official unit price is Product unit price, product identification information, product unit price, product unit identification information, product unit identification information, product unit identification information, product unit classification information, product unit classification information The acquisition step of acquiring the official unit price applied to the product included in the slip from the unit price master, and the unit price included in the slip was acquired in the acquisition step And a change step for changing to a unit price.

  The amount retroactive program according to the present invention is an amount retroactive program for causing a sales information device provided with a control unit to execute, and is traded at a tentative unit price and executed for the control unit. The unit price master and product identification information, product unit price, product transaction category, including at least the official unit price of the product determined after the transaction, product product identification information, product transaction category and official unit price application period And an acquisition step of obtaining a formal unit price applied to the product included in the slip from the unit price master, and a unit price included in the slip in the acquisition step A change step of changing to the acquired unit price.

  According to the present invention, there is an effect that the batch cleaning process can be performed under certain conditions with respect to the temporarily registered unit price.

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

  Embodiments of the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
The present embodiment relates to a function for retroactively updating a sales unit price and a purchase unit price in a business category that handles futures commodities.

  For example, in the present embodiment, on the (A1) condition specification screen, the condition of the sales slip that is to be retroactively selected this time is selected, (A2) the billing completion check of the target slip is performed, and (A3) the sales slip to be targeted Check whether (detail) is in exclusive status. (A4) If not in exclusive status, unit price retroactive processing of sales slip (purchase slip in case of direct delivery) including retrospective details (A5) Refer to the registered contents of the retroactive sales unit price master for each target sales item, and (A6) If there is a corresponding retroactive sales unit price master, the unit price on the master Adopt and 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) cancel the exclusive status of the target sales slip (see FIG. 1) ). In the process of (A2), in the billing temporary tightening / confirmed state, the slip may be internally excluded from processing and an error may not be generated. Further, in the process of (A3), if there is a slip that is in an exclusive state, an error may be generated. Further, in the process of (A6), as a result of recalculation, the sales history information on the slip, the claim information for the billing party, and the collection schedule information may be linked and washed. Further, in the process of (A6), when one of the slips having a plurality of details becomes a retroactive target, the slip information may be replaced with the contents after the amount of the one detail is changed. Good.

  Further, for example, in the present embodiment, (B1) on the condition designation screen, the condition of the purchase slip that is to be retroactively selected this time is selected, (B2) the billing completion check of the target slip is performed, and (B3) the target Check that the purchase slip (details) to be checked is not in the exclusive state. (B4) If the purchase slip is not in the exclusive state, the purchase slip (sales slip in the case of direct delivery) that includes the retroactive item is included. Is in the exclusive state as the unit price retroactive processing is being executed, (B5) for each purchase item subject to retroactivity, the registered contents of the retroactive purchase unit price master are referred to, and (B6) the corresponding retroactive purchase unit price master is If it exists, the unit price on the master is adopted and the amount and consumption tax are recalculated. (B7) In the case of retroactive purchase slips linked to sales, the cost and gross profit amounts in the sales data are also washed. Change (B8) purchase data update operator ID Overwriting at valence retrospective processing execution operator ID, and releases the exclusive state of (B9) target purchase voucher (see FIG. 2). In the process of (B2), if the payment is in a closed / confirmed state, the slip may not be processed internally and an error may not be generated. Further, in the process of (B3), if there is a slip that is in an exclusive state, an error may be generated. Further, in the process of (B6), the purchase history information relating to the slip, the debt information for the payee, and the payment schedule information may be linked and washed as a result of recalculation. Further, in the process of (B6), when one of the slips having a plurality of details becomes a retroactive target, the slip information may be replaced with the content after the amount of the one detail is changed. Good.

[2. Constitution]
An example of the configuration of the sales information apparatus according to the present embodiment will be described with reference to FIG. FIG. 3 is a block diagram illustrating 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 apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. An information processing apparatus may be used.

  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 unit included in the sales information device 100 is connected to be communicable via an arbitrary communication path.

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

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk 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 customer of the present invention). (Equivalent to identification information), delivery destination (equivalent to delivery destination identification information of the present invention), product (equivalent to product identification information of the present invention), own warehouse, shipping base (equivalent to shipping source identification information of the present invention), application It is a table including 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 sales unit price (corresponding to an official unit price of the present invention). (See FIG. 4). Here, two types of sales, “Kuraide Sales” and “Direct Sales” are defined in advance. Further, based on the way delivery arrangements are made, three types of delivery are defined in advance: “Pre-customer arrangement”, “In-house arrangement”, and “Supplier arrangement”. Here, “arrangement before the customer” indicates that there is a delivery arrangement request from a “destination of goods” (for example, final delivery destination) ahead of the customer in a commercial manner. “In-house arrangement” refers to our own arrangement for delivery. “Supplier arrangement” refers to a case where an oil wholesaler (mainly a manufacturer) requests to specify a delivery method at the time of direct delivery.

  The retroactive purchase unit price master 106b (equivalent to the unit price master of the present invention) includes a purchase category (equivalent to the purchase category of the present invention), a delivery arrangement category (equivalent to the delivery arrangement category of the present invention), and a supplier code. (Equivalent to supplier identification information of the present invention), warehouse (shipping base) code (equivalent to shipping source identification information of the present invention), delivery destination code (equivalent to delivery destination identification information of the present invention), product code (present Equivalent to the product identification information of the invention), application start date (corresponding to the application start date of the present invention), application end date (corresponding to the application end date of the present invention), and purchase unit price (the official unit price of the present invention) The table includes information such as (refer to FIG. 5). Here, two purchase categories, “kurai purchase” and “direct delivery”, are defined in advance. In addition, based on the way delivery arrangements are made, three types of delivery arrangement categories are defined in advance: “Pre-customer arrangement”, “In-house arrangement” and “Supplier arrangement”.

  The sales data table 106c (including the slip of the present invention) includes a number for identifying a record, a sales office, a sales number, a line number, a sales date, a sales category, a CD (delivery arrangement category code), a delivery arrangement category, It is a table including information such as customer, delivery destination, warehouse (own warehouse), product, warehouse CD (shipping base code), shipping base, closing state, sales unit price, sales amount, and sales quantity (see FIG. 6). Here, the shipping base information is acquired 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 details included in the sales slip.

  The purchase data table 106d (including the slip of the present invention) includes a number for identifying a record, a purchase establishment, a purchase number, a line number, a purchase date, a purchase classification, and a CD (delivery arrangement classification code). , Including delivery arrangement category, supplier, warehouse CD (shipping base code), shipping base, warehouse (in-house warehouse), product, tightening status, delivery destination, purchase unit price, purchase price and purchase quantity It is a table (see FIG. 7). Here, the information on the delivery destination is obtained from the sales data table 106c. The purchase number is a number for identifying a purchase slip. The line number is a number for identifying 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 (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The control unit 102 is a CPU or the like that controls the sales information apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run. In terms of functional concept, the control unit 102 includes a retroactive object data acquisition unit 102a, a retroactive unit price acquisition unit 102b including the acquisition unit of the present invention, and a retroactive processing unit 102c including the calculation unit and the change unit of the present invention. Yes.

  The retroactive object data acquisition unit 102a acquires the sales slip data to be retroactively from the sales data table 106c according to the specified conditions. The retroactive object data acquisition unit 102a acquires purchase slip data to be retroactively from the purchase data table 106d according to the specified conditions. In addition, about the process which the retroactive object data acquisition part 102a implements, 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 retrospective target data acquisition unit 102a, and applies the retroactive sales unit price master 106a to the retroactive target sales slip data. Get the unit price. Specifically, the retroactive unit price acquisition unit 102b refers to the retroactive sales unit price master 106a for each retrospective sales slip data (record) acquired by the retrospective target data acquisition unit 102a, and sets 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 purchase unit price slip data acquired by the retrospective target data acquisition unit 102a, and determines the retroactive purchase unit price master 106b from the retroactive purchase unit price master 106b. Get the unit price applied to the data. Specifically, the retroactive unit price acquisition unit 102b refers to the retroactive purchase unit price master 106b for each retrospective purchase slip data (record) acquired by the retrospective target data acquisition unit 102a and corresponds to each record. Acquire the retroactive unit price (unit price of purchased unit).

  In addition, about the process which the retroactive unit price acquisition part 102b implements, 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 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 sales slip data, 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 replaced (updated).

  The retroactive processing unit 102c recalculates the purchase amount included in the retroactive 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 purchase slip data. Based on the acquired purchase main unit price and the recalculated purchase amount, the purchase unit price and the purchase amount included in the retroactive purchase slip data are replaced (updated).

  In addition, about the process which the retroactive processing part 102c implements, the following [4. Specific Example of Processing] will be described in detail.

[3. Screen configuration example]
Here, a configuration example of the condition designation screen M will be described with reference to FIG. Note that the screen shown in FIG. 8 is used to allow the operator to select sales slip data to be retroactively in the sales unit retroactivity processing described later.

  The condition designation screen M includes an area 1 for entering the range of sales offices, an area 2 for entering the range of sales dates, an area 3 for entering the range of sales divisions, and a delivery arrangement category. An area 4 for inputting the range, an area 5 for inputting the range of the sales person, an area 6 for inputting the range of the customer, an area 7 for inputting the range of the delivery destination, An area 8 for inputting the range of the shipping base, an area 9 for inputting the range of the company warehouse, an area 10 for inputting the range of goods, and an area 11 for inputting the range of sales numbers , And an area 12 for displaying the progress of processing executed by each processing unit of the control unit 102.

Note that the condition designation screen for allowing the operator to select purchase slip data to be retroactively selected in the purchase unit price retrospective processing described later is obtained by making the following changes and deletions to the screen M shown in FIG. Also good.
-Changed the area 1 to the area 3, the area 5, and the area 11 to input the respective ranges of purchase establishment, purchase date, purchase category, purchase person in charge, and purchase number.
-Area 6 and area 9 are deleted.

[4. Specific example of processing]
Specific examples of the sales unit price retroactive processing and the purchase unit price retrospective processing implemented in the present embodiment will be described with reference to FIGS.

[4-1. Specific example of retroactive sales unit processing]
A specific example of the sales unit retroactivity processing will be described with reference to FIGS. FIG. 9 is a flowchart illustrating an example of main processing executed by the sales information device 100 according to 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 data]
The retroactive object data acquisition unit 102a acquires the sales slip data to be retroactively from the sales data table 106c according to the conditions input on the condition designation screen M. Specifically, when the input sales category is “Kuraide Sales”, the retroactive object data acquisition unit 102a inputs the sales office, sales date, sales category, delivery arrangement category, sales representative, specialty Using the destination, delivery destination, company warehouse, product, and sales number as conditions, narrow down sales slip data including the same data as the conditions. In addition, when the input sales category is “direct sales”, the retroactive object data acquisition unit 102a inputs the sales office, sales date, sales category, delivery arrangement category, sales representative, customer, delivery destination. Using the shipping base, product, and sales category as conditions, narrow down sales slip data including the same data as the conditions.

  For example, when the condition shown in FIG. 10 is designated on the condition designation screen M, 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. 4 records No. 4 selected as a retroactive target. No. 3 is the same slip, but no. No. 4 records in the own warehouse are different from the specified ones. Record 4 is not selected as a retroactive target. That is, No. as sales details data. Record 4 is not retroactive. However, retroactively occurs for the slip with the sales number “A110” including the record. In FIG. 8 and no. For the record No. 9, since the shipping base data is not registered at the time of sales input, the shipping base data is not registered. Therefore, when the range of the shipping base is designated on the condition designation screen M, these records are not selected. However, if the shipping base range is not input on the condition designation screen M, the data of all 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 unit price) applied to the product included in each sales slip data. To do.

  It should be noted that the conditions for acquiring the sales unit unit price differ as shown below depending on the data of the sales category included in the sales slip data.

  Specifically, when the sales classification included in the sales slip data = “Kurade Sales”, the retroactive unit price acquisition unit 102b reads “Sales classification included in the sales slip data, delivery arrangement classification, customer, delivery destination, Retroactive, satisfying the condition that 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 sales unit price master record.

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

[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 unit price) acquired in step S2, and converts the sales amount included in the sales slip data to step S2. The sales unit price and sales amount data included in the sales slip data (including sales details data) are re-created by reconsidering the product of the retroactive unit price (sales unit price) and the quantity included in the sales slip data. create. Here, when the quantity is zero, such sales slip data is not processed. In addition, when the retroactive unit price cannot be acquired in Step S2 or when the retroactive unit price acquired in Step S2 is zero yen, no reconstitution is performed.

  The above [4-1. [Specific Example of Sales Unit Price Retroactive Processing]] ends.

[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. In this description, it is assumed that the data shown in FIG. 7 is stored in the purchase data table 106d. In this description, [4-1. A description similar to that described in “Specific example of sales unit price retroactive processing” may be omitted.

[Step S1: Acquisition of retroactive data]
The retroactive object data acquisition unit 102a acquires purchase slip data to be retroactively from the purchase data table 106d according to the conditions input on the condition designation screen M. Specifically, when the input purchase category is “Kurairi purchase”, the retroactive object data acquisition unit 102a, the input purchase establishment, purchase date, purchase category, delivery arrangement category, Using purchase clerk, supplier, shipping base, product and purchase number as conditions, narrow down purchase slip data including the same data as the conditions. In addition, the retroactive object data acquisition unit 102a, when the input purchase category is “direct delivery purchase” and the delivery arrangement category is “vendor arrangement”, the input purchase establishment, purchase date The purchase category, the delivery arrangement category, the person in charge of purchase, the supplier, the shipping base, the product, the delivery destination and the purchase number are used as conditions to narrow down purchase slip data including the same data as the conditions. Further, the retroactive object data acquisition unit 102a, when the input purchase classification is “direct delivery purchase” and the delivery arrangement classification is “in-house arrangement” or “pre-customer arrangement”, The purchase slip data containing the same data as the relevant conditions is used, using the location, purchase date, purchase category, delivery arrangement category, purchaser, supplier, shipping base, product and purchase number as conditions. Narrow down.

  For example, when the condition shown in FIG. 12 is designated on the condition designation screen M, the purchase slip data including the data within the thick frame shown in FIG. 13 among the purchase slip data stored in the purchase data table 106d. Is selected and acquired. In FIG. The record of No. 8 is selected as the retroactive target. The same slip as record No. 7, but no. Since the shipping base data included in the record No. 8 is different from the designated data, Eight records are not selected for retrospective. That is, No. as purchase details data. 8 records are not retroactive. However, retroactively occurs for the slip of purchase number “S120” including the record. In FIG. 5 and no. As for the record No. 6, the shipping base data is not registered at the time of purchase input. 12 and no. For the 13 records, the shipping base data is not registered at the time of sales input, so the shipping base data is not registered. Therefore, when the range of the shipping base is designated on the condition designation screen M, these records are not selected. However, if the shipping base range is not input on the condition designation screen M, the data of all shipping bases are unconditionally selected. In FIG. The 19 records are not selected because the data of the tightening state is “payment closed”. On the other hand, no. For the 20 records, the data of the tightening state is “billing-completed” (that is, the corresponding sales slip is in-charged), and is selected. That is, when the data of the tightening state included in the purchase data table 106d is “payment closed”, the purchase data table 106d is excluded from the selection target regardless of the condition specified on the condition specifying 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 sets the retroactive unit price (purchased body) applied to the product included in each purchase slip data. Unit price).

  It should be noted that the conditions for obtaining the unit price of the purchase unit differ depending on the purchase category data and the delivery arrangement category data included in the purchase slip data as shown below.

Specifically, the retroactive unit price acquisition unit 102b, in the case of the purchase category included in the purchase slip data = “Kurairi purchase”, in the order of the following (21) and (22), Records that satisfy the condition are acquired from the master 106b.
(21) “Purchase classification, delivery arrangement classification, supplier and product included in purchase slip data match those included in retroactive purchase unit price master, and retroactive purchase unit price master. Warehouse ( The purchase base is not registered and the retroactive purchase unit price master. The application start date is the latest date before the purchase date included in the purchase slip data. Get unit price master record.
(22) “The 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 Receipt unit price master. Record of purchase unit price master for retroactive conditions that satisfies the condition that the application start date is the latest date before the purchase date included in the purchase slip data is acquired.

Further, the retroactive unit price acquisition unit 102b has the following case when the purchase category included in the purchase slip data = “direct purchase” and the delivery arrangement included in the purchase slip data = “vendor”. 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 product included in purchase slip data match those included in retroactive purchase unit price master, and retroactive purchase unit price master. Warehouse ( Shipping base) and retroactive purchase unit price master, both of which are 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 the latest date The record of the retroactive purchase unit price master that satisfies the condition “is” is acquired.
(32) “The 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 Receipt unit price master. Retroactive purchase unit price master. Retroactive purchase unit price master. The application start date is the latest date before the purchase date included in the purchase slip data. Get purchase unit price master record.
(33) “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 the latest date before the purchase date included in the purchase slip data. , Get the record of purchase unit price master for retroactive use.
(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. The record of the retroactive purchase unit price master that satisfies the condition that it is the latest date before the purchase date included in the purchase slip data is acquired.
In other words, since the purchase price unit for retroactive purchases has permitted delivery destination = “No registration”, the delivery destination is first applied in the unregistered master, and again for the retrospective target document Then, apply the master with detailed conditions including the delivery destination.

Further, the retroactive unit price acquisition unit 102b has the purchase classification included in the purchase slip data = “direct delivery 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 following order (41) and (42).
(41) “The 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 Receipt unit price master. Retroactive purchase unit price master. Retroactive purchase unit price master. The application start date is the latest date before the purchase date included in the purchase slip data. Get purchase unit price master record.
(42) “Purchasing 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 Retroactive purchase unit price master. Record of retrofit 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 unit price) acquired in step S2, and purchase amount included in the purchase slip data. Is replaced with the product of the retroactive unit price (purchased unit price) acquired in step S2 and the quantity included in the purchase slip data, so that it is included in the purchase slip data (including purchase details data). Re-create the purchase unit price and purchase price data. Here, when the quantity is zero, such purchase slip data is not processed. In addition, when the retroactive unit price cannot be acquired in Step S2 or when the retroactive unit price acquired in Step S2 is zero yen, no reconstitution is performed. In addition, when the purchase category included in the purchase slip data is “direct delivery”, the cost and gross margin 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 finished.

[5. Summary of this embodiment and other embodiments]
As described above in detail, the present embodiment relates to a retroactive update function for “sales / purchase unit price” in a business category that handles futures commodities. In the case of a corporate business that handles futures products, the unit price is fixed (determined) after a certain period of time. Can be done. Specifically, in the present embodiment, (1) the unit price of sales is reconstituted by retroactive batch update processing, (2) the unit price of purchase is reconstituted by retrospective batch update processing, (3) It is possible to create a condition for attaching a unit price (retroactive unit price master).

  Until now, in the case of business categories that handle futures-related products (for example, energy, sugar, or wheat), it is necessary to replace the sales slips for a certain period with certain rules. There was no processing function to change the unit price. For this reason, it is necessary to manually recall past slips and correct them one by one, which is troublesome.

  Therefore, in the present embodiment, by adopting the above-described configuration and processing, it has succeeded in greatly reducing the labor that has been 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 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 performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

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

  Moreover, regarding the sales information apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, the processing functions provided in the sales information device 100, particularly the processing functions performed by the control unit, may be realized entirely or arbitrarily by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment. 100 mechanically read. In other words, in a storage unit such as a ROM or a 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 the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the sales information device 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. is there.

  In addition, a 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 “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Stores programs, tables, databases, web page files, and the like.

  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.

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

  The present invention is particularly useful in industries that handle futures commodities.

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

Claims (8)

A sales information device comprising a control unit,
The controller is
Product unit identification and product identification including at least the official unit price of the product that is traded at the tentative unit price and the official 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 official unit price Information, a unit price of the product, a transaction classification of the product and a slip including at least a transaction date of the product, and obtaining means for obtaining a formal unit price applied to the product included in the slip from the unit price master;
A sales information device comprising: a changing unit that changes a unit price included in the slip to a unit price acquired by the acquiring unit. The slip further includes the amount of the product and the quantity of the product,
The control unit further includes calculation means for calculating a product of the unit price acquired by the acquisition means and the quantity included in the slip,
The changing means changes the amount included in the slip to the product calculated by the calculating means,
The sales information device according to claim 1. The transaction category is a purchase category in which one of warehouse purchase and direct delivery is set,
The application period is an application start date and an application end date,
The transaction date is a purchase date,
The unit price master further includes a delivery arrangement category in which any one of a plurality of predefined categories related to delivery arrangements is set, and supplier identification information of the supplier of the product,
The slip further includes a delivery arrangement category and supplier identification information,
The acquisition means includes a condition that the purchase classification, delivery arrangement classification, supplier identification information and product identification information included in the unit price master coincide with those included in the slip and a purchase date after the application start date and Obtaining the official unit price from the unit price master if the condition that it is before the application end date is satisfied,
The sales information device according to claim 1 or 2. The unit price master is capable of further storing shipping source identification information of a product shipping source and delivery destination identification information of a delivery destination of the product,
The slip further includes shipping source identification information and delivery destination identification information,
The acquisition means includes a condition that the purchase classification included in the slip is a warehouse purchase and a condition that shipping source identification information included in the unit price master is unregistered or matches the one included in the slip Or the condition that the purchase classification included in the slip is direct delivery, and the condition that the shipping source identification information included in the unit price master is not registered or matches that included in the slip; and Obtaining the official unit price from the unit price master, when further satisfying the condition that the delivery destination identification information included in the unit price master is unregistered or matches the one included in the slip;
The sales information device according to claim 3. The transaction classification is a sales classification in which any one of Kurade sales and direct sales is set,
The application period is an application start date and an application end date,
The transaction date is a sales date,
The unit price master further includes a delivery arrangement category in which any one of a plurality of predefined categories relating to delivery arrangements is set, sales destination identification information of a product sales destination, and delivery destination identification information of a product delivery destination. Including
The slip further includes a delivery arrangement category, sales destination identification information, and delivery destination identification information,
The acquisition means includes a 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 coincide with those included in the slip, and the sales start date. After that, when the condition that it is before the application end date is satisfied, obtaining an official unit price from the unit price master,
The sales information device according to claim 1 or 2. The unit price master is capable of further storing shipping source identification information of the shipping source of the product,
The slip further includes shipping source identification information,
The acquisition means further satisfies the condition that the sales category included in the slip is Kuride sales and the condition that the shipping source identification information included in the unit price master matches that included in the slip, or the slip From the unit price master when the condition that the sales category included is direct sales and the condition that the shipping source identification information included in the unit price master is not registered or matches the one included in the slip Getting a formal unit price,
The sales information device according to claim 5. An amount retroactive method executed by a sales information device provided with a control unit,
Executed by the control unit,
Product unit identification and product identification including at least the official unit price of the product that is traded at the tentative unit price and the official 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 official unit price An acquisition step of comparing the information, the unit price of the product, the transaction category of the product and the slip including at least the transaction date of the product, and obtaining the official unit price applied to the product included in the slip from the unit price master;
And a change step of changing the unit price included in the slip to the unit price acquired in the acquisition step. An amount retroactive program for causing a sales information device equipped with a control unit to execute,
For causing the control unit to execute,
Product unit identification and product identification including at least the official unit price of the product that is traded at the tentative unit price and the official 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 official unit price An acquisition step of comparing the information, the unit price of the product, the transaction category of the product and the slip including at least the transaction date of the product, and obtaining the official unit price applied to the product included in the slip from the unit price master;
And a change step of changing the unit price included in the slip to the unit price acquired in the acquisition step.

Images