In this blog I would like to share my experiences with the configuration and process steps of accrual posting process in CRM trade promotion management (TPM). With regards to the topics covered, I have split this blog into two sections:

1.     Accruals Configuration

2.     Accrual Calculation & Posting Process

1.     Accruals Configuration

Customer Relationship Management -> Funds Management -> Accruals

TPM_ACL_1.png

1.1     Define accrual reference data types

You can define the reference data types the accrual calculation methods use.

TPM_ACL_2.png

The standard delivery reference data type is:

  • ERP_SV; defines ERP sales volumes as reference data.
  • TPM_PLAN; defines TPM planning data as reference data.

1.2     Define accrual methods

You can define an accrual calculation method and optional reference data that can be used to calculate the accrual amount.

TPM_ACL_3.png

TPM_ACL_4.png

There are 6 standard delivery accrual calculation methods:

  • Uses Accrual Rate of ERP Sales Volume and TPM Take Rates (ERP_SV): This method calculates accruals based on ERP rebates sales volumes using and TPM take rates. It does not support accrual amounts in upcoming fiscal period (expense forecast).
  • Whole Amount on a Fixed Date (FIXED_DT): This accrual method accrues the amount reserved for the fund usage on the date the accrual posting is performed (fixed date). It supports expense forecast.
  • Fund-Based Amount on a Fixed Date (FUNDFIXD): This accrual method is for fund-based accruals and accrues the entire amount of the fund on the date the accrual posting is performed (fixed date). It supports expense forecast.
  • Fund Usage Amount for Accrual Period (NB_DAYS): This accrual method spreads the amount reserved for the fund usage equally over the number of days that it accrues. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.
  • Spread Accrual Amount Using Ref. Data (REF_DATA): This accrual method spreads the amount reserved for the fund usage over the days that it accrues according to the reference data. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.
  • Spread Fund-Based Amount Using Ref. Data (FUNDRDTA): This accrual method is for fund-based accruals. It spreads the entire amount of the fund equally over the number of days that it accrues according to the reference data. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.

1.3     Define accrual profiles

You can define an accrual profile that references an accrual calculation method and optional reference data.

TPM_ACL_5.png

There are 5 standard delivery accrual profiles:

  • Accrue Whole Amount at Fixed Date (FIXED_DT): This accrual profile accrues the amount reserved for the fund usage on a fixed date.
  • Accrue Fund-Based Amount at Fixed Date (FUNDFIXD): This accrual profile is for fund-based accruals and accrues the entire amount of the fund on the date the accrual posting is performed (fixed date).
  • Accrue Amount Equally for Accrual Dates (NB_DAYS): This accrual profile spreads the amount reserved for the fund usage equally over the number of days that it accrues. The number of days can span several periods.
  • Accrue Using ERP Sales Volumes and TPM Take Rates (ERP_SV): This accrual profile accrues ERP sale volumes and TPM take rates using the ERP sales volume agreement accrual rate.
  • Accrue Using TPM Planning Data (TPM_PLAN): This accrual profile accrues TPM planning data.

Customer Relationship Management -> Trade Promotion Management -> Trade Promotions -> Funds Integration

TPM_ACL_6.png

1.4     Funds Integration

You can make settings to integrate funds management functionality into your trade promotions.

TPM_ACL_7.png

Under Expense Type to Accrual Profile, select the expense type for a particular promotion type. Select the accrual date range and accrual profile to map to the expense type, by doing so you specify the accrual calculation method for each expense type.

If Accrual Profile is left blank, then there will be no accrual for this expense type and its related trade spend. It is recommended to leave this field blank for off-invoice type trade spends, as they only create pricing records and not rebate agreements. Therefore, accruals are not relevant.

2.     Accrual Calculation & Posting Process

Below is the table of TPM accrual posting process steps for different accrual profiles.

Accrual Profile

Step

Program name

ERP Sales Volume Dependent

1

RCRM_FM_ACL_ACCRUAL_UPLOAD_SV

Sales Volume Load

2

RCRM_FM_ACL_ACCRUAL_RUN

Accrual Calculation

3

RCRM_FM_ACL_ACCRUAL_POSTING_FM

Accrual Posting

ERP Sales Volume Independent

1

RCRM_FM_ACL_ACCRUAL_RUN

Accrual Calculation

2

RCRM_FM_ACL_ACCRUAL_POSTING_FM

Accrual Posting

“Sales Volume Load” job uploads sales volumes from SAP ERPto SAP CRM. For the expense types having an ERP sales volume dependent accrual profile such as ERP_SV, sales volume load job should be executed before accrual calculation to transfer ERP sales volumes to CRM. The transferred sales volumes are captured in CRM table CRMD_FM_ACL_SV and will be the input of the accrual calculation for the related accrual profiles.

“Accrual Calculation” job calculates the accruals according to the accrual profile. After the calculation the accrual amounts are kept in accrual staging area, CRM table CRMD_FM_ACL_ASA, and will be the input of the accrual posting. The related entries of CRMD_FM_ACL_ASA table are cleared after the accrual posting.

“Accrual Posting” job posts the calculated accruals and creates the ‘accrue’ type fund posting documents in CRM. CRM table CRMD_FM_FPO_HEAD holds the header information and CRM table CRMD_FM_FPO_ITEM holds the item information of the fund postings.

TPM_ACL_8.png

Accruals are transferred to ERP accounting via middleware with Bdocs of CRM_FM_FPO type and create ERP accrual posting documents. In the standard delivery the reference number of the ERP accounting document is the fund posting ID of the CRM fund posting document. This number is the link between CRM and ERP accrual processes.

TPM_ACL_9.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply