Physical inventory management system and method for scrap steel enterprise

Abstract

The invention discloses a steel scrap enterprise physical inventory management system and method, and belongs to the technical field of steel scraps. The system comprises a warehouse information maintenance module, a purchase warehouse-in management module, a sales warehouse-out management module, a processing management module, a material conversion management module, an impurity removal management module, a bottom material management module, an inventory checking module, an inventory checking module and a report module. According to the method, the problems that existing inventory management is extensive and is greatly different from actual inventory are solved, and the field inventory is supervised by integrating flow nodes such as receiving, processing, material conversion, deslagging and delivery, so that the consistency of the field inventory and the physical inventory can be ensured, the operation risk is reduced, and product overstock is avoided.

Description

Technical Field

[0001] The present invention relates to the technical field of scrap steel, and in particular to a physical inventory management system and method for a scrap steel enterprise. Background Art

[0002] The existing base inventory management system does not include the impurity part of the purchase weight, which leads to extensive inventory management and large differences from the actual inventory. It is impossible to accurately grasp the physical inventory in each base and warehouse, especially the impurity part, which is not conducive to the management needs of on-site inventory and inventory monitoring; therefore, it does not meet the existing needs. In this regard, we propose a physical inventory management system and method for scrap steel enterprises. Summary of the invention

[0003] The purpose of the present invention is to provide a physical inventory management system and method for scrap steel enterprises, which integrates process nodes such as receiving, processing, material conversion, slag discharge, and delivery to supervise the on-site inventory to ensure the consistency between the on-site inventory and the physical inventory, thereby solving the problems raised in the above-mentioned background technology.

[0004] To achieve the above object, the present invention provides the following technical solution: a physical inventory management system for scrap steel enterprises, comprising:

[0005] The warehouse information maintenance module is used to maintain warehouse information and warehouse area information. The warehouse contains one or more warehouse areas. Warehouse information maintenance is used to maintain warehouse information. Warehouse area information maintenance is used to maintain warehouse information, basic warehouse area information and warehouse area type. Warehouse area types are divided into raw material warehouse, finished product warehouse and bottom material warehouse.

[0006] The purchasing and warehousing management module is used to track and manage the purchasing and warehousing process of materials, as well as record the warehousing weight. The recorded warehousing weight includes two parts: impurity weight and estimated dry basis weight. The estimated dry basis weight is the effective weight of the goods, which is included in the raw material warehouse or finished product warehouse. The impurity weight is the weight of impurities in the goods that are not included in the effective weight, which is included in the bottom material warehouse as bottom material M1;

[0007] Sales outbound management module is used to sell the inventory in the raw material warehouse or finished product warehouse and automatically deduct the corresponding inventory after the sale;

[0008] The processing management module is used to convert raw materials into finished products, mix the raw materials and bottom material M1, and produce finished products and bottom material M2, wherein the bottom material M1 is the impurities removed when receiving the goods, and the bottom material M2 is the non-reusable bottom material generated in the impurity removal and processing links;

[0009] Material conversion management module, used for the conversion between two different raw materials or two different finished products;

[0010] The impurity removal management module is used to convert the impurity weight at the time of receipt into non-reusable bottom material, and adjust the bottom material M1 to bottom material M2 through impurity removal by recording the impurity removal operation of the actual objects on site;

[0011] The bottom material management module is used to conduct non-main sales or other processing of the bottom materials, including selling the inventory of bottom materials M1 and bottom materials M2 from the bottom material storage area as non-main business;

[0012] The inventory counting module is used to perform daily inventory counting operations on raw materials and finished products and create inventory counting sheets for recording, and supports the direct generation of documents from return orders;

[0013] Inventory inventory module is used for on-site personnel to count and display the difference between actual inventory and system inventory every month, and to fill in the reason for the difference when there is a difference between actual inventory and system inventory;

[0014] The report module is used to display the system inventory, physical inventory, daily inventory in and out, unconfirmed inventory in and out, and in-transit inventory through reports, so as to view the actual inventory status of each base under the company.

