JP2001014554A - Stocking managing device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To update a stock file with the date on the day of information input and a credit purchase file with an optional date from the input of the same stocking information by updating the stock file on the basis of the date of the day of the information input of stocking information, the credit purchase file on the basis of the credit purchase account date when a credit purchase account date input exists, and the credit purchase file on the basis of the date of the day of stocking merchandise information input when an input does not exist. SOLUTION: When a determination button is subjected to a touch input (ST15), the last arrival date in the stock file record of stocking merchandise is updated into a processing date on the basis of the stocking information of inputted stocking merchandise. After that, whether or not credit purchase is selected as a settling method is discriminated, and when credit purchase is selected (ST17), a credit purchase file is updated on the basis of an account date displayed in an account date field on the basis of the stocking information of the inputted stocking information (ST18). Further, when the input of a credit purchase account date does not exist, the credit purchase file is updated on the basis of the date on the day being the account date in an initial state.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a purchase management device for storing and managing information on stock of each product and information on accounts payable to a supplier by inputting information on purchase in a retail store or the like.

[0002]

2. Description of the Related Art A conventional purchase management apparatus of this type stores and manages an inventory file for storing and managing the stock quantity, stock amount, etc. of each product, and the type, amount, etc. of the product purchased by the supplier from accounts payable. When information such as the type of purchased product, cost, and purchased quantity is input via the input means, the stock file and the payable file are updated on the date of the input of the information. Was.

[0003]

Since the stock of each commodity increases each time there is a purchase, the information on the purchase commodity is inputted through the input means on the day of the purchase, so that the information of the stock file is obtained. The inventory of each product can be accurately stored and managed.

However, the due date of payment of goods purchased from a supplier by accounts payable is often the next month or two months after the month when the purchase was made. Nevertheless, in the past, the accounts payable file was updated along with the inventory file on the date when the information on the purchased goods was entered, so the accounts payable file contains information on the payable goods whose due date is the next month or the next two months. It was stored and managed as information for the month of purchase. For this reason, when calculating the monthly payment amount to the supplier from the information in the accounts payable file, the person in charge must recognize the due date of the accounts payable product by himself and distribute the information on a monthly basis. And took time.

[0005] The present invention has been made in view of such circumstances, and the purpose is to update the stock file from the input of the same purchase information to the date of the information input on the day of the information input. It is an object of the present invention to provide a purchase management device capable of processing and updating a payable file on an arbitrary date.

[0006]

The invention according to claim 1 of the present application relates to an inventory file for storing and managing information relating to the stock of each product, a payable file for storing and managing information relating to a purchase to a supplier, and a purchase product. An input means for inputting information and an update means for updating the inventory file and the accounts payable file based on the information on the purchased goods input by the input means. Input means is provided. The updating means updates the stock file based on the date of the day when the information on the purchased goods is input by the input means, and the payable date is input by the input means to the payable file. In such a case, the information is updated on the basis of the accounts payable date, and if not, the information is updated based on the date on the day when the information on the purchased commodities is inputted by the input means.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. In FIG. 1, reference numeral 1 denotes a store computer functioning as a purchase management device of the present invention, and the store computer 1 has a CPU (Central Prism).
processing unit), a ROM (Read Only Memory), and the like.
s Memory), a clock unit 13 for measuring the current date and time, and a plurality of POSs (Point Of S) connected via a communication line 2 such as a LAN (Local Area Network).
ales) A communication interface 14 for controlling data communication with the terminal 3, a printer interface 15 to which a printer can be externally connected, a keyboard 16 mounted on the store computer 1, and a touch panel display 1
A key / display interface 18 having an interface function between the control unit 7 and the control unit 11 is connected.

The store computer 1 stores a product master file F1 in which product information such as a product name, a link section, a unit price, and a status is set and stored in advance in correspondence with a product code assigned to each product. A supplier master file F2 in which supplier information such as a supplier name, an address, a telephone number, etc. is set and stored in advance in correspondence with a supplier code assigned to each supplier, and information on stock of each product is stored and managed. Inventory file F3 to be stored, accounts payable file F4 for storing and managing information on accounts payable to suppliers
And the like are formed on a storage medium such as a hard disk, and the control unit 11 accesses these data files to write and read data.

FIG. 2 shows a record layout of the stock file F3. As shown in FIG.
3 is a store code, a product code, a color code, a size code, a final sales date, a final arrival date, a remaining quantity of the month, a sales quantity of the month, a purchase quantity of the month, a discarded quantity of the month, a remaining amount of the month, a sales amount of the month, a sales month of the month. It stores an inventory file record including items such as a disposal amount, a previous month's remaining amount, a previous month's sales amount, a previous month's purchase amount, a previous month's disposal amount, a previous month's remaining amount, a previous month's sales amount, and a previous month's disposal amount. Where the store code is
This is a unique code preset for the own store. The product code, the color code, and the size code are codes for specifying the type of the product managed in stock in the record. The last sale date is the last date when the product is registered for sale at the POS terminal 3. The final arrival date is the last date on which the product was purchased. The previous month's remaining quantity is the last month's inventory remaining quantity of the product, and the current month's sales quantity, current month's purchase quantity, and current month's discard quantity are the sales quantity, purchase quantity, and discard quantity of the product up to the current month. The previous month's remaining quantity is the inventory quantity of the product in the previous month, and the previous month's sales quantity, last month's purchase quantity, and last month's discard quantity are the last month's sales quantity, purchase quantity, and discard quantity of the product.

FIG. 3 shows a record layout of the payable file F4. As shown in FIG.
4 is position code, slip number, line number, store code, accounting date, supplier code, product code, color code,
A payable file record including items such as a size code, a case quantity, a loose quantity, an original unit price, a selling unit price, and a cost amount is stored. Here, the position code is a serial number on the accounts payable file 4 assigned to the record. The slip number is a slip number assigned to a purchase slip of a purchased product managed by accounts payable in the record. The line number is a number assigned to a detail line on which the details of the purchased product are printed in the purchase slip. The store code is a unique code preset for the store itself. The accounting date is the scheduled payment date of accounts payable for the purchased product (account accounting date). The supplier code is a code for specifying the supplier of the purchased product. The product code, color code, and size code are codes that specify the type of the purchased product. The case quantity and the bulk quantity are the purchase quantities of the purchased commodities. The original unit price, selling unit price and cost amount are the original unit price, selling unit price and cost amount of the purchased product.

When the execution of the purchase input operation is selected from the operation menu screen displayed on the touch panel display 17, the store computer having such a configuration switches the screen to the purchase input operation screen 40 of the format shown in FIG.
Here, when the registration button 41 in the touch button group displayed on the lower portion of the screen 40 is touched, the control unit 1
1 starts the registration process shown in the flowchart of FIG.

First, as ST (step) 1, the clock unit 1
3. Read the current date that is being timed in step 3
The current date (date of the day) is displayed in the processing date column and the accounting date column displayed on the second and the second lines. Screen 4
A new slip number is displayed in the slip number column 44 displayed in the third line on the upper right of 0. Further, a preset store code and a corresponding store name are displayed in the store code column displayed in the first line on the upper left of the screen 40. Next, a cursor (not shown) is displayed in the store code column as ST2,
Wait for store code to be entered. The input of the store code is optional. Here, when a store code is input from the keyboard 16, the store name is changed to a store name set in advance corresponding to the input store code.

Next, as ST3, the cursor is moved to the supplier code field displayed on the second line at the upper left of the screen 40, and the system waits for the input of the supplier code. The input of the supplier code is indispensable. Here, when the supplier code is input from the keyboard 16, the supplier name corresponding to the input supplier code is read out with reference to the supplier master file F2, and is displayed together with the input supplier code in the supplier code column. . Next, as ST4, screen 4
The user moves the cursor to the settlement condition column displayed in the upper left third line of 0, and waits for the settlement condition code (0: accounts payable, 1: bill settlement, 2: cash settlement) to be input. Note that input of a settlement condition code is also essential. Here, when any settlement condition code is input from the keyboard 16, the settlement condition code is displayed in the settlement condition column.

Next, in ST5, the cursor is moved to the processing date column displayed on the first line on the upper right of the screen 40, and the process waits for the input of the processing date. The input of the processing date is optional. Here, when the data of the processing date is input from the keyboard 16, the date in the processing date column is changed to the input date. Next, in ST6, the cursor is moved to the accounting date column displayed on the second line on the upper right of the screen 40, and the system waits for the input of the accounting date. The input of the accounting date is optional. Here, when the accounting date data is input from the keyboard 16, the date in the accounting date column is changed to the input date.

Next, in step ST7, the control waits for the commodity input button 42 in the touch button group to be touch-inputted.
When the product input button 42 is touch-input, S
At T8, the row number counter formed in the memory unit 12 is cleared to "0". Next, it waits for the input of the product code of the purchased product as ST9. Here, when a product code is input from the keyboard 16, the product file F1 is searched using the product code. Then, when it is confirmed that the product code exists in the product file F1, the product name set corresponding to the product code is read. Also, S
At T11, the line number counter is counted up by "1". Then, in ST12, the name of the product read from the product master file F1 is displayed together with the line number of the line number counter in the first line of the detail line column displayed in the center of the screen 40. Next, in step ST13, the process waits for input of other purchase information (color code, size code, case quantity, bulk quantity, original unit price, sale unit price, cost amount) for the purchased product, and the purchase information is input from the keyboard 16. Is selectively input, the purchase information is displayed on the same line in the detail line column.

Thereafter, in ST15, it is determined whether or not the enter button 43 of the touch button group is touch-input. When the touch input has not been performed and the product code of the next purchased product has been input, the processes of ST10 to ST14 are repeated. At this time, the line number, the product name, and other purchase information are displayed on the second line of the detail line column. Thereafter, every time the product code of the purchased product is input, the line number, the product name, and other purchasing information are sequentially displayed on the third and subsequent lines of the detail line column. Then, when the number of purchased commodities exceeds the number of lines in the detail line column, it is displayed on the purchase input business screen on the next page. Incidentally, the next page and the previous page can be switched by inputting the next page button 44 and the previous page button 45 of the touch button group.

When the enter button 43 is touch-input at ST15, the stock file F3 is stored in the processing date column based on the purchase information of the purchased commodity input at ST16. Update. Specifically, the last arrival date in the stock file record of the purchased product is updated to the processing date. Further, the purchase quantity and the purchase price for the current month are increased by the current purchase count and the purchase price ([stock file] updating means).

Thereafter, in ST17, it is determined whether or not the accounts payable is selected as the settlement method. If the payable has been selected, the payable file F4 is updated based on the accounting date displayed in the accounting date column, based on the purchase information of the purchased commodities input in ST18. Specifically, for each purchased product for which purchasing information has been input, the latest position code, a slip number on the purchasing input screen, a detailed line on which the purchasing information of the purchased product is displayed, and a store on the same screen Code, accounting date on the screen, supplier code on the screen, product code, color code, size code, case quantity,
A payable file record is created based on the number of pieces, the original unit price, the selling unit price, the cost amount, and the like, and is additionally stored in the payable file F4 ([payable file] updating means). Thus, the registration processing in the purchase input operation is completed.

When the correction button 46 of the touch button group is touched after the registration processing is completed, the processing for correcting the purchase information registered at this time is started. When the delete button 47 is touched, the process enters a process of deleting the purchase information registered this time. When the list button 48 is touched, the process enters a printout process of the purchase information registered this time. When the end button 49 is touch-input, the purchase input operation is ended.

In a store that has constructed the system of the present embodiment configured as described above, when a product is purchased, a purchaser selects a purchase input operation on the store computer 1 and executes a registration process. First, a supplier code is input. Next, a settlement condition is input. At this time, when the payable is selected as the settlement condition, the payment date of the payable is input as the accounting date.

Thereafter, the purchase information of the purchased goods from the same supplier is input one by one, and when the input is completed, the enter button 43 is pressed. Then, the stock file F3 is updated on the basis of the processing date, that is, the current date measured by the clock unit 13, based on the input purchase information of the purchased product, and the payable file F4 is updated based on the payable accounting date. Be updated. If the payable accounting date is not input, the payable file F4 is updated based on the initial accounting date, that is, the current date.

For example, as shown in FIG. 4, when the processing date (date of the day) is June 29, 1999, and the key account payable accounting date is July 5, 1999,
Inventory file F for purchased product "Men's Sweater"
The last stock date of the inventory file record No. 3 is updated on June 29, 1999. On the other hand, the accounts payable file record of the accounts payable file F4 for the purchased product “men's sweater” is stored and managed with the account payable date of July 5, 1999. Thus, the product “Men's Sweater” purchased on June 29, 1999 from the information in the accounts payable file F4 can be easily managed on the assumption that the payment will be made on July 5, 1999.

As described above, according to the present embodiment, in the registration processing of the purchased merchandise information in the purchasing input business,
Allows entry of accounts payable date. Then, the stock file F3 and the accounts payable file F4 are updated based on the input purchased product information. At this time, the inventory file F3 is updated based on the date of the day when the information on the purchased product is input. If the payable date is entered in the payable file F4, the date is updated based on the payable date, and if not, the date is based on the date when the information on the purchased goods is entered. And update it.

Accordingly, from the input of the same purchase information, the stock file F3 can be updated on the date of the information input, and the payable file F4 can be updated to any future date. It can be updated by date. As a result, there is an effect that it is possible to reduce the labor and time when calculating the monthly payment amount to the supplier from the information of the accounts payable file F4.

[0025]

As described above, according to the first aspect of the present invention, it is possible to update the stock file from the input of the same purchase information to the date of the input of the information. In addition, it is possible to provide a purchase management device that can update the accounts payable file on an arbitrary date.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a main configuration of an embodiment of the present invention.

FIG. 2 is a view showing a record layout of an inventory file in FIG. 1;

FIG. 3 is a view showing a record layout of a checkout file in FIG. 1;

FIG. 4 is an exemplary view showing an example of a purchase input business screen in the embodiment.

FIG. 5 is a flowchart showing a main part of a registration process executed by the control unit when a purchase input operation is selected in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Store computer 11 ... Control part 12 ... Memory part 13 ... Clock part 14 ... Communication interface 15 ... Printer interface 16 ... Keyboard 17 ... Touch panel display 18 ... Key / display interface F3 ... Stock file F4 ... Account file

Claims (1)

[Claims] 1. An inventory file for storing and managing information on stock of each product, a payable file for storing and managing information on purchases to suppliers, input means for inputting information on purchased goods, and input by the input means An updating unit for updating the stock file and the accounts payable file based on the information on the purchased commodities. The inventory file is updated based on the date of the day when the information on the purchased goods is input by the input unit, and the payable date is input by the input unit to the payable file. In this case, it is updated on the basis of the accounts payable date. Purchasing management system and to update based on the day date when the broadcast is input.