Confirmed product quantity management device, confirmed product quantity management method, and confirmed product quantity management program

Abstract

To provide a confirmed product quantity management device, a confirmed product quantity management method and a confirmed product quantity management program that can calculate a sales amount based on a product quantity confirmed after delivery to a delivery destination and not based on a product quantity at the time of shipment to the delivery destination when shipping a product whose quantity decreases over time.SOLUTION: According to an embodiment, a confirmed product quantity management device, (1) from quantity report detail data having an order number, an order row number, a product code, and a confirmed product quantity, acquires a confirmed product quantity associated with an order number, an order row number and a product code contained in order detail data having an order number, an order row number, a product code, an asset quantity, and a sales unit price, and stores the same into the order detail data, and (2) for the order detail data for which the confirmed product quantity has been obtained, calculates a sales amount by multiplying the confirmed product quantity by the sales unit price; on the other hand, for the order detail data for which the confirmed product quantity has not been obtained, calculates the sales amount by multiplying the asset quantity by the sales unit price.SELECTED DRAWING: Figure 6

Description

[Technical Field]

[0001] The present invention relates to a confirmed commodity quantity management device, a confirmed commodity quantity management method, and a confirmed commodity quantity management program. [Background technology]

[0002] Patent Document 1 discloses a transaction support system that can support the trading of goods whose transaction prices will be determined in the future, and also discloses that goods whose transaction prices will be determined in the future include, for example, food ingredients such as agricultural products, marine products, and dairy products, raw materials such as petroleum and ores, and materials and products such as chemicals, and the price is determined based on the ingredients and quality that become clear at the time of inspection (see paragraph 0030 of Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2003-091656 Summary of the Invention [Problem to be solved by the invention]

[0004] Here, in the industry that ships products (for example, petroleum products) whose volume decreases over time due to evaporation, etc., the sales amount is not calculated based on the quantity of the product at the time of shipment to the delivery destination, but is calculated based on the confirmed quantity of the product reported by the delivery destination after inspection at the delivery destination.

[0005] However, in the past, including the technology described in Patent Document 1 above, it was not possible to automatically calculate the sales amount based on the confirmed product quantity, so the person in charge received a report from the delivery destination, manually entered the confirmed product quantity, and manually calculated the sales amount.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a confirmed product quantity management device, a confirmed product quantity management method, and a confirmed product quantity management program that, when shipping products whose quantity decreases over time, can calculate sales revenue based on the confirmed product quantity after delivery to the delivery destination, rather than the product quantity at the time of shipment to the delivery destination. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, a confirmed commodity quantity management device according to the present invention is provided which includes a control unit and a memory unit, and which, in the case of shipping commodities whose quantity decreases over time, can calculate a sales amount based on the confirmed commodity quantity after delivery to a destination, rather than the commodity quantity at the time of shipping to the destination, wherein the memory unit stores order data including order detail data having an order number, an order line number, commodity identification data, a shipped commodity quantity which is the commodity quantity at the time of shipping to the destination, and a sales unit price, and quantity report data including quantity report detail data which has the order number, the order line number, commodity identification data, and a confirmed commodity quantity which is the confirmed commodity quantity reported by the destination after delivery to the destination, and the control unit the unit is characterized by comprising: a confirmed product quantity acquisition means for acquiring from the quantity report detail data a confirmed product quantity linked to the order number, the order line number, and the product identification data in the order detail data, and storing the confirmed product quantity in the order detail data; and a sales amount calculation means for calculating a sales amount for each of the order detail data for which the confirmed product quantity acquisition means has acquired the confirmed product quantity by multiplying the confirmed product quantity in the order detail data by the sales unit price in the order detail data, and for which the confirmed product quantity acquisition means has not acquired the confirmed product quantity by multiplying the shipped product quantity in the order detail data by the sales unit price in the order detail data, to calculate a sales amount for each of the order detail data.

[0008] In addition, in the confirmed product quantity management device of the present invention, the order detail data further includes a cost unit price, and the control unit further includes a cost amount calculation means for calculating the cost amount for each order detail data by multiplying the shipped product quantity in the order detail data by the cost unit price in the order detail data.

[0009] In addition, in the confirmed product quantity management device of the present invention, the control unit is further characterized by having a gross profit calculation means for calculating the gross profit amount for each of the order detail data by subtracting the calculated cost amount for each of the order detail data from the calculated sales amount for each of the order detail data.

[0010] In addition, in the confirmed product quantity management device of the present invention, the memory unit further stores a product master including product identification data and a reduction / non-reduction flag, which is a flag for identifying whether the product quantity will decrease over time, and the order detail data further has a confirmation / non-reduction flag, which is a flag for identifying whether the product quantity has already been confirmed based on a report from the delivery destination, and the control unit further comprises sales data generation means for generating sales data based on the sales amount for the order detail data that has been determined when (i) it is determined that the reduction / non-reduction flag in the product master linked to the product identification data in the order detail data is a flag indicating that the product quantity will not decrease over time, or (ii) it is determined that the reduction / non-reduction flag in the product master linked to the product identification data in the order detail data is a flag indicating that the product quantity will decrease over time and the confirmation / non-reduction flag in the order detail data is a flag indicating that the product quantity has already been confirmed.

[0011] Furthermore, the fixed commodity quantity management device according to the present invention is characterized in that the commodity whose quantity decreases over time is a volatile commodity.

[0012] In addition, the fixed commodity quantity management device according to the present invention is characterized in that the volatile commodity is a petroleum product.

[0013] Furthermore, in a confirmed commodity quantity management method according to the present invention, when shipping commodities whose quantity decreases over time, the sales amount can be calculated based on the confirmed commodity quantity after delivery to the delivery destination, rather than the commodity quantity at the time of shipment to the delivery destination, and is executed by an information processing device having a control unit and a memory unit, wherein the memory unit stores order data including order detail data having an order number, an order line number, commodity identification data, a shipped commodity quantity which is the commodity quantity at the time of shipment to the delivery destination, and a sales unit price, and quantity report data including quantity report detail data which has the order number, the order line number, commodity identification data, and a confirmed commodity quantity which is the confirmed commodity quantity reported by the delivery destination after delivery to the delivery destination, and a confirmed product quantity acquisition step of acquiring a confirmed product quantity linked to the order number, the order line number, and the product identification data in the order detail data from the quantity report detail data, and storing the acquired quantity in the order detail data; and a sales amount calculation step of calculating a sales amount for each of the order detail data for which the confirmed product quantity can be acquired in the confirmed product quantity acquisition step by multiplying the confirmed product quantity in the order detail data by the sales unit price in the order detail data, and calculating a sales amount for each of the order detail data for which the confirmed product quantity cannot be acquired in the confirmed product quantity acquisition step by multiplying the shipped product quantity in the order detail data by the sales unit price in the order detail data.

[0014] Furthermore, in a confirmed commodity quantity management program according to the present invention, when shipping commodities whose quantity decreases over time, the program is executed by an information processing device having a control unit and a memory unit, and is capable of calculating a sales amount based on the confirmed commodity quantity after delivery to a destination, rather than the commodity quantity at the time of shipment to the destination, wherein the memory unit stores order data including order detail data having an order number, an order line number, commodity identification data, a shipped commodity quantity which is the commodity quantity at the time of shipment to the destination, and a sales unit price, and quantity report data including quantity report detail data which has the order number, the order line number, commodity identification data, and a confirmed commodity quantity which is the confirmed commodity quantity reported by the destination after delivery to the destination, and the program is executed by the control unit. and a sales amount calculation step of calculating a sales amount for each of the order detail data by multiplying the confirmed product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity can be obtained in the confirmed product quantity acquisition step, and calculating a sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity cannot be obtained in the confirmed product quantity acquisition step. [Effects of the Invention]

[0015] According to the present invention, when shipping a product whose quantity decreases over time, the sales amount can be calculated based on the quantity of the product determined after delivery to the delivery destination, rather than the quantity of the product at the time of shipping to the delivery destination. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a fixed commodity quantity management device. [Figure 2] FIG. 2 is a diagram showing an example of a flow relating to a determination as to whether or not to include an item in sales. [Figure 3] FIG. 3 is a diagram illustrating an example of a processing flow. [Figure 4] FIG. 4 is a diagram showing an example of items in the order data and the product master. [Figure 5] FIG. 5 is a diagram showing an example of order data before a quantity report. [Figure 6] FIG. 6 is a diagram showing an example of quantity report data, order data after quantity report, and product master. DETAILED DESCRIPTION OF THE INVENTION

[0017] Hereinafter, embodiments of a confirmed commodity quantity management device, a confirmed commodity quantity management method, and a confirmed commodity quantity management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

[0018] [1. Overview] In industries that ship volatile commodities (oil, gasoline, etc.), the amount of goods at the time of shipment is not the trading volume; the trading volume is determined by measurements taken by the delivery destination at the time of delivery.

[0019] However, in the past, it was not possible to automatically calculate the sales amount based on the confirmed product quantity, so the person in charge received a report from the delivery destination, manually entered the confirmed product quantity, and manually calculated the sales amount.

[0020] Therefore, in this embodiment, for example, the sales amount can be automatically calculated based on the quantity of goods confirmed after delivery to the delivery destination, rather than the quantity of goods at the time of shipment to the delivery destination, which can eliminate human error and reduce the workload.

[0021] In addition, when recording sales of volatile products, it is necessary to record sales only for products that have been inspected by the delivery destination and for which a confirmed product quantity has been reported. In other words, it is not permitted to record sales for products for which such a report has not yet been made.

[0022] However, in the past, for volatile products, the person in charge had to determine whether the delivery destination had inspected and reported the confirmed quantity of the product, which resulted in incorrect recording of sales and incorrect invoicing of sales.

[0023] Therefore, in this embodiment, for example, sales can be automatically recorded only for products that have been inspected by the delivery destination and for which a confirmed product quantity has been reported, which can prevent, for example, erroneous recording of sales and erroneous invoicing of sales.

[0024] The specific configuration and operation will be described below.

[0025] [2. Configuration] An example of the configuration of the confirmed commodity quantity management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the confirmed commodity quantity management device 100.

[0026] The confirmed commodity quantity management device 100 is a commercially available desktop personal computer. Note that the confirmed commodity quantity management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0027] The confirmed commodity quantity management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units included in the confirmed commodity quantity management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0028] The communication interface unit 104 communicably connects the confirmed commodity quantity management device 100 to a 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 the communication line. Here, the network 300 has a function of connecting the confirmed commodity quantity management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

[0029] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0030] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0031] The storage unit 106 includes, for example, a product master 106a, quantity report data 106b, and order data 106c.

[0032] Here, according to the confirmed product quantity management device 100 of this embodiment, when shipping products whose quantity decreases over time, the sales amount can be calculated based on the confirmed product quantity after delivery to the delivery destination, rather than the product quantity at the time of shipment to the delivery destination.

[0033] A commodity whose quantity decreases over time is, for example, a volatile commodity, such as petroleum products (oil itself, kerosene, diesel, heavy oil, gasoline, etc.).

[0034] The product master 106a is a master for setting for each product whether the quantity of the product will decrease over time. As shown in Figures 4 and 6, the product master 106a includes, for example, product identification data (product code, product name, and product kana name), product specifications, and a reduction determination flag (quantity confirmation required flag) that is a flag for identifying whether the quantity of the product will decrease over time.

[0035] As shown in Figure 6, there are two types of reduction determination flags (quantity confirmation required flags): a flag (TRUE) indicating that the quantity of the product will decrease over time, and a flag (FALSE) indicating that the quantity of the product will not decrease over time.

[0036] The quantity report data 106b is data for managing the confirmed product quantity reported by the delivery destination, and includes quantity report detail data.

[0037] As shown in Figure 6, the quantity report detail data includes, for example, an order number, an order line number, the product identification data (product), and a confirmed product quantity (quantity), which is the confirmed product quantity reported by the delivery destination after delivery to the delivery destination.

[0038] The order data 106c is data for managing order information from customers, and includes order detail data.

[0039] As shown in Figures 4, 5 and 6, the order detail data includes, for example, the order number, the order line number, business establishment identification data (business establishment), order date, customer identification data (customer), delivery destination identification data (delivery destination), the product identification data (product), the confirmed product quantity (unit price quantity), the shipped product quantity (asset quantity) which is the product quantity at the time of shipment to the delivery destination, a confirmation determination flag (quantity confirmation flag) which is a flag for identifying whether the product quantity has already been confirmed based on a report from the delivery destination, unit sales price, sales amount, unit cost price, cost amount, gross profit amount, etc.

[0040] As shown in Figures 5 and 6, there are two types of confirmation flags (quantity confirmation flags): a flag (TRUE) indicating that the quantity of the product has already been confirmed, and a flag (FALSE) indicating that the quantity of the product has not yet been confirmed.

[0041] Here, the order data 106c shown in FIG. 5 is order data before the confirmed product quantity is reported from the delivery destination (i.e., at the stage of order input). Therefore, in the order data 106c shown in FIG. 5, the confirmed product quantity (unit price quantity) is initially set to the same value as the shipped product quantity (asset quantity). Furthermore, the sales amount and the gross profit amount are values ​​calculated based on the initially set confirmed product quantity (unit price quantity). Furthermore, the confirmation presence / absence judgment flags (quantity confirmation flags) are all set to "FALSE."

[0042] In contrast, the order data 106c shown in FIG. 6 is the order data after the confirmed product quantity has been reported from the delivery destination. Therefore, in the order data 106c shown in FIG. 6, the confirmed product quantity (unit price quantity) in the order detail data for which a quantity report has already been made is set to a value acquired by the confirmed product quantity acquisition unit 102a (described later) from the quantity report data 106b. Furthermore, the sales amount in the order detail data for which a quantity report has already been made is a value calculated by the sales amount calculation unit 102b (described later) based on the acquired confirmed product quantity (unit price quantity). Furthermore, the gross profit amount in the order detail data for which a quantity report has already been made is a value calculated by the gross profit calculation unit 102d (described later) based on the calculated sales amount. Furthermore, the confirmation determination flag (quantity confirmation flag) is set to "TRUE" for the order detail data for which a quantity report has already been made.

[0043] Here, the confirmed product quantity (unit price quantity) and the shipped product quantity (asset quantity) in the order data 106c shown in FIG. 6 will be described in detail.

[0044] The confirmed product quantity (unit price quantity) is the quantity used to calculate the sales amount. The sales amount is calculated using the formula "confirmed product quantity (unit price quantity) x sales unit price." In other words, to calculate the sales amount, the confirmed product quantity (quantity) in the quantity report data 106b must be reflected in the order data 106c.

[0045] The quantity of shipped goods (asset quantity) is the quantity used to calculate the cost price. The cost price is calculated using the formula "quantity of shipped goods (asset quantity) x cost unit price." In other words, the cost price can be calculated using the quantity of shipped goods (asset quantity) entered at the time of order entry, so there is no need to reflect the confirmed quantity of goods (quantity) in the quantity report data 106b in the order data 106c.

[0046] The control unit 102 is a CPU or the like that performs overall control of the confirmed commodity quantity management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs.

[0047] The control unit 102 has, in terms of functional concept, for example: (1) a confirmed product quantity acquisition unit 102a as confirmed product quantity acquisition means for acquiring, from the quantity report detailed data, the confirmed product quantity linked to the order number, the order line number, and the product identification data in the order detailed data, and storing the confirmed product quantity in the order detailed data; and (2) for the order detailed data for which the confirmed product quantity has been acquired by the confirmed product quantity acquisition means, multiplying the confirmed product quantity in the order detailed data by the sales unit price in the order detailed data to store the confirmed product quantity in the order detailed data. (3) a sales amount calculation unit 102b as a sales amount calculation means for calculating the sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the unit sales price in the order detail data for which the confirmed product quantity could not be acquired by the confirmed product quantity acquisition means; and (4) a sales amount calculation unit 102b as a sales amount calculation means for calculating the sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the unit cost price in the order detail data. (4) a gross profit amount calculation unit 102d as gross profit amount calculation means that calculates a gross profit amount for each of the detailed order data by subtracting the calculated cost amount for each of the detailed order data from the calculated sales amount for each of the detailed order data; and (5) a sales data generation unit 102e as sales data generation means that generates sales data based on the sales amount for the detailed order data that has been determined, when (i) it is determined that the reduction presence / absence determination flag in the product master linked to the product identification data in the detailed order data is a flag indicating that the quantity of the product does not decrease over time, or (ii) it is determined that the reduction presence / absence determination flag in the product master linked to the product identification data in the detailed order data is a flag indicating that the quantity of the product decreases over time and the confirmation presence / absence determination flag in the detailed order data is a flag indicating that the product quantity has already been confirmed. The processing performed by each unit will be explained in detail in [4. Specific examples of processing] below.

[0048] [3. Processing Overview] In this section, an outline of the processing according to this embodiment will be explained. In this embodiment, as shown in Fig. 3, after an order is input, a lump-sum sales entry processing is performed by referring to the product master 106a.

[0049] The outline of the lump-sum sales accounting process is as shown in (1) to (5) below. (1) By providing a quantity confirmation required flag in the product master 106a, it is possible to automatically determine for each product whether or not the product requires quantity confirmation when recording sales. (2) For products that do not require quantity confirmation (i.e., products for which the quantity confirmation required flag is set to “FALSE”), the products are included in the sales calculation regardless of the quantity confirmation flag in the order data 106c described in (3) below. (3) A quantity confirmation flag is provided in the order data 106c. (4) For products that require quantity confirmation (i.e., products for which the quantity confirmation required flag is set to "TRUE"), sales will only be recorded if the quantity has already been confirmed based on a report from the delivery destination (i.e., if the quantity confirmation flag is set to "TRUE"). (5) Furthermore, if there is one order detail with the same order number, but the quantity confirmation required flag is set to "TRUE" and the quantity confirmation flag is set to "FALSE," the order detail with that order number will not be included in the sales calculation.

[0050] [4. Specific examples of processing] In this section, a specific example of the process according to the present embodiment will be described. In this example, it is assumed that a person in charge of a company that ships oil or gasoline uses the confirmed commodity quantity management device 100 according to the present embodiment.

[0051] First, when an order is received from a business partner, the person in charge registers the order data 106c shown in Fig. 5 for five products (S001 to S005). At this stage, the order data 106c shown in Fig. 5 is order data before the confirmed quantity is reported from the business partner, so the unit price quantity is set to the same value as the asset quantity, and all of the confirmed quantity flags are set to "FALSE."

[0052] Next, the inventory is delivered to the delivery destination through shipping processing. After delivery, the delivery destination reports that delivery is complete and the resulting delivery quantity. The resulting delivery quantity is stored in quantity report data 106b shown in FIG. 6. In the example of quantity report data 106b in FIG. 6, inspection has been completed and quantity reports have been submitted for products S001, S003, and S004, while inspection has not yet been completed for products S002 and S005 and so quantity reports have not yet been submitted. Note that quantity report data 106b may be generated by a person in charge based on a report from the delivery destination, or may be generated at the delivery destination and received by a person in charge.

[0053] The processing executed by the control unit 102 will now be described in detail.

[0054] [4-1. Confirmed product quantity acquisition process] The confirmed product quantity obtaining unit 102a obtains the confirmed product quantity (quantity) linked to the order number, order line number, and product identification data in the order specification data from the quantity report specification data, and stores it in the order specification data.

[0055] Specifically, in the order data 106c shown in Fig. 5, if attention is paid to the order detail data for order number J001, the confirmed product quantity (quantity) in the quantity report data 106b in Fig. 6 linked to order number J001, order row number 1, and product code S001 in the order detail data is 95. Therefore, the confirmed product quantity acquisition unit 102a updates the unit price quantity in the order detail data for order number J001 to 95.

[0056] Similarly, the confirmed product quantity acquisition unit 102a updates the unit price quantity in the order detail data for order number J003 and order line number 2 to 380, and also updates the unit price quantity in the order detail data for order number J004 and order line number 1 to 490.

[0057] Here, for the three pieces of order detail data for which the confirmed product quantity (quantity) was obtained, the value of the quantity confirmation flag is automatically updated from "FALSE" to "TRUE."

[0058] In contrast, if we look at the order detail data for order number J002 in order data 106c shown in Figure 5, we see that order number J002, order line number 1, and product code S002 in that order detail data do not exist in quantity report data 106b in Figure 6. Therefore, the unit price quantity in the order detail data for order number J002 remains at 200 and is not updated.

[0059] Similarly, the unit price quantity in the order detail data for order number J003 and order line number 1 remains at 300 and is not updated, and the unit price quantity in the order detail data for order number J004 and order line number 2 remains at 600 and is not updated.

[0060] The state of the unit price quantity and the quantity confirmation flag at the stage when the confirmed product quantity acquisition process is completed is shown in the order data 106c of Fig. 6. Note that values ​​updated from the values ​​in the order data 106c of Fig. 5 are indicated by hatching.

[0061] [4-2. Sales amount calculation process] For order detail data for which the confirmed product quantity (quantity) has been acquired by the confirmed product quantity acquisition unit 102a, the sales amount calculation unit 102b calculates the sales amount for each order detail data by multiplying the confirmed product quantity (unit price quantity) in the order detail data by the sales unit price in the order detail data.

[0062] Specifically, the sales amount calculation unit 102b calculates the unit price quantity 95 × unit sales price 100 yen = sales amount 9,500 yen for the order detail data of order number J001, calculates the unit price quantity 380 × unit sales price 100 yen = sales amount 38,000 yen for the order detail data of order number J003 and order line number 2, and calculates the unit price quantity 490 × unit sales price 100 yen = sales amount 49,000 yen for the order detail data of order number J004 and order line number 1.

[0063] In contrast, for order detail data for which the final product quantity could not be obtained by the final product quantity obtaining unit 102a, the sales amount calculation unit 102b calculates the sales amount for each order detail data by multiplying the asset quantity in the order detail data by the sales price in the order detail data.

