Invoicing Module

From MYDAS Version 7.07 all processes to create a Invoice are unified in one UI. In this UI, it is possible to run the established Invoice Runs that were earlier handled in multiple different modules.

The UI is responsive to the specific invoice type means that only the relevant filters are displayed for the specific invoice process.

The UI will be explained for each specific Invoice process in the following chapters.

As Invoice types can potentially be named differently on different environments we always also will reference the ID of the invoice type as this is steering the behavior.

It can be defined, which invoice types are displayed in the Selection by activating used invoice types or deactivating invoice types that are not used

Invoice Type ID 1 - In Advance Invoice (=Vorab)

In case of In Advance Invoicing the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type is a Suborder invoicing type. This means it only invoices budgets booked on sub orders. Exceptions here are - Suborders that have an order type that is set to "isGRP", sub orders that contain virtual Etat packages and sub orders that are linked to placements. On sub order linked to placements there is once exception - Sub orders on Placements that are set to Spot Invoicing are considered in this process.

These selections are responsive. this means if someone selects e.g. an advertiser, only the orders of this Advertiser are show in the order selection. Which ones is stated below.

The filtering attributes are automatically showing only the relevant selections that apply for In Advance Invoicing:

  • Date From - Type Date; defaulted to the first day of the current month. This filters the delivery period.
  • Date Until - Type Date; defaulted to the last day of the current month. This filters the delivery period.
  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to suborders
  • Sales branch (=Saleshouse) - Type Filter; on Salesbranches that are assigned to suborders
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers.
  • Suborders - Type Filter; on Agencies that are assigned to orders. This filter is responsive to selected Orders.
  • Order types - Type Filter; on order types set on the sub order
  • Preliminary Invoice day -Type Filter; This is a filtering value that is set on the Invoice settings (3)

 

Invoice Type 2 - Final Invoice

In case of Final Invoicing the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type is a Suborder invoicing type. This means it only invoices budgets booked on sub orders. Exceptions here are - Suborders that have an order type that is set to "isGRP", sub orders that contain virtual Etat packages and sub orders that are linked to placements. On sub order linked to placements there is once exception - Sub orders on Placements that are set to Spot Invoicing are considered in this process.

The filtering attributes are automatically showing only the relevant selections that apply for Final Invoicing:

  • Date From - Type Date; defaulted to the first day of the current month. This filters the delivery period.
  • Date Until - Type Date; defaulted to the last day of the current month. This filters the delivery period.
  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to suborders
  • Sales branch (=Saleshouse) - Type Filter; on Salesbranches that are assigned to suborders
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers.
  • Sub orders - Type Filter; on sub orders that are assigned to an orders. This filter is responsive to selected Orders.
  • Order types - Type Filter; on order type set on the sub order

 

Invoice Type 3 - Discount Recalculation

In case of Discount Recalculation the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type applies for all discount related changes for created Invoice documents, regardless of which invoicing type is considered for the invoice generation.

The filtering attributes are automatically showing only the relevant selections that apply for Discount Recalculation:

  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to suborders
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers.
  • Sub orders - Type Filter; on sub orders that are assigned to an orders. This filter is responsive to selected Orders.
  • Fiscal year - Type Filter; As Discount recalculation are a yearly definition this enables a user to run a discount recalculation for the past, current or future year.

Invoice Type 7 - Package Invoice

In case of Package Invoicing the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type is a Suborder invoicing type. Only sub orders are considered that are set to "only Package" on sub order level and contain virtual package types. This means it only invoices budgets defined by virtual Packages on a sub orders.

The filtering attributes are automatically showing only the relevant selections that apply for Package Invoicing:

  • Date From - Type Date; defaulted to the first day of the current month. This filters the delivery period.
  • Date Until - Type Date; defaulted to the last day of the current month. This filters the delivery period.
  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to suborders
  • Sales branch (=Saleshouse) - Type Filter; on Salesbranches that are assigned to suborders
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers.
  • Sub orders - Type Filter; on sub orders that are assigned to an orders. This filter is responsive to selected Orders.
  • Order types - Type Filter; on order type set on the sub order

Invoice Type ID 8 - GRP Invoice

In case of GRP Invoicing the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type is a Suborder invoicing type. Only sub orders are considered where the order type is set to "isGRP" This means it only invoices budgets booked on sub orders. Exceptions here are - Suborders that have an order type that is set to "isGRP".

The filtering attributes are automatically showing only the relevant selections that apply for Package Invoicing:

  • Date From - Type Date; defaulted to the first day of the current month. This filters the delivery period.
  • Date Until - Type Date; defaulted to the last day of the current month. This filters the delivery period.
  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to suborders
  • Sales branch (=Saleshouse) - Type Filter; on Salesbranches that are assigned to suborders
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers.
  • Sub orders - Type Filter; on sub orders that are assigned to an orders. This filter is responsive to selected Orders.
  • Order types - Type Filter; on order type set on the sub order

Invoice Type ID 10 - All Deals Invoice at Once

To generate Placement, Campaign, and Deal Prepayment Detail invoices with Deal Invoicing all in one run, the Invoice type (2) must be selected in the new Invoicing UI (1).

  • Date type - Type Filter; Possible selections:
    • Due Date Range - filters for data to be invoiced where the due date is in between Due date from and Due date until (see below fields).
    • Due Date - filters for all not invoiced items where the invoice due date (see below field Invoice due date) is equal to or before the given date.
  • Due date from - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Due date until - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Invoice due date - Type Date; Field is visible if in the Date type filter the selection is 'Due Date'.
  • Sales branch - Type Filter; on Sales branches that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Sales areas - Type Filter; on Sales areas that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Channels - Type Filter; on channels.
  • Revenue channels - Type Filter; on revenue channels.
  • Agencies - Type Filter; on Agencies that are assigned to deals.
  • Advertisers - Type Filter; on Advertisers that are assigned to deals.
  • Media combinations - Type Filter; on Media combinations that are assigned to bundles.
  • Deals - Type Filter; on Deals.
  • Campaigns - Type Filter; on Campaigns.

Invoice Type ID 13 - Placement Invoicing

In case of Placement Invoicing the Invoice type (2) must be selected in the new Invoicing UI (1).

This invoicing type is a CCT Placement invoicing type. All placements that contain monthly billing records are considered in this invoice run. This means it applies for all invoicable placements, regardless if they are Linear, Digital or Cost related.

The filtering attributes are automatically showing only the relevant selections that apply for Package Invoicing:

  • Date From - Type Date; defaulted to the first day of the current month. This filters the delivery period.
  • Date Until - Type Date; defaulted to the last day of the current month. This filters the delivery period.
  • Invoice Date - Not a filter - Invoice date to be printed on the document
  • Agencies - Type Filter; on Agencies that are assigned to orders
  • Advertisers - Type Filter; on Advertisers that are assigned to orders.
  • Media combination - Type Filter; on Media combinations that are assigned to bundles
  • Sales branch (=Saleshouse) - Type Filter; on Salesbranches that are assigned to campaigns
  • Orders - Type Filter; on orders. This filter is responsive to selected Agencies or Advertisers and contain campaigns
  • Order types - Type Filter; on order type set on the placement

Invoice Type ID 300 - CCT Invoice Placement

To generate Placement invoices with Deal Invoicing, the Invoice type (2) must be selected in the new Invoicing UI (1).

  • Date type - Type Filter; Possible selections:
    • Due Date Range - filters for data to be invoiced where the due date is in between Due date from and Due date until (see below fields).
    • Due Date - filters for all not invoiced items where the invoice due date (see below field Invoice due date) is equal to or before the given date.
  • Due date from - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Due date until - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Invoice due date - Type Date; Field is visible if in the Date type filter the selection is 'Due Date'.
  • Sales branch - Type Filter; on Sales branches that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Sales areas - Type Filter; on Sales areas that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Agencies - Type Filter; on Agencies that are assigned to deals.
  • Advertisers - Type Filter; on Advertisers that are assigned to deals.
  • Media combinations - Type Filter; on Media combinations that are assigned to bundles.
  • Media kinds - Type Filter; on media kinds.
  • Deals - Type Filter; on Deals.
  • Campaigns - Type Filter; on Campaigns.
  • Placements - Type Filter; on Placements.

