Warehouse storage fee processing device, warehouse storage fee processing method, and warehouse storage fee processing program

Abstract

To appropriately process whether or not to include warehouse storage fees as an element of inventory evaluation unit price when treating them as a cost element.SOLUTION: A warehouse storage fee processing device according to the present embodiment includes cost calculation processing means which calculates an inventory evaluation unit price (including additional costs) for inventory data matching a product in expense payment scheduled data by an expression: ((quantity×inventory evaluation unit price)+(expense amount in the expense payment scheduled data))÷quantity, calculates an allowable inventory evaluation unit price (including additional costs) by an allowable inventory calculation variation rate of the inventory evaluation unit price×a product master, updates the inventory evaluation unit price in the inventory data to the inventory evaluation unit price (including additional costs) when the inventory evaluation unit price (including additional costs) is smaller than the allowable inventory evaluation unit price (including additional costs), and rewrites the cost unit price and cost amount in sales data where the product matches in each sales data and the transaction type is inventory-out.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a warehouse storage fee processing device, a warehouse storage fee processing method, and a warehouse storage fee processing program.

Background Art

[0002] For example, as a system related to warehouse storage fees, there has conventionally been Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] For example, in a chemical trading company, there are many transactions with a large volume and low gross profit. Therefore, through analysis of capturing costs by invoice, management analysis is often carried out to grasp the sales of each product by business flow. Among them, for product-specific expenses such as warehouse storage fees that are difficult to record as transaction-specific expenses, it is desired to treat them as the inventory evaluation unit price of the product. However, when the inventory quantity at the end of the month is small, there is a possibility of increasing the inventory evaluation unit price per inventory unit, making it difficult to capture the original product inventory evaluation unit price.

[0005] The present invention has been made in view of the above, and an object of the present invention is to provide a warehouse storage fee processing device, a warehouse storage fee processing method, and a warehouse storage fee processing program that can appropriately process whether to use it as an element for calculating the inventory evaluation unit price when capturing the warehouse storage fee as a cost element.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention is a warehouse storage fee processing apparatus including a control unit, wherein the control unit is configured to be accessible to a product master that registers products in association with an inventory calculation tolerance rate, inventory data including a warehouse, products, quantity, and inventory evaluation unit price, and sales data including a sales number, a sales classification including inventory shipment or direct delivery, a sales date, a customer, a supplier, products, quantity, unit, sales unit price, sales amount, cost unit price, and cost amount. The control unit further includes an expense payment input means for inputting expense payment schedule data including an expense payment number, an expense accounting date, a payee, products, an expense item including a warehouse storage fee, and an expense amount. For the inventory data that matches the product in the expense payment schedule data, the inventory evaluation unit price (including accrued expenses) is calculated as ((quantity × inventory evaluation unit price) + (expense amount in the expense payment schedule data)) ÷ quantity, and the allowable inventory evaluation unit price (including accrued expenses) is calculated as the inventory evaluation unit price × the inventory calculation tolerance rate of the product master. When the inventory evaluation unit price (including accrued expenses) is smaller than the allowable inventory evaluation unit price (including accrued expenses), the inventory evaluation unit price of the inventory data is updated to the inventory evaluation unit price (including accrued expenses), and a cost calculation processing means for re-washing the cost unit price and cost amount of the sales data where the products match in each sales data and the transaction classification is inventory shipment.

[0007] Further, according to one aspect of the present invention, the product master is further registered in association with a unit conversion quantity and a converted unit. The expense payment schedule data includes a monthly accrued calculation flag, and when the inventory evaluation unit price (including accrued expenses) is not smaller than the allowable inventory evaluation unit price (including accrued expenses), the cost calculation processing means may update the monthly accrued calculation flag in the expense payment schedule data to "1".

[0008] Further, according to one aspect of the present invention, the control unit further targets the expense payment schedule data with the monthly various charges calculation flag "1", matches the product of the expense payment schedule data, and aggregates the quantity of the product for the sales data with the sales classification "inventory shipment", and at that time, if the unit of the sales data is different from the converted unit of the product master, multiply the quantity by the unit conversion quantity of the product master, calculate the various charges unit price by dividing the expense amount of the expense payment schedule data by the aggregated value of the product quantity, and create various charges calculation result allocation data including the accounting year and month, product, unit, and various charges unit price. It may be provided with slip-by-slip actual result data output means.

[0009] Further, according to one aspect of the present invention, the slip-by-slip actual result data output means may create slip-by-slip sales actual result data based on the sales data and the various charges calculation result allocation data and display it on the screen.

[0010] Also, in order to solve the above-described problems and achieve the object, the present invention is a warehouse storage fee processing method executed by an information processing apparatus including a control unit, wherein the control unit is configured to be accessible to a product master registered by associating a product with an inventory calculation error tolerance rate, inventory data including a warehouse, a product, a quantity, and an inventory evaluation unit price, and sales data including a sales number, a sales classification including inventory shipment or direct delivery, a sales date, a customer, a supplier, a product, a quantity, a unit, a sales unit price, a sales amount, a cost unit price, and a cost amount. An expense payment input step of inputting expense payment schedule data including an expense payment number, an expense posting date, a payment destination, a product, and a warehouse storage fee including a cost item and an expense amount; for the inventory data matching the product of the expense payment schedule data, calculate the inventory evaluation unit price (various charges included) as ((quantity × inventory evaluation unit price) + (expense amount of the expense payment schedule data)) ÷ quantity, calculate the allowable inventory evaluation unit price (various charges included) as the inventory evaluation unit price × the inventory calculation error tolerance rate of the product master, and if the inventory evaluation unit price (various charges included) is smaller than the allowable inventory evaluation unit price (various charges included), update the inventory evaluation unit price of the inventory data to the inventory evaluation unit price (various charges included), and a cost calculation processing step of re-washing the cost unit price and cost amount of the sales data where the product matches and the transaction classification is "inventory shipment" in each sales data.

[0011] Also, in order to solve the above-described problems and achieve the object, the present invention is a warehouse storage fee processing program for causing an information processing apparatus including a control unit to execute. The control unit is configured to be accessible to a product master in which products and inventory calculation tolerance rates are registered in association with each other, inventory data including a warehouse, a product, a quantity, and an inventory evaluation unit price, and sales data including a sales number, a sales category including inventory withdrawal or direct delivery, a sales date, a customer, a supplier, a product, a quantity, a unit, a sales unit price, a sales amount, a cost unit price, and a cost amount. An expense payment input step of inputting expense payment scheduled data including an expense payment number, an expense accounting date, a payee, a product, a warehouse storage fee, and an expense amount to the control unit; for the inventory data that matches the product of the expense payment scheduled data, the inventory evaluation unit price (including miscellaneous charges) is calculated as ((quantity × inventory evaluation unit price) + (expense amount of the expense payment scheduled data)) ÷ quantity, and the inventory evaluation allowable unit price (including miscellaneous charges) is calculated as the inventory evaluation unit price × the inventory calculation tolerance rate of the product master. When the inventory evaluation unit price (including miscellaneous charges) is smaller than the inventory evaluation allowable unit price (including miscellaneous charges), the inventory evaluation unit price of the inventory data is updated to the inventory evaluation unit price (including miscellaneous charges), and a cost calculation process step of re-washing the cost unit price and the cost amount of the sales data in which the product matches in each sales data and the transaction category is "inventory withdrawal". It is a warehouse storage fee processing program for causing the above to be executed, which is characterized in that.

Effect of the Invention

[0012] According to the present invention, when capturing the warehouse storage fee as a cost element, there is an effect that it is possible to appropriately process whether or not it is an element for calculating the inventory evaluation unit price.

Brief Description of the Drawings

[0013]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6A

Figure 6B

Figure 7A

Figure 7B

Figure 7C

[0014] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiments.

[0015] [1. Overview] For example, in a chemical trading company, since there are many transactions with a large transaction volume and a low gross profit, management analysis is often performed to grasp the sales of each product by business flow by analyzing the cost for each invoice. Among them, various charges for each product, such as warehouse storage fees, which are difficult to record as various charges for each transaction, are to be treated as the inventory evaluation unit price of the product. However, when the inventory quantity at the end of the month is small, there is a possibility of increasing the inventory evaluation unit price per inventory unit, and it may become difficult to capture the original product inventory evaluation unit price.

[0016] Therefore, in the present invention, when considering warehouse storage fees as cost elements, a warehouse storage fee processing device is provided that can appropriately handle whether or not to include them as elements in the calculation of inventory valuation unit prices. Further, in the present invention, when considering warehouse storage fees as cost elements for each monthly transaction detail, it has become possible to determine whether a voucher should be an element in the calculation of inventory valuation unit prices or a voucher to be managed as selling, general, and administrative expenses at the time of the expense voucher for warehouse storage fees.

[0017] More specifically, by holding a threshold value from the inventory valuation unit prices held monthly for each product, it is possible to determine whether a voucher should be ON for the inventory valuation unit price at the time of the expense voucher for warehouse storage fees. Also, when it is not an element in the calculation of the inventory valuation unit price, as a gross profit confirmation element for each monthly transaction detail, the expense amount is allocated and displayed as a cost of goods sold element for each voucher based on the sales quantity of the corresponding product. Also, in the accounting system, it is not allowed to arbitrarily participate in whether or not to be an element in the calculation of the inventory valuation unit price, but it is premised that since a threshold value is held in the system this time, it is a mechanism that is acceptable in institutional accounting as a management accounting mechanism.

[0018] The present invention is applicable to companies, trading companies, etc. that store their own assets in consignment warehouses.

[0019] [2. Configuration] FIG. 1 is a block diagram showing an example of the configuration of a warehouse storage fee processing device 100 according to the present embodiment. The warehouse storage fee processing device 100 is, for example, a commercially available desktop personal computer. Note that the warehouse storage fee processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. In FIG. 1, the warehouse storage fee processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the warehouse storage fee processing device 100 is communicably connected via an arbitrary communication path.

[0020] The communication interface unit 104 communicably connects the warehouse storage fee processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the warehouse storage fee processing device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0021] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home TV), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that collaborates with the mouse to realize a pointing device function can be used. Hereinafter, the output device 114 may be described as the monitor 114 in some cases.

[0022] Various databases, tables, files, etc. are stored in the storage unit 106. A computer program for giving instructions to the CPU (Central Processing Unit) to perform various processes in cooperation with the OS (Operating System) is recorded in the storage unit 106. 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 floppy disk, and an optical disk can be used.

[0023] The storage unit 106 stores various data such as a product master 106a, a work table 106b, inventory data, sales data, expense payment data, and allocated data of ledger calculation results. FIG. 2 is a diagram showing a configuration example of the product master 106a.

[0024] The product master 106a can be composed of a table or the like that registers by associating products (product codes and / or product names), inventory calculation tolerance rates, unit conversion quantities, and converted units. The "inventory calculation tolerance rate" is a threshold value for the upper limit value recognized as the inventory valuation unit price in the cost calculation process. In the example shown in the figure, the first row shows the product "S001", the product name "ammonia", the inventory calculation tolerance rate "120%", the unit conversion quantity "20", the converted unit "Kg", and the second row shows the product "S002", the product name "nitric acid", the inventory calculation tolerance rate "140%", the unit conversion quantity "2000", and the converted unit "Kg".

[0025] The work table 106b is a table for storing work data (intermediate data), and stores inventory calculation work and the like.

[0026] The inventory data may include the warehouse, product, quantity, and inventory valuation unit price.

[0027] The sales data may include the sales number, sales classification, sales date, customer, supplier, product, quantity, unit, sales unit price, sales amount, cost unit price, and cost amount.

[0028] The expense payment schedule data may include the expense payment number, expense posting date, payee, product, expense item, expense amount, and current month's various payables calculation flag. The "current month's various payables calculation flag" is a flag for determining whether to use the data as the target data to be calculated as the various payables elements for each voucher in the voucher-by-voucher actual performance table data output.

[0029] The various payables calculation result allocation data may include the accounting year and month, product, unit, and various payables unit price.

[0030] The control unit 102 is a CPU or the like that comprehensively controls the warehouse storage fee processing device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processes based on these stored programs.

[0031] The control unit 102 is configured to be able to access the product master 106a, work table 106b, inventory data, sales data, expense payment data, allocation data of ledger calculation results, etc. stored in the storage unit 106. Note that the product master 106a, work table 106b, inventory data, sales data, expense payment data, allocation data of ledger calculation results, etc. may be stored in other locations (for example, server 200), as long as the control unit 102 can access them.

[0032] Functionally conceptually, the control unit 102 includes a sales input unit 102a, an expense payment input unit 102b, a cost calculation processing unit 102c, a transaction-specific performance data output unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

[0033] The sales input unit 102a inputs sales data and registers it in the storage unit 106 according to, for example, the operations of the operator on a sales input screen (not shown) displayed on the monitor 114.

[0034] The expense payment input unit 102b inputs expense payment schedule data including the expense payment number, expense posting date, payee, product, item including warehouse storage fee, and expense amount, and registers it in the storage unit 106 according to, for example, the operations of the operator on a sales input screen (not shown) displayed on the monitor 114.

[0035] The cost calculation processing unit 102c calculates the inventory evaluation unit price (ledger charge) for the inventory data that matches the product in the expense payment schedule data as ((quantity × inventory evaluation unit price) + (expense amount of the expense payment schedule data)) ÷ quantity according to, for example, the operations of the operator on the cost calculation processing screen displayed on the monitor 114, calculates the allowable inventory evaluation unit price (ledger charge) as the inventory evaluation unit price × the allowable inventory calculation deviation rate of the product master. If the inventory evaluation unit price (ledger charge) is smaller than the allowable inventory evaluation unit price (ledger charge), it updates the inventory evaluation unit price of the inventory data to the inventory evaluation unit price (ledger charge), and rewrites the cost unit price and cost amount of the sales data where the product matches and the transaction classification is inventory shipment in each sales data.

[0036] If the inventory valuation unit price (accounts payable) is not less than the allowable inventory valuation unit price (accounts payable), the cost payment schedule data monthly accounts payable calculation flag may be updated to "1".

[0037] For example, in response to an operator's operation on the slip-by-slip performance data output processing screen displayed on the monitor 114, the slip-by-slip performance data output unit 102d targets the expense payment schedule data with the monthly accounts payable calculation flag being "1", aggregates the quantities of the products for the sales data that matches the product of the expense payment schedule data and has the sales classification of "inventory release", and when the unit of the sales data is different from the converted unit of the product master 106a, multiplies the quantity by the unit conversion quantity of the product master 106a, calculates the accounts payable unit price by dividing the expense amount of the expense payment schedule data by the aggregated value of the product quantities, creates the accounts payable calculation result allocation data including the accounting year / month, product, unit, and accounts payable unit price, and registers it in the storage unit 106.

[0038] The slip-by-slip performance data output unit 102d may create slip-by-slip sales performance data based on the sales data and the accounts payable calculation result allocation data and display it on the screen.

[0039] For example, in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, the master maintenance unit 102e performs settings such as data input, addition, change, and update on the product master 106a.

[0040] The screen display control unit 102f controls the display and input reception of various screens (for example, sales input screen, expense payment input screen, cost calculation processing screen, slip-by-slip performance data output processing screen, master maintenance screen, etc.) displayed on the monitor 114.

[0041] [3. Specific Example] With reference to FIGS. 1 to 7C, a specific example of the processing of the control unit 102 of the warehouse storage fee processing apparatus 100 in the present embodiment will be described.

[0042] (3-1. Overall Processing) FIG. 3 is a diagram showing a flow for explaining an outline of the overall processing flow of the control unit 102 of the warehouse storage fee processing apparatus 100 in the present embodiment. With reference to FIG. 3, an outline of the overall processing flow of the control unit 102 of the warehouse storage fee processing apparatus 100 in the present embodiment will be described.

[0043] In this flow, the following is assumed. (1) It is assumed that the cost calculation method is the monthly total average. Regarding the method of adopting the cost of goods sold in the sales data, for the sales category "inventory sales", the inventory valuation unit price of the product is adopted. In the cost calculation process, the cost amount of the sales data within the current month is rewritten based on the recalculated inventory valuation unit price. For the sales category "direct delivery", the purchase amount of the purchase data recorded simultaneously with the sales is adopted as the cost amount. (2) It is assumed that the on-cost of the warehouse storage fee is calculated by the site or the logistics department, etc. for each warehouse and each product. (3) The output of the voucher-by-voucher performance table data is performed by the system department for monthly closing.

[0044] In FIG. 3, the sales input unit 102a executes a sales input process (step S1). Specifically, in the sales input process, the sales input unit 102a inputs sales data and registers it in the storage unit 106 in response to, for example, an operator's operation on a sales input screen (not shown) displayed on the monitor 114.

[0045] The expense payment input unit 102b executes an expense payment input process (step S2). Specifically, in the expense payment input process, the expense payment input unit 102b inputs expense payment schedule data including an expense payment number, an expense accounting date, a payee, a product, an expense item including a warehouse storage fee, and an expense amount, and registers it in the storage unit 106 in response to, for example, an operator's operation on a sales input screen (not shown) displayed on the monitor 114.

[0046] The cost calculation processing unit 102c executes cost calculation processing (step S3). Specifically, in the cost calculation processing, the cost calculation processing unit 102c, for example, calculates the inventory valuation unit price (including miscellaneous charges) for the inventory data that matches the product in the expense payment planned data according to the operator's operation on the cost calculation processing screen displayed on the monitor 114, etc., as ((quantity × inventory valuation unit price) + (expense amount in the expense payment planned data)) ÷ quantity, calculates the allowable inventory valuation unit price (including miscellaneous charges) as the inventory valuation unit price × the allowable inventory calculation deviation rate of the product master. When the inventory valuation unit price (including miscellaneous charges) is smaller than the allowable inventory valuation unit price (including miscellaneous charges), it updates the inventory valuation unit price of the inventory data to the inventory valuation unit price (including miscellaneous charges), and rewrites the cost unit price and cost amount of the sales data where the product matches and the transaction classification is inventory shipment in each sales data. Also, when the inventory valuation unit price (including miscellaneous charges) is not smaller than the allowable inventory valuation unit price (including miscellaneous charges), the cost calculation processing unit 102c may update the monthly miscellaneous charge calculation flag of the expense payment planned data to "1".

[0047] The voucher-by-voucher performance data output unit 102d executes voucher-by-voucher performance data output processing (step S4). Specifically, in the voucher-by-voucher performance data output processing, the voucher-by-voucher performance data output unit 102d, for example, targets the expense payment planned data with the monthly miscellaneous charge calculation flag being "1" according to the operator's operation on the voucher-by-voucher performance data output processing screen displayed on the monitor 114, etc., aggregates the quantity of the product for the sales data where the product matches the product in the expense payment planned data and the sales classification is "inventory shipment". At this time, when the unit of the sales data is different from the converted unit of the product master 106a, it multiplies the quantity by the unit conversion quantity of the product master 106a, calculates the miscellaneous charge unit price as the expense amount in the expense payment planned data ÷ the aggregated value of the quantity of the product, creates the miscellaneous charge calculation result allocation data including the accounting year and month, product, unit, and miscellaneous charge unit price, and registers it in the storage unit 106. Also, the voucher-by-voucher performance data output unit 102d may create the voucher-by-voucher sales performance data based on the sales data and the miscellaneous charge calculation result allocation data and display it on the screen.

[0048] (3-2. Sample Data) Figs. 4 to 7C are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the warehouse storage fee processing apparatus 100 according to the present embodiment. With reference to Figs. 4 to 7C, a specific example of the processing of the control unit 102 of the warehouse storage fee processing apparatus 100 according to the present embodiment will be described. In the following example, the explanation will be based on the sales data and inventory data for the month of October 23rd. Hereinafter, for convenience of explanation, serial numbers NO are attached to each data item.

[0049] (S1: Sales input processing) With reference to Fig. 4, a specific example of the sales input processing will be described. The sales input unit 102a inputs sales data and registers it in the storage unit 106 in response to, for example, an operator's operation on a sales input screen (not shown) displayed on the monitor 114.

[0050] Fig. 4(A) shows an example of the inventory data at the start of October. The inventory data includes items for warehouse, product, quantity, and inventory valuation unit price.

[0051] Fig. 4(B) shows an example of the sales data generated in October. The sales data includes items for sales number, sales classification (inventory shipment, direct delivery), sales date, customer, supplier, product, quantity, unit, sales unit price, sales amount, cost unit price, and cost amount.

[0052] (S2: Expense payment input processing) With reference to Fig. 5, a specific example of the expense payment input processing will be described. The expense payment input unit 102b inputs expense payment number, expense posting date, payee, product, expense item including warehouse storage fee, and expense payment planned data including expense amount, and registers it in the storage unit 106 in response to, for example, an operator's operation on a sales input screen (not shown) displayed on the monitor 114.

[0053] Fig. 5(A) shows an example of the expense payment planned data. The expense payment planned data includes items for expense payment number, expense posting date, payee, product, expense item, expense amount, and current month miscellaneous charges calculation flag. The "current month miscellaneous charges calculation flag" is a flag for determining whether to use the data as target data to be calculated as miscellaneous charges elements for each voucher in the output of the voucher-by-voucher performance table data.

[0054] FIG. 5(B) shows an example of inventory data as of the end of October. FIG. 5(C) shows an example of the product master 106a. The product master 106a includes items such as products, product names, inventory calculation tolerance rates, unit conversion quantities, and converted units. The "inventory calculation tolerance rate" holds the upper limit value recognized as the inventory valuation unit price as a threshold value in the cost calculation process.

[0055] (S3: Cost calculation process) With reference to FIGS. 6A and 6B, a specific example of the cost calculation process will be described. The cost calculation processing unit 102c, for example, in response to an operator's operation on the cost calculation processing screen displayed on the monitor 114, etc., for the inventory data that matches the product in the planned expense payment data, calculates the inventory valuation unit price (accrual) as ((quantity × inventory valuation unit price) + (expense amount in the planned expense payment data)) ÷ quantity, calculates the allowable inventory valuation unit price (accrual) as the inventory valuation unit price × the inventory calculation tolerance rate of the product master, and if the inventory valuation unit price (accrual) is less than the allowable inventory valuation unit price (accrual), updates the inventory valuation unit price of the inventory data to the inventory valuation unit price (accrual), and rewrites the cost unit price and cost amount of the sales data where the product matches and the transaction classification is inventory release in each sales data.

[0056] In the cost calculation process, when "product accrual calculation" = "1: update", it is determined whether to add the planned expense payment data to the inventory valuation based on the current inventory data, planned expense payment data, and product master 106a.

[0057] FIG. 6A shows a display example of the cost calculation processing screen 400. The accounting year and month are automatically displayed on the cost calculation processing screen 400. Also, the cost calculation processing screen 400 includes a column for selecting 1: update or 0: non-update for product accrual calculation and an output button. When "1: update" is selected for product accrual calculation and the output button is pressed, the following processing is executed.

[0058] (1) Determination of target planned expense payment data Based on the planned expense payment data, it is determined whether the expense payment data with the product code registered is used as the data for calculating the inventory valuation unit price. The following calculation process is performed for NO8 and 9 of the expense payment data in Figure 5(A). NO.10 is excluded because the product code is not set.

[0059] (2) Calculation of the inventory valuation unit price including the planned expense payment data This is performed on the inventory data that matches the product code of the planned expense payment data.

[0060] 1. Inventory valuation unit price (for general ledger posting) = ((quantity × inventory valuation unit price) + (expense amount in the planned expense payment data)) ÷ quantity S001: (8 × 55,950 + 12,600) ÷ 8 = 57,525 S002: (100 × 950 + 78,000) ÷ 100 = 1,730

[0061] 2. Allowable inventory valuation unit price (for general ledger posting) = inventory valuation unit price × inventory calculation tolerance rate in the product master S001: 55,950 × 120 / 100 = 67,140 S002: 950 × 140 / 100 = 1,330

[0062] The inventory data and the "inventory valuation unit price (for general ledger posting)" and "allowable inventory valuation unit price (for general ledger posting)" calculated above are retained in the inventory calculation worksheet. Figure 6B(A) is a diagram showing an example of the inventory calculation worksheet.

[0063] The inventory calculation worksheet has columns for warehouse, product, quantity, inventory valuation unit price, inventory valuation unit price (for general ledger posting), and allowable inventory valuation unit price (for general ledger posting).

[0064] (3) Determination of whether to adopt the inventory valuation unit price (for general ledger posting) and update of each data For NO15 in the inventory calculation worksheet, since the "inventory valuation unit price (for general ledger posting)" is smaller than the "allowable inventory valuation unit price (for general ledger posting)", it is within the allowable value. When it is within the allowable value, the following processing is performed. 1) Update the "inventory valuation unit price" in the inventory data with the "inventory valuation unit price (for general ledger posting)". 2) For each sales data where the product codes match, rewrite the cost unit price and cost amount of the sales data with the transaction classification of "stock release".

[0065] As shown in FIG. 6B(B), update the stock evaluation unit price of the stock data of NO11 to "￥57,525". Also, as shown in FIG. 6B(C), rewrite the cost unit price of the sales data of NO3 to "￥57,525" and the cost amount to "￥230,100".

[0066] NO16 of the stock calculation work is outside the allowable value because the "stock evaluation unit price (miscellaneous charges)" is greater than the "allowable stock evaluation unit price (miscellaneous charges)". In the case of being outside the allowable value, perform the following processing. 1) Do not update the "stock evaluation unit price" of the stock data with the "stock evaluation unit price (miscellaneous charges)". 2) Update the "monthly miscellaneous charges calculation flag" of the corresponding expense payment planned data to "1".

[0067] As shown in FIG. 6B(D), update the "monthly miscellaneous charges calculation flag" of the expense payment planned data of NO9 to "1".

[0068] (S4: Voucher-by-voucher actual data output process) Referring to FIGS. 7A to 7B, the voucher-by-voucher actual data output process will be described. The voucher-by-voucher actual data output unit 102d, for example, in response to an operator's operation on the voucher-by-voucher actual data output process screen displayed on the monitor 114, targets the expense payment planned data with the "monthly miscellaneous charges calculation flag" of "1", aggregates the quantities of the sales data that match the product of the expense payment planned data and have the sales classification of "stock release". At this time, if the unit of the sales data is different from the converted unit of the product master 106a, multiply the quantity by the unit conversion quantity of the product master 106a, calculate the miscellaneous charges unit price by dividing the expense amount of the expense payment planned data by the aggregated value of the product quantities, create the miscellaneous charges calculation result allocation data including the accounting year and month, product, unit, and miscellaneous charges unit price, and register it in the storage unit 106.

[0069] In the slip-by-slip performance data output process, when "Merchandise accrued calculation" = "1: Update", based on the current sales data, planned expense payment data, and merchandise master 106a, the planned expense payment data is used to calculate the accrued amount for each sales data, create the allocated accrued calculation result data, and output the data.

[0070] Figure 7A shows an example display of the slip-by-slip performance data output screen 500. The accounting year and month are automatically displayed on the slip-by-slip performance data output screen 500. In addition, the slip-by-slip performance data output screen 500 is provided with a column for selecting 1: Update or 0: Non-update for merchandise accrued calculation, and an output button. When "1: Update" of merchandise accrued calculation is selected and the output button is pressed, the following processing is performed.

[0071] (1) Determination of target planned expense payment data If there is data with "Current month accrued calculation flag" = 1 in the planned expense payment data, create the allocated accrued calculation result data. In this example, since NO9 of the planned expense payment data has "Current month accrued calculation flag" = 1, the following calculation process is performed as the target. NO.8 / 10 is not the target because "Current month accrued calculation flag" = 0.

[0072] (2) Calculate the current month's sales quantity of the merchandise code in the planned expense payment data Aggregate the quantity for the sales data that matches the merchandise code in the planned expense payment data and the transaction category "Inventory shipment".

[0073] 1. If the unit of the sales data is different from the unit after conversion in the merchandise master 106a, multiply the quantity by the unit conversion quantity in the merchandise master 106a. Figure 7B(A) shows an example of sales data. For NO6, since the conversion units are different, multiply by the unit conversion quantity. The aggregated value is 1×2000 + 800 = 2800.

[0074] 2. Calculate the planned expense payment amount per conversion quantity as the accrued unit price, and create the allocated accrued calculation result data. Figure 7B(B) shows the planned expense payment data. In this example, the miscellaneous expense unit price is approximately 78000 / 2800 = 27.86. Create the allocated miscellaneous expense calculation result data as shown in Figure 7B(C). The allocated miscellaneous expense calculation result data includes the items of accounting year and month, product, unit, and miscellaneous expense unit price.

[0075] (3) Display the actual current month's sales data Create and display the sales performance data by invoice based on the sales data and the allocated miscellaneous expense calculation result data. The allocated miscellaneous expense calculation result data is displayed as the miscellaneous expense unit price for the sales data of the transaction category "stock out" with matching product codes.

[0076] Figures 7C(A) and (B) show examples of the sales performance data by invoice. The sales performance data by invoice includes sales number, sales category, sales date, customer, supplier, product, quantity, unit, sales unit price, sales amount, cost unit price, cost amount, converted quantity, converted unit, miscellaneous expense unit price, miscellaneous expense amount, gross profit unit price, and gross profit amount.

[0077] The calculation items are calculated as follows. (1) "Converted quantity" If the unit of the sales data is different from the conversion unit of the product master 106a, multiply the quantity of the sales data by the conversion quantity of the product master 106a. NO18: 4 × 20 = 80 NO21: 1 × 2000 = 2000

[0078] (2) "Miscellaneous expense amount" Calculate by multiplying the converted quantity by the miscellaneous expense unit price. NO20: 2,000 × 27.86 = 55,720 NO21: 800 × 27.86 = 22,288

[0079] (3) Gross profit unit price Calculate as ((sales unit price - cost unit price) ÷ conversion quantity) - miscellaneous expense unit price. For "conversion quantity", when the unit of the sales data is different from the conversion unit of the product master 106a, use the conversion quantity of the product master 106a in the calculation formula. NO18: ($78,000 - $55,950) ÷ 2 = 1,103 NO19: ($850 - $774) ÷ 1 = 76 NO20: ($900 - $85) ÷ 1 = 50 NO21: ($2,000,000 - $1,900,000) ÷ 2,000 - $27.86 = 22.14 NO22: ($970 - $950) ÷ 1 - $27.86 = -7.86

[0080] (4) Gross profit amount It is calculated by subtracting the cost amount and various payables from the sales amount.

[0081] As described above, according to this embodiment, a product master 106a that registers by associating products with the inventory calculation error tolerance rate, an expense payment input unit 102b that inputs expense payment schedule data including an expense payment number, an expense accounting date, a payee, a product, an item including warehouse storage fees, and an expense amount, For the inventory data that matches the product in the expense payment schedule data, the inventory valuation unit price (including various payables) is calculated as ((quantity × inventory valuation unit price) + (expense amount in the expense payment schedule data)) ÷ quantity, and the allowable inventory valuation unit price (including various payables) is calculated as the inventory valuation unit price × the inventory calculation error tolerance rate of the product master. When the inventory valuation unit price (including various payables) is smaller than the allowable inventory valuation unit price (including various payables), the inventory valuation unit price of the inventory data is updated to the inventory valuation unit price (including various payables), and a cost calculation processing unit 102c that rewrites the cost unit price and cost amount of the sales data where the product matches and the transaction category is inventory shipment is provided. Therefore, when capturing warehouse storage fees as a cost element, it is possible to appropriately process whether to include them as an element in the calculation of the inventory valuation unit price.

[0082] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to this embodiment, it can contribute to improving business efficiency and promoting appropriate business judgment of the enterprise, so it is possible to contribute to Goals 8 and 9 of the SDGs.

[0083] In addition, according to the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, thus making it possible to contribute to SDGs Goals 12, 13, and 15.

[0084] In addition, according to the present embodiment, it is possible to contribute to strengthening control and governance, thus making it possible to contribute to SDGs Goal 16.

[0085] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.

[0086] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0087] In addition, regarding 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 the drawings, they can be arbitrarily changed unless otherwise specified.

[0088] Regarding the warehouse storage fee processing device 100, each illustrated component is a functional concept and does not necessarily have to be physically configured as illustrated.

[0089] For example, regarding the processing functions provided by the warehouse storage fee processing device 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the warehouse storage fee processing device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0090] In addition, this computer program may be stored in an application program server connected to the warehouse storage fee processing device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0091] Also, the program for executing the processing described in this embodiment may be stored in a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as 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), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0092] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributed and configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs typified by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0093] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0094] Further, the warehouse storage fee processing 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 any peripheral device is connected. Further, the warehouse storage fee processing device 100 may be realized by installing software (including programs or data, etc.) for realizing the processing described in this embodiment in the device.

[0095] Furthermore, the specific forms of device distribution and integration are not limited to those illustrated, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Reference Numerals

[0096] 100 Warehouse storage fee processing device 102 Control unit 102a Sales input unit 102b Expense payment input unit 102c Cost calculation processing unit 102d Slip-by-slip performance data output unit 102e Master maintenance unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Product master 300 Network

Claims

1. A warehouse storage fee processing device comprising a control unit, wherein the control unit is configured to be accessible to a product master that registers products in association with an inventory calculation tolerance rate, inventory data including a warehouse, a product, a quantity, and an inventory evaluation unit price, sales data including a sales number, a sales category including inventory withdrawal or direct delivery, a sales date, a customer, a supplier, a product, a quantity, a unit, a sales unit price, a sales amount, a cost unit price, and a cost amount, and is configured to be accessible to them, an expense payment input means for inputting expense payment schedule data including an expense payment number, an expense posting date, a payee, a product, an item including a warehouse storage fee, and an expense amount, for inventory data that matches the product in the expense payment schedule data, calculates the inventory evaluation unit price (accrual) as ((quantity × inventory evaluation unit price) + (expense amount in the expense payment schedule data)) ÷ quantity, calculates the allowable inventory evaluation unit price (accrual) as the inventory evaluation unit price × the inventory calculation tolerance rate of the product master, and if the inventory evaluation unit price (accrual) is less than the allowable inventory evaluation unit price (accrual), updates the inventory evaluation unit price of the inventory data to the inventory evaluation unit price (accrual), and a cost calculation processing means for re-washing the cost unit price and cost amount of the sales data where the product matches in each sales data and the transaction category is inventory withdrawal; A warehouse storage fee processing device characterized by comprising the above.

2. The product master is further registered in association with a unit conversion quantity and a converted unit, the expense payment schedule data further includes a monthly accrual calculation flag, the cost calculation processing means is characterized in that when the inventory evaluation unit price (accrual) is not less than the allowable inventory evaluation unit price (accrual), it updates the monthly accrual calculation flag of the expense payment schedule data to "1". The warehouse storage fee processing device according to Claim 1.

3. The control unit further aggregates the quantities of products in the sales data that match the product in the expense payment schedule data with a monthly accrual calculation flag of "1" and a sales category of "inventory withdrawal". At this time, if the unit of the sales data is different from the converted unit of the product master, multiply the quantity by the unit conversion quantity of the product master, calculate the accrual unit price as the expense amount in the expense payment schedule data ÷ the aggregated value of the product quantity, and is characterized by comprising a voucher-by-voucher actual performance data output means for creating accrual calculation result allocation data including the accounting year and month, the product, the unit, and the accrual unit price. The warehouse storage fee processing device according to Claim 2.

4. The slip-by-slip performance data output means creates slip-by-slip sales performance data based on the sales data and the allocated data of the various charges calculation results and displays the same on a screen, and the warehouse storage fee processing apparatus according to claim 3 is characterized in that.

5. A warehouse storage fee processing method executed by an information processing apparatus including a control unit, wherein the control unit is configured to be able to access a product master in which products and an inventory calculation tolerance rate are registered in association with each other, inventory data including a warehouse, a product, a quantity, and an inventory evaluation unit price, sales data including a sales number, a sales category including inventory withdrawal or direct delivery, a sales date, a customer, a supplier, a product, a quantity, a unit, a sales unit price, a sales amount, a cost unit price, and a cost amount, and executed in the control unit, an expense payment input step of inputting expense payment schedule data including an expense payment number, an expense posting date, a payee, a product, an item including a warehouse storage fee, and an expense amount, for the inventory data that matches the product of the expense payment schedule data, calculating the inventory evaluation unit price (for various charges) as ((quantity × inventory evaluation unit price) + (expense amount of the expense payment schedule data)) ÷ quantity, calculating the allowable inventory evaluation unit price (for various charges) as the inventory evaluation unit price × the inventory calculation tolerance rate of the product master, and if the inventory evaluation unit price (for various charges) is less than the allowable inventory evaluation unit price (for various charges), updating the inventory evaluation unit price of the inventory data to the inventory evaluation unit price (for various charges), and a cost calculation processing step of re-washing the cost unit price and the cost amount of the sales data in which the product matches in each sales data and the transaction category is "inventory withdrawal", and a warehouse storage fee processing method characterized by including the above.

6. A warehouse storage fee processing program for causing an information processing apparatus including a control unit to execute, wherein the control unit is configured to be able to access a product master in which products and an inventory calculation tolerance rate are registered in association with each other, inventory data including a warehouse, a product, a quantity, and an inventory evaluation unit price, sales data including a sales number, a sales category including inventory withdrawal or direct delivery, a sales date, a customer, a supplier, a product, a quantity, a unit, a sales unit price, a sales amount, a cost unit price, and a cost amount, and in the control unit, an expense payment input step of inputting expense payment schedule data including an expense payment number, an expense posting date, a payee, a product, an item including a warehouse storage fee, and an expense amount, For the inventory data that matches the product in the planned expense payment data, calculate the inventory valuation unit price (for accounts payable) as ((quantity × inventory valuation unit price) + (expense amount in the planned expense payment data)) ÷ quantity, calculate the allowable inventory valuation unit price (for accounts payable) as the inventory valuation unit price × the allowable inventory calculation error rate in the product master. If the inventory valuation unit price (for accounts payable) is less than the allowable inventory valuation unit price (for accounts payable), update the inventory valuation unit price of the inventory data to the inventory valuation unit price (for accounts payable), and a cost calculation processing step of re-washing the cost unit price and cost amount of the sales data where the product matches in each sales data and the transaction classification is "inventory withdrawal"; A warehouse storage fee processing program for execution.

Images