第 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 |