CN111126922A - Dynamic backtracking query method and management system for home decoration store warehousing system - Google Patents
Dynamic backtracking query method and management system for home decoration store warehousing system Download PDFInfo
- Publication number
- CN111126922A CN111126922A CN201911387642.0A CN201911387642A CN111126922A CN 111126922 A CN111126922 A CN 111126922A CN 201911387642 A CN201911387642 A CN 201911387642A CN 111126922 A CN111126922 A CN 111126922A
- Authority
- CN
- China
- Prior art keywords
- warehouse
- warehousing
- information
- dimensional code
- inventory
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000005034 decoration Methods 0.000 title claims abstract description 33
- 239000000463 material Substances 0.000 claims abstract description 192
- 239000002344 surface layer Substances 0.000 claims abstract description 19
- 230000008569 process Effects 0.000 claims description 16
- 230000006870 function Effects 0.000 claims description 4
- 238000007726 management method Methods 0.000 description 30
- 238000010276 construction Methods 0.000 description 12
- 230000000875 corresponding effect Effects 0.000 description 12
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 11
- 230000002950 deficient Effects 0.000 description 10
- 238000012384 transportation and delivery Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 6
- 238000012550 audit Methods 0.000 description 5
- 238000012546 transfer Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000007812 deficiency Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000002596 correlated effect Effects 0.000 description 1
- 230000000215 hyperchromic effect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000013468 resource allocation Methods 0.000 description 1
- 239000011550 stock solution Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24573—Query processing with adaptation to user needs using data annotations, e.g. user-defined metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device
- G06K17/0025—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Finance (AREA)
- Human Resources & Organizations (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- Library & Information Science (AREA)
- Development Economics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a dynamic backtracking query method of a warehouse system of a home decoration store, which comprises the following steps: s1: inputting the information of the warehouse-in and warehouse-out materials and the quantity of the warehouse-in and warehouse-out materials; s2: the dynamic recording module records the surface layer information of the input warehousing material information, the warehousing material quantity, the ex-warehouse material information and the ex-warehouse material quantity and generates a surface layer information library; s3: when backtracking the warehousing records and the ex-warehouse records, the user directly enters the surface layer information base, and directly scans the warehousing two-dimensional code or the ex-warehouse two-dimensional code, and the system directly calls all warehousing records and ex-warehouse records belonging to the material name from the surface layer information base according to the material information. The invention also provides a warehouse management system of the home decoration store. The invention can effectively improve the material input and query efficiency and avoid the problems of material loss, material cost confusion and the like.
Description
Technical Field
The invention relates to a warehouse database query method, in particular to a dynamic backtracking query method and a management system of a warehouse system of a home decoration store.
Background
The traditional home decoration industry lacks a professional storage management system, warehouse entry and exit management is disordered, the storage cannot be inquired quickly, the stock overstock or emergency stock is caused easily, the shortage of storage management causes management short boards, and the project construction period quality is influenced. In the process of the project, backtracking and querying of the flow record can not be performed, and the conditions of effective closed loop, material loss and the like from material purchase to material warehouse-out are not realized. Meanwhile, the records of the entry and exit of the project are not clear, and the material cost of the project is also disordered.
Disclosure of Invention
In view of the above, the invention provides a dynamic backtracking query method and a management system for a warehouse system of a home decoration store, which can form a quick and effective backtracking query, improve the material input and query efficiency, and avoid the problems of material loss, material cost confusion and the like.
Therefore, in one aspect, the invention provides a dynamic backtracking query method for a warehouse system of a home decoration store, which comprises the following steps:
s1: arranging a warehousing two-dimensional code for identifying warehousing material information and warehousing material quantity on the material warehousing bill, and after scanning the warehousing two-dimensional code, inputting the warehousing material information and the warehousing material quantity into a stock database; meanwhile, the ex-warehouse two-dimensional code used for identifying the ex-warehouse material information and the ex-warehouse material quantity is arranged on the material ex-warehouse list, the ex-warehouse material information is recorded into the inventory database after the ex-warehouse two-dimensional code is scanned, and the ex-warehouse material quantity is deducted from the inventory quantity;
s2: setting a dynamic recording module in the warehousing database, recording surface layer information of the recorded warehousing material information, warehousing material quantity, ex-warehouse material information and ex-warehouse material quantity by the dynamic recording module, and generating a surface layer information library;
s3: when backtracking the warehousing records and the ex-warehouse records, the user directly enters the surface layer information base, and directly scans the warehousing two-dimensional code or the ex-warehouse two-dimensional code, and the system directly calls all warehousing records and ex-warehouse records belonging to the material name from the surface layer information base according to the material information.
Further, the recording process of the surface layer information in the step S2 includes:
s211: when the data is recorded into the inventory database, the system automatically keeps the material information and the material quantity synchronously in the dynamic recording module;
s212: the time recording module records the event occurrence time into the dynamic recording module in real time, and the dynamic recording module associates the corresponding event occurrence time with the corresponding material;
s213: and the dynamic recording module stores the associated material information, material quantity and material in/out time and generates a surface information base.
Further, the generating process of the surface information base includes:
s221: the dynamic recording module associates and packs the related material data into a folder;
s222: naming the folder with the corresponding material name;
s223: the system automatically generates a text file containing the material data and stores the text file in a folder;
s224: and combining a plurality of folders into a surface information base.
Further, the text file is a word file and/or an excel file.
Further, the two-dimensional code identification and association process of step S1 includes:
s11: presetting a two-dimensional code related to the material information according to the material category, and setting the two-dimensional code as a warehousing two-dimensional code or a warehousing two-dimensional code according to the warehousing and warehousing functions;
s12: scanning the two-dimension code for warehousing or the two-dimension code for ex-warehouse, automatically calling out material information by the system, and requiring a user to input the material quantity;
s13: the material information and the material quantity are automatically entered into the inventory database.
In another aspect, the present invention provides a warehouse management system for home decoration stores, which includes a material warehouse entry and exit management module, a warehouse entry and exit reservation module, and an inventory instant query module, wherein the inventory instant query module applies the dynamic backtracking query method for the warehouse system of home decoration stores as claimed in any one of claims 1 to 5.
Further, the home decoration shop warehouse management system adopts a B/S mode.
Further, a colored batch number adjusting module is arranged in the material warehouse entry management module, when a new colored batch number is adjusted, an adjusting sheet number is automatically generated, an adjusting person and an adjusting date are automatically brought out, and an adjusting type is selected: color number or lot number.
According to the dynamic backtracking query method and the management system of the home decoration store warehousing system, firstly, a two-dimensional code scanning technology is utilized to form rapid warehouse-in and warehouse-out records of material information and quantity, then, a dynamic recording module is used to record the input data and generate a surface information base, the data records of the surface information base are utilized to form rapid backtracking query of subsequent data, the conventional mode that the materials need to enter the database for query is replaced, and the surface information base only records the necessary data such as the material information, the quantity and the like, so that the data quantity of the data query is reduced, the material input and query efficiency can be effectively improved, and the problems of material loss, material cost confusion and the like are avoided.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a schematic main flow chart of a dynamic backtracking query method for a warehouse system of a home decoration store according to an embodiment of the present invention;
fig. 1A is a schematic view of a surface information recording process of a dynamic backtracking query method for a warehouse system of a home decoration store according to an embodiment of the present invention;
fig. 1B is a schematic diagram of a two-dimensional code identification and association process of a dynamic backtracking query method for a warehouse system of a home decoration store according to an embodiment of the present invention;
fig. 1C is a schematic diagram illustrating a surface information base generation process of a dynamic backtracking query method for a warehouse system of a home decoration store according to an embodiment of the present invention;
fig. 2 is a schematic flow chart of a store warehouse of the warehouse management system of a home decoration store according to an embodiment of the present invention;
fig. 3 is a schematic diagram illustrating a warehouse-out process of the warehouse management system of the home decoration store according to an embodiment of the present invention;
fig. 4 is a schematic diagram illustrating a warehousing process of the warehouse management system of the home decoration store according to an embodiment of the present invention;
FIG. 5 is a schematic material utilization flow chart of a warehouse management system of a home decoration store according to an embodiment of the present invention;
FIG. 6 is a schematic illustration of a material return flow of a warehouse management system of a home decoration store according to an embodiment of the present invention;
fig. 7 is a schematic diagram illustrating an inventory checking process of the warehouse management system of the home decoration store according to an embodiment of the present invention;
fig. 8 is a schematic diagram illustrating a procedure of allocating each store in the warehouse management system of the home decoration store according to the embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
As shown in fig. 1, the dynamic backtracking query method for a warehouse system of a home decoration store provided in the present embodiment includes the following steps:
s1: arranging a warehousing two-dimensional code for identifying warehousing material information and warehousing material quantity on the material warehousing bill, and after scanning the warehousing two-dimensional code, inputting the warehousing material information and the warehousing material quantity into a stock database; meanwhile, the ex-warehouse two-dimensional code used for identifying the ex-warehouse material information and the ex-warehouse material quantity is arranged on the material ex-warehouse list, the ex-warehouse material information is recorded into the inventory database after the ex-warehouse two-dimensional code is scanned, and the ex-warehouse material quantity is deducted from the inventory quantity;
s2: setting a dynamic recording module in the warehousing database, recording surface layer information of the recorded warehousing material information, warehousing material quantity, ex-warehouse material information and ex-warehouse material quantity by the dynamic recording module, and generating a surface layer information library;
s3: when backtracking the warehousing records and the ex-warehouse records, the user directly enters the surface layer information base, and directly scans the warehousing two-dimensional code or the ex-warehouse two-dimensional code, and the system directly calls all warehousing records and ex-warehouse records belonging to the material name from the surface layer information base according to the material information.
As shown in fig. 1A, the recording process of the surface layer information in step S2 includes:
s211: when the data is recorded into the inventory database, the system automatically keeps the material information and the material quantity synchronously in the dynamic recording module;
s212: the time recording module records the event occurrence time into the dynamic recording module in real time, and the dynamic recording module associates the corresponding event occurrence time with the corresponding material;
s213: and the dynamic recording module stores the associated material information, material quantity and material in/out time and generates a surface information base.
As shown in fig. 1B, the process of generating the surface information library includes:
s221: the dynamic recording module associates and packs the related material data into a folder;
s222: naming the folder with the corresponding material name;
s223: the system automatically generates a text file (word file and/or excel file) containing the material data and stores the text file and/or the excel file in a folder;
s224: and combining a plurality of folders into a surface information base.
As shown in fig. 1C, the two-dimensional code identification and association process of step S1 includes:
s11: presetting a two-dimensional code related to the material information according to the material category, and setting the two-dimensional code as a warehousing two-dimensional code or a warehousing two-dimensional code according to the warehousing and warehousing functions;
s12: scanning the two-dimension code for warehousing or the two-dimension code for ex-warehouse, automatically calling out material information by the system, and requiring a user to input the material quantity;
s13: the material information and the material quantity are automatically entered into the inventory database.
As shown in fig. 1 to 8, the warehouse management system of the home decoration store provided in this embodiment includes a material warehouse entry and exit management module, a warehouse entry and exit reservation module, and an inventory instant query module, where the inventory instant query module applies the dynamic backtracking query method of the warehouse system of the home decoration store, combines with actual business of stores, manages material warehouse entry and exit, reserves warehouse entry and exit, and immediately queries inventory, and performs resource allocation among different stores by material allocation, and also performs inventory checking to handle inventory difference by inventory checking, so as to keep the accounts and realities consistent. Meanwhile, the method also combines the business, performs report statistics on the materials, and effectively monitors the dull stock, the defective products, the warehouse entry and exit efficiency and the like. Through the system, the store can clearly and effectively manage the store warehouse, the materials are effectively managed, and the ordered progress of the project is promoted.
By establishing a professional warehousing management system, a data closed loop is established from the purchase of materials to the ex-warehouse of the materials, and each node has a traceable characteristic. The warehouse-in and warehouse-out data is clear, the inventory can be checked in real time, and the material quantity can be locked after the warehouse-out is reserved, so that the warehouse-out is effectively carried out. In the warehousing system, report statistics can be carried out through data flow, and then warehousing management is optimized through a management means, for example, cash flow is affected due to overhigh inventory, stock solutions need to be adjusted, and bankrupt products are excessively stocked and need to be discounted for sale.
The warehouse management system related to the embodiment is suitable for the home decoration industry and is used for the purchase, sales and inventory management of stores in each store of the home decoration.
The hardware environment and the software environment for development and operation are as follows:
(1) hardware environment developed: the CPU is more than I3 and at least 2G memory;
(2) software environment developed: windows, Java1.7, MySQL1.6;
(3) hardware environment of operation: the CPU is PIV and above, at least 1G memory;
(4) software environment of operation: server side environment (Linux system, java1.7, mysql1.6);
the programming language is Java jdk 1.7, the technical characteristics adopt a B/S mode, and the development and calling efficiency is high; all data are managed after entering the system by adopting a uniform inlet, and the system is fast and convenient to maintain; the portability is strong, the requirement on the operating environment is simple, the stability is strong, and the safety is high. And the MVC development mode is adopted to separate the code and the interface.
The warehouse management system related to the embodiment further comprises the following functions:
1.1 inventory management
1.1.1 inventory query
The stock data of the local store can be inquired according to commodity numbers, commodity names, brands, commodity types and stock areas. The types of goods include: main materials, auxiliary materials, self-purchased main materials and self-purchased auxiliary materials; the reservoir area includes: a good product storage area, a defective product storage area, a virtual storage area and a gift storage area; the good product warehouse area is from good product warehouse-in, the defective product warehouse area is from defective product warehouse-in and stock adjustment (good product adjustment defective product), and the gift warehouse area is from gift purchase warehouse-in.
1.1.2 inventory adjustment
The stock adjustment can only adjust the materials in the good product stock area to be defective products, and the generation rule of the single number can be adjusted according to the adjustment single number, the adjustment date and the checking state inquiry. Inventory adjustment approval is from the custodian → shop finance. Adjustment lists which are not submitted and not approved can be invalidated. And after the adjustment order is submitted for auditing, locking the good product stock, canceling the locking after the adjustment order is invalidated, and generating good product delivery commodity flow and defective product warehousing flow after the adjustment order is approved.
When stock adjustment is newly added, a sheet number is automatically generated, an applicant is automatically brought out, the application date is automatically brought out, the adjustment type is fixed as good product → defective product, the adjustment reason is filled, the adjustment commodity is selected, and the commodity can be selected only from good product stock.
1.1.3 inventory loss report
The inventory defective products are subjected to inventory damage reporting, and can be inquired according to a damage report number, a damage report date and an audit state, and a damage report audit process is carried out: warehouse manager → shop finance → store manager → platform finance center, and submitting the examination and examination of the reported loss of stock. The file can be edited and invalidated after being submitted.
Newly added inventory loss reporting, automatic generation of a loss report number, automatic bringing-out of loss reporting dates and applicants, automatic collection of loss reporting amounts according to the details, and automatic display of the effective date which is the loss reporting verification pass date. Filling in the loss reason, and submitting the inventory report for examination.
1.2 color lot number adjustment
The commodity color number or batch number can be adjusted together with a plurality of commodities, and can be inquired according to the adjustment order number, the audit passing date and the audit state. The color batch number adjustment does not need to be checked, the adjustment is successful after the commodity is submitted, meanwhile, a color batch number adjustment running water record is generated in the commodity in-out running water, and the state to be submitted can be edited and invalidated. When the storage and adjustment are carried out, the number is required to be checked to be consistent before and after the adjustment, otherwise, the storage or submission cannot be carried out.
When the new hyperchromic batch number is adjusted, the adjustment sheet number is automatically generated, the adjustment person and the adjustment date are automatically brought out, and the adjustment type is selected: color number or lot number. The adjustment detail is selected, a plurality of materials can be selected, and the material codes are required to be consistent. And (4) adjusting the color numbers, wherein the batch numbers are required to be consistent, the batch numbers are required to be adjusted, the color numbers are required to be consistent, and the adjustment quantity cannot be larger than the adjustable quantity. After the adjustment material is added, the adjusted material is displayed in a row by default, the material information is consistent with the added material, and the color number or batch number information is edited and can be adjusted into a plurality of pieces. When the storage and adjustment are carried out, the number is required to be checked to be consistent before and after the adjustment, otherwise, the storage or submission cannot be carried out.
1.3 reservation note for warehousing
Displaying the warehousing reservation orders pushed by all the business documents, wherein different businesses correspond to different types of warehousing reservation orders, and the method comprises the following steps: the method comprises the following steps of self-purchasing commodities, auxiliary materials, main material standard products, soft packaging, transferring lists, material return-capital construction, material return-samples, material return-store self-use, material return-project construction, and generating corresponding ex-warehouse reservation lists by pushing various business documents.
1.4 reservation sheet for delivery
The ex-warehouse reservation list state comprises the following steps: the reservation is successful, the reservation is failed, the reservation is cancelled, the delivery is delivered, and the delivery list with the successful reservation can be cancelled. The ex-warehouse reservation type comprises: the method comprises the steps of purchasing commodities, auxiliary materials, main material labels, soft packaging, transferring lists, material receiving-capital construction, material receiving-sample, material receiving-shop self-use, material receiving-project construction and goods return, and generating corresponding ex-warehouse reservation lists by pushing business documents.
The warehouse manager executes warehouse-out according to the warehouse-out reservation list, when warehouse-out is carried out, the warehouse-out number cannot be larger than the reservation number and can be smaller than the reservation number, the warehouse-out reservation list state is carried out after warehouse-out, and partial warehouse-out state (no matter whether all warehouse-out is carried out or not) is cancelled.
And checking all the ex-warehouse list information, and searching according to the ex-warehouse type. And different types of delivery lists have different corresponding business documents, the corresponding transfer list numbers are transferred and delivered out of the warehouse, and the return list numbers are delivered out of the warehouse.
1.5 materials receipt
The material acceptance is project construction, capital construction, sample and store self-use, and after the acceptance sheet is approved, the ex-warehouse reservation sheet can be generated. And the warehouse keeper carries out warehouse-out according to the warehouse-out reservation sheet. Project construction, application of a store ordering person or a housekeeper, and automatic generation of a warehouse-out reservation sheet after submission. And (4) receiving materials of the types of capital construction, samples and stores, and generating a delivery reservation sheet after auditing.
Selecting a return type: project construction, capital construction, samples and self-service in stores. Item Return type, requiring selection of an item, with the Return material selected from the item's outbound material. The materials used by capital construction, samples and stores are returned, the warehouse-out bill needs to be correlated, and the returned materials are selected from the receiving bill.
1.6 stock flows
The warehouse-out flowing water corresponds to the commodity warehouse-out flowing water of the warehouse-out bill, and the warehouse-in flowing water corresponds to the commodity warehouse-in flowing water of the warehouse-in bill. The warehouse-in and warehouse-out running water comprises all types of commodity warehouse-out and warehouse-in running water, including inventory adjustment, inventory reporting and loss, color batch number adjustment, inventory checking, warehouse-out order and warehouse-in order. And displaying the serial number of the business document generating the running water in the running water entering and exiting the warehouse.
1.7 inventory checking
And adding an inventory list by a warehouse manager to perform inventory, wherein the platform can directly initiate the inventory list of each store. The checking type is the checking of the whole warehouse, and the checking range is the materials of a good warehouse area. And checking the inventory into an initial inventory, a repeated inventory and an inventory difference list, and if the difference part is submitted for verification, then changing the inventory.
And locking the warehouse after the checking list is stored, stopping checking, unlocking the warehouse and ending the checking, submitting checking difference list for checking if the checking difference exists, unlocking the warehouse, and unlocking the warehouse after the checking is ended if no difference exists. After the initial inventory, if the inventory quantity is different, the inventory needs to be repeated, and if the inventory quantity is not different, the direct inventory is finished. The double-disc only needs to count the number of lists with difference, only displays the lists without difference, and does not need to count and register. And after the disk is copied, if the difference exists, generating an inventory difference list, if the difference does not exist, not generating the inventory difference, and after the disk is copied, ending the inventory.
Selecting an inventory type: and (4) checking the whole stock, automatically listing all stock material lists by the system, only listing material information, not displaying the stock, and checking the stock to be a blind disc. And filling remarks, after the points are stored, generating an inventory list, locking inventory at the moment, and not performing warehousing unless the inventory is cancelled or the inventory is finished. The point view button in the list goes to the inventory details page, pointing to the "export" in the top right hand corner of the inventory list.
And (4) checking excel by importing, and paying attention to that only previously downloaded excel can be uploaded and materials cannot be added into the excel. If the materials are fully checked during checking, the materials, the material type supply chain materials and the self-purchased materials can be newly added on the checking detail page, and the checking quantity is filled after the materials are selected.
If the initial disc counting quantity is different from the actual stock, re-counting is needed, only different materials need to be counted during re-counting, and accurate materials do not need to be counted during initial disc counting;
the number of the duplicate discs is recommended to be manually input, the system also supports import of the number of the duplicate discs, but only the inventory material list excel downloaded in the early stage can be used;
when the number of the repeated disks is different from the actual inventory, the system automatically generates an inventory difference list. The materials in the difference sheet are divided into two categories: excess and deficiency of the dish. The warehouse manager needs to remark the difference materials to explain the difference reason, submit the audit, and release the lock warehouse after the difference list is submitted. After the checking of the inventory difference list is passed, the system automatically generates the warehouse-out (inventory shortage) and warehouse-in running water (inventory shortage) of the inventory difference.
And in the checking difference list, materials of excess and deficiency are separately displayed, and warehouse managers are used for remarking the difference reasons of the difference materials and submitting the remarks for examination.
1.8 inventory Allocation
Auxiliary materials of supply chains among storehouses of stores and auxiliary materials purchased by the stores are allocated. And calling in the store to initiate transfer, and automatically generating a warehouse-out reservation list in the store after the check of the store is passed. And after the user calls out the store, the user automatically generates a storage reservation bill in the call-in store. After the system is transferred to a store to be put in storage, the state of a call list is: and (5) warehousing and transferring.
And adding a transfer order, selecting to transfer into a store house, and displaying information of a warehouse manager and a warehouse of the current store house by default according to the information of the consignee. And selecting materials to be allocated from the inventory of the allocation bin, and only supporting allocation of auxiliary materials in a supply chain of a good product warehouse. If the store is called into the store warehouse, the other stores are not allowed to check the inventory, and the call cannot be made. The reference price of the allocated material is the sale price of the material sold in the supply chain at present, the allocation settlement price is equal to the reference price by default, and the store house initiating the allocation can be modified and is taken out of the store house for auditing. And the out-of-store is carried out according to the stock unit price, and the in-store is carried out according to the transfer settlement price.
1.9 management of returns
And returning goods from the store to the suppliers, wherein the goods comprise supply chain suppliers and store self-purchase suppliers. After the goods returned list is approved, the system automatically generates a delivery reservation list, and the warehouse keeper delivers goods from the warehouse according to the delivery reservation list.
Selecting a goods returning channel: the method comprises the steps of platform goods returning and self-purchase goods returning, wherein the platform goods returning is material goods returning purchased by a supply chain, and the self-purchase goods returning is material goods returning purchased by a store. Selecting a return type: good products, defective products and different return types, and material return is selected from the corresponding storage area. The information of the goods returned and received by the goods receiver and the information of the platform returned goods automatically display the information of the central warehouse corresponding to the store warehouse, and the information of the self-purchase supplier is displayed by the self-purchase returned goods.
The dynamic backtracking query method and the management system for the warehouse system of the home decoration store provided by the embodiment are characterized in that a scanning technology of two-dimensional codes is firstly utilized to form rapid warehouse entry and exit records of material information and quantity, then a dynamic recording module is used to record the entered data and generate a surface information base, the data records of the surface information base are utilized to form rapid backtracking query of subsequent data, the conventional mode that the materials need to enter the database for query is replaced, and the surface information base only records the necessary data such as the material information and the quantity, so that the data quantity of the data query is reduced, the material entry and query efficiency can be effectively improved, and the problems of material loss, material cost confusion and the like are avoided.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (8)
1. A dynamic backtracking query method for a warehouse system of a home decoration store is characterized by comprising the following steps:
s1: arranging a warehousing two-dimensional code for identifying warehousing material information and warehousing material quantity on the material warehousing bill, and after scanning the warehousing two-dimensional code, inputting the warehousing material information and the warehousing material quantity into a stock database; meanwhile, arranging a warehouse-out two-dimensional code for identifying warehouse-out material information and warehouse-out material quantity on a material warehouse-out sheet, scanning the warehouse-out two-dimensional code, inputting the warehouse-out material information into a stock database, and deducting the warehouse-out material quantity from the stock quantity;
s2: setting a dynamic recording module in the inventory database, wherein the dynamic recording module records the surface layer information of the input warehousing material information, the warehousing material quantity, the ex-warehouse material information and the ex-warehouse material quantity and generates a surface layer information library;
s3: when backtracking the warehousing records and the ex-warehouse records, a user directly enters the surface layer information base, and directly scans the warehousing two-dimensional code or the ex-warehouse two-dimensional code, and the system directly calls all warehousing records and ex-warehouse records belonging to the material name from the surface layer information base according to the material information.
2. The method as claimed in claim 1, wherein the step S2 of recording the surface layer information comprises:
s211: while data are input into the inventory database, the system automatically keeps the material information and the material quantity synchronously in the dynamic recording module;
s212: the time recording module records the event occurrence time into the dynamic recording module in real time, and the dynamic recording module associates the corresponding event occurrence time with the corresponding material;
s213: and the dynamic recording module stores the associated material information, material quantity and material warehousing-in/warehousing-out time and generates the surface information library.
3. The method as claimed in claim 1 or 2, wherein the generating process of the surface information base comprises:
s221: the dynamic recording module associates and packs related material data into a folder;
s222: naming the folder with the corresponding material name;
s223: the system automatically generates a text file containing the data of the materials to be stored under the folder;
s224: and combining a plurality of folders into the surface information base.
4. The dynamic backtracking query method for the warehouse system of the home decoration store as claimed in claim 3, wherein the text file is a word file and/or an excel file.
5. The method as claimed in claim 1, wherein the two-dimensional code identification and association process of step S1 includes:
s11: presetting a two-dimensional code related to the material information according to the material category, and setting the two-dimensional code as a warehousing two-dimensional code or a warehousing two-dimensional code according to the warehousing and warehousing functions;
s12: scanning the warehousing two-dimensional code or the ex-warehouse two-dimensional code, automatically calling out material information by a system, and requiring a user to input the material quantity;
s13: the material information and the material quantity are automatically entered into the inventory database.
6. A warehouse management system of a home decoration store, which comprises a material warehouse entry and exit management module, a warehouse entry reservation module and an inventory instant query module, wherein the inventory instant query module applies the dynamic backtracking query method of the warehouse system of the home decoration store according to any one of claims 1 to 5.
7. The home store warehouse management system of claim 6, wherein the home store warehouse management system employs a B/S model.
8. The warehouse management system of claim 6, wherein the warehouse management module is provided with a color batch number adjustment module, when adjusting a new color batch number, an adjustment sheet number is automatically generated, an adjustment person and an adjustment date are automatically brought out, and an adjustment type is selected: color number or lot number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911387642.0A CN111126922A (en) | 2019-12-27 | 2019-12-27 | Dynamic backtracking query method and management system for home decoration store warehousing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911387642.0A CN111126922A (en) | 2019-12-27 | 2019-12-27 | Dynamic backtracking query method and management system for home decoration store warehousing system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111126922A true CN111126922A (en) | 2020-05-08 |
Family
ID=70504487
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911387642.0A Pending CN111126922A (en) | 2019-12-27 | 2019-12-27 | Dynamic backtracking query method and management system for home decoration store warehousing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111126922A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102867229A (en) * | 2012-07-27 | 2013-01-09 | 吉林大学 | Material list establishing method based on intelligent mobile phones and tablet personal computers |
| CN106203905A (en) * | 2016-07-05 | 2016-12-07 | 上海市基础工程集团有限公司 | The material in-out-storehouse management method that engineering construction is on-the-spot |
| CN107590630A (en) * | 2017-09-15 | 2018-01-16 | 郑州云海信息技术有限公司 | A kind of warehouse management system and method based on cloud computing |
| CN109359907A (en) * | 2018-09-20 | 2019-02-19 | 江苏绪普信息科技有限公司 | A kind of storekeeper bar code management system |
-
2019
- 2019-12-27 CN CN201911387642.0A patent/CN111126922A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102867229A (en) * | 2012-07-27 | 2013-01-09 | 吉林大学 | Material list establishing method based on intelligent mobile phones and tablet personal computers |
| CN106203905A (en) * | 2016-07-05 | 2016-12-07 | 上海市基础工程集团有限公司 | The material in-out-storehouse management method that engineering construction is on-the-spot |
| CN107590630A (en) * | 2017-09-15 | 2018-01-16 | 郑州云海信息技术有限公司 | A kind of warehouse management system and method based on cloud computing |
| CN109359907A (en) * | 2018-09-20 | 2019-02-19 | 江苏绪普信息科技有限公司 | A kind of storekeeper bar code management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7072855B1 (en) | Systems and methods for purchasing, invoicing and distributing items | |
| TW508516B (en) | Warehousing system with optimum process management | |
| KR100198236B1 (en) | A customer data processing system provided in a showroom | |
| CN107330755A (en) | Dealer management system | |
| KR102192429B1 (en) | Goods Receipt and Issue Management System using binary management user interface | |
| EP0961253A2 (en) | Product activity data collection system | |
| CN110060123A (en) | Based under line to the wholesale operation management system on line | |
| CN115471126A (en) | E-commerce ERP system with expense estimation function | |
| Bragg | Inventory accounting: a comprehensive guide | |
| CN108846631A (en) | A kind of enterprise management system | |
| CN112465326A (en) | Big data integration management system | |
| US7418404B2 (en) | Commodity order acceptance and transportation system, method, and recording medium | |
| CN114462816A (en) | Enterprise ERP (enterprise resource planning) integrated management system based on Internet of things | |
| CN113205290A (en) | Supply chain management system applied to cold chain refrigeration house | |
| NZ542567A (en) | Consignment inventory management and reconciliation system | |
| CN114255011A (en) | Dining data processing method and device | |
| CN111126922A (en) | Dynamic backtracking query method and management system for home decoration store warehousing system | |
| KR20020001963A (en) | The electronic commerce system and method using enterprise resource planning | |
| CN112750006A (en) | Agricultural product transaction system, method, device and storage medium | |
| Zhao et al. | Transactional and in‐store display data of a large supermarket for data‐driven decision‐making | |
| CN111445174A (en) | Sales order management system | |
| RU2723144C1 (en) | Automated control system for sale of goods | |
| CN113988746A (en) | Shopping management system for enterprises | |
| JP2004145877A (en) | Information processing system, information processing method, information processing program and storage medium | |
| US20200364420A1 (en) | Autonomous rfid storage system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200508 |