Slip processing device, slip processing method, and program
The slip processing device addresses the challenge of managing inventory discounts by calculating and reflecting discounts on a product-by-item basis, enhancing inventory management accuracy and promoting efficient electronic systems.
Patent Information
- Application Number
- JP2021161836
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-09-30
- Publication Date
- 2024-12-03
- Estimated Expiration
- 2041-09-30
AI Technical Summary
Existing systems fail to accurately manage inventory when multiple products are discounted on a slip-by-slip basis, leading to difficulties in reflecting discounts on a product-by-item basis during asset management.
A slip processing device and method that calculates and reflects discounts on a product-by-item basis, including a control unit to determine purchase quantities and prices before and after discounts, generate inventory movement data, and create monthly inventory data, with features for setting discounted products and managing inventory management flags.
Enables accurate asset management by reflecting discounts on a product-by-item basis, improving inventory management accuracy and reducing waste through electronic systems.
Smart Images

Figure 0007593905000001 
Figure 0007593905000002 
Figure 0007593905000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a slip processing device, a slip processing method, and a program. [Background technology]
[0002] Patent Document 1 describes a buying and selling management system that accumulates information entered into a slip displayed on a screen as journal data. When a product code is entered into the displayed slip details, this system automatically sets information such as the product name, product tax category, sales price, unit price, and purchase price from a product master file, and automatically inputs the amount of consumption tax and total amount. Also, in this system, when the slip details category is discount, the product tax amount, discount application, and discount amount are entered. The buying and selling management system accumulates information entered into the slip details as journal data. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Publication No. 6-131374 Summary of the Invention [Problem to be solved by the invention]
[0004] In a purchase invoice, multiple products may be discounted together on the invoice basis. In this case, the discount amount is not reflected in the unit price of each product, making it difficult to accurately manage the inventory of purchased products when recording it as an asset.
[0005] The present invention has been made in consideration of the above, and aims to provide a slip processing device, a slip processing method, and a program that enable asset management that reflects discounts on an individual product basis, even if discounts are applied in bulk at the time of purchase. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, a slip processing device according to the present invention is a slip processing device having a control unit, comprising: a purchase slip generating means for generating a purchase slip including a purchase quantity, a pre-discount purchase price, and a pre-discount purchase amount for each purchased product or service; a discount amount obtaining means for obtaining a discount amount for the product or service included in the purchase slip; and a discount amount obtaining means for obtaining a discounted purchase price, a discount amount, and a discounted purchase price for each discounted product or discounted service that is subject to discount among the products or services related to the purchase slip. The system is characterized by comprising a purchase price calculation means for calculating based on the pre-discount purchase amount and the purchase quantity, an inventory movement data generation means for generating inventory movement data including the purchase date, the discounted purchase price, the discounted purchase amount, and the purchase quantity for each inventory management item that is subject to inventory management among the discounted items, and a monthly inventory data generation means for generating monthly inventory data including the quantity for each purchase month, the evaluated unit price, and the evaluated amount for each inventory management item based on the inventory movement data.
[0007] The slip processing device according to the present invention may further comprise setting means for setting the discounted product or service.
[0008] In the slip processing device according to the present invention, a predetermined commodity may be set as the inventory management commodity.
[0009] In addition, the invoice processing method of the present invention is a invoice processing method executed by a invoice processing device equipped with a control unit, and is characterized by comprising the following steps executed by the control unit: a purchase invoice generation step of generating a purchase invoice including a purchase quantity, a pre-discount purchase price, and a pre-discount purchase amount for each purchased good or service; a discount amount acquisition step of acquiring a discount amount for the good or service included in the purchase invoice; a purchase unit price calculation step of calculating a post-discount purchase price for each discounted good or discounted service that is subject to discount among the goods or services related to the purchase invoice based on the discount amount, the pre-discount purchase amount, and the purchase quantity; an inventory movement data generation step of generating inventory movement data including a purchase date, the post-discount purchase price, the post-discount purchase amount, and the purchase quantity for each inventory-managed good that is subject to inventory management among the discounted goods; and a monthly inventory data generation step of generating monthly inventory data including the quantity for each purchase month, an valuation unit price, and an valuation amount for each inventory-managed good based on the inventory movement data.
[0010] In addition, the program of the present invention is characterized in that it causes a computer to execute the following processes: a purchase voucher generation process that generates a purchase voucher including the purchase quantity, pre-discount purchase price, and pre-discount purchase amount for each purchased good or service; a discount amount acquisition process that acquires the discount amount for the good or service included in the purchase voucher; a purchase unit price calculation process that calculates a discounted purchase price for each discounted good or discounted service that is subject to discount among the goods or services related to the purchase voucher based on the discount amount, the pre-discount purchase amount, and the purchase quantity; an inventory movement data generation process that generates inventory movement data including the purchase date, the discounted purchase price, the discounted purchase amount, and the purchase quantity for each inventory-managed good that is subject to inventory management among the discounted goods; and a monthly inventory data generation process that generates monthly inventory data including the quantity, valuation unit price, and valuation amount for each inventory-managed good based on the inventory movement data. Effect of the Invention
[0011] According to the present invention, even if a bulk discount is applied to purchases, asset management can be performed that reflects discounts on an individual product basis. [Brief description of the drawings]
[0012] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a slip processing device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of a product master, purchase header data, purchase detail data, inventory transfer data, and monthly inventory data stored in the storage unit according to the embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of a purchase slip screen displayed on the slip processing device according to the embodiment. [Figure 4] FIG. 4 is a diagram showing an example of a details input screen displayed on the slip processing device according to the embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a purchase slip screen displayed on the slip processing device according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a purchase slip screen displayed on the slip processing device according to the embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a purchase slip screen displayed on the slip processing device according to the embodiment. [Figure 8] FIG. 8 is a diagram showing an example of a details input screen displayed on the slip processing device according to the embodiment. [Figure 9] FIG. 9 is a diagram illustrating an example of inventory movement data according to the embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0013] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a slip processing device, a slip processing method, and a program according to the present invention will be described in detail below with reference to the drawings. However, the present invention is not limited to the embodiment.
[0014] [1. Configuration] An example of the configuration of a slip processing 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 a slip processing device 100 according to this embodiment.
[0015] The slip processing device 100 is a device that processes purchase slips when purchasing goods or services, and manages the inventory of the purchased goods or services. The slip processing device 100 is installed, for example, in the business premises of a construction company that performs construction work, a manufacturer that produces goods, a retailer, etc. In the following explanation, goods may also include services.
[0016] The slip processing device 100 is, for example, a commercially available desktop personal computer. However, the slip processing device 100 is not limited to stationary information processing devices such as desktop personal computers, and may be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers.
[0017] Slip processing device 100 comprises a control unit 102, a communications interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of slip processing device 100 is connected to each other so as to be able to communicate with each other via any communication path.
[0018] The communications interface unit 104 communicatively connects the slip processing device 100 to the network 300 via a communications device such as a router and a wired or wireless communications line such as a dedicated line. The communications interface unit 104 has a function for communicating data with other devices via the communications line. Here, the network 300 has a function for connecting the slip processing 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). The data stored in the memory unit 106 may be stored in the server 200, for example, and the data processed by the control unit 102 may be obtained from the server 200.
[0019] 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 realize 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.
[0020] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. For example, purchase header data 106a, purchase detail data 106b, inventory movement data 106c, monthly inventory data 106d, and product master 106e are stored in the storage unit 106. FIG. 2 shows examples of the purchase header data 106a, purchase detail data 106b, inventory movement data 106c, monthly inventory data 106d, and product master 106e.
[0021] The purchase header data 106a is data including the amount related to the purchase of goods (services). The purchase header data 106a includes a purchase number, a purchase date, a supplier, a total purchase amount excluding tax, a total purchase consumption tax amount, a total purchase amount including tax, a voucher discount amount, and a voucher discount consumption tax amount. The purchase number is a number given to the purchase voucher of the purchased goods (services), the purchase date is the date when the goods (services) related to the purchase voucher were purchased, and the supplier is the supplier of the goods (services) related to the purchase voucher. The total purchase amount excluding tax is the total purchase amount excluding tax of the goods (services) related to the purchase invoice, the total purchase consumption tax amount is the total amount of consumption tax on the goods (services) related to the purchase invoice, the total purchase amount including tax is the total purchase amount including tax of the goods (services) related to the purchase invoice, the invoice discount amount is the amount of discount on the goods (services) related to the purchase invoice, and the invoice discount consumption tax amount is the amount of consumption tax on the discount on the goods (services) related to the purchase invoice.
[0022] The purchase details data 106b includes the amount of the product (service) entered on the purchase slip. The purchase details data 106b includes the purchase number, purchase line number, purchased product, purchase quantity, purchase price, purchase amount, purchase consumption tax, discount amount, discounted consumption tax amount, and pre-discount unit price. The purchased product is the product code assigned to the purchased product (service), the purchase quantity is the quantity of the purchased product (service), and the purchase price is the unit price of the purchased product (service). In addition, the purchase amount is the unit price of the purchased goods (services) multiplied by the purchased quantity, the input consumption tax is the amount of consumption tax on the purchase amount, the discount amount is the amount of discount on the purchased goods (services), the discounted consumption tax amount is the amount of consumption tax on the discount amount, and the pre-discount unit price is the unit price of the goods (services) before it is discounted by the discount amount.
[0023] The inventory movement data 106c includes the history of the quantity, unit purchase price, and purchase amount of purchased goods. The inventory movement data 106c includes the purchase number, purchase date, purchased goods, purchase quantity, unit purchase price, and purchase amount. The purchase date is the date on which the goods entered in the purchase slip were purchased, the purchased goods is the product code assigned to the purchased goods, the purchase quantity is the quantity of the purchased goods, the purchase price is the unit price of the purchased goods, and the purchase amount is the unit price of the purchased goods multiplied by the purchase quantity.
[0024] The monthly inventory data 106d is data for managing the monthly inventory of purchased products. The monthly inventory data 106d includes the accounting year and month, product, end-of-month quantity, end-of-month evaluated unit price, and end-of-month evaluated amount. The accounting year and month is the month for checking the inventory of the purchased product, the product is the product code assigned to the purchased product, the end-of-month quantity is the inventory quantity of the purchased product at the end of the month, the end-of-month evaluated unit price is the inventory evaluated unit price of the purchased product at the end of the month, and the end-of-month evaluated amount is the evaluated amount of the purchased product inventory at the end of the month.
[0025] The product master 106e is a master that stores information related to products (services) purchased by a vendor equipped with the slip processing device 100. The product master 106e includes a product code, a product name, an inventory management unnecessary flag, and a discount target category. The product code is a code assigned to the purchased product (service), and the product name is the name of the purchased product. The inventory management flag is a flag that sets whether or not inventory management is to be performed for the purchased product (service), and the discount target category is a flag that sets whether or not the purchased product (service) is eligible for a discount.
[0026] The control unit 102 is a CPU or the like that performs overall control of the slip processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. In terms of function, the control unit 102 includes a purchase slip generation unit 102a, a discount amount acquisition unit 102b, a purchase unit price calculation unit 102c, an inventory movement data generation unit 102d, a monthly inventory data generation unit 102e, and a setting unit 102f.
[0027] Purchase slip generation unit 102a, which serves as a purchase slip generation means, generates a purchase slip screen including the purchase quantity, pre-discount purchase price, and pre-discount purchase amount for each product or service purchased by a vendor equipped with slip processing device 100 in response to an operation performed on input device 112, and displays the purchase slip screen on output device 114. The purchase slip screen is an example of a purchase slip. The purchase slip screen will be described later.
[0028] The discount amount acquiring unit 102b as a discount amount acquiring means acquires the discount amount for the product or service displayed on the purchase slip screen, which is inputted on the purchase slip screen by the input device 112.
[0029] The purchase price calculation unit 102c, which serves as a purchase price calculation means, calculates the discounted purchase price for each discounted product or service among the products or services displayed on the purchase slip screen that is eligible for discounting, based on the discount amount entered on the purchase slip screen, the purchase amount before discount that is displayed on the purchase slip screen, and the purchase quantity that is displayed on the purchase slip screen.
[0030] The inventory movement data generation unit 102d, which serves as an inventory movement data generating means, generates inventory movement data 106c including the purchase date, discounted purchase price, and purchase quantity for each inventory-managed item that is subject to inventory management and is set as a discount item on the purchase slip screen.
[0031] The monthly inventory data generating unit 102e, which serves as a monthly inventory data generating means, generates monthly inventory data 106d including the quantity, the evaluated unit price, and the evaluated amount for each stock-managed commodity by purchase month.
[0032] The setting unit 102f as a setting means sets discounted products (discounted services) to be discounted among the products (services) displayed on the purchase slip screen in response to an operation performed on the input device 112.
[0033] [2. Specific examples of processing] Here, a specific example of the processing executed by slip processing device 100 will be described with reference to FIGS.
[0034] 3 is a diagram showing an example of a purchase slip screen displayed by slip processing device 100. The operator operates input device 112 to input information related to the purchased goods (services) into purchase slip screen 501 displayed on output device 114. For example, the operator inputs the date the goods and services were purchased into the "Purchase Date" text box on purchase slip screen 501, and inputs the supplier code established for the supplier of the purchased goods into the "Supplier" text box.
[0035] When the operator operates the input device 112 to click on the details area 601 on the purchase slip screen 501, a details input screen 511 as shown in Fig. 4 is displayed. On this details input screen 511, the operator operates the input device 112 to input the product code of the purchased product (service), the quantity of the purchased product (service), and the purchase price of the purchased product (service) before discount. For example, when the product code "K001" is input into the purchase product text box, the slip processing device 100 refers to the product master 106e with the input product code "K001" and displays the product name "temporary construction" associated with the input product code on the details input screen 511 as shown in Fig. 4.
[0036] Furthermore, when the quantity and unit purchase price of purchased goods (services) are entered into the text boxes on the detail input screen 511, the slip processing device 100 displays the calculation result of quantity x unit purchase price based on the entered quantity and unit purchase price as the purchase amount before discount, and displays the calculation result of multiplying the purchase amount by the consumption tax rate as the input consumption tax, as shown in Figure 4. Furthermore, the slip processing device 100 displays the sum of the entered purchase amount and the calculated input consumption tax as the purchase amount including tax.
[0037] When the operator clicks the "Confirm" button displayed on detail input screen 511 in the state shown in Figure 4, slip processing device 100 displays the product code, purchase quantity, purchase price, calculated purchase amount, and calculated purchase consumption tax entered on detail input screen 511 for the line clicked in detail area 601, as shown in Figure 5. In addition, slip processing device 100 displays the product name (service name) displayed on detail input screen 511 as the purchased product name, displays the total purchase amount displayed in detail area 601 as the total purchase amount excluding tax, displays the total purchase consumption tax displayed in detail area 601 as the total purchase consumption tax amount, and displays the result of adding the total purchase amount excluding tax and the total purchase consumption tax amount as the total purchase amount including tax, as shown in Figure 5. In addition, the product master 106e is referenced for the product code entered on the detail input screen 511. If the discount category associated with the entered product code is "1: Discounted", a check mark is displayed in the "Discount" column of the detail area 601. If the discount category associated with the entered product code is "0: Not discounted", a check mark is displayed in the "Discount" column of the detail area 601 without being checked.
[0038] When the operator enters the product code, purchase quantity, and purchase price for other purchased goods (services) on the detail input screen 511 and clicks the "Confirm" button, the slip processing device 100 displays, for example, the purchase slip screen 501 as shown in Figure 6, based on the input made on the detail input screen 511.
[0039] When a purchase slip has a discount per slip, the operator inputs the discount amount for the product displayed on the purchase slip screen on purchase slip screen 501. When the operator operates input device 112 to input "-600,000" as the discount amount in the "Discount amount" text box on purchase slip screen 501, slip processing device 100 displays "-60,000" as the discounted consumption tax corresponding to the input discount amount.
[0040] Furthermore, the operator checks the "Discount" column of the details area 601 for products (services) that are eligible for discount among the products or services displayed in the details area 601, and unchecks the "Discount" column of the details area 601 for products (services) that are not eligible for discount. For example, if a product (service) with the purchase product name "temporary construction", a product (service) with the purchase product name "base repair work", and a product with the purchase product name "material cost (concrete)" are eligible for discount, the operator checks the "Discount" column of the details area 601 for these products (services) as shown in FIG. 6. Note that, if a product (service) with the purchase product name "transportation volume" is not eligible for discount, the operator unchecks the "Discount" column of the details area 601 for this product as shown in FIG. 6.
[0041] When the operator finishes inputting the discount amount and clicks the "Reflect Amount" button, the slip processing device 100 updates the purchase slip screen 501. Specifically, the slip processing device 100 first pro rataly distributes the input discount amount to the purchased goods (purchased services) that are the subject of the discount. Here, the slip processing device 100 calculates the discount amount for each discounted purchased goods or services that have a discount check mark on, based on the ratio of the purchase amounts of the purchased goods (purchased services) that have a discount check mark on the purchase slip screen 501. For example, in the case of the purchase slip screen 501 shown in FIG. 6, the ratio of the purchase amounts for the purchased goods and services that have check marks on and are numbered 1 to 3 is 3:2:1, so the slip processing device 100 pro rataly distributes the discount amount at a ratio of 3:2:1.
[0042] When a discount amount of "-600,000" is entered on the purchase slip screen 501 shown in Figure 6 and the "Reflect amount" button is clicked, the slip processing device 100 will set the discount amount for purchased item "K001" numbered "1" to "-300,000," for purchased item "K002" numbered "2," and for purchased item "Z001" numbered "3," to "-100,000."
[0043] Next, in the row with purchase line number "1" in details area 601, the slip processing device 100 applies the discount amount prorated for purchased item "K001" of "-300,000" to the purchase amount before the update of "4,500,000" to update the purchase amount to "4,200,000." Additionally, in the row with purchase line number "1" in details area 601, the slip processing device 100 updates the input consumption tax to "420,000" using the consumption tax amount of the updated purchase amount. In addition, the slip processing device 100 calculates the amount by dividing the discount amount allocated to the purchased item "K001" by the purchase quantity in the row with purchase row number "1" in the details area 601, and updates the discounted purchase price to "4,200,000" by the amount obtained by subtracting the calculated amount from the purchase price before the update.
[0044] The slip processing device 100 also updates the unit purchase price, purchase amount, and purchase consumption tax for rows numbered 2 and 3 on the purchase slip screen 501 shown in Figure 6 in the same manner as for row numbered 1. Note that for row numbered 4 on the purchase slip screen 501 shown in Figure 6, the discount check mark is off, so no discount is applied to the product with product code "YSU001" displayed in row numbered "4." For this reason, the slip processing device 100 does not update the unit purchase price, purchase amount, and purchase consumption tax for row numbered 4 on the purchase slip screen 501 shown in Figure 6.
[0045] In addition, the slip processing device 100 updates the total purchase amount excluding tax on the purchase slip screen 501 with the updated total purchase amount, updates the total purchase consumption tax amount on the purchase slip screen 501 with the updated total purchase consumption tax, and updates the total purchase amount including tax on the purchase slip screen 501 with the updated total purchase amount excluding tax and the updated total purchase consumption tax amount. With these updates, the slip processing device 100 displays the updated purchase slip screen 502 shown in FIG. 7.
[0046] When an operator wishes to check the discount amount for each purchased product (service) on the updated purchase slip screen 502, the operator operates the input device 112 to click on details area 601 on the purchase slip screen 502. For example, when the line for product code "K001" is clicked on the purchase slip screen 502, the slip processing device 100 displays details input screen 512 shown in FIG. 8 based on the information displayed in details area 601 on the purchase slip screen 502 and the discount amount apportioned to the product (service) with product code "K001."
[0047] When the operator finishes inputting the discount amount and clicks the "Reflect Amount" button, and then operates the input device 112 to click the "Register" button on the purchase slip screen 501, the slip processing device 100 generates purchase header data 106a and purchase detail data 106b. Specifically, the slip processing device 100 generates a purchase number corresponding to the input purchase slip, and stores the generated purchase number in the "Purchase Number" column of the purchase header data 106a, stores the purchase date "2021 / 7 / 1" entered on the purchase slip screen 502 in the "Purchase Date" column, and stores the supplier "TKY001" entered on the purchase slip screen 502 in the "Supplier" column, as shown in FIG. 2.
[0048] In addition, as shown in Figure 2, the invoice processing device 100 stores the amount "9,400,000" obtained by applying the input discount amount "-600,000" to the total purchase amount excluding tax "10,000,000" before applying the discount amount in the "Total purchase amount excluding tax" column, stores the amount "940,000" obtained by applying the calculated discounted consumption tax "-60,000" to the total purchase tax amount "1,000,000" before applying the discounted consumption tax in the "Total purchase tax amount" column, and stores the amount "10,340,000" obtained by applying the discount amount "-600,000" and discounted consumption tax "-60,000" to the purchase amount including tax "11,000,000" before applying the discount amount and discounted consumption tax in the "Total purchase amount including tax" column. In addition, as shown in Figure 2, the voucher processing device 100 stores the input discount amount "-600,000" in the "voucher discount amount" column, and stores the calculated discounted consumption tax "-60,000" in the "voucher discounted consumption tax" column.
[0049] Furthermore, slip processing device 100 reflects the discount amount entered on purchase slip screen 502 in the purchase price displayed in details area 601 to generate purchase details data 106b.
[0050] The voucher processing device 100 generates a row with purchase row number "1" in the purchase detail data 106b, and in the generated row, stores the product code "K001" displayed in the row with purchase number "1" in the "Purchase product" column, and stores the purchase quantity "1" displayed in the row with purchase number "1" in the "Purchase quantity" column. The voucher processing device 100 also stores the purchase price "4,200,000" displayed in the row with number 1 on the purchase voucher screen 502 in the "Purchase price" column, stores the purchase amount "4,200,000" displayed in the row with number 1 on the purchase voucher screen 502 in the "Purchase amount" column, and stores the purchase consumption tax "420,000" displayed in the row with number 1 on the purchase voucher screen 502 in the "Purchase consumption tax" column. In addition, in the row with purchase line number "1" in purchase detail data 106b, slip processing device 100 stores the discount amount prorated for purchased item "K001" as "-300,000" in the "Discount amount" column, and stores the consumption tax amount on this discount amount, "-30,000", in the "Discounted consumption tax amount" column. In addition, in the row with purchase line number "1" in purchase detail data 106b, slip processing device 100 stores the pre-discount purchase price of purchased item "K001", "4,500,000", in the "Unit price before discount" column.
[0051] The voucher processing device 100 also generates rows with purchase row numbers "2" and "3" in the purchase detail data 106b for rows numbered 2 and 3 on the purchase voucher screen 502 shown in Figure 7, and stores the purchase number, purchased item, purchase quantity, purchase price, purchase amount, purchase consumption tax, discount amount, discounted consumption tax amount, and pre-discount unit price in the generated rows in the same manner as for the row numbered 1.
[0052] 7, the discount check mark is off for the row numbered 4 on the purchase slip screen 502, so no discount is applied to the product (service) with product code "YSU001" displayed in the row with purchase number "4." Therefore, for the row numbered 4 on the purchase slip screen 501, the slip processing device 100 generates a row with purchase row number "4" in the purchase detail data 106b, and stores "0" in the "Discount amount," "Discounted consumption tax amount," and "Unit price before discount" columns. In addition, for the row with purchase row number "4" in the purchase detail data 106b, the voucher processing device 100 stores the purchase price "1,000,000" displayed in the row with number 4 on the purchase voucher screen 502 in the "Purchase price" column, stores the purchase amount "1,000,000" displayed in the row with number 4 on the purchase voucher screen 502 in the "Purchase amount" column, and stores the purchase consumption tax "100,000" displayed in the row with number 4 on the purchase voucher screen 502 in the "Purchase consumption tax" column.
[0053] Next, voucher processing device 100 updates inventory movement data 106c including the product code stored in the "Purchased product" column of generated purchase detail data 106b. If inventory movement data 106c including the product code stored in the "Purchased product" column of generated purchase detail data 106b is not stored in memory unit 106, voucher processing device 100 generates new inventory movement data 106c including the product code. The purchased products for which inventory movement data 106c is generated or updated are purchased products for which the inventory management flag in product master 106e is set to "0: inventory managed."
[0054] For example, when inventory movement data 106c including product code "Z001" is stored in the memory unit 106, the voucher processing device 100 adds a second line including the generated purchase number and the purchase date entered on the purchase voucher screen 502, as shown in Figure 9, and stores the purchase quantity, purchase price, and purchase amount stored in the third line of the purchase detail data 106b in the second line of the inventory movement data 106c.
[0055] For products for which the inventory management unnecessary flag is set to "0: inventory managed" in product master 106e, slip processing device 100 updates monthly inventory data 106d monthly. For example, for a product with product code "Z001", the inventory management unnecessary flag is set to "0: inventory managed", so slip processing device 100 updates monthly inventory data 106d based on inventory movement data 106c. For example, if inventory movement data 106c is in the state shown in FIG. 2, monthly inventory data 106d is updated based on this inventory movement data 106c as shown in FIG. 2. By referring to the updated monthly inventory data 106d, an operator can check the monthly inventory of purchased products and the valuation amount including discounts.
[0056] [3. Effects of the embodiment] According to the slip processing device 100 of the embodiment, the discount on a slip basis is reflected in the unit price of the purchased goods, so that the inventory of purchased goods can be accurately managed when it is recorded as an asset.
[0057] [4. 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 goals 8 and 9 of the SDGs.
[0058] 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.
[0059] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0060] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0061] 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.
[0062] In addition, 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 may be changed as desired unless otherwise specified.
[0063] Furthermore, with regard to slip processing device 100, the components shown in the figures are merely functional concepts, and the slip processing device 100 does not necessarily have to be physically configured as shown in the figures.
[0064] For example, all or any part of the processing functions of slip processing device 100, particularly the processing functions performed by control unit 102, may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the slip processing device to execute the processes described in this embodiment, and is mechanically read by slip processing 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 give instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM, and works with the CPU to configure control unit 102.
[0065] This computer program may also be stored in an application program server connected to slip processing device 100 via any network, and may be downloaded in whole or in part as needed.
[0066] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.
[0067] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. 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, may use well-known configurations and procedures.
[0068] The various databases etc. stored in the memory unit 106 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 etc. used for various processes and providing websites.
[0069] Furthermore, slip processing device 100 may be configured as a slip processing device such as a known personal computer or workstation, or may be configured as slip processing device 100 connected to any peripheral device. Furthermore, slip processing device 100 may be realized by installing software (including programs and data, etc.) that causes the slip processing device to perform the processing described in this embodiment.
[0070] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0071] The present invention is useful for construction companies that purchase goods, manufacturers that manufacture goods, retailers, and the like. [Explanation of symbols]
[0072] 100 Slip processing device 102 Control section 102a Purchase slip generation section 102b Discount amount acquisition section 102c Purchase price calculation section 102d Inventory movement data generation department 102e Monthly inventory data generation section 102f Setting section 104 Communication interface section 106 Storage section 106a Purchase header data 106b Purchase details data 106c Inventory movement data 106d Monthly inventory data 106e Product Master 108 Input / Output Interface Section 112 Input Device (Keyboard) 114 Output device (monitor) 200 Servers 300 Network 501, 502 Purchase slip screen 511, 512 Detail input screen 601 Details Area
Claims
1. A slip processing device having a control unit, a purchase slip generating means for generating a purchase slip including a purchase quantity, a purchase price before discount, and a purchase amount before discount for each purchased product or service; a discount amount acquisition means for acquiring a discount amount for the product or service included in the purchase slip; a purchase unit price calculation means for calculating a discounted purchase unit price for each discounted product or service that is subject to discount among the products or services related to the purchase slip, based on the discount amount, the purchase amount before discount, and the purchase quantity; an inventory movement data generating means for generating inventory movement data including a purchase date, the discounted purchase price, the discounted purchase amount, and the purchase quantity for each inventory management item that is the subject of inventory management among the discounted items; a monthly inventory data generating means for generating monthly inventory data including a quantity, an evaluated unit price, and an evaluated amount for each of the inventory-managed commodities based on the inventory movement data; A slip processing device comprising:
2. 2. The slip processing device according to claim 1, further comprising setting means for setting the discounted goods or services.
3. The predetermined product is the inventory management product. The slip processing device according to claim 1 or 2.
4. A slip processing method executed by a slip processing device having a control unit, Executed by the control unit, a purchase slip generating step of generating a purchase slip including a purchase quantity, a purchase price before discount, and a purchase amount before discount for each purchased product or service; a discount amount acquisition step of acquiring a discount amount for the goods or services included in the purchase slip; a purchase unit price calculation step of calculating a discounted purchase unit price for each discounted product or service that is subject to discount among the products or services related to the purchase slip, based on the discount amount, the purchase amount before discount, and the purchase quantity; an inventory movement data generating step of generating inventory movement data including a purchase date, the discounted purchase price, the discounted purchase amount, and the purchase quantity for each inventory management item that is a target of inventory management among the discounted items; a monthly inventory data generating step of generating monthly inventory data including a quantity, an evaluated unit price, and an evaluated amount for each of the inventory-managed commodities based on the inventory movement data; A slip processing method comprising:
5. On the computer, a purchase slip generation process for generating a purchase slip including a purchase quantity, a purchase price before discount, and a purchase amount before discount for each purchased product or service; A discount amount acquisition process for acquiring a discount amount for the product or service included in the purchase slip; a purchase unit price calculation process for calculating a discounted purchase price for each discounted product or service that is subject to discount among the products or services related to the purchase slip, based on the discount amount, the purchase amount before discount, and the purchase quantity; an inventory movement data generation process for generating inventory movement data including a purchase date, the discounted purchase price, the discounted purchase amount, and the purchase quantity for each inventory management item that is a target of inventory management among the discounted items; a monthly inventory data generation process for generating monthly inventory data including a quantity, an evaluation unit price, and an evaluation amount for each of the inventory management products based on the inventory movement data; A program for executing the above.
Citation Information
Patent Citations
Buying / Selling control system
JP1994131374A
Stocking managing device
JP2001014554A
Acquisition promotion supporting method, method and device for supporting sales promotion, accounting processor and recording medium
JP2001092886A
Service sale method, service provision device, and service sale system
JP2003122985A
