AC240_EN_Col92_FV_Part_A4 (第9页)

第 370 页 / 共 603 页

Unit8: DunningandCollections AC240

DisplaythedunningletterusingSystem→OwnSpoolRequests.

Usetheaccountbalancedisplaytocheckwhetherthedunningchargeswere

posted correctly.

a) On the SAP Easy Access screen, choose: Accounting → Financial

Accounting→ContractAccountsReceivableandPayable→Periodic

Processing→ForContractAccounts→DunningNotice→Dunning

Activity Run.

Field Name Value

Run ID

Date ID Today’s date

Identification DUN##

GeneralSelections

Date ID Today’s date

Identification DUN##

Printparameters

Output device lp01

Fromthemenubar,chooseProgramrun→Schedule.

In the "Schedule Job" dialog box, choose “Background – Start

Immediate”.

On the SAP Easy Access screen, choose: Accounting → Financial

Accounting→ContractAccountsReceivableandPayable→Periodic

Processing→ForContractAccounts→Correspondence→Printto

print your dunning notices.

Field Name Value

Run ID

Date ID Today’s date

Identification DUN##

GeneralSelections

Business Partner T-CA0910##(##=yourgroupnumber)

Company Code C100

Saveyourparametersbychoosingthediskicon.

Fromthemenubar,chooseProgramrun→Schedule.

Continued on next page

346

©2009SAPAG.Allrightsreserved. 2009

Field Name Value
Run ID
Date ID Today’s date
Identification DUN##
GeneralSelections
Date ID Today’s date
Identification DUN##
Printparameters
Output device lp01
Field Name Value
Run ID
Date ID Today’s date
Identification DUN##
GeneralSelections
Business Partner T-CA0910##(##=yourgroupnumber)
Company Code C100

第 371 页 / 共 603 页

AC240 Lesson: Configuration and Execution of the Dunning Program

In the "Schedule Job" dialog box, choose “Background – Start

Immediate”.

DisplaythecreateddunningletterbychoosingSystem→OwnSpool

Requests.

Select the relevant spool number and choose the glasses icon from

the toolbar.

Return to theSAP Easy Access screen.

Check whether the dunning fees have been posted correctly by

choosingAccounting→FinancialAccounting→ContractAccounts

ReceivableandPayable→Account→AccountBalance.

Note: Postingstotheaccountaremadeusingmaintransaction0010

and subtransaction 0010.

347

2009 © 2009 SAP AG. All rights reserved.

第 372 页 / 共 603 页

Unit8: DunningandCollections AC240

Lesson Summary

You should now be able to:

• Configureappropriatedunningproceduresandunderstandhowtoexecutea

dunningruninContractAccountsReceivableandPayable

348

©2009SAPAG.Allrightsreserved. 2009

第 373 页 / 共 603 页

AC240 Lesson: Collection Processing

Lesson: Collection Processing

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• Submitreceivablestoexternal collectionagenciesandunderstandhowto

updateadditionalinformationaboutsubmitteditems

Business Example

Figure 234: Submissionto ExternalCollection Agencies

If a receivable is submitted to an external collection agency, this means that a

customerhasnotpaidareceivableandthatthecompanyisnotabletocollectit.

Receivablessubmission ismadeupof two steps:

1. Data is entered in database table DFKKCOLL, in which all submitted

receivablesandthosetobesubmitted(ReleaseforSubmission)aremanaged.

2. ReceivablestobesubmittedarereadfromtheDFKKCOLLdatabasetable

and physically

submitted using report RFKKCOL2, which creates a file for each collection

agency (Submission to Collection Agency).

349

2009 © 2009 SAP AG. All rights reserved.

第 374 页 / 共 603 页

Unit8: DunningandCollections AC240

The dunning activity (FKK_COLL_AGENCY_RELEASE_0350) releases a

receivable to an external collection agency. Receivables can be submitted to

collection agencies for the following items:

• Receivables (also statistical items)

• Credit memos

The external collection agency is determined by derivation rules defined in

Customizing (event 5060).

Submissionstatus01: Release Receivableis set.

The periodic submission flow (transaction FP03D or FP03DM) selects the

documentsandcreatesalistorsubmissionfile(thesubmissionfilecanalsobe

generatedinXMLformat). Thefollowingdataisupdated:

• Inthecollectionagencyitem(DFKKCOLL):Submissiondate,submission

status(02: Receivablesubmitted),and possiblesubmissionamount,ifnot

identical to the amount in the open item.

• In the document: Payment block, dunning block, or alternative payer

(posting area 1054).

Logs,whicharelistedintheDFKKOPCOLLtablebythemassrunforsubmitting

receivablestocollectionagencies(FP03DM),canbedeletedusingtheFP03DML

transaction.

350

©2009SAPAG.Allrightsreserved. 2009

第 375 页 / 共 603 页

AC240 Lesson: Collection Processing

Submission Status

• 01: Receivable released for submission

Release process (dunning, mass release)

• 02: Receivable submitted

Submission run

• 03: Receivablepaidbycollectionagency(event0020)

• 04: Receivablepaidpartiallybycollectionagency(event0020)

• 05: Submission of receivable reversed

Dunning run reversal

• 06: Submission of receivablefailed(event0020)

• 07: Receivable paid partially and submission of outstanding receivable

reversed

• 08: Receivablepaidpartiallyandpartiallyuncollectible(event0020)

• 09: Receivable recalled

Recall receivable

• 10: Receivablepaiddirectlybycustomer(event0020)

• 11: Receivablepartiallypaidbycustomerdirectly(event0020)

• 12: Receivable cleared (event 0020)

• 13: Receivable partially cleared (event 0020)

• 14: Receivablereleasedandpartiallynotcollectable

• 15: Receivablesubmittedandpartiallynotcollectable

• 16: Receivablerecalledandpartiallynotcollectable

InadditiontothestatusesdeliveredbySAPforitemsreleasedandsubmittedto

collectionagencies,youcanalsodefineyourown,company-specificsubmission

statuses. Youcanusethenumberrange20to99forthis. Numbers01to19are

standardsettings. Undernocircumstancesshouldyouchangethem.

351

2009 © 2009 SAP AG. All rights reserved.

第 376 页 / 共 603 页

Unit8: DunningandCollections AC240

Figure235: SubmissionofReceivablestoExternalCollectionAgencies

IntheCustomizingactivityDefineDerivationRulesforResponsibleCollection

Agency,youcandefinewhichcollectionagencyistobeused,dependingonthe

data in the document.

ThederivationrulesdefinedinCustomizingareevaluatedbythederivationtool.

The derivation tool is always called in the FKK_COLL_AG_SAMPLE_5060

functionmodulewhenitemsarereleasedforsubmissionindividuallyintransaction

FP03Eor inmassreleaseusingtransaction FP03M.

Thederivationtooldeterminestheresponsiblecollectionagencyinoneormore

derivation steps from a range of source fields of the enhanceable structure

FKKCOLLAG. The number of derivation steps corresponds to the number of

derivation rules you define in Customizing.

IfyouwanttocontinueusingtheoldCustomizingactivitybecause,forexample,

youhavenottransferredthederivationtothenewCustomizingactivity,definethe

functionmoduleFMCA_COLLAG_SAMPLE_5060forevent5060.

352

©2009SAPAG.Allrightsreserved. 2009

第 377 页 / 共 603 页

AC240 Lesson: Collection Processing

Management of Submitted Receivables

• Receivables that were submitted to external collection agencies can be

managed using transaction FP03. The following functions are available

in transaction FP03:

– Changesubmissionstatus(changedocumentisgenerated)

– Indicatorthatthereceivablesweresoldtothecollectionagency

– Submit receivables

– Recall receivables

– Create list of collection items

Inbound Collection Agency Information

• The collection agency file contains:

– Collected payments

– Uncollected payments

– Interest

– Charges

A RFKK60PM collection agency has completed a collection order and now

forwardsafiletothesold-to-partyinformingofthereceivablesthatwerecollected,

andthosethatwereonlypartiallycollectedornotatall.

Figure 236: CollectionAgencyPayment: Incoming Payment

353

2009 © 2009 SAP AG. All rights reserved.

第 378 页 / 共 603 页

Unit8: DunningandCollections AC240

When you submit an item, you can create a payment form that simplifies the

assignment of payments to open items. If the file from the collection agency

containscollectedpayments,thesecanbeallocatedtotheappropriateopenitems

usingthepaymentformnumberconfirmedbythecollectionagency

Ifthecollectionfilecontainsinterestandcharges,thesystempoststheseasinterest

andcreditreceivablesandtheyarepassedontothecustomer.

Receivablesthathavenotbeencollectedandare,therefore,irrecoverablecanbe

automaticallywrittenoffifyouactivatetheWrite-offItemDirectlyindicatorinthe

write-off parameters of RFKKCOPM.

Collectionchargestobepaidtothecollectionagencycanbedeterminedusinga

definedfunctionmoduleinevent5068andpostedaspayablestothecollection

agency'scontractaccount. Todothis,youmustactivatePostCollectionCharges

indicator in thespecifications of RFKKCOPM.

If the collection agency provides the information personally or in writing, the

payments, interest and chargesreceivablesmust be posted manually. You can

usetransactionFPAVI(paymentadvicenotefromcollectionagency) toenter a

payment advice note.

Figure 237: Collection Agency Payments: Postings

354

©2009SAPAG.Allrightsreserved. 2009

第 379 页 / 共 603 页

AC240 Lesson: Collection Processing

Figure238: AdministratorInformationforIncomingPayment

Ifyouwanttoensurethattheresponsibleprocessorisinformedaboutincoming

paymentstocollectionitems,thesystemcansendamessagewhenapaymentis

posted. ThesamplefunctionmoduleFMCA_CLERK_COLL_AG_0020andthe

ruleFMCA_COLL_AC(02100019)aredeliveredforthis.

As soon as a payment is made to a collections item, the processor receives an

incomingdocumentwhichisdisplayedintheSAPBusinessWorkplace. Using

thisnotification,theprocessorcandecidewhetheranitemhastobecalledback

fromthecollectionsagencyorwhetherotherstepsshouldbecarriedout.

Figure 239: Collection: Information forCollection Agency

355

2009 © 2009 SAP AG. All rights reserved.

第 380 页 / 共 603 页

Unit8: DunningandCollections AC240

Thecollectionagencyhastobeinformedwhenitemsarecalledbackandmust

receiveinformationonitemsthathavealreadybeensubmitted. InCustomizing,

youcanspecifywhichinformationisincludedinthefileforthecollectionagency.

TheInformationforCollectionAgency(FPCI)massrunenablesyoutocreatefiles

forthecollectionagenciesthatcontainthefollowinginformation:

Themasterdataofoneormorebusinesspartnershaschanged.

Thebusinesspartnerhasdirectlypaidpartoralloftheoutstandingamount. The

programwritesitemswiththefollowingsubmissionstatusinthefile:

• 10 (receivable paid directly by customer)

• 11 (receivable partially paid by customer)

Itemsthatthecollection agency cannotrecover withinacertain period haveto

be called back. When this happens the program includes items that have the

submissionstatus09(call backreceivable)inthefile.

The direct customer payment for a previously submitted item was reversed,

clearing reset or a return made.

In the case of a reversal, returns or the (partial) reset of a clearing, the items

in question receive the status 02 (receivable submitted) again. You can use

the information file to inform thecollection agency about the resubmission of

items, providedthatthecollectionagencyhasalreadybeeninformedaboutthe

customer's direct payment.

Figure 240: Collection: Customizing

356

©2009SAPAG.Allrightsreserved. 2009

第 381 页 / 共 603 页

AC240 Lesson: Collection Processing

Exercise 15: Submitting Receivables to

External Collection Agencies

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Submitreleasedreceivablesforcollectionagencies.

Business Example

Theconfigureddunningprocedurecontainsthereleaseofreceivablestoexternal

collectionagenciesintheseconddunning step. Oncethedunningprocedureis

complete,yousubmitthereleasedreceivablestoexternalcollections.

Task:

1. Execute a second dunning run for business partner T-CA0910##. Copy

thedunningrunDUN##fromthe“CreateDunningNotices”exercisewith

the following information:

Date ID: Today's date + 30

Identification: DUX##

Enter the following parameters:

Date of issue: Today's date + 30

Company Code: C100

Business Partner: T-CA0910##

Start Current Run: Yes

Onthe"Logs"tabpage,activatethelogclassforadditionalinformationso

that you can track all of the dunning activities for your business partner.

Saveyourentriesandstartthedunningrunincludingthedunningactivities

immediately.

Checkwhetherthedunneditemshavebeenreleasedforcollection.

2. Submit the receivables for business partner T-CA0910## to collection

agencyCOLLECT_IT.Displaythestatusinformationaboutthesubmission.

Which changes are made at document level when the item is submitted

to the external collection agency?

Analyze the document changes.

357

2009 © 2009 SAP AG. All rights reserved.

Date ID: Today's date + 30
Identification: DUX##
Date of issue: Today's date + 30
Company Code: C100
Business Partner: T-CA0910##
Start Current Run: Yes

第 382 页 / 共 603 页

Unit8: DunningandCollections AC240

Solution 15: Submitting Receivables to

External Collection Agencies

Task:

1. Execute a second dunning run for business partner T-CA0910##. Copy

thedunningrunDUN##fromthe“CreateDunningNotices”exercisewith

the following information:

Date ID: Today's date + 30

Identification: DUX##

Enter the following parameters:

Date of issue: Today's date + 30

Company Code: C100

Business Partner: T-CA0910##

Start Current Run: Yes

Onthe"Logs"tabpage,activatethelogclassforadditionalinformationso

that you can track all of the dunning activities for your business partner.

Saveyourentriesandstartthedunningrunincludingthedunningactivities

immediately.

Continued on next page

358

©2009SAPAG.Allrightsreserved. 2009

Date ID: Today's date + 30
Identification: DUX##
Date of issue: Today's date + 30
Company Code: C100
Business Partner: T-CA0910##
Start Current Run: Yes

第 383 页 / 共 603 页

AC240 Lesson: Collection Processing

Checkwhetherthedunneditemshavebeenreleasedforcollection.

a) On the SAP Easy Access screen, choose: Accounting →Financial

Accounting→ContractAccountsReceivableandPayable→Periodic

Processing→ForContractAccounts→DunningNotice→Dunning

Proposal Run.

CopythedunningrunDUN##withthefollowinginformation:

Date ID: Today's date + 30

Identification: DUX##

Enter the following parameters:

Date of issue: Today's date + 30

Company Code: C100

Business Partner: T-CA0910##

Start Current Run: Yes

Choosethediskicontosaveyourparametersettingsandschedulethe

dunningrunbychoosingProgramrun→Schedule.

In the "Schedule Job" dialog box, choose “Background – Start

Immediate”.

Choosethe“Logs”tabpagetocheckwhether your dunningrunhas

beencompletedsuccessfully. Choose“ApplicationLog”toviewthe

detailsforthedunningrun. Theentryinthe“Total”columnprovides

all of the necessary information.

Return to theSAP Easy Access screen.

On the SAP Easy Access screen, choose: Accounting →Financial

Accounting→ContractAccountsReceivableandPayable→Account

→ Submit for Collection → Process Collection Items and check

whether the receivables have been submitted for collection during

the dunning run.

Do not leave the transaction.

2. Submit the receivables for business partner T-CA0910## to collection

agencyCOLLECT_IT.Displaythestatusinformationaboutthesubmission.

Which changes are made at document level when the item is submitted

to the external collection agency?

Continued on next page

359

2009 © 2009 SAP AG. All rights reserved.

Date ID: Today's date + 30
Identification: DUX##
Date of issue: Today's date + 30
Company Code: C100
Business Partner: T-CA0910##
Start Current Run: Yes

第 384 页 / 共 603 页

