JPH09223272A - Purchase slip preparation device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically prepare the purchase slip of purchase products by calculating a retail price from a read coefficient and an inputted purchase cost and printing the calculated retail price and the inputted purchase cost on a slip form. SOLUTION: In a hard disk device 7, a supplier tile 20 for which the titles of the suppliers or the like is set beforehand for respective supplier codes for identifying the suppliers of the respective kinds of the products and a product classification file 30 for which the classification titles and mark-on rate etc., of the product groups are set beforehand for respective classification codes for identifying the product groups for classifying the respective products are formed. Then, the rate of the product classification file is the coefficient for deciding the retail price to the purchase cost of the product belonging to the corresponding product classification. To put it concretely, the coefficient calculated by (100/(100-rate)) is multiplied with the purchase cost and the retail price is calculated. The calculated retail price and the purchase cost are printed on the slip form by a printer 13. Thus, the purchase slip of the purchase product is automatically prepared.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a purchase slip creating apparatus used in a headquarters system in a retail store or retail business.

[0002]

2. Description of the Related Art For example, in a retail store, every time a product is purchased from a wholesaler, supplier information such as the purchase date, the name of the distributor, the classification of the purchased product, the purchase cost, and the retail selling price are recorded. By creating and storing receipt slips, business management related to purchasing is performed. Here, the retail selling price is calculated by multiplying the purchase cost by a certain coefficient, and the coefficient is (100 /
(100-value entry rate [%])). Generally, the purchase rate [%] is set to a fixed value according to each product category, for example, a group of products such as food, clothing, and household appliances, and the purchaser is in charge of each purchase of the product. In addition, check the rate of purchase of the category to which the product belongs, calculate the coefficient, multiply the purchase cost by this coefficient to calculate the retail selling price, and then enter the purchase cost, retail selling price, etc. on the slip sheet. Purchasing slips were properly created by.

[0003]

[Problems to be Solved by the Invention] However, in the conventional purchase slip preparation work, since the purchase cost of a product is entered in the delivery slip, etc., it is easy to understand, but the retail selling price is the classification of the purchased product. It is necessary to calculate the coefficient for the purchase cost by obtaining the value-added rate determined by the purchase rate, and to multiply the purchase cost by this coefficient to calculate it, which is time-consuming and prone to calculation errors. Was there.

Therefore, according to the present invention, a purchase slip for a purchase product can be automatically created only by inputting a code for specifying the purchase product and the purchase cost thereof. An object of the present invention is to provide a purchase slip preparation device which can reduce the burden on the purchaser and the person in charge of purchase.

[0005]

SUMMARY OF THE INVENTION According to the present invention, a coefficient storage unit that presets and stores a coefficient for determining a retail selling price with respect to a purchase cost for each product code, and an input for inputting a purchase product code and a purchase cost. And means are provided. Then, when the code of the purchased product and the purchase cost are input by this input means, the coefficient corresponding to the code of the purchased product is read from the coefficient storage unit, and the read coefficient and the purchase input by the input means are input. When the retail selling price is calculated from the cost, the calculated retail selling price and the purchase cost input by the input means are printed on a slip sheet to create a purchase slip.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. In this embodiment, the case where the purchase slip preparation device of the present invention is applied to a mass retailer handling various products such as food, home appliances, clothing, stationery, and miscellaneous goods will be described.

FIG. 1 is a block diagram showing a schematic configuration of such a purchase slip preparation device, and a CP constituting a control unit main body.
A U (central processing unit) 1 is installed. In addition, the CP
A ROM (Read Only Memory) 2 in which fixed data such as a program for controlling the operation of U1 is stored in advance, a print buffer, a display buffer, and various memory areas for temporarily storing key input data from the keyboard 9 and the like. A RAM (random access memory) 3 provided therein, an EEPROM (electrically erasable ROM) 4 which is a non-volatile rewritable memory, a clock unit 5 for measuring the current date and time, and an external device such as a host computer. It is equipped with a communication interface 6 for controlling data communication with the computer.

Further, this purchase slip preparation device is an HDD (hard disk drive) for writing and reading data to and from the hard disk device 7 as a large capacity storage medium.
Drive) controller 8 and keyboard controller 1 for taking in key signals from a keyboard 9 as an input means
0, various controls such as a display controller 12 that controls driving of a display 11 as display means and sends display data and the like, and a printer controller 14 that controls driving of a printer 13 as printing means and sends print data and the like. Equipped with an input / output device controller. And the CPU 1
And ROM2, RAM3, EEPROM4, clock section 5,
The communication interface 6 and the various input / output device controllers 8, 10, 12, 14 are connected by a bus line 15 such as an address bus and a data bus to form an internal circuit.

As shown in FIG. 2, the hard disk device 7 has a supplier file 2 in which the name of the supplier is preset for each supplier code for identifying the supplier of various products.
0 and, as shown in FIG. 3, a product classification file 30 in which the classification name, the rate of price insertion, etc. of the product group are preset for each classification code that identifies the product group that classifies each product. The price insertion rate [%] functions as a coefficient that determines the retail selling price with respect to the purchase cost of the product belonging to the corresponding product classification. Specifically, the retail price is calculated by multiplying the purchase cost by a coefficient calculated by (100 / (100-value-adding rate)).
Here, the product classification file 30 functions as a coefficient storage unit.

As shown in FIG. 4, the keyboard 9 includes a numeric keypad 91 consisting of "0" to "9", "." And "C", as well as an "ENT" entry key 92 and "x".
Multiply key 93 for, unit price key 94 for "unit price", "next"
Various function keys such as the next key 95 and the end key 96 of "end" are provided.

The display 11 is a CRT display,
It has a screen such as a liquid crystal display. The printer 13 prints data on a predetermined slip sheet or the like. In the EEPROM 4, as shown in FIG. 5, an area 50 for storing and holding a fixed value input rate is formed. Incidentally, in this embodiment, the fixed value-adding rate is 1
5.0% is set in the area 50.

In this purchase slip preparation apparatus, when the value input rate setting operation is selected by inputting the ten key 91 of the keyboard 9 on the initial menu screen, the CPU 1 causes the CPU 1 to execute the operation shown in FIG.
The program of the ROM 2 is formed so as to execute the processing shown in the flowchart of FIG. The value-adding rate setting operation is executed when the value-adding rate set for each product category in the product classification file 30 is corrected.

That is, when the processing of the value-added rate setting work is started, the CPU 1 first causes the display 11 to display the value-added rate setting screen G1 shown in FIG. Further, as step p1, the data of the product classification file 30 is read from the hard disk device 7 and expanded in a predetermined area of the RAM 3. The value-adding rate setting screen G1 has a classification code area A1, a classification name area A2, and a value-adding rate area A3. On the same screen G1, the set date [yy / mm / dd] is the current date measured by the clock unit 5, and the fixed value input rate [15.0].
Is fixed value entry rate data set in the area 50 of the EEPROM 4.

In this state, in step p2, the process waits until the classification code of the product classification for changing the value-adding rate is input. Then, when the classification code is entered by the ten-key pad 91 and then the entry key 92 is entered, the entered classification code is entered in the area A1 of the value insertion rate setting screen G1.
To be displayed. Further, in step p3, the data of the product classification file 30 developed in the RAM 3 is searched and the classification name data corresponding to the registered classification code is read.
Then, this classification name data is displayed in the area A2 of the value-adding rate setting screen G1.

Next, as step p4, the unit price key 94
Wait for input. When the input of the selling unit price key 94 is detected, it is determined in step p5 whether or not the numerical key 91 has been used to perform the number setting immediately before that. Here, if the registration is performed, step p
6 is displayed in the area A3 of the value-adding rate setting screen G1, and the value-adding rate data corresponding to the classification code registered in the step p2 in the data of the product classification file 30 expanded in the RAM3. Is rewritten to the numerical data.

On the other hand, if the number has not been entered in step p5, the fixed value-adding rate data stored in the area 50 of the EEPROM 4 is read and displayed in the area A3 of the value-adding rate setting screen G1. , Of the data of the product classification file 30 developed in the RAM 3 is rewritten to the fixed value-added rate data corresponding to the classification code entered in step p2.

Then, in step p8, the end key 96
Or the next key 95 is input in step p9. If the key input of the next key 95 is detected, the process returns to step p2 and the above process is repeated. On the other hand, if the end key 96 is pressed at step p8, the RAM 3 is selected at step p10.
The data of the merchandise classification file 30 developed in the above is used as print data and is sent to the printer 13 to print out a value insertion rate list 80 having a format as shown in FIG. 8 on a recording paper.

Then, in step p11, the RAM 3
The data of the product classification file 30 that has been expanded to is overwritten on the product classification file 30 of the hard disk device 7 to update the product classification file 30. This completes the processing of the value-added rate setting operation and returns the display screen from the value-added rate setting screen G1 to the initial menu screen.

When the slip preparation operation is selected by inputting ten keys 91 on the initial menu screen, the CP
ROM so that U1 executes the process shown in the flowchart of FIG.
It forms two programs. It should be noted that this slip creation work is executed when a purchase slip for each supplier is created.

That is, when the processing of the slip preparation work is started, the CPU 1 first causes the display 11 to display the purchase slip input screen G2 shown in FIG. The purchase slip input screen G2 is displayed on the supplier code area A4 and the supplier name area A.
5 and a slip description area A6. Voucher detail area A
6 is a multi-line classification code column, classification name column, original unit price column,
It consists of a cost amount column, a selling unit price column, and a selling price column. On the same screen G2, the slip number [zzzzzzzz1] is the data of the slip number counter that is incremented each time the slip creation operation is started, and the set date [yy / mm / dd] is the current date measured by the clock unit 5. .

In this state, step q1 waits for the supplier code to be input. And ten keys 91
When the supplier code is entered by, and the entry key 92 is subsequently input, the entered supplier code is displayed in the area A4 of the purchase slip input screen G2. In step q2, the data of the supplier file 20 is read from the hard disk device 7, the supplier name data corresponding to the entered supplier code is read from the file data, and the supplier slip input screen G2 is displayed. Display in area A5.

Next, in step q3, the process waits for the classification code of the classification to which the purchased product belongs. Then, if the classification code is entered by the ten keys 91 and then the entry key 92 is entered, the entered classification code is displayed in the first line of the classification code column in the area A6 of the purchase slip input screen G2. Let Further, in step q4, the data of the commodity classification file 30 is read from the hard disk device 7, and the classification name data and the value insertion rate data corresponding to the classification code entered from the file data are read. Then, the classification name data is displayed in the first line of the classification name column in the area A6 of the purchase slip input screen G2. Further, the value-added rate data is temporarily stored in the RAM 3.

Next, in step q5, the process waits until the quantity of purchased goods and the original unit price, which is the purchase cost per piece, are input. And the numeric keypad 9 of the keyboard 9
The quantity is entered by 1 and then the multiplication key 93 is entered, and the original unit price is entered by the ten-key 91,
Then, when the entry key 92 is input, the quantity of cost, which is the purchase cost of the purchased product, is calculated by multiplying the quantity entered and the original unit price entered in step q6. Then, in step q7, the quantity, the original unit price, and the cost amount are displayed on the first line of each of the quantity column, the original unit price column, and the cost amount column in the area A6 of the purchase slip input screen G2.

Next, in step q8, the unit price key 94
Wait for input. When the input of the selling unit price key 94 is detected, it is determined in step q9 whether or not the numerical key 91 has been used to perform the numeral input immediately before that. Here, if the registration is performed, step q
The unit price data is set as 10, and the selling price is the retail selling price per purchased product, and the selling price is the retail selling price of the purchased product by multiplying this selling price by the quantity entered in step q5. To calculate.

Thereafter, in step q14, the selling unit price and the selling price amount are displayed on the first line of each of the selling unit price column and the selling price amount column in the area A6 of the purchase slip input screen G2. Also, the respective amount data in the cost amount column and the selling price amount column are summed up to calculate the respective total amounts of the cost amount and the selling price amount, and the respective total amounts are displayed in the corresponding total amount column respectively.

On the other hand, if the number has not been entered at step q9, the value-adding rate data temporarily stored in the RAM 3 is read at step q11 (coefficient reading means). Then, as step q12, the selling price of the purchased product is calculated by the following equation (1). Selling unit price = (original unit price / [(100−value-adding rate) / 100]) (1) Further, as step q13, the selling price amount of the purchased product is calculated by the following equation (2). Sale price amount = (cost amount amount / [(100−value-adding rate) / 100]) (2) In the above formulas (1) and (2), “unit price” is the unit price data input in step q5. The “cost amount” is the cost amount data calculated in step q6 (retail selling price calculation means).

After that, the process proceeds to the step 14, and the selling unit price and the selling price amount calculated in the steps q12 and q13 are displayed on the first line of the selling unit price column and the selling price amount column in the area A6 of the purchase slip input screen G2. Display it. Also, the respective amount data in the cost amount column and the selling price amount column are summed up to calculate the respective total amounts of the cost amount and the selling price amount, and the respective total amounts are displayed in the corresponding total amount column respectively.

After that, the end key 9 is entered in step q15.
6 or the next key 95 is waited for in step q16. If the key input of the next key 95 is detected, the process returns to step q3 to repeat the above process. In this case, the classification code, the classification name, the quantity, the original unit price, the cost amount, the selling unit price and the selling price amount of the newly input purchased commodities are sequentially displayed in the next row of the area A6.

On the other hand, when the key input of the end key 96 is detected in step q15, the data displayed on the purchase slip input screen G2 is used as print data in step q17, and is sent to the printer 13, A purchase slip 110 having a format as shown in FIG. 11 is printed out on a slip sheet. After that, this voucher creation work is terminated, and the display screen is returned from the purchase voucher input screen G2 to the initial menu screen.

In the purchase slip preparation apparatus of this embodiment having the above-mentioned configuration, the supplier file 20 and the commodity classification file 30 are formed in the hard disk device 7. In this state, when a product is purchased from a certain supplier, the person in charge first selects the slip preparation work. Then, the purchase slip input screen G2 is displayed on the display unit 11.
Then, the person in charge next inputs the supplier code of the supplier. For example, if the supplier is "AAAAA", "1" is entered and then the entry key 92 is input. Then, the supplier code "000001" is displayed in the area A4 of the purchase slip input screen G2. Further, the supplier name data "AAAA" corresponding to the entered supplier code is read from the supplier file 20 and displayed in the area A5 of the same screen G2.

Then, the person in charge next inputs the classification code of the classification to which the purchased product belongs. For example, if the purchased product is a food product, "1000" is entered, and then the entry key 92 is entered. Then, the purchase slip input screen G2
The classification code “1000” is displayed in the first line of the classification code column in the area A6. Further, the classification name data “food” corresponding to the inputted classification code is read from the product classification file 30 and displayed on the first line of the classification name column in the area A6.

Then, the person in charge next inputs the quantity and the original unit price of the purchased goods. For example, if the quantity is 1 point and the original unit price is 120 yen, first enter "1" and then enter the multiplication key 93, then enter "120" and then press the entry key 92. input. Then, the quantity "1.00" is displayed in the first line of the quantity column in the area A6 of the purchase slip input screen G2, and the original unit price "120.00" is displayed in the first line of the original unit price column in the area A6. To be done. Further, the input amount and the original unit price are multiplied to calculate the cost amount of 120 yen, and the cost amount "120" is displayed in the first line of the cost amount column in the area A6.

Then, the person in charge next determines whether or not to use the value-adding rate preset in the product classification file 30. Then, when used, the unit price key 94 is blanked. Then, the unit selling price and the selling price of the purchased product are respectively set at the price ratio "15.0" corresponding to the classification code "1000" of the classification "food" to which the purchased product belongs in advance in the product classification file 30. It is calculated by the equations (1) and (2). Then, in the first line of each of the selling price column and the selling price column in the area A6 of the purchase slip input screen G2, the calculated selling price "141.41", respectively.
And the selling price amount “141” is displayed. The unit selling price may be displayed as "141.00" by rounding down the number after the decimal point.

Next, if another product is purchased from the same supplier, the person in charge inputs the next key 95 and
Enter the classification code of the classification to which the other product belongs. For example, if the purchased product is a home appliance product, enter "2000"
Then, the entry key 92 is input. Then, the classification code "2000" input in the second line of the classification code column in the area A6 of the purchase slip input screen G2 is displayed. Further, the classification name data “home appliances” corresponding to the inputted classification code is read from the product classification file 30,
It is displayed on the second line of the classification name column in the same area A6.

Then, the person in charge next inputs the quantity and the original unit price of the purchased goods. For example, if the quantity is 2 points and the original unit price is 150 yen, first enter "2" and then enter the multiplication key 93, then enter "150" and then enter the entry key 92. input. Then, the quantity “2.00” is displayed in the second line of the quantity column in the area A6 of the purchase slip input screen G2, and the original unit price “150.00” is displayed in the first line of the unit price column in the same area A6. To be done. Further, the input amount and the original unit price are multiplied to calculate the cost amount of 300 yen, and the cost amount "300" is displayed in the second line of the cost amount column in the area A6.

Then, the person in charge next determines whether or not to use the value-added rate preset in the product classification file 30. Then, when used, the unit price key 94 is blanked. Then, the selling unit price and the selling price amount of the purchased product are respectively set at the value-adding rate "16.5" corresponding to the classification code "2000" of the classification "home appliance" to which the purchased product belongs in advance in the product classification file 30. It is calculated by the equations (1) and (2). Then, the calculated selling unit price “179.64” is displayed in each of the second line of the selling unit price column and the selling price amount column in the area A6 of the purchase slip input screen G2.
And the selling price amount “359” is displayed.

Thereafter, if there is no product purchased from the same supplier, the person in charge inputs the end key 96. Then, the printer 13 is driven, and the purchase slip 110 as shown in FIG. 11 is automatically printed and issued.

As described above, when the value-added rate preset in the product classification file 30 is used, it is only necessary to input the classification code, quantity and original unit price of the purchased product, and the purchased product is automatically purchased. The selling unit price and the selling price amount are calculated, these are filled in, and the purchase slip for each supplier can be acquired. In this case, since the classification code, quantity, and original unit price of the purchased product are clear from the delivery slip attached to the purchased product, the person in charge can easily enter them. Further, since it is no longer necessary to calculate the retail selling price (selling unit price and selling price amount) by complicated calculation, the burden on the person in charge can be reduced, calculation errors can be eliminated, and the efficiency of the slip preparation work can be improved.

If the value-added rate preset in the product classification file 30 is not used, the unit price of the purchased product is entered using the ten keys 91 and then the unit price key 94 is entered. Then, the selling price is calculated by multiplying the selling price by the quantity, and the selling price and the selling price are displayed in the selling price column and the selling price column, respectively.

Further, in the purchase slip creating apparatus of the present embodiment, when the value-adding rate setting operation is selected on the initial menu screen, the value-adding rate setting screen G1 is displayed. Enter the classification code for the classification. Then, the classification code and the classification name input in the areas A1 and A2 of the value-adding rate setting screen G1 are displayed, so the changed value-adding rate is entered and the unit selling price key is entered. By doing so, the value insertion rate corresponding to the input classification code in the product classification file 30 is automatically changed to the entered data. In this way, the value-adding rate set for each product category in the item-classifying file 30 can be corrected by a simple operation, so that even if the value-adding rate is changed, it can be promptly dealt with.

Further, in the case of correcting the price-adding rate, if the selling unit price key is input without inputting the changed price-adding rate after inputting the classification code, it corresponds to the input classification code in the commodity classification file 30. The value input rate is automatically changed to a fixed value input rate preset in the area 50 of the EEPROM 4. Therefore, by presetting a highly-priced value-adding rate as the fixed value-adding rate, the efficiency of the value-adding rate changing operation can be increased.

The present invention is not limited to the above embodiment. For example, in the above-described embodiment, the purchase slip is immediately printed and issued in the slip creation work, but a slip file is created in the hard disk device 7 and the purchase slip data created in the slip creation work is temporarily stored in the slip file. And then use the printer 13 when needed.
You may make it print out from.

Further, in the above embodiment, the purchase slip is issued for each supplier, but it may be issued for each product category instead of each supplier. In this case, the classification code column and the classification name column may be removed from the slip description area, and a supplier code column and a supplier name column may be provided instead.

Further, in the above-mentioned embodiment, the classification code for identifying the product group is shown as the code for specifying the product, but a single product code unique to each product may be used. In addition,
Needless to say, various modifications such as the structure of the supplier file 20 and the product classification file 30 and the format of the purchase slip can be implemented without departing from the scope of the present invention.

[0045]

As described in detail above, according to the present invention, a purchase slip for a purchased product can be automatically created only by inputting a code specifying the purchased product and the purchase cost. Therefore, it is possible to provide the purchase slip preparation device which can improve the efficiency of the purchase slip preparation work and reduce the burden on the purchaser.

[Brief description of drawings]

FIG. 1 is a block diagram of a main part of a purchase slip creating apparatus according to an embodiment of the present invention.

FIG. 2 is a configuration diagram of a supplier file provided in the purchase slip creating apparatus.

FIG. 3 is a configuration diagram of a product classification file provided in the purchase slip creation device.

FIG. 4 is a main key layout diagram of a keyboard provided in the purchase slip creating apparatus.

FIG. 5 is a view showing a main area of an EEPROM provided in the purchase slip creating apparatus.

FIG. 6 is a flowchart showing the processing of the CPU for the value-adding rate setting work of the purchase slip creating apparatus.

FIG. 7 is a configuration diagram of a value-adding rate setting screen displayed in the value-adding rate setting operation.

FIG. 8 is a view showing a list of value-added rates printed in the above-mentioned value-added rate setting work.

FIG. 9 is a flowchart showing the processing of the CPU for the slip creation work of the purchase slip creation device.

FIG. 10 is a configuration diagram of a slip creation screen displayed in the slip creation work.

FIG. 11 is a diagram showing a purchase slip printed in the slip creation work.

[Explanation of symbols]

 1 ... CPU 4 ... EEPROM 5 ... Clock part 7 ... Hard disk device 9 ... Keyboard 11 ... Display device 13 ... Printer 20 ... Supplier file 30 ... Merchandise classification file

Claims (1)

[Claims] 1. A purchase slip preparation apparatus for preparing a purchase slip in which the purchase cost, retail selling price, etc. of a purchased product are printed, wherein a coefficient for determining the retail selling price for the purchase cost is preliminarily set for each product code. A coefficient storage unit for setting and storing, an input means for inputting a purchased product code and the purchase cost, and a coefficient storage unit when the input product code and the purchase cost are input by this input device. The retail price from the coefficient reading means for reading the coefficient corresponding to the code of the purchased product, the coefficient read from the coefficient storage section by the reading means, and the purchase cost input by the input means. Retail selling price calculating means for calculating, and a printing means for printing the retail selling price calculated by the calculating means and the purchase cost input by the input means on a slip sheet. Purchase voucher creation device being characterized in that comprises a.