Trading partner-fed transactional data is a feature in Collaborator, that allows your trading partners to submit transactional data to your DealTrack tenant. Collaborators, who have been granted permission to upload data, have access to the master data for your DealTrack tenant. They can then use this to populate the reference columns in the turnover file. The import wizard uploads the data directly into DealTrack which will then go through the normal reconciliation process.
Trading partner-fed data is a platform admin setting. If you would like to enable this feature, please raise a ticket with us or speak to your Enable contacts directly.
Once enabled, a permissions box will be available on a per-user basis in the 'Collaborators' area within a trading partner in DealTrack. Collaborators with the 'Can submit transactional data' box ticked have access to the 'Transactions' area of Collaborator. If they then wish to upload transactional data into DealTrack, the trading partner which they are collaborating on behalf of must have a scheme against it. The schemes against this trading partner will also determine the currency in which they can upload transactional data.
The Tenant Collaborator report is particularly useful for seeing which users you have given permission to upload data.
Reconciling the data
Turnover data uploaded by a trading partner will go through the same reconciliation process as turnover uploaded by DealTrack users. DealTrack client admin users receive a notification on the DealTrack dashboard when transactional data has been submitted by a Collaborator. In the Config area under Turnover then Reconciliation, you can see which Collaborator has uploaded data and also which trading partner they are uploading on behalf of. Similar to the normal reconciliation process, you can click on this 'Addition of lines' reconciliation to view a report of any unreconciled lines.
Unreconciled lines will typically be due to incorrect references being used, which do not appear on your master data lists. Collaborators will be warned that they are uploading unrecognized references if any are present, however they will not be prevented from uploading the turnover. Upon viewing the unreconciled references in DealTrack, you can then make the decision whether the Collaborator needs to re-upload the data or if there are missing references in your DealTrack tenant. Unrecognized references will also be shown to the Collaborator in a single report (accessed via a red exclamation button), so your trading partners can always see which lines have not reconciled from their uploads.
Reporting on the data
In DealTrack, you are also able to report solely on the data that has been uploaded by your trading partners. A checkbox has been added to the Turnover report page labeled 'Consider trading partner-fed turnover only?'. This allows you to view a report of all trading partner-fed data but also apply any number of filters and restrictions, just as you would with the turnover report normally.