Skip to content
English
Sign in
  • There are no suggestions because the search field is empty.

Trade Deals Integration for Mediaocean AP Import

Overview

The Trade Deals feature helps agencies manage media-related supplier invoices that are tied to special deal arrangements. It allows you to define deal types and codes, link them to imported invoices, and ensure accurate financial tracking and reporting.
This functionality is especially useful when working with Mediaocean, enabling you to separate trade deal amounts from standard media costs and streamline reconciliation.
 
 

What It Does

  • Lets you define and manage different types of media trade deals
  • Supports deal-specific invoice entries during AP file import
  • Validates deal data to prevent posting errors
  • Ensures deal entries are excluded from media cost reporting

How It Works

Deal Identification in AP Files
When importing supplier invoices from Mediaocean, the system checks for two fields:
  • Original Invoice #
  • DealID
If a row includes a DealID and the invoice number is different from the Original Invoice # for the same vendor, it’s treated as a deal record. Instead of creating a new invoice, the system links the deal entry to the original invoice and adds a separate line item.
This allows you to track trade deal amounts separately from standard media costs.
 

How to Set It Up

To use the Trade Deals feature, follow these steps:

 

1. Define Media Deal Types

Go to Mediaocean Configuration and open the Media Deal Types section.
  • There are four default descriptions - No Services, Services, OID, No ID (CASH).
  • Assign a Media Deal Revenue Account for each deal type.

💡 Tip: Revenue accounts are required for deal types that will be used in financial postings.

2. Add Media Deals

From the Media Deal Types page, click into Media Deals.
  • Confirm the Media Deal Type with the associated DealID.
  • Add a description for clarity - optional.

3. Update Your AP File Format

Ensure your Mediaocean AP file includes:
  • Original Invoice #: The invoice the deal is linked to.
  • DealID: The code that matches a Media Deal Type.

💡If the DealID is present and the invoice number differs from the original, the system will refer to the media deal type record to determine to the revenue account.

4. Review Posting Behavior

  • Trade Deal entries will be added as extra lines under the original invoice.
  • The Trade Deal value will not post to Media WIP unless the GL Account on the media deal type record is the media WIP account.
 

Summary

The Trade Deals feature gives agencies more control over how media deal amounts are tracked and reported. By linking deal entries to original invoices and validating setup during import, it ensures clean data and accurate financials without disrupting your standard media workflows.