[0015] Furthermore, the warehouse information maintenance module includes:

[0016] Management module, which is used to provide management functions, including keyword search, classification screening, and import and export functions. Through keyword search and classification screening functions, warehouse information and warehouse area information that need to be maintained can be located. Through the import and export functions, existing information can be imported into the system and existing information can be exported at the same time.

[0017] The permission module is used to set different operation permissions for users of different roles. The operation permissions are divided into general permissions and special permissions;

[0018] If set to general permissions, it allows viewing warehouse information and warehouse area information;

[0019] If set to general permissions, it allows viewing and modifying warehouse information and warehouse area information.

[0020] Furthermore, the sales and delivery management module includes:

[0021] The inventory management module is used to issue sales documents after sales, generate corresponding delivery vouchers based on the sales documents, and automatically deduct the corresponding inventory;

[0022] Statistics module, used to generate statistical reports based on sales to analyze inventory changes and sales

[0023] The early warning module is used to set the inventory early warning threshold. When the inventory in the raw material warehouse or finished product warehouse is lower than the early warning value, an alarm notification is automatically triggered.

[0024] Furthermore, the report module includes the following functions:

[0025] Report customization function: used to customize the report field display and report style;

[0026] Report export function: used to export reports to Excel or PDF format, and provide printing, downloading and sharing operations.

[0027] Furthermore, the calculation formula of the actual inventory is as follows:

[0028] Physical inventory = raw material quantity + finished product quantity + bottom material quantity;

[0029] The calculation formula of the bottom material is: bottom material = bottom material M1 + bottom material M2.

[0030] Furthermore, the processing management module supports adding new documents and supports manually filling in all fields before entering the system, and outputs according to the following formula:

[0031] Raw material + bottom material M1 -> finished product + bottom material M2;

[0032] Add control based on the above formula: Raw material + bottom material M1>= finished product + bottom material M2;

[0033] If raw material + bottom material M1> finished product + bottom material M2, the system will automatically calculate the processing loss and loss ratio.

[0034] Furthermore, in the material conversion management module, the formula for calculating the inventory amount of the converted material is: inventory amount of the converted material = conversion weight * weighted average price of the material inventory before conversion.

[0035] Furthermore, the inventory module provides information on the display base, inventory date, excess quantity, shortage quantity, difference quantity and data source, wherein the difference quantity calculation formula is: difference quantity = excess quantity + shortage quantity;

[0036] In the inventory module, the difference amount calculation formula is: difference amount = inventory inventory - system inventory.

[0037] Furthermore, in the report module, the report is divided into the following fields:

[0038] System book inventory: the total inventory of the warehouse area entered in the system;

[0039] Purchase quantity received on the day: the weight of inventory that has been confirmed to be received through the purchase and warehousing module on the day;

[0040] Sales outbound quantity for the day: the weight of inventory that has been confirmed outbound through the sales outbound module on the day;

[0041] Other incoming inventory: the sum of the incoming inventory through other means except sales;

[0042] Other outbound volume: the sum of inbound volume received through other means except sales outbound volume;

[0043] Among them, the unconfirmed incoming quantity = the sum of the weights of the documents entered into the purchase incoming module but not confirmed, which is not included in the system inventory;

[0044] Unconfirmed outbound quantity = the sum of the weights of the documents entered into the sales outbound module but not confirmed, and not included in the system inventory;

[0045] Sales volume in transit = the sum of the weight of the documents that have been shipped out but not settled;

[0046] Physical inventory = system book inventory + unconfirmed inventory in + unconfirmed inventory out.

[0047] A method for implementing a physical inventory management system for a scrap steel enterprise comprises the following steps:

[0048] After maintaining warehouse information, the estimated dry basis part of the received materials is stored in the raw material warehouse or finished product warehouse through receiving and warehousing, and the miscellaneous part is stored in the bottom material warehouse as the unified material bottom material M1;

[0049] The raw materials and bottom material M1 are converted into finished products and bottom material M2 through the processing module and stored in the corresponding storage area;

[0050] Finished products and raw materials can be converted into their respective material categories through the material conversion management module, and can also be sold and shipped through the sales and shipping management module;

[0051] The bottom material M1 is converted into bottom material M2 through the impurity removal management module, so that the bottom material M2 is sold as a non-main business in the bottom material management module;

[0052] If you encounter returns, partial returns, or inconsistencies between system inventory and physical inventory, use the inventory counting module to operate the inventory. The inventory counting module is used to periodically count inventory differences and send them to relevant personnel for approval when there are differences, so as to realize the function of inventory supervision;

[0053] The report module displays the physical inventory and system inventory information of each warehouse so that staff can monitor the inventory status in real time.

[0054] Compared with the prior art, the present invention has the following beneficial effects:

[0055] Based on the existing business processes of the original system, the present invention strengthens the management of physical inventory, supports staff to conduct monthly inventory of on-site inventory, integrates process nodes such as receiving, processing, material conversion, slag discharge and delivery, and supervises on-site inventory, thereby ensuring the consistency of on-site inventory and physical inventory, enhancing corporate competitiveness, reducing operational risks and avoiding product backlogs. BRIEF DESCRIPTION OF THE DRAWINGS

[0056] Figure 1 It is a business flow chart of the physical inventory management system for scrap steel enterprises of the present invention;

[0057] Figure 2 It is a detailed information diagram of the bottom material storage area in the business process diagram of the present invention;

[0058] Figure 3 It is a structural schematic diagram of the physical inventory management system for scrap steel enterprises of the present invention. DETAILED DESCRIPTION

[0059] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0060] In order to solve the problem that the existing base inventory management system does not include the impurity part of the purchase warehousing weight, resulting in extensive inventory management, large differences from the actual inventory, and inability to accurately grasp the physical inventory in each base and warehouse, especially the impurity part, which is not conducive to the management needs of on-site inventory and inventory monitoring, please refer to Figure 1-Figure 3 , this embodiment provides the following technical solutions:

[0061] A physical inventory management system for scrap steel enterprises, comprising:

[0062] The warehouse information maintenance module is used to maintain warehouse information and warehouse area information. The warehouse contains one or more warehouse areas. Warehouse information maintenance is used to maintain warehouse information. Warehouse area information maintenance is used to maintain warehouse information, basic warehouse area information and warehouse area type. Warehouse area types are divided into raw material warehouse, finished product warehouse and bottom material warehouse.

[0063] The purchasing and warehousing management module is used to track and manage the purchasing and warehousing process of materials, as well as record the warehousing weight. The recorded warehousing weight includes two parts: impurity weight and estimated dry basis weight. The estimated dry basis weight is the effective weight of the goods, which is included in the raw material warehouse or finished product warehouse. The impurity weight is the weight of impurities in the goods that are not included in the effective weight, which is included in the bottom material warehouse as bottom material M1;

[0064] The sales and delivery management module is used to sell the inventory in the raw material warehouse or finished product warehouse, and automatically deduct the corresponding inventory after the sale. At the same time, the sales and delivery management module supports the return and partial return functions. When returning goods, it automatically generates an inventory count to increase the corresponding inventory, and can support external system input of data, at which time the document will be automatically confirmed;

[0065] The processing management module is used to convert raw materials into finished products, mix the raw materials and bottom material M1, and produce finished products and bottom material M2, wherein the bottom material M1 is the impurities removed when receiving the goods, and the bottom material M2 is the non-reusable bottom material generated in the impurity removal and processing links;

[0066] Material conversion management module, used for the conversion between two different raw materials or two different finished products;

[0067] The impurity removal management module is used to convert the impurity weight at the time of receipt into non-reusable bottom material, and adjust the bottom material M1 to bottom material M2 through impurity removal by recording the impurity removal operation of the actual objects on site;

[0068] The bottom material management module is used to conduct non-main sales or other processing of the bottom materials, including selling the inventory of bottom materials M1 and bottom materials M2 from the bottom material storage area as non-main business;

[0069] The inventory counting module is used to perform daily inventory counting operations on raw materials and finished products and create inventory counting sheets for recording, and supports the direct generation of documents from return orders;

[0070] Inventory inventory module is used for on-site personnel to count and display the difference between actual inventory and system inventory every month, and to fill in the reason for the difference when there is a difference between actual inventory and system inventory;

[0071] The report module is used to display the system inventory, physical inventory, daily inbound and outbound inventory, unconfirmed inbound and outbound inventory, and in-transit inventory through reports, so as to view the actual inventory status of each base under the company;

[0072] The calculation formula for actual inventory is as follows:

[0073] Physical inventory = raw material quantity + finished product quantity + bottom material quantity;

[0074] The calculation formula for the bottom material is: bottom material = bottom material M1 + bottom material M2.

[0075] The technical effect of the above content is: the warehouse information and warehouse area information can be maintained through the warehouse information maintenance module. After maintaining the warehouse information, the goods are received and put into the warehouse through the purchase and warehousing management module, and the estimated dry basis part of the received materials is stored in the raw material warehouse or the finished product warehouse, and the miscellaneous part is stored in the bottom material warehouse as a unified material bottom material M1. The raw materials and bottom materials M1 (bottom materials are optional) can be converted into finished products and bottom materials M2 (bottom materials are optional) through the processing management module and stored in the corresponding warehouse area. The finished products and raw materials can be converted into material categories in their respective material categories through the material conversion management module, and can also be shipped out through sales. The management module performs sales and outbound operations. The bottom material M1 can be converted into bottom material M2 through the impurity removal management module, so that the bottom material management module sells the inventory of bottom material M1 and bottom material M2 from the bottom material warehouse area as a non-core business. The inventory counting module can perform daily inventory operations on raw materials and finished product inventories. The inventory counting module can count the difference between actual inventory and system inventory and display it. Finally, the report module displays the system inventory, physical inventory, daily inbound and outbound volume, unconfirmed inbound and outbound volume, and in-transit volume, so that the company can monitor the inventory status of its base warehouses.

[0076] In this embodiment, the purchasing and warehousing management module can create a new warehousing order in the system or click the "Supplier Weighing Order Import" button to use Excel to batch generate warehousing orders. After clicking batch confirmation, the warehousing weight will be included in the inventory. The warehousing weight includes two parts: impurities and estimated dry basis. The estimated dry basis weight is the effective weight of the goods, which can be included in the raw material warehouse or finished product warehouse. The impurity weight is the weight of impurities in the goods that is not included in the effective weight and can only be included in the bottom material warehouse. Furthermore, the purchasing and warehousing module can also support external system input of data, and the document will be automatically confirmed at this time.

[0077] In this embodiment, the miscellaneous material removal management module supports the recording of miscellaneous material removal (bottom material M2) operations on physical objects on site, and adjusts the bottom material M1 to bottom material M2 through miscellaneous removal. The salesperson fills in the corresponding base warehouse area, miscellaneous material removal weight and other information. After the review is passed, the system synchronously adjusts the corresponding bottom material M1 and bottom material M2 inventory. The miscellaneous material removal page provides information such as the miscellaneous material removal time, the base to which the warehouse belongs, the warehouse, the warehouse area, the material, and the weight.

[0078] In this embodiment, the bottom material management module can sell the inventory of bottom material M1 and bottom material M2 from the bottom material warehouse area as a non-core business. At the same time, a bottom material delivery order can be generated on this page to automatically confirm the delivery and deduct the bottom material inventory. Furthermore, the bottom material management module can also support data input from external systems.

[0079] Warehouse information maintenance module, including:

[0080] Management module, which is used to provide management functions, including keyword search, classification screening, and import and export functions. Through keyword search and classification screening functions, warehouse information and warehouse area information that need to be maintained can be located. Through the import and export functions, existing information can be imported into the system and existing information can be exported at the same time.

[0081] The permission module is used to set different operation permissions for users of different roles. The operation permissions are divided into general permissions and special permissions;

[0082] If set to general permissions, it allows viewing warehouse information and warehouse area information;

[0083] If set to general permissions, it allows viewing and modifying warehouse information and warehouse area information.

[0084] The technical effect of the above content is: the warehouse information maintenance module has a management module and a permission module, wherein the management module is used to provide a variety of management functions, such as keyword search, category screening, import and export, etc. The keyword search and category screening functions can help users quickly locate the warehouse information and warehouse area information that need to be maintained, while the import and export functions can conveniently import existing information into the system and export existing information. In addition, the permission module is responsible for setting permissions for users of different roles. Permissions are divided into general permissions and special permissions. Users with general permissions can view warehouse information and warehouse area information, while users with special permissions can view and modify warehouse information and warehouse area information, so that the warehouse information maintenance module has higher flexibility and scalability, and can meet the needs of different users.

[0085] In this embodiment, the warehouse information maintenance module includes warehouse information maintenance and warehouse area information maintenance. A warehouse can contain multiple warehouse areas, among which the warehouse area information needs to maintain the warehouse area type, and the warehouse area type is divided into raw material warehouse, finished product warehouse and bottom material warehouse. The warehouse area management page displays company information, the base to which the warehouse area belongs, warehouse information and warehouse area type information. A bottom material warehouse area must be set up under each warehouse. When a new warehouse is created, the bottom material warehouse area will be automatically created according to the name of "(warehouse name) warehouse bottom material". When the system receives the goods into the warehouse, the miscellaneous goods will automatically enter the bottom material warehouse area under the corresponding warehouse. The warehouse information maintenance page displays the base to which the warehouse belongs, the warehouse name and the number of subordinate warehouse areas.

[0086] Sales outbound management module, including:

[0087] The inventory management module is used to issue sales documents after sales, generate corresponding delivery vouchers based on the sales documents, and automatically deduct the corresponding inventory;

[0088] Statistics module, used to generate statistical reports based on sales to analyze inventory changes and sales

[0089] The early warning module is used to set the inventory early warning threshold. When the inventory in the raw material warehouse or finished product warehouse is lower than the early warning value, an alarm notification is automatically triggered.

[0090] The technical effects of the above content are as follows: after a sale occurs, the inventory management module can automatically deduct the corresponding inventory based on the delivery voucher generated by the sales order. The inventory management module ensures real-time updating of inventory records and can effectively control inventory levels. The statistical module can generate various statistical reports, such as inventory changes, sales, etc., by analyzing sales data, which helps scrap steel companies to better understand their business operations and make more informed decisions based on this. The early warning module can set the inventory early warning threshold in advance. When the inventory in the raw material warehouse or the finished product warehouse is lower than the warning value, an alarm notification will be automatically triggered, which can help scrap steel companies to promptly discover possible inventory problems, prevent insufficient inventory, and ensure the continuity and smoothness of production. The above three modules work together to form a sales delivery management module, which can greatly improve the company's inventory management level and reduce the operating risks caused by inventory problems.

[0091] The processing management module supports adding new documents and manually filling in all fields before entering the system, and outputs them according to the following formula:

[0092] Raw material + bottom material M1 (optional) -> finished product + bottom material M2 (optional);

[0093] Add control based on the above formula: Raw material + bottom material M1>= finished product + bottom material M2;

[0094] If raw material + bottom material M1> finished product + bottom material M2, the system will automatically calculate the processing loss and loss ratio.

[0095] In this embodiment, bottom material M1 refers to the miscellaneous part removed upon receipt, and bottom material M2 refers to the non-reusable bottom material generated during the removal of impurities and processing. For each processing order, the page displays the basic information of the processing order, detailed information of the input materials (including raw materials and bottom material M1) (including storage area, material, weight and processing method), detailed information of the finished product (finished product) and detailed information of the by-product (bottom material M2).

[0096] In the material conversion management module, the formula for calculating the inventory amount of the converted material is: inventory amount of the converted material = conversion weight * weighted average price of the material inventory before conversion.

[0097] In this embodiment, the material conversion management module can convert two different raw materials or two different finished products of equal weight into each other. Before the conversion, fill in the information such as the warehouse area before conversion, the material before conversion, the warehouse area after conversion, and the inventory after conversion. After the review is passed, the corresponding material inventory is adjusted synchronously, so as to facilitate business scenarios such as the sorting of on-site inventory at the base. Finally, material conversion can be carried out to convert one material into another.

[0098] The inventory module provides information on the display base, inventory date, surplus quantity, shortage quantity, difference quantity and data source. The difference quantity calculation formula is: difference quantity = surplus quantity + shortage quantity.

[0099] In the inventory inventory module, the formula for calculating the difference is: Difference = inventory inventory - system inventory.

[0100] In this embodiment, the inventory module can perform daily inventory operations on raw materials and finished products, create inventory lists to record them, and directly operate the system inventory. It also supports the direct generation of documents from return orders, and the page of the inventory module can display information such as base, inventory date, surplus quantity, shortage quantity (generally negative value), difference quantity and data source (inventory, return).

[0101] The inventory inventory module supports the on-site staff to count and display the difference between the actual inventory and the system inventory every month, and also supports raw materials or finished products to become bottom material M1 through inventory inventory. Click the "Start Inventory Inventory" button to start the inventory inventory, and the current base's delivery and inbound and outbound business will be suspended. Then select the corresponding base, and the system will automatically query the base inventory data. At the same time, the system enters the editing page, and the relevant personnel enter the inventory inventory data. The system will perform the following controls:

[0102] The total amount of surplus raw materials / finished products <= the total amount of bottom material M1 inventory;

[0103] The total amount of bottom material M1>=0;

[0104] After the inventory is completed, click "Submit Inventory". If there is an inventory surplus or shortage, approval is required after submission, otherwise the inventory process ends.

[0105] The reporting module includes the following functions:

[0106] Report customization function: used to customize the report field display and report style;

[0107] Report export function: used to export reports to Excel or PDF format, and provide printing, downloading and sharing operations.

[0108] Report module, the report is divided into the following fields:

[0109] System book inventory: the total inventory of the warehouse area entered in the system;

[0110] Purchase quantity received on the day: the weight of inventory that has been confirmed to be received through the purchase and warehousing module on the day;

[0111] Sales outbound quantity for the day: the weight of inventory that has been confirmed outbound through the sales outbound module on the day;

[0112] Other incoming inventory: the sum of the incoming inventory through other means except sales;

[0113] Other outbound volume: the sum of inbound volume received through other means except sales outbound volume;

[0114] Among them, the unconfirmed incoming quantity = the sum of the weights of the documents entered into the purchase incoming module but not confirmed, which is not included in the system inventory;

[0115] Unconfirmed outbound quantity = the sum of the weights of the documents entered into the sales outbound module but not confirmed, and not included in the system inventory;

[0116] Sales volume in transit = the sum of the weight of the documents that have been shipped out but not settled;

[0117] Physical inventory = system book inventory + unconfirmed inventory in + unconfirmed inventory out.

[0118] The technical effect of the above content is: through the report customization function, users are allowed to customize the field display and style of the report according to their own needs. For example, users can add, delete or modify a field, or adjust the width and font color of the field, etc., which allows users to more conveniently obtain the reports they need and avoid unnecessary information loss or repeated display. Through the report export function, reports can be exported to Excel or PDF format, and printing, downloading and sharing operations are provided. The report export function not only supports the export of reports in multiple formats, but also provides rich export options, allowing users to choose the appropriate export method according to actual needs. A practical report module is constructed through the report customization function and the report export function, which can display the system inventory, physical inventory, daily inbound and outbound quantity, unconfirmed inbound and outbound quantity and in-transit quantity, thereby facilitating the company to monitor the inventory status of its base warehouses.

[0119] Specifically, this embodiment also proposes an implementation method of a physical inventory management system for a scrap steel enterprise, comprising the following steps:

[0120] After maintaining warehouse information, the estimated dry basis part of the received materials is stored in the raw material warehouse or finished product warehouse through receiving and warehousing, and the miscellaneous part is stored in the bottom material warehouse as the unified material bottom material M1;

[0121] The raw materials and bottom material M1 are converted into finished products and bottom material M2 through the processing module and stored in the corresponding storage area;

[0122] Finished products and raw materials can be converted into their respective material categories through the material conversion management module, and can also be sold and shipped through the sales and shipping management module;

[0123] The bottom material M1 is converted into bottom material M2 through the impurity removal management module, so that the bottom material M2 is sold as a non-main business in the bottom material management module;

[0124] If you encounter returns, partial returns, or inconsistencies between system inventory and physical inventory, use the inventory counting module to operate the inventory. The inventory counting module is used to periodically count inventory differences and send them to relevant personnel for approval when there are differences, so as to realize the function of inventory supervision;

[0125] The report module displays the physical inventory and system inventory information of each warehouse so that staff can monitor the inventory status in real time.

[0126] Working principle: By strengthening the management of physical inventory, supporting business personnel to conduct monthly inventory of on-site inventory, and integrating process nodes such as receiving, processing, material conversion, slag discharge, and delivery, on-site inventory supervision is achieved, thereby ensuring the consistency of on-site inventory and physical inventory, thereby enhancing corporate competitiveness, reducing operational risks, and avoiding product backlogs.

[0127] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0128] While the embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that many changes, modifications, substitutions and variations can be made to the embodiments without departing from the principles and spirit of the invention.

Claims

1. A physical inventory management system for scrap steel enterprises, characterized in that: include: The warehouse information maintenance module is used to maintain warehouse information and warehouse area information. The warehouse contains one or more warehouse areas. Warehouse information maintenance is used to maintain warehouse information. Warehouse area information maintenance is used to maintain warehouse information, basic warehouse area information and warehouse area type. Warehouse area types are divided into raw material warehouse, finished product warehouse and bottom material warehouse. The purchasing and warehousing management module is used to track and manage the purchasing and warehousing process of materials, as well as record the warehousing weight. The recorded warehousing weight includes two parts: impurity weight and estimated dry basis weight. The estimated dry basis weight is the effective weight of the goods, which is included in the raw material warehouse or finished product warehouse. The impurity weight is the weight of impurities in the goods that are not included in the effective weight, which is included in the bottom material warehouse as bottom material M1; Sales outbound management module is used to sell the inventory in the raw material warehouse or finished product warehouse and automatically deduct the corresponding inventory after the sale; The processing management module is used to convert raw materials into finished products, mix the raw materials and bottom material M1, and produce finished products and bottom material M2, wherein the bottom material M1 is the impurities removed when receiving the goods, and the bottom material M2 is the non-reusable bottom material generated in the impurity removal and processing links; Material conversion management module, used for the conversion between two different raw materials or two different finished products; The impurity removal management module is used to convert the impurity weight at the time of receipt into non-reusable bottom material, and adjust the bottom material M1 to bottom material M2 through impurity removal by recording the impurity removal operation of the actual objects on site; The bottom material management module is used to conduct non-main sales or other processing of the bottom materials, including selling the inventory of bottom materials M1 and bottom materials M2 from the bottom material storage area as non-main business; The inventory module is used to perform daily inventory operations on raw materials and finished products and create inventory sheets for recording, and supports the direct generation of documents from return orders; Inventory inventory module is used for on-site personnel to count and display the difference between actual inventory and system inventory every month, and to fill in the reason for the difference when there is a difference between actual inventory and system inventory; The report module is used to display the system inventory, physical inventory, daily inventory in and out, unconfirmed inventory in and out, and in-transit inventory through reports, so as to view the actual inventory status of each base under the company.

2. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The warehouse information maintenance module includes: Management module, which is used to provide management functions, including keyword search, classification screening, and import and export functions. Through keyword search and classification screening functions, warehouse information and warehouse area information that need to be maintained can be located. Through the import and export functions, existing information can be imported into the system and existing information can be exported at the same time. The permission module is used to set different operation permissions for users of different roles. The operation permissions are divided into general permissions and special permissions; If set to general permissions, it allows viewing warehouse information and warehouse area information; If set to general permissions, it allows viewing and modifying warehouse information and warehouse area information.

3. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The sales and delivery management module includes: The inventory management module is used to issue sales documents after sales, generate corresponding delivery vouchers based on the sales documents, and automatically deduct the corresponding inventory; Statistics module, used to generate statistical reports based on sales to analyze inventory changes and sales The early warning module is used to set the inventory early warning threshold. When the inventory in the raw material warehouse or finished product warehouse is lower than the early warning value, an alarm notification is automatically triggered.

4. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The report module includes the following functions: Report customization function: used to customize the report field display and report style; Report export function: used to export reports to Excel or PDF format, and provide printing, downloading and sharing operations.

5. The physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The actual inventory calculation formula is as follows: Physical inventory = raw material quantity + finished product quantity + bottom material quantity; The calculation formula of the bottom material is: bottom material = bottom material M1 + bottom material M2.

6. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The processing management module supports adding new documents and manually filling in all fields before entering the system, and outputs according to the following formula: Raw material + bottom material M1 -> finished product + bottom material M2; Add control based on the above formula: Raw material + bottom material M1>= finished product + bottom material M2; If raw material + bottom material M1> finished product + bottom material M2, the system will automatically calculate the processing loss and loss ratio.

7. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: In the material conversion management module, the formula for calculating the inventory amount of the converted material is: the inventory amount of the converted material = the conversion weight * the weighted average price of the material inventory before the conversion.

8. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: The inventory module provides information on the display base, inventory date, excess quantity, shortage quantity, difference quantity and data source, wherein the difference quantity calculation formula is: difference quantity = excess quantity + shortage quantity; In the inventory module, the difference amount calculation formula is: difference amount = inventory inventory - system inventory.

9. A physical inventory management system for scrap steel enterprises according to claim 1, characterized in that: In the report module, the report is divided into the following fields: System book inventory: the total inventory of the warehouse area entered in the system; Purchase quantity received on the day: the weight of inventory that has been confirmed to be received through the purchase and warehousing module on the day; Sales outbound quantity for the day: the weight of inventory that has been confirmed outbound through the sales outbound module on the day; Other incoming inventory: the sum of the incoming inventory through other means except sales; Other outbound volume: the sum of inbound volume received through other means except sales outbound volume; Among them, the unconfirmed incoming quantity = the sum of the weights of the documents entered into the purchase incoming module but not confirmed, which is not included in the system inventory; Unconfirmed outbound quantity = the sum of the weights of the documents entered into the sales outbound module but not confirmed, and not included in the system inventory; Sales volume in transit = the sum of the weight of the documents that have been shipped out but not settled; Physical inventory = system book inventory + unconfirmed inventory in + unconfirmed inventory out.

10. An implementation method of the physical inventory management system for scrap steel enterprises according to any one of claims 1 to 9, characterized in that: The following steps are involved: After maintaining warehouse information, the estimated dry basis part of the received materials is stored in the raw material warehouse or finished product warehouse through receiving and warehousing, and the miscellaneous part is stored in the bottom material warehouse as the unified material bottom material M1; The raw materials and bottom material M1 are converted into finished products and bottom material M2 through the processing module and stored in the corresponding storage area; Finished products and raw materials can be converted into their respective material categories through the material conversion management module, and can also be sold and shipped through the sales and shipping management module; The bottom material M1 is converted into bottom material M2 through the impurity removal management module, so that the bottom material M2 is sold as a non-main business in the bottom material management module; If you encounter returns, partial returns, or inconsistencies between system inventory and physical inventory, use the inventory counting module to operate the inventory. The inventory counting module is used to periodically count inventory differences and send them to relevant personnel for approval when there are differences, so as to realize the function of inventory supervision; The report module displays the physical inventory and system inventory information of each warehouse so that staff can monitor the inventory status in real time.

Images