Method for realizing automatic charging based on multi-dimensional logistics price list

Abstract

The invention belongs to the technical field of logistics platforms, and particularly relates to a method for realizing automatic charging based on a multi-dimensional logistics price list, which comprises the following steps of: 1, configuring a logistics price list and pricing rules which comprise a data preprocessing rule, a price list visualization rule and a data post-processing rule; step 2, data acquisition, wherein the step comprises acquisition of logistics order data and visual acquisition and maintenance of price list data; and step 3, cost calculation is carried out based on a pricing rule and the collected data. According to the invention, more accurate unit price filling of logistics orders and combined processing of multiple types of price data are realized, and the accuracy and reliability of automatic charging under complex conditions are effectively improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of logistics platforms, and in particular relates to a method for realizing automatic billing based on a multi-dimensional logistics price list. Background Art

[0002] In the existing technology, the billing situation in the logistics and transportation industry is relatively complicated. In addition to the logistics price list with its own billing unit price (yuan / ton, yuan / ton / kilometer), there are also various additional pricing rules, which together constitute the billing logic of logistics and transportation.

[0003] However, most of the products on the market cannot support multi-dimensional logistics price list configuration, nor can they perform visual editing of price lists and customize pricing rules based on this. These problems together lead to the inability to achieve high automation in the field of logistics transportation billing, and the inability to reduce the workload of manual accounting, and the system effect is not ideal.

[0004] In this context, I invented a set of pricing rules, which enabled the custom configuration and visual editing of logistics price lists and the automatic billing of logistics orders, greatly improving the billing automation and work efficiency of industry customers in the field of logistics and transportation accounting. Summary of the invention

[0005] The purpose of the present invention is to provide a method for realizing automatic billing based on a multi-dimensional logistics price list, which is used to solve the technical problems that the existing technology on the logistics platform has the problem that it is difficult for customers to comprehensively calculate multiple types of logistics costs with different billing methods and billing levels based on the information in the price list in terms of logistics transportation cost accounting, resulting in a low degree of automation of the billing method, difficulty in adapting to comprehensive billing in multiple scenarios, and difficulty in maintaining and updating the data of the logistics price list, which affects the accuracy of the billing.

[0006] The method for realizing automatic billing based on a multi-dimensional logistics price list comprises the following steps.

[0007] Step 1: Configure the logistics price list and pricing rules, which include data preprocessing rules, price list visualization rules and data post-processing rules.

[0008] Step 2: Collect data. This step includes collecting logistics order data and visually collecting and maintaining price list data.

[0009] Step 3: Calculate the cost based on the pricing rules and the collected data.

[0010] Preferably, step one configures the logistics price list fields, which involve dimension fields and unit price fields. This step defines the dimension fields used to describe the logistics information in the price list, and also defines the unit price fields for different pricing methods and pricing ranges.

[0011] Preferably, in the step 1, in the data preprocessing logic, a batch merging processing rule is configured;

[0012] In the unit price matching rules, configure the maintenance information matching rules and unit price drop rules; in the data post-processing, configure the price fluctuation and multi-table matching return rules.

[0013] Preferably, the data preprocessing rules include: performing data preprocessing on multiple logistics orders according to the configured preprocessing logic to form an order set; the preprocessing methods include: summarizing the tonnage, volume, number of pick-up points, and number of unloading points according to delivery time and logistics routes, and performing merged batch processing; the data preprocessing methods also include data cleaning and precision conversion.

[0014] Preferably, the dimension information matching rules include: matching the dimension data of the order set with the dimension data of the price list according to the dimension field of the price list, the method supports the priority matching of the pickup location and the unloading location of the logistics route at the minimum granularity of provinces, cities and districts, and also supports other dimensions containing numerical values ​​to be matched by numerical equality by default; after matching the price line of the logistics price list through the attributes of the order set, proceed to the next step, otherwise return a null value and end the current billing.

[0015] Preferably, after matching the price row in the price table, the numerical attribute of the order set is conditionally matched with the price level. After matching the level, the billing unit price can be found to proceed to the next step, otherwise a null value is returned.

[0016] Preferably, in step one, the data post-processing rules include: after calculating the logistics costs according to the unit price, subsequent rule calculations for price fluctuations are performed, and in the data post-processing stage, the method supports the combination logic of multi-table settlement; price fluctuations are based on post-processing functions, including cost items, floating percentages and base parameters.

[0017] Preferably, in step one, the logistics price table data is displayed in the system according to the field configuration. Through the logistics price table field configuration, the logistics pricing data is displayed in a tabular form, and can be queried according to the dimension field conditions. The data rows of the price table can be maintained based on the visual information and stored in the system.

[0018] Preferably, the step three comprises.

[0019] 1) Preprocess the logistics order data.

[0020] 2) Match dimensional information for the preprocessed data.

[0021] 3) Adjust the unit price according to the matching results.

[0022] 4) Calculate the cost based on the unit price range obtained from the filing.

[0023] 5) Perform data post-processing on the cost calculation results and output the obtained logistics cost data.

[0024] Preferably, each sub-step of step three specifically includes.

[0025] 1) This step performs preprocessing of the logistics order data such as numerical merging, data cleaning, and precision conversion according to the set data preprocessing rules.

[0026] 2) This step matches the logistics order data with the corresponding dimension information in the price list data based on the dimension information matching rules, thereby matching the attributes of the order set to the price rows of the logistics price list.

[0027] 3) According to the numerical attributes of the order set and the corresponding gear in the unit price field in the price table data, conditional matching is performed to complete the corresponding unit price leveling.

[0028] 4) Calculate the several billing unit prices and the order set values ​​to calculate the logistics cost of a single item in the order.

[0029] 5) The calculation results of the previous step are processed according to the data post-processing rules, and the logistics costs of multiple items are merged again according to the cost type, and then the merged data is returned to the business demander to complete the billing automation.

[0030] The present invention has the following advantages: The present invention provides a set of visual configuration rules for logistics price lists, which realizes the configurability and visual maintenance of logistics price lists with complex structures. Through the configuration of pricing logic rules and billing automation, more accurate unit price filing of logistics orders and combined processing of various types of price data are realized, which can meet the comprehensive billing of various scenarios such as long-distance trunk lines and short-distance distribution of logistics, and effectively improve the accuracy and reliability of automatic billing in complex situations.

[0031] This method matches and calculates logistics orders according to the logistics price list and billing rules, and follows the steps of data preprocessing, dimensional information matching, unit price filing, cost calculation and data post-processing to complete the automation of logistics billing; and during the billing process, the unit price source and calculation process are recorded to facilitate result tracing. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 The present invention is a flowchart of a method for realizing automatic billing based on a multi-dimensional logistics price list.

[0033] Figure 2 The present invention is a schematic diagram of the price list visualization logic in a method for realizing automatic billing based on a multi-dimensional logistics price list. DETAILED DESCRIPTION

[0034] The specific implementation modes of the present invention are further explained in detail below by describing the embodiments with reference to the accompanying drawings, so as to help those skilled in the art to have a more complete, accurate and in-depth understanding of the inventive concept and technical solution of the present invention.

[0035] like Figure 1 , Figure 2 As shown, the present invention provides a method for realizing automatic billing based on a multi-dimensional logistics price list, comprising the following steps.

[0036] Step 1: Configure the logistics price list and pricing rules, which include data preprocessing rules, price list visualization rules and data post-processing rules.

[0037] This step is specifically configured for the visualized logistics price list.

[0038] 1) Configure the logistics price list fields.

[0039] The price list visualization rules involve dimension fields and unit price fields. This step defines dimension fields such as logistics routes and cargo attributes, and describes the logistics information in the price list. This step also defines unit price fields for different pricing methods and pricing ranges. For example, the pricing range includes less than 2 tons and 2 tons and above. The pricing methods include: charging by weight, with unit prices of RMB / ton and RMB / ton / kilometer; charging by volume, with unit prices of RMB / cubic meter and RMB / cubic meter / kilometer; charging by cargo, RMB / piece and RMB / piece / kilometer; charging by pick-up and unloading location, RMB / pick-up point and RMB / delivery point.

[0040] 2) Configure logistics pricing logic rules.

[0041] In the data preprocessing logic, configure the rules for batch merging processing.

[0042] Data preprocessing rules include: performing data preprocessing on multiple logistics orders (i.e., logistics order data) according to the configured preprocessing logic to form an order set. Preprocessing methods include: aggregating tonnage, volume, number of pickup points, and number of unloading points according to delivery time, logistics routes, etc., and performing merged batch processing. In addition, data preprocessing may also include other data preprocessing methods, such as data cleaning, data standardization, precision conversion, etc.

[0043] In the unit price matching rules, you can customize the maintenance information matching rules and unit price filing rules.

[0044] The dimension information matching rules include: matching the dimension data of the order set with the dimension data of the price list according to the dimension fields of the price list, supporting the priority matching of the pick-up and unloading locations of the logistics route according to the minimum granularity of provinces, cities and districts, and matching other dimensions such as cargo information by default according to equal values. Another matching method is to match according to the programmable custom dimension matching function, and only proceed to the next step after matching the attributes of the order set to the price line of the logistics price list, otherwise it returns a null value and ends this billing.

[0045] The unit price ranking rules include: after matching the price line in the price list, conditionally matching the numerical attributes of the order set, such as weight in tons, volume in cubic meters, mileage in kilometers, etc., with the price level. For example, if the order set weighs 1 ton, it will match the level <2 tons. After matching the level, the billing unit price can be found and the next step can be entered. Otherwise, a null value will be returned.

[0046] In data post-processing, you can configure the rules for price fluctuations and multi-table matching returns.

[0047] Data post-processing rules include: after calculating logistics costs based on unit prices, some subsequent price fluctuation rules are calculated, and the system supports the combination logic of multi-table settlement in the data post-processing stage. Price fluctuation is based on post-processing functions, including cost items, floating percentages, bases and other parameters.

[0048] 3) Visualization and maintenance of logistics price lists.

[0049] The logistics price table data is displayed in the system according to the field configuration. Through the logistics price table field configuration, the logistics pricing data can be displayed in a tabular form, queried by dimension field conditions, and pricing data can be maintained. Users can maintain the data rows of the price table based on the visualized information and store them in the system.

[0050] Step 2: Collect data. This step includes collecting logistics order data and visually collecting and maintaining price list data.

[0051] The system displays the logistics price list data according to the field configuration. Through the logistics price list field configuration, the logistics pricing data can be displayed in a tabular form, queried by dimension field conditions, and the pricing data can be maintained. Users can maintain the data rows of the price list based on the visual information and store them in the system. At the same time, the system also collects the corresponding logistics order data from multiple logistics orders.

[0052] Step 3: Calculate the cost based on the pricing rules and the collected data. This step includes the following sub-steps.

[0053] 1) Preprocess the logistics order data.

[0054] This step performs preprocessing of the logistics order data such as numerical merging, data cleaning, and precision conversion according to the set data preprocessing rules. The preprocessed logistics order data should be easy to match with the price list data.

[0055] 2) Match dimensional information for the preprocessed data.

[0056] This step matches the logistics order data with the corresponding dimension information in the price table data based on the dimension information matching rules, thereby matching the attributes of the order set to the price rows of the logistics price table.

[0057] 3) Adjust the unit price according to the matching results.

[0058] According to the numerical attributes of the order set (tons of weight, cubic meters of volume, kilometers of mileage), conditions are matched with the corresponding gears in the unit price field in the price list data to complete the corresponding unit price gearing.

[0059] 4) Calculate the cost based on the unit price range obtained from the filing.

[0060] Calculate several billing unit prices and order set values, usually unit price*value (tonnage*yuan / ton, volume*yuan / cubic meter, number of pick-up points*yuan / point, etc.), to calculate the logistics cost of a single item in the order.

[0061] 5) Perform data post-processing on the cost calculation results and output the obtained logistics cost data.

[0062] The calculation results of the previous step are processed according to the data post-processing rules. The logistics costs of multiple items can be merged again according to the cost type, and the merged data is returned to the business demander to complete the billing automation.

[0063] The present invention is described above by way of example in conjunction with the accompanying drawings. It is obvious that the specific implementation of the present invention is not limited to the above-mentioned method. As long as various non-substantial improvements are made using the inventive concept and technical solution of the present invention, or the inventive concept and technical solution are directly applied to other occasions without improvement, they are all within the protection scope of the present invention.

Claims

1. A method for realizing automatic billing based on a multi-dimensional logistics price list, characterized in that: The following steps are involved: Step 1: Configure the logistics price list and pricing rules, which include data pre-processing rules, price list visualization rules and data post-processing rules; Step 2: Collect data. This step includes collecting logistics order data and visually collecting and maintaining price list data. Step 3: Calculate the cost based on the pricing rules and the collected data.

2. A method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: Step 1 configures the logistics price table fields. The logistics price table fields involve dimension fields and unit price fields. This step defines the dimension fields used to describe the logistics information in the price table, and also defines the unit price fields for different pricing methods and pricing ranges.

3. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: In the step 1, In the data preprocessing logic, configure the rules for batch merging processing; In the unit price matching rule, configure the maintenance information matching rule and the unit price drop rule; In data post-processing, configure the rules for price fluctuations and multi-table matching returns.

4. A method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 3, characterized in that: Data preprocessing rules include: preprocessing multiple logistics orders according to the configured preprocessing logic to form an order set; preprocessing methods include: summarizing tonnage, volume, number of pick-up points, and number of unloading points according to delivery time and logistics routes, and merging batches; data preprocessing methods also include data cleaning and precision conversion.

5. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 3, characterized in that: The dimension information matching rules include: matching the dimension data of the order set with the dimension data of the price list according to the dimension fields of the price list. The method supports the priority matching of the pickup location and the unloading location of the logistics route according to the minimum granularity of provinces, cities and districts, and also supports other dimensions containing numerical values ​​to be matched by numerical equality by default; only after matching the price line of the logistics price list through the attributes of the order set, proceed to the next step, otherwise return a null value and end the current billing.

6. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 3, characterized in that: After matching the price row in the price table, the numerical attribute of the order set is matched with the price level. After matching the level, the billing unit price can be found and the next step can be entered. Otherwise, a null value is returned.

7. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: In the step 1, the data post-processing rules include: after calculating the logistics costs according to the unit price, the subsequent rules for price fluctuation are calculated, and in the data post-processing stage, the method supports the combination logic of multi-table settlement; the price fluctuation is based on the post-processing function, including cost items, floating percentage and base parameters.

8. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: In the step one, the logistics price table data is displayed in the system according to the field configuration. Through the logistics price table field configuration, the logistics pricing data is displayed in a tabular form, and can be queried according to the dimension field conditions. The data rows of the price table can be maintained based on the visual information and stored in the system.

9. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: The step three comprises: 1) Preprocess logistics order data; 2) Perform dimensional information matching on the preprocessed data; 3) Implement unit price adjustment based on matching results; 4) Calculate the cost based on the unit price range obtained from the filing; 5) Perform data post-processing on the cost calculation results and output the obtained logistics cost data.

10. The method for realizing automatic billing based on a multi-dimensional logistics price list according to claim 1, characterized in that: The sub-steps of step three specifically include: 1) This step performs preprocessing such as numerical merging, data cleaning, and precision conversion on the logistics order data according to the set data preprocessing rules; 2) This step matches the logistics order data with the corresponding dimension information in the price table data based on the dimension information matching rules, thereby matching the attributes of the order set to the price rows of the logistics price table; 3) According to the numerical attributes of the order set and the corresponding level in the unit price field in the price table data, conditions are matched to complete the corresponding unit price level; 4) Calculate the several billing unit prices and the order set values ​​to calculate the logistics cost of a single item in the order; 5) The calculation results of the previous step are processed according to the data post-processing rules, and the logistics costs of multiple items are merged again according to the cost type, and then the merged data is returned to the business demander to complete the billing automation.

Images