Invoice Type ID 301 - CCT Invoice Campaign

To generate Campaign invoices with Deal Invoicing, the Invoice type (2) must be selected in the new Invoicing UI (1).

  • Date type - Type Filter; Possible selections:
    • Due Date Range - filters for data to be invoiced where the due date is in between Due date from and Due date until (see below fields).
    • Due Date - filters for all not invoiced items where the invoice due date (see below field Invoice due date) is equal to or before the given date.
  • Due date from - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Due date until - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Invoice due date - Type Date; Field is visible if in the Date type filter the selection is 'Due Date'.
  • Sales branch - Type Filter; on Sales branches that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Sales areas - Type Filter; on Sales areas that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Agencies - Type Filter; on Agencies that are assigned to deals.
  • Advertisers - Type Filter; on Advertisers that are assigned to deals.
  • Media combinations - Type Filter; on Media combinations that are assigned to bundles.
  • Deals - Type Filter; on Deals.
  • Campaigns - Type Filter; on Campaigns.

Invoice Type ID 302 - CCT Invoice Deal Prepayment Detail

To generate Deal Prepayment Detail invoices, the Invoice type (2) must be selected in the new Invoicing UI (1).

  • Date type - Type Filter; Possible selections:
    • Due Date Range - filters for data to be invoiced where the due date is in between Due date from and Due date until (see below fields).
    • Due Date - filters for all not invoiced items where the invoice due date (see below field Invoice due date) is equal to or before the given date.
  • Due date from - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Due date until - Type Date; Field is visible if in the Date type filter the selection is 'Due Date Range'.
  • Invoice due date - Type Date; Field is visible if in the Date type filter the selection is 'Due Date'.
  • Sales branch - Type Filter; on Sales branches that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Sales areas - Type Filter; on Sales areas that are assigned to deals and campaigns. Visibility of filter dependent on ground setup.
  • Channels - Type Filter; on channels.
  • Revenue channels - Type Filter; on revenue channels.
  • Agencies - Type Filter; on Agencies that are assigned to deals.
  • Advertisers - Type Filter; on Advertisers that are assigned to deals.
  • Media combinations - Type Filter; on Media combinations that are assigned to bundles.
  • Deals - Type Filter; on Deals.
  • Campaigns - Type Filter; on Campaigns.

Action Buttons

  • Preview - here a invoice run can be simulated. The output creates test files in case invoiced budget is available for each invoice case.
  • Run - triggers the invoice creation for all cases where invoicable budget applies.

Table view

The table contain columns that cover all the invoice cases. it is not restricted to one invoice case.

Currently the table contains three view options.

  • Header
  • Header with Details
  • Single

Header is only displaying the summaries.

Header with Details is displaying the Summary and single lines for the invoiced Media.

Single is only displaying the Media Lines.

 

Sample In Advance invoicing in Preview Mode:

Progress bar is shown. It disappears if 100% are done.

Sample InAdvance Invoicing in Run-Mode:

First a warning will be display that this is a realistic invoice run.

Then the progress on creation will be show. once it has reached 100% it will disappear.

Then the result is displayed in the Table (Header with Details view in this case).

Key features here:

  1. Invocie number is created by the defined process (Usually Buchungskreis)
  2. Link to PDF Document with its UUID (uniqueUniqueID). If the document is downloaded it gets it defined file name (can vary by customer). minimum is that the PDF file name is the invoice Number.pdf.
  3. if x Rechnung is active here the .xml file for XRechnung is displayed.
  4. for check reasons in case the validation of a ZUGFeRD xml file faiils (see 5) we also display the ZUFFeRD.xml outside of the PDF file.
  5. KoSIT (=Koordinierungsstelle für IT-Standards) Validation for both file formats is in place. Here Validation and success columns for XRechnung and ZUGFeRD are displayed. In case of validation issues the invoice creation for the single invoice will be stopped. They system continues with the next invoice. No Invoice number will be created but an error message instead of the Invoice number will be shown.. In the respective column in this section, the validation issue will be display. This is to prevent the creation of invalid invoice .xml documents.

Required Rights

  • Kennung = "INVOICE_RUN_MODE"
  • Modul = "INVOICE"
  • Name ="Right to open the invoice frontend"