[0064] Here, for the order detail data for which the confirmed product quantity could not be acquired by the confirmed product quantity acquisition unit 102a, the unit price quantity is set to the same value as the asset quantity and is not updated. Therefore, the process of multiplying the "unit price quantity" by the sales price, which will be described in the next paragraph, is essentially the same as the process of multiplying the "asset quantity" by the sales price.

[0065] Specifically, the sales amount calculation unit 102b calculates the unit price quantity 200 × unit sales price 100 yen = sales amount 20,000 yen for the order detail data of order number J002, calculates the unit price quantity 300 × unit sales price 100 yen = sales amount 30,000 yen for the order detail data of order number J003 and order line number 1, and calculates the unit price quantity 600 × unit sales price 100 yen = sales amount 60,000 yen for the order detail data of order number J004 and order line number 2.

[0066] The state of the sales amount at the stage when the sales amount calculation process is completed in this manner is shown in the order data 106c of Fig. 6. Note that values ​​updated from the values ​​in the order data 106c of Fig. 5 are indicated by hatching.

[0067] [4-3. Cost amount calculation process] The cost amount calculation unit 102c calculates the cost amount for each item of detailed order data by multiplying the quantity of shipped goods (asset quantity) in the detailed order data by the unit cost price in the detailed order data.

[0068] Specifically, the cost amount calculation unit 102c calculates the asset quantity 100 × unit cost price 80 yen = cost amount 8,000 yen for the order detail data of order number J001, calculates the asset quantity 200 × unit cost price 80 yen = cost amount 16,000 yen for the order detail data of order number J002, and calculates the asset quantity 300 × unit cost price 80 yen = cost amount 24,000 yen for the order detail data of order number J003 and order line number 1. For the order detail data for order number J003 and order line number 2, the calculation is asset quantity 400 x cost unit price 80 yen = cost amount 32,000 yen, for the order detail data for order number J004 and order line number 1, the calculation is asset quantity 500 x cost unit price 80 yen = cost amount 40,000 yen, and for the order detail data for order number J004 and order line number 2, the calculation is asset quantity 600 x cost unit price 80 yen = cost amount 48,000 yen.

[0069] The state of the cost amount at the stage when the cost amount calculation process is completed in this manner is shown in the order data 106c of FIG.

[0070] [4-4. Gross profit calculation process] The gross profit calculation unit 102d calculates the gross profit for each order detail data by subtracting the cost amount for each order detail data calculated in [4-3] from the sales amount for each order detail data calculated in [4-2].

[0071] Specifically, the gross profit calculation unit 102d calculates the following for the order detail data of order number J001: sales amount 9,500 yen - cost amount 8,000 yen = gross profit amount 1,500 yen; for the order detail data of order number J002, it calculates the following: sales amount 20,000 yen - cost amount 16,000 yen = gross profit amount 4,000 yen; and for the order detail data of order number J003 and order line number 1, it calculates the following: sales amount 30,000 yen - cost amount 24,000 yen = gross profit amount 6,000 yen. For the order detail data for order number J003 and order line number 2, the calculation is sales amount 38,000 yen - cost amount 32,000 yen = gross profit amount 6,000 yen; for the order detail data for order number J004 and order line number 1, the calculation is sales amount 49,000 yen - cost amount 40,000 yen = gross profit amount 9,000 yen; and for the order detail data for order number J004 and order line number 2, the calculation is sales amount 60,000 yen - cost amount 48,000 yen = gross profit amount 12,000 yen.

[0072] The state of the gross profit amount at the stage when the gross profit amount calculation process is completed in this manner is shown in the order data 106c of Fig. 6. Note that values ​​updated from the values ​​in the order data 106c of Fig. 5 are indicated by hatching.

[0073] [4-5. Sales data generation process] The sales data generating unit 102e generates sales data based on the sales amount in the order description data that is the subject of the determination in the following cases (i) or (ii). (i) When it is determined that the quantity confirmation necessary flag in the product master 106a linked to the product identification data in the order detail data is "FALSE" ("FALSE" in step S1 of FIG. 2) (ii) When it is determined that the quantity confirmation required flag in the product master 106a linked to the product identification data in the order detail data is “TRUE” (step S1 in FIG. 2 is “TRUE”) and the quantity confirmation flag in the order detail data is “TRUE” (step S2 in FIG. 2 is “TRUE”)

[0074] Below, we will explain the items in detail by order number.

[0075] (1) Order detail data for order number J001 The quantity confirmation required flag in the product master 106a in Figure 6, which is linked to product S001 in the order detail data for order number J001 in Figure 6, is "TRUE." Also, the quantity confirmation flag in the order detail data is "TRUE." In other words, the order detail data for order number J001 falls under pattern (ii), and is therefore subject to sales recognition.

[0076] (2) Order detail data for order number J002 The quantity confirmation required flag in the product master 106a in Figure 6, which is linked to product S002 in the order detail data for order number J002 in Figure 6, is "TRUE." However, the quantity confirmation flag in the order detail data is "FALSE." In other words, the order detail data for order number J002 does not fall into either pattern (i) or (ii), and therefore is not subject to sales recognition.

[0077] (3) Order detail data for order number J003 The quantity confirmation required flag in the product master 106a in Figure 6, which is linked to product S003 in the two order detail data for order number J003 in Figure 6, is "FALSE" (= product S003 is not a product whose quantity decreases over time in the first place). In other words, the order detail data for order number J003 falls under pattern (i), and is therefore subject to sales recognition.

[0078] (4) Order detail data for order number J004 The order detail data for order number J004 and order line number 1 in Figure 6 is subject to sales recognition for the same reason as in (1) above. However, the order detail data for order number J004 and order line number 2 in Figure 6 is not subject to sales recognition for the same reason as in (2) above. In this way, if there is one detail of order detail data with the same order number that is not subject to sales recognition, all order detail data with that same order number (in this example, the two order detail data with order number J004) will not be subject to sales recognition.

[0079] As explained above in (1) to (4), it has been determined that three pieces of detailed order data (the detailed order data for order number J001 and the two detailed order data for order number J003) are subject to sales accounting. Therefore, the sales data generating unit 102e generates sales data (not shown) based on the sales amounts in the three detailed order data.

[0080] [5. Summary of this embodiment] As described above in [4-1] and [4-2], the confirmed commodity quantity management device 100 according to this embodiment can automatically calculate the sales amount based on the confirmed commodity quantity after delivery to the delivery destination. This can, for example, eliminate human error and reduce the workload of the person in charge.

[0081] Furthermore, as explained in [4-3] and [4-4], the determined commodity quantity management device 100 according to this embodiment can automatically calculate the gross profit amount, which can, for example, eliminate human error and reduce the workload of the person in charge.

[0082] As explained in [4-5], the confirmed product quantity management device 100 according to this embodiment can automatically determine which order details have been inspected and the confirmed product quantity has been reported. In other words, it can automatically determine which order details are eligible for sales accounting. This can prevent, for example, erroneous accounting of sales and erroneous invoicing of sales.

[0083] [6. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0084] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0085] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0086] 7. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0087] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0088] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0089] Furthermore, with regard to the fixed commodity quantity management device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0090] For example, all or any part of the processing functions of the confirmed commodity quantity management device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the confirmed commodity quantity management device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to constitute the control unit.

[0091] In addition, this computer program may be stored in an application program server connected to the confirmed commodity quantity management device 100 via any network, and all or part of it may be downloaded as needed.

[0092] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0093] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0094] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0095] The confirmed commodity quantity management 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 connected to any peripheral device. The confirmed commodity quantity management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0096] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0097] The present invention is useful, for example, in industries that deal with commodities whose quantities decrease over time, and is particularly useful in industries that deal with volatile commodities (such as petroleum and gasoline). [Explanation of symbols]

[0098] 100 Determined product quantity control device 102 Control section 102a Determined product quantity acquisition department 102b Sales amount calculation section 102c Cost calculation section 102d Gross Profit Calculation Department 102e Sales Data Generation Department 104 Communication interface unit 106 Storage section 106a Product Master 106b Quantity Reporting Data 106c Order Data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A fixed commodity quantity management device having a control unit and a memory unit, which is capable of calculating a sales amount based on the fixed commodity quantity after delivery to a destination, rather than the commodity quantity at the time of shipment to the destination, when shipping a commodity whose quantity decreases over time, The storage unit includes: order data including order detail data having an order number, an order line number, product identification data, a product shipment quantity which is the product quantity at the time of shipment to the delivery destination, and a sales price; quantity report data including a quantity report detail data having an order number, an order line number, product identification data, and a confirmed product quantity, which is a confirmed product quantity reported by the delivery destination after delivery to the delivery destination; is stored, The control unit a confirmed product quantity acquisition means for acquiring a confirmed product quantity associated with the order number, the order line number, and the product identification data in the order detail data from the quantity report detail data, and storing the confirmed product quantity in the order detail data; a sales amount calculation means for calculating a sales amount for each of the order detail data by multiplying the confirmed product quantity in the order detail data by the sales unit price in the order detail data for which the confirmed product quantity acquisition means has been able to acquire the confirmed product quantity, and for calculating a sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the sales unit price in the order detail data for which the confirmed product quantity acquisition means has not been able to acquire the confirmed product quantity; To have A confirmed commodity quantity management device characterized by the above.

