Telus TPM Documentation

User Tools

Site Tools

Trace: • probable_exposure_explained • terminating_a_contract • accrual_process • dashboard_and_search • deduction_reports
eclaim_processes

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
eclaim_processes [2020/01/16 14:06] – lisa.maloneyeclaim_processes [2020/06/22 11:24] (current) – lisa.maloney
Line 2: Line 2:
  
 This section of help will explain how to load an eclaim using the eclaim template, and the checks the system performs to prevent duplicate eclaim loads.   This section of help will explain how to load an eclaim using the eclaim template, and the checks the system performs to prevent duplicate eclaim loads.  
 +
 +Another feature of the eclaim process is the ability to have eclaims Auto Submit and/or Auto Approve.  This setting is done at the company level and companies with this setting enabled will flow through the eclaim process automatically.
 +
 +Auto Submit: if a company has this enabled, any eclaim loaded for this claimant will move from draft to submitted and then into a Pend, Hold, Evaluation status.
 +
 +Auto Approve: if a company has this enabled, any eclaim loaded for this claimant will be auto approved once the claim is submitted (either via auto submit or manually).  
 +
 +Settings at the company level:
 +{{:pasted:20200622-112349.png}}
 ----- -----
  
Line 28: Line 37:
 Use a 4-digit year for all dates.  Use a 4-digit year for all dates. 
  
-__Invoice_header:__+__**Invoice_header:**__
  
   * **//__File_name__//** – this is the exact name of the file that came in that you are going to input into the template, include the file type extension.    * **//__File_name__//** – this is the exact name of the file that came in that you are going to input into the template, include the file type extension. 
Line 48: Line 57:
   * **//__Invoice_type__//** – billback (for invoiced to distributors) or operator billback (for invoices paid to operators)   * **//__Invoice_type__//** – billback (for invoiced to distributors) or operator billback (for invoices paid to operators)
  
-__Invoice_product:  (the below required fields are only if the invoice is sku based)__+__**Invoice_product:**  (the below required fields are only if the invoice is sku based)__
  
   * **//__claimant_company_name__//** – this should be the same as the first worksheet, who is the invoice for, this is the claimant company name (i.e USF CORPORATE)   * **//__claimant_company_name__//** – this should be the same as the first worksheet, who is the invoice for, this is the claimant company name (i.e USF CORPORATE)
Line 112: Line 121:
   * location_country_code – unit level country CA or US   * location_country_code – unit level country CA or US
  
 +
 +
 +__**invoice_lumpsum:**   (the below required fields are only if the invoice is lumpsum)__
 +
 +  * **//__claimant_company_name__//** – this should be the same as the first worksheet, who is the invoice for, this is the claimant company name
 +
 +  * **//__claimant_invoice_number__//** - this should be the same as the first worksheet, the invoice number that should be used to load the claim, if none if given use the Dot Foods DE number or the month/year.
 +
 +  * **lumpsum_description** – the words used to describe the event being claimed, this will get mapped to an event bucket
 +
 +  * amount_requested – amount being requested for that lump sum event
 +
 +  * **//__claimant_contract_name__//** – this will appear in the claim’s contract hint
 +
 +-----
 +
 +__Process to name the file and save it to the FTP__
 +
 +Once the file is created save it as “1072_inbound_ claim_(manufacturer name)_(initials and date file is being saved to the ftp)
 +
 +  * Example:  1072_inbound_claim_PIN_tmm11142016.xlsx 
 +
 +Save the template to the specific clients FTP under the from Files\Inbound\From Distributors.
 +  
 +Manufacturer name use:  MFG (Manufacturer) where MFG is the 3 letter abbreviation followed by manufacturer name
 +
 +If you create more than one file a day then add a _1 at the end of the file name, increasing the number by 1 each time.  
 +
 +**IMPORTANT:  Also, save the original documents to the FTP as well.  Make sure to save then with the exact file name noted in the File_name field on the excel document so the process can match it up to the claim created.  
 +FTP Login choose your client**
 +
 +FTP Login choose your client
 +
 +{{:pasted:20200116-142418.png}}
 +
 +FTP save under Files, Inbound, From_Distributor
 +
 +{{:pasted:20200116-142434.png}}
 +
 +-----
 +
 +**__Eclaim Load Duplicate Checking__**
 +
 +Process to determine duplicates - Eclaim Load:
 +
 +1. Check for possible Duplicate based on Header information (checks against both what is in the eclaim import tables and what is in the system for claims)
 +  * Claimant
 +  * Claimant Name
 +  * Invoice Number
 +  * Start Date
 +  * End Date
 +  * Total lines (Note: this is rarely if ever loaded as everything is calculated based on lines loaded)
 +  * Total Requested Amount (Note: this is rarely if ever loaded as everything is calculated based on lines loaded)
 +
 +2. Check line level for duplicates for those header rows that have been determined to be possible duplicates
 +
 +  * Each line is checked for duplicates within eclaim import to prevent loading of duplicates  - it requires that all lines match exactly to be considered a duplicate
 +
 +3. Exact Duplicates are tagged and ignored preventing the load of the invoice from progressing any further
 +
 +Recap:  If we load (2) files they contain the same invoice, but they are not exact matches at the header level, they will not be flagged as a possible duplicate, add into that the change of the claimant to the invoice that you are doing, the second file would not see a possible duplicate in the system either because the claimant being loaded is not the one on the invoice that it should see as a duplicate.  Everything for eclaim is based at INVOICE level not claim level.
 +-----
  
eclaim_processes.1579183576.txt.gz · Last modified: 2020/01/16 14:06 by lisa.maloney

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki