Explaining Invoice Agreements and Invoice List Agreements

Objectives

After completing this lesson, you will be able to:
  • Understand the Invoice and Invoice List Agreement
  • Understand Filter Technologies used in agreements

Invoice Agreements and Invoice List Agreements

Lesson Overview

With the master agreement in place it is now possible to bring billable items of several provider contracts and different business partners on one invoice or additionally, create an invoice List. The master agreement is enhanced with an invoice agreement or invoice list agreement.

Business Example

The group headquarters should receive an invoice containing all license fees that it used by itself and its subsidiaries.

You define an invoice agreement license fees with the necessary control parameters and restrict the validity area to the business partner that represents the group headquarters.

Invoice Agreements and Invoice List Agreements

For invoice creation control parameters of the provider contract as well as the contract account are taken into account.

Billable items are processed depending on the provider contract and contract account they are assigned to. This is determined by which invoice the billable items end up on.

In the example above, business partner 100 has a contract account 10 and three provider contracts. Depending on the control parameters in the contract account as well as the provider contract, three invoices are created in the end and that is one invoice per provider contract.

Additionally, business partner 400 receives a separate invoice for their contract account 40 and provider contract 4.

With the master agreement in place it is now possible to bring billable items of several provider contracts and different business partners on one invoice.

The processing of billable items checks whether a master agreement has to be considered for the given billable items. The check is performed based on the validity area of an agreement of the master agreement. The validity area can be defined based on any field of the billable items.

Billable items which do not qualify for a master agreement will be processed according to the provider contract.

In the above example, you can see that some of the billable items of provider contract 1 and 2 have been put together onto one combined invoice. The same is true for some of the billable items of provider contract 2 and 3. Additionally, all the billable items of business partner 400 will be put on one invoice with some of the billable items of provider contract 3.

This can be achieved because it is possible to slice the given billable items depending on the given validity areas of the invoice agreements. The slicing cannot only be done vertically (within the given master data objects) but also horizontally (across different master data objects).

Some billable items of contract 1 do not qualify for the master agreement and thus, are put on a separate invoice which is created according to the control parameters of the provider contract.

An Invoice Agreement …

  • Is designed in the Master agreement maintenance in ERP.
  • Defines the Agreement for Creation of Invoices which override Provider Contract Control Parameter.
  • Define Rules and Areas of Validity as:
    Restrict Contract Partners
    A list of all business partners or group of Business partners that are authorized to sign individual contracts that refer to a master agreement.
    Restrict Products
    A list of products or group of Products to which the conditions of the master agreement apply. These can be both standard product numbers as well as custom product numbers and product names.
    Other Restrictions
    Custom selections (filter) to built for individual selections.

Hint

The billable item will be considered only once for an invoice based on invoice agreement settings.

Business Example: All Roaming Fees are paid by Headquarter.

In an integrated scenario CRM focuses on the ordering side of a master agreement, ERP focuses on the billing side.

For this, different types of agreements within the master agreement can be created.

For a more convenient maintenance of the agreements area of validity, it is possible to define business partner and product groups. By those groups the single records are bundled together and can be assigned to an agreement more easily (instead of entering each entry separately, which can become quite cumbersome).

The agreements are built up out of a rules part and an area of validity part. The rules part is specific for each type of agreement. It outlines what has to be done when a billable qualifies for an agreement (for example, the rules part of an invoice agreement tells who the invoice recipient is). The area of validity specifies the conditions under which the rules are applied. The conditions can be set up based on business partners, products and further selections based on filters and function modules.

Invoice Agreement - Control Parameters are:

  • The invoicing category, which acts as a control feature in the processes of billing. It controls the selection of the billing form, the grouping of items, and distribution to several invoices, among other things.
  • The billing cycle, which specifies the length of the periods to be billed, the end date of the period and a scheduling characteristic that is used to schedule the actual date of invoice creation.
  • An invoice recipient and a contract account of the invoice recipient. These have to be entered if the invoices are not to be posted to the contract accounts of the contract partners, but are to be posted instead to a separate, central contract account.
  • Statement field, Each contract partner receives an invoice extract showing the items belonging to him or her that were contained in the total invoice.
  • Invoice Sent To: In cases where the invoices are posted to the contract accounts of the individual contract partners, but are sent to a different address, you can also enter a business partner in the Invoice Sent To field.

The list above explains the major parameter of the invoice agreement.

Agreement for Creation of Invoicing Lists

An invoicing list is a summary of multiple invoices or parts of invoices in the form of additional correspondence.

Business Example

Once a month, the group headquarters receives a summary of all invoices that were sent to its subsidiaries.

You make the following entries in an agreement for the creation of invoicing lists: Recipient of the invoicing list

Specify a business partner number. For technical reasons, a contract account number is also required. However, the system determines the contract account number automatically.

Since the creation of the invoicing list is a function of invoicing, the following entries are also required

  • The invoicing category, which is itself a part of the control parameters (similar to the situation for invoice creation).

  • The billing cycle, which specifies the intervals in which invoicing lists are created.

For invoicing lists, you cannot restrict the validity areas by products or by other general criteria (filters and function modules). You can restrict the selection to certain business partners. You can also restrict the selection to certain invoice agreements.

The invoicing of the original billing documents checks if these contracts are relevant for an invoicing list and creates an additional invoice source document of the category SUBIN as a result of the invoicing process.

The source document, SUBIN carries the information to whom the invoicing list shall be sent.

The source document is processed by an invoice process with the activated invoice function invoicing list, SUBINV_LIST.

Invoice List Agreement

An Invoice List Agreement …

  • Is a rule definition in an Master Agreement that definition which rules should apply to billable Items.
  • An invoicing list is a summary of invoice information based on multiple invoices to be sent to an additional correspondence recipient for information purposes only.
  • Requires additional invoicing process, is additional to the normal invoice and has no posting.
  • The recipient of the invoicing list receives the invoice information of all assigned parties of the invoicing list agreement.
  • The complete information of a individual invoice can be part of multiple invoicing list agreements. E.G Sales Invoicing List, Headquarter Invoicing List.

Business Example

If the sum of all recurring feed of all Provider Contracts that are closed with the subsidiaries of headquarter are additionally monthly sent to Headquarter in Invoicing list.

Invoicing list agreement:

If invoices are sent out in a decentralized way but the headquarters want to have an overview, additional invoicing lists can be used for this. They are similar to an invoice copy but can also be set up in such a way that only final amounts are displayed and not billable items. They can be dependent on business partners as well as invoice agreements.

The agreements are built up out of two parts. These include:

  • A rules part

  • An area of validity

The rules part is specific for each type of agreement. It tells what has to be done when a billable qualifies for an agreement (for example, the rules part of an invoice agreement tells who the invoice recipient is). The area of validity specifies the conditions under which the rules are applied. The conditions can be set up based on business partners, products and further selections based on filters and function modules.

Parameters of an invoicing list agreement are:

  • An invoicing list recipient and a contract account of the invoice list recipient.
  • The invoicing category, which acts as a control feature in the processes of billing. It controls the selection of the billing form, the grouping of items, and distribution to several invoices, among other things.
  • The billing cycle, which specifies the length of the periods to be billed, the end date of the period and a scheduling characteristic that is used to schedule the actual date of invoice creation.
  • Statement field, each contract partner receives an invoice extract showing the items belonging to him or her that were contained in the total invoice.
  • Invoice Sent To: In cases where the invoices are posted to the contract accounts of the individual contract partners, but are sent to a different address, you can also enter a business partner in the Invoice Sent To field.
  • Include Own Invoices, which specifies that the own invoices of the invoicing list recipient shall be also included in the invoicing list.
  • You can restrict the business partners. You can also restrict the invoicing list to certain invoice agreements.

Filter Technologies Used in Agreements

Visualization of a filter, as a bottleneck.

A Filter in Convergent Invoicing …

  • Can be used to select items to be processed (similar to predefined selections in FI-CA, filter conditions are joined with AND).
  • Is based on the billable Item structure (BIT-Filter).All available fields can be used!
  • Can be combined to compound filter (joined together with OR).
  • Only Items, which pass the filter will be processed later on.
  • Are used in invoice and discount agreements.
  • Can be defined in Customizing or in SAP Menu.

Business Example

A predefined Filter for RAM_Usage selects all billable Items with BITTypeH221.

Simple filter:

Choose TelecommunicationsBusiness Master DataFor Integration with Rating and ChargingMaster AgreementChange Filter.

With regard to their structure, there are two different types of filters:

  1. Simple Filters:

    Simple filters contain selection conditions, similar to those you are familiar with from reporting. A billable item or a contract partner qualifies if it fulfills the selection conditions.

    You can create simple filters in the production system or in the customizing system and use them in any agreements of a master agreement.

    Choose AccountingFinancial AccountingContract Accounts Receivable and PayableMaster DataFor Integration with Rating and ChargingMaster AgreementEdit Filter (Transaction FP_Filter2).

  2. Compound Filters:

    You can create compound filters using simple filters and function modules.

    A compound filter selects a billable item or contract partner if one of the following conditions is fulfilled:

    • A billable item or contract partner fulfills at least one selection condition of a simple filter contained in the complex filter.

    • A function module selects a billable item or a contract item.

    If a compound filter also contains excluding filters or function modules, an item or a contract partner fulfills the selection conditions only if none of the exclusion criteria is also fulfilled.

    You can create compound filters only in the customizing system. In defining compound filters, you can only use simple filters that were also created in the customizing system. You use compound filters in discount agreements.

    Choose Financial Accounting (New)Contract Accounts ReceivableBasic FunctionsMaster AgreementDefine Filters for billable Items.

The following transactions are relevant for filter maintenance:

  • FQ_FILTER: Maintenance of simple general and compound filters as part of the customizing.

  • FP_FILTER3: Display of simple, general and compound filters created in the customizing as well as the productive system.

  • FP_FILTER2: Maintenance of simple general filters.

  • FP_MA1/FP_MA2: EnvironmentAdditional EnvironmentMaintain Filters: Maintenance of business partner specific filters.

Test of filter is possible for master Agreement:

Choose AccountingFinancial AccountingsContract Accounts Receivable and PayableMaster DataFor Integration with Rating and ChargingMaster AgreementUtilitiesTest data for Filters (Transaction: FP_MA_TEST).

Enhance Master Agreement with Invoice Agreement

Business Example

Headquarter pays all roaming usages for the subsidiaries and headquarter receives invoices for all contracts that are related to your master agreement.

Exercise Options

To perform this exercise, you have two options:

  1. Watch the simulation: to start the simulation, choose Start Exercise in the figure below.
  2. Perform the steps, as described below.

Task 1: Enhance Master Agreement with Invoice Agreement

Steps

  1. Your master agreement (result in task 1) for your Business Partner B2B Headquarter ## was already created by sales agent of Print Service Corporation in SAP S/4HANA system.

    Therefore, in SAP S/4HANA convergent invoicing, enhance the master agreement xxx with invoice agreement, Printer License Fee Monthly.

    Assign the contract account that is used to assign calculated discounts for a master agreement. Use the existing default contract account of the business partner that is assigned to the master agreement. Set all contract partners and all products to status completed.

    Create a new invoice agreement with the name, Printer License Fee.

    1. In the SAP Fiori launchpad search section Master Data: Contracts & Agreements and choose the tile Display Master Agreement (Corresponding back-end transaction FP_MA2). Within the app choose Change in the menu.

      Create invoice agreement on the Master Agreement Change: General Data Screen and choose the Agreements tab. In the Overview of Agreements section, choose Create AgreementInvoices (first button from left side). On the Create Invoice to Agreement popup screen, make the following entries:

      AgreementPRINTER
      NamePrinter License are paid by Headquarter.

      Choose Continue (Enter).

  2. Define invoice agreement is valid from 01/01/2017.

    1. Invoice agreement validity: In the Basic Data and Validity Area section, make the following entries:

      Items from (date starting from which items can be assigned)01/01/2017
      Items to (date up to which items can be assigned)31/12/9999

      Leave restrict contract partner, restrict products and other restrictions empty.

      That means printer license fees for all contract partners and all products are paid by Headquarter.

  3. Define agreement rules, that assign the printer license fees to contract account of your Headquarter.

    1. Define agreement rules:

      In the agreement rules selection, invoice the actual attributes of the invoice agreement that are to be maintained. Enter the business partner/contract account number of your headquarter as follows:

      • Posting to Partner: Business Partner Number of Contract Account.

      • Contract Account: Contract Account of Headquarter.

  4. Assign an existing filter printer license fee for items that represent recurring fees, for example, H250.

    1. Define filters for base amount calculation. Define which billable items are relevant for invoicing to headquarter. On the master agreement, change to General Data screen and choose Tab Agreements. Choose the Other Restrictions tab and choose Create Assignment (first button from left side).

      As Key enter LICENSE.

      Under Default Value In the Basic Data and Validity Area section, make the following entries:

      Items from (date starting from which items can be assigned)01/01/2017
      Items to (date up to which items can be assigned)31/12/9999

      Which billable items are selected with filter roaming?

      Result: Billable items with type H250 are selected in filter roaming.

      Save your entries. You have enhanced your master agreement according to business requirements.

      Hint

      If you have unassigend periods, it is necessary to adapt the period for the invoice agreement. Press button change period to adapt the invoice agreement period to 01.01.2017-31.12.9999.

Task 2: Create Billable Items as Test Data for your Master Agreement Assigned Provider Contracts

Steps

  1. Create billable items for your master agreement and your provider contracts, contract account. Run the RFKKBIXBITSAMPLE program again with variant MA_INVOICE_LIC for generation of test data. Choose SAP MenuToolsABAP WorkbenchDevelopmentUser InterfaceABAP Editor (Transaction SE38).

    Change the following fields with your solution from master agreement (solution, task 1) (user 6 master agreement 5000146)

    The report suggests one of the assigned provider contracts. Remember your contract accounts, in order to find the relevant billing documents without any trouble.

    In Menu, choose ProgramExecute. Run report second time with second provider contract related to master agreement.

    1. Select two contracts out of five that you want to use for test.

      Your contract (solution task 1) for example, user 6 provider contract 122 and 123

      Check the billable items were created using app Display Billable Items or via transaction FKKBIXBIT_MON.

      Result: The report has generated billable items for your billing process.

Task 3: Execute Billing Mass Run for License Fees

Steps

  1. Billing of all master agreement assigned contract accounts is done using app Execute Billing or via transaction FKKBIX_M with billing process YNAL and subprocess HPSP for roaming charges. Adjust the billing day in accordance to the bill from date of your billable items.

    Press Further Selection button and enter your master agreement (for example, User 6: 5000146). With that, you do not have to enter all the contract accounts of your master agreement.

    Check that the billing document that is assigned to Headquarter includes the printer license fee with billable items H250.

    1. In the SAP Fiori launchpad search section Billing and choose the tile Execute Billing (Corresponding back-end transaction FKKBIX_M).

      Check the created billing documents using app Display Billing Documents or via transaction FKKINVBILL_DISP. Again, the master agreement can be specified by using the further selection function (back-end only).

      Hint

      There are one Time Fees and Hardware fees that came from SAP S/4HANA Subscription Order Management at least on each contract account.

      Check that the billing document that is assigned to Headquarter includes the license fees with billable items H250.

Task 4: Execute Invoice Mass Run

Steps

  1. Execute invoicing using app Execute Invoicing or via transaction FKKINV_M for your master agreement. Enter YN for invoicing process and adjust the document date in accordance to the billing documents created before. Press the further selection button and enter your master agreement.

    1. In the SAP Fiori launchpad search section Invoicing and choose the tile Execute Invoicing (Corresponding back-end transaction FKKINV_M).

      Check the created invoicing documents using app Display Invoicing Documents or via transaction FKKINVDOC_DISP. Again, the master agreement can be specified by using the further selection function (back-end only).

      One invoicing document for Headquarter contains the license fees of the subsidiaries.

Log in to track your progress & complete quizzes