Telus TPM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Autopay and Off Invoice=====

=====Autopay=====

In order to access the Autopay process in the system, your user role must include Admin Autopay.  Only users with this role will have access to generate, review and approve the automated earnings.  To access Autopay – it’s located in the Admin section of the menu. 

{{:pasted:20200720-101632.png}}

{{:pasted:20240827-135620.png}}

Once you click on Autopay – your action buttons will be at the bottom of your screen.  

{{:pasted:20200720-101657.png}}

**Step 1 – run the Precheck Review**

{{:pasted:20200720-101727.png}}

Click on Precheck Review and then hit the GENERATE button.   This will generate your precheck report.  This report consists of 6 tabs.   PreCheck Explained, AutoPay Contracts, Contracts not Renewed, AutoPay Exclusions, Autopay Backouts and Sales Company Eligibility.   The first tab just provides an explanation for the other tabs in the worksheet.   

  * AutoPay Contracts will have all of the contracts that are available to generate your earnings.  Once you have confirmed that all contracts you expect to generate earnings are included on this tab, and that the payee for each is correct, you may proceed to the next tab. 

  * Contracts not Renewed shows you any AutoPay contracts in the system that were not renewed and therefore will not generate any earnings.  

  * Autopay Exclusions – if you are using Exclusions on any of your AutoPay contracts, the companies and products being excluded from the payments, and the percent of exclusion, will be shown here.  

  * Autopay Backouts – if you are using Backouts on any of your AutoPay contracts, the companies and products being backed out, and the percent of the backout, will show on this tab.  

  * Sales Company Eligibility – this tab helps to show you which companies are being included on contracts where your contractee is a Company Group.  An example of this might be a buying Group like Unipro – this tab will show you who the system is recognizing as members of Unipro.  Or if your contract is for a Broker Commission – this tab will show you all the distributors found to be linked to the broker that will be included in generating their earnings. 

Once you have reviewed the whole spreadsheet and are confident that all of your contracts are included and accurate, you can proceed to Step 2.  If you find any that are missing or that need to be updated prior to generating earnings, now is the time to do it.  Amend/Renew or create the contracts that are missing and then you can rerun the Precheck report to make sure everything is accurate.   Only proceed to Step 2 when you are sure all of your contracts are up to date and accurate.  

**Step 2  - Refresh Earnings** 

Click on Refresh Earnings and you will need to make a selection to run MONTHLY or QUARTERLY (or any other payment frequency you have set up).  You may select more than one option by holding down the CTRL or SHIFT key while choosing your options. 

{{:pasted:20200720-101938.png}}

Then click on the CONTINUE button in the bottom right hand corner.   This will bring up all the contracts from the selected payment calendar(s).  At this point you can choose to generate earnings for one, many, or all the contracts by selecting them.   To select click on the contract row and it will highlight.   To select ALL contracts – select the first contract, hold down the SHIFT key and scroll to the last contract and select it.  This will highlight all of the contracts.  If you want to select specific contracts – hold down the CTRL key while making your selections.  This will allow you to choose specific contracts in the list without selecting them all.  The LAST EARNING DATE at the bottom should be populated with the date that you want to generate your earnings through.  For example – if you are running earnings for June – you would enter 6/30/2020 (or the last day of your fiscal month if you are on a fiscal calendar).   You may use the calendar icon to select your dates or you can hand key the dates, but you must enter the / and use a 4-digit year.   Once you have selected your contracts and entered your Last Earning Date – click on the CONTINUE button in the bottom right corner. 

{{:pasted:20200720-102027.png}}

You should now see the contracts that you selected up at the top of your screen. 

{{:pasted:20200720-102047.png}}

If you select contracts that someone else has already generated earnings for, but have not completed yet you will get a pop-up warning that you are about to undo their work and the system will regenerate earnings for that contract(s) and it will be included in the new user’s run. 

**Step 3 – run the Unpaid Earnings Report.**

At this point you will click on the Unpaid Earnings Report button at the bottom of the screen.  This will give you a popup window where you choose to generate the Excel report.  

{{:pasted:20200720-102132.png}}

Once generated, you should open and review the data in the Excel spreadsheet.   This spreadsheet will consist of 4 tabs.   Unpaid Earnings Explained, Summary, Earnings and Backouts.   The first tab provides you with just an explanation of the data on the 3 tabs that contain your data in the worksheet.   The Summary tab shows a list of the contracts that generated earnings along with a total amount of the earnings to be paid out.   The Earnings tab shows the detail for the total earnings to be paid.   This is the tab that gives the sales invoice, customer, product, and rate details (and more) so that you and/or your customer can reconcile their payment.  The last column on this tab is labeled AUTOPAY ACTION.   This is the column that you need to update with either HOLD, PAY or EXCLUDE.   

  * If you choose HOLD the earnings on that line will remain available for payment and show in future runs, but will not pay on this periods invoice. 

  * If you choose to PAY the earnings on that line will be generated as a payment for that customers.  

  * If you choose to EXCLUDE the earnings on that row will be excluded forever and will never pull back into any future earnings that are generated.   

HOLD, PAY and EXCLUDE are the only 3 options you can choose.   You must not change the format, column order or any of the other data in the spreadsheet.  Touch only the last column.  The last tab is BACKOUTS.  If you are utilizing the backouts option on any of your AutoPay contracts, the lines that are being backed out of the customers earnings will display on this tab.   The sum of the earnings tab and the backout tab will be equal to the total on the Summary tab. 

Once you have updated all of the rows in the spreadsheet with an AutoPay action.   Save the spreadsheet.   You will upload your spreadsheet in the next step. 

**Step 4 – Upload Unpaid Earnings Report**

Click on the Upload Unpaid Earnings Report button at the bottom of the screen.  This will open a pop-up window.  Choose Upload File – this will open a file selection window that will allow you to navigate to the location on your computer where you have saved your document from the previous step.   

{{:pasted:20200720-102318.png}}

{{:pasted:20200720-102327.png}}

Select your saved file and then hit OPEN in the bottom corner.  This will then show your saved report in the window.  Hit CONTINUE to upload your file. 

{{:pasted:20200720-102400.png}}

Once your spreadsheet is uploaded you will get the results of your import.   The pop-up will tell you how many rows were in your file, how many GOOD rows and how many BAD rows.   BAD rows do not import.   This means that there was something was wrong in the spreadsheet that you uploaded.  In this example the AutoPay Action columns were not updated.  That is required in order to pay any of the earnings.  

{{:pasted:20200720-102424.png}}

You should click CLOSE in the bottom corner and then recheck your spreadsheet.  Once you have updated your spreadsheet to fix any errors, you can choose to Upload it again.  If everything is correct you will see the Total Rows and the Good Rows should be the same value.   You can then click CLOSE in the bottom right hand corner. 

{{:pasted:20200720-102442.png}}

**Step 5 – Earnings to Pay Report**

Now you can click the Earnings to Pay Report on the bottom of the screen.  Choose GENERATE in the popup window.   This will generate and XLS spreadsheet that has 4 tabs – Earnings to Pay Report Explained, Summary, Earnings and Backout.  If you made no changes and did not exclude or hold any earnings – this should show the same information and totals that were on your unpaid earnings report.  Review all the tabs in the report to confirm these are the amounts that you want to pay.  If everything is correct and accurate – you can proceed to the next step. 

**Step 6 -  Create Invoices**
 
Click on the Create Invoices button at the bottom of the screen.  This will now create the claim for the customers in your earnings spreadsheet.   These claims can be found in DRAFT in the system.  You will review them and click on SUBMIT.  When an autopay invoice is submitted, the claims go directly to complete, no need for approval workflow, no need for pending checks.   These claims will automatically appear in the next payment file you receive. 

**DO NOT remove an autopay contract from an autopay claim. This will cause the earnings to re-set and the claim will need to be rejected and the autopay process re-run for that contract**

-----

**New data feed – 1043: Auto pay with sales paid date**

A new data feed is now available for clients to use with Autopay reporting.  
  * 1043_sale_paid allows the client to provide us with dates that your invoices were paid.  If you want to use the paid date for eligibility for your Autopay contracts.
  * Sale number, Invoice number, and Paid Date are the three new fields on this report.  
  * This feed is required to use the new hold unpaid sales invoice feature in Autopay
  * Please reach out to your Account Manager for the file layout and more information on using this new feature.

{{:pasted:20250321-180229.png}}

**Auto pay new option to Hold unpaid sales invoices**

There is now a way to hold autopay invoices until the sales invoice is paid.  
  * The setting is at the template level. 
  * This feature does require the new data feed for auto pay (1043) to be on and used.  This feed will supply the paid date.  
  * The Autopay unpaid earnings report is where you will see WAIT FOR PAYMENT for any claims where sales was not paid. 
  * If this feature is on no autopay claims will be created for any sales invoices unpaid. 

{{:pasted:20250321-180405.png}}

Please contact the Account Manager if you would like to start using this feature.

This feature can be turned on by editing the template and checking the box under REBATE VALUE TYPES AVAILABLE that says AUTOPAY HOLD UNPAID SALE INVOICES.
 
{{:pasted:20250618-182639.png}} 

 
**-------------------------------------------------------------------------------------------------------------------
**


=====Off Invoice=====

Off Invoice is a Discount included to the customer at the time the manufacturer invoices the customer for the product. To use off invoice, the following steps must be taken:

**Step 1**
Contract Template needs to be set up to allow a Contract Type of Off Invoice or a separate template should be setup for only a contract type of off invoice
•	It is recommended to have Off Invoice contracts on its own template as there is less confusion when creating contracts on what to pick with the contract type.

**Step 2**
Contracts need to be set up with an Off Invoice Contract Type.
{{:pasted:20240618-140125.png}}

**Step 3**
Contracts should only be set up for Off Invoice for customers that purchase directly.
{{:pasted:20240618-140325.png}}

**Step 4**
Reach out to the Account Manager to set up the off invoice process.

**Step 5**
Once Turned on, sales received daily or frequency received from the Manufacturer are bounced up against the Off Invoice contracts for the time period of the sale and claims are auto-created and completed with a draft transaction type. Draft transactions do not appear in any reporting (Payment or Deduction Feeds), but they are available to show as actuals in reporting against a contract in TPM or in tableau. 

**Step 6**
If the Manufacturer would like to receive an outbound feed of Off Invoice contracts, the Manufacturer should reach out to the Account Manager to have these feeds established.


**Off Invoice claim workflow**
{{:pasted:20240618-140536.png}}
Telus TPM Documentation

User Tools

Site Tools

Page Tools
