Telus TPM Documentation

User Tools

Site Tools

Trace:
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 19:05] – 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** **Auto Set Labels**
Line 165: Line 175:
  
 {{:pasted:20241008-185417.png}} {{: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** **Saving and Modifying Rules**
Line 183: Line 197:
  
 {{:pasted:20241008-185727.png}} {{:pasted:20241008-185727.png}}
 +-----
  
 **Deduction Scoring** **Deduction Scoring**
Line 225: Line 240:
 • Deduction number doesn't contain client's automatch_deduction_number_exclusion_pattern (if applicable) • Deduction number doesn't contain client's automatch_deduction_number_exclusion_pattern (if applicable)
  
-Match Pass Sequence:+**Match Pass Sequence**:
  
-1. Credit Matches (Exact, Any Hint): +1. Credit Matches (Exact, Any Hint): 
-  C2C: Company-to-Company, one side negative +C2C: Company-to-Company, one side negative 
-  P2C: Parent-to-Company, one side negative + 
-  G2G: Group-to-Group, one side negative (if enabled)+P2C: Parent-to-Company, one side negative 
 + 
 +G2G: Group-to-Group, one side negative (if enabled)
      
-2. Debit Matches (Exact, Any Hint): +2. Debit Matches (Exact, Any Hint): 
-  C2C: Company-to-Company, both sides positive +C2C: Company-to-Company, both sides positive 
-  P2C: Parent-to-Company, both sides positive + 
-  G2G: Group-to-Group, both sides positive (if enabled)+P2C: Parent-to-Company, both sides positive 
 + 
 +G2G: Group-to-Group, both sides positive (if enabled)
      
-3. Fuzzy Matches (Open Debit, Open): +3. Fuzzy Matches (Open Debit, Open): 
-  DedNumHint: Deduction number matches hint, amounts match +DedNumHint: Deduction number matches hint, amounts match 
-  DistInvNumHint: Deduction invoice number matches hint, amounts match+ 
 +DistInvNumHint: Deduction invoice number matches hint, amounts match
      
-4. Score-Match-Singleton: +4. Score-Match-Singleton: 
-  Utilizes the scoring system defined above+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. 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.1728414335.txt.gz · Last modified: 2024/10/08 19:05 by tina.robles

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki