Telus TPM Documentation

User Tools

Site Tools

Trace: • auto_matching_rules
auto_matching_rules

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
auto_matching_rules [2024/10/08 13:44] – tina.roblesauto_matching_rules [2025/02/26 13:44] (current) – tina.robles
Line 8: Line 8:
 **IMPORTANT**:   When using these settings, it is recommended that if you turn a setting on you do it for all three fields – Claim invoice, Deduction Hint, and Deduction Invoice **IMPORTANT**:   When using these settings, it is recommended that if you turn a setting on you do it for all three fields – Claim invoice, Deduction Hint, and Deduction Invoice
  
-• **Allow contains**:  This will look for matches between the three fields (deduction hint, deduction invoice, and claim invoice).  This approach enhances match accuracy by identifying partial matches rather than requiring exact correspondence.  **Example**:  Deduction invoice 012345/P/0456, claim invoice 12345+• **Allow contains**:  This will look for matches between the three fields (deduction hint, deduction invoice, and claim invoice).  The contains option is from deduction invoice to claim invoice. This approach enhances match accuracy by identifying partial matches rather than requiring exact correspondence.  **Example**:  Deduction invoice 012345/P/0456, claim invoice 12345
  
 • **Match options**:  This is used for customers where the deduction customer names are different company id than what is used on the claims.  **Example**:  Deduction is the Plan to company id and the claims are at the Ship to company id.  • **Match options**:  This is used for customers where the deduction customer names are different company id than what is used on the claims.  **Example**:  Deduction is the Plan to company id and the claims are at the Ship to company id. 
Line 22: Line 22:
 {{:pasted:20241008-131933.png}} {{:pasted:20241008-131933.png}}
  
 +-----
  
 **Configurable Fields** **Configurable Fields**
  
-1) Allow contains Match on comparison Fields+A) Allow contains Match on comparison Fields
  
-2) Match Claimant +B) Match Claimant 
-  a.  Parent Grouping +   - Parent Grouping 
-  b.  Buying Group+  -  Buying Group
  
-3) Match deduction +C) Match deduction 
-  a.  Parent Grouping +   - Parent Grouping 
-  b.  Buying Grouping+  - Buying Grouping
  
-4) Strip Alpha  +D) Strip Alpha  
-  a.  Deduction Invoice +  - Deduction Invoice 
-  b.  Claim Invoice +  - Claim Invoice 
-  c.  Deduction Hint+  - Deduction Hint
  
-5)  Strip Characters +E) Strip Characters 
-  a.  Deduction Invoice  +  - Deduction Invoice  
-  b.  Claim Invoice +  - Claim Invoice 
-  c.  Deduction Hint +  - Deduction Hint
- +
-6) Strip Leading Zeros Deduction Invoice +
-  a.  Deduction Invoice +
-  b.  Claim Invoice +
-  c.  Deduction hint+
  
 +F) Strip Leading Zeros Deduction Invoice
 +  - Deduction Invoice
 +  - Claim Invoice
 +  - Deduction Hint
  
 Below are a few examples of what settings would need to be true for the below to auto match.   Below are a few examples of what settings would need to be true for the below to auto match.  
  
-1)  PFG NJ +__PFG NJ__ 
-  a.  Deduction customer name/id – PFG NJ 44444 +  - Deduction customer name/id – PFG NJ 44444 
-  b.  Deduction Invoice num = 0168129/P/0410 +  - Deduction Invoice num = 0168129/P/0410 
-  c.  Claimant Claim name/id = PFG New Jersey 12345 +  - Claimant Claim name/id = PFG New Jersey 12345 
-  d.  Claim Invoice num = 168129 +  - Claim Invoice num = 168129 
-  e.  Deduction Hint = (blank) +  - Deduction Hint = (blank) 
-  f.  **Recommendation**:  The deduction invoice number contains extra information compared to the claim.  The 0 in front and al the data after the 9.   Also, the company ids are different.  They are the same company but different levels in the distributor hierarchy.   +  - **Recommendation**:  The deduction invoice number contains extra information compared to the claim.  The 0 in front and al the data after the 9.   Also, the company ids are different.  They are the same company but different levels in the distributor hierarchy.   
-    i. Strip leading zeros from Deduction invoice number   +Strip leading zeros from Deduction invoice number  
-    ii. Strip characters from Deduction invoice number +  
-    iii. Contains setting on +Strip characters from Deduction invoice number 
-    iv. Match claimant to parent group and match deduction company to parent+ 
 +Contains setting on 
 + 
 +Match claimant to parent group and match deduction company to parent
          
-2)  Ben E Keith Edmond +__Ben E Keith Edmond__ 
-  a.  Deduction customer name/id – BEK Edmond 787878 +  - Deduction customer name/id – BEK Edmond 787878 
-  b.  Deduction Invoice num = FOK6661029702-00 +  - Deduction Invoice num = FOK6661029702-00 
-  c.  Claimant Claim name/id = BEK Edmond 787878 +  - Claimant Claim name/id = BEK Edmond 787878 
-  d.  Claim Invoice num = 66610297 +  - Claim Invoice num = 66610297 
-  e.  Deduction Hint = (blank) +  - Deduction Hint = (blank) 
-  f.  **Recommendation**:  The deduction invoice numbers has extra alpha in the front and extra numbers and characters after the 7 +  - **Recommendation**:  The deduction invoice numbers has extra alpha in the front and extra numbers and characters after the 7 
-    i. Strip alpha from Deduction invoice number +Strip alpha from Deduction invoice number
-    ii. Strip characters from Deduction invoice number +
-    iii.  Contains setting on+
  
-3)  Kroger +Strip characters from Deduction invoice number 
-  a.  Deduction customer name/id = Kroger 22222 + 
-  b.  Deduction Invoice num = 0090222423-CM +Contains setting on 
-  c.  Claimant Claim name/id = Kroger 22222 + 
-  d.  Claim Invoice num = 90222423 +__Kroger__ 
-  e.  Deduction Hint = (blank) +  - Deduction customer name/id = Kroger 22222 
-  f.  **Recommendation**:  The deduction invoice numbers has extra zeros in the front and an extra character and letters after the 3 +  - Deduction Invoice num = 0090222423-CM 
-    i. Strip leading zeros from Deduction invoice number   +  - Claimant Claim name/id = Kroger 22222 
-    ii. Strip alpha from Deduction invoice number +  - Claim Invoice num = 90222423 
-    iii. Strip characters from Deduction invoice number +  - Deduction Hint = (blank) 
-    iv. Contains setting on+  - **Recommendation**:  The deduction invoice numbers has extra zeros in the front and an extra character and letters after the 3 
 +Strip leading zeros from Deduction invoice number 
 +   
 +Strip alpha from Deduction invoice number 
 + 
 +Strip characters from Deduction invoice number 
 + 
 +Contains setting on
          
-4)  Dot Foods +__Dot Foods__ 
-  a.  Deduction customer name/id = Dot Foods 12345 +  - Deduction customer name/id = Dot Foods 12345 
-  b.  Deduction Invoice num = DEE8618076 +  - Deduction Invoice num = DEE8618076 
-  c.  Claimant Claim name/id = Sygma Denver Dot 87910 +  - Claimant Claim name/id = Sygma Denver Dot 87910 
-  d.  Claim Invoice num = 2024 KDM_215685 +  - Claim Invoice num = 2024 KDM_215685 
-  e.  Deduction Hint = DEE-8618076 +  - Deduction Hint = DEE-8618076 
-  f.  **Recommendation**:  The deduction hint contains a character (-) but the invoice number does not. Strip leading zeros from Deduction invoice number   +  - **Recommendation**:  The deduction hint contains a character (-) but the invoice number does not. Strip leading zeros from Deduction invoice number   
-    i. Strip characters from Deduction hint +Strip characters from Deduction hint 
-    ii. Deduction AGG will take care of the completely different company names so no setting needed for that part + 
 +Deduction AGG will take care of the completely different company names so no setting needed for that part  
 +----- 
 + 
 +**Auto Set Labels** 
 +These rules will only work on OPEN deductions with a label of NONE. 
 + 
 +{{:pasted:20241008-134750.png}} 
 + 
 +**Adding a new rule** 
 +1.  Click the "Add Deduction Rule" button 
 + 
 +{{:pasted:20241008-134852.png}} 
 + 
 +2. Provide a rule name and select the deduction label to auto-set 
 + 
 +{{:pasted:20241008-134956.png}} 
 + 
 +3. Begin creating the rule criteria. 
 + 
 +**Important** – the criteria always should be on top, then the criteria  
 + 
 +Example – if you want invoice contains DE or DEE then the OR should first then the invoice criteria below the OR 
 + 
 +{{:pasted:20241008-135315.png}} 
 + 
 +Use the dark plus icon to add AND/OR logic for multiple criteria. 
 + 
 +Use the light plus icon to add parameters to your rule. 
 + 
 +{{:pasted:20241008-135454.png}} 
 + 
 +**Parameter Configuration** 
 + 
 +1. Select the field from the dropdown menu (includes all deduction screen fields and custom CDF fields). 
 + 
 +2. Choose the appropriate condition for the selected field. 
 + 
 +3. Enter the specific criteria value. 
 + 
 +{{:pasted:20241008-185116.png}} 
 + 
 +The second box is how to look at the criteria, the choices will change based off the field you choose in the first box 
 + 
 +{{:pasted:20241008-185204.png}} 
 + 
 +If you make a mistake, you can click the trash can icon to delete the information 
 + 
 +{{:pasted:20241008-185243.png}} 
 + 
 +**Condition Options** 
 + 
 +1) Equal to 
 + 
 +2) Contains 
 + 
 +3) Not contains 
 + 
 +4) Starts with 
 + 
 +5) Ends with 
 + 
 +6) Total Characters 
 + 
 +7) Greater than 
 + 
 +8) Less than 
 + 
 +Value is where you add the specific criteria  
 + 
 +{{:pasted:20241008-185417.png}} 
 + 
 +If you try to setup a second rule with the same fields chosen in the new deduction label rules you will get this error. 
 + 
 +{{:pasted:20241022-195624.png}} 
 + 
 +**Saving and Modifying Rules** 
 + 
 +Click the "Save" button in the bottom right corner to save your rule configuration. 
 + 
 +{{:pasted:20241008-185526.png}} 
 + 
 +To remove a rule, click the delete button on the far right side of the rule's row. 
 + 
 +By following these procedures, you can efficiently set up and manage deduction auto-match settings and rules, streamlining the claim matching process. 
 + 
 +{{:pasted:20241008-185622.png}} 
 + 
 +**Updating data for a line** 
 + 
 +Double click on the line and the screen will pop up so you are able to make edits.   
 + 
 +{{:pasted:20241008-185727.png}} 
 +----- 
 + 
 +**Deduction Scoring** 
 + 
 +Match Score Calculation (0-4 points): 
 + 
 +1. Company to company or company to deduction aggregator parent match (1 point) 
 + 
 +2. Deduction amount requested matches claim invoice's amount requested within $0.01 (1 point) 
 + 
 +3. Deduction number matches claim's deduction hint OR deduction invoice number matches claim's deduction hint OR deduction invoice number matches claim's invoice number (2 points) 
 + 
 +__Score Interpretation:__ 
 + 
 +• 4: Absolute match (company, invoice/hint, amount) 
 + 
 +• 3: Invoice/hint match AND either company or amount match 
 + 
 +• 2: Invoice/hint match OR company and amount match 
 + 
 +• 1: Either company or amount match 
 + 
 +• 0: No matches 
 + 
 + 
 +__Eligibility Criteria:__ 
 + 
 +Claims 
 + 
 +• Not in DRAFT or HOLD state 
 + 
 +• If REJECTED, reason must not be 'DUPLICATE_CLAIM' or 'CLAIM_ENTERED_IN_ERROR' 
 + 
 +• Requested amount not fully tied to deductions 
 + 
 +Deductions: 
 + 
 +• In OPEN state 
 + 
 +• Amount requested not fully tied to claims 
 + 
 +• Deduction number doesn't contain client's automatch_deduction_number_exclusion_pattern (if applicable) 
 + 
 +**Match Pass Sequence**: 
 + 
 +1. Credit Matches (Exact, Any Hint): 
 +C2C: Company-to-Company, one side negative 
 + 
 +P2C: Parent-to-Company, one side negative 
 + 
 +G2G: Group-to-Group, one side negative (if enabled) 
 +   
 +2. Debit Matches (Exact, Any Hint): 
 +C2C: Company-to-Company, both sides positive 
 + 
 +P2C: Parent-to-Company, both sides positive 
 + 
 +G2G: Group-to-Group, both sides positive (if enabled) 
 +   
 +3. Fuzzy Matches (Open Debit, Open): 
 +DedNumHint: Deduction number matches hint, amounts match 
 + 
 +DistInvNumHint: Deduction invoice number matches hint, amounts match 
 +   
 +4. Score-Match-Singleton: 
 +Utilizes the scoring system defined above 
 + 
 +This structure provides a clear, professional overview of the deduction matching process, highlighting the key components and their relationships. 
 + 
 +----- 
 + 
 +**Enhancements to Deduction Management System** 
 + 
 +Refined Auto-Match Algorithm: 
 +  * The deduction auto-match process has been optimized to consider only one rolling year. 
 +  * Matching now compares deduction creation date against claim date. 
 +  * This refinement aims to minimize erroneous matches caused by incorrect invoice numbers on deductions. 
 + 
 +Expanded Deduction Settings: 
 +Building upon the previously implemented automatic label update feature, we have introduced additional     functionality: Automatic note generation capability for deductions. This enhancement provides more comprehensive explanations for label assignments, improving transparency and traceability in the 
 +deduction management process. 
 +     
 +{{:pasted:20241220-195310.png}}     
 +     
 +**Deduction Rule Editor Enhancement: Expanded Deduction Parameters** 
 + 
 +The Rule Editor functionality has been augmented to include additional deduction parameters, specifically incorporating an equal to comparison option for deduction amount requests. This enhancement provides greater precision in rule configuration capabilities. 
 + 
 +{{:pasted:20241220-195548.png}} 
 + 
 +Advanced Deduction Invoice Number Filtering 
 + 
 +The Rule Editor has been expanded to include sophisticated invoice number filtering options for deductions. New criteria have been implemented: 
 + 
 +  * Not Starts With condition 
 +  * Not Ends With condition 
 + 
 +These additions allow for more nuanced and precise rule definitions when processing deductions based on invoice 
 +number characteristics 
 + 
 +{{:pasted:20241220-195751.png}} 
 + 
 +Deduction Amount Remaining Criterion 
 + 
 +A new equality comparison option has been implemented in the Rule Editor for the Deduction Amount Remaining 
 +parameter. This addition allows for precise rule creation based on the exact outstanding balance of deductions. 
 + 
 +{{:pasted:20241220-195916.png}} 
 + 
 +----- 
 + 
 +Key improvements outside of the normal deduction rules: 
 + 
 +  * WHEN deduction_state IN ('CLEARED', 'BALANCED') AND deduction_label NOT IN ('NONE')THEN UPDATE TO 'NONE' 
 + 
 +  * WHEN deduction_state IN ('COMPLETE') AND deduction_label NOT IN'REBILLABLE',REBILL_SENT',NOT_PAID_AT_GOSIMPLE_WORKING')AND (active deduction_claim_balance is within 0.01 AND the claim_state is not REJECTED AND claim_reason_code not 'NOT_PAID_AT_GOSIMPLE')THEN 'REBILLABLE' 
 + 
 +  * WHEN deduction_state IN ('COMPLETE') AND deduction_label NOT IN ('NOT_PAID_AT_GOSIMPLE','NOT_PAID_AT_GOSIMPLE_WORKING', 'REBILL_SENT')AND (active deduction_claim_balance is within 0.01 AND the claim_state is not REJECTED AND claim_reason_code not 'NOT_PAID_AT_GOSIMPLE')THEN 'NOT_PAID_AT_GOSIMPLE' 
 + 
 + 
 + 
  
auto_matching_rules.1728395089.txt.gz · Last modified: 2024/10/08 13:44 by tina.robles

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki