CN112508475A - Inventory checking method and system for orthopedic medical instruments - Google Patents
Inventory checking method and system for orthopedic medical instruments Download PDFInfo
- Publication number
- CN112508475A CN112508475A CN202011310792.4A CN202011310792A CN112508475A CN 112508475 A CN112508475 A CN 112508475A CN 202011310792 A CN202011310792 A CN 202011310792A CN 112508475 A CN112508475 A CN 112508475A
- Authority
- CN
- China
- Prior art keywords
- inventory
- checking
- list
- mode
- shortage
- 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
- 230000000399 orthopedic effect Effects 0.000 title claims abstract description 20
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000012790 confirmation Methods 0.000 claims abstract description 11
- 238000012937 correction Methods 0.000 abstract description 2
- 238000003860 storage Methods 0.000 description 4
- 230000008676 import Effects 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000006735 deficit Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 229940079593 drug Drugs 0.000 description 1
- 239000003814 drug Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- -1 medical equipment Substances 0.000 description 1
- 230000000246 remedial effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000012795 verification Methods 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Software Systems (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses an inventory checking method and system for orthopedic medical instruments, relates to the technical field of medical instrument warehouse management, and aims to solve the problems that the existing inventory checking mode for medical articles is not suitable for orthopedic medical instruments and is not flexible enough. The key point of the technical scheme is that the checking mode is selected to be a monthly dial or daily checking; generating a temporary table to store the recorded stock information of the current system; checking the checking list, guiding the actual inventory information after checking into the temporary list, performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage, and updating the system inventory after manual confirmation. The invention provides a flexible data error correction adjustment mode aiming at the inventory counting mode of counting, delivering and warehousing, can greatly improve the working efficiency in enterprises and is convenient for enterprise management.
Description
Technical Field
The invention relates to the technical field of medical instrument warehouse management, in particular to an inventory checking method and system for orthopedic medical instruments.
Background
For the medical equipment management industry, most of the medical equipment production enterprises have a plurality of warehousing goods areas with inconsistent distribution areas, and how to uniformly and effectively manage the scattered warehousing goods areas, reduce the inventory cost and improve the operation efficiency is a challenge that the medical equipment management enterprises must face.
The existing method for managing inventory in the medical industry mainly aims at two stages of warehouse-out and warehouse-in, and when warehouse-in, the inventory is delivered to a designated warehouse location according to the type of the stock, and code scanning and warehouse-in are carried out according to the bar code. And if the product is off shelf, scanning the code at the designated storage position and discharging the product out of the storage.
The method is mainly applied to checking of materials such as medical equipment, medicines and fixed assets, and a calibration inventory checking mode aiming at the medical orthopedic instrument industry is not provided. The marketing characteristic of the orthopedic instrument industry is that the goods are delivered firstly and then the invoices are checked according to the actual consumption. For example, direct sales business needs to involve a plurality of products for one operation, but the products of which specifications and models are specifically needed are unknown, customers generally require a whole set of products to be stocked, the customers are placed in the warehouse according to actual consumption, and unused products are returned to the warehouse, so that inventory of goods and materials in the warehouse is complicated, and inventory errors are easy to occur. Therefore, the above inventory count approach cannot be adapted to unique business models in the orthopedic appliance industry. Meanwhile, the existing checking mode is not flexible enough, for example, the checking in the range can not be carried out on the condition that a customer designates a goods area and a designated product according to the size and the class, and the like, so that the working efficiency and the operation cost of an enterprise are greatly influenced.
Disclosure of Invention
The invention aims to provide a method and a system for inventory checking of orthopedic medical instruments, which provide a flexible data error correction adjustment mode aiming at an inventory counting mode of counting, delivering and warehousing, and adjust inventory in time, thereby greatly improving the working efficiency in enterprises and facilitating the management of the enterprises.
The above object of the present invention is achieved by the following technical solutions:
an inventory count method for orthopedic medical devices, comprising the steps of:
selecting an inventory mode, generating an inventory list comprising all stock articles in a goods area when the inventory mode is monthly inventory, and determining an inventory range according to a specified inventory condition and generating a corresponding inventory list when the inventory mode is daily inventory;
generating a temporary table to store the recorded stock information of the current system;
checking the checking list, guiding the actual inventory information after checking into the temporary list, performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage, and updating the system inventory after manual confirmation.
The invention is further configured to: the checking mode of checking by contrasting the checking list comprises manual checking and code scanning disc checking, wherein the manual checking is performed through manual checking, actual inventory information is filled, and the code scanning disc checking is performed through scanning a bar code on a real object through a code scanning gun for counting.
The invention is further configured to: and the step of updating the system inventory after manual confirmation comprises the steps of manually adjusting according to the results of the inventory balance and the inventory shortage, then verifying and confirming, and updating the system inventory according to the confirmed results.
The invention is further configured to: and the step of updating the system inventory after manual confirmation comprises the steps of deleting the inventory shortage data to generate the inventory shortage list from the system inventory and counting the inventory shortage data to generate the inventory surplus list into the system inventory.
The invention is further configured to: the inventory list comprises product names, product numbers and system record inventory numbers corresponding to the products and actual inventory numbers.
The invention is further configured to: the checking list comprises a checking order number, a checking person, checking time, a checking mode and a checking mode.
The second aim of the invention is realized by the following technical scheme:
an inventory count system for orthopedic medical devices, comprising:
the checking mode selection module is used for enabling a user to select a checking mode, generating a checking list comprising all stock goods types in the goods area when the checking mode is monthly checking, and determining a checking range according to a specified checking condition and generating a corresponding checking list when the checking mode is daily checking;
the temporary table generating module is used for storing the recording inventory information of the current system into a temporary table;
the difference comparison module is used for importing the actual inventory information after inventory into the temporary table, and performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage; and the number of the first and second groups,
and the updating module is used for updating the system inventory after manually confirming the total inventory of the goods area and the inventory shortage.
In conclusion, the beneficial technical effects of the invention are as follows:
through monthly inventory and daily inventory, the inventory of the enterprise storage goods area can be adjusted, the inventory of products in the actual inventory but not in the system is subjected to excess inventory treatment, the inventory of products in the actual inventory but not in the system is subjected to deficiency inventory treatment, and in addition to the method for calculating the inventory by taking the quantity of warehouse-in and warehouse-out as a statistical object, a remedial measure is provided for adjusting the inventory, so that the working efficiency in enterprises can be greatly improved, and the enterprise management is facilitated.
Drawings
Fig. 1 is a schematic overall structure diagram of a first embodiment of the present invention.
Detailed Description
Example one
Referring to fig. 1, the invention discloses an inventory checking method of orthopedic medical instruments, comprising the following steps:
and S1, selecting an inventory mode, generating an inventory list including all stock articles in the cargo area when the inventory mode is monthly inventory, and determining an inventory range according to a specified inventory condition and generating a corresponding inventory list when the inventory mode is daily inventory.
And S2, generating a temporary table and storing the record inventory information of the current system.
And S3, checking the checking list, introducing the actual inventory information after checking into the temporary list, performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage, and updating the system inventory after manual confirmation.
And the user selects a corresponding checking mode according to the service scene to correspondingly check the warehouse goods area, and if the user is at the end of the month, the user performs mass checking on warehouse inventory to select monthly checking. The inventory problem that the user finds in daily work needs to be checked and adjusted temporarily, daily inventory is selected, and the inventory checking mode is more flexible. In step S1, when the monthly statement is selected, the system automatically generates a "monthly statement" in which the statement data is recorded, and acquires data import temporary tables from the "monthly statement" in the system. After selecting daily inventory, the user designates the inventory range, and the screening conditions include the goods shelf, the commuting unit, the brand, the series, the specification and the model, and the like. After the checking range is specified, the system generates a daily checking table, the checking data is recorded into the daily checking table, and the system acquires data from the daily checking table and imports the data into a temporary table. When the daily inventory is selected, the range of the temporary table is limited in the range of the inventory designated by the user, so that the statistical data are reduced, and the analysis is convenient.
The inventory list comprises product names, product numbers and system record inventory quantity and actual inventory quantity corresponding to the products. The checking list also comprises a checking order number, a checking person, checking time, a checking mode and a checking mode. The inventory list can be kept as a work record, so that the historical inventory record can be conveniently traced, and the inventory process is more transparent.
In step S3, the checking method for checking against the checking list includes manual checking and code scanning checking. Manual checking is performed through manual counting, and actual inventory information is filled. When manual checking is carried out, the checking list can be printed as a paper checking list, and after data is filled according to actual checking, the data is recorded into an electronic file so that a system can acquire the data. The code scanning and stacking points scan the bar codes on the real objects through the code scanning gun to count, and the system can analyze the batch number information of the products according to the bar code rule. And the code scanning disc points can be simultaneously scanned by a plurality of persons, and the code scanning information is uploaded by a user after the code scanning is finished.
In step S3, the operation step of updating the system inventory after manual confirmation includes manually performing adjustment according to the results of the total of the excess and the deficit, then verifying and confirming, and updating the system inventory according to the confirmed results. Meanwhile, the step of updating the system inventory after manual confirmation further comprises the steps of deleting the inventory shortage data generation inventory shortage list from the system inventory and calculating the inventory shortage data generation inventory shortage list into the system inventory.
The implementation principle of the above embodiment is as follows: the system inputs actual stock into the inventory list through manual inventory or code scanning inventory, guides data in the inventory list into the temporary list for difference comparison, and automatically calculates inventory balance and inventory shortage total of a storage goods area. And the user adjusts the specific batch number of the product according to the judgment result of the system, and finally clicks for confirmation after verification, the system deletes the inventory shortage data generation inventory shortage list from the system inventory according to the selection of the user, and the inventory shortage data generation inventory shortage list is added into the system inventory.
Example two
The invention discloses an inventory checking system of orthopedic medical instruments, which comprises:
the checking mode selection module is used for enabling a user to select a checking mode, generating a checking list comprising all stock goods types in the goods area when the checking mode is monthly checking, and determining a checking range according to a specified checking condition and generating a corresponding checking list when the checking mode is daily checking;
the temporary table generating module is used for storing the recording inventory information of the current system into a temporary table;
the difference comparison module is used for importing the actual inventory information after inventory into a temporary table, and performing difference comparison with the recorded inventory information to obtain the inventory excess and inventory shortage of the goods area; and the number of the first and second groups,
and the updating module is used for updating the system inventory after manually confirming the total inventory of the goods area and the inventory shortage. In the updating module, the user can adjust the specific batch number of the product according to the inventory balance and the inventory shortage sum
The embodiments of the present invention are preferred embodiments of the present invention, and the scope of the present invention is not limited by these embodiments, so: all equivalent changes made according to the structure, shape and principle of the invention are covered by the protection scope of the invention.
Claims (7)
1. An inventory checking method for orthopedic medical instruments, comprising the steps of:
selecting an inventory mode, generating an inventory list comprising all stock articles in a goods area when the inventory mode is monthly inventory, and determining an inventory range according to a specified inventory condition and generating a corresponding inventory list when the inventory mode is daily inventory;
generating a temporary table to store the recorded stock information of the current system;
checking the checking list, guiding the actual inventory information after checking into the temporary list, performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage, and updating the system inventory after manual confirmation.
2. The inventory count method for orthopedic medical devices as claimed in claim 1, wherein: the checking mode of checking by contrasting the checking list comprises manual checking and code scanning disc checking, wherein the manual checking is performed through manual checking, actual inventory information is filled, and the code scanning disc checking is performed through scanning a bar code on a real object through a code scanning gun for counting.
3. The inventory count method for orthopedic medical devices as claimed in claim 1, wherein: and the step of updating the system inventory after manual confirmation comprises the steps of manually adjusting according to the results of the inventory balance and the inventory shortage, then verifying and confirming, and updating the system inventory according to the confirmed results.
4. The inventory count method for orthopedic medical devices as claimed in claim 3, wherein: and the step of updating the system inventory after manual confirmation comprises the steps of deleting the inventory shortage data to generate the inventory shortage list from the system inventory and counting the inventory shortage data to generate the inventory surplus list into the system inventory.
5. The inventory count method for orthopedic medical devices as claimed in claim 1, wherein: the inventory list comprises product names, product numbers and system record inventory numbers corresponding to the products and actual inventory numbers.
6. The inventory count method for orthopedic medical devices as claimed in claim 5, wherein: the checking list comprises a checking order number, a checking person, checking time, a checking mode and a checking mode.
7. An inventory count system for orthopedic medical devices, comprising:
the checking mode selection module is used for enabling a user to select a checking mode, generating a checking list comprising all stock goods types in the goods area when the checking mode is monthly checking, and determining a checking range according to a specified checking condition and generating a corresponding checking list when the checking mode is daily checking;
the temporary table generating module is used for storing the recording inventory information of the current system into a temporary table;
the difference comparison module is used for importing the actual inventory information after inventory into the temporary table, and performing difference comparison with the recorded inventory information to obtain the total inventory of the goods area and the inventory shortage; and the number of the first and second groups,
and the updating module is used for updating the system inventory after manually confirming the total inventory of the goods area and the inventory shortage.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011310792.4A CN112508475A (en) | 2020-11-20 | 2020-11-20 | Inventory checking method and system for orthopedic medical instruments |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011310792.4A CN112508475A (en) | 2020-11-20 | 2020-11-20 | Inventory checking method and system for orthopedic medical instruments |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112508475A true CN112508475A (en) | 2021-03-16 |
Family
ID=74960006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011310792.4A Pending CN112508475A (en) | 2020-11-20 | 2020-11-20 | Inventory checking method and system for orthopedic medical instruments |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112508475A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113642966A (en) * | 2021-08-19 | 2021-11-12 | 重庆允成互联网科技有限公司 | Inventory method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046473A (en) * | 2015-08-28 | 2015-11-11 | 苏州市享乐惠信息科技有限公司 | Barcode-based warehouse management system |
| CN107909327A (en) * | 2017-12-11 | 2018-04-13 | 广东澳加医疗软件有限公司 | A kind of long-range check system and its checking method |
| CN110619492A (en) * | 2018-06-19 | 2019-12-27 | 珠海横琴盛达兆业科技投资有限公司 | Method for automatically generating excess and deficiency inventory during drug inventory |
| CN111126902A (en) * | 2019-12-12 | 2020-05-08 | 江苏苏宁物流有限公司 | Warehouse inventory method and device |
-
2020
- 2020-11-20 CN CN202011310792.4A patent/CN112508475A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046473A (en) * | 2015-08-28 | 2015-11-11 | 苏州市享乐惠信息科技有限公司 | Barcode-based warehouse management system |
| CN107909327A (en) * | 2017-12-11 | 2018-04-13 | 广东澳加医疗软件有限公司 | A kind of long-range check system and its checking method |
| CN110619492A (en) * | 2018-06-19 | 2019-12-27 | 珠海横琴盛达兆业科技投资有限公司 | Method for automatically generating excess and deficiency inventory during drug inventory |
| CN111126902A (en) * | 2019-12-12 | 2020-05-08 | 江苏苏宁物流有限公司 | Warehouse inventory method and device |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113642966A (en) * | 2021-08-19 | 2021-11-12 | 重庆允成互联网科技有限公司 | Inventory method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110009172B (en) | Asset full life cycle data modeling method based on SG-CIM model | |
| CN104778540B (en) | A kind of equipment for building materiaIs manufacturing BOM management method and management system | |
| EP1901215A1 (en) | Inventory management system and method | |
| US20080027835A1 (en) | Methods for maintaining inventory records between audit periods | |
| CN103679418A (en) | Nonstandard size cargo warehouse location matching management system | |
| US20080270269A1 (en) | Method for stock record verification for small inventory populations | |
| US20090144178A1 (en) | Consignment inventory management and reconciliation system | |
| Sellenheim | JI Case Company: performance measurement | |
| CN112397181A (en) | Medical consumable management method and system | |
| CN107103481A (en) | Equipment based on sequence number information processing system after sale | |
| CN111415733A (en) | Medical treatment consumptive material wisdom logistics system | |
| CN110378546B (en) | Method and apparatus for generating information | |
| CN107844923A (en) | A kind of ERP management systems and method | |
| CN112508475A (en) | Inventory checking method and system for orthopedic medical instruments | |
| CN112270513A (en) | Intelligent warehouse material monitoring and checking system | |
| JP2009289056A (en) | Device for supporting personnel arrangement planning | |
| CN112508314A (en) | Uygur medicine manufacturing execution system | |
| CN112950070A (en) | Management method and system for joint purchase and centralized distribution and supply of oral consumables | |
| CN105956810A (en) | Weighing manager | |
| CN112766849A (en) | Method and system for managing digital tags of full life cycles of associated storage materials | |
| CN108805504A (en) | Supplier deliver goods processing method and apply its system | |
| CN116384883A (en) | Production operation management system of electric energy metering equipment | |
| CN111597265A (en) | E-commerce commodity anti-counterfeiting traceability management system based on block chain | |
| CN113610494B (en) | Project material cost accounting system | |
| CN111563704A (en) | Warehouse inventory management 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 |