Telus TPM Documentation

User Tools

Site Tools

Trace: • accrual_process
contract_template_-_edit

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
contract_template_-_edit [2018/01/18 12:15] – lisa.maloneycontract_template_-_edit [2024/08/27 14:09] (current) – tina.robles
Line 3: Line 3:
 Click on the Contract Template Admin menu option to view, edit and add Templates. Click on the Contract Template Admin menu option to view, edit and add Templates.
  
-{{:pasted:20170517-164502.png}}+{{:pasted:20240827-140646.png}}
  
 To edit a template, select a template from the drop down then click the Edit button. To edit a template, select a template from the drop down then click the Edit button.
Line 36: Line 36:
 The contract header, pricing, approval options, and decimal setting display on the right side of the General tab: The contract header, pricing, approval options, and decimal setting display on the right side of the General tab:
  
-{{:pasted:20170517-170134.png}}+{{:pasted:20240827-140901.png}}{{:pasted:20240827-140912.png}}
  
 **Contract Types Available** - select which Contract Types can be created using this template.  One or many options can be selected. **Contract Types Available** - select which Contract Types can be created using this template.  One or many options can be selected.
Line 42: Line 42:
 **Cost Basis Types Available** - select which Cost Basis Types can be selected on contracts created using this template. One or many options can be selected. **Cost Basis Types Available** - select which Cost Basis Types can be selected on contracts created using this template. One or many options can be selected.
  
-**Contract Rebate Methods Available** - select which Rebate Methods will be available on contracts created using this template.  One or many options can be selected.  Note that if only Direct is selected, if a contract is created with an operator contractee, no deviated pricing will be available for contracts created on that template.  +**Contract Rebate Methods Available** - select which Rebate Methods will be available on contracts created using this template.  One or many options can be selected.  Note that if only Direct is selected, if a contract is created with an operator contractee, no deviated pricing will be available for contracts created on that template. 
 + 
 +**Accrual Quantity Sources Available** - select how the accruals will be determined.  See below for accrual definitions. 
 + 
 +**Accrual Lumpsum Sources Available** - select how the lumpsum dollars will accrue.   
 + 
 +  * Event Start Date will put all the accrual dollars for the lumpsum on the start date.   
 +  * Event End Date will put all the accrual dollars for the lumpsum on the end date.   
 +  * Lumpsum Spread will divide the accrual dollars evenly across the lumpsum timeframe.
  
 **Rebate Types Available** - select Numeric and/or Percent pricing to be available on contracts created using this template. **Rebate Types Available** - select Numeric and/or Percent pricing to be available on contracts created using this template.
Line 49: Line 57:
  
 **Estimated Quantity Required** - check the Active box to require estimated volume on all contracts created using this template.  If the box is unchecked then entering estimated quantity on a contract is optional. **Estimated Quantity Required** - check the Active box to require estimated volume on all contracts created using this template.  If the box is unchecked then entering estimated quantity on a contract is optional.
 +
 +**Preset Contract** - a preset contract can be selected so that when contracts are created using this template, the products, pricing, and other information is pre-filled and non-editable.  The preset contract must be from a different template than the current template.  **Note:** if the preset contract is amended, in order for new contracts to use that updated/active version, the template will need to be updated to use the updated version of the contract.  It does not happen automatically.
 +
 +**Date Range Type** - there are 3 options for date ranges on templates.  
 +  * Range - No Dates Entered: this will allow contracts to be created with any start and end date.
 +  * Range - Start and End Dates Entered: this will allow contracts to be created with start and end dates anywhere between the dates on the template.
 +  * Explicit - Start and End Dates Entered: this will force contracts created on that template to have the start date and end date as specified on the template and the user is unable to modify the contract dates.
 +
 +**NEW time frame tolerance**- There is a new time frame tolerance within the template that applies to all contracts created using that template. This feature will help prevent claims from pending for out of time frame.
 +  * This new feature will help reduce the need to guess what time frame your accounts are going to run a promotion by allowing a number of days tolerance in relation to your contract dates.
 +  * Setting this tolerance up at the Template level will allow a claim to process as long as it's within your number of tolerance days from the dates on your contract. 
 +  * Example-You are offering Publix a deal for 1 week in May. You are not sure which week Publix is going to run that promotion, so you create a contract and pick the second week of May. Publix runs that deal the third week of May. PRIOR TO THIS ENHACEMENT – the claim would pend as out of time frame. To clear this either the contract must be updated to the proper dates or the claim would need to be manually updated to clear this pending. AFTER THIS ENHANCEMENT – if you were to add a 7-day tolerance on this template the claim would not pend as out of time frame, it will allow the claim because it is within 7 days of the contract time frame. 
 +  * NOTE:  Claims tied to terminated contracts pend as out of time frame today. That means this tolerance will also clear these pends as well. In the next quarter’s release, we will have a new pend reason for claims tied to terminated contracts to avoid this. 
 +  * NOTE:  You must have access rights to the templates to setup this tolerance. 
 +
 +{{:pasted:20240711-141537.png}}
  
 **Contract Approval Policy** - select an Approval Policy from the dropdown to apply to contracts created on this template.  This allows different approval processes to be set up on different templates. **Contract Approval Policy** - select an Approval Policy from the dropdown to apply to contracts created on this template.  This allows different approval processes to be set up on different templates.
  
-**Contract Rate Numeric Decimal State** - enter a value from 0 - 6 in this textbox.  This value determines how many decimal places will be available on contract rates.  For example, if 5 is selected a user can enter a contract rate of 1.25654.+**Contract Value Numeric Decimal Scale** - enter a value from 0 - 6 in this textbox.  This value determines how many decimal places will be available on contract for either Fixed Rate or Fixed Price values.  For example, if 5 is selected a user can enter a contract rate of 1.25654. 
 + 
 +**Contract Value Percent Decimal Scale** - enter a value from 0 - 6 in this textbox.  This value determines how many decimal places will be available to enter on a percent on the contract.  For example, if 3 is entered, a user can enter a contract percent of 12.375% on the contract. 
 + 
 +__Accrual Definitions__: 
 + 
 +**Accruals always accrue at the contract/company/product/lumpsum level for a defined timeframe.  Lumpsums are always allocated to the contractee company (evenly split when there are multiple contractees or to the contractee group’s parent company if one is defined). See below for how the dollars are allocated to companies/products under the contract.**  
 +  
 +**NONE** – Do not pull in any quantity to accrue, so nothing will be accrued for this contract. 
 +CUSTOM – Indicates that there is a custom accrual method set up for the manufacturer and it's not controlled by any of the accrual types listed. 
 + 
 +**CONTRACT ESTIMATE** – Uses the estimates defined on the contract as the quantity to accrue for.  Allocates the estimate evenly over the entire time frame of the contract to determine accrued dollars per period.  Allocate each product evenly over the contract period divided evenly by each contractee company (if a group or aggregate). 
 + 
 +**CLAIM TRAILING AVERAGE** –Past periods use actual claim volume/dollars while future periods use an average from a defined trailing period with an optional gap period…e.g. Gap 2 months back and take the previous 6 months claim actuals average.  Dollars are allocated to the distributor of each paid claim line item, or if there is no captured distributor, then they will be allocated to the claimant company. 
 + 
 +**CLAIM ACTUALS ONLY** – This option will not accrue for future periods, it just accrues based on the claim actuals for the past periods.  Dollars are allocated to the distributor of each paid claim line item, or if there is no captured distributor, then they will be allocated to the claimant company. 
 + 
 +**DISTRIBUTOR SALES** – Uses the sales data for a period as the quantity to accrue in the past, then similar to claim trailing average, uses a gapped trailing average to project future periods.  Dollars are allocated to the company on the sale unless the contractee is a group with a parent company, in which case they are allocated to the parent company. 
 + 
 ----- -----
 **__Users__** **__Users__**
Line 151: Line 194:
 To allow only certain Contractee Company Groups to be selected when creating a contract, check the Contractee Company Groupings Filters Active box.  Then navigate to the Contractee Company Groupings tab to select the company groups. To allow only certain Contractee Company Groups to be selected when creating a contract, check the Contractee Company Groupings Filters Active box.  Then navigate to the Contractee Company Groupings tab to select the company groups.
  
-This grid displays an include checkbox as the first column.  To include a company group, check the box for the grouping row.  To include all company groups, click the Include All box.  (Note that if the Contractee Company Groups Filter Active box is unchecked, that also includes all contractee company groups.) +This grid displays a checkbox as the first column.  This grid works two different ways, depending on if the Contractee Company Type filter is selected.
  
