JP4010917B2 - Inventory management system at sales office and salary calculation system for sales staff belonging to sales office - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a system that uses a computer to perform management work in a sales office that performs consignment sales of merchandise.
[0002]
[Prior art]
As one of the sales forms of products and cosmetics, one or more sales offices are established separately from the product manufacturing company (head office) and the product sales company (sales company), and one or more sales staff belonging to this sales office. Has a form of selling products to customers.
[0003]
In the above sales form, the consignment sales form from the head office to the sales company is adopted, and the products sold by the sales staff are the property of the head office, rented from the head office to the sales office through the sales company, and further from the sales office Loaned to a salesperson. In addition, the products lent to the sales office may be sent to other sales offices depending on the situation. As described above, since the product is a loan from the head office to the sales office and the salesperson, the sales office needs to manage the product (inventory) borrowed from the head office.
In addition, the sales office manages sales of merchandise and payments for merchandise, and calculates salaries for sales staff.
[0004]
[Problems to be solved by the invention]
  The present invention relates to a computer system for supporting inventory management work in a sales office.TheThe issue is to provide.
[0005]
[Means for Solving the Problems]
  The present invention employs the following configuration in order to solve the above-described problems. That is, the present invention is a computer system that supports an inventory management operation in a sales office to which one or more sales staff belongs and sells products for which sales have been entrusted. Incoming product management section that manages inbound product information including at least each item indicating the number of products received as stockThen, the input screen of the received product information is displayed on a display device, and the received product record including the product name of the received product input by the input device through the input screen and the number of received products is created for each received product. An incoming product management unit for registering the incoming product record in a databaseAnd a lending product management unit that manages lending product information including at least each information indicating a product lent as inventory on hand from the shelf inventory to the affiliated salesperson, the number thereof, and the salesperson belonging to the lending destinationWhen the rental product information input screen is displayed on a display device, and the salesperson name and the product name are input by the input device through the input screen, the number of shelves in stock of the product with the product name Is displayed on the input screen, and when the lending number from the shelf stock is input by the input device, a new on-hand number obtained by adding the lending number from the shelf stock to the current on-hand inventory number is calculated, and a new A lending product record that includes the number of inventory items on hand and the product name, creates a lending product record for such a salesperson for each lending product, and registers the created lending product record in the database Product management departmentAnd a lending-back product management unit that manages lending-back product information including at least each information indicating the product returned from the on-hand inventory of the affiliated salesperson to the shelf inventory, the number thereof, and the affiliated salesperson of the lending destinationThe lending return product information input screen is displayed on a display device, and through this input screen the name of the salesperson to which the salesperson belongs,
When the product name and the loan back number are input, a new hand number is calculated by subtracting the loan back number from the current stock on hand, and the loan back product record including the product name and the new hand stock number A lending product management unit that creates a lending product record for each affiliated salesperson for each lending product and registers the created lending product record in the database.And the transferred product management section that manages the transferred product information including at least each information indicating the products to be transferred from the own sales office to other sales offices, the number of the products, and the sales office of the destination.When the transfer product information input screen is displayed on a display device, and the transfer source business name, the transfer destination business name, and the product name are input by the input device through the input screen, the product The current number of warehouses is displayed on the input screen as the number of transferable items, and when the number of transfers according to the number of transferable items is input from the input device, the product name including the product name, the number of transferable items, and the number of transferred items A transfer product management unit that creates a record, creates a transfer product record to the transfer destination sales office for each transfer product, and registers the generated transfer product record in the databaseAnd the transferred product management section that manages the transferred product information including at least each information indicating the products to be transferred from other sales offices to the self-sales office, the number of the products, and the sales office of the transfer source.When an input screen for the transferred product information is displayed on a display device, and the name of the transfer source business office, the name of the transfer destination business location, and the product name are input by the input device through the input screen, the product The current number of warehouses at the new sales office is displayed on the input screen, and when the number of transferred goods is input from the input device, a new current number of warehouses is calculated by adding the transferred number to the current number of warehouses. , Create a transfer product record that includes the product name, the new current number of warehouses, and the number of transfers, create a transfer product record for each transfer product, and create a transfer product record Transfer Product Management Department to registerAnd a return management unit that manages return information including at least information indicating the number of products returned from the sales office to the sales consignor or from the salesperson belonging to the sales office to the sales office. System.
[0007]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings. The configuration of the embodiment is an exemplification, and the configuration of the present invention is not limited to the configuration of the embodiment.
[0008]
<Outline of business>
FIG. 1 is a schematic explanatory diagram of a business management system of a sales office in the embodiment. As shown in FIG. 1, the sales office receives a product sales contract from the head office / sales company (hereinafter sometimes simply referred to as “head office” or “head office etc.”) and stores the products to be sold on the shelf. And sell the products in the shelf inventory. In addition, one or more salespersons belong to the sales office, and the salesperson borrows products from the shelf inventory of the sales office as hand-held inventory and performs door-to-door sales. In addition, the sales office transfers products in the shelf inventory to other sales offices, and receives products from the shelf inventory in other sales offices.
[0009]
The office management system is a stand-alone system used at each sales office, and manages products, money, sales, salespersons, etc., centered on the sales office. For this reason, the business management system manages inventory information, sales information, payment information, salesperson information, product information, and other information in a database. These pieces of information are related to each other. Note that this office management system may be used in a higher organization.
[0010]
《Offices that can use the office management system》
Basically, one PC (personal computer) is assigned to each sales office, and the business management system is realized on the PC. However, in jointly managed sales offices and joint base sales offices, a plurality of sales offices may share and use one PC. Here, the joint management business office is a form in which a plurality of business offices exist at one address, and the joint base business office is a form in which one inventory is shared by a plurality of business offices.
[0011]
<Outline of office management system>
The office management system is realized by using a computer such as a PC or a workstation. FIG. 2 is a schematic explanatory diagram of a computer that realizes the business management system. In FIG. 2, a computer 1 includes a processor device such as a CPU 2 connected to a bus B, a main memory (MM) 3, a communication control device (communication interface) such as a LAN card 4, and an auxiliary storage device (such as a hard disk). A magnetic storage device, an optical storage device, a magneto-optical storage device, a semiconductor memory) 5, an input device such as a keyboard 6 and a pointing device (a mouse 7 is illustrated in FIG. 2), a printer 8 and a display (CRT, LCD, An output device such as a plasma display 9) is connected.
[0012]
The CPU 2 loads at least various programs such as an operating system (OS) stored in the auxiliary storage 5 and an application program for realizing an office management system into the main memory 3 and executes them, so that at least the inventory management business-related Inventory management unit 11 that manages processing, sales management unit 12 that manages sales management business related processing, return management unit 13 that manages return management business related processing, payment management unit 14 that manages payment management business related processing, and settlement business management related processing It functions as a settlement management unit 15 and the like.
[0013]
The inventory management unit 11, the sales management unit 12, the return management unit 13, the payment management unit 14, and the payment management unit 15 provide a user interface (input / management screen) for the user to input information related to each management target. Information displayed on the display 9 and entered by the user (operator) via the keyboard 6 or the mouse 7 using the user interface is registered at a predetermined position in the database in association with the predetermined information. The inventory management unit 11, the sales management unit 12, the return management unit 13, the payment management unit 14, and the payment management unit 15 display the already-input information and history inquiry screen on the display 9, or print it out with the printer 8. Provide the function to do.
[0014]
A database 10 for storing various data and information used and managed in the office management system is constructed on the auxiliary storage device 5. The database 10 stores inventory information, sales (sales) information, payment information, salesperson information, product information, and other information. Inventory information, sales information, and payment information are generated by each process by the inventory management unit 11, the sales management unit 12, the return management unit 13, and the payment management unit 14, and are registered in the database. Salesperson information and product information are periodically downloaded from the host computer 22 or distribution server 23 via the gateway server 21 and the network, and those received by the communication control device 4 are registered in the database 10. Yes.
[0015]
The computer 1 is connected to a gateway server 21 via a network, and can communicate with a host computer 22 such as a head office or a distribution server for distributing information and programs via the gateway server 21. The computer 1 downloads an update program for the office management system, the latest product information, and salesperson information from the distribution server 23 via the gateway server 21. Further, the computer 1 can transfer report information such as sales results at the sales office to the host computer 22 via the network.
[0016]
《Work performed using the office management system》
The main business operations performed using the business management system are (1) inventory management business, (2) sales management business, (3) returns management business, (4) deposit management business, and (5) settlement management business. The business management system can perform independent processing for the above-described tasks (1) to (5). Hereinafter, the configuration of the office management system related to each business will be described individually.
[0017]
<Inventory management business>
FIG. 3 is a diagram for explaining the movement of products centered on sales offices. The goods move around the sales office by “arrival”, “return”, “transfer”, “transfer”, “lending”, “lending back”, and “cooling off”. The “arrival” occurs when the head office / sales company ships the product to the sales office and adds it to the shelf inventory of the sales office. “Return” occurs when the inventory at the sales office is returned to the head office / sales company. Returns occur for two reasons: the convenience of the sales office and the convenience of the head office / sales company. “Lending” occurs when lending goods to a salesperson from a shelf inventory at a sales office. The rented product becomes the inventory on hand of the salesperson. “Lending back” occurs when the salesperson returns the product borrowed from the sales office. At this time, the target product moves from the on-hand inventory to the shelf inventory. “Transfer” occurs when a product is transferred from another sales office. “Moving out” occurs when a product in the shelf stock is transferred to another sales office. “Cooling off” occurs when a product is returned from a customer through a cooling off system. The business management system manages the flow of products shown in FIG. 3 as inventory management business related processing.
[0018]
FIG. 4 is a diagram showing a display example of the main menu screen of the business management system. The main menu screen is a user interface that is displayed on the display 9 when the CPU 2 executes a program of the business management system by the operation of the computer 1 by the user. In addition, each screen shown in the following description is also a user interface displayed on the display 9 by execution of a program by the CPU 2 in accordance with a user operation.
[0019]
In FIG. 4, the main menu screen includes an input / display field for a business office code and a business office name, “inventory management”, “sales management”, “return management”, “payment management”, “NO & month-end report”, “ It has a plurality of menu buttons respectively corresponding to “checkout management”, “monthly management”, “various settings”, “auxiliary management”, “inquiry / tabulation”, and “head office data reception”. When a button corresponding to inventory management is pressed, an inventory management screen as shown in FIG. 5 is displayed.
[0020]
FIG. 5 is a diagram illustrating a display example of the inventory management screen. The inventory management screen has an input / display field for sales office codes and sales office names, a plurality of registration related buttons, and a plurality of inquiry / print related buttons. As registration-related buttons, there are multiple buttons corresponding to "Incoming registration", "Transfer registration", "Transfer registration", "Lending / Lending return registration", "Total return registration", and "Inventory correction". As the inquiry / print related buttons, buttons corresponding to “incoming history inquiry / tabulation”, “transfer / ingress history inquiry / tabulation”, and “lending history inquiry / tabulation” are prepared.
[0021]
When a button corresponding to arrival registration is pressed on the inventory management screen, an arrival registration screen as shown in FIG. 6 is displayed. FIG. 6 is a diagram illustrating a display example of the arrival registration screen. The arrival registration screen is a screen for registering information on products received from the head office / sales company in the month. The arrival registration screen has an entry field for registration classification and registration date, and an entry field for a product number, a product name, and the number of arrivals. The arrival registration screen further includes a display column for a record (arrival product record) having the product number, the product name, and the number of arrivals as fields, and one or more arrival product records are displayed. In addition, the total number of arrivals is calculated and displayed. The input registration screen has an end button, and before the end button is pressed, a received product record for a plurality of products to be received can be input. When the end button is pressed, the received commodity record input so far is registered.
[0022]
The procedure for registering an incoming product using the arrival registration screen is as follows. That is, the operator of the business management system displays the arrival registration screen and enters the registration category and the registration date in the corresponding entry fields. Subsequently, the operator inputs the product number, the product name, and the number of products related to the product to be received in the corresponding entry fields. Then, a received product record having the input product number, product name, and number of products received as fields is displayed in the display column. At this time, the operator can input a product number or the like for the next product to be received by pressing the next product button. On the other hand, when the received product record displayed in the display column is selected and the delete one line button is pressed, the selected received product record is deleted. Further, when the cancel all button is pressed, all the received commodity records displayed in the display column are deleted. The operator creates an incoming merchandise record for all the incoming merchandise by the above operation. At this time, every time an incoming commodity record is created, the total value of the number of arrivals is automatically calculated and displayed in the total value display column provided in the vicinity of the display column. When the operator has created all the received commodity records, the operator presses the end button. Then, all the received commodity records displayed in the display column and the total value of the number of arrivals are registered in the database 10 as the received commodity information in the inventory information.
[0023]
Returning to FIG. 5, when a button corresponding to the transfer registration is pressed on the inventory management screen, a transfer registration screen as shown in FIG. 7 is displayed. FIG. 7 is a diagram illustrating a display example of the transfer registration screen. The transfer registration screen has a registration field, a transfer date entry field, a transfer source business code, a transfer source business office name, a transfer destination business office code, and a transfer destination business office name input field, a product number, and a product. Has a column for entering the name, current stock quantity, and number of transfers, and a column for displaying the product record (transfer product record) with the product number, product name, number of transfers possible, and the number of transfers as fields. Yes.
[0024]
The procedure for registering a transfer product using the transfer registration screen is as follows. That is, the operator of the business management system displays the transfer registration screen and enters the registration category and the transfer date in the corresponding entry fields. Subsequently, the operator inputs the transfer source sales office code, the transfer source sales office name, the transfer destination sales office code, and the transfer destination sales office name related to the product to be transferred into the corresponding entry fields. Further, the operator inputs a product number and a product name to be transferred. Then, the transferable number of products corresponding to the product number and / or product name is automatically input in the corresponding column. The maximum number of possible transfers is the current number of warehouses. The operator can input the number of transfers, with the maximum number of transfers possible. Then, a transfer product record whose fields are the input product number, product name, transferable number, and transfer number is displayed in the display column. At this time, as the transferable number of records, a value obtained by subtracting the number of transfers from the transferable number input in the input field is automatically calculated and displayed. Thereafter, the operator can input a product number or the like (field information of the record) for the next product to be transferred by pressing the next product button. On the other hand, when the moving-out merchandise record displayed in the display column is selected and the delete one line button is pressed, the selected moving-out merchandise record is deleted. Further, when the cancel all button is pressed, all the transferred product records displayed in the display column are deleted. The operator creates an incoming merchandise record for all the merchandise to be transferred by the above operation. At this time, every time a transfer merchandise record is created, the total value of the number of transfers in the record is automatically calculated and displayed in the total value display field provided near the record display field. In addition, the total number of possible transfers in the record is displayed in the corresponding display column. When the operator has created all the transferred product records, the operator presses the end button. Then, all the transferred product records displayed in the display column, the total value of transferable numbers, and the total value of the transferred numbers are registered in the database 10 as transferred product information in the inventory information.
[0025]
Returning to FIG. 5, when the button corresponding to the transfer registration is pressed on the inventory management screen, the transfer registration screen is displayed. FIG. 8 is a diagram illustrating a display example of the transfer registration screen. The transfer registration screen includes a registration field, a transfer date entry field, a transfer source business code, a transfer source business office name, a transfer destination business office code, and a transfer destination business office name input field, a product number, and a product. An entry field for the name, current number of warehouses, and number of transfers, and a display field for a product record (referred to as a “transfer product record”) with the product number, product name, current warehouse, and number of transfers as fields. Have. Here, the current number of warehouses is the total of the number of shelves in stock and the number of inventory on hand.
[0026]
The procedure for registering the transferred product using the transfer registration screen is as follows. That is, the operator of the business management system displays the transfer registration screen and enters the registration category and the transfer date in the corresponding entry fields. Subsequently, the operator inputs the transfer source sales office code, the transfer source sales office name, the transfer destination sales office code, and the transfer destination sales office name related to the product to be transferred into the corresponding entry fields. Further, the operator inputs a product number and a product name to be transferred. Then, the current number of products corresponding to the product number and / or product name is automatically entered in the corresponding column. At the same time or subsequently, the operator can enter the number of transfers of the transferred product in the corresponding column. Then, a transfer product record having the input product number, product name, current number of warehouses, and transfer count as fields is displayed in the display column. At this time, as the current number of warehouses in the record, a value obtained by adding the transferred number to the current warehouse number entered in the entry field is automatically calculated and displayed. Thereafter, the operator can input a product number or the like (field information of the transferred product record) for the next product to be transferred by pressing the button for the next product. On the other hand, when the transferred product record displayed in the display column is selected and the delete one line button is pressed, the selected transferred product record is deleted. Further, when the cancel all button is pressed, all the transferred product records displayed in the display column are deleted. The operator creates a transfer product record for all the products to be transferred through the above operation. At this time, each time a transferred product record is created, the total value of the number of transfers in the transferred product record is automatically calculated and displayed in the display column of the total value provided near the display column. Further, the total value of the current number of warehouses in the transferred product record is automatically calculated and displayed in the corresponding display column. When the operator has created all the transfer product records, the operator presses the end button. Then, all the transferred product records displayed in the display column, the total value of the current warehouse, and the total value of the number of transferred items are registered in the database 10 as the transferred product information in the inventory information.
[0027]
Returning to FIG. 5, when a button corresponding to lending / lending back registration is pressed on the inventory management screen, a lending / lending back registration screen is displayed. FIG. 9 is a diagram illustrating a display example of a lending / lending return registration screen. On the lending / lending back registration screen, the fields for entering the ready code (salesperson code) and ready name (salesperson name), registration category, lending category (separate lending / lending back), and entry date of registration And an entry column for product number, product name, current number of warehouses, and number of loan / lending back, and record of the product with the field of product number, product name, and number on hand (referred to as "lending / lending back product record") ) Display column.
[0028]
The procedure for registering a transfer product to be lent / lending back using the lending / lending back registration screen is as follows. That is, the operator of the business management system displays the lending / lending return registration screen and enters the salesperson code and the salesperson name in the corresponding entry fields. Subsequently, the operator inputs a registration category, a rental category, and a registration date in the corresponding entry fields. Depending on the lending classification input at this time, the products specified by the following procedure are divided into products to be lent and products to be lent back. Subsequently, the operator inputs the product number and the product name of the product to be lent or loaned back into the corresponding input fields. Then, the number of shelves in stock of the corresponding product is automatically entered in the corresponding entry field. At the same time or subsequently, the number of loans or the number of loans returned is input. That is, when the lending classification is lending, the number of products input is the number of lending, and when the lending classification is lending back, the number of the goods input is the number of lending back from hand inventory. Then, a record having the product number, the product name, and the number on hand as fields is displayed in the display column. At this time, if the lending category is lending, the value of the current inventory of the product plus the number of lending is displayed as the number of on-hand items in the record. The value obtained by subtracting the number of loan backs from the stock on hand is displayed. Thereafter, the operator can input a product number or the like (field information of the record) for the next product to be lent / lending back by pressing the next product button. On the other hand, when the lending / lending back product record displayed in the display column is selected and the delete one line button is pressed, the selected lending / lending back product record is deleted. When the cancel all button is pressed, all the lending / lending return product records displayed in the display column are deleted. The operator creates a lending / lending-back product record for all the products to be lent / lending back through the above operation. At this time, every time a lending / lending-back product record is created, the total value of the number on hand is automatically calculated and displayed in the total value display column provided in the vicinity of the display column. In addition, the total amount of the price of the on-hand inventory is automatically calculated and displayed in the corresponding display column. When the operator has created all the lending / lending back merchandise records, the operator presses the end button. Then, all the lending / lending-back merchandise records displayed in the record display column, the total number of items on hand, and the total value of the amount are registered in the database 10 as lending / lending-back merchandise information in the inventory information.
[0029]
The operator can transition from the inventory management screen to an inventory correction screen (not shown) by pressing the “stock correction” button on the inventory management screen shown in FIG. It is possible to correct the current number of registered warehouses in that month.
In addition, the operator uses the screen (not shown) displayed by pressing the inquiry / print related button on the inventory management screen shown in FIG. 5 to refer to the display history, transfer history, and loan history (display). If necessary, it can be printed using a printer.
[0030]
The display control of information on each screen related to the inventory management work described above, numerical calculation, registration processing of records, etc. are performed by the inventory management unit 11 shown in FIG. By inventory management business-related processing, as inventory information at the sales office, the product corresponding to the shelf inventory and its number, the product lent to the salesperson as on-hand inventory and the number, the arrival, transfer, transfer, lending / lending History information on the movement of products can be stored in the database 10 and can be referred to or printed as necessary.
[0031]
There are two types of inventory information: daily inventory information and inventory information at the end of the previous month. When these stock information is taken into the business management system, all previous information is discarded and only the latest state is retained. For this reason, there is no linkage with the monthly determination process (described later).
[0032]
<Sales management business>
FIG. 10 is an explanatory diagram of the sales management business. The product to be sold at the sales office is a product (hand-held inventory) borrowed from the sales office by the salesperson or a product in the shelf inventory of the sales office. A salesperson sells a product in stock on hand (hand-held sale) or sells a product in shelf stock (shelf sale) at the request of a customer, and the salesperson receives the price of the sold product .
[0033]
It is the sales management business that manages which products from which stocks, which sales people, how much, to which customers, and the administrative management system is responsible for sales management business related processing. This process is governed. Some products are not in stock (for example, ordering after receiving an order, beauty treatment, sales at a venue, etc.).
[0034]
The sales management business-related process can be performed using a sales management screen that transitions by pressing a sales management button from the main menu screen shown in FIG. FIG. 11 is a diagram illustrating a display example of the sales management screen. In FIG. 11, the sales management screen has an entry / display field for sales office codes and sales office names, sales function registration related buttons, other function buttons, and inquiry / print related buttons. As registration-related buttons, buttons corresponding to “cosmetics & diversified sales registration” and “SP product sales registration” are provided. As buttons for other functions, buttons corresponding to “accompanying sales registration” and “esthetic fee registration” are prepared. In addition, a “sales history inquiry / tabulation” button is prepared as an inquiry / print related button.
[0035]
The “Cosmetics & Diversified Sales Registration” button is a button for registering sales of cosmetics as a product. When this button is pressed, the screen changes to the cosmetics & diversified sales registration screen. FIG. 12 is a diagram showing a display example of a cosmetic and diversified sales registration screen (hereinafter simply referred to as “sales registration screen”). In FIG. 12, the sales registration screen includes a salesperson code (ready code), salesperson name (ready name) entry field, registration category, registration date and slip number input fields, business selection, product number, Product name, unit price, number of sales, sales amount, percentage of remaining stock, shelf inventory remaining, recording month, measure addition, entry column for each item, next product, end, delete one line, cancel all buttons have. In addition, the sales registration screen displays a record for each product ("", business number, product name, unit price, number of sales, sales amount, hand sales, shelf sales, commission rate, recording month, measure addition, and slip number as fields. A display field for displaying "sales record". Further, the sales registration screen has columns for displaying the breakdown of the slip and the breakdown of the current month.
[0036]
The product registration procedure using the sales registration screen is as follows. That is, the operator of the business management system displays the sales registration screen and enters the salesperson code and salesperson name in the corresponding entry fields. Subsequently, the operator inputs the registration category and the registration date in the corresponding entry fields. The operator selects and inputs the slip number by pressing a selection button provided near the slip number. Next, the operator selects and inputs the business and product number, and then selects the unit price, number of sales, sales amount, commission rate, remaining inventory, shelf inventory remaining, recording month, measure addition, and banknote as necessary. input. Then, the sales record corresponding to the input content is displayed in the display column of the sales record. Thereafter, the operator can input a product number or the like (field information of the sales record) for the next sales product by pressing the button of the next product. On the other hand, when the sales merchandise record displayed in the display column is selected and the delete one line button is pressed, the selected sales record is deleted. When the cancel all button is pressed, all the sales records displayed in the display column are deleted. The operator creates sales records for all the products to be sold through the above operation. At this time, every time a sales record is created, the total value of the number on hand is automatically calculated and displayed in the total value display field provided in the vicinity of the display field. In addition, the total amount of the price of the on-hand inventory is automatically calculated and displayed in the corresponding display column.
[0037]
In the breakdown column of this slip, the number of sales and the sales amount for each product type such as cosmetics, cases, diversification, and BF, and the total value of sales and the total value of sales are displayed. In the current month breakdown column, the number of sales and the sales amount for each product type such as cosmetics, cases, diversification, and BF, and the total value and the total value of the sales amount are displayed. When the operator creates all sales records, the operator presses the end button. Then, all the sales records displayed in the sales record display column, the contents of this slip breakdown, and the contents of the current month breakdown are registered in the database 10 as sales information.
[0038]
In the sales management screen shown in FIG. 11, the corresponding screen (not shown) is called by pressing the “SP product sales registration”, “accompanying sales registration”, and “esthetic fee registration” buttons. Can be used for sales, sales or price registration. In addition, by pressing a “sales history inquiry / tabulation” button, a corresponding screen (not shown) can be called to inquire about the history.
[0039]
The above-described display control of information on each screen related to sales management business, numerical calculation, registration processing of records, etc. are performed by the sales management unit 12 shown in FIG. 2 as sales management business related processing. The sales management business related process generates sales records for the salesperson for that month, and each sales record is registered in the database 10 as a slip.
[0040]
<Returns management business>
FIG. 13 is an explanatory diagram of returned goods management work. Returns include head office / sales company-sales office returns and customer-sales office returns. The sales office returns merchandise in unnecessary inventory to the head office / sales company, or returns inventory in accordance with instructions from the head office / sales company (honpo instruction / base instruction). In addition, the sales office may accept the return of the product from the customer (customer return). Merchandise related to customer return is sent to the appropriate place depending on the content. In addition, the sales office may accept the return of goods through a cooling-off system. The product returned by the cooling-off becomes a product that can be sold again as a shelf inventory.
[0041]
The return management business manages the flow of products generated by the above-mentioned returns, and the office work management system manages the flow of products to be returned as a return management business related process. The returned goods management business related process can be performed using the returned goods management screen which is changed by pressing the returned goods management button from the main menu screen shown in FIG. FIG. 14 is a diagram illustrating a display example of the return management screen. In FIG. 14, the returned goods management screen has an entry / display field for an office code and an office name, a registration related button, and an inquiry / print related button. As registration-related buttons, a “returned goods registration (real finger / unnecessary / base)” button and a “returned goods registration (cooling / customer)” button are provided. Further, as a reference / print related button, a “returned goods history inquiry / tabulation” button is provided.
[0042]
When the “return registration (real finger / unnecessary / base)” button is pressed on the return management screen, the return registration (real finger / unnecessary / base) screen (“first return”) for that month as shown in FIG. A registration screen ”). The first return registration screen includes a registration field and a return date entry field, a product number, a product name, the number of returns, and a return purpose entry field, and “next product”, “end”, “one line” Each button includes “delete” and “cancel all” buttons, and a display column for a record (return record) having a product number, a product name, the number of returns, and a return purpose as fields.
[0043]
The operator registers information related to the target product using the first return registration screen when a return by the main office instruction, a base instruction, or a return of unnecessary stock at the sales office occurs. That is, the operator uses the first return registration screen to input the registration category and the return date. Next, the operator enters the product number, the product name, and the number of returns, and further selects the purpose of return from “honpo directed return”, “unnecessary inventory return”, and “site directed return”. Then, a record (referred to as “first return record”) in which the input or selected product number, product name, return number, and return purpose are fields is displayed in the display column. At this time, if the next product button is pressed, the field information of the record such as the product number can be input for the next product to be returned. Further, when one of the first return records displayed in the display column is selected and the button for deleting one line is pressed, the first return record can be deleted. Furthermore, when the cancel all button is pressed, all the first return records displayed in the display field can be deleted. Further, every time the first return record is displayed in the display field, the total value of the number of returns included in the displayed first return record is calculated, and the total provided in the vicinity of the display field of the first return record. Displayed in the value display column. Then, when the operator finishes creating the first return record for all return target products, the operator presses the end button. When the end button is pressed, all the first return records displayed in the display column of the first return record and the total value of the return numbers are registered in the database 10 as the return information in the inventory information.
[0044]
In addition, when the “returned goods registration (cooling / customer)” button is pressed on the returned goods management screen shown in FIG. 14, the returned goods registration (cooling / customer) screen (“ "Second return registration screen") is displayed. The second return registration screen has a column for salesperson code (ready code) and salesperson name (ready name), and a registration section, registration date, slip number, and a section, business selection, and product number. , Product name, unit price, number of returns, return amount, percentage of commission, remaining inventory, remaining shelf, target month, return destination, and “next product”, “end”, “delete one line”, “all "Cancel" button and display of record (referred to as "second return record") with field of classification, business, product number, product name, unit price, number of returns, return amount, commission rate, return destination, slip number Column.
[0045]
When the return from the customer of the customer or the return based on the cooling-off system occurs, the operator registers information related to the target product using the second return registration screen. That is, the operator inputs a salesperson code and a ready name using the second return registration screen. Subsequently, a registration category, a return date, and a slip number are selected and input. Next, the operator fills in the classification, business selection, product number, product name, unit price, number of returns, return amount, commission rate, remaining on hand, remaining shelf, target month, and return destination. Then, the second return record corresponding to the input information is displayed in the display field. At this time, when the operator presses the next product button, the field of the second return record such as the product number can be input for the next product to be returned. Further, when one of the second return records displayed in the display column is selected and the button for deleting one line is pressed, the second return record can be deleted. Furthermore, when the cancel all button is pressed, all the second return records displayed in the display field can be deleted. Then, when the operator finishes creating the second return record for all products to be returned, the operator presses the end button. When the end button is pressed, all the second return records displayed in the display column of the second return record are registered in the database 10 as the return information in the inventory information.
[0046]
When the operator presses the return history inquiry / tabulation button on the return registration screen shown in FIG. 14, the operator can proceed to the screen for inquiring / displaying the return history. The history can be inquired and displayed.
[0047]
The above-described display control of information on each screen related to the return management business, numerical calculation, and record registration processing are performed by the return management unit 13 shown in FIG. 2 as the return management business related processing. The first and second return records for the month are generated and registered in the database 10 by the returned goods management business related process.
[0048]
<Payment management business>
The customer pays for the product when purchasing the product. There are three types of payment (payment from the sales office): cash payment, credit, and individual item installment. When the sales office sells the product to the customer, the sales office allows the customer to select a payment form from the above three types.
[0049]
FIG. 17 is a schematic explanatory diagram of the deposit management business. As shown in FIG. 17, when the customer pays the price with cash, the cash is handed to the salesperson, and the salesperson stores the cash at the sales office. On the other hand, when the customer selects payment by credit or individual item installment, the customer applies for a credit or individual item installment to the credit company, and the salesperson bears the fee. The credit company pays cash to the sales office.
[0050]
The business for managing how much and in what form the customer has received the money is the money management business, and the office work management system manages the processing related to the above money management business as the money management business related processing.
[0051]
The payment management business related process can be performed using a payment management screen that is transitioned by pressing a return management button from the main menu screen shown in FIG. FIG. 18 is a diagram showing a display example of the deposit management screen. In FIG. 18, the deposit management screen has an entry / display field for an office code and an office name, a registration related button, and an inquiry / print related button. As registration-related buttons, a “payment registration” button and a “payment registration at payment” button are provided. In addition, as the inquiry / print related buttons, there are buttons for “Payment history inquiry / tabulation”, “Sales receipt table inquiry / tabulation / day”, “Sales receipt table inquiry / tabulation / cumulative”, “Credit status inquiry”. Is provided.
[0052]
When the “deposit registration” button is pressed on the deposit management screen, a deposit registration screen for that month as shown in FIG. 19 is displayed. The payment registration screen includes a salesperson code (ready code) and salesperson name (ready name) entry field, registration category, registration date entry field, payment type, payment target month, payment amount, business selection, New / Re, credit type, credit company, credit fee fields, “Next”, “End”, “Delete one line”, “Cancel all” buttons, and payment type (cash / credit / piece) And a display column for a record (referred to as a “receipt record”) with fields for the deposit target month, deposit amount, business selection, new / month, credit type, credit company, and credit fee. Yes.
[0053]
When it is necessary to register payment for a certain product, the operator registers information related to the target product using the payment registration screen. That is, the operator inputs a salesperson code and a salesperson name using the deposit registration screen. Subsequently, the operator inputs a registration category and a return date. Next, the operator enters or selects a payment type, a deposit target month, a deposit amount, a business selection, a new / month, a credit type, a credit company, and a credit fee. Then, a receipt record having fields of the entered or selected deposit type, deposit target month, deposit amount, business selection, new / month, credit type, credit company, and credit fee is displayed in the display column. At this time, when the “next” button is pressed, a field of a receipt record such as a product number can be entered for the next product to be deposited. Further, when one of the deposit records displayed in the display column is selected and the delete one line button is pressed, the deposit record can be deleted. Furthermore, when the cancel all button is pressed, all the deposit records displayed in the display field can be deleted. In addition, every time a receipt record is displayed in the display column, depending on the contents of each receipt record displayed in the display column, the sales (incidence amount), consumption tax, total value, cash payment amount, credit payment on the day And the amount of individual installment payments are calculated and displayed in the appropriate fields. In addition, when the “Calculate Current Month” button on the payment registration screen is clicked, sales (payment amount), consumption tax amount, total value, cash payment amount, credit payment amount, individual installment payment amount The cumulative amount for the current month is calculated and displayed in the appropriate column. Then, when the operator finishes creating the deposit record for all the products to be deposited, the operator presses the end button. When the end button is pressed, all the deposit records displayed in the deposit record display column and the record of the sales on the day are registered in the database.
[0054]
In addition, on the deposit management screen shown in FIG. 18, when a button for deposit at the time of settlement, deposit history query / tabulation, credit status query, or the like is pressed, a corresponding screen is displayed. Using the displayed screen, the operator can perform payment registration at the time of payment, inquiry / tabulation of payment history for each day or each salesperson, credit status inquiry, and the like.
[0055]
The above-described information display control, numerical calculation, and receipt record registration processing for each screen related to the receipt management operation are performed by the receipt management unit 14 shown in FIG. 2 as receipt management operation related processing.
[0056]
<Checkout management>
The sales office calculates the salary payment amount to the salesperson at the end of each month. In the calculation, there are a plurality of adjustment parameters such as an amount, a commission, an additional payment amount, and the like. For this reason, maintenance of such information (adjustment parameters) is also required. This work is the settlement management business.
[0057]
FIG. 20 is a diagram showing an outline of the settlement management business. As shown in FIG. 20, sales information, payment information, and salesperson information are edited by processes such as the above-described sales registration related process and payment registration related process. Business information, product information, credit information, and consumption tax information are edited by the above-described sales management, payment management, and the like. Then, settlement processing is performed using sales information, payment information, salesperson information, business information, product information, credit information, consumption tax information, etc., and salesperson salary information for that month is generated.
[0058]
A specific settlement process is performed as follows. When the settlement management button provided on the main menu screen shown in FIG. 4 is pressed, a settlement management screen as shown in FIG. 21 is displayed. The settlement management screen has a column for entering a business office code and a business office name, a commission calculation related button, a settlement registration related button, and a settlement report print button. As a button related to checkout registration, a “fee calculation / all salesperson (ready)” button (referred to as “first fee calculation button”) and a “fee calculation / salesperson (ready) unit” button (“second "Fee settlement button") is provided, and a column for entering a salesperson code and salesperson name is provided for identifying a salesperson subject to calculation of a commission for each salesperson. In addition, as a payment registration related button, buttons for “accounting details registration” and “payment registration at the time of payment” are prepared. In addition, as a settlement report print button, “personal statement print” and “payment ledger print” buttons are prepared.
[0059]
When the first fee calculation button is pressed on the checkout management screen, the sales fees (percentage amounts) of all salespersons belonging to the sales office are calculated for the sales of the product. For each salesperson, the commission rate when the product is sold is determined in advance, and the sales commission is calculated by multiplying the sales amount of the product by the commission rate. At this time, the fee may be calculated for sales for each type of product. In this way, when the first fee calculation button is pressed, the sales fees for all salespeople are calculated. On the other hand, when calculating the commission of a salesperson, enter the salesperson's salesperson code and salesperson name in the corresponding input fields and press the second fee calculation button to enter the desired salesperson's commission. Is calculated.
[0060]
When the “Settlement statement registration” button is pressed on the settlement management screen, a settlement statement registration screen for that month as shown in FIG. 22 is displayed. The payment statement registration screen is a screen for registering salesperson salary information for that month, and has multiple fields for entering salesperson salary, that is, information for calculating the payment amount (detailed information). is doing. Specifically, the payment statement registration screen has the following screen configuration.
[0061]
The payment statement registration screen displays the salesperson code (ready code) and salesperson name (ready name) fields to identify the salesperson to whom the salary is paid, and the basic commission rate assigned to that salesperson. Display column. In the vicinity of the salesperson code, a “ready (salesperson) selection” button is provided, and the operator selects the corresponding salesperson code from the salesperson code list displayed by pressing this button. . Then, the selected salesperson code is displayed in the salesperson code entry field, the salesperson name registered in the database in association with this salesperson code, and the salesperson name registered in advance (in advance). The basic commission rate (provided) is displayed in the corresponding display field.
[0062]
In addition, the payment statement registration screen has a display column for displaying the sales amount for each type of product registered in the sales management related process, and a display column for displaying the sales commission calculated for each item. . In this example, “ordinary cosmetics”, “case”, “25% discount”, “eco road”, “SP”, etc. are prepared as the types of products. In addition, there is a display column for consumption tax according to sales, as well as a subtotal, total sales, total consumption tax, and a total display column that combines sales and consumption tax. The amount to be displayed is displayed. The sales amount, subtotal, consumption tax, and grand total for each product type are associated with the sales record (salesperson code and / or salesperson identification information of the salesperson name) registered in the sales management related processing. ) To extract necessary fields (sales amount, consumption tax amount, etc. in a month) and automatically display them in the corresponding display column. Further, the subtotal and each total amount are automatically calculated and displayed by adding the field information extracted from the sales record.
[0063]
In addition, the settlement statement registration screen is provided with a column for inputting / displaying various types of information relating to the payment amount. In this example, there are columns for displaying the amount equivalent to other allowances, guarantee allowances (fixed salary), head office prizes, sales company prizes, and policy additions, and the sum of these allowances. A display column is provided for the consumption tax as a total of the corresponding consumption tax, and the total sum of the salary and consumption tax. The amount of each allowance is extracted from the salesperson information previously managed in association with the salesperson's identification information in the office management system and displayed in the corresponding column.
[0064]
In addition, the settlement details registration screen is provided with a column for inputting and displaying various information related to the deduction amount. In this example, input / display fields such as withholding tax amount, provisional payment amount, credit fee amount, individual item installment fee amount, medical mutual aid amount, optional reserve amount, etc. are provided. As for the amount of temporary payment, credit fee and individual item installment fee, the corresponding field information is extracted from the receipt record (associated with the salesperson's identification information) registered in the process related to receipt management business, and the total amount Is calculated and displayed in the corresponding column. In addition, the amount of medical mutual aid and optional accumulation is extracted from salesperson information managed by the office management system and displayed in the corresponding column. Furthermore, a display column for the total amount of deductions is provided, and the sum of the amounts displayed in each item of the deduction amount such as withholding tax and temporary payment is calculated and displayed in the display column for the total amount. The amount of withholding tax can be obtained by pressing a “withholding tax calculation” button provided on the screen.
[0065]
In addition, the payment statement registration screen has a column for displaying the total amount of cash deposit, credit deposit, and deposit, and field information corresponding to the deposit record for the current month registered in association with the salesperson's identification information Are extracted and the total amount is calculated and displayed in the corresponding column.
[0066]
Further, the settlement details registration screen has a display column for the amount of money received during settlement. The payment amount displayed in this column is displayed by pressing the payment registration button on the payment management screen shown in FIG. 21, and using the payment registration screen for the month as shown in FIG. The payment amount registered at the time of payment is displayed.
[0067]
In FIG. 23, the payment registration screen at the time of payment includes an entry field for a salesperson code and a salesperson name, and an input field for the payment required amount and the payment amount at the time of payment. When a salesperson code and salesperson name are entered on the payment registration screen, the payment required amount stored in the database in association with at least one of these is automatically entered in the corresponding input field. At the same time, the amount of money that has been deposited at that time (stored in the database 10 in association with at least one of the salesperson code and the salesperson name) is automatically displayed in the input field for the amount of payment. The amount required for payment at the time of checkout is the amount that the salesperson has to pay at the time of checkout. At this time, if the deposit amount is less than the deposit amount required for settlement, the amount entered in the deposit amount input field can be increased (the deposit procedure for the increment is performed separately). When the salesperson's code, salesperson name, and the corresponding payment required amount and payment amount are entered on the payment registration screen, the salesperson code, salesperson name, payment required amount, and payment A record having the amount as a field (referred to as a “payment deposit record”) is generated and displayed in the settlement deposit record display field provided on the settlement deposit registration screen. Here, the payment registration screen includes buttons for “next lady (salesperson)”, “end”, “delete one line”, “cancel all”, and “next salesperson”. When the button is pressed, the salesperson code and salesperson name of the salesperson corresponding to the next salesperson are displayed in the corresponding display column. In addition, when one of the records displayed in the display column of the payment record at the time of settlement is selected and the “Delete one line” button is pressed, the selected record is deleted. When the “cancel all” button is pressed, all the records displayed in the record display column at that time are deleted. When the “end” button is pressed, the payment record at the time of settlement displayed in the display column at that time is registered in the database 10. On the settlement details registration screen shown in FIG. 22, an amount corresponding to the deposit amount in the deposit record at the settlement is displayed in the corresponding column as the deposit amount at the settlement.
[0068]
Returning to FIG. 22, when the guaranteed payment of the salesperson's salary is requested on the payment statement registration screen, a “guaranteed salary calculation” button provided on the payment statement registration screen is pressed. Then, the monthly salary calculation screen is displayed. FIG. 24 is a diagram illustrating a display example of the guaranteed salary calculation screen. In FIG. 24, the guaranteed salary calculation screen has a salesperson code, salesperson name, fixed salary, commission rate entry fields, and a guaranteed salary calculation button. Here, when the salesperson code, salesperson name, fixed salary and commission rate of the corresponding salesperson are entered and the guaranteed salary calculation button is pressed, the total amount of the sales commission corresponding to the commission rate for the current month's sales is calculated. The guaranteed salary is calculated by calculating the sum of the total sales commission and the fixed salary. That is, the guaranteed salary is the sum of the fixed salary and the sales commission, and does not include other benefits, prize money, and policy additions. On the guaranteed salary calculation screen, the calculation result of the guaranteed salary, and the breakdown (guaranteed salary fee breakdown), the fixed salary and the commission fee (total sales commission) are displayed.
[0069]
Returning to FIG. 22, a “end of confirmation” button is further provided on the checkout statement registration screen. When this button is pressed, the following calculation is performed using the sales commission displayed on the screen, other payments (allowance, fixed salary, prize money, etc.), deductions, and the amount paid at the time of settlement. Calculate the settlement amount for the salesperson.
Settlement amount = (sales fee + payment amount)-deduction amount + deposit amount at the time of settlement
In the above formula, the sales commission is the total sales commission for the sales in that month, the payment is the total of the amount shown in other payments such as fixed salary and other benefits, and the deduction is the source This is the total amount displayed in the deduction amount column for taxes and provisional payments, and the settlement amount displayed in the corresponding column is used as the settlement amount.
[0070]
Then, the corresponding amount used to calculate the settlement amount is displayed in each of “sales fee”, “payment amount”, “deduction amount”, “payment amount at settlement”, and “settlement amount” provided on the settlement statement registration screen. At the same time, the calculation result of the settlement amount is displayed in the corresponding column. This settlement amount is the salary payment amount to the salesperson in that month.
If there is no amount corresponding to the amount paid at the time of settlement, the settlement amount, that is, the salary payment amount, is obtained by “(sales commission + payment amount) −deduction”.
[0071]
The display contents of the checkout details registration screen are registered in the database 10 as a checkout ledger (salary information) for the corresponding salesperson in that month. Further, the user can print out a sheet by pressing a “checkout ledger print” button provided on the screen.
[0072]
The display control of information on each screen related to the settlement management work, the registration process of the numerical calculation, and the settlement details are performed by the settlement management unit 15 shown in FIG. 2 as the settlement management work related process.
[0073]
《Information generated in the operation of the office management system》
When business is performed using the functions of the business management system, the result is created as a slip. There are the following three types of slips.
[0074]
(1) Main slip showing the latest state of slip number
Once the main slip is created, it remains as it is until it expires. Corrections are also entered directly on the main slip.
[0075]
(2) History slip, which is the creation and correction history of the main slip
The history slip is a creation / correction history of the main slip. This remains until the expiration date expires. History slips are not modified. Add only.
[0076]
(3) Monthly slip, which is aggregated information during the month in which the sales office is active
Monthly slips are collected and corrected each time corrections and additions are made to the main slip. This remains until the expiration date expires. Add only. There is no history slip for monthly slips.
[0077]
As shown in FIG. 25, the main slip and the history slip are linked by a slip number. The main slip and the monthly slip are linked by the activity month. The history slip is used when the main slip is inconsistent or for troubleshooting. The monthly slip is used to know the current state of the sales office.
[0078]
<Processing cycle of office management system>
The business management system operates on the basis of the year and month called “month”. This “monthly” is different at each sales office. Declaring the end of “monthly” is a timing called “determined date 1 (first confirmed date)” and “determined date 2 (second confirmed date)”.
[0079]
Here, the first fixed date indicates the closing date of the activity of the management business relating to inventory, sales, and payment. The second fixed date indicates the closing date of the processing related to the settlement. There are two activity months during the period between the first fixed date and the second fixed date. Since it is necessary to satisfy the first fixed date ≦ the second fixed date, the second fixed date is not determined before determining the first fixed date. For example, FIG. 26 is a diagram illustrating a relationship between the first fixed date, the second fixed date, and the monthly level. The right to determine the first fixed date and the second fixed date is in each business office, and each business office determines the first fixed date and the second fixed date.
[0080]
The first and second fixed dates can be set using a monthly management screen displayed by pressing a “monthly management” button provided on the main menu screen shown in FIG.
[0081]
《Distribution information of the host imported by the office management system》
The host computer 22 or the distribution server 23 distributes auxiliary information for the office management system to refer to the office management process every predetermined period of every day, week, or month. The office management system in each business office determines at what timing auxiliary information is to be acquired. The office management system (computer 1) accesses the host computer 22 or the distribution server 23 via the gateway server 21 according to the determined timing (every predetermined period), downloads necessary auxiliary information, and stores the auxiliary storage device 5 To store.
[0082]
Information distributed as auxiliary information includes salesperson information and product information (cosmetic information, diversification information, and souvenir information). Moreover, credit information, consumption tax information, business information, etc. may be included as auxiliary information. The auxiliary information is used by the payment management unit 15 in the payment management related processing.
[0083]
The office management system must obtain the latest salesperson information before the second fixed date. For salesperson information, identification information such as the salesperson code and salesperson name of the salesperson belonging to the sales office, and the commission rate for the salesperson, whether it is subject to warranty salary, fixed salary, etc. Information is included. The office management system must acquire the latest product information before the second fixed date. The merchandise information includes identification information such as a merchandise code and a merchandise name, and information necessary for payroll calculation such as the latest commission of the merchandise and the unit price.
[0084]
FIG. 27 shows an example in which the office management system acquires auxiliary information (salesperson information, product information, etc.). In the example shown in FIG. 27, auxiliary information for June is acquired before the second fixed date for June. For this reason, the settlement process on the second fixed date in June is correctly performed. On the other hand, if the supplementary information for June is not acquired before the second fixed date in June, the salesperson information for May is already acquired in the settlement process on the second fixed date in June. Will be used). At this time, in the case where there is a promotion to the salesperson, correct settlement processing is not performed.
[0085]
[Action]
According to the business management system in the present embodiment, records related to goods related to movement by arrival, transfer, transfer, lending / rental return, and return are registered at the sales office by inventory management related processing by the inventory management unit 11. And manage inventory at the sales office. Therefore, inventory management work can be performed smoothly. Thus, the office work management system functions as a computer system that supports inventory management at a sales office.
[0086]
In addition, according to the office management system, the salary of the salesperson in the month can be calculated by the settlement management related processing by the settlement management unit 15. Therefore, the salary calculation work at the sales office can be performed smoothly. As described above, the office management system functions as a computer system that supports the salary calculation of the sales staff belonging to the sales office.
According to the office management system, a computer functioning as an office management system downloads information (auxiliary information) necessary for calculating salary within a predetermined period from the server. Thereby, salary calculation within a predetermined period can be performed based on appropriate auxiliary information (pay rate, etc.) about the payee.
[0087]
【The invention's effect】
  According to the present invention, a computer system that supports inventory management work at a sales office.TheCan be provided.