2. The order detail data further includes a cost unit price, The control unit a cost amount calculation means for calculating a cost amount for each of the order detail data by multiplying the quantity of shipped goods in the order detail data by the unit cost price in the order detail data; Further comprising: The confirmed commodity quantity management device according to claim 1,

3. The control unit a gross profit calculation means for calculating a gross profit for each of the order detail data by subtracting the calculated cost amount for each of the order detail data from the calculated sales amount for each of the order detail data; Further comprising:

3. The confirmed commodity quantity management device according to claim 2, wherein:

4. The storage unit further stores a product master including product identification data and a weight loss determination flag, which is a flag for identifying whether the product is a product whose weight decreases over time, The order detail data further includes a confirmation flag for identifying whether or not the quantity of goods has already been confirmed based on a report from the delivery destination, The control unit (i) when it is determined that the reduction determination flag in the product master linked to the product identification data in the order specification data is a flag indicating that the product quantity will not decrease over time, or (ii) when it is determined that the reduction determination flag in the product master linked to the product identification data in the order specification data is a flag indicating that the product quantity will decrease over time and the confirmation determination flag in the order specification data is a flag indicating that the product quantity has already been confirmed, a sales data generation means for generating sales data based on the sales amount for the order specification data that is the subject of determination Further comprising: The confirmed commodity quantity management device according to claim 1,

5. A product whose quantity decreases over time is a volatile product.

5. The confirmed commodity quantity management device according to claim 1, wherein:

6. The volatile commodity is a petroleum product; The confirmed commodity quantity management device according to claim 5,

7. A fixed product quantity management method executed by an information processing device having a control unit and a storage unit, which is capable of calculating a sales amount based on a fixed product quantity after delivery to a delivery destination, rather than the product quantity at the time of shipment to the delivery destination, when shipping a product whose quantity decreases over time, The storage unit includes: order data including order detail data having an order number, an order line number, product identification data, a product shipment quantity which is the product quantity at the time of shipment to the delivery destination, and a sales price; quantity report data including a quantity report detail data having an order number, an order line number, product identification data, and a confirmed product quantity, which is a confirmed product quantity reported by the delivery destination after delivery to the delivery destination; is stored, Executed by the control unit, a confirmed product quantity acquisition step of acquiring a confirmed product quantity associated with the order number, the order line number, and the product identification data in the order detail data from the quantity report detail data, and storing the confirmed product quantity in the order detail data; a sales amount calculation step of calculating a sales amount for each of the order detail data by multiplying the confirmed product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity has been acquired in the confirmed product quantity acquisition step, and calculating a sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity has not been acquired in the confirmed product quantity acquisition step; containing, A method for managing a fixed quantity of goods, characterized by:

8. A confirmed product quantity management program to be executed by an information processing device having a control unit and a storage unit, which is capable of calculating a sales amount based on a confirmed product quantity after delivery to a delivery destination, rather than the product quantity at the time of shipment to the delivery destination, when shipping a product whose quantity decreases over time, The storage unit includes: order data including order detail data having an order number, an order line number, product identification data, a product shipment quantity which is the product quantity at the time of shipment to the delivery destination, and a sales price; quantity report data including a quantity report detail data having an order number, an order line number, product identification data, and a confirmed product quantity, which is a confirmed product quantity reported by the delivery destination after delivery to the delivery destination; is stored, To cause the control unit to execute a confirmed product quantity acquisition step of acquiring a confirmed product quantity associated with the order number, the order line number, and the product identification data in the order detail data from the quantity report detail data, and storing the confirmed product quantity in the order detail data; a sales amount calculation step of calculating a sales amount for each of the order detail data by multiplying the confirmed product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity has been acquired in the confirmed product quantity acquisition step, and calculating a sales amount for each of the order detail data by multiplying the shipped product quantity in the order detail data by the unit sales price in the order detail data for the order detail data for which the confirmed product quantity has not been acquired in the confirmed product quantity acquisition step; containing, A fixed product quantity management program characterized by:

Images