-{{:pasted:20170517-181429.png}}+__If the Contractee Company Type filter is NOT set:__  To include a company grouping, check the box for the company grouping.  To include all company groupings, click the Check All box.  (Note that if the Contractee Company Grouping Filter Active box is unchecked, that also includes all contractee company groupings.) In this scenario below, only the Generic Distributor Grouping and Sysco Grouping will be INCLUDED and available to select as contractees on this template.
  
-{{:pasted:20170517-174016.png}}+{{:pasted:20180118-121824.png}} 
 + 
 +{{:pasted:20180118-121847.png}} 
 + 
 +__If the Contractee Company Type filter IS set:__  When the Contractee Company Type filter is set, this changes the checkboxes on this grid to an exclusion instead of an inclusion.   
 + 
 +As an example, if the Contractee Company Type is filtered to only allow Distributors, checking boxes on the Contractee Company Groupings grid will exclude the checked rows.  In the example below, the Contractee Company Type is Distributor and the row for the Sysco grouping is checked.  This means that ALL Distributor Groupings EXCEPT the Sysco grouping are available as contractees on this template. (Note: it is not necessary to click the checkbox on company groupings that do not have the company type that is selected on the Company Type tab.  Those company groupings will be excluded by the fact that they don't have the required company type.) 
 + 
 +{{:pasted:20180118-122030.png}}
  
 The groupings can be Expanded or Flattened by clicking these buttons at the bottom of the grid.  This expands or collapses the grouping data. The groupings can be Expanded or Flattened by clicking these buttons at the bottom of the grid.  This expands or collapses the grouping data.
  
 {{:pasted:20170517-174635.png}} {{:pasted:20170517-174635.png}}
 +
 ----- -----
 __**Distributor Companies**__ __**Distributor Companies**__
Line 165: Line 217:
 To allow only certain Distributor Companies to be selected as eligible distributors when creating a contract, check the Distributor Companies Filters Active box.  Then navigate to the Distributor Companies tab to select the distributor. To allow only certain Distributor Companies to be selected as eligible distributors when creating a contract, check the Distributor Companies Filters Active box.  Then navigate to the Distributor Companies tab to select the distributor.
  
-This grid displays an include checkbox as the first column.  To include a company, check the box for the company row.  To include all companies, click the Include All box.  (Note that if the Distributor Companies Filter Active box is unchecked, that also includes all distributor companies.) +This grid displays a checkbox as the first column.  To include a company, check the box for the company row.  To include all companies, click the Check All box.  (Note that if the Distributor Companies Filter Active box is unchecked, that also includes all distributor companies.) 
  
-{{:pasted:20170517-182004.png}}+{{:pasted:20180118-122450.png}}
  
-{{:pasted:20170517-174016.png}}+{{:pasted:20180118-122456.png}}
 ----- -----
 __**Distributor Company Groupings**__ __**Distributor Company Groupings**__
Line 175: Line 227:
 To allow only certain Distributor Company Groups to be selected when creating a contract, check the Distributor Company Groupings Filters Active box.  Then navigate to the Distributor Company Groupings tab to select the distributor groups. To allow only certain Distributor Company Groups to be selected when creating a contract, check the Distributor Company Groupings Filters Active box.  Then navigate to the Distributor Company Groupings tab to select the distributor groups.
  
-This grid displays an include checkbox as the first column.  To include a company group, check the box for the grouping row.  To include all company groups, click the Include All box.  (Note that if the Distributor Company Groups Filter Active box is unchecked, that also includes all distributor company groups.) +This grid displays a checkbox as the first column.  To include a company group, check the box for the grouping row.  To include all company groups, click the Check All box.  (Note that if the Distributor Company Groups Filter Active box is unchecked, that also includes all distributor company groups.) 
  
-{{:pasted:20170517-182207.png}}+{{:pasted:20180118-122548.png}}
  
-{{:pasted:20170517-174016.png}}+{{:pasted:20180118-122520.png}}
  
 The groupings can be Expanded or Flattened by clicking these buttons at the bottom of the grid.  This expands or collapses the grouping data. The groupings can be Expanded or Flattened by clicking these buttons at the bottom of the grid.  This expands or collapses the grouping data.
contract_template_-_edit.1516277711.txt.gz · Last modified: 2018/01/18 12:15 by lisa.maloney

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki