A bill storage method and system
By identifying and matching the bill data of the medical industry, judging drugs or consumables and generating inventory orders, the problem of mismatch in the medical industry's inventory data is solved, automated inventory is realized, and operation and management efficiency is improved.
Patent Information
- Application Number
- CN202411527004.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-30
- Publication Date
- 2025-02-18
- Estimated Expiration
- 2044-10-30
AI Technical Summary
During the process of purchasing and warehousing items in the medical industry, it is necessary to manually verify and match purchase orders, delivery orders and invoices, resulting in mismatch in data, increasing the difficulty of warehouse management statistics and not conducive to the operation and management of hospitals.
Provide a method and system for registration of bills. By identifying the valid data in the bills, determining whether it is a drug or medical consumable, and querying the preset registration table or conversion table, generating corresponding registration orders to realize automated registration.
It improves the efficiency and accuracy of data processing, shortens the inbound time, reduces manual verification errors, and improves the operation and management efficiency of the hospital.
Smart Images

Figure CN119049678B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a bill storage method and system. Background Art
[0002] In the existing medical industry, when hospitals need to purchase items, they place orders through the medical ordering system. The corresponding suppliers deliver the items needed by the hospital and provide delivery notes and invoices. The hospital needs to manually verify and match the purchase orders, delivery notes and invoices in the medical ordering system one by one. If the verification and matching are successful, the items and the corresponding data will be put into storage by the warehouse management. However, due to the strengthening of the management of medication and consumables in the medical industry and to avoid excessive use of medication and consumables, they are generally sold in pieces, which makes it inconsistent with the storage data, greatly increases the difficulty of warehouse management statistics, and is not conducive to the operation and management of the hospital. Summary of the invention
[0003] In view of this, an object of the present invention is to provide a bill storage method and system.
[0004] In order to achieve the above object, the technical solution adopted by the present invention is:
[0005] A bill storage method, applied to the medical industry, comprises the following steps:
[0006] S1, obtaining the bill to be stored, identifying whether the preset area in the bill contains valid data, if so, proceeding to step S2;
[0007] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0008] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0009] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0010] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0011] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0012] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0013] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0014] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0015] Furthermore, step S3 is specifically as follows:
[0016] Determine whether the drug name is a Western medicine name;
[0017] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0018] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0019] Step S4 is specifically as follows:
[0020] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0021] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0022] Furthermore, step S1 further includes:
[0023] If it is identified that the preset area in the bill does not contain valid data, it will be identified again after a preset time interval. When the number of identifications reaches a preset threshold, the identification failure information is output to the management end.
[0024] Furthermore, step S1 further includes:
[0025] Determine whether the bill is a valid bill, and if so, identify whether a preset area in the bill contains valid data.
[0026] Furthermore, step S1 further includes:
[0027] A purchase order is obtained from the medical ordering system, and the first valid information contained on the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; it is determined whether the matching result is successful, and if so, step S2 is entered.
[0028] A bill storage system includes a processor and a memory, wherein the memory stores a program or an instruction, and when the program or the instruction is executed by the processor, the following steps are implemented:
[0029] S1, obtaining the bill to be stored, identifying whether the preset area in the bill contains valid data, if so, proceeding to step S2;
[0030] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0031] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0032] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0033] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0034] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0035] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0036] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0037] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0038] Furthermore, when the program or instruction is executed by the processor, the following steps are also implemented:
[0039] Determine whether the drug name is a Western medicine name;
[0040] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0041] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0042] Step S4 is specifically as follows:
[0043] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0044] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0045] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0046] If it is identified that the preset area in the bill does not contain valid data, it will be identified again after a preset time interval. When the number of identifications reaches a preset threshold, the identification failure information is output to the management end.
[0047] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0048] Determine whether the bill is a valid bill, and if so, identify whether a preset area in the bill contains valid data.
[0049] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0050] A purchase order is obtained from the medical ordering system, and the first valid information contained on the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; it is determined whether the matching result is successful, and if so, step S2 is entered.
[0051] The beneficial effects of the present invention are:
[0052] The present invention provides a bill storage method and system, which first identifies the bill to be stored, identifies whether the preset area in the bill contains valid data, and determines whether it is a drug name or a medical consumables name in the case of valid data, and further determines whether the corresponding quantity unit is the minimum unit. If so, the corresponding storage order is generated according to the bill content and the storage is completed; if not, the corresponding storage order is generated after conversion according to the conversion relationship between the current quantity unit and the minimum unit in the corresponding unit conversion table and the storage is completed. The specific name is first determined to be effectively divided by the drug name and the medical consumables name, which can greatly reduce the subsequent data processing amount, thereby effectively improving the processing response rate. When the drug name is not in the preset drug minimum unit storage table or when the medical consumables name is not in the preset medical consumables minimum unit storage table, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates the corresponding storage order and completes the storage, which can further optimize the data processing mechanism. If a new drug name or medical consumables name is encountered, it can be perfectly processed through the above method. The above-mentioned overall approach to warehousing can effectively improve the efficiency of hospital operation and management. BRIEF DESCRIPTION OF THE DRAWINGS
[0053] Figure 1 The figure is a flow chart of the steps of a bill storage method of the present invention;
[0054] Figure 2 Shown is a structural block diagram of a bill storage system of the present invention;
[0055] Description of Figure Numbers:
[0056] 1-Processor; 2-Memory. DETAILED DESCRIPTION
[0057] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments:
[0058] like Figure 1 As shown, a bill storage method provided by the present invention is applied to the medical industry and includes the following steps:
[0059] S1, obtaining the bill to be stored, identifying whether the preset area in the bill contains valid data, if so, proceeding to step S2;
[0060] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0061] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0062] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0063] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0064] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0065] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0066] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0067] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0068] From the above description, it can be seen that the beneficial effects of the present invention are:
[0069] The present invention provides a bill storage method, which first identifies the bill to be stored, identifies whether the preset area in the bill contains valid data, and determines whether it is a drug name or a medical consumables name in the case of valid data, and further determines whether the corresponding quantity unit is the minimum unit. If so, the corresponding storage order is generated according to the bill content and the storage is completed; if not, the corresponding storage order is generated after conversion according to the conversion relationship between the current quantity unit and the minimum unit in the corresponding unit conversion table and the storage is completed. The specific name is first determined to be effectively divided by the drug name and the medical consumables name, which can greatly reduce the subsequent data processing amount, thereby effectively improving the processing response rate. When the drug name is not in the preset drug minimum unit storage table or when the medical consumables name is not in the preset medical consumables minimum unit storage table, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates the corresponding storage order and completes the storage, which can further optimize the data processing mechanism. If a new drug name or medical consumables name is encountered, it can be perfectly processed through the above method. The above-mentioned overall approach to warehousing can effectively improve the efficiency of hospital operation and management.
[0070] Furthermore, step S3 is specifically as follows:
[0071] Determine whether the drug name is a Western medicine name;
[0072] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0073] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0074] Step S4 is specifically as follows:
[0075] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0076] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0077] From the above description, it can be seen that by first determining whether the drug name is a Western medicine name or a Chinese medicine name and making an effective classification, the subsequent data processing volume can be greatly reduced, thereby effectively improving the processing response rate.
[0078] Furthermore, step S1 further includes:
[0079] If it is identified that the preset area in the bill does not contain valid data, it will be identified again after a preset time interval. When the number of identifications reaches a preset threshold, the identification failure information is output to the management end.
[0080] As can be seen from the above description, the above method can avoid omissions in only one identification, and multiple identifications can further ensure the effectiveness of identification. When the number of identifications reaches the preset threshold and no valid data can be identified, it can be determined that the bill does not have valid data. At this time, the identification failure information is output to the management end, so that the management end can intervene in time to ensure smooth execution.
[0081] Furthermore, step S1 further includes:
[0082] Determine whether the bill is a valid bill, and if so, identify whether a preset area in the bill contains valid data.
[0083] As can be seen from the above description, through the above method, the validity of the bills to be stored is first verified, and then subsequent operations are performed when the verification is successful, so as to ensure the validity of data processing.
[0084] Furthermore, step S1 further includes:
[0085] A purchase order is obtained from the medical ordering system, and the first valid information contained on the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; it is determined whether the matching result is successful, and if so, step S2 is entered.
[0086] From the above description, it can be seen that through the above method, three documents are matched if the verification is successful, where the three documents include valid documents (such as invoices), purchase orders and delivery notes. If the match is successful, proceed to the next step to improve the effectiveness of data processing.
[0087] See also Figure 2 As shown, a bill storage system provided by the present invention includes a processor 1 and a memory 2, wherein the memory 2 stores a program or instruction, and when the program or instruction is executed by the processor 1, the following steps are implemented:
[0088] S1, obtaining the bill to be stored, identifying whether the preset area in the bill contains valid data, if so, proceeding to step S2;
[0089] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0090] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0091] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0092] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0093] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0094] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0095] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0096] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0097] From the above description, it can be seen that the beneficial effects of the present invention are:
[0098] The present invention provides a bill entry system, which first identifies the bill to be entered, identifies whether the preset area in the bill contains valid data, and determines whether it is a drug name or a medical consumables name in the case of valid data, and further determines whether the corresponding quantity unit is the minimum unit. If so, the corresponding entry form is generated according to the bill content and the entry is completed; if not, the conversion is performed according to the conversion relationship between the current quantity unit and the minimum unit in the corresponding unit conversion table to generate the corresponding entry form and complete the entry. The specific name is first determined by effectively dividing it by the drug name and the medical consumables name, which can greatly reduce the subsequent data processing amount, thereby effectively improving the processing response rate. When the drug name is not in the preset drug minimum unit entry table or when the medical consumables name is not in the preset medical consumables minimum unit entry table, a confirmation request is sent to the entry end. When the confirmation information sent by the entry end is received, the bill generates the corresponding entry form and completes the entry, which can further optimize the data processing mechanism. For example, when a new drug name or medical consumables name is encountered, it can be perfectly processed by the above method. The above-mentioned overall approach to warehousing can effectively improve the efficiency of hospital operation and management.
[0099] Furthermore, when the program or instruction is executed by the processor, the following steps are also implemented:
[0100] Determine whether the drug name is a Western medicine name;
[0101] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0102] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0103] Step S4 is specifically as follows:
[0104] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0105] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0106] From the above description, it can be seen that by first determining whether the drug name is a Western medicine name or a Chinese medicine name and making an effective classification, the subsequent data processing volume can be greatly reduced, thereby effectively improving the processing response rate.
[0107] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0108] If it is identified that the preset area in the bill does not contain valid data, it will be identified again after a preset time interval. When the number of identifications reaches a preset threshold, the identification failure information is output to the management end.
[0109] As can be seen from the above description, the above method can avoid omissions in only one identification, and multiple identifications can further ensure the effectiveness of identification. When the number of identifications reaches the preset threshold and no valid data can be identified, it can be determined that the bill does not have valid data. At this time, the identification failure information is output to the management end, so that the management end can intervene in time to ensure smooth execution.
[0110] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0111] Determine whether the bill is a valid bill, and if so, identify whether a preset area in the bill contains valid data.
[0112] As can be seen from the above description, through the above method, the validity of the bills to be stored is first verified, and then subsequent operations are performed when the verification is successful, so as to ensure the validity of data processing.
[0113] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0114] A purchase order is obtained from the medical ordering system, and the first valid information contained on the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; it is determined whether the matching result is successful, and if so, step S2 is entered.
[0115] From the above description, it can be seen that through the above method, three documents are matched if the verification is successful, where the three documents include valid documents (such as invoices), purchase orders and delivery notes. If the match is successful, proceed to the next step to improve the effectiveness of data processing.
[0116] Several preferred embodiments or application examples are listed below to help those skilled in the art better understand the technical content of the present invention and the technical contribution made by the present invention relative to the prior art:
[0117] Preferred embodiment one:
[0118] like Figure 1 As shown, a bill storage method provided by the present invention is applied to the medical industry and includes the following steps:
[0119] S1. Use a high-speed scanner to quickly scan multiple stacked bills to be stored, and use existing bill verification technology to determine whether the bill is a valid bill. If so, use OCR recognition technology to identify whether a preset area in the bill contains valid data. If so, obtain a purchase order from the medical ordering system and extract the first valid information contained in the purchase order and the second valid information from the delivery note, and match the recognized valid data on the bill with the first valid information and the second valid information to obtain a matching result.
[0120] In this embodiment, a certain amount of bills are generally collected and stored in a unified manner. Therefore, after all the bills are entered and invalid bills are excluded, unified matching can be performed. At this time, all bills determined to be valid bills need to form a first bill set; determine whether there are duplicate bills in the first bill set. If so, only one duplicate bill is retained and the rest of the duplicate bills are deleted. Through the above steps, duplicate bills can be removed from the valid bills before matching and after successful verification, thereby ensuring the efficiency and accuracy of subsequent matching. The matching process is then carried out, and the specific matching method is:
[0121] Determine whether the dates in the valid data, the first valid information, and the second valid information are within a reasonable range. If so, determine whether the quantities in the valid data, the first valid information, and the second valid information match. If so, determine whether the amounts in the valid data, the first valid information, and the second valid information match. If so, determine whether the product information in the valid data, the first valid information, and the second valid information matches. If so, determine whether the supplier information in the valid data, the first valid information, and the second valid information matches. If so, determine that the matching result is successful.
[0122] Through the above steps, the specific matching contents of the three orders are realized, including date matching, quantity matching, amount matching, product information matching and supplier information matching. When all these contents are matched successfully, it is finally determined to be a successful match, ensuring the accuracy of the matching.
[0123] Determine whether the matching result is successful, if so, proceed to step S2. If it is recognized that the preset area in the bill does not contain valid data, recognize it again after a preset time interval, and when the number of recognitions reaches a preset threshold, output recognition failure information to the management end.
[0124] Through the above method, the validity of the bills to be stored is first verified, and subsequent operations are performed when the verification is successful to ensure the effectiveness of data processing. In the case of successful verification, three-document information matching is performed, where the three documents include valid bills (such as invoices), purchase orders, and delivery notes. In the case of successful matching, the next step is entered to further improve the effectiveness of data processing. At the same time, omissions in only one identification can be avoided, and multiple identifications can also further ensure the effectiveness of identification. When the number of identifications reaches the preset threshold and valid data cannot be identified, it can be determined that there is no valid data for the bill. At this time, the identification failure information is output to the management end, so that the management end can intervene in the processing in time to ensure smooth execution. In this embodiment, the preset threshold can be set to three or five times, which can be set according to actual needs.
[0125] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0126] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0127] In this embodiment, step S3 is specifically as follows:
[0128] Determine whether the drug name is a Western medicine name;
[0129] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0130] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0131] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0132] In this embodiment, step S4 is specifically as follows:
[0133] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0134] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0135] By first determining whether the drug name is a Western medicine or a Chinese medicine and making an effective classification, the amount of subsequent data processing can be greatly reduced, thereby effectively improving the processing response rate.
[0136] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0137] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0138] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0139] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0140] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0141] In this embodiment, the minimum unit entry table of drugs is used as an example for explanation. For example, the minimum unit of drug A is one stick, but the delivery note and invoice both say 1 box. Then, it needs to be converted to 8 sticks when entering the warehouse. The name of drug A and the minimum unit are used as the basis for whether conversion is required. If conversion is not required, it is directly entered into the warehouse; if conversion is required, it is entered into the warehouse after conversion. When the conversion rule is 1 box to 8 sticks, it will be converted to 8 sticks when entering the warehouse. This is because different users have different requirements for quantity statistics and usage. Therefore, adding the conversion of entry units is conducive to actual statistics.
[0142] In the actual warehousing process, you can also adopt a multi-level warehousing method, such as first-level warehousing, second-level warehousing, third-level warehousing, etc., which can be set according to the outbound requirements to facilitate rapid statistics after outbound delivery.
[0143] Preferred embodiment 2:
[0144] like Figure 2 As shown, a bill storage system provided by the present invention includes a processor 1 and a memory 2, wherein the memory 2 stores a program or instruction, and when the program or instruction is executed by the processor 1, the following steps are implemented:
[0145] S1, obtaining the bill to be stored, identifying whether the preset area in the bill contains valid data, if so, proceeding to step S2;
[0146] S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5;
[0147] S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry;
[0148] S4, determine whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table according to the preset first unit conversion table, convert the quantity unit corresponding to the drug name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; the first unit conversion table is used to store multiple drug names and the conversion relationship between the quantity unit corresponding to each drug name and the corresponding minimum unit;
[0149] S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6;
[0150] S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage;
[0151] S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table;
[0152] If so, a corresponding entry form is generated based on the bill and the entry is completed;
[0153] If not, then the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table is obtained according to the preset second unit conversion table, and the quantity unit corresponding to the medical consumables item is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; the second unit conversion table is used to store multiple medical consumables items and the conversion relationship between the quantity unit corresponding to each medical consumables item and the corresponding minimum unit.
[0154] Furthermore, when the program or instruction is executed by the processor, the following steps are also implemented:
[0155] Determine whether the drug name is a Western medicine name;
[0156] If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0157] If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it goes to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names; if not, a confirmation request is sent to the storage end, and when the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage;
[0158] Step S4 is specifically as follows:
[0159] If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit entry table; if so, generate a corresponding entry order based on the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the Western medicine name and the corresponding minimum unit in the preset Western medicine minimum unit entry table based on the preset first Western medicine unit conversion table, convert the quantity unit corresponding to the Western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry order and complete the entry; the first Western medicine unit conversion table is used to store multiple Western medicine names and the conversion relationship between the quantity unit corresponding to each Western medicine name and the corresponding minimum unit;
[0160] If the drug name is a traditional Chinese medicine name, determine whether the quantity unit corresponding to the traditional Chinese medicine name is the same as the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table; if so, generate a corresponding entry form according to the bill and complete the entry; if not, obtain the conversion relationship between the quantity unit corresponding to the traditional Chinese medicine name and the corresponding minimum unit in the preset traditional Chinese medicine minimum unit entry table according to the preset first traditional Chinese medicine unit conversion table, convert the quantity unit corresponding to the traditional Chinese medicine name into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry form and complete the entry; the first traditional Chinese medicine unit conversion table is used to store multiple traditional Chinese medicine names and the conversion relationship between the quantity unit corresponding to each traditional Chinese medicine name and the corresponding minimum unit.
[0161] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0162] If it is identified that the preset area in the bill does not contain valid data, it will be identified again after a preset time interval. When the number of identifications reaches a preset threshold, the identification failure information is output to the management end.
[0163] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0164] Determine whether the bill is a valid bill, and if so, identify whether a preset area in the bill contains valid data.
[0165] Furthermore, when the program or instruction is executed by the processor, the following steps are specifically implemented:
[0166] A purchase order is obtained from the medical ordering system, and the first valid information contained on the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; it is determined whether the matching result is successful, and if so, step S2 is entered.
[0167] The present invention has been described by the above-mentioned relevant embodiments and drawings, but the above-mentioned embodiments are only examples for implementing the present invention. It must be pointed out that the disclosed embodiments do not limit the scope of the present invention. On the contrary, modifications and equivalent settings included in the spirit and scope of the claims are all included in the scope of the present invention.
Claims
1. A bill storage method, applied to the medical industry, characterized in that: The following steps are involved: S1, obtain the bill to be stored, and use OCR recognition technology to identify whether the preset area in the bill contains valid data. If so, proceed to step S2; S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5; S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry; S4, determining whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; If so, a corresponding entry form is generated based on the bill and the entry is completed; If not, then the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table is obtained according to the preset first unit conversion table, and the quantity unit corresponding to the drug name is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry order is generated and the entry is completed; The first unit conversion table is used to store a plurality of drug names and the conversion relationship between the quantity units corresponding to each drug name and the corresponding minimum units; S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6; S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage; S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table; If so, a corresponding warehouse entry form is generated according to the bill and the warehouse entry is completed; If not, then obtain the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table according to the preset second unit conversion table, convert the quantity unit corresponding to the medical consumables item into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry order and complete the entry; The second unit conversion table is used to store a plurality of medical consumables items and the conversion relationship between the quantity units corresponding to each medical consumables item and the corresponding minimum units; Step S3 is specifically as follows: Determine whether the drug name is a Western medicine name; If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage; If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it proceeds to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names one by one; If not, a confirmation request is sent to the warehousing end. When the confirmation information sent by the warehousing end is received, the bill generates a corresponding warehousing order and completes the warehousing; Step S4 is specifically as follows: If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit storage table; If yes, then generate a corresponding entry form according to the bill and complete the entry; if no, then obtain the conversion relationship between the quantity unit corresponding to the western medicine name and the corresponding minimum unit in the preset western medicine minimum unit entry table according to the preset first western medicine unit conversion table, convert the quantity unit corresponding to the western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; The first western medicine unit conversion table is used to store a plurality of western medicine names and the conversion relationship between the quantity units corresponding to each western medicine name and the corresponding minimum units; If the drug name is a Chinese medicine name, determine whether the quantity unit corresponding to the Chinese medicine name is the same as the corresponding minimum unit in the preset Chinese medicine minimum unit storage table; If so, a corresponding warehouse entry form is generated according to the bill and the warehouse entry is completed; If not, then the conversion relationship between the quantity unit corresponding to the Chinese medicine name and the corresponding minimum unit in the preset Chinese medicine minimum unit entry table is obtained according to the preset first Chinese medicine unit conversion table, and the quantity unit corresponding to the Chinese medicine name is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; The first Chinese medicine unit conversion table is used to store a plurality of Chinese medicine names and the conversion relationship between the quantity units corresponding to each Chinese medicine name and the corresponding minimum units; Step S1 also includes: If it is identified that the preset area in the bill does not contain valid data, the bill is identified again after a preset time interval. When the number of identifications reaches a preset threshold, an identification failure message is output to the management terminal; Step S1 also includes: A high-speed scanner is used to quickly scan multiple stacked bills to be stored, and the bill verification technology is used to determine whether the bill is a valid bill. If so, all the bills determined to be valid bills are combined into a first bill set; it is determined whether there are duplicate bills in the first bill set. If so, only one duplicate bill is retained and the other duplicate bills are deleted, and then it is identified whether a preset area in the bill contains valid data; Step S1 also includes: A purchase order is obtained from a medical ordering system, and the first valid information contained in the purchase order is extracted, and the second valid information is extracted from the delivery note. The valid data identified on the bill is matched with the first valid information and the second valid information to obtain a matching result; wherein the matching method is: Determine whether the dates in the valid data, the first valid information, and the second valid information are within a reasonable range. If so, determine whether the quantities in the valid data, the first valid information, and the second valid information match. If so, determine whether the amounts in the valid data, the first valid information, and the second valid information match. If so, determine whether the product information in the valid data, the first valid information, and the second valid information matches. If so, determine whether the supplier information in the valid data, the first valid information, and the second valid information matches. If so, determine that the matching result is successful. Determine whether the matching result is successful, if so, proceed to step S2; The bill entry method sets up multi-level entry according to the requirements for exiting the warehouse, and the multi-level entry is to set up a minimum unit entry table and multiple secondary unit entry tables.
2. A bill storage system, characterized in that: The system comprises a processor and a memory, wherein the memory stores a program or an instruction, and when the program or the instruction is executed by the processor, the following steps are implemented: S1, obtain the bill to be stored, and use OCR recognition technology to identify whether the preset area in the bill contains valid data. If so, proceed to step S2; S2, determining whether the valid data includes the drug name and the quantity unit corresponding to the drug name, if yes, proceeding to step S3; if no, proceeding to step S5; S3, judging whether the drug name is in the preset drug minimum unit entry table, if so, proceeding to step S4; the drug minimum unit entry table is used to store multiple drug names and the minimum units corresponding to the drug names; if not, sending a confirmation request to the entry end, when receiving the confirmation information sent by the entry end, the bill generates a corresponding entry order and completes the entry; S4, determining whether the quantity unit corresponding to the drug name is the same as the corresponding minimum unit in the preset drug minimum unit entry table; If so, a corresponding entry form is generated based on the bill and the entry is completed; If not, then the conversion relationship between the quantity unit corresponding to the drug name and the corresponding minimum unit in the preset drug minimum unit entry table is obtained according to the preset first unit conversion table, and the quantity unit corresponding to the drug name is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry order is generated and the entry is completed; The first unit conversion table is used to store a plurality of drug names and the conversion relationship between the quantity units corresponding to each drug name and the corresponding minimum units; S5, determining whether the valid data includes the name of medical consumables and the quantity unit corresponding to the name of medical consumables, if so, proceeding to step S6; S6, judging whether the medical consumables item is in the preset medical consumables minimum unit storage table, if so, proceeding to step S7; the medical consumables minimum unit storage table is used to store multiple medical consumables items and the minimum units corresponding to the medical consumables items; if not, sending a confirmation request to the storage end, when receiving the confirmation information sent by the storage end, the bill generates a corresponding storage order and completes the storage; S7, determining whether the quantity unit corresponding to the medical consumables item is the same as the corresponding minimum unit in the preset medical consumables minimum unit entry table; If so, a corresponding warehouse entry form is generated according to the bill and the warehouse entry is completed; If not, then obtain the conversion relationship between the quantity unit corresponding to the medical consumables item and the corresponding minimum unit in the preset medical consumables minimum unit entry table according to the preset second unit conversion table, convert the quantity unit corresponding to the medical consumables item into the corresponding minimum unit according to the conversion relationship, generate the corresponding entry order and complete the entry; The second unit conversion table is used to store a plurality of medical consumables items and the conversion relationship between the quantity units corresponding to each medical consumables item and the corresponding minimum units; When the program or instruction is executed by the processor, the following steps are also implemented: Determine whether the drug name is a Western medicine name; If yes, it is determined whether the western medicine item is in the preset western medicine minimum unit storage table. If yes, it proceeds to step S4; the western medicine minimum unit storage table is used to store multiple western medicine items and the minimum units corresponding to the western medicine items one by one; if no, a confirmation request is sent to the storage end. When the confirmation information sent by the storage end is received, the bill generates a corresponding storage order and completes the storage; If not, it is determined whether the drug name is a Chinese medicine name; if so, it is determined whether the Chinese medicine name is in the preset Chinese medicine minimum unit storage table, and if so, it proceeds to step S4; the Chinese medicine minimum unit storage table is used to store multiple Chinese medicine names and the minimum units corresponding to the Chinese medicine names one by one; If not, a confirmation request is sent to the warehousing end. When the confirmation information sent by the warehousing end is received, the bill generates a corresponding warehousing order and completes the warehousing; Step S4 is specifically as follows: If the drug name is a Western medicine name, determine whether the quantity unit corresponding to the Western medicine name is the same as the corresponding minimum unit in the preset Western medicine minimum unit storage table; If yes, then generate a corresponding entry form according to the bill and complete the entry; if no, then obtain the conversion relationship between the quantity unit corresponding to the western medicine name and the corresponding minimum unit in the preset western medicine minimum unit entry table according to the preset first western medicine unit conversion table, convert the quantity unit corresponding to the western medicine name into the corresponding minimum unit according to the conversion relationship, generate a corresponding entry form and complete the entry; The first western medicine unit conversion table is used to store a plurality of western medicine names and the conversion relationship between the quantity units corresponding to each western medicine name and the corresponding minimum units; If the drug name is a Chinese medicine name, determine whether the quantity unit corresponding to the Chinese medicine name is the same as the corresponding minimum unit in the preset Chinese medicine minimum unit storage table; If so, a corresponding entry form is generated based on the bill and the entry is completed; If not, then the conversion relationship between the quantity unit corresponding to the Chinese medicine name and the corresponding minimum unit in the preset Chinese medicine minimum unit entry table is obtained according to the preset first Chinese medicine unit conversion table, and the quantity unit corresponding to the Chinese medicine name is converted into the corresponding minimum unit according to the conversion relationship, and the corresponding entry form is generated and the entry is completed; The first Chinese medicine unit conversion table is used to store a plurality of Chinese medicine names and the conversion relationship between the quantity units corresponding to each Chinese medicine name and the corresponding minimum units; When the program or instruction is executed by the processor, the following steps are specifically implemented: If it is identified that the preset area in the bill does not contain valid data, the bill is identified again after a preset time interval. When the number of identifications reaches a preset threshold, an identification failure message is output to the management terminal; When the program or instruction is executed by the processor, the following steps are specifically implemented: A high-speed scanner is used to quickly scan multiple stacked bills to be stored, and the bill verification technology is used to determine whether the bill is a valid bill. If so, all the bills determined to be valid bills are combined into a first bill set; it is determined whether there are duplicate bills in the first bill set. If so, only one duplicate bill is retained and the other duplicate bills are deleted, and then it is identified whether a preset area in the bill contains valid data; When the program or instruction is executed by the processor, the following steps are specifically implemented: A purchase order is obtained from a medical ordering system, and first valid information contained in the purchase order is extracted, and second valid information is extracted from the delivery note, and valid data identified on the note is matched with the first valid information and the second valid information to obtain a matching result; The matching method is: Determine whether the dates in the valid data, the first valid information, and the second valid information are within a reasonable range. If so, determine whether the quantities in the valid data, the first valid information, and the second valid information match. If so, determine whether the amounts in the valid data, the first valid information, and the second valid information match. If so, determine whether the product information in the valid data, the first valid information, and the second valid information matches. If so, determine whether the supplier information in the valid data, the first valid information, and the second valid information matches. If so, determine that the matching result is successful. Determine whether the matching result is successful, if so, proceed to step S2; The bill entry system is configured with multi-level entry according to the requirements for exiting the warehouse, and the multi-level entry is configured with a minimum unit entry table and a plurality of secondary unit entry tables.
Citation Information
Patent Citations
Drug acceptance check method by scanning two-dimensional bar code of invoice
CN102044013A
Drug data matching method and device, equipment and storage medium
CN113130038A
Medical bill code matching method and device
CN113139498A