Picking method and system based on two-dimensional code technology

Abstract

The invention discloses a receiving method and system based on a two-dimensional code technology, and relates to the technical field of information management. For office consumables of an enterprise, based on a two-dimensional code, the receiving process is executed as follows: S01, basic information of articles is maintained, S02, user information including user accounts, user names, departments to which the articles belong and user type information to which the user information belong is maintained, S03, receiving quotas are set for all materials of the departments in a year, and S04, approvers and approval processes of all the departments are maintained. The method comprises the steps of S05, maintaining goods allocation, physical inventory, safe inventory, maximum inventory, minimum inventory, goods ABC classification information and goods allocation two-dimensional codes of goods, S06, maintaining the number of receiving reminding days, the number of automatic cancellation days and a short message notification template, and S07, through a terminal, according to the user permission, according to the user permission, sending the goods to the terminal. The method comprises the following steps: S01, checking the maintained information with the authority, S08, carrying out article receiving in a warehouse by receiving a single two-dimensional code, S09, enabling the maintained A-class articles to reach a safe stock, and S10, checking an overall link of the articles from warehousing to receiving and delivery.

Description

TECHNICAL FIELD

[0001] The application discloses a taking method and system based on a two-dimensional code technology, and relates to the technical field of information management. BACKGROUND

[0002] The existing offline taking system, such as paper registration, Excel table management or simple local software, gradually exposes many shortcomings in modern enterprise operation, for example:

[0003] Low efficiency, time-consuming and laborious: manual operation is tedious, inefficient and prone to errors; process delay: it is necessary to find the person in charge for signature approval offline, and it takes a long time to cross-department cooperation, which affects the business response speed.

[0004] Difficult data management: information is scattered, and it is difficult to query and aggregate; update lag, data cannot be synchronized in real time; lack of analysis capability: it is difficult to generate statistical reports or analyze taking trends, which is not conducive to optimizing resource allocation.

[0005] Error-prone and vulnerable: manual entry is prone to missed, repeated registration or data errors; difficult to trace responsibility: paper records are easy to lose, alter or forge, and it is difficult to trace responsibility when disputes occur; security risk: Excel files may cause data loss due to accidental deletion, no backup or version confusion.

[0006] Inventory and resource management problems: inventory is not transparent: real-time monitoring of inventory dynamics is not possible, which may lead to excessive taking or inventory shortage; resource waste: due to lack of use data, it is difficult to optimize procurement or deployment plan, resulting in idle or repeated procurement; security and compliance risk: weak permission control: offline system is difficult to set fine-grained permissions; audit difficulty: lack of complete operation log, unable to meet the requirements of compliance audit.

[0007] Poor user experience: the taker needs to be present for registration, and remote or cross-region scenarios cannot be operated; feedback delay: the approval status, inventory balance and other information cannot be queried in real time, and the communication cost is high. SUMMARY

[0008] The application provides a taking method and system based on two-dimensional code technology, aiming at the problems of the prior art, which uses two-dimensional code technology to realize the overall paperless of the taking system, realizes the visualization and traceability of data, and realizes the dynamic adjustment of inventory through ABC intelligent replenishment. The existing taking process is upgraded to an efficient, transparent and traceable digital management mode, which is suitable for various scenes such as enterprises and schools, and helps to reduce cost and increase efficiency.

[0009] The specific scheme provided by the application is:

[0010] The application provides a taking method based on two-dimensional code technology, which is based on two-dimensional code to execute the taking process for office supplies of an enterprise:

[0011] S01: Maintain basic information about the items, including item code, item name, item category, specifications, model, manufacturer, price, warehouse, department, eligible user type, and dispatch cycle information.

[0012] S02: Maintain user information, including user account, username, department, and user type information.

[0013] S03: Set requisition limits for each material in the department for the year. Options include overall control of the total amount or control at the material level to manage the overall budget for a specific material in a given year.

[0014] S04: Maintain approvers and approval processes for each department, and guide the workflow through different branches based on the total unit price or overall amount of each material in the application, and the user type.

[0015] S05: Maintain the item's location, physical inventory, safety stock, maximum inventory, minimum inventory, item ABC classification information, and location QR code.

[0016] S06: Maintain the number of days for requisition reminders, the number of days for automatic expiration, and the SMS notification template.

[0017] S07: Through the terminal, based on user permissions, view the information maintained with which you have the authority, including basic information on inventory and warehouse items. Add items to the requisition form as needed. When submitting, call the maintained departmental budget. If the budget is exceeded, submission is not allowed; otherwise, invoke the unified pending process and notify the approver via SMS or notification to process the approval. Create a requisition form QR code.

[0018] S08: Use the QR code on the requisition form to retrieve items from the warehouse.

[0019] S09: Once the maintained Category A items have reached safety stock levels, calculate the required procurement quantity based on the ABC classification model, send a text message reminder to the purchasing staff, place an order with the supplier, and after the supplier delivers the goods, store them in the corresponding storage location.

[0020] S10: View the entire process from item receipt to item issuance.

[0021] Furthermore, in S02 of the QR code-based requisition method, the subsequent requisition process verifies the logged-in user's department and account, compares it with the department and eligible user type in the basic information, and filters out materials that only belong to the user type that matches the logged-in user's department, thereby realizing the division of permissions.

[0022] Furthermore, in step S07 of the QR code-based requisition method, after approval via mobile phone, all user applications are sorted according to the approval time, and the inventory is locked in the warehouse according to the principle of first-approval, first-requisition.

[0023] If the requisition form is approved but the goods are not requisitioned within the specified reminder period, a text message will be sent to the requisitioning person to remind them. If the automatic cancellation period is exceeded, the locked inventory will be automatically released, and the requisition form will be voided.

[0024] If the inventory is sufficient, a requisition form QR code will be generated immediately. After scanning the QR code, the creation date, specific item name, and quantity information of the requisition form can be viewed. The QR code status will be "pending requisition". If the inventory is insufficient, a requisition form QR code will not be generated immediately. Instead, a notification will be sent to the person requisitioning the item via SMS, and a notification will also be sent to the purchasing staff via SMS, indicating that the inventory is insufficient and an order needs to be placed.

[0025] Summarize the requisition forms, calculate the materials with insufficient inventory based on all requisition quantities minus inventory quantities plus in-transit quantities, and generate orders directly based on the calculated quantities.

[0026] Furthermore, in step S08 of the aforementioned QR code-based requisition method, the materials in the requisition form are displayed by scanning the QR code using a mobile device. Based on the location information, the quantity and location information of all items in that location are obtained by scanning the QR code on the shelf.

[0027] After the items are handed over to the recipient, the item is issued and the status of the QR code is changed to "received". If the QR code is scanned again, a message will appear: "This QR code has been used and cannot be used again".

[0028] This invention also provides a requisition system based on QR code technology, including a basic file module, an access control module, a budget management module, a unified approval module, an intelligent warehousing module, a notification and early warning module, a requisition module, and a data traceability module.

[0029] For office supplies used by enterprises, the requisition process is based on QR codes:

[0030] The basic file module maintains basic information about items, including item code, item name, item category, specifications, model, manufacturer, price, warehouse, department, eligible user type, and transportation cycle information.

[0031] The access control module maintains user information, including user account, username, department, and user type.

[0032] The budget management module sets requisition limits for various materials within a department for the year. This allows for either overall control of the total amount or management at the material level, controlling the overall budget limit for a specific material in a particular year.

[0033] The unified approval module maintains the approvers and approval processes of each department, and follows different branches in the workflow based on the total amount of each material unit price or the overall amount, and the user type.

[0034] The intelligent warehousing module maintains the location, physical inventory, safety stock, maximum inventory, minimum inventory, ABC classification information of items, and location QR codes.

[0035] The notification and early warning module maintains the number of days for requisition reminders, the number of days for automatic expiration, and SMS notification templates.

[0036] The requisition module allows users to view and maintain authorized information via the terminal, including basic information on inventory and warehouse items. Items are added to the requisition form as needed. Upon submission, the maintained departmental budget is accessed. If the budget is exceeded, submission is denied; otherwise, a unified pending workflow is invoked, notifying the approver via SMS or notification for approval. A requisition form QR code is also created.

[0037] The requisition module allows users to retrieve items from the warehouse using a requisition slip QR code.

[0038] Once the A-class items maintained by the requisition module reach safety stock levels, the required procurement quantity is calculated based on the ABC classification model. A text message reminder is sent to the purchasing personnel, and an order is placed with the supplier. After the supplier delivers the goods, they are stored in the corresponding warehouse location.

[0039] The data traceability module allows you to view the entire process of items from entry into the warehouse to issuance and release.

[0040] Furthermore, the access control module of the QR code-based requisition system verifies the department and account of the logged-in user during the subsequent requisition process, compares it with the department and eligible user type in the basic information, and filters out materials that only belong to the user type that matches the logged-in user's department, thereby realizing access control.

[0041] Furthermore, in the requisition module of the QR code-based requisition system, after approval via mobile phone, all user applications are sorted according to the approval time, and the inventory is locked in the warehouse according to the principle of first-approval, first-requisition.

[0042] If the requisition form is approved but the goods are not requisitioned within the specified reminder period, a text message will be sent to the requisitioning person to remind them. If the automatic cancellation period is exceeded, the locked inventory will be automatically released, and the requisition form will be voided.

[0043] If the inventory is sufficient, a requisition form QR code will be generated immediately. After scanning the QR code, the creation date, specific item name, and quantity information of the requisition form can be viewed. The QR code status will be "pending requisition". If the inventory is insufficient, a requisition form QR code will not be generated immediately. Instead, a notification will be sent to the person requisitioning the item via SMS, and a notification will also be sent to the purchasing staff via SMS, indicating that the inventory is insufficient and an order needs to be placed.

[0044] Summarize the requisition forms, calculate the materials with insufficient inventory based on all requisition quantities minus inventory quantities plus in-transit quantities, and generate orders directly based on the calculated quantities.

[0045] Furthermore, the requisition module of the QR code-based requisition system allows users to scan a QR code using a mobile device. The system then displays the materials listed on the requisition form. Based on the storage location information, scanning a QR code on the shelf retrieves the quantity and location information of all items at that location.

[0046] After the items are handed over to the recipient, the item is issued and the status of the QR code is changed to "received". If the QR code is scanned again, a message will appear: "This QR code has been used and cannot be used again".

[0047] The advantages of this invention are:

[0048] This invention utilizes QR codes to requisition materials, achieving one code per order, enabling full traceability and preventing unauthorized or excessive requisitions. It further achieves a completely paperless requisition process, visualizes data, and dynamically adjusts inventory through ABC intelligent replenishment. This upgrades the requisition process to an efficient, transparent, and traceable digital management model, suitable for various scenarios such as enterprises and schools, helping to reduce costs and increase efficiency. It optimizes resource allocation and strengthens managers' overall control over requisition budgets. Attached Figure Description

[0049] Figure 1 This is a schematic diagram of the system business architecture of the present invention.

[0050] Figure 2 This is a schematic diagram of the requisition process. Detailed Implementation

[0051] The present invention will be further described below with reference to the accompanying drawings and specific embodiments, so that those skilled in the art can better understand and implement the present invention. However, the embodiments described are not intended to limit the present invention.

[0052] Example 1

[0053] This invention provides a method for requisitioning office supplies based on QR code technology, which enables the requisition process to be executed using QR codes.

[0054] S01: Maintain basic information about items, including item code, item name, item category, specifications, model, manufacturer, price, warehouse, department, type of user who can receive the item, and dispatch cycle information.

[0055] S02: Maintain user information, including user account, username, department, and user type. In the subsequent application process, the department and account of the logged-in user are verified and compared with the department and eligible user type in the basic information. Materials that belong only to the user type of the logged-in user and the department of the logged-in user are filtered out, thereby realizing the division of permissions.

[0056] S03: Set requisition limits for each material in the department for the year. This allows for either overall control of the total amount or control at the material level, limiting the overall budget for a specific material in a given year. Subsequent application processes will then control the department's overall budget based on the material or year, achieving financial budget management.

[0057] S04: Maintain approvers and approval processes for each department. Based on the total amount of each material unit price or the overall amount, and the user type, different branches can be traversed in the workflow to achieve automatic approval.

[0058] S05: Maintain the location, physical inventory, safety stock, maximum inventory, minimum inventory, ABC classification information of items, and location QR code.

[0059] S06: Maintain the number of days for requisition reminders, the number of days for automatic cancellation, and the SMS notification template.

[0060] S07: Through the terminal, users can view the information they have the authority to maintain, including basic information on inventory and warehouse items. As needed, items can be added to the requisition form. When submitting, the maintained departmental budget is called. If the budget is exceeded, the submission is not allowed. Otherwise, the unified pending process is called, and the approver is notified by SMS or notification to approve the process. A requisition form QR code is also created.

[0061] After approval via mobile phone, all user applications are sorted according to the approval time, and the inventory is locked in the warehouse on a first-come, first-served basis.

[0062] If the requisition form is approved but the goods are not requisitioned within the specified reminder period, a text message will be sent to the requisitioning person to remind them. If the automatic cancellation period is exceeded, the locked inventory will be automatically released, and the requisition form will be voided.

[0063] If the inventory is sufficient, a requisition form QR code will be generated immediately. After scanning the QR code, the creation date, specific item name, and quantity information of the requisition form can be viewed. The QR code status will be "pending requisition". If the inventory is insufficient, a requisition form QR code will not be generated immediately. Instead, a notification will be sent to the person requisitioning the item via SMS, and a notification will also be sent to the purchasing staff via SMS, indicating that the inventory is insufficient and an order needs to be placed.

[0064] Summarize the requisition forms, calculate the materials with insufficient inventory based on all requisition quantities minus inventory quantities plus in-transit quantities, and generate orders directly based on the calculated quantities.

[0065] S08: Items are retrieved from the warehouse via the QR code on the requisition form. This involves scanning the QR code with a mobile device to display the materials listed on the requisition form, and then scanning the QR code on the shelf according to the storage location information to obtain the quantity and location information of all items at that location.

[0066] After the items are handed over to the recipient, the item is issued and the status of the QR code is changed to "received". If the QR code is scanned again, a message will appear: "This QR code has been used and cannot be used again".

[0067] S09: The maintained Class A items have reached the safety stock level. According to the ABC classification model, and based on the formula:

[0068] The maximum inventory level minus the in-transit quantity plus the minimum inventory level is used to calculate the required purchase quantity. A text message is sent to the purchasing staff to remind them, and an order is placed with the supplier. After the supplier delivers the goods, they are stored in the corresponding warehouse location.

[0069] S10: View the entire process from item receipt to item issuance.

[0070] Example 2

[0071] This invention also provides a requisition system based on QR code technology, including a basic file module, an access control module, a budget management module, a unified approval module, an intelligent warehousing module, a notification and early warning module, a requisition module, and a data traceability module.

[0072] For office supplies used by enterprises, the requisition process is based on QR codes:

[0073] The basic file module maintains basic information about items, including item code, item name, item category, specifications, model, manufacturer, price, warehouse, department, eligible user type, and transportation cycle information.

[0074] The access control module maintains user information, including user account, username, department, and user type.

[0075] The budget management module sets requisition limits for various materials within a department for the year. This allows for either overall control of the total amount or management at the material level, controlling the overall budget limit for a specific material in a particular year.

[0076] The unified approval module maintains the approvers and approval processes of each department, and follows different branches in the workflow based on the total amount of each material unit price or the overall amount, and the user type.

[0077] The intelligent warehousing module maintains the location, physical inventory, safety stock, maximum inventory, minimum inventory, ABC classification information of items, and location QR codes.

[0078] The notification and early warning module maintains the number of days for requisition reminders, the number of days for automatic expiration, and SMS notification templates.

[0079] The requisition module allows users to view and maintain authorized information via the terminal, including basic information on inventory and warehouse items. Items are added to the requisition form as needed. Upon submission, the maintained departmental budget is accessed. If the budget is exceeded, submission is denied; otherwise, a unified pending workflow is invoked, notifying the approver via SMS or notification for approval. A requisition form QR code is also created.

[0080] The requisition module allows users to retrieve items from the warehouse using a requisition slip QR code.

[0081] Once the A-class items maintained by the requisition module reach safety stock levels, the required procurement quantity is calculated based on the ABC classification model. A text message reminder is sent to the purchasing personnel, and an order is placed with the supplier. After the supplier delivers the goods, they are stored in the corresponding warehouse location.

[0082] The data traceability module allows you to view the entire process of items from entry into the warehouse to issuance and release.

[0083] The information interaction and execution process between the modules in the above system are based on the same concept as the method embodiment of the present invention, and the specific details can be found in the description in the method embodiment of the present invention, and will not be repeated here.

[0084] Similarly, this invention's system utilizes QR codes to requisition materials, achieving one code per order, enabling full traceability and preventing unauthorized or excessive requisitions. Furthermore, it achieves complete paperless requisitioning, data visualization, and dynamic inventory adjustment through ABC intelligent replenishment. This upgrades the requisition process to an efficient, transparent, and traceable digital management model, suitable for various scenarios such as enterprises and schools, helping to reduce costs and increase efficiency. It optimizes resource allocation and strengthens managers' overall control over requisition budgets.

[0085] It should be noted that not all steps and modules in the above processes and system structures are mandatory; some steps or modules can be omitted as needed. The execution order of each step is not fixed and can be adjusted as required. The system structures described in the above embodiments can be physical or logical structures. That is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or they may be jointly implemented by certain components in multiple independent devices.

[0086] The above-described embodiments are merely preferred embodiments provided to fully illustrate the present invention, and the scope of protection of the present invention is not limited thereto. Equivalent substitutions or modifications made by those skilled in the art based on the present invention are all within the scope of protection of the present invention. The scope of protection of the present invention is defined by the claims.

Claims

1. A method for issuing based on two-dimensional code technology, characterized in that For the office supplies of enterprises, the taking process is executed based on two-dimensional code: S01: maintaining the basic information of the articles, including article code, article name, article classification, specification, model, manufacturer, price, belonging warehouse, department attribution, available user type, and transfer cycle information, S02: maintaining user information, including user account, user name, belonging department, and belonging user type information, S03: setting taking quota for each material of the department in a year, in which the total amount is controlled by overall control or the overall budget quota of a certain material in a year is controlled to the material dimension, S04: maintaining the approvers and approval process of each department, and different branches are selected in the workflow according to the total amount of the application of each material or the total amount, user type, S05: maintaining the location of the articles, physical inventory, safety stock, maximum stock, minimum stock, article ABC classification information, and location two-dimensional code, S06: maintaining the taking reminder days, automatic invalidation days, and SMS notification template, S07: through the terminal, the user can view the information with the right to maintain, including the inventory and the basic information of the warehouse articles, add the articles to the taking list as needed, and call the department budget maintained when submitting. If the budget is exceeded, the submission is not allowed. Otherwise, the unified to-do process is called, the approver is notified for process approval through SMS or notification, and the taking list two-dimensional code is created, S08: through the taking list two-dimensional code, the articles are taken in the warehouse, S09: when the A-class articles reach the safety stock, the quantity to be purchased is calculated according to the ABC classification mode, and the SMS is sent to the purchaser to remind the purchase, and the supplier is ordered. After the arrival of the supplier, the goods are stored in the corresponding location, S10: viewing the overall link of the articles from storage to taking and delivery.

2. The method according to claim 1, wherein the method is characterized in that In S02, the subsequent application process is verified by the department and account of the logged-in user, compared with the belonging department and available user type in the basic information, and the materials of the user type that only belong to the department and the logged-in user are filtered, so as to realize the division of rights.

3. The method according to claim 1, wherein the method is characterized by In S07, after the approval through the mobile phone, all user application lists are sorted according to the time of approval through, and the inventory is locked in the warehouse according to the principle of first approval and first taking, If the taking reminder days are not taken after the approval of the taking list, the SMS is sent to the taker for reminding, and if the automatic invalidation days are exceeded, the locked inventory is automatically released, and the taking list is invalidated, If the inventory is sufficient, the taking list two-dimensional code is generated immediately, the creation date of the taking list, the specific article name, and the article quantity information can be viewed after scanning the two-dimensional code, and the two-dimensional code state is in the taking state. If the inventory is insufficient, the taking list two-dimensional code is not generated immediately, and the SMS is sent to the taker for prompting, and the SMS is also sent to the purchaser to prompt that the inventory is insufficient and needs to be ordered. The taking list is summarized, the materials with insufficient inventory are calculated according to all taking quantity-inventory quantity+in-transit quantity, and the order is directly generated according to the calculated quantity.

4. The method according to claim 1, wherein the method is characterized by S08 scans the two-dimensional code through the mobile phone device, displays the materials in the taking list, acquires the quantity and position information of all the items on the shelf according to the storage location information, After the items are handed over to the taking personnel, the warehouse-out operation is performed, and the state of the two-dimensional code is changed to taken, if the two-dimensional code is scanned again, it will be prompted that this two-dimensional code has been taken and cannot be taken repeatedly.

5. A system for issuing a document based on two-dimensional code technology, characterized by It includes a basic file module, a permission control module, a budget management module, a unified approval module, an intelligent storage module, a notification and early warning module, a taking module, and a data traceability module, For the office supplies of an enterprise, a taking process is performed based on a two-dimensional code: The basic file module maintains the basic information of the items, including item code, item name, item classification, specification, model, manufacturer, price, belonging warehouse, department affiliation, available user type, and transfer cycle information, The permission control module maintains user information, including user account, user name, belonging department, and belonging user type information, The budget management module sets the taking limit of each material for a department in a year, which can be selected as overall amount control or maintained to the material dimension to control the overall budget limit of a certain material in a year, The unified approval module maintains the approvers and approval process of each department, and different branches are selected in the workflow according to the total amount of each material or the total amount of the user type, The intelligent storage module maintains the storage location, physical inventory, safety inventory, maximum inventory, minimum inventory, item ABC classification information, and storage location two-dimensional code of the items, The notification and early warning module maintains the taking reminder days, automatic invalidation days, and SMS notification template, The taking module views the information with permission through the terminal according to the user permission, including the inventory and basic information of the warehouse items, adds the items to the taking list as needed, calls the department budget when submitting, does not allow submission if the budget is exceeded, otherwise, calls the unified to-be-done process, notifies the approver for process approval through SMS or notification, and creates a taking list two-dimensional code, The taking module takes the items in the warehouse through the taking list two-dimensional code, The A-class items maintained by the taking module reach the safety inventory, the quantity to be purchased is calculated according to the ABC classification mode, an SMS is sent to the purchaser to remind, and the supplier is ordered, the supplier delivers the goods to the corresponding storage location after arrival, The data traceability module views the overall link of the items from warehousing to taking and warehousing-out.

6. The system according to claim 5, wherein the system is characterized in that The permission control module checks the department and account of the logged-in user in the subsequent taking process, compares it with the belonging department and available user type in the basic information, filters the materials that only belong to the department and the user type of the logged-in user, and thus realizes the division of permissions.

7. The system according to claim 5, wherein the system is characterized in that After the taking module is approved through the mobile phone, all user application forms are sorted according to the approval time, and the inventory is locked in the warehouse according to the principle of first approval and first taking, If the taking is not performed within the taking reminder days after the taking list is approved, an SMS is sent to the taker for reminding, and if the automatic invalidation days are exceeded, the locked inventory is automatically released, and the taking list is invalidated. If the inventory is sufficient, the receipt voucher two-dimensional code is generated immediately, and after scanning the two-dimensional code, the creation date of the receipt voucher, the specific item name, and the item quantity information can be viewed, and the two-dimensional code state is in the state of waiting for use. If the inventory is insufficient, the receipt voucher two-dimensional code is not generated immediately, and a short message is sent to the user for prompt, and a short message is also sent to the procurement personnel to prompt that the inventory is insufficient and needs to be ordered. The receipt vouchers are summarized, the inventory insufficient materials are calculated according to all the use-quantity-inventory+in-transit quantity, and the order is directly generated according to the calculated quantity.

8. The system according to claim 5, wherein the system is characterized by The use module scans the two-dimensional code through the mobile device, the system displays the materials in the receipt voucher, and according to the location information, the quantity and position information of all the items on the shelf are obtained by scanning the two-dimensional code on the shelf, After the items are handed over to the user, the out-of-stock operation is performed, and the state of the two-dimensional code is changed to have been used. If the two-dimensional code is scanned again, it will be prompted that the two-dimensional code has been used and cannot be used repeatedly.

Images