Unit8: DunningandCollections AC240

Analyze the document changes.

a) On the SAP Easy Access screen, choose Accounting → Financial

Accounting→ContractAccountsReceivableandPayable→Account

→SubmitforCollection→ProcessCollectionItems. Selecttheitems

to be submitted and choose “Submit”.

On the following selection screen, enter the collection agency

COLLECT_IT in the “Submit to Collection Agency” field, choose

“Submit Items” instead of the simulation, and start the submission

process by choosing Execute (F8).

Oncethesubmissionhasbeenloggedinalist,pressF3toreturntothe

“Management ofSubmittedItems”screen.

Updatethedisplayifnecessary(submissionstatuschangesto02)and

branch to the detail displayof the document by double clicking the

document number.

Double-clickthebusinesspartneritemtoaccessthedetailscreenfor

the business partner item.

Switch to the “Payments” tab page.

Result: Thecollectionagencyhasbeenenteredasanalternativepartner

for payments, alongwiththepaymentlockreason“I –Submittedto

Ext. Collection Agency”.

Switchtothe“DunningData”tabpage. Result: TheDunnLockReason

fieldcontains“I–SubmittedtoExt. CollectionAgency”.

360

©2009SAPAG.Allrightsreserved. 2009

第 385 页 / 共 603 页

AC240 Lesson: Collection Processing

Lesson Summary

You should now be able to:

• Submitreceivablestoexternal collectionagenciesandunderstandhowto

updateadditionalinformationaboutsubmitteditems

361

2009 © 2009 SAP AG. All rights reserved.

第 386 页 / 共 603 页

UnitSummary AC240

Unit Summary

You should now be able to:

• DefinethedunningtermsusedinContractAccountsReceivableandPayable

• Configureappropriatedunningproceduresandunderstandhowtoexecutea

dunningruninContractAccountsReceivableandPayable

• Submit receivablestoexternal collectionagenciesandunderstand howto

updateadditionalinformationaboutsubmitteditems

362

©2009SAPAG.Allrightsreserved. 2009

第 387 页 / 共 603 页

第 388 页 / 共 603 页

第 389 页 / 共 603 页

Unit 9

Interest Calculation

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• DescribetheprinciplesandtransactionsforinterestcalculationinContract

Accounts Receivable and Payable

• Configureinterestkeysandcalculationrulesforiteminterestcalculation

• Execute interest calculation

Unit Contents

Lesson: Calculation of Interest on Items.....................................364

Lesson: Interest Keys and Calculation Rules...............................367

Lesson: Processing of Interest Calculation..................................379

Exercise 16: Calculation of Interest on Items...........................387

363

2009 © 2009 SAP AG. All rights reserved.

第 390 页 / 共 603 页

Unit9: InterestCalculation AC240

Lesson: Calculation of Interest on Items

Lesson Overview

This lesson gives you an overview of the main task of interest calculation in

Contract AccountsReceivable and Payable.

Lesson Objectives

After completingthislesson, you will beable to:

• DescribetheprinciplesandtransactionsforinterestcalculationinContract

Accounts Receivable and Payable

Business Example

Figure 241: Interest Calculation: Considerations

364

©2009SAPAG.Allrightsreserved. 2009

第 391 页 / 共 603 页

AC240 Lesson: Calculation of Interest on Items

Figure 242: BusinessTransactions forPosting Interest

• Debit interest:

Interestonopendebititemsiscalculatedfortheperiodfromtheduedateto

theinterestcalculationdate(thisisusuallythecurrentdate).

• Cleared debit items:

Interest on debit items that were cleared late is calculated for the period

fromtheduedatetothedateofclearing,providedtheclearingfallsbefore

the interest calculation date.

• Do not calculate interest:

Ifanitemisnotclearedbyapayment,usuallynointerestcalculationisto

takeplace(forexample,interestmustnotbecalculatedforitemsthathave

the clearing reason “Reversal”).

• Credit interest:

Credit interest for calculating interest for credit always has to be posted

as relevant for the general ledger.

Interestisnotcalculatedforallocatedincomingpayments.

• Interest simulation:

Interestiscalculatedforinformationonly;itisnotposted.

365

2009 © 2009 SAP AG. All rights reserved.

第 392 页 / 共 603 页

Unit9: InterestCalculation AC240

Lesson Summary

You should now be able to:

• DescribetheprinciplesandtransactionsforinterestcalculationinContract

Accounts Receivable and Payable

366

©2009SAPAG.Allrightsreserved. 2009

第 393 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

Lesson: Interest Keys and Calculation Rules

Lesson Overview

This lesson givesyou an overviewof how interest calculation iscarried out in

Contract Accounts Receivable and Payable.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Configureinterestkeysandcalculationrulesforiteminterestcalculation

Business Example

Figure 243: Interest Parameters

The interest key contains all control parameters for calculating interest, for

example,theparametersforselectingitemsandthereferencetothecalculation

rule.

Priority of interest key determination

• Aninterestkeyenteredintheitemhasthehighest priority. Youcanenter

theinterestkeymanually,oritcanbedeterminedfromthetransactionsand

enteredintheitembythesystematthetimeofposting.

• If interest is calculated for an item as part of the dunning procedure, an

interest key can bestored inthedunning level.

• Theinterestkeycanalsobeenteredinthecontractaccount.

367

2009 © 2009 SAP AG. All rights reserved.

第 394 页 / 共 603 页

Unit9: InterestCalculation AC240

Ifaninterestkeycannotbedetermined,interestcalculationisnotpossible.

Thevalidinterestratesarefoundusingtheinterest calculationrule. Additional

conditionscanalsobestoredintheinterestcalculationrule.

The interest rates depend on:

• The reference interest rates (optional)

• The analysis period

Iteminterestcalculationiscontrolledbytheinterestkeyparameter. Aninterest

keyisdeterminedforeachitemforwhichinterestistobecalculated.

An interest key consists of all control parameters for interest calculation and

interest posting.

• Parameters for item selection

Figure 244: Posting Interest

The interest key controls interest calculation and can be assigned to contract

accounts,asecuritydeposit,individuallineitemsordunninglevels.

Toavoidchargingyourcustomersverysmallamounts,youcancarryoutamount

checks per customer or industry.

Interestlocksenableyoutopreventinterestfrombeingcalculatedoncertainitems.

Youcanalsoexcludecertainbusinesstransactions(suchasreversalpostingsor

additionalreceivablesforinterestcalculation)frominterestcalculation.

Interestcanbepostedsothatitisalsopostedtothegeneralledger. Debitinterest

canalsobepostedasastatisticalitem(inotherwords,notpostedtothegeneral

ledger).

368

©2009SAPAG.Allrightsreserved. 2009

第 395 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

An interest document is generated when interest is posted. Posting interest is

integrated into some business transactions.

In addition to the usual document data, an interest document also contains

informationaboutthebasisofinterestposting. Thisinformationiscontainedin

the interest supplement. The interest supplement contains the items for which

interestwascalculated,aswellastherelevantamountsandintervals. Theinterest

key is recorded in the interest supplement. This allows you to identify which

factorswereusedforinterestcalculationandposting.

When interest is posted (using manual posting, installment plan, dunning

procedure,andsoon)theresultingdocumentcontainsanoriginkeyinitsheader.

Theoriginkeyidentifiesthebusinessprocessthattriggeredtheinterestcalculation.

Forexample,originkey“28”identifiesthattheinterestdocumentresultedfroma

dunningprocedure. (YoucandisplayallpossibleoriginkeysintableTFK001).

Figure 245: Interest Calculation: Configuration

Iteminterestcalculationiscontrolledbytheinterestkeyparameter. Aninterest

keyisdeterminedforeachitemforwhichinterestistobecalculated.

An interest key consists of all control parameters for interest calculation and

interest posting.

• Parameters for item selection

• Reference to a calculation rule

369

2009 © 2009 SAP AG. All rights reserved.

第 396 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 246: Interest Calculation: Configuration

Tolerancedays(graceperiod): Minimumnumberofdaysthatmusthavepassed

sincetheduedatefornetpaymentofareceivablebeforeinterestcanbecalculated.

Ifthereceivableisclearedwithinthetoleranceperiod,nointerestcalculationor

interest posting can take place.

Hint: The tolerance period is not taken into account for interest

calculationsinthefuture(suchasinstallmentplaninterest).

Interestfrequency: Interestcalculationfrequencydeterminestheearliestpointat

whichinterestiscalculatedforanitemifinteresthasalreadybeencalculated(for

example, days, months, years).

Transfer days: Refersto theperiod that it takesa bank to clear apayment and

providetheclearinginformation. Thisensuresthatinterestcalculationdoesnot

takeplaceonareceivableforwhichpaymentisdelayedbythebank.

Baselinedateforinterestcalculation=duedatefornetpayment+graceperiod+

transfer days.

370

©2009SAPAG.Allrightsreserved. 2009

第 397 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

Figure 247: Configuration of the InterestCalculation Rule

Theinterestcalculationrulecontainstheparametersforinterestcalculation:

• Referencetoareferenceinterestrate(dynamicinterestrate)

• Fixed rates (static interest rate)

Interestcalculationrules: Interestratesarestoredper currencyanddebit/credit

indicator accordingtodate. Theycanalsobebasedonareferenceinterestrate

such as the federal funds rate.

Interestcalculationcanbecarriedoutonamonthlybasis. Forexample,interest

can be 2% for each month.

371

2009 © 2009 SAP AG. All rights reserved.

第 398 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 248: Interest Calculation Rules: Details

The interest calculation method dictateshow interest is to becalculated. Most

usersusemethod“act/365”withwhichthesystemcalculatesinterestbasedona

365-dayperiod. However,thereareothermethodsavailable.

TheScaleTypeindicatorisusediftheinterestrateusedisbasedonamounts. For

example,youmaywishtochargeaninterestrateof5%onthefirst1000balance

and then 6% for any balance above 1000.

Theinterestintervalcanbesettoaday,week,month,oryear. Inmostcountries,

thisindicatorissettoYear. However,somecountrieswithhighinflationratesuse

Day or Week (such as Brazil).

• Youcanroundinteriminterestcalculations. Roundingrulescandifferand

have to be configured.

• Example: Interestistobecalculatedonanamountfortheperiodfrom01/01

to01/20, usingahigherinterestratefrom01/10on.

• Interest from 01/01 to 01/09: 10.12345. Interest from 01/01 to 01/20:

30.34437

Iftheamountistobecalculatedtotwodecimalplaces,thetotalinterestwithout

flaggingRoundinteriminteresttotalsis40.47(10.12345+30.34437=40.46782).

Iftheindicatorisselected,thetotalinterestis40.46(10.12+30.34).

372

©2009SAPAG.Allrightsreserved. 2009

第 399 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

Calculate interest on total amount. This indicator is used in conjunction with

the ScaleTypeoption for interest rates. For example, if the interest ratevaries

accordingtoamountsandthisindicatorisselected,theinterestrateusedisapplied

to the entire amount. If the indicator is not selected, theinterest rate specified

for each amount is used.

IftheComp. Interestsettingisselected,interestiscalculatedbasedonacompound

interest formula.

Figure 249: Interest Calculation: Rounding Rules

RoundingrulesareassignedtointerestcalculationrulesintheInterestConditions

areafor interest calculation in Customizing.

Threeroundingrulesareavailableforinterestcalculation:

• “' '” round to the nearest whole number

• “-”alwaysrounddowntothenearestwholenumber

• “+”alwaysrounduptothenearestwholenumber. Groupingofitemsbefore

interest calculation

By using event 2085, you can group items before the interest calculation -

provided you have set the Summarize Subitems before Interest Calculation

indicatorintheinterestkey. SeethedocumentationfortheFKK_SAMPLE_2085

andFKK_CONDENSE_2085 function modules.

Ifyouusedifferentinterestratestocalculateinterestonreceivablesandpayables,

for example, youcan groupitemsin event 2085before the interest calculation

andusetheinterestrateforreceivablesiftheamountofthereceivablesexceeds

that of the payables.

Usingafunctionmoduleprocessedinevent2075youcanroundtheresultofthe

interest calculation up or down.

373

2009 © 2009 SAP AG. All rights reserved.

第 400 页 / 共 603 页

Unit9: InterestCalculation AC240

IfyouenterfunctionmoduleFKK_ROUND_INT_AMOUNTinevent2075,you

canroundtheinterestcalculatedusingfunctionmoduleFKK_INTEREST_CALC

accordingto thevalues defined inCustomizing.

Figure 250: Interest Calculation: AdditionalReceivables

Foradditionalreceivables(interestandcharges)thataregeneratedbyFI-CA,itis

possible to define interest calculation rules.

TheInterestCalculationindicatorinformsthesystemwhetherornottheadditional

receivableistobeincludedwheninterestiscalculated. Youmayalsospecifya

specificinterestkeyfortheseadditionalreceivablesforeachresponsiblecompany

code.

374

©2009SAPAG.Allrightsreserved. 2009

第 401 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

Figure 251: Interest Key: Determination

Thesystemlooksforaninterestkeyinthesequence1to4. Ifnointerestkeycan

bedetermined, interest calculationisnot possibleandinterestisnot calculated

for the item.

The system calculates interest only on those items for which it can determine

aninterest key. An interest keycanbeassignedtoacontractaccount, itemsor

dunninglevels. Thesystemnormallydeterminestheinterestkeyforeachindustry,

butcanalsodosoon acustomer-by-customer basis.

Hint: Thishierarchyisdefinedinevent2000. Ifdesired,youcanchange

thecodingoftheeventtochangethishierarchy.

375

2009 © 2009 SAP AG. All rights reserved.

第 402 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 252: Dunning Level - Customizing forInterest

If you select the Calculate Interest indicator, interest is calculated when this

dunning level is reached.

Ingeneral,theinterestkeydeterminesthecalculationruleandtheperiodcontrol.

The “update key” has three possible settings:

• “' '” =interest is only calculated, not posted. An organization can send a

lettertoacustomer, informingthemthattheycouldhavechargedinterest,

but opted not to.

• “1” = interest is calculated and posted statistically (you do not expect to

completethetransactionorcollect the interest).

• “2” = interest is calculated and posted. The general ledger is updated as

a result.

376

©2009SAPAG.Allrightsreserved. 2009

第 403 页 / 共 603 页

AC240 Lesson: Interest Keys and Calculation Rules

Figure 253: Interest Calculation: Customizing

Referenceinterestratesareusedinvariousapplicationcomponents. Therefore,

referenceinterestratesmayalreadybemaintainedhere. Date-dependentinterest

valuesarespecifiedforthedefinedreferenceinterestratesintheMaintainValues

forReferenceInterestRatesprocessstep. Referenceinterest ratesarevalidfor

all clients.

Interestcalculationrulesareusedinvariousapplicationcomponents. Therefore,

interest calculation rules may already be maintained here. Interest calculation

rulesareallocatedtodefinedinterestkeysintheDefineInterestKeyprocessstep.

Youmustentertheinterestcalculationruleintheinterestkey. Youalsoallocate

other parameters to the interest key.

Intheadditionalfunctionsfor interest calculation, youcanspecifywhetherthe

followingtakesplacewheninterestiscalculatedforlineitems:

• Interest calculation based on net amounts

• Interestcalculationforsourceitemswheninstallmentplanitemsarecleared

IntheCustomizingsettingsfortransactions,youmustsettheinteresttransactions,

theallocationtointernaltransactions,assignmentofthestatisticaltransactions,

and account determination.

377

2009 © 2009 SAP AG. All rights reserved.

第 404 页 / 共 603 页

Unit9: InterestCalculation AC240

Lesson Summary

You should now be able to:

• Configureinterestkeysandcalculationrulesforiteminterestcalculation

378

©2009SAPAG.Allrightsreserved. 2009

第 405 页 / 共 603 页

AC240 Lesson: Processing of Interest Calculation

Lesson: Processing of Interest Calculation

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• Execute interest calculation

Business Example

Figure 254: Interest Calculation: Timeline

With a function module processed in event 2065 you can change the date for

the Calculate Interest To for clearing items. For amounts cleared in account

maintenance,theduedateoftheinvoiceandclearingdateofbothitemsareused

bydefaulttocalculatetheinterest. Inevent2065,youcanusetheduedateofthe

invoiceamountandthevaluedateofthepaymentamounttocalculatetheinterest

for amounts cleared in account maintenance.

379

2009 © 2009 SAP AG. All rights reserved.

第 406 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 255: Mass Interest Processing: Selection

Figure 256: IndividualInterestCalculation: Preparation

Thedefaultdocumenttypeandstatisticalkeydisplayedonthisscreenaredefined

inCustomizingandmaybeoverwrittenatthetimeofposting.

TheSingleDocumentindicatorspecifieswhetherthesystemistocreateaseparate

documentinGeneralLedgerAccountingforeachlineitemforwhichinterestis

calculated. ThenumberofthedocumentpostedinFI-CAisstoredasthereference

documentnumber in thegeneral ledger document.

380

©2009SAPAG.Allrightsreserved. 2009

第 407 页 / 共 603 页

AC240 Lesson: Processing of Interest Calculation

Youmustspecifywhetheryouwanttocalculateinterestondebitorcredititems.

Hint: ItisnotpossibletoselectCreditItemsandindicateonlyopendebit

items at the same time.

IfyouselecttheClearedItemsOnlyindicator,ifanypartialpayments(resulting

in 2 subitems) are made, interest calculation only takes place when the item

is totally cleared.

In the Calculate Interest To field, you specify the date up to which interest is

to be calculated.

Hint: Interest calculations are usually posted using the interest run

function, and not manually.

Figure 257: Item Selection for Interest Calculation

A“green”lightindicatesthatinterestcanbecalculated;a“red”lightindicatesthat

the item is blocked for interest calculation.

Youcandouble-clickonaredlighttofindoutwhyinterestcannotbecalculated

for that particular item.

381

2009 © 2009 SAP AG. All rights reserved.

第 408 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 258: Summarization of Interest Items

Inordertominimizethenumberofinterestdocumentsthatthesystemmustpost,

onlyoneinterestdocumentpermatchingsummarizationcriteriaispostedinthe

system.

The summarization criteria (fields) forinterest items are transferred from the

original items to the interest items.

SAPdeliversseveraldefault fieldsforsummarization. Youcannotdeletethese

criteria. Standarddeliveredfieldsinclude: companycode,businessarea,business

partnernumber,contractaccountnumber,division,andsoon. Youcanalsoadd

more fields (up to a maximum of 12 criteria, including the standard delivered

summarization fields).

Hint: Technical note: The summarization criteria are defined in the

structure FKKIV.

Figure 259: Calculation Exceptions: Interest Lock

382

©2009SAPAG.Allrightsreserved. 2009

第 409 页 / 共 603 页

AC240 Lesson: Processing of Interest Calculation

Interestlocksenableyoutopreventinterestfrombeingcalculatedoncertainitems.

Youcanalsoexcludecertainbusinesstransactions(suchasreversalpostingsor

additionalreceivablesforinterestcalculation)frominterestcalculation.

Moreoveranitemwillnotbeselectedinthefollowingcases:

• If it does not meet selection criteria

• Ifitisexcludedfrominterestcalculationinevent2010. Thefunctionmodule

calledwithevent2010checkswhetherinterestcanbecalculatedonaline

item. In the reference function module, statistical itemscan be excluded

from interest calculation

• Ifitisanadditionalreceivableandinterestcalculationwasexcluded

• If it is not due

• IfitcannotbeprocessedduetotheCustomizingsettingsfortransferdays,

tolerancedays(graceperiod), orinterestfrequency

• Ifinteresthasalreadybeencalculatedfortheitemforthegivenperiod

InCustomizingyoudefinetheclearingreasons(tableTFK056C)forcaseswhen

theinterestcalculationisnotcalculatedretroactively(forexample,reversals).

Figure 260: Interest Calculation: Exceptions

Since interest keys are linked to calculation rules, which in turn are linked to

currencytypes,aninterestdocumentcanonlybecreatedinonecurrencyatatime.

Ifyouhaveitemsindifferentcurrencies,thesystemcannotdetermineinwhich

currency theinterest document isto beposted.

Ifpostingsexistinseveralcurrenciesforanaccount,youhavetocallupinterest

posting separately for each currency.

383

2009 © 2009 SAP AG. All rights reserved.

第 410 页 / 共 603 页

Unit9: InterestCalculation AC240

Figure 261: Exception forPosting Interest: Amount Limit

Debitinterestisgeneratedifthecalculatedinterestexceedstheminimumamount

limit set in Customizing.

The amount limit for posting interest depends on the company code, the

debit/creditindicator,andthecurrency. Itemsarefirstsummarizedbycriteria,and

theninterestmustreachthedefinedminimumamountlimittobeposted.

Standardcheck: Totalamountsforallinterestforacompanycodearecompared

withtheminimumamountlimitdefinedintheTFK057table.

Foriteminterestcalculationyoucanrounditemsbeforetheinterestcalculation. If

interestiscalculatedonseveralitemstogether,eachitemisroundedindividually.

You can group subitems before the interest calculation so that a split item is

subject to interest in exactly the same way as an item that has not been split.

Event2085providesyouwithfurther,moreextensiveoptionsforgroupingitems

beforeinterestcalculation-providedyouhavesettheSummarizeSubitemsbefore

Interest Calculation indicator intheinterest key.

Ifyouusedifferentinterestratestocalculateinterestonreceivablesandpayables,

for example, you cangroup itemsin event 2085beforetheinterest calculation

andusetheinterestrateforreceivablesiftheamountofthereceivablesexceeds

that of the payables.

384

©2009SAPAG.Allrightsreserved. 2009

第 411 页 / 共 603 页

AC240 Lesson: Processing of Interest Calculation

Figure 262: Additional Functions

Figure 263: Interest Supplement and Interest History

AninterestdocumentincludesthestructuresofadocumentinFI-CA:document

header, line items, and general ledger (G/L) items. In addition to the usual

documentdata,aninterestdocumentalsocontainsinformationaboutthebasisof

interestposting. Thisinformationiscontainedintheinterestsupplement.

Foreachinterestitem,theinterestsupplementindicateshowtheinterestamount

wasdetermined,includingoriginalitems,interestperiod,andinterestrate. This

allowsyoutoreconstructhowinterestwasdeterminedatalaterdate. Theinterest

supplementcanbeaccessedviaaninterestdocument.

385

2009 © 2009 SAP AG. All rights reserved.

第 412 页 / 共 603 页

Unit9: InterestCalculation AC240

Aninterest historyrecords theinterest calculationperiod for each lineitem on

whichinterestistobecalculated. Duringinterestcalculation,theselecteditems

andtheinterestareconsideredjointly. Thisensuresthatinterestiscalculatedonly

onceforitemsforacertainperiod. Interest→Selectlineitems. Selecttheitems

for which you want to calculate interest.

Hint: Ifyoulaterchangethesystemsettingsfortheinterestcalculation

rule or interest rule, you will no longer be able to retrace interest

calculationusingtheinterestsupplement. Ifyouchangetheinterestrate

for datesin the past, this hasnoimpact. However, thesystemissuesa

warning when you try to do this.

Figure264: InterestDocumentStructuresandTechnicalDetails

Thisfigureshowssomeofthetechnicalinformationrequiredbycustomerswho

maywanttoaddeventstostandardinterest-relatedprograms.

386

©2009SAPAG.Allrightsreserved. 2009

第 413 页 / 共 603 页

AC240 Lesson: Processing of Interest Calculation

Exercise 16: Calculation of Interest on

Items

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Calculate debit interest for open and delayed cleared items. The interest

is posted online and in a mass run.

Business Example

Oneofyourbusinesspartnershasnotpaidtheirinvoice. Youwanttocalculate

interest for this overdue item.

Task:

1. Manualcalculation of interest fordebititems

CalculatetheinterestfortheoverdueitemsofbusinesspartnerT-CA1010##.

Use the following information:

Document Date Today’s date

Posting Date Today’s date

Business Partn. T-CA1010##

Currency EUR

Debit Items X

All Items X

Calc. Int. To Today’s date

Choose the “Line Items” function.

ChooseEntertoconfirmanymessagesdisplayed.

Select theoverdue items, use the Display Interestfunction todisplay the

calculated interest, and post the interest.

Writedownthedocumentnumber: ______________________________

2. Interest run (mass interest calculation)

FirstusetransactionFPE1(PostDocument)topostanadditionalreceivable

to the amount of EUR 800 for business partner T-CA1010##. Use the

following information:

Continued on next page

387

2009 © 2009 SAP AG. All rights reserved.

Document Date Today’s date
Posting Date Today’s date
Business Partn. T-CA1010##
Currency EUR
Debit Items X
All Items X
Calc. Int. To Today’s date

第 414 页 / 共 603 页

Unit9: InterestCalculation AC240

Document Date Today'sdateminus6months

Posting Date Today'sdateminus6months

Currency EUR

Company Code C100

EnteradditionaldatabychoosingNewBusinessPartnerItem:

Business Partn. T-CA1010##

Net Due Date Today'sdateminus6months

Contract Acct T-CA1010##

Transac 6000 / 0010

Amount EUR 800

Thenstarttheinterestrunasperiodicprocessingforcontractaccounts. Use

theinterestrunfromNovember25,2008withidentificationINT99asacopy

templateforyourinterestrun. Entertoday’sdateasthedateidentifier,and

for the identification, enter:

ZI0## (## = group number)

Change thefollowing interest parameters:

Date of Issue Today’s date

Posting Date Today’s date

Calc. Int. To Today’s date

CreateCorrespondence X

ChooselogclassAdditionalInformationinthelogsettings.

Saveyourentriesandscheduletheinterestruntorunimmediately.

Checktheinterestcalculatedintheaccountdisplay.

388

©2009SAPAG.Allrightsreserved. 2009

Document Date Today'sdateminus6months
Posting Date Today'sdateminus6months
Currency EUR
Company Code C100
Business Partn. T-CA1010##
Net Due Date Today'sdateminus6months
Contract Acct T-CA1010##
Transac 6000 / 0010
Amount EUR 800
Date of Issue Today’s date
Posting Date Today’s date
Calc. Int. To Today’s date
CreateCorrespondence X
返回FICO参考资料列表