JP6963664B2 - Sales information device, purchase quantity determination method, and purchase quantity determination program - Google Patents

Description

The present invention relates to a sales information device, a purchase quantity determination method, and a purchase quantity determination program.

Patent Document 1 consistently manages financial data such as inventory quantity, sales, and inventories at the time of shipment for sales contracts in which a certain shipping limit is determined and shipments are made at any time within the shipping limit. A sales management system that can be used is disclosed.

Japanese Unexamined Patent Publication No. 2004-149262

However, with the prior art, it has been difficult to prevent the amount of petroleum that can be purchased from exceeding the specified amount.

The present invention has been made in view of the above problems, and is a sales information device, a purchase quantity determination method, and a purchase quantity determination program that can prevent the amount of petroleum that can be purchased from being exceeded. The purpose is to provide.

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 purchases in the transaction category of direct delivery or Kurairi. The quantity of products that the original company plans to purchase from the supplier on the date belonging to the specified period, and the actual quantity of the product that the supplier purchased from the supplier within the specified period. , And whether the supplier exceeds or falls below the upper limit due to the purchase of the planned quantity based on the upper limit quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period. It is characterized in that it includes a determination means for determining.

Further, in the sales information device according to the present invention, in the sales information device, the upper limit quantity is associated with the supplier, the supplier, the product type, and the start date and end date of the predetermined period. It is characterized in that it is stored in.

Further, in the sales information device according to the present invention, in the sales information device, when the determination means determines that the value exceeds or does not decrease, an error and / or the actual quantity and the upper limit of the actual quantity are obtained. It is characterized in that the difference from the quantity is notified, and when it is determined that the quantity exceeds the quantity or the quantity falls below the quantity, the difference between the sum of the planned quantity and the actual quantity and the upper limit quantity is notified. do.

Further, the sales information device according to the present invention is characterized in that, in the sales information device, the supplier is a distributor and the supplier is a principal seller.

Further, the sales information device according to the present invention is characterized in that, in the sales information device, the product type is petroleum or gas, and the product belongs to petroleum or gas.

Further, the sales information device according to the present invention is characterized in that, in the sales information device, the product type is light oil, heavy oil or kerosene.

The purchase quantity determination method according to the present invention is a purchase quantity determination method executed by a sales information device provided with a control unit, and is executed in the control unit for direct delivery or purchase in a warehouse transaction category. The quantity of products that the original company plans to purchase from the supplier on the date belonging to the specified period, and the actual quantity of the product that the supplier purchased from the supplier within the specified period. , And whether the supplier exceeds or falls below the upper limit due to the purchase of the planned quantity based on the upper limit quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period. It is characterized by including a determination step for determination.

The purchase quantity determination program according to the present invention is a purchase quantity determination program for being executed by a sales information device provided with a control unit, and is used in a direct delivery or warehouse transaction classification to be executed by the control unit. The quantity of products that the supplier plans to purchase from the supplier on the date that belongs to the specified period, and the actual results that the supplier purchased the product type corresponding to the product from the supplier within the specified period. Based on the quantity of the product and the maximum quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period, the quantity exceeds the maximum quantity due to the purchase of the planned quantity. It is characterized by including a determination step of determining whether or not the value is lower.

According to the present invention, it is possible to prevent the amount of petroleum from exceeding a predetermined amount that can be purchased.

FIG. 1 is a diagram showing an outline of a frame remaining check. FIG. 2 is a block diagram showing an example of the configuration of the sales information device 100. FIG. 3 is a diagram showing an example of the frame remaining management master 106a. FIG. 4 is a diagram showing an example of the accounted data table 106b. FIG. 5 is a flowchart showing an example of the main processing of the sales information device 100 in the present embodiment. FIG. 6 is a diagram showing an example of a sales input screen (header portion). FIG. 7 is a diagram showing an example of a sales input screen (detailed portion). FIG. 8 is a diagram showing an example of a purchase input screen (header portion). FIG. 9 is a diagram showing an example of a purchase input screen (detailed portion).

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]
For example, with regard to petroleum, between the distributor and the oil distributor, the quantity that the distributor can purchase from the oil distributor (purchasable quantity) is for each period and for each oil type (for example, light oil, heavy oil, kerosene, etc.). It is decided to. This quantity is called the "frame". In the present embodiment, a function (frame remaining check) is provided to check whether the frame is exceeded due to the newly registered order (purchased quantity) based on the already purchased quantity. The frame is determined for each oil type (variety), not for each product. Taking light oil as an example, products are divided into "tax-exempt light oil", "taxable light oil" and "cold region light oil", but the frame is determined by the "light oil" unit.

Taking kerosene as an example, in the present embodiment, for example, the following frame remaining checks (1) and (2) are executed (see FIG. 1).
(1) Kerosene purchased by the department A (seller) of the company (for example, a distributor) from the customer A (sales destination) and by the purchasing department (supplier) of the company from the supplier (for example, the main seller). When the product is sold directly, the department A checks how many liters of kerosene for sale can be purchased from the supplier.
(2) When the purchasing department of the company purchases kerosene from a supplier (purchasing in-house inventory), the purchasing department checks how many liters of kerosene can be purchased from the supplier. ..

In addition, this embodiment is applicable not only to petroleum but also to gas such as LLG.

[2. composition]
An example of the configuration of the sales information device 100 according to the present embodiment will be described with reference to FIGS. 2 to 4. FIG. 2 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 an instruction 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 frame remaining management (frame management) master 106a and a recorded data table 106b. The storage unit 106 may further include a basic information master for setting processing (for example, no check, warning, error, etc.) when a frame remaining check, which will be described later, occurs.

The frame balance management master 106a has a number (serial number) for specifying a record, a business establishment code for identifying a business establishment of a supplier or a sales source, a supplier code for identifying a supplier, It is a table including a product type code for specifying a product type, an application start date (date), an application end date (date), a frame quantity, and the like (see FIG. 3).

The recorded data table 106b is a table for associating and managing the recorded sales data and the purchase data, and includes a number (serial number) for specifying a record, sales data, purchase data, and the like. It is a waste (see Fig. 4). Sales data includes sales categories such as direct sales and Kurade sales, sales office code for identifying the business establishment of the sales source, sales date, product code for specifying the product, and product code for specifying the product type. And sales volume etc. The purchase data includes the purchase category such as direct purchase and warehouse purchase, the place of business of the supplier (supplier code, supplier code for specifying the supplier, and the supplier). Includes the date of entry, the product code for identifying the product, the product code for identifying the product type, and the purchase quantity.

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 is functionally provided with a data management unit 102a including the determination means of the present invention.

The data management unit 102a functions as a data acquisition means for acquiring information from a sales input screen, a purchase input screen, or the like. For example, when the data management unit 102a executes the recording of direct sales, the data management unit 102a acquires the sales office code, the supplier code, the product type code, the sales date, and the recorded quantity of the product on the sales input screen. Further, for example, when the data management unit 102a executes the recording of the purchase in the warehouse, the supplier code, the supplier code, the product type code, the purchase date, and the recorded quantity of the product on the purchase input screen are recorded. To get.

The data management unit 102a uses the information acquired from the sales input screen, the purchase input screen, etc., and from the frame remaining management master 106a, the frame remaining setting information (specifically, the application start date, application) that matches the information. It functions as a master setting acquisition means for acquiring (end date, frame quantity, etc.). If the frame remaining setting information that meets the condition is not registered in the frame remaining management master 106a on the condition of the information acquired from the screen, the subsequent processing including the frame remaining check described later is not performed.

The data management unit 102a is one that matches the condition from the recorded data table 106b, subject to the information acquired from the sales input screen, the purchase input screen, etc., and the frame balance setting information acquired from the frame balance management master 106a. Alternatively, it functions as a recorded data acquisition means for acquiring a plurality of purchase quantities and aggregating the acquired purchase quantities. For the warehouse purchase data, refer to the purchase office, but for the direct purchase data, refer to the sales office of the sales data associated with the data, not the purchase office. do.

The data management unit 102a functions as a check target quantity acquisition means for acquiring the check target quantity by adding the total purchase quantity (total) of the aggregated actual results and the recorded quantity acquired from the screen. The data management unit 102a functions as a frame remaining check means for checking whether the acquired check target quantity exceeds the frame quantity included in the acquired frame remaining setting information (frame remaining check). If the data management unit 102a exceeds the limit, the data management unit 102a may notify an error or notify the difference between the actual purchase quantity and the frame quantity as the remaining quantity. Further, the data management unit 102a may notify the difference between the check target quantity and the frame quantity as the remaining quantity if it does not exceed the limit.

Regarding the processing performed by the data management unit 102a, the following [3. Specific example of processing] will be described in detail.

[3. Specific example of processing]
A specific example of the frame remaining check process at the time of sales input and purchase input, which is executed in the present embodiment, will be described with reference to FIGS. 5 to 9 and the like.

[3-1. Specific example of processing at the time of direct sales by sales input]
A specific example of processing at the time of direct sales in sales input will be described with reference to FIGS. 5 to 7 and the like. FIG. 5 is a flowchart showing an example of the main processing of the sales information device 100 in the present embodiment.

[Step S1: Data acquisition]
When the quantity or the like is confirmed on the detail screen (sales input screen) or when the operator presses the function key F11 of the keyboard 112 which functions as a registration button, the data management unit 102a sets the header unit of the sales input screen (see FIG. 6). ), The sales office code and the sales date (date) information are acquired, and the product type code, quantity, and supplier code information are acquired from the detail part (see FIG. 7) of the sales input screen. The timing of starting the operation may be, for example, when the quantity is confirmed, when the registration button is pressed, or when the slip is confirmed. Even in the case of products for which packing style is managed, the item of "quantity" included in the detail part of the sales input screen is used when calculating the amount (the item of "quantity" is not used). In addition, since it is not possible to check the remaining frame before the supplier code is determined, the remaining frame check is not performed. In addition, when "Kuraide sales" is set as the sales category in the header part of the sales input screen, the supplier code cannot be specified, so that the frame remaining check is not inevitably performed. Further, in the case of registration in the new mode, the first check is applied when the function key F11 functioning as the registration button is pressed.

[Step S2: Acquisition of master setting]
The data management unit 102a refers to the frame remaining management master 106a based on the sales office code, sales date, product type code, and supplier code acquired in step S1, and sets the master setting (frame quantity) corresponding to the following conditions. , Application start date and application end date). If the master setting that meets the following conditions cannot be acquired, the data management unit 102a does not perform any further processing (the frame remaining check is not performed).
(conditions)
-Frame remaining management master. Office code = screen. Sales office code / remaining frame management master. Supplier code = screen. Supplier code / remaining frame management master. Variety code = screen. Product code / frame balance management master. Application start date ≤ screen. Sales date ≤ frame balance management master. Application end date

[Step S3: Acquisition of recorded data]
The data management unit 102a refers to the accounted data table 106b based on the sales office code, the product type code and the supplier code acquired in step S1 and the application start date and application end date acquired in step S2. Acquire the total purchase quantity (recorded purchase quantity) that meets the following conditions. In addition, the target to which the conditions of the business establishment code are applied differs between the warehouse purchase data and the direct purchase data. In addition, regarding the purchase quantity, those registered as negative values are totaled as negative results. In addition, the quantity of items registered in the category where the actual quantity does not occur, such as the category of "purchase discount", is omitted. In addition, when the slip is corrected, the actual data is totaled excluding the data for the slip being corrected, and the process proceeds from this step onward.
(Condition: In the case of direct purchase data)
・ Application start date ≤ purchase data. Purchase date ≤ application end date / purchase data. Variety code = screen. Variety code / purchase data. Supplier code = screen. Supplier code-Sales data that is linked to purchase data that meets the above three conditions and whose sales category is direct sales. Sales office code = screen. Sales office code (Condition: In the case of Kurairi purchase data)
・ Application start date ≤ purchase data. Purchase date ≤ application end date / purchase data. Variety code = screen. Variety code / purchase data. Supplier code = screen. Supplier code / supplier data. Purchasing office code = screen. Sales office code

[Step S4: Quantity addition]
The data management unit 102a adds the recorded purchase quantity acquired in step S3 and the quantity acquired in step S1 to obtain the check target quantity used in step S5. If the details of the same product type / supplier are already registered in the same slip, the quantity of the details may be included.

[Step S5: Checking the remaining frame]
The data management unit 102a sets a check NG (error) in the case of "frame quantity acquired in step S2 ≤ check target quantity acquired in step S4", and checks OK in the case where it is not.

The specific example of the processing at the time of direct sales in the sales input has been described above, but if the same slip contains a plurality of items having the same frame condition, the frame remaining check may be performed including the items. ..

Here, to explain with an example, for example, in step S1, the sales office code “100” and the sales date “20XX / 9/15” are acquired from the header part of the sales input screen, and the detail part of the sales input screen. Detailed data a including two detailed data (product code "21000", product code "20", quantity "300" and supplier code "10001", product code "31101", product code "30", quantity. When the detail data b) including "400" and the supplier code "10001" is acquired, it is determined that the check is OK for the detail data a through the processes (11) to (14) shown below. The detailed data b is determined to be check NG through the processes (21) to (24) shown below.

(11) In step S2, the record in the second line from the top in the frame remaining management master 106a shown in FIG. 3 is specified, the frame quantity "1,500" included in the specified record, and the application start date "20XX". "/ 9/1" and the application end date "20XX / 9/30" are acquired.
(12) In step S3, the records in the second and third rows from the top in the recorded data table 106b shown in FIG. 4 are specified, and the purchase quantity “300” and the purchase quantity “300” included in the specified two records are specified. A total of "400" of "400" is acquired.
(13) In step S4, the quantity "300" acquired in step S1 and the total "700" are added to obtain the check target quantity "1,000".
(14) In step S5, since "frame quantity" 1,500 "≥ check target quantity" 1,000 "" is established, it is determined that the check is OK.

(21) In step S2, the record in the seventh row from the top in the frame remaining management master 106a shown in FIG. 3 is specified, the frame quantity “500” included in the specified record, and the application start date “20XX / 9”. / 11 ”and the application end date“ 20XX / 9/20 ”are acquired.
(22) In step S3, the record in the fifth row from the top in the recorded data table 106b shown in FIG. 4 is specified, and the purchase quantity “150” included in the specified record is acquired as a total.
(23) In step S4, the quantity "400" acquired in step S1 and the total "150" are added to obtain the check target quantity "650".
(24) In step S5, since "frame quantity" 500 "≤ check target quantity" 650 "" is established, it is determined that the check is NG.

Further, for example, in step S1, the sales office code "200" and the sales date "20XX / 9/20" are acquired from the header part of the sales input screen, and two detailed data (product code) are acquired from the detailed part of the sales input screen. Detailed data c including "11000", product type code "10", quantity "400" and supplier code "10001", product code "31101", product type code "30", quantity "400" and supplier code. When the detailed data d) including "10001" is acquired, the detailed data c is determined to be check NG through the processes (31) to (34) shown below, and the detailed data d is determined to be check NG. Since the frame quantity cannot be acquired from the frame remaining management master 106a shown in FIG. 3 in step S2, the processing after step S3 is not performed.

(31) In step S2, the record on the twelfth line from the top in the frame remaining management master 106a shown in FIG. 3 is specified, the frame quantity "1,000" included in the specified record, and the application start date "20XX". "/ 9/1" and the application end date "20XX / 9/30" are acquired.
(32) In step S3, the records in the sixth and twelfth rows from the top in the recorded data table 106b shown in FIG. 4 are specified, and the purchase quantities "400" and "300" included in the specified records are specified. A total of "700" is acquired.
(33) In step S4, the quantity "400" acquired in step S1 and the total "700" are added to obtain the check target quantity "1,100".
(34) In step S5, since "frame quantity" 1,000 "≤ check target quantity" 1,100 "" is established, it is determined that the check is NG.

With the above, [3-1. Specific example of processing at the time of direct sales in sales input] is completed.

[3-2. Specific example of processing at the time of purchase in the warehouse with purchase input]
A specific example of the processing at the time of purchasing from the warehouse in the purchase input will be described with reference to FIGS. 5, 8 and 9 and the like. In this description, [3-1. Specific example of processing at the time of direct sales in sales input] may be omitted.

[Step S1: Data acquisition]
When the quantity or the like is confirmed on the detail screen (purchase input screen) or when the operator presses the function key F11 of the keyboard 112 which functions as a registration button, the data management unit 102a sets the header unit (FIG. 8), obtain the supplier code, purchase date (date), and supplier code information, and also obtain the product type code and quantity information from the detail section (see Fig. 9) of the purchase input screen. get.

[Step S2: Acquisition of master setting]
The data management unit 102a refers to the frame remaining management master 106a based on the supplier office code, purchase date, product type code, and supplier code acquired in step S1, and sets the master that meets the following conditions ( Get the quota quantity, application start date and application end date).
(conditions)
-Frame remaining management master. Office code = screen. Purchasing office code / remaining frame management master. Supplier code = screen. Supplier code / remaining frame management master. Variety code = screen. Product code / frame balance management master. Application start date ≤ screen. Purchase date ≤ frame balance management master. Application end date

[Step S3: Acquisition of recorded data]
The data management unit 102a refers to the accounted data table 106b based on the supplier code, product type code and supplier code acquired in step S1 and the application start date and application end date acquired in step S2. , Obtain the total purchase quantity (recorded purchase quantity) that meets the following conditions.
(Condition: In the case of direct purchase data)
・ Application start date ≤ purchase data. Purchase date ≤ application end date / purchase data. Variety code = screen. Variety code / purchase data. Supplier code = screen. Supplier code-Sales data that is linked to purchase data that meets the above three conditions and whose sales category is direct sales. Sales office code = screen. Purchasing office code (Condition: In the case of Kurairi purchasing data)
・ Application start date ≤ purchase data. Purchase date ≤ application end date / purchase data. Variety code = screen. Variety code / purchase data. Supplier code = screen. Supplier code / supplier data. Purchasing office code = screen. Purchasing office code

Here, for example, in step S1, the supplier code "500", the supplier date "20XX / 9/15", and the supplier code "10001" are displayed from the header part of the purchase input screen. Is acquired, and two detail data (detail data e including product code "21000", product code "20" and quantity "300", and product code "30" and quantity "400" are obtained from the detail section of the purchase input screen. When the detailed data f) including the above is acquired, it is determined that the check is OK for the detailed data e through the processes (41) to (44) shown below. For the detailed data f, since the frame quantity cannot be acquired from the frame remaining management master 106a shown in FIG. 3 in step S2, the processing after step S3 is not performed.

(41) In step S2, the record in the fifth row from the top in the frame remaining management master 106a shown in FIG. 3 is specified, the frame quantity "1,500" included in the specified record, and the application start date "20XX". "/ 9/1" and the application end date "20XX / 9/30" are acquired.
(42) In step S3, the record in the tenth row from the top in the recorded data table 106b shown in FIG. 4 is specified, and the purchase quantity “500” included in the specified record is acquired as a total.
(43) In step S4, the quantity "300" acquired in step S1 and the total "500" are added to obtain the check target quantity "800".
(44) In step S5, since "frame quantity" 1,500 "≥ check target quantity" 800 "" is established, it is determined that the check is OK.

Further, for example, in step S1, the purchase establishment code "200", the purchase date "20XX / 9/20" and the supplier code "10001" are acquired from the header part of the purchase input screen, and the purchase input is made. When detailed data including the product code "11000", the product type code "10" and the quantity "400" is acquired from the detailed part of the screen, it is determined that the check is NG through the following processes (51) to (54). NS.

(51) In step S2, the record on the twelfth line from the top in the frame remaining management master 106a shown in FIG. 3 is specified, the frame quantity "1,000" included in the specified record, and the application start date "20XX". "/ 9/1" and the application end date "20XX / 9/30" are acquired.
(52) In step S3, the records in the sixth and twelfth rows from the top in the recorded data table 106b shown in FIG. 4 are specified, and the purchase quantity “400” and the purchase quantity “400” included in the two specified records are specified. A total of "700" of "300" is acquired.
(53) In step S4, the quantity "400" acquired in step S1 and the total "700" are added to obtain the check target quantity "1,100".
(54) In step S5, since "frame quantity" 1,000 "≤ check target quantity" 1,100 "" is established, it is determined that the check is NG.

