A method for intelligently generating ASN for client parts

Abstract

The present invention discloses a method for intelligently generating ASNs for client parts, comprising a basic information module generated in Excel, an ASN creation module, an ASN management module, and a user control interface. The basic information module is used to store basic information of customer-shipped parts and can dynamically manage the basic information of customer parts. The ASN creation module maintains common fields of the customer-shipped parts ASN file based on the basic information stored in the basic information module, and intelligently aggregates the generated customer-shipped parts ASN file into the ASN management module via a VBA background program. The ASN management module is used to store and manage customer ASN templates and to store and manage customer historical ASN data. The user control interface is used for a user to start using the tool, and the basic information module, ASN creation module, and ASN management module can be accessed through the control interface. The method disclosed by the present invention has high efficiency and low error rate.

Description

Technical Field

[0001] The present invention relates to the technical field of ASN, and in particular to a method for intelligently generating ASN of client parts. Background Art

[0002] With the vigorous development of the automotive parts industry, digital interactions between automotive parts suppliers and customers are becoming increasingly frequent and important. ASN (Advanced Shipment Notice) has gradually become the first choice and core of digital transaction credentials.

[0003] Therefore, the accuracy and timeliness of ASN files are crucial, especially when shipping large quantities of parts to customers. How to accurately and efficiently complete ASN generation is particularly important for engineers engaged in logistics planning and control positions. However, the current general practice has the following shortcomings: 1) Manual maintenance of the relevant variable fields required for ASN is labor-intensive and inefficient; 2) The basic information that ASN refers to is scattered in other files, which makes searching inefficient and updates easy to miss; 3) ASN numbers are prone to duplication, resulting in data interaction errors, and need to be renumbered and resent, affecting customer parts receipt and subsequent settlement, resulting in additional rework costs and time costs; 4) ASN historical data is manually sorted, collected and summarized, which is inefficient and prone to errors. Summary of the Invention

[0004] In view of the shortcomings and defects of the existing technology, a method for intelligently generating ASN of client parts is provided, which can solve the above technical problems.

[0005] To achieve the above objectives, the present invention provides the following technical solutions.

[0006] A method for intelligently generating ASN of client parts, including:

[0007] The basic information module is used to store the basic information of customer-shipped parts and can dynamically manage the basic information of customer parts;

[0008] The ASN creation module maintains the common fields of the customer shipment parts ASN file based on the basic information stored in the basic information module, and intelligently aggregates the generated customer shipment parts ASN file into the ASN management module through the VBA background program.

[0009] The ASN management module is used to store and manage customer ASN templates and customer historical ASN data; it also generates the ASN analysis report required by the user for independent analysis of customer shipment data.

[0010] The user control interface is used for users to start using the tool. By using the control interface, users can enter the basic information module, ASN creation module and ASN management module, and operate the basic information module, ASN creation module and ASN management module.

[0011] The beneficial effects of the present invention are as follows: the method of the present invention can use a systematic tool to create and aggregate ASNs of different customers and factories in the same system tool, and based on the customer ASN template, parse and process the common fields and parts shipment quantities required by the ASN, thereby improving the efficiency and accuracy of ASN maintenance, centrally saving the basic information of each part required by the ASN, and realizing synchronous update of files related to external basic information with one click, performing intelligent reminders and automatic generation of maintenance of error-prone fields in the ASN, ensuring the correctness and efficiency of ASN maintenance, and automatically generating and saving ASN files that conform to the standard format, and intelligently managing customer historical ASN data. The method used is based on EXCEL software and its own VBA programming language, and does not require the installation of other related plug-ins or third-party software. It is simple and convenient to use, data generation is reliable and efficient, and data tracing and verification are simple and smooth.

[0012] As an improvement of the present invention, the usage control interface includes the input of user ID and password, customer selection and customer factory selection. After the operations of inputting user ID and password, customer selection and customer factory selection are performed, the usage control interface can then operate the basic information module, ASN creation module and ASN management module.

[0013] As an improvement of the present invention, the basic information module includes a basic information maintenance control unit for importing and updating basic information of newly added customer parts.

[0014] As an improvement of the present invention, the steps of using the basic information module include:

[0015] A1. Determine whether a new part is added. If yes, proceed to step A2. If no, proceed to step A6.

[0016] A2. Automatically import the parts packaging plan through VBA backend programming and proceed to step A3.

[0017] A3. Determine whether the VBA automatically checks whether the part is unique. If so, proceed to step A4; if not, proceed to step A5.

[0018] A4. Automatically update the part number to the latest base output and proceed to step A5;

[0019] A5. The latest parts data is stored and the process goes to step A6.

[0020] A6.End.

[0021] As an improvement of the present invention, the ASN creation module includes a barcode sequence generation control unit and an ASN generation control unit. The barcode sequence generation control unit intelligently generates the shipping barcode of the parts based on the information of the parts shipped this time. The ASN generation control unit intelligently captures and calculates all the changing fields involved in this shipment, intelligently generates the ASN file for this shipment, and stores the file in a designated location.

[0022] As an improvement of the present invention, the steps of using the ASN creation module include:

[0023] B1. Start;

[0024] B2. Maintain ASN common fields and initialize ASN field information;

[0025] B3 determines the VBA background programming check standardization, if the standard, proceeds to step B4, if not standardized, then returns to step B2, re-initialize the ASN field information;

[0026] B4. VBA programming backend to check ASN historical entrustment record information;

[0027] B5. Automatically generate the initial number of the new tray sequence;

[0028] B6. Automatically generate the initial serial number for new boxes;

[0029] B7. Determine the parts shipment quantity. This includes selecting and determining the parts to be shipped and the quantity. Once the parts are selected, basic information about the shipped parts is automatically generated through VBA programming linked to the basic information module.

[0030] B8. Based on the confirmed parts shipment quantity, the initial serial numbers for the new pallet, and the initial serial numbers for the new box, VBA programming is used to automatically generate consecutive serial numbers for each part, consecutive serial numbers for each part box, and the cumulative net and gross weights of each part shipped.

[0031] B9. Based on the parts' serial pallet numbers, the serial box numbers for each part, and the cumulative net and gross weights of each part shipped, a VBA backend program automatically captures these numbers and intelligently generates a barcode sequence generation control unit and an ASN generation control unit.

[0032] B10. The barcode sequence generation control unit and the ASN generation control unit automatically aggregate the ASN information for this shipment using VBA backend programming and send it to the ASN management module.

[0033] B11.End.

[0034] As an improvement of the present invention, in step B9, the barcode sequence generation control unit specifically includes automatic generation of the shipping barcode for each part and printing of the barcode for the parts shipped this time. The ASN generation control unit specifically includes calling the ASN standard format template through the VBA background program, intelligently capturing and calculating all the changed fields involved in this shipment, intelligently generating the ASN file for this shipment, and storing the ASN standard file for this shipment in a designated location.

[0035] As an improvement of the present invention, the ASN management module includes an ASN template control unit for updating and managing ASN templates and an ASN summary control unit for analyzing and managing ASN historical data.

[0036] As an improvement of the present invention, the steps of using the ASN template control unit include:

[0037] C1. Start;

[0038] C2 determines whether the ASN module needs to be updated, if yes, proceeds to step C3, if not, proceeds to step C4;

[0039] C3, update the ASN template, specifically including VBA programming to automatically update the corresponding relationship of public fields in the ASN creation template and automatically record the VBA programming template change log;

[0040] C4. End.

[0041] As an improvement of the present invention, the steps of using the ASN aggregation control unit include:

[0042] D1. Start;

[0043] D2. VBA programming to automatically organize ASN historical data;

[0044] D3. VBA programming, automatic analysis of ASN reconciliation data, automatic generation of ASN data according to conditions through VBA programming;

[0045] D4.VBA programming report automatic production;

[0046] D5. End. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 It is an overall flow chart of the present invention.

[0048] Figure 2 It is a flow chart of the use control interface of the present invention.

[0049] Figure 3 It is a flow chart of the basic information module of the present invention.

[0050] Figure 4It is a flow chart of the ASN creation module of the present invention.

[0051] Figure 5 It is a flow chart of the ASN template control unit of the present invention.

[0052] Figure 6 It is a flow chart of the ASN aggregation control unit of the present invention. DETAILED DESCRIPTION

[0053] The present invention is further explained with reference to the accompanying drawings.

[0054] See also Figures 1 to 6 The method shown is a method for intelligently generating ASN for client parts, including a usage control interface generated based on EXCEL, a basic information module, an ASN creation module and an ASN management module.

[0055] The user control interface is used for the user to start the operation of using the tool. By using the user control interface, the basic information module, ASN creation module and ASN management module can be entered and the basic information module, ASN creation module and ASN management module can be operated.

[0056] See Figure 2 As shown, the user control interface may include a user name input box, a password input box, a customer selection box, a customer factory selection box, a login button, and a logout button. The user name input box and the password input box are used together to enter the correct user name and password; the customer selection box is used for the user to select the correct customer for the shipped parts, and the customer factory selection box is used to select the corresponding customer shipping factory after the corresponding customer is selected for the shipped parts, thereby matching the shipped parts with the completely correct customer shipping destination and ensuring the correctness of subsequent series of operations; the login button is used for login click operation after the user name, password, customer selection, and customer factory selection are confirmed. If the entered user name or password is incorrect, a pop-up window will be displayed to remind the user of the error message so that the user can re-enter and log in. The logout button is used for the user to abandon the operation, exit the user control interface, and no longer use this tool.

[0057] After entering the user ID and password, selecting the customer and the customer factory, the user control interface can then be used to operate the tool's lower-level modules, namely the basic information module, ASN creation module and ASN management module.

[0058] The user interface is a floating form designed using Excel VBA backend programming. The username and password input boxes are text box controls, used to control corresponding text. The customer and factory selection boxes are list boxes. VBA backend programming enables fuzzy queries, narrowing the list by identifying query keywords. This allows for quick location and selection, especially when there are a large number of customers or factories. The login and logout buttons are button controls that, when clicked, work in conjunction with VBA backend programming to log in and out of the tool. Clicking the login button automatically and quickly verifies the correct username and password. If they are correct, the tool can be entered for the next step. If they are incorrect, a pop-up window will appear. After confirming the error, the user can close the pop-up window and try again to enter the correct username and password to log in. Clicking the logout button receives the logout instruction, closes the user interface window, and ends the tool.

[0059] The basic information module is used to store the basic information of customer-shipped parts and can dynamically manage the basic information of customer parts. The basic information of customer parts generally includes customer name, customer factory code, part number, part name, part measurement unit, part net weight, part packaging box type, packaging box net weight, pallet net weight, unit packaging capacity, number of single-pallet packaging boxes, etc. The basic information of customer parts can also be deleted or expanded according to the actual information required by the ASN of the specific customer-shipped parts.

[0060] The information of customer-shipped parts is stored in a worksheet. Each category of basic information of customer parts is treated as a field and expanded column by column in the form of a title in the same row. The specific information of each part corresponding to the customer-shipped part is stored row by row and column by column.

[0061] The Basic Information module includes a Basic Information Maintenance Control Unit, which is used to import and update basic information for newly added customer parts. The Basic Information Control Unit includes a VBA backend program and an Import button, which connects externally added part basic information files to the customer shipped parts information storage table, enabling one-click import, review, and update of externally added information. Externally added part basic information files typically refer to customer part packaging solution forms. These solution forms typically contain the same fields as the basic information for the customer shipped parts, facilitating comparison and analysis. New additions typically fall into two categories: adding a solution for a completely new part or updating a solution for an existing part. When new customer part packaging solution forms are added, they are typically stored in a folder in a common location. Then, by clicking the Import button in the Basic Information Maintenance Control Unit, the VBA backend program automatically extracts the corresponding field data from the external customer part packaging solution forms and compares it with the currently stored customer part information. If the part is a completely new part, the new part record is appended to the end of the storage table. If the part is an existing part, the existing stored information is checked for discrepancies and the discrepancies are updated one by one.

[0062] If there is no new basic part information during the actual use of the tool, you can skip this module.

[0063] See Figure 3 As shown, the steps for using the basic information module include:

[0064] A1. Determine whether a new part is added. If yes, proceed to step A2. If no, proceed to step A6.

[0065] A2. Automatically import the parts packaging plan through VBA backend programming and proceed to step A3.

[0066] A3. Determine whether the VBA automatically checks whether the part is unique. If so, proceed to step A4; if not, proceed to step A5.

[0067] A4. Automatically update the part number to the latest base output and proceed to step A5;

[0068] A5. The latest parts data is stored and the process goes to step A6.

[0069] A6.End.

[0070] The ASN creation module maintains the common fields of the ASN file of customer-shipped parts based on the basic information stored in the basic information module, generates new pallet initialization serial numbers and new box initialization serial numbers for ASN shipments, determines the quantity of parts shipped, intelligently generates barcodes for customer-shipped parts, and intelligently generates ASN files for customer-shipped parts; and intelligently aggregates the generated ASN files for customer-shipped parts into the ASN management module through the VBA background program.

[0071] When creating an ASN file for customer shipped parts, the maintenance information generally includes file common field information and shipped parts information.

[0072] Common fields generally refer to the variable fields within the standard fields in an ASN file, such as the header identifier, shipping date, ASN number, ASN creation time, actual shipment time of customer-shipped parts, and shipping document number. Common fields in an ASN file can be initialized and configured based on the ASN template and individually assigned to corresponding cells in the form. Users can then maintain each field in the corresponding cell according to its specifications. The VBA backend automatically checks and analyzes each field for compliance. When a cell is clicked to maintain a field, a pop-up window displays the maintenance requirements. When field maintenance is complete, a check is performed to ensure correct maintenance. If not, a pop-up window will appear to remind you of the requirements, ensuring accuracy. For example, if the ASN creation time is maintained as 2020-02-23 / 11:05, a pop-up window will prompt you to maintain it in the correct format, such as YYYY-MM-DD / hh:mm. When maintaining an ASN, the VBA backend automatically analyzes and calculates historical ASN records and generates a new ASN, ensuring the standardization and uniqueness of the ASN number for the customer shipment.

[0073] The relevant information of the parts shipped by the customer generally refers to the serial number information of the customer's shipping box, the serial number information of the pallet, the shipped part number, the part name, the unit of measurement, the quantity of parts shipped, the cumulative net weight and gross weight of the parts, etc.

[0074] The initial serial number for a new pallet shipped with an ASN is the starting serial number for the pallet shipped this time. The serial number increments by 1 for each additional pallet. The initial serial number for a new box shipped with an ASN is the starting serial number for the box shipped this time. All pallet and box serial numbers must be unique and must be unique. A new pallet and box initial serial number for ASN shipments is generated by a VBA background program that automatically traverses historical ASN information and intelligently generates the initial serial number by adding 1 to the historical maximum pallet and box serial numbers. For example, the pallet serial number is specified as a 6-digit continuous serial number starting from 100000, and the box serial number is specified as an 8-digit continuous serial number starting from 20000000. When the historical maximum pallet serial number is 100100, the new pallet initialization serial number 100101 is automatically generated. When the historical maximum box serial number is 20001000, the new box initialization serial number 20001001 is automatically generated. If there is no historical record, it means it is the first shipment, then the new pallet initialization serial number 100000 is automatically generated, and the new box initialization serial number 20000000 is automatically generated.

[0075] Determining the quantity of parts shipped involves selecting and determining the quantity of the parts to be shipped. This selection is accomplished through the following filtering methods. Once a part is selected, its corresponding basic parameters, such as part name, unit of measurement, net weight, box type, and packaging capacity, are displayed synchronously via the VBA backend program connected to the Basic Information module. Quantity determination can be performed manually, through batch indexing using a VLOOKUP formula, or through VBA programming.

[0076] Based on the determination of the shipment quantity of each part, as well as the determination of the new pallet initialization serial number and the new box initialization serial number for this ASN shipment, the VBA background program is used to automatically generate the continuous pallet serial number of each part, the continuous box serial number of each part, and the cumulative net weight and gross weight of each part shipment.

[0077] The ASN creation module includes a barcode sequence control unit and an ASN generation control unit. The barcode control unit includes a VBA background program and a button control. By clicking the button, the VBA background program is linked to automatically capture the pallet and box serial number information of each part shipped this time, as well as information such as the net weight and gross weight of the parts, and intelligently generates the shipping barcode for each part, and then implements the barcode batch printing job. The ASN generation control unit includes a VBA background program and a button control. By clicking the button, the VBA background program is linked to call the ASN standard format template, intelligently captures and calculates all the changing fields involved in this shipment, intelligently generates the ASN file for this shipment, and stores the file in the specified location. At the same time, through the operation of these two control units, the main information of the ASN for this shipment, such as the ASN number, shipping date, number of parts shipped, the pallet serial number and box serial number of each part shipped, etc., will be intelligently summarized into the ASN management module through the VBA background program.

[0078] The ASN creation module includes a barcode sequence generation control unit and an ASN generation control unit. The barcode sequence generation control unit intelligently generates the shipping barcode of the parts based on the information of the parts shipped this time. The ASN generation control unit intelligently captures and calculates all the changing fields involved in this shipment, intelligently generates the ASN file for this shipment, and stores the file in a designated location.

[0079] See Figure 4 As shown, the steps for using the ASN creation module include:

[0080] B1. Start;

[0081] B2. Maintain ASN common fields and initialize ASN field information;

[0082] B3 determines the VBA background programming check standardization, if the standard, proceeds to step B4, if not standardized, then returns to step B2, re-initialize the ASN field information;

[0083] B4. VBA programming backend to check ASN historical entrustment record information;

[0084] B5. Automatically generate the initial number of the new tray sequence;

[0085] B6. Automatically generate the initial serial number for new boxes;

[0086] B7. Determine the parts shipment quantity. This includes selecting and determining the parts to be shipped and the quantity. Once the parts are selected, basic information about the shipped parts is automatically generated through VBA programming linked to the basic information module.

[0087] B8. Based on the confirmed parts shipment quantity, the initial serial numbers for the new pallet, and the initial serial numbers for the new box, VBA programming is used to automatically generate consecutive serial numbers for each part, consecutive serial numbers for each part box, and the cumulative net and gross weights of each part shipped.

[0088] B9. Based on the determination of the serial number of the parts' consecutive pallets, the serial number of each part's consecutive boxes, and the cumulative net weight and gross weight of each part's shipment, the VBA background program automatically captures these information and intelligently generates a barcode sequence generation control unit and an ASN generation control unit. The barcode sequence generation control unit specifically generates the barcodes for each part's shipment and prints the barcodes for the parts in this shipment. The ASN generation control unit specifically calls the ASN standard format template through the VBA background program, intelligently captures and calculates all variable fields involved in this shipment, intelligently generates the ASN file for this shipment, and stores the standard ASN file for this shipment in a designated location.

[0089] B10. The barcode sequence generation control unit and the ASN generation control unit automatically aggregate the ASN information for this shipment using VBA backend programming and send it to the ASN management module.

[0090] B11.End.

[0091] The ASN management module is used to store and manage customer ASN templates and to store and manage customer historical ASN data; the ASN management module includes an ASN template control unit for updating and managing ASN templates and an ASN summary control unit for analyzing and managing ASN historical data.

