CN111383088B - Warehouse accounting checking method and related device - Google Patents
Warehouse accounting checking method and related device Download PDFInfo
- Publication number
- CN111383088B CN111383088B CN202010143227.7A CN202010143227A CN111383088B CN 111383088 B CN111383088 B CN 111383088B CN 202010143227 A CN202010143227 A CN 202010143227A CN 111383088 B CN111383088 B CN 111383088B
- Authority
- CN
- China
- Prior art keywords
- management system
- warehouse
- enterprise information
- bill
- information management
- 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.)
- Active
Links
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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- 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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- General Business, Economics & Management (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Technology Law (AREA)
- Computational Linguistics (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a checking method and a related device of a warehouse account, wherein the checking method of the warehouse account comprises the following steps: acquiring the posted inventory of the warehouse management system and the total inventory of the enterprise information management system; comparing and judging whether the checked-out inventory of the warehouse management system is the same as the total inventory of the enterprise information management system; if the checked-out stock quantity of the warehouse management system is judged to be different from the total stock quantity of the enterprise information management system, abnormal prompt is carried out, and the bill of the warehouse management system is compared with the bill of the enterprise information management system, so that abnormal bill is found out. Therefore, the warehouse accounts can be automatically checked at any time, abnormal reminding can be timely carried out when abnormality occurs, and the receipts of the warehouse management system are automatically and further compared with the receipts of the enterprise information management system, so that abnormal receipts are found out.
Description
Technical Field
The present disclosure relates to the field of accounting checking technology, and in particular, to a checking method for warehouse accounts and a related device.
Background
Warehousing plays a critical role in the whole supply chain of an enterprise, and if proper stock intake and stock control and delivery cannot be guaranteed, the management cost will be increased, and the service quality is difficult to guarantee, so that the competitiveness of the enterprise is affected.
The warehouse operation and inventory control operation are complicated and diversified, and only the manual memory and the manual input are needed, so that the method is time-consuming and labor-consuming, is easy to make mistakes, and brings great loss to enterprises. Warehouse management is now generally performed by a warehouse management system (Warehouse Management System, WMS). Meanwhile, an enterprise resource planning system (Enterprise Resource Planning, ERP), also called enterprise information management system, is an enterprise information management system for integrating and managing material resources, fund resources and information resources of enterprises, and also manages information with warehouse.
When a financial staff checks accounts at the end of a month, whether the warehouse information in the warehouse management system is consistent with the warehouse information in the enterprise information management system or not can be checked manually so as to determine whether financial abnormality problems exist in the warehouse management system and the enterprise information management system, and when abnormal problems exist, the abnormal reasons are analyzed through manual account checking. Therefore, the existing method can only find abnormal problems when checking out at the end of the month, has very poor timeliness, and is very low in efficiency by checking by manual checking out.
Disclosure of Invention
Based on the defects of the prior art, the invention provides a checking method of warehouse accounts and a related device, which are used for solving the problems that the existing checking method is not timely and has low efficiency.
In order to achieve the above object, the present invention provides the following technical solutions:
the first aspect of the present application provides a checking method for warehouse accounts, including:
acquiring the posted inventory of the warehouse management system and the total inventory of the enterprise information management system;
comparing and judging whether the checked-out inventory of the warehouse management system is the same as the total inventory of the enterprise information management system;
if the checked-out stock quantity of the warehouse management system is judged to be different from the total stock quantity of the enterprise information management system, abnormal prompt is carried out, and the bill of the warehouse management system is compared with the bill of the enterprise information management system, so that abnormal bill is found out.
Optionally, in the above checking method, the acquiring the posted inventory of the warehouse management system includes:
acquiring the total stock quantity, the ex-warehouse non-accounting quantity and the warehouse-in non-accounting quantity of the warehouse management system;
adding the total stock quantity of the warehouse management system with the ex-warehouse unset quantity, and subtracting the warehouse-in unset quantity to obtain the posted stock quantity of the warehouse management system.
Optionally, in the above checking method, comparing the document of the warehouse management system with the document of the enterprise information management system, finding out an abnormal document includes:
comparing each bill of the warehouse management system with each bill of the enterprise information management system according to each bill of the mobile type, and determining that inconsistent bills are recorded in the enterprise information management system and the enterprise information management system in each bill of the mobile type;
and determining the determined bill as an abnormal bill, and prompting the information of the abnormal bill.
Optionally, in the above checking method, comparing each bill of the warehouse management system with each bill of the enterprise information management system for each bill of the mobile type, determining a bill of each bill of the mobile type, in which inconsistent records are recorded in the enterprise information management system and the enterprise information management system, including:
judging whether the posted inventory of the warehouse management system is greater than the total inventory of the enterprise information management system;
if the checked-out stock quantity of the warehouse management system is larger than the total stock quantity of the enterprise information management system, the bills of each mobile type are searched out from the bills of the warehouse management system and are consistent with the records of the bills in the enterprise information management system.
A second aspect of the present application provides a checking device for warehouse accounts, including:
a first acquiring unit for acquiring the posted inventory of the warehouse management system;
a second obtaining unit, configured to obtain a total stock of the enterprise information management system;
a first judging unit for judging whether the checked-out stock quantity of the warehouse management system and the total stock quantity of the enterprise information management system are the same by comparison;
the prompting unit is used for prompting abnormality when the first judging unit judges that the checked-out stock quantity of the warehouse management system is different from the total stock quantity of the enterprise information management system;
and the abnormality searching unit is used for comparing the bill of the warehouse management system with the bill of the enterprise information management system to find out an abnormal bill when the first judging unit judges that the checked-out stock quantity of the warehouse management system is different from the total stock quantity of the enterprise information management system.
Optionally, in the above collation apparatus, the first acquisition unit includes:
the first acquisition subunit is used for acquiring the total stock quantity, the ex-warehouse non-accounting quantity and the warehouse non-accounting quantity of the warehouse management system;
and the calculation unit is used for adding the total stock quantity of the warehouse management system to the ex-warehouse unset quantity and subtracting the warehouse-in unset quantity to obtain the posted stock quantity of the warehouse management system.
Optionally, in the above collation apparatus, the abnormality finding unit includes:
the comparison unit is used for comparing each bill of the warehouse management system with each bill of the enterprise information management system for each bill of the mobile type, and determining the bills of each mobile type, which are inconsistent in records of the enterprise information management system and the enterprise information management system;
and the determining unit is used for determining the determined bill as an abnormal bill and prompting the information of the abnormal bill.
Optionally, in the above collation apparatus, the collation unit includes:
a second judging unit, configured to judge whether the posted inventory amount of the warehouse management system is greater than the total inventory amount of the enterprise information management system;
and the comparison sub-unit is used for searching out the receipts consistent with the records of all the receipts in the enterprise information management system from all the receipts of the warehouse management system respectively aiming at the receipts of all the mobile types when the posted inventory of the warehouse management system is larger than the total inventory of the enterprise information management system by the second judging unit.
A third aspect of the present application provides a computer storage medium storing a program which, when executed, is configured to implement the checking method of the warehouse accounting as set forth in any one of the above.
A fourth aspect of the present application provides an electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of checking a warehouse account as described in any of the above.
According to the checking method for the warehouse accounts, the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are obtained, and then whether the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are identical is judged through comparison. Since the posted inventory of the warehouse management system and the total inventory of the enterprise information management system are the same under normal conditions, if it is determined that the posted inventory of the warehouse management system and the total inventory of the enterprise information management system are different, an abnormality is indicated, and thus an abnormality is presented at this time. And further comparing the bill of the warehouse management system with the bill of the enterprise information management system to find out an abnormal bill, thereby being beneficial to solving the abnormal problem of the user. The invention can automatically check in time because the checked-out stock quantity of the warehouse management system and the total stock quantity of the enterprise information management system can be obtained at any time, thereby timely finding out the abnormality and prompting the abnormality, and the subsequent searching of the abnormality cause is also automatically realized without manual checking, so that the checking efficiency is effectively improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flow chart of a checking method of warehouse accounts according to an embodiment of the present application;
fig. 2 is a flow chart of a checking method of warehouse accounts according to another embodiment of the present application;
fig. 3 is a flow chart of a checking method of warehouse accounts according to another embodiment of the present application;
fig. 4 is a flowchart of a method for checking a warehouse account according to another embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of a checking device for warehouse accounts according to another embodiment of the present disclosure;
fig. 6 is a schematic structural diagram of a first obtaining unit according to another embodiment of the present application;
fig. 7 is a schematic structural diagram of an exception searching unit according to another embodiment of the present application.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In this application, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The embodiment of the application provides a checking method of warehouse accounts, as shown in fig. 1, specifically including:
s101, acquiring the posted inventory of the warehouse management system and the total inventory of the enterprise information management system.
Optionally, the method provided by the embodiment of the application can be applied to a warehouse management system, namely, the method can be realized through the warehouse management system. Specifically, the warehouse management system performs data interaction with the enterprise information management system through the hypertext transfer protocol (HTTP), so that inventory data can be downloaded from the enterprise information management system at any time to perform accounting check. Therefore, the acquiring the checked-out inventory of the warehouse management system is actually reading the checked-out inventory from the local storage, and the acquiring the total inventory of the enterprise information management system needs to be downloaded from the enterprise information management system. Of course, this is just one alternative, and may be applied to an enterprise management system or other system.
It should be noted that, the record of each ex-warehouse and in-warehouse is recorded in the warehouse management system, but the record needs to be posted to the enterprise information management system, and the enterprise information system will record the record accordingly, that is, the record in the enterprise information system is posted by the warehouse management system. Therefore, the total inventory of the enterprise information management system is normally consistent with the posted inventory of the warehouse management system.
Optionally, in another embodiment of the present application, the specific implementation of obtaining the posted inventory of the warehouse management system in step S101, as shown in fig. 2, includes:
s201, acquiring the total stock quantity, the ex-warehouse unset quantity and the warehouse-in unset quantity of a warehouse management system.
The ex-warehouse unset amount refers to an ex-warehouse total amount record recorded in a warehouse management system and checked out at the time of warehouse entry, but not checked out to an enterprise information management system. Similarly, if the warehouse entry is not checked out, the warehouse entry recorded in the warehouse management system is not checked out to the enterprise information management system, and the warehouse entry total amount recorded in the warehouse entry is not checked out yet.
S202, adding the total stock quantity of the warehouse management system with the ex-warehouse unset quantity, and subtracting the warehouse-in unset quantity to obtain the posted stock quantity of the warehouse management system.
The method comprises the steps of obtaining the checked-out inventory of the warehouse management system by adding the checked-in inventory of the warehouse management system, which is required to be checked in during warehouse entry, subtracting the checked-out inventory which is still in the warehouse but is not checked out from the warehouse entry which is not checked out, and recording the checked-in inventory which is not checked out in warehouse entry, so that the checked-out inventory of the warehouse management system is finally obtained.
Since the total stock of the enterprise information management system and the posted stock of the warehouse management system are kept consistent under normal conditions, the "total stock of the warehouse management system + outstanding amount out of warehouse-in outstanding amount = total stock of the enterprise information management system" should be satisfied under correct conditions.
S102, comparing and judging whether the checked-out inventory quantity of the warehouse management system is the same as the total inventory quantity of the enterprise information management system.
Since the posted inventory amount of the warehouse management system and the total inventory amount of the enterprise information management system are the same under normal conditions, if it is determined that the posted inventory amount of the warehouse management system and the total inventory amount of the enterprise information management system are different, it is indicated that there is an abnormality in the inventory record in the warehouse management system and/or the inventory record in the enterprise information management system record, so step S103 is executed at this time. If the checked-out inventory quantity of the warehouse management system is judged to be the same as the total inventory quantity of the enterprise information management system, the accounting of the warehouse management system and the enterprise information management system on the warehouse is normal.
S103, carrying out abnormal prompt, comparing the bill of the warehouse management system with the bill of the enterprise information management system, and finding out the abnormal bill.
Specifically, when the accounting abnormality occurs, abnormal information can be prompted to user personnel through a user interface. After the abnormality occurs, the cause of the abnormality caused by the analysis needs to be found out and solved. Under the condition that no abnormality exists, each bill of the warehouse management system has a corresponding bill in the enterprise information management system, namely, a bill with consistent records exists, so that the specific bill which causes that the checked-out stock quantity of the warehouse management system is unequal to the total stock quantity of the enterprise information management system can be found out by downloading the bill of the warehouse management system and the bill of the enterprise information management system and comparing the checked-out bill in the warehouse management system with the bill of the enterprise information management system one by one. Therefore, the staff can solve the abnormal problem according to the specific bill.
According to the checking method for the warehouse accounts, the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are obtained, and then whether the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are identical is judged through comparison. Since the posted inventory of the warehouse management system and the total inventory of the enterprise information management system are the same under normal conditions, if it is determined that the posted inventory of the warehouse management system and the total inventory of the enterprise information management system are different, an abnormality is indicated, and thus an abnormality is presented at this time. And moreover, the receipts of the warehouse management system can be further compared with the receipts of the enterprise information management system, so that abnormal receipts can be found out, and the problem of abnormality can be solved by a user. The invention can automatically check in time because the checked-out stock quantity of the warehouse management system and the total stock quantity of the enterprise information management system can be obtained at any time, thereby timely finding out the abnormality and prompting the abnormality, and the subsequent searching of the abnormality cause is also automatically realized without manual checking, thus effectively improving the checking efficiency.
Optionally, in another embodiment of the present application, a specific implementation manner of step S103, as shown in fig. 3, includes:
s301, comparing each bill of the warehouse management system with each bill of the enterprise information management system according to each bill of the mobile type, and determining that inconsistent bills are recorded in the enterprise information management system and the enterprise information management system in the bills of the mobile type.
In order to facilitate the management of the warehouse-in and warehouse-out, the warehouse-out and warehouse-in are generally classified into a plurality of smaller mobile types, for example, the warehouse-in is classified into a mobile type such as a normal warehouse-in type, a warehouse-out warehouse-in type, a reworked warehouse-in type, and the warehouse-out can be classified into a sales warehouse-out type, a material-receiving warehouse-out type, and the like.
Therefore, when comparing the bulkhead document of the warehouse management system with the bulkhead document of the enterprise information management system, the application compares the documents of the two systems under the moving type for the documents of the moving type for the sake of convenience. For example, each document in normal warehouse entry in the warehouse management system is compared with the document in normal warehouse entry in the enterprise information management system, so that the document which is inconsistent in record in the enterprise information management system and the enterprise information management system is determined from the documents in normal warehouse entry.
Wherein, two documents with identical records can be understood as two documents with the same article in and out of the warehouse. Therefore, if a document exists only in the warehouse management system or the enterprise information management information system, the document is a document which is inconsistent in the enterprise information management system and the enterprise information management system.
Optionally, since the warehouse information in the enterprise information management system is posted from the warehouse management system, abnormal documents in the general situation appear in the warehouse management system, so that the abnormal documents can be searched mainly for each document in the warehouse management system. Thus, in another embodiment of the present application, an implementation of step S302, as shown in fig. 4, includes:
s401, judging whether the posted inventory quantity of the warehouse management system is larger than the total inventory quantity of the enterprise information management system.
It should be noted that, since the warehouse information in the enterprise information management system is posted from the warehouse management system, if the posted inventory amount of the warehouse management system is greater than the total inventory amount of the enterprise information management system, it can be further determined that the abnormal bill appears in the warehouse management system, but not in the enterprise information management system, so that the abnormal bill can be directly found out from the warehouse management system, but needs to be found out from the bill managed by the enterprise information, and thus step S402 is executed at this time.
S402, aiming at the bills of each mobile type, searching out the bills which are inconsistent with the records of the bills in the enterprise information management system from the bills of the warehouse management system.
Specifically, for each mobile type bill, each bill of the warehouse management system is sequentially taken as a target bill, and whether the bills with the consistent records exist in each bill of the enterprise information management system is searched, so that the target bill inconsistent with the records of each bill of the enterprise information management system is determined.
S302, determining the determined bill as an abnormal bill, and prompting information of the abnormal bill.
Specifically, each determined bill is determined to be an abnormal bill, and information of each abnormal bill is provided for a user through a user interface. The information of the abnormal bill can comprise identification, generation date, article name, quantity and the like of the abnormal bill.
Another embodiment of the present application provides a checking device for warehouse accounts, as shown in fig. 5, including:
a first obtaining unit 501, configured to obtain a posted inventory level of the warehouse management system.
A second obtaining unit 502, configured to obtain a total inventory of the enterprise information management system.
A first judging unit 503, configured to judge whether the posted inventory amount of the warehouse management system and the total inventory amount of the enterprise information management system are the same by comparing.
And a prompting unit 504, configured to perform exception prompting when the first determining unit 503 determines that the posted inventory amount of the warehouse management system and the total inventory amount of the enterprise information management system are different.
And the anomaly searching unit 505 is configured to compare the bill of the warehouse management system with the bill of the enterprise information management system to find an anomaly bill when the first judging unit 503 judges that the posted inventory of the warehouse management system is different from the total inventory of the enterprise information management system.
It should be noted that, the specific working process of the above units in the embodiments of the present application may refer to the steps S101 to S103 in the embodiments of the above methods, which are not described herein again.
Alternatively, in another embodiment of the present application, the first obtaining unit 501, as shown in fig. 6, includes:
the first obtaining subunit 601 is configured to obtain a total inventory, an ex-warehouse outstanding inventory, and an in-warehouse outstanding inventory of the warehouse management system.
The calculating unit 602 is configured to add the total inventory of the warehouse management system to the ex-warehouse outstanding inventory, and subtract the in-warehouse outstanding inventory to obtain the posted inventory of the warehouse management system.
It should be noted that, the specific working process of the above units in the embodiments of the present application may refer to the step S201 and the step S202 in the embodiments of the above method, which are not described herein again.
Alternatively, in another embodiment of the present application, the exception finding unit 505, as shown in fig. 7, includes:
and the comparison unit 701 is used for comparing each bill of the warehouse management system with each bill of the enterprise information management system for each bill of the mobile type, and determining that inconsistent bills are recorded in the enterprise information management system and the enterprise information management system in the bills of the mobile type.
And the determining unit 702 is configured to determine the determined document as an abnormal document and prompt information of the abnormal document.
It should be noted that, the specific working process of the above units in the embodiments of the present application may refer to the step S301 and the step S302 in the embodiments of the above method, which are not described herein again.
Optionally, in another embodiment of the present application, the comparing unit 701 includes:
and the second judging unit is used for judging whether the posted inventory quantity of the warehouse management system is larger than the total inventory quantity of the enterprise information management system.
And the comparison sub-unit is used for searching out the bills of each mobile type from the bills of the warehouse management system when the checked-out stock quantity of the warehouse management system of the second judging unit is larger than the total stock quantity of the enterprise information management system, and the bills are consistent with the records of the bills in the enterprise information management system.
It should be noted that, the specific working process of the above units in the embodiments of the present application may refer to the step S401 and the step S402 in the embodiments of the above method, which are not described herein again.
According to the checking device for the warehouse accounts, the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are obtained through the first obtaining unit and the second obtaining unit, and then whether the checked-out inventory of the warehouse management system and the total inventory of the enterprise information management system are identical or not is judged through comparison. And when the first judging unit judges that the checked-out stock quantity of the warehouse management system is different from the total stock quantity of the enterprise information management system, the prompting unit prompts abnormality. And the abnormal searching unit further compares the bill of the warehouse management system with the bill of the enterprise information management system to search out the abnormal bill, thereby being beneficial to solving the abnormal problem of the user. The invention can automatically check in time because the checked-out stock quantity of the warehouse management system and the total stock quantity of the enterprise information management system can be obtained at any time, thereby timely finding out the abnormality and prompting the abnormality, and the subsequent searching of the abnormality cause is also automatically realized without manual checking, thus effectively improving the checking efficiency.
Another embodiment of the present application provides a computer storage medium storing a program that, when executed, is configured to implement a method for checking a warehouse accounting as in any one of the method embodiments described above.
Another embodiment of the present application provides an electronic device, including:
one or more processors and a storage device.
The storage device has one or more programs stored thereon. The one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method for checking a warehouse accounting in any of the method embodiments described above.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of functionality in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
1. A method for checking a warehouse account, comprising:
acquiring the posted inventory of the warehouse management system and the total inventory of the enterprise information management system;
comparing and judging whether the checked-out inventory of the warehouse management system is the same as the total inventory of the enterprise information management system;
if the checked-out stock quantity of the warehouse management system is judged to be different from the total stock quantity of the enterprise information management system, carrying out abnormal prompt, comparing the bill of the warehouse management system with the bill of the enterprise information management system, and finding out abnormal bill;
comparing the receipt of the warehouse management system with the receipt of the enterprise information management system to find out an abnormal receipt, wherein the method comprises the following steps:
comparing each bill of the warehouse management system with each bill of the enterprise information management system according to each bill of the mobile type, and determining that inconsistent bills are recorded in the enterprise information management system and the enterprise information management system in each bill of the mobile type;
and determining the determined bill as an abnormal bill, and prompting the information of the abnormal bill.
2. The method of claim 1, wherein the obtaining the posted inventory of the warehouse management system comprises:
acquiring the total stock quantity, the ex-warehouse non-accounting quantity and the warehouse-in non-accounting quantity of the warehouse management system;
adding the total stock quantity of the warehouse management system with the ex-warehouse unset quantity, and subtracting the warehouse-in unset quantity to obtain the posted stock quantity of the warehouse management system.
3. The method according to claim 1, wherein comparing each bill of the warehouse management system with each bill of the enterprise information management system for each bill of the mobile type, and determining that the bills of the mobile type are inconsistent in the records of the enterprise information management system and the enterprise information management system, includes:
judging whether the posted inventory of the warehouse management system is greater than the total inventory of the enterprise information management system;
if the checked-out stock quantity of the warehouse management system is larger than the total stock quantity of the enterprise information management system, the bills of each mobile type are searched out from the bills of the warehouse management system and are consistent with the records of the bills in the enterprise information management system.
4. A checking device for warehouse accounts, comprising:
a first acquiring unit for acquiring the posted inventory of the warehouse management system;
a second obtaining unit, configured to obtain a total stock of the enterprise information management system;
a first judging unit for judging whether the checked-out stock quantity of the warehouse management system and the total stock quantity of the enterprise information management system are the same by comparison;
the prompting unit is used for prompting abnormality when the first judging unit judges that the checked-out stock quantity of the warehouse management system is different from the total stock quantity of the enterprise information management system;
the abnormal searching unit is used for comparing the bill of the warehouse management system with the bill of the enterprise information management system to find out an abnormal bill when the first judging unit judges that the checked-out stock quantity of the warehouse management system is different from the total stock quantity of the enterprise information management system;
wherein the abnormality finding unit includes:
the comparison unit is used for comparing each bill of the warehouse management system with each bill of the enterprise information management system for each bill of the mobile type, and determining the bills of each mobile type, which are inconsistent in records of the enterprise information management system and the enterprise information management system;
and the determining unit is used for determining the determined bill as an abnormal bill and prompting the information of the abnormal bill.
5. The apparatus of claim 4, wherein the first acquisition unit comprises:
the first acquisition subunit is used for acquiring the total stock quantity, the ex-warehouse non-accounting quantity and the warehouse non-accounting quantity of the warehouse management system;
and the calculation unit is used for adding the total stock quantity of the warehouse management system to the ex-warehouse unset quantity and subtracting the warehouse-in unset quantity to obtain the posted stock quantity of the warehouse management system.
6. The apparatus according to claim 4, wherein the comparison unit comprises:
a second judging unit, configured to judge whether the posted inventory amount of the warehouse management system is greater than the total inventory amount of the enterprise information management system;
and the comparison sub-unit is used for searching out the receipts consistent with the records of all the receipts in the enterprise information management system from all the receipts of the warehouse management system respectively aiming at the receipts of all the mobile types when the posted inventory of the warehouse management system is larger than the total inventory of the enterprise information management system by the second judging unit.
7. A computer storage medium storing a program which, when executed, is adapted to carry out the checking method of a warehouse accounting as claimed in any one of claims 1 to 3.
8. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of checking a warehouse accounting as claimed in any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010143227.7A CN111383088B (en) | 2020-03-04 | 2020-03-04 | Warehouse accounting checking method and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010143227.7A CN111383088B (en) | 2020-03-04 | 2020-03-04 | Warehouse accounting checking method and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111383088A CN111383088A (en) | 2020-07-07 |
| CN111383088B true CN111383088B (en) | 2023-05-05 |
Family
ID=71219757
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010143227.7A Active CN111383088B (en) | 2020-03-04 | 2020-03-04 | Warehouse accounting checking method and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111383088B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113393191A (en) * | 2021-06-15 | 2021-09-14 | 北京京东振世信息技术有限公司 | Inventory reconciliation method, device, electronic equipment and storage medium |
| CN114548952A (en) * | 2022-04-22 | 2022-05-27 | 武汉中科通达高新技术股份有限公司 | Transaction data verification method and device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105184542A (en) * | 2015-10-20 | 2015-12-23 | 韩继东 | Enterprise resource plan real time management method and system based on material stock state |
| CN106127557A (en) * | 2016-06-30 | 2016-11-16 | 东莞浩方云网电子商务有限公司 | A kind of ecommerce information management system |
| CN106295834A (en) * | 2015-05-20 | 2017-01-04 | 常州奥迈信息技术有限公司 | A kind of method that parts stock shares optimization |
| WO2018000622A1 (en) * | 2016-06-28 | 2018-01-04 | 乐视控股（北京）有限公司 | Wms system and erp system synchronization method and system |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103559602A (en) * | 2013-10-15 | 2014-02-05 | 济南金钟电子衡器股份有限公司 | Intelligent warehouse entering and exiting system one-stop service platform |
| CN107392544B (en) * | 2017-07-31 | 2021-11-09 | 深圳华盛商业发展有限公司 | Universal retail management system and method |
| CN109447553A (en) * | 2018-10-31 | 2019-03-08 | 国网河北省电力有限公司电力科学研究院 | A kind of checking method of inventory, system and terminal device |
-
2020
- 2020-03-04 CN CN202010143227.7A patent/CN111383088B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106295834A (en) * | 2015-05-20 | 2017-01-04 | 常州奥迈信息技术有限公司 | A kind of method that parts stock shares optimization |
| CN105184542A (en) * | 2015-10-20 | 2015-12-23 | 韩继东 | Enterprise resource plan real time management method and system based on material stock state |
| WO2018000622A1 (en) * | 2016-06-28 | 2018-01-04 | 乐视控股（北京）有限公司 | Wms system and erp system synchronization method and system |
| CN106127557A (en) * | 2016-06-30 | 2016-11-16 | 东莞浩方云网电子商务有限公司 | A kind of ecommerce information management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111383088A (en) | 2020-07-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8126787B1 (en) | System and method for preparing a tax return using electronically distributed tax return data | |
| EP3292469B1 (en) | Automated workflow management system for application and data retirement | |
| US7810067B2 (en) | Development processes representation and management | |
| US7593859B1 (en) | System and method for operational risk assessment and control | |
| US20120304248A1 (en) | Method and system for information technology asset management | |
| CN111383088B (en) | Warehouse accounting checking method and related device | |
| US10496817B1 (en) | Detecting anomalous values in small business entity data | |
| US20070078701A1 (en) | Systems and methods for managing internal controls with import interface for external test results | |
| CN102456172A (en) | Smart automobile maintenance and management method | |
| CN111241161A (en) | Invoice information mining method and device, computer equipment and storage medium | |
| US20090043594A1 (en) | Method and system for shortage deduction processing | |
| CN111291051A (en) | Freight rate data processing method and device, storage medium and electronic equipment | |
| US9953294B2 (en) | Enabling an in-memory transactional application | |
| US20240062235A1 (en) | Systems and methods for automated processing and analysis of deduction backup data | |
| CN111222966A (en) | Automatic account checking system and implementation method | |
| US20130085958A1 (en) | Flexible and automated processing of electronic documents | |
| US20140012830A1 (en) | Data verification system | |
| US20220129864A1 (en) | Systems and methods for processing trailer repair requests submitted by carriers | |
| CN112446697B (en) | Account checking method, account checking device, computer equipment and storage medium | |
| US20210174410A1 (en) | Rail asset management system and interactive user interface | |
| US20110145202A1 (en) | Archiving system | |
| US20200019972A1 (en) | Reverse logistics system for mobile devices and method | |
| CN111798080A (en) | Help item data management method and system | |
| US11809590B1 (en) | Online software platform (OSP) querying client data about relationship instances for application of permission digital rules in addition to resource digital rules for the relationship instances | |
| US11605136B1 (en) | Providing diagnostics regarding differences between trusted resource values and historical resource values |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |