Contract AGC [Cash]

General contract data

General contract data
  1. Number - the number of the contract is generated by the system on first save. The numbering of the contracts starts over with 1 each year. There is no consecutive numbering over the years but only within each year.
  2. Title - the title of the contract is generated by the system on first save. It uses the following pattern: year/number/CASH/name
  3. Name - name of the contract
  4. Year - the year in which the contract is valid
  5. Contract type - you can determine the contract to either work on agency level or on advertiser level. Please note: depending on the selected level, the selection in field (8.) will be restricted on (corporate) agencies resp. advertisers/ holdings.
  6. Valid - set the flag to enable the contract for cash discount calculation
  7. Media combi - selection of the media combi that the contract will be valid for. Only suborders that use media of the selected combi can be considered for calculation.
  8. Corporate agency/ agency - selection of the corporate agency or agency whose connected advertisers' suborders will be relevant for the contract.
    Holding/ advertiser - selection of the holding or advertiser whose suborders will be relevant for the contract.
  9. Business type for assessment basis - selection of the business type which will be used for calculating the assessment basis.
  10. Order type groupe for assessment basis - selection of the order type group whose orders will be used for calculating the assessment basis.
  11. Exclusion - certain clients can be excluded from the contract.
  12. Exclusion overriding - selection of suborders that will be excluded from the exclusion.
  13. Validity period of the contract. Just for infomative purposes since cash-contracs are always valid during the entire year which is entered in field (4.).-
  14. Decimals - you can define the number of decimals that will be displayed in the reportings.
  15. Opens the exclusion validation.
  16. Runs a check on multiple allocations of suborders to different cash-contracts in the same year.
  17. Displays the actuals of the available discount levels.
  18. Displays the actuals of the available discount levels per suborder.
  19. Creates an overview on the monthly actuals.
  20. Opens the contract's history.
  21. Copies the entire contract incl. discount levels.
  22. Creates a memo which can be edited only once afterwards. Please note: once the memo is saved after editing, there are no further modifications possible!
  23. Creates a new discount level.
  24. Runs a partial reorganisation of the contract.
  25. Reorganizes all cash-contracts of the contract's year (if you run the reorganisation in a contract of 2016, all contracts of 2016 will be reorganized).
  26. Opens the percental exclusion. With this functionality you can determine how much of an excluded client's budget shall add to the contract.
    Example: a client books spots with a budget of 100.000 €. If you only want 60.000 € of the budget to add to the contract, you need to exclude the client and afterwards open the percental exclusion. Now you replace the default-value with 40. This way you exclude 40% of the clients budget and the remaining 60% add to the contract.

Exclusion validation

Exclusion validation

The screenshot displays the exclusion validation for a cash-contract on corporate agency-level. That means that suborders of the agencies that are connected to the corporate agency are displayed in the validation.

  • If the contract was on agency-level, only suborders of the agency would be displayed.
  • in contracts on holing-level only suborders of advertisers that belong to that holding would be displayed.
  • in contracts on advertiser-level only suborders of the advertiser would be displayed.

Discounts

Discounts
  1. Name of the connected cash-contract
  2. Name of the discount
  3. Prioritized - the discount is used in preference
    Korrektur AE - the discount is used to adjust the agency commission
    Korrektur Skonto - the discount is used to adjust the cashback
    Korrektur Vermarkterprovision - the discount is used to adjust the saleshouse commission
    Coupled - set the flag to apply the values for target business type, target order type group, exclusions and exclusion overridings from the connected contract to the discount record.
  4. Target business type - selection of the business type that will be used as basis for assessment calculation
  5. Target order type group -  selection of the order type group that will be used as basis for assessment calculation
  6. Exclusion - selection of the clients that are going to be excluded from the discount
  7. Exclusion overriding - selection of certain suborders of excluded clients that are going to be excluded from the exclusion.
  8. Cash-Label ID - selection of a cash-label
  9. Cash-Label - once the flag is set the cash-label selection becomes mandatory
  10. Client selection - the selection grid below gets enabled once the flag is set.
  11. Client selection - selection of clients that the discount shall be valid for.
  12. Zielkennzahl (EUR) - selection of the budget basis for the discount
  13. Zieltyp (EUR) - if the flag is set an absolute value in Euro for the discount is used. The value is determined in the discount level.
  14. Zielkennzahl (%) - selection of the budget basis for the discount
  15. Zieltyp (%) -  if the flag is set an absolute value in % for the discount is used. The percentage is determined in the discount level.
  16. Berechnungstyp - selection of the way of discount calculation. It needs to match the selected target type (absolute or percentage)
  17. Calculation basis - selection of the budget basis for assessment calculation
  18. Levels - the discount levels are displayed in this grid
  19. In these two fields the validity period in months is entered.
  20. From/ To - the validity period is applied from the connected contract
  21. Application - the selection determines the usage of discouns
    additiv --> the discounts are deducted one after another (Budget - discount1 = result1; result1 - discount2 = result2 etc.).
    consecutive --> the discounts are summarized and this sum is deducted from the budget (Budget - (discount1 + discount2 + discout3 etc.))
  22. Reihenfolge - determines the order in which the discounts will be applied (100 = first, 200 = second, 300 = third etc.)
  23. Opens the exclusion validation - a detailed description can be found in step "Exclusion validation".
  24. Opens the overview on all of the contract's discounts' actuals.
  25. Opens the monthly overview on the discounts' actuals.
  26. Creates a new discount level.
  27. Opens the percental exclusion.

Discount levels

Discount levels
  1. Name of connected cash-contract
  2. Name of connected discount
  3. If the flag is set the discount level is activated
  4. Depending on which target type (absolute or %) is selected in the discount record, the respective fields for the target value are displayed in the discount level. In the screenshot above the target value needs to be entered in %.
  5. Depending on which calculation type (EUR or %) is selected in the discount record, the respective fields for the discount value are displayed in the discount level. In the screenshot above the discount value needs to be entered in %.
  6. An upper limit can only be entered for calculation type %.