JP2007276935A - System for supporting inspection of delivered articles and inventory during article inspection by using computer in distributor such as supermarket - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system eliminating delivery slips and regular inventory and drastically reducing costs necessary for article inspection and delivery. <P>SOLUTION: This system for supporting inspection of delivered articles and inventory during the article inspection is provided with an article delivery schedule database storing article delivery schedule data input by suppliers and received from the suppliers via a communication network; a book inventory database storing the number of stock articles on the book calculated by subtracting the number of sold articles recorded in cash registers on the previous day from the sum of the number of stock articles two days before and the number of articles delivered on the previous day; and an actual inventory database storing the number of articles actually stocked. The system is further provided with a function to extract all articles to be delivered on the day from the article delivery schedule database, calculate the number of articles to be displayed and display time based on the article delivery schedule data input by the suppliers first and the book inventory database, and output the number and time to an operation terminal at a unit selling space (cell) allocated to each person in charge. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a system that uses a computer to support inspection of delivered products and inventory at the time of inspection in a distribution business such as a supermarket that handles a large amount of various products.

  Conventionally, a delivery date and the number of deliveries are designated from each store such as a supermarket to a large number of suppliers, and a large number of ordered products are purchased in groups of 5 to 7 each on the designated delivery date. A delivery slip including slips is attached and delivered to the delivery location of each store by the carrier, where the full-time inspection staff at each store delivers the delivery slip attached to the delivery product. The actual products were checked individually and inspected.

  Traditionally, inspections of individual delivered products have been performed in this way, so a dedicated inspection staff is required at each supermarket and other stores, and each business partner must fill out each delivery date for each store. It was requested to create a thick delivery slip. This raises the delivery and inspection costs as a whole, and the transporter entrusted with the delivery may have to wait for a relatively long time with the vehicle until delivery and inspection are completed, which also raises the problem of raising the distribution cost. Furthermore, at each store, there was a regular inventory that counts the actual stock of each product on a regular basis, independently of the daily delivery and inspection work.

  The object of the present invention is to solve the above-mentioned conventional problems, that is, a supermarket that handles a large variety of products using a computer that reduces delivery, inspection costs and distribution costs, and eliminates periodic inventory. It is to provide a system that supports inspection of delivered products and inventory at the time of inspection.

  In the present invention, based on the "prior order data" transmitted from a computer such as a supermarket via a communication network, delivery schedule data sent from each business partner to the computer such as a supermarket via the communication network is stored. For each product delivered on the same day from the scheduled delivery data database, the number of store openings and the store opening time are calculated based on the book inventory quantity, and the obtained data is used as the supplier name, the store name, and the product. It is added to the data of each product including name, number of entries, number of delivery cases, unit price, and expiration date, and is output to the work terminal of the unit sales floor (cell) assigned to each person in charge. The person in charge of each unit sales floor will transfer the corresponding product from the delivered product storage area specified for each business partner according to the number of store sales and the store opening time output to the work terminal of that unit sales floor. Carry it to the sales floor, count the number while displaying the product, and enter the number into the work terminal to complete the inspection at the time of display. Further, the number of actual stocks of each product is counted in accordance with the display that also serves as the inspection for each product, and the number is similarly input to the work terminal to determine the actual stock for each time.

  According to the present invention, for each product, based on the scheduled delivery data for each day, the person in charge of the unit sales floor performs the display and inventory check at each unit sales floor so that the conventional products can be used. Inspection at the time of delivery and periodic inventory are not required, and further, it is not necessary for a business partner to create a delivery slip, thereby reducing costs. Further, since the waiting time for conventional delivery and inspection is zero for the carrier, the distribution cost can be significantly reduced.

  Hereinafter, an embodiment of a system for supporting inspection of delivered goods and inventory at the time of inspection in a distribution business such as a supermarket using the computer of the present invention will be described with reference to FIGS.

  FIG. 1 is a schematic system diagram of an embodiment of a system for supporting inspection of delivered goods and inventory at the time of inspection in a supermarket or the like using the computer of the present invention, and a computer in the store A (hereinafter referred to as CP) is a communication network. And the CP of the supplier A, the CP of the supplier B,... Through the headquarter CP that controls a plurality of stores, respectively. Each store CP has a delivery schedule data database, a real inventory data database, a book inventory data database, a cash register A, a cash register B,..., A cash register N, and a work prepared for each unit sales floor assigned to each person in charge. A work terminal A, a work terminal B,..., And a work terminal N are provided.

  From the business partners A, B,..., N, based on the “pre-order data” via the communication network from the store CP, at least the day before the delivery date, the delivery date, the transaction Delivery schedule data with data such as the name of the store, the name of the store, the name of the product, the number of entries, the number of delivery cases, the unit price, the expiration date, etc. is sent to the store CP via the communication network. The store CP stores the delivery schedule data sent in this way in the delivery schedule data database each time.

  The store CP extracts products to be delivered that day from the delivery schedule data database, sorts them by unit sales floor, and stores the inventory quantity of the previous day stored in the book inventory data database for each product + Number of deliveries on the previous day-Based on the number of book inventory in the morning of the day determined by the number of checkouts sold on the previous day, the store opening time and the number of store opening cases are calculated for each product, and these are sent from each business partner. In addition to delivery schedule data including data such as the date of delivery, supplier name, store name, product name, number of entries, number of delivery cases, unit price, expiration date, etc., distribute to each corresponding work terminal .

  FIG. 2 shows an example of a screen “delivery store leaving work” that displays the data distributed to the work terminals in this way. The display of this “delivery store opening work” screen is based on the “business partner time” of the display by business partner and order of store opening time, but when “time business partner” is selected, the display of the store opening time and business order by business partner is selected. It is configured to change to display.

  When the store CP determines the store opening time based on the book inventory quantity in the morning of that day in the book inventory data database, the “before store opening” instruction is given to the store opening time column for items with low inventory. Display.

  Further, when the number of delivery cases on that day exceeds the number of cases that can be displayed on the floor for the product, the number is displayed in the warehouse detained case column of the “delivery store opening work” screen. Therefore, for products that have a large amount of arrival and cannot be displayed on the sales floor at a time, there is no waste of erroneously moving the products to the sales floor, and store operation costs are reduced.

  The person in charge of each unit sales floor follows the display on the “delivery store opening work” screen of each corresponding work terminal, and the designated delivery product of the store assigned to each business partner according to the designated store opening time. Go to the yard, take out the corresponding delivered product, bring it into the unit sales area in charge, scan the JAN code of the delivered product (or the JAN code of the case) at the time of display, count the number of store cases, and confirm Then, enter the number in the “Confirmed store opening case number field” of the work terminal. In addition, when the number of warehouse detained cases is specified on the “delivery store opening work” screen, the same method as the previous store store case confirmation is performed when the store store products are picked up at the designated delivery product store. Count the number of warehouse detained cases, confirm, and enter the number in the “Confirmed warehouse case number field” of the work terminal. In addition, when the person in charge of the unit sales department confirms the number of delivered products, if there is any missing damage in the delivered products, the number is entered in the “damage missing number column”.

  In addition, the person in charge of each unit sales floor will discount the percentage of unsold items for yesterday's unsold items in accordance with the display work that also serves as the inspection for the corresponding delivered products according to the specified store opening time including before opening. The inventory is checked while stickers are attached, and the counted number is entered in the actual inventory quantity field before opening of the work terminal. Therefore, it is not necessary to take another inventory for each product.

  Upon receiving input to the work terminal based on the work at each unit sales floor as described above, the store CP confirms the number of confirmed store cases + number of confirmed warehouse detained cases = number of delivered cases for each product delivered on that day. If there is a discrepancy, the number of shortage cases will be displayed in the shortage of delivery case field on the “delivery store exit” screen of the work unit at the relevant unit sales floor, and the message “Check the number of cases again” will be displayed. Display on the screen.

  If the discrepancy is not resolved in spite of the reconfirmation work by the person in charge of the relevant unit sales floor according to the reconfirmation instruction message, the store CP will contact the relevant customer CP via the headquarters CP. Automatically report the number of underdelivered cases or surplus cases.

  Through the above operation, the purchase is confirmed even if the conventional purchase slip is eliminated.

  Further, the store CP is based on the above input, the numerical value of the “pre-opening inventory quantity field” (corresponding to the book inventory quantity on the morning of the day) and the “real inventory quantity field before opening” on the “delivery store opening work” screen. Is displayed in the “Inventory shortage (actual book)” column. When the person in charge determines that the numerical value is not an abnormal value and presses the confirmation key of the work terminal, the book inventory data of the corresponding product in the book inventory data database is replaced with the confirmed actual inventory data. Through the above operations, display and inventory inspection that also serve as inspections are completed at each unit sales floor.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a schematic system diagram of an embodiment of a system that supports inspection of delivered products and inventory at the time of inspection in a supermarket or the like using the computer of the present invention. The figure which shows an example of the "delivery store leaving work" screen displayed on the work terminal of a certain unit sales floor of FIG.

Claims (5)

  This is a system that supports the inspection of delivered products and the inventory at the time of inspection in the distribution business such as a supermarket using a computer, and the above-mentioned computers are input by each supplier received from a number of suppliers' computers via communication lines. Delivery schedule data database that stores delivery schedule data for each product handled, including delivery date, supplier name, supplier name, product name, quantity entered, number of delivery cases, original unit price, and expiration date. + Delivery quantity of the previous day-Book inventory data database storing the book inventory quantity of each handling product obtained from the previous day's cash register sales quantity and each handling product including the delivery quantity of each case and counting it Has an actual inventory data database storing the actual inventory quantity, and The computer of the distribution business such as the market extracts all the products that are scheduled to be delivered on the same day from the above delivery schedule data database, and for each of the extracted products, the delivery schedule of each product entered by each business partner first Further, based on the book inventory data database, the number of store openings and the store opening time of each product are calculated and added to the data, and the unit sales floor (cell) assigned to each person in charge is added. ) Function to output to the corresponding work terminal assigned to) and each delivery at each unit sales floor according to the store opening number and the store opening time for each product output from the above corresponding work terminal Number of products counted in the display that doubles as inspection of products, and actual inventory adjustments for the corresponding products accordingly Based on the input to the corresponding work terminal of the number counted in step 1, the delivery quantity is verified for each delivered product, and the actual stock quantity for each product is confirmed. A system that supports the inspection of delivered products and inventory at the time of inspection in the distribution industry such as supermarkets using computers.   The computer of the supermarket etc. according to claim 1, wherein the computer of the supermarket etc. corrects the corresponding data in the book inventory data database based on the determined actual stock quantity of each product. A system that supports inspection of delivered products and inventory at the time of inspection in the distribution industry.   The computer of the supermarket or the like re-delivered the product to the corresponding work terminal if the number input from the corresponding work terminal and the delivery quantity in the corresponding delivery schedule data do not match as a result of collation. The system for supporting the inspection of delivered goods and inventory at the time of inspection in a distribution business using a computer according to claim 1, wherein the number is counted and an instruction is given to input the number.   The computer of the supermarket etc. in the distribution business such as a supermarket using the computer according to claim 3, wherein if the discrepancy of the result of the collation is not resolved, the contents of the discrepancy are transmitted to the corresponding business partner A system that supports inspection of delivered products and inventory at the time of inspection. The computer of the supermarket or the like uses the difference between the actual inventory quantity of each product input from the work terminal and the book inventory quantity obtained from the book inventory data database, respectively, to the inventory shortage column for the corresponding product on the corresponding work terminal. The system according to claim 1, wherein the system supports the inspection of delivered products and the inventory at the time of inspection in a distribution business such as a supermarket using the computer according to claim 1.