With the above, [3-2. Specific example of processing at the time of purchase in the warehouse in the purchase input] is completed.

[4. Summary of this embodiment and other embodiments]
As described above, the present embodiment is mainly related to the management of "sales quota balance" and "purchase quota balance" for the wholesale business of petroleum (gas (LLG, etc.) may be used). In this embodiment, (1) a function for checking the remaining purchase quota at the time of registering a direct sales slip for each sales establishment / purchasing establishment, supplier, and product type, (2) purchasing establishment, purchasing A function to check the remaining purchase frame when registering the purchase slip for each type and destination, (3) Processing when the remaining frame check occurs in the basic information master (for example, no check, warning, error, etc.) It has a function that enables setting, and (4) a function that manages the master of frames (limit values).

When purchasing oil from a petroleum product (manufacturer, etc.), the "upper limit of purchase in a certain period" is set for the purchaser (special agent, etc.), and the "upper limit for purchase in a certain period" is also set for the seller. "Maximum sales amount" is set. Then, if a transaction exceeding this upper limit is carried out in practice, a penalty will be incurred for the company. However, until now, at the time of purchasing (purchasing) or selling oil, the function of checking the frame (margin frame) against the standard value (limit value) (checking the remaining frame) and grasping the surplus weight There was no function to do. However, in the present embodiment, it is possible to prevent the occurrence of a penalty by adopting the above-described configuration and processing.

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 manually performed, or all of 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. Well, 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, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and cooperates with the CPU to form a control unit.

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. be.

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 EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

The "program" is a data processing method described in any 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 or 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 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 managing the remaining quota at a distributor who purchases oil from an oil company.

100 Sales information device 102 Control unit 102a Data management unit 104 Communication interface unit 106 Storage unit 106a Frame remaining management master 106b Accounted data table 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A sales information device equipped with a control unit and a storage unit.
The storage unit
In the transaction category of direct delivery or Kurairi, the supplier has purchased the product type corresponding to the product that the supplier plans to purchase from the supplier on the date belonging to the specified period from the supplier within the specified period. It has a performance data table in which the quantity is stored and a master in which the upper limit quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period is stored.
The varieties are light oil, heavy oil or kerosene.
The control unit
The planned quantity is purchased based on the planned quantity of the product acquired from the screen, the actual quantity stored in the actual data table, and the upper limit quantity stored in the master. Therefore, the sales information device is provided with a determination means for determining whether the quantity exceeds or falls below the upper limit for each product type. The variety shall be at least two of light oil, heavy oil and kerosene.
The sales information device according to claim 1. The supplier is a distributor,
The supplier must be a petroleum product
The sales information device according to claim 1 or 2. It is a purchase quantity determination method executed by a sales information device provided with a control unit and a storage unit.
The storage unit
In the transaction category of direct delivery or Kurairi, the supplier has purchased the product type corresponding to the product that the supplier plans to purchase from the supplier on the date belonging to the specified period from the supplier within the specified period. It has a performance data table in which the quantity is stored and a master in which the upper limit quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period is stored.
The varieties are light oil, heavy oil or kerosene.
Executed by the control unit,
The planned quantity is purchased based on the planned quantity of the product acquired from the screen, the actual quantity stored in the actual data table, and the upper limit quantity stored in the master. Therefore, a determination step for determining whether the quantity exceeds or falls below the upper limit for each product type.
To include
A purchase quantity determination method characterized by. It is a purchase quantity determination program to be executed by a sales information device equipped with a control unit and a storage unit.
The storage unit
In the transaction category of direct delivery or Kurairi, the supplier has purchased the product type corresponding to the product that the supplier plans to purchase from the supplier on the date belonging to the specified period from the supplier within the specified period. It has a performance data table in which the quantity is stored and a master in which the upper limit quantity that the supplier is allowed to purchase the product from the supplier within the predetermined period is stored.
The varieties are light oil, heavy oil or kerosene.
To make the control unit execute
The planned quantity is purchased based on the planned quantity of the product acquired from the screen, the actual quantity stored in the actual data table, and the upper limit quantity stored in the master. Therefore, a determination step for determining whether the quantity exceeds or falls below the upper limit for each product type.
To include
A purchase quantity determination program characterized by.

Images