Orders
The order as "bracket" for suborders

The order literally builds a "bracket" around several suborders of a client. Through the order the agency responsible for booking and the invoice recipient are allocated to the client. Furthermore sales areas and so-called labels can be allocated to this data set. In case of special agreements upon times for payments it is reasonable to store them in the order data set as well.
Set up of orders

- If there´s already an existing customer relation between advertiser and agency it is sufficient to change it into an order. Please note that there has to be an invoice recipient added in the newly created order.
- If there isn´t a customer relation established yet the order can be set up directly in the order-module. Advertiser, agency and invoice recipient have to be added in the order.
- The next step would be the allocation of the order to a sales area.
- The order label brands certain types of orders. This way the labelled orders can be identified in order reports and can be analysed. This selection is optional.
- In case there´s an agreement upon special payment conditions different from the default media invoice parameter, the client´s special payment condition can be stored in the order.
Creation of orders out of customer relations
- Number -this field is filled automatically with the order number as soon as the customer relation was converted into an order
- External Number - the external number of the order is also imported automatically after the conversion
- Type - non-editable field that informs about the current status of the relation. After the conversion the status changes into "Order status".
- Advertiser - clients that do advertising
- Agency - agency that is responsible for planning the commercials
- From - beginning of validity period
- To - end of validity period
- Sales Area - allocation of a sales area which will be imported into the suborders. Sales areas include contact persons and sales targes.
- Special Action "Order" - the customer relation is converted into an order. The order data set is automatically filled with data of the customer relation. Please note: the new order is locked by default! To be able to make bookings on allocated suborders you need to unmark the checkbox "Lock" in the order data set!
- Special Action "Copy" - the customer relation is copied with the validity period lying in the year ahead. If the relation´s status is already the order-status an order will also be copied in addition to the relation.
The order data set
The order data set contains all data that are relevant for the order and an overview of the bookings made on the suborders that are allocated to the order.
General data
- Number - the order number is generated automatically by the system once the new order is saved for the first time
- External No. - if required an external order number can be entered here
- Advertiser ID - selection of the advertiser. Attention: Once an order is invoiced it is not possible to change the selection.
- Agency ID - selection of the agency that is allocated to advertiser. Attention: Once an order is invoiced it is not possible to change the selection.
- Invoice Recipient - selection of the client that will receive the invoice. Attention: Once an order is invoiced it is not possible to change the selection.
- Sales Rep. - in case the selected agency is not responsiple for planning, a differing agency can be selected here
- Info - optional text field for additional information on the order
- Internal Comment - optional text field for internal comments
- External Comment - optional text field for external comments
- From - beginning of validity period
- To - end of validity period
- Invoice Settings - in case there´s an agreement upon special payment conditions different from the default media invoice parameter, the client´s special payment condition can be stored in the order. It will be imported to all allocated suborders.
- Lock - if the checkbox is marked the order is locked and its allocated suborders cannot be booked anymore. Locked orders and suborders aren´t displayed in the Booking Cockpit anymore. Orders that are created out of customer relations are locked by default!!!
- Sales Area- selection of a sales area with sales staff and sales targets. If no sales area is selected a warning message will be displayed.
- Create suborder: creates a new suborder with standard values
- Plus-Button: opens the order-manager which is covered in a separate manual
- Reorg: starts a manual reorganisation of the order data. This has to be done if e.g. a contract was allocated to the order or if a customer/order-discount needs be activated.
Allocated suborders

In this tab all the suborders allocated to the order are displayed. It is possible to open and modify the suborder out of this tab.
Budget data

- Rel.-Budget-Calculation - If the checkbox is marked the relevant budget will not be calculated across media combis
- MG3 - total budget according to the price-folder of the order. This is the value of the order if no discounts are granted but the price-folder was strictly applied.
- MG1 - total budged according to media gross of the order. This is the sum of all the media gross amounts of the suborders.
- MG1 Discount building - relevant budget of the order for granting discounts. This is the actual order value that discounts are deducted from.
- Forecast Cash Discount - Forecast on the amount of cash discounts
- Forecast VD - Forecast on the amount of rebates in kind
Contracts
The system provides the possibility of linking the order to a commitment (1). In these contracts the user can set up discounts which can be applied to the linked orders resp. suborders. It is possible to define commitments steps with several discount levels and relate them to the orders' volume of sales. The order is assigned to a commitment step whose rebates are applied to the order.
The other kind of commitment is the Corner Position commitment (2) where it is possible to define a percentage of corner positions per month.
Agency contracts (3) are linked to the orders in the agency contract´s master data. Therefore the agency contract field is not editable in the orders' master data.
Settings

With the order label (1) a reporting entity is introduced. Here, for a sub-order to define whether it is e.g. a standard sub-order or a sub-order with special concerns. The label can then be issued accordingly grouped on behalf Reporting. If no label control values applied, the field in the subcontract does not appear.
To allow variable classifications of orders to business segments, a cash label (2) can be linked to the order. Furthermore the order can be limited to a certain order type group. This means that the suborder type has to match the order type group of the allocated order. If e.g. an order is limited to type group "classic". All the suborders that are created out of the order have to be in order type category "classic".
The order mailing list (3) provides the possibility to inform agencies about new bookings or changes of existing bookings, when done by an internal user (member of the sales house).
Order tpye limitation (4) for the selection of order types for sub-orders of this order. Only order types that belong to the selected group can be saved in a suborder.
Bookings
The order master data provide an annual overview of the booking values of all suborders allocated to the order within the validity period. The time periods (framed red on the screenshot) define the time slots relevant for consumer research. Bookings within the particular time slots are evalutated for statistical purposes by the GfK (Gesellschaft für Konsumforschung), e.g. for audience rating. How and if the days of broadcast are divided into individual dayparts depends on the customers. The time slots that divide the days of broadcast are determined by the GfK.
The buttons beneath the table are explained below (from left to right):
- MG1: media gross - shows the gross value of the bookings e.g. within the time slots
- MG2: list prices (depending on price model) - prices for basic lengths can be stored in the system, spots of 30 seconds length for instance cost 100€ in tariff category X combined with price group Y. These list prices are put together in price folders. Each price folder is allocated to one price model, e.g. a linear one. The outcome of this is the prices of the bookings.
- MG3: linear prices (value) of the booked advertising space - this is the "real" value of the ad space, thus the price the ad space would cost if all spots were charged with their full prices.
- o NR %: balance - difference between MG3 and MG2
- MN1: media net (media gross - cash discount) - MG1 less cash rebates granted
- MN2: media net2 (MN1 - AE) - MN1 less agency discounts granted
- MN3: media net3 (MN2 - Skonto) - MN2 less discounts for cash granted
- Spots: number of spots - total of booked spots over the year
- V: seconds - total of booked seconds
- o V: average seconds - amount of seconds each spot lasts on average
- o SP: average price per second (MG3 / seconds) - value of the booked ad space divided by the total of seconds
- % MG1: media gross balance - percentaged allocation of media gross to the respective time slots of the months. At the end of the year it´s a total of 100% media gross allocated to the months and time slots. The sum of all months' MG1 must be 100% at the end of the year. Just as that the sum of the time slots' MG1 must also be 100% at the end of the year. Example1: MG1 allocated to 3 months (20% + 30% + 50%). Adding the 3 months up, the total will be 100%. Example2: within the time slots the MG1 is distributed as follows: 10% between 0-6 a.m., 25% between 6-12 a.m., 15% between 12-5 p.m. and 50% between 5 to 0 p.m. The total will also be 100%.
- % MG3: distribution according to ad space value - real value of the bookings in relation to the ad spaces' just value.
- % MN3: distribution according to MN3 (Cash-In) - net value of the bookings after having granted rebates and cash discounts. The distribution is calculated as follows: 100 divided by all months' total net values resp. time slots multiplied with total net value of the particular month resp. time slot. Example: total-MN3 = 26.470; MN3 of june = 1.201 ==> 100 / 26470 * 1201 = 4,54%
- Yield: profitability in % (MN3 / MG3 *100 = Cash-In / Wert *100) - media net after having granted rebates and cash discounts divided by the real price of the booked ad space.
- %o NR %: balance distribution - the percentage that the particular month resp. time slots contributes to the total balance
- Exp D: table content exportable exportierbar (german notation)
- Exp E: table content exportable exportierbar (english notation)
If you click on the booking values within the particular time slots (framed turquoise on booking overview) the spot viewer is opened in a new window. It contains all relevant data of the order´s bookings in the selected time slot. The booked break for instance, date of broadcast, suborder and further information are displayed. At the bottom of the window the following values are displayed as total: number of spots, total length of spots, media gross, list price.
Special Actions
Following actions can be done within an order:
- Create Sub-Order
- Order manager
- Reorg
- Corner Position Report
Order Manager
This is a tool to easy generate a full order including its sub-orders and invoice settings. An automated rights allocation for agency users is possible as well.
Check out this manual.
Reorg
Reorganizes the discount relevant budget and allocates applicable discounts to the sub-orders.
All Items in the master data record Order
- Number - the order number is generated automatically by the system once the new order is saved for the first time
- External No. - if required an external order number can be entered here
- Advertiser ID - selection of the advertiser
- Agency ID - selection of the agency that is allocated to advertiser
- Invoice Recipient - selection of the client that will receive the invoice
- Sales Rep. - in case the selected agency is not responsiple for planning, a differing agency can be selected here
- Info - optional text field for additional information on the order
- Internal Comment - optional text field for internal comments
- External Comment - optional text field for external comments
- From - beginning of validity period
- To - end of validity period
- Invoice Delivery - in case there´s an agreement upon special payment conditions different from the default media invoice parameter, the client´s special payment condition can be stored in the order. It will be imported to all allocated suborders.
- Lock - if the checkbox is marked the order is locked and its allocated suborders cannot be booked anymore. Locked orders and suborders aren´t displayed in the Booking Cockpit anymore. Orders that are created out of customer relations are locked by default!!!
- Sales Area- selection of a sales area with sales staff and sales targets
- Rel.-Budget-Calculation - If the checkbox is marked the relevant budget will not be calculated across media combis
- MG3 - total budget according to the price-folder of the order. This is the value of the order if no discounts are granted but the price-folder was strictly applied.
- MG1 - total budged according to media gross of the order. This is the sum of all the media gross amounts of the suborders.
- MG1 Discount building - relevant budget of the order for granting discounts. This is the actual order value that discounts are deducted from.
- Forecast Cash Discount - Forecast on the amount of cash discounts
- Forecast VD - Forecast on the amount of rebates in kind
- Commitment - Commitment the order is linked to
- Commitment/corner position - Corner position commitment the order is linked to.
- Agency Contract - Agency contract the order is linked to
- Order Label - Label of the order and it´s sub-orders.This will be displayed in the order report if selected.
- Cash Label - Cash label of the order. This will be displayed in the order report if selected.
- Limit to order type group - Limitation for the selection of order types for sub-orders of this order. Only order types that belong to the selected group can be saved in a suborder.