[0092] The ASN template control unit is used to update and manage ASN templates. The ASN template is a standard format template for customer ASN files and is stored in the ASN management module as a worksheet. Generally, fields in some format templates are added or deleted based on customer requirements. When a customer updates their requirements, by clicking a button control, the VBA background program will automatically update the format template in the form, analyze and compare the differences between the old and new format templates, and automatically record the differences for user reference. At the same time, the VBA background program automatically updates the public field correspondence in the ASN creation module, ensuring that the public fields in the ASN creation module remain up to date.

[0093] The ASN aggregation control unit is used for analyzing and managing historical ASN data. With a single click, the VBA background program automatically organizes historical customer shipment ASN data, including, for example, the breakdown of shipment dates by year, month, and day, and the splitting of shipment parts by pallet and box. With a single click, the VBA background program compares and analyzes discrepancies between customer reconciliation data and stored historical ASN data. When discrepancies occur, the rows containing the discrepant historical data are automatically shaded red, and when no discrepancies occur, the rows containing the historical data are shaded green, facilitating visual and comparative analysis and accurate reconciliation. The VBA background program automatically generates the required ASN data based on various criteria combinations. Criteria can be entered or selected in individual cells as needed, such as part number, date (year / month), ASN number, pallet number, box number, and whether or not reconciliation is being performed. With the two buttons above and then a single click, the VBA background program automatically generates the required ASN analysis report for independent analysis of customer shipment data, facilitating information exchange with customers.

[0094] See Figure 5 As shown, the steps for using the ASN template control unit include:

[0095] C1. Start;

[0096] C2 determines whether the ASN module needs to be updated, if yes, proceeds to step C3, if not, proceeds to step C4;

[0097] C3, update the ASN template, specifically including VBA programming to automatically update the corresponding relationship of public fields in the ASN creation template and automatically record the VBA programming template change log;

[0098] C4. End.

[0099] See Figure 6 As shown, the steps for using the ASN summary control unit include:

[0100] D1. Start;

[0101] D2. VBA programming to automatically organize ASN historical data;

[0102] D3. VBA programming, automatic analysis of ASN reconciliation data, automatic generation of ASN data according to conditions through VBA programming;

[0103] D4.VBA programming report automatic production;

[0104] D5. End.

[0105] The method of the present invention can use a systematic tool to create and aggregate ASNs of different customers and factories in the same system tool, and based on the customer ASN template, parse and process the common fields and parts shipment quantities required by the ASN, thereby improving the efficiency and accuracy of ASN maintenance, centrally saving the basic information of each part required by the ASN, and realizing synchronous update of files related to external basic information with one click, and providing intelligent reminders and automatic generation of maintenance for error-prone fields in the ASN, thereby ensuring the correctness and efficiency of ASN maintenance, and automatically generating and saving ASN files that conform to the standard format, and intelligently managing customer historical ASN data. The method used is based on EXCEL software and its own VBA programming language, and does not require the installation of other related plug-ins or third-party software. It is simple and convenient to use, generates data reliably and efficiently, and makes data tracing and verification simple and smooth.

[0106] The above description is only a preferred embodiment of the present invention. Therefore, any equivalent changes or modifications made according to the structure, characteristics and principles described in the scope of the patent application of the present invention are included in the scope of the patent application of the present invention.

Claims

1. A method for intelligently generating ASN for client parts, characterized by: Including those generated based on EXCEL: The basic information module is used to store the basic information of customer-shipped parts and can dynamically manage the basic information of customer parts. The basic information of customer parts includes customer name, customer factory code, part number, part name, part measurement unit, part net weight, part packaging box type, packaging box net weight, pallet net weight, unit packaging capacity, and number of packaging boxes per pallet; The ASN creation module maintains the common fields of the customer shipped parts ASN file based on the basic information stored in the basic information module, and intelligently aggregates the generated customer shipped parts ASN file into the ASN management module through the VBA background program; The ASN management module is used to store and manage customer ASN templates and customer historical ASN data; it also generates the ASN analysis reports required by users for independent analysis of customer shipment data; The user control interface is used for users to start using the tool. Through the user control interface, users can enter the basic information module, ASN creation module and ASN management module and operate the basic information module, ASN creation module and ASN management module; The steps for using the ASN creation module include: B1. Start; B2. Maintain ASN common fields and initialize ASN field information; B3 determines the VBA background programming check standardization If the standard, then proceed to step B4, if not standardized, then return to step B2, re-initialize the ASN field information; B4. VBA programming backend to check ASN historical entrustment record information; B5. Automatically generate the initial number of the new tray sequence; B6. Automatically generate the initial serial number for new boxes; B7. Determine the parts shipment quantity. This includes selecting and determining the parts to be shipped and the quantity. Once the parts are selected, basic information about the shipped parts is automatically generated through VBA programming linked to the basic information module. B8. Based on the confirmed parts shipment quantity, the initial serial numbers for the new pallet, and the initial serial numbers for the new box, VBA programming is used to automatically generate consecutive serial numbers for each part, consecutive serial numbers for each part box, and the cumulative net and gross weights of each part shipped. B9. Based on the parts' serial pallet numbers, the serial box numbers for each part, and the cumulative net and gross weights of each part shipped, a VBA backend program automatically captures these numbers and intelligently generates a barcode sequence generation control unit and an ASN generation control unit. In step B9, the barcode sequence generation control unit specifically includes automatic barcode generation for each part and barcode printing for the current shipment. The ASN generation control unit specifically includes calling the ASN standard format template through the VBA background program, intelligently capturing and calculating all the changing fields involved in the current shipment, intelligently generating the ASN file for this shipment, and storing the ASN standard file for this shipment in a designated location. B10. The barcode sequence generation control unit and the ASN generation control unit automatically aggregate the ASN information for this shipment using VBA backend programming and send it to the ASN management module. B11.End.

2. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The usage control interface includes the input of user ID and password, customer selection and customer factory selection. After the operations of inputting user ID and password, customer selection and customer factory selection are completed, the usage control interface can then operate the basic information module, ASN creation module and ASN management module.

3. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The basic information module includes a basic information maintenance control unit for importing and updating basic information of new customer parts.

4. The method for intelligently generating ASN for client parts according to claim 3, characterized in that: The steps for using the basic information module include: A1. Determine whether a new part is added. If yes, proceed to step A2. If no, proceed to step A6. A2. Automatically import the parts packaging plan through VBA backend programming and proceed to step A3. A3. Determine whether the VBA automatically checks whether the part is unique. If so, proceed to step A4; if not, proceed to step A5. A4. Automatically update the part number to the latest base output and proceed to step A5; A5. The latest parts data is stored and the process goes to step A6. A6.End.

5. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The ASN creation module includes a barcode sequence generation control unit and an ASN generation control unit. The barcode sequence generation control unit intelligently generates the shipping barcode of the parts based on the information of the parts shipped this time. The ASN generation control unit intelligently captures and calculates all the changing fields involved in this shipment, intelligently generates the ASN file for this shipment, and stores the file in a designated location.

6. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The ASN management module includes an ASN template control unit for updating and managing ASN templates and an ASN summary control unit for analyzing and managing ASN historical data.

7. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The steps for using the ASN template control unit include: C1. Start; C2 determines whether the ASN module needs to be updated, if yes, proceeds to step C3, if not, proceeds to step C4; C3, update the ASN template, specifically including VBA programming to automatically update the corresponding relationship of public fields in the ASN creation template and automatically record the VBA programming template change log; C4. End.

8. The method for intelligently generating ASN for client parts according to claim 1, characterized in that: The steps for using the ASN aggregation control unit include: D1. Start; D2. VBA programming to automatically organize ASN historical data; D3. VBA programming, automatic analysis of ASN reconciliation data, automatic generation of ASN data according to conditions through VBA programming; D4.VBA programming report automatic production; D5. End.

Images