[Brief description of the drawings]
FIG. 1 is a diagram showing an outline of a business and office management system in a sales office.
FIG. 2 is an explanatory diagram of a computer system that realizes a business management system;
FIG. 3 is an explanatory diagram of inventory management work;
FIG. 4 is a diagram illustrating a display example of a main menu screen of the business management system.
FIG. 5 is a diagram illustrating a display example of an inventory management screen.
FIG. 6 is a diagram illustrating a display example of an arrival registration screen.
FIG. 7 is a diagram illustrating a display example of a transfer registration screen.
FIG. 8 is a diagram illustrating a display example of a transfer-in registration screen.
FIG. 9 is a diagram illustrating a display example of a lending / lending return registration screen.
FIG. 10 is an explanatory diagram of a sales management business.
FIG. 11 is a diagram illustrating a display example of a sales management screen.
FIG. 12 is a diagram illustrating a display example of a sales registration screen.
FIG. 13 is an explanatory diagram of a return management business.
FIG. 14 is a diagram showing a display example of a returned goods management screen.
FIG. 15 is a diagram illustrating a display example of a returned goods registration (real finger / unnecessary / base) screen;
FIG. 16 is a diagram showing a display example of a return registration (cooling / customer) screen.
FIG. 17 is an explanatory diagram of deposit management work.
FIG. 18 is a diagram showing a display example of a deposit management screen.
FIG. 19 is a diagram showing a display example of a deposit registration screen.
FIG. 20 is an explanatory diagram of a settlement management task.
FIG. 21 is a diagram illustrating a display example of a settlement management screen.
FIG. 22 is a diagram showing a display example of a payment statement registration screen.
FIG. 23 is a diagram showing a display example of a payment registration screen for settlement.
FIG. 24 is a diagram showing a display example of a guaranteed salary calculation screen.
FIG. 25 is an explanatory view of a slip linking state.
FIG. 26 is an explanatory diagram of monthly management.
FIG. 27 is an explanatory diagram of the acquisition timing of auxiliary information (salesperson information, product information, etc.).
[Explanation of symbols]
1 computer
2 CPU
3 Main memory
4 Communication control device
10 Database
11 Inventory Management Department
12 Sales Management Department
13 Returns Management Department
14 Deposit Management Department
15 Settlement Management Department

Claims (1)

A computer system that supports inventory management operations at a sales office where one or more sales staff belongs and sells products for which sales are entrusted.
A received product management unit that manages received product information including at least each information indicating the number of products that are received as shelf stock from the sales agent of the product, and displays the input screen for the received product information A received product management unit that creates a received product record including a product name and the number of products received by the input device through the input screen, and displays the received product record in the database. When,
A lending product management unit for managing lending product information including at least each information indicating a product lent as inventory on hand to a salesperson belonging to a shelf from the shelf, the number thereof, and a salesperson belonging to the lending destination , When an input screen is displayed on the display device and a salesperson name and a product name belong to the input device through the input screen, the number of shelves in stock of the product name is displayed on the input screen, and When the lending number from the shelf inventory is input by the input device, a new on-hand number obtained by adding the lending number from the shelf inventory to the current on-hand inventory number is calculated, and the new on-hand inventory number and the product name are calculated. A lending product record that includes a lending product record for each affiliated product and creates a lending product record for such affiliated salesperson for each lending product, and registers the created lending product record in the database And parts,
Product returned to shelf inventory from stock on hand of affiliation salesperson number thereof, a rental return product management unit manages the rental return product information including at least the information respectively indicating the rent destination belongs salesperson, return the rental When the product information input screen is displayed on the display device, and the salesperson name, product name, and loan return number are input by the input device through this input screen, the loan return number is subtracted from the current inventory on hand. Calculate a new number of on-hand items, create a rent-back product record including the product name and the number of new on-hand inventory, create a rent-back product record for such a salesperson for each lent-back product, A loan back product management unit for registering the created loan back product record in the database ;
A transfer product management section for managing transfer product information including at least information indicating products to be transferred from the self-sales office to other sales offices, the number of the products, and the sales office of the transfer destination, and an input screen for the transfer product information Is displayed on the display device, and when the name of the transfer source business office, the name of the transfer destination business office, and the product name are input by the input device through this input screen, the current storage number of the product is input as the transferable number. When the number of transfers corresponding to the number of transfers available is input from the input device, a transfer product record including the product name, the number of transfers possible, and the number of transfers is created, and such a transfer destination business Creates a transfer product record for each transfer product and creates the transfer product
A transferred product management unit for registering records in the database ;
A transfer product management section for managing transfer product information including at least information indicating products to be transferred from other sales offices to the self-sales office, the number of the products, and the transfer source sales office, and an input screen for the transfer product information Is displayed on the display device, and when the name of the transfer source business office, the name of the transfer destination business office, and the product name are input by the input device through this input screen, When the transfer number of the product is input from the input device, the new current store number is calculated by adding the transfer number to the current store number, and the product name, the new current store number, And a transfer product management section that creates a transfer product record for each transfer product and creates a transfer product record to the transfer destination sales office, and registers the generated transfer product record in the database. ,
An inventory management system of a sales office comprising a return management section for managing return information including at least each information indicating a product to be returned from a sales office to a sales consignor or from a salesperson belonging to the sales office to the sales office.

Images