第 43 页 / 共 213 页
AC805 Lesson: Customizing: Cash Position
4. AddyouraccountstothegroupingsACBANKENandACBANK-IST,using
the existing entries as a basis.
a) SolutionforaddingyouraccountstothegroupingsACBANKENand
ACBANK-IST.
ChooseSAPReferenceIMG→FinancialSupplyChainManagement
→ Cash and Liquidity Management → Cash Management →
Structuring→Groupings→MaintainStructure.
Nowaddyournewaccountstothegroupings(ACBANKEN:11##00,
11##01andACBANK-IST:11##00). Usethecopyfunctiontodo
this. Choose,forexample,##Bank,asthesummarizationterm. Note
the leading zeros for the G/L account.
Choose Save.
5. Thefirstbankstatementforthenewaccountshowsadebitforanoutgoing
check.
Post this transaction (11##01/11##00).
a) Solutionforpostingthetransaction(11##01/11##00).
ChooseSAPEasyAccess→Accounting→FinancialAccounting→
GeneralLedger→Posting→EnterG/LAccountDocument.
Enter AC## as your company code.
Nowenter the data(11##01/11##00).
Debit for an outgoing check
11##01 Debit 20.000 ValueDate: today
11##00 Credit 20.000 ValueDate: today
6. Call up the new accounts in the cash position. Choose grouping
ACBANK-IST and then ACBANKEN.
a) Solutionfordisplayingyourdatainthecashposition.
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→InformationSystem→ReportsforCashManagement→Liquidity
Analyses → Cash Position.
Enteryourselections(ACBANK-ISTandACBANKEN).
35
2006/Q2 © 2006 SAP AG. All rights reserved.
| 11##01 | Debit | 20.000 | ValueDate: today |
|---|---|---|---|
| 11##00 | Credit | 20.000 | ValueDate: today |
第 44 页 / 共 213 页
Unit1: CashManagement/CashPosition AC805
Lesson Summary
You should now be able to:
• IntegrateanewhousebankintoyourCashManagementsetup.
• SetupandconfiguretheG/Laccounts(bankandbankclearingaccounts)
you need for short-term cash management.
• Setupthegroupingstructuresusedinthecashpositionandassignthenew
G/L accounts to them.
36
©2006SAPAG.Allrightsreserved. 2006/Q2
第 45 页 / 共 213 页
AC805 Unit Summary
Unit Summary
You should now be able to:
• Explainthepurposeandfunctionofthecashpositionandliquidityforecast
in SAP Cash Management.
• Distinguishbetweenlevels, groups, andaccounts.
• Recognizethespecificfeaturesofthecashposition.
• Outsort bank accounts.
• Accesstheflexibledisplaystructuresforthecashposition.
• IntegrateanewhousebankintoyourCashManagementsetup.
• SetupandconfiguretheG/L accounts(bankandbankclearingaccounts)
you need for short-termcash management.
• Setupthegroupingstructuresusedinthecashpositionandassignthenew
G/L accounts to them.
37
2006/Q2 © 2006 SAP AG. All rights reserved.
第 46 页 / 共 213 页
UnitSummary AC805
38
©2006SAPAG.Allrightsreserved. 2006/Q2
第 47 页 / 共 213 页
Unit 2
Manual Memo Records
Unit Overview
ThischapterlooksatmanualmemorecordsandtherequiredCustomizingsettings.
Unit Objectives
After completing thisunit, you will beableto:
• Reproduceplannedpaymentflowsinbankaccounts.
• Process and display payment advices.
• ImportexternalmemorecordsfromafiletotheSAPsystem.
• Defineplanningtypesandassigntheappropriatelevels
• Assignarchivingcategoriestotheindividualplanningtypes
• Use the field for automatic expiration
Unit Contents
Lesson: Application View: Manual Memo Records .........................40
Exercise 4: Manual Memo Records.......................................45
Lesson: Customizing: Manual Memo Records ..............................50
Exercise 5: Customizing: Manual Memo Records......................53
39
2006/Q2 © 2006 SAP AG. All rights reserved.
第 48 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Lesson: Application View: Manual Memo Records
Lesson Overview
Thislessonlooksattheapplicationofmanualmemorecords.
Lesson Objectives
After completingthislesson, you will beable to:
• Reproduceplannedpaymentflowsinbankaccounts.
• Process and display payment advices.
• ImportexternalmemorecordsfromafiletotheSAPsystem.
Business Example
Nowthatyouknowhowtoreproduceactualbankpostingsinplanning,younow
wanttofindouthowplannedincomingandoutgoingpaymentsthatdonotarise
fromactualbankpostingscanbedisplayedinthebankaccounts. Youalsowantto
findouthowmemorecordsthathavebeenenteredareprocessed,andhowyou
cancall upalist ofsomeor all of thememorecords.
Figure 23: Manual Planning
Youcanusemanualmemorecordstoincludeadditionalinformation(additional,
thatis,totheliquidityinformationinthesystem)inshort-termplanning.
Thisadditionalinformationinvolvesincomingandoutgoingpaymentsthatdonot
trigger actual postings in Cash Management.
40
©2006SAPAG.Allrightsreserved. 2006/Q2
第 49 页 / 共 213 页
AC805 Lesson: Application View: Manual Memo Records
Figure 24: Creating Memo Records
Youcanentersinglecashmanagementrecordsasindividualentriesorusingthe
fast entry function.
The entry procedure involves three steps:
1. Planningdata(date,account–cashmanagementaccountname,expiration
date if required)
2. Amountdata(currency,exchangerate,exchangeratetype,andsoon)
3. Additionalinformation(allocation,characteristics,description,andsoon)
The planning type determines, via Customizing, the entry level, screen, and
expiration. Theexpirationdateshowshowlongthepaymentadviceisincludedin
planning. Onlyinexceptionalcases,suchastheconcentrationpaymentadvice,
shoulditbechangeable. Youcanalsodefinethecharacteristicsyourself. They
helpyouidentifyrecordsquickly. Thetransactiontypeacceleratesthecomparison
of payment advices and bank statements.
Theplanningtypeisauniqueclassificationcharacteristic,enteredinallmanual
memorecords. Itcontrolstheleveltowhichamemorecordissent.
Youcanchoosebothanexchangerateandanexchangeratetype. If youmake
no specification, the system uses theaverage rate. You can use field selection
control to show or hide the Rate Type field.
Remembertoenteraminussignforoutgoingpaymentsadvices.
41
2006/Q2 © 2006 SAP AG. All rights reserved.
第 50 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Figure 25: Changing Memo Records Using Lists
The payment advices for editing can be changed, archived, or reactivated
(=transfer).
The widerangeof selectionoptionssimplifies the search for specific payment
advices.
Archivedpaymentadvicesarenolongerincludedinplanning.
Theplanningtype(forexample,BV)determinesthearchive(forexample,A)in
which amemo recordis stored (Customizing).
ThearchivingcategoryisfreelydefinableinCashManagementcustomizing. The
variouscategoriesaredifferentiatedbyretentionperiod. Onearchiveisusually
sufficient.
The retention period shows how many months arecord remains in the system
before it is deleted in a reorganization run.
Hint: Ifyouchangetheplanningtype,thesystemcreatesanewmemo
record and archives the original.
42
©2006SAPAG.Allrightsreserved. 2006/Q2
第 51 页 / 共 213 页
AC805 Lesson: Application View: Manual Memo Records
Figure 26: Loading External Memo Records
The Load Memo Records to File program is accessed by choosing Cash
Management→Incomings→MemoRecord→LoadfromFile. Thisprogram
importspaymentadvicedatathatwascreatedinanexternalsystemtotheSAP
system, and writes new records for it there. The data can be stored on the
application server or the presentation server.
The payment advices are supplied in the FDES_IMPORT structure. You can
generate this structure as a template using the Create Structure for External
Advices function. (In the application, choose Cash Management → Tools →
Create Structure for External Advices.)
Thefollowingfileformatsaresupported: XLS(Excel),CSV,TXT,ASCII.
IfyouusethefileformatforMicrosoftExcel,MicrosoftExcelmustbeinstalled
on the presentation server.
To import payment advice data to the SAP system, you need specify only the
file name and format.
Hint: In the case of the bank account, you must enter the account
numberandnotthecashmanagementaccountname.
43
2006/Q2 © 2006 SAP AG. All rights reserved.
第 52 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Figure 27: Payment Advice Journal
Inthepayment advicejournal, the payment advicesare listed according to the
selectioncriteriayouspecify. Youcanprintthejournal.
Unlike in the worklist, the active and archived records can be displayed in a
single list.
The program has been converted to the ABAP List Viewer (ALV). You can
configuretheoutputlisttosuityourspecificrequirements. Whendoingso,you
can use the ABAP List Viewer functions:
• Show or hide columns
• Modify columns
• Determine sort criteria
• Insert or remove interim totals
Youcansavethecurrentlistdisplayvariant. Youcanthenuseitagainthenext
time you use this program.
44
©2006SAPAG.Allrightsreserved. 2006/Q2
第 53 页 / 共 213 页
AC805 Lesson: Application View: Manual Memo Records
Exercise 4: Manual Memo Records
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Enter incoming and outgoing payments noted manually so that they are
displayed in the cash position
• Edit, archive, and select payment advices.
Business Example
Youdonotwanttoseeonlytheactualbankpostingsinthecashposition,butthe
plandatatoo. Forthisreason,whenyourbankcallsyouduringthedaytotellyou
thatalargecashamounthasbeenreceived, youcanenterthistransactionusing
paymentadvices,eventhoughnogeneralledgerpostinghasyettakenplace.
Task:
Thissectionprovidesamoredetaileddescriptionofhowtousememorecords.
1. At10:15,youreceiveacallfromyourbank(##CURR)informingyouthat
theyhavereceivedthesumof250,000EURwithtodayasthevaluedate.
Usetheappropriateplanningtype(BV)toprocessthisinformation.
Shortlyafterwards,yourinternalpatentdepartmentcallstoinformyouthata
patentfeeof500,000EURisduetomorrowatthelatest. Planthisamount
in your DBGIRO account.
2. Checkyourentriesinthecashposition(grouping: ACBANKEN).
3. Younowwanttoarchiveamemorecord. Callupalistoftheentries(Process
Memo Record Using List).
Archiveamanualmemorecordandlookathowthisaffectsthecashposition.
Younowwant tocall upjust thisarchivedrecord(ProcessMemoRecord
Using List, archiving category A).
4. Reactivatetherecordandcheckwhateffectthishasonthecashposition.
5. Younowwanttoprocess/changeaparticularmemorecord. Forexample,
changethevaluedate/planningdatetoadateinthefutureandcheckyour
entries again in the cash position.
45
2006/Q2 © 2006 SAP AG. All rights reserved.
第 54 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Solution 4: Manual Memo Records
Task:
Thissectionprovidesamoredetaileddescriptionofhowtousememorecords.
1. At10:15,youreceiveacallfromyourbank(##CURR)informingyouthat
theyhavereceivedthesumof250,000EURwithtodayasthevaluedate.
Usetheappropriateplanningtype(BV)toprocessthisinformation.
Shortlyafterwards,yourinternalpatentdepartmentcallstoinformyouthata
patentfeeof500,000EURisduetomorrowatthelatest. Planthisamount
in your DBGIRO account.
a) Solution forcreatingmanualmemorecords.
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→ Incomings→ Memo Record→Create.
EnterBV(confirmedadvices)astheplanningtypeandchooseEnteror
IndividualEntry. Chooseeithertodayortomorrowasthevaluedate.
Enterthecashmanagementaccountnameandanamount.
Caution: Remembertouseminussignswherenecessary.
Youcanalsocreateamemorecordfromthecashposition:
ChooseEnvironment→CreateMemoRecordorMemoRecord.
Enter the following values:
Cashinflow BV Value date: 250.000 ##CURR
today
Cashoutflow BV Value date: 500.000- DBGIRO
tomorrow
2. Checkyourentriesinthecashposition(grouping: ACBANKEN).
a) Solution for checking entries in the cash position (grouping:
“ACBANKEN”).
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→InformationSystem→ReportsforCashManagement→Liquidity
Analyses → Cash Position.
Grouping: “ACBANKEN”
Continued on next page
46
©2006SAPAG.Allrightsreserved. 2006/Q2
| Cashinflow | BV | Value date: today | 250.000 | ##CURR |
|---|---|---|---|---|
| Cashoutflow | BV | Value date: tomorrow | 500.000- | DBGIRO |
第 55 页 / 共 213 页
AC805 Lesson: Application View: Manual Memo Records
3. Younowwanttoarchiveamemorecord. Callupalistoftheentries(Process
Memo Record Using List).
Archiveamanualmemorecordandlookathowthisaffectsthecashposition.
Younowwant tocall upjust thisarchivedrecord(ProcessMemoRecord
Using List, archiving category A).
a) Solution for archiving a memo record.
Listing the entries:
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→MemoRecord→ChangeUsingList.
Enteryourcompanycodeandexecutetheprogram.
NowchoosethepaymentadviceyouwanttoarchiveandpressTransfer.
Notethemessagetellingyouthatamemorecordhasbeenarchived.
Displaying the archived record:
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→MemoRecord→ChangeUsingList.
Enter your company code and Archiving Category A, then execute
the program.
4. Reactivatetherecordandcheckwhateffectthishasonthecashposition.
a) Solutionforreactivatingmanualmemorecords
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→MemoRecord→ChangeUsingList.
Enter your company code and Archiving Category A, then execute
the program.
Now choose the payment advice you want to reactivate and press
Transfer. Notethemessagetellingyou thatamemorecordhasbeen
reactivated.
Viewing theeffects inthe cash position:
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→InformationSystem→ReportsforCashManagement→Liquidity
Analyses → Cash Position.
Continued on next page
47
2006/Q2 © 2006 SAP AG. All rights reserved.
第 56 页 / 共 213 页
Unit2: ManualMemoRecords AC805
5. Younowwanttoprocess/changeaparticularmemorecord. Forexample,
changethevaluedate/planningdatetoadateinthefutureandcheckyour
entries again in the cash position.
a) Solution for editing/changingmemorecords
Changing the Date:
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→MemoRecord→ChangeUsingList.
Enteryourcompanycodeandexecutetheprogram.
Chooseandselecttherequiredpaymentadvice. ChooseDisplayMemo
Record(F2)andthenChangeMemoRecord(F6).
Enter and save the new data (F11).
Displaying the changed record
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→MemoRecord→ChangeUsingList.
Now enter the required data range (Value Date from ... to ...) and
execute the program again.
Viewingthe effectsin the cash position:
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→InformationSystem→ReportsforCashManagement→Liquidity
Analyses → Cash Position.
48
©2006SAPAG.Allrightsreserved. 2006/Q2
第 57 页 / 共 213 页
AC805 Lesson: Application View: Manual Memo Records
Lesson Summary
You should now be able to:
• Reproduceplannedpaymentflowsinbankaccounts.
• Process and display payment advices.
• ImportexternalmemorecordsfromafiletotheSAPsystem.
49
2006/Q2 © 2006 SAP AG. All rights reserved.
第 58 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Lesson: Customizing: Manual Memo Records
Lesson Overview
Now that the function of manual memo records in the application has been
explained, this lesson looks at Customizing.
Lesson Objectives
After completingthislesson, you will beable to:
• Defineplanningtypesandassigntheappropriatelevels
• Assignarchivingcategoriestotheindividualplanningtypes
• Use the field for automatic expiration
Business Example
Before you can work with manual payment advices, you must make certain
settingsinCustomizing. Whenyoucreateplanningtypes,whichcharacterizethe
individualpaymentadvices,youaremakingseveralassignmentssimultaneously.
Figure 28: Planning Types
The planning type or payment advice type is freely definable. It determines
further characteristicsofthememorecords(level, archiving category, possibly
also expiration, number range, and field selection). It is the most important
classificationcharacteristic. Youcanusedifferentplanningtypestoindicatehow
likely transactions are to occur.
Thelevelenablesyoutomakeaqualitativeanalysisaboutthevalueofaplanned
item. Thereshouldbea1:1relationshipwiththeplanningtype,sothatthetypeof
memo record is clear.
Thearchivingcategorydetermineshowlongamanuallyplanneditemremainsin
the archive before it is reorganized/eliminated.
50
©2006SAPAG.Allrightsreserved. 2006/Q2
第 59 页 / 共 213 页
AC805 Lesson: Customizing: Manual Memo Records
TheAutomaticExpirationswitchdetermineswhethermemorecordsofaplanning
typebecomeinvalidautomatically("X")aftertheyreachtheexpirationdate.
You must also define the number range in advance. It controls number
assignment for memo records.
Thefieldselectionstringisusedtocontrolwhichfieldsarereadyforinput.
Figure 29: Archive Retention Period
ThearchivingcategoryisfreelydefinableinCustomizing.
Theretentionperiodisspecifiedinmonths. Individualrecordsthathavebeenin
the archive for longer than the retention period are eliminated during the next
reorganization run.
One archive is usually sufficient.
Figure 30: Examples
1)Thepaymentadvicecanbearchivedmanuallyorcanbereorganizedwhenthe
archivedurationhaselapsed(thisisthemostcommonscenarioinpractice).
2) If the CPUdateisafter theexpirationdate, thepayment adviceisnolonger
includedinthecashposition. Itcanbearchivedmanuallyorreorganized:
- After the expiration date has elapsed
51
2006/Q2 © 2006 SAP AG. All rights reserved.
第 60 页 / 共 213 页
Unit2: ManualMemoRecords AC805
- After thearchivingretentionperiodhaselapsed
3)Reorganizationnotpossible-carriedoutaftertheexpirationdatehaselapsed.
52
©2006SAPAG.Allrightsreserved. 2006/Q2
第 61 页 / 共 213 页
AC805 Lesson: Customizing: Manual Memo Records
Exercise 5: Customizing: Manual Memo
Records
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Configure a new planning type
Business Example
TheplanningtypesprovidedbySAPdonotcoverallyourrequirements. Forthis
reason, you want tocreatea newplanning type.
Task:
1. Createanewplanninglevel(memorecordGR##)forthecashpositionanda
newplanningtype(memorecordGR##)(##=yourPC/groupnumber).
Groups 01 to 09 use the names W1 to W9 for their planning level and
planningtype. Inotherwords,group01usesthenameW1,andsoon.
Groups10to19usethenamesX0toX9fortheirplanninglevelandplanning
type. Inotherwords,group10usesthenameX0,andsoon.
Groups20to29usethenamesY0toY9fortheirplanninglevelandplanning
type. Inotherwords,group20usesthenameY0,andsoon.
Groups30to39usethenamesZ0toZ9fortheirplanninglevelandplanning
type.
Onlyonearchivingrunshouldbepossible(noautomaticexpiration).
Use archiving category A.
Youmustbeabletoentertextinthetextfield(fieldstatus).
Number assignment for the manual memo record should be automatic
(internalnumberassignmentwithinterval1,000,000,000to2,000,000,000).
2. At around 10.15, a customer calls to inform you that he has authorized
payment of 1,000,000 to your bank account (11##00) and is expecting a
credit memo tomorrow.
Enterthismemorecordwithyournewplanningtype.
3. Displaythisplanningdatainthecashposition(grouping: ACBANKEN).
53
2006/Q2 © 2006 SAP AG. All rights reserved.
第 62 页 / 共 213 页
Unit2: ManualMemoRecords AC805
Solution 5: Customizing: Manual Memo
Records
Task:
1. Createanewplanninglevel(memorecordGR##)forthecashpositionanda
newplanningtype(memorecordGR##)(##=yourPC/groupnumber).
Groups 01 to 09 use the names W1 to W9 for their planning level and
planningtype. Inotherwords,group01usesthenameW1,andsoon.
Groups10to19usethenamesX0toX9fortheirplanninglevelandplanning
type. Inotherwords,group10usesthenameX0,andsoon.
Groups20to29usethenamesY0toY9fortheirplanninglevelandplanning
type. Inotherwords,group20usesthenameY0,andsoon.
Groups30to39usethenamesZ0toZ9fortheirplanninglevelandplanning
type.
Onlyonearchivingrunshouldbepossible(noautomaticexpiration).
Use archiving category A.
Youmustbeabletoentertextinthetextfield(fieldstatus).
Continued on next page
54
©2006SAPAG.Allrightsreserved. 2006/Q2
第 63 页 / 共 213 页
AC805 Lesson: Customizing: Manual Memo Records
Number assignment for the manual memo record should be automatic
(internalnumberassignmentwithinterval1,000,000,000to2,000,000,000).
a) Solutionforcreatinganewplanninglevelandplanningtype
Define the planning level:
ChooseSAPReferenceIMG→FinancialSupplyChainManagement
→CashandLiquidityManagement→CashManagement→Master
Records→G/LAccounts→DefinePlanningLevels.
Copy or enter your new data. Choose the level as stated in
instructions for the exercise and the name memo
record GR##.
UsesourcesymbolBNK (bankaccounting).
Define the planning type:
ChooseSAPReferenceIMG→FinancialSupplyChainManagement
→ Cash and Liquidity Management → Cash Management →
Structuring→ManualPlanning→DefiningPlanningTypes.
Copyorenteryournewdata. Fortheplanningtype,choosethesame
nameasyoudidfortheplanninglevel(see instructions for
the exercise). Thememorecordisonlytobearchived(donot
selectautomaticexpiration). EnterarchivingcategoryAandNumber
Range 01.
You can use number range 01.
You can use Field Status Definition to set the display status of the
individualinputfields(settextto"RequiredEntry",forexample). Note
that when the system copies existing planning types, it also copies
theirfieldstatus. IfyouchooseNewEntries, you have to setupthe
entire field status from scratch.
2. At around 10.15, a customer calls to inform you that he has authorized
payment of 1,000,000 to your bank account (11##00) and is expecting a
credit memo tomorrow.
Enterthismemorecordwithyournewplanningtype.
a) Solution for entering a memo record.
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→ Memo Record→ Create.
Enteryourdata(cashmanagementaccountname: example01GIRO;
your new planning type see exercise part 1, value date
tomorrow). You can also enter the memo record from the cash
position.
Continued on next page
55
2006/Q2 © 2006 SAP AG. All rights reserved.
第 64 页 / 共 213 页
Unit2: ManualMemoRecords AC805
3. Displaythisplanningdatainthecashposition(grouping: ACBANKEN).
a) Solutionfordisplayingyourdatainthecashposition.
ChooseSAP EasyAccess→Accounting→Financial SupplyChain
Management→CashandLiquidityManagement→CashManagement
→InformationSystem→ReportsforCashManagement→Liquidity
Analyses → Cash Position.
56
©2006SAPAG.Allrightsreserved. 2006/Q2
第 65 页 / 共 213 页
AC805 Lesson: Customizing: Manual Memo Records
Lesson Summary
You should now be able to:
• Defineplanningtypesandassigntheappropriatelevels
• Assignarchivingcategoriestotheindividualplanningtypes
• Use the field for automatic expiration
57
2006/Q2 © 2006 SAP AG. All rights reserved.
第 66 页 / 共 213 页
UnitSummary AC805
Unit Summary
You should now be able to:
• Reproduceplannedpaymentflowsinbankaccounts.
• Process and display payment advices.
• ImportexternalmemorecordsfromafiletotheSAPsystem.
• Defineplanningtypesandassigntheappropriatelevels
• Assignarchivingcategoriestotheindividualplanningtypes
• Use the field for automatic expiration
58
©2006SAPAG.Allrightsreserved. 2006/Q2
第 67 页 / 共 213 页
Unit 3
Check Deposit
Unit Overview
ThischapterlooksatthecheckdepositprocedureandtherequiredCustomizing
activities.
Unit Objectives
After completing thisunit, you will beableto:
• Explainthetechnicalprocedurefordepositingchecks.
• Enter checks andprint the checkdeposit list.
• Create and run batch input sessions.
• Postprocess postings (sessionswitherrors).
• Make the Customizing settings required for entering and posting check
deposit transactions.
• Create screen variants.
Unit Contents
Lesson: Application View: Check Deposit....................................60
Exercise 6: Check Deposit.................................................67
Lesson: Customizing: Check Deposit.........................................75
Exercise 7: Customizing: Check Deposit ................................79
59
2006/Q2 © 2006 SAP AG. All rights reserved.
第 68 页 / 共 213 页
Unit3: CheckDeposit AC805
Lesson: Application View: Check Deposit
Lesson Overview
Thislesson looksat thecheckdeposit procedure.
Lesson Objectives
After completingthislesson, you will beable to:
• Explainthetechnicalprocedurefordepositingchecks.
• Enter checksandprint the check deposit list.
• Create and run batch input sessions.
• Postprocesspostings (sessionswith errors).
Business Example
Anumber ofchecksaredepositedinyourcompany, whicharetobeclearedin
AccountsReceivableAccountingonreceipt. Youdecidetoworkwiththecheck
deposit facility in SAP Cash Management so that the open items in accounts
receivable are cleared immediately.
Figure 31: Check Deposit Procedure
YoucanusethecheckdepositfunctioninSAPCashManagementtoenterchecks
received at the company.
The manual check deposit is a “fast entry tool” that substantially reduces the
manual workinvolved inenteringchecks. You enter onlythechecksreceived,
not the posting records.
60
©2006SAPAG.Allrightsreserved. 2006/Q2
第 69 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Thesystemthenautomaticallymakesthepostingstothebankclearingaccountand
customeraccount,alongwiththepaymentclearing. Youhavetwooptionshere:
• Immediate posting
• Create and then run a batch input session
Postprocessingalsodiffersdependingonwhichoptionyouchoose.
Whenyouhavefinishedenteringchecks,additionalfunctionsareavailablesothat
youcanprocessthemfurther. Forexample,youcanprintacheckdepositlistand
give it to the bank, along with the checks.
Thecheckdepositlistiswritten,butnotposted,afterthechecksaresavedinthe
database. You can make changes in the list while it has this status. Once the
postingprocesshasbeeninitiated,nofurtherchangesarepossible.
Figure 32: Account Assignment
Procedure::
1. Enter checks. Remember toinclude clearinginformation. Createabatch
input session.
2. Runthesubledger session. Postingsto bank clearingaccounts(incoming
checks)andtosubledgeraccounting(customerclearing).
3. Printthecheckdepositlistandgiveittothebank,alongwiththechecks.
4. Importthebankstatement: bankpostings(clearingtheclearingaccountsas
necessary).
61
2006/Q2 © 2006 SAP AG. All rights reserved.
第 70 页 / 共 213 页
Unit3: CheckDeposit AC805
Figure 33: Check Deposit Transaction: Entry Screen I
Thisscreenappearsthefirsttimeyouenterabankstatement.
Here,youstipulatetheaccountassignmentvariant. Thestartvariantdetermines
whichfieldsaredisplayedwhenyouareactuallyenteringchecks. Youcanchange
theaccountassignmentvariantatanytimeduringprocessing.
The start variant specifies the account assignment variant for the individual
postings. Youcanusecustomizingtocreateentryscreens(variants)ofyourown.
Ifyouselectinternalbankdetermination,thesystemidentifiesthebankusingthe
internalnameinsteadofthebanknumberandexternalaccountnumber. Youcan
useeither, accordingtowhatisusualinyourcompany.
ThematchcodeID"D"andthecontentsoftheCustomerMatchcodefieldonthe
nextscreenmakeupthematchcodeofthecustomeraccountthesystemsearches
for (account determination for payment settlement).
Thefurther processingtypedetermineswhether thepostingsinthebatch input
session are made online or in the background.
Transfer value date: The value date from the check entry is copied into the
postings.
SpecifyaformIDifyouwanttouseaformthatdiffersfromthestandardformfor
the check deposit list.
62
©2006SAPAG.Allrightsreserved. 2006/Q2
第 71 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Figure 34: Check Deposit Transaction: Entry Screen II
Enter thefollowing data in theinitial screen:
Group: This indicator isused to differentiate between check deposit lists. For
example, you can combine incoming checks into groups by house bank. The
groupisafreely-definabletermtodifferentiatebetweenthevariouscheckdeposit
lists(basicallya“name”forthecheckdepositlist(bybankaccount,nameofthe
person who entered it, time).
Transaction: The transactioncontrolsposting. Therules are enteredwhen the
system is customized.
PostingDate: Enterthedateofthedocumentstobeposted.
Value Date: Enter the expected value date in the bank statement (can be
transferred to the documents to be posted).
Note: Aseparatelistshouldbecreatedforeachcurrency(orvaluedate)duetothe
various methods for fixing value dates.
63
2006/Q2 © 2006 SAP AG. All rights reserved.
第 72 页 / 共 213 页
Unit3: CheckDeposit AC805
Figure 35: Check Deposit List
Theaccount assignmentvariants(startvariants) determinewhichfieldsare
displayedduringentry. Differentaccountassignmentfieldsappearintheentry
screen, dependingontheaccountassignmentvariant beingused. Amongother
things,thenumberofaccountassignmentfieldsinavariantregulateswhether1,
2, or 3lines areavailablefor each memorecord.
Youdefinethevariantsincustomizingandcanchangethematanytimeduring
processing. If youusemoreaccountassignmentfieldsthanareavailableinthe
currentvariant, thisisshown inanadditional field.
For example, you can enter several document numbers and different invoice
amountsforamemorecord. Thisisofuseifacustomerusesonechecktocleara
numberofinvoices. Anaccountassignmentfieldforwhichmorethanonevalue
hasbeen entered ishighlighted in the display.
64
©2006SAPAG.Allrightsreserved. 2006/Q2
第 73 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Figure 36: Check Deposit: Printing and Overview
Youcanprintthecheckdepositlistdirectlyfromtheentryscreen. Youcanalso
printatotalslist covinganumber ofcheckdeposits.
ThePrintoptionallowsyoutodisplaytheformforprinting.
Youcanusetheoverviewtogainaperspectiveoverallyourcheckdeposits. It
contains the following data:
• Date entered
• Entered by
• Group name
• Company code and currency
• Total amount
• Processing status
You can see how far check deposit posting has progressed by means of the
processing status. If both postings and clearing postings have been made, the
statuswillbePostedinfull. Theincompletepostingstatuswillappearifonlythe
bankaccountpostingshavebeenmade. Ifnopostinghastakenplace,thestatus
will be Created.
65
2006/Q2 © 2006 SAP AG. All rights reserved.
第 74 页 / 共 213 页
Unit3: CheckDeposit AC805
Figure 37: Generating Postings
Youcangeneratethepostingsimmediatelyorusingbatchinputsessions.
The Post option generates postings immediately or the batch input sessions,
including postings for subledger accounts.
You can run the batch input sessions individually or together, online or in the
background (batch).
Thelogdisplaystheprocessingstatisticsandanyincorrecttransactions.
Incorrect transactions, which were not processed due to inadequate clearing
information, must be postprocessed.
Ifyouareusingbatchinputsessions,youmustruntheseagainonline.
Ifyouareusingimmediatepostings,youhavetopostprocessthepaymentadvices.
66
©2006SAPAG.Allrightsreserved. 2006/Q2
第 75 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Exercise 6: Check Deposit
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Enteracheckdepositlistinthesystemandpostit.
Business Example
Yourcompanyhasahighvolumeofincomingchecks. Forthisreason,youhave
decided tousethemanual checkdepositfunction.
Task:
Post the following transactions:
1. Post an outgoing invoice:
Invoice date: -11 days
Posting date: -10 days
Customer: T-F00B00
Amount: 10.000,-
Output tax: 10% - Training (1O)
Paymentterms: payableimmediatelywithoutdeduction(ZB00)
Useaccount 800200 (revenues, for examplenotpassed onto CO-PA) for
the offset posting.
Hint: Makeanoteof thedocumentnumber.
2. Yourcustomerpaysbycheck(10,000)andspecifiesthedocumentnumber.
ChoosescreenvariantSAP01andcarryoutfurtherprocessinginabatch
input session (generate online).
Enter this check in your current account, using the internal bank
designation (bankID1000, account ID1000).
Group: Own name
Posting date: Today
Value date: Tomorrow
Session name: NEBU##
Choosetransaction0002 Direct check deposit.
Continued on next page
67
2006/Q2 © 2006 SAP AG. All rights reserved.
第 76 页 / 共 213 页
Unit3: CheckDeposit AC805
Specify the document number too.
3. Generatethesessionfor subledger accounting.
4. Calluptheprintpreviewforthecheckdepositlist(outputdeviceLP01).
5. Run the batch input session to update it.
6. CheckthetransactionsincustomeraccountT-F00B00orthebankaccounts.
Makeanoteofthedocumentnumberinaccount113108.
7. Takealookathowthisaffectsthecashposition(grouping: ACBANKEN).
68
©2006SAPAG.Allrightsreserved. 2006/Q2
第 77 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Solution 6: Check Deposit
Task:
Post the following transactions:
1. Post an outgoing invoice:
Invoice date: -11 days
Posting date: -10 days
Customer: T-F00B00
Amount: 10.000,-
Output tax: 10% - Training (1O)
Paymentterms: payableimmediatelywithoutdeduction(ZB00)
Useaccount 800200 (revenues, for examplenotpassed onto CO-PA) for
the offset posting.
Hint: Makeanoteof thedocumentnumber.
a) Solution forpostingan outgoinginvoice.
ChooseSAPEasyAccess→Accounting→FinancialAccounting→
AccountsReceivable→DocumentEntry→Invoice-CompanyCode
AC##.
FieldNameorDataType Values
Customer T-F00B00
Invoice Date <-11 days>
Posting Date <-10 days>
Amount EUR 10,000
Output Tax 10% - Training (1O)
Calculate Tax Set indicator
Payment Terms payable immediately
without deduction
(ZB00)
G/L Account 800200
Amount EUR 10,000
2. Yourcustomerpaysbycheck(10,000)andspecifiesthedocumentnumber.
Continued on next page
69
2006/Q2 © 2006 SAP AG. All rights reserved.
| FieldNameorDataType | Values |
|---|---|
| Customer | T-F00B00 |
| Invoice Date | <-11 days> |
| Posting Date | <-10 days> |
| Amount | EUR 10,000 |
| Output Tax | 10% - Training (1O) |
| Calculate Tax | Set indicator |
| Payment Terms | payable immediately without deduction (ZB00) |
| G/L Account | 800200 |
| Amount | EUR 10,000 |
第 78 页 / 共 213 页
Unit3: CheckDeposit AC805
Choosescreenvariant SAP01andcarryoutfurtherprocessinginabatch
input session (generate online).
Enter this check in your current account, using the internal bank
designation (bankID1000, account ID1000).
Group: Own name
Posting date: Today
Value date: Tomorrow
Session name: NEBU##
Choosetransaction0002 Direct checkdeposit.
Continued on next page
70
©2006SAPAG.Allrightsreserved. 2006/Q2
第 79 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
Specify the document number too.
a) Solution for enteringa check deposit list.
ChooseSAPEasyAccess→Accounting→FinancialSupplyChain
Management→CashandLiquidityManagement→CashManagement
→Incomings→ManualCheckDeposit→Enter.
Enter your data.
And the document number and/or customer name AC805 to clear
the open item.
FieldNameorDataType Values
InternalBankDetermination Set indicator
Start Variant SAP01
Processing Type 1- as batch input
Company Code AC##
House Bank 1000
Account ID 1000
Group <own name>
Transaction 0002(Checkdepositonaccount)
Posting Date <today>
Value Date <tomorrow>
Currency EUR
Subledger Session NEBU##
Amount 10.000,-
Check Number 123
Issuer AC805
DocumentNumber <invoice document
number>
Savingthelistcreatesthecheckdepositlist. Youarefreetochangeor
add to the list.
Continued on next page
71
2006/Q2 © 2006 SAP AG. All rights reserved.
| FieldNameorDataType | Values |
|---|---|
| InternalBankDetermination | Set indicator |
| Start Variant | SAP01 |
| Processing Type | 1- as batch input |
| Company Code | AC## |
| House Bank | 1000 |
| Account ID | 1000 |
| Group | <own name> |
| Transaction | 0002(Checkdepositonaccount) |
| Posting Date | <today> |
| Value Date | <tomorrow> |
| Currency | EUR |
| Subledger Session | NEBU## |
| Amount | 10.000,- |
| Check Number | 123 |
| Issuer | AC805 |
| DocumentNumber | <invoice document number> |
第 80 页 / 共 213 页
Unit3: CheckDeposit AC805
3. Generatethesessionfor subledger accounting.
a) Solution for generating the sessions.
See menu path for solution 1-2 . . .
SavingthelistasecondtimecreatesthesubledgersessionNEBU##.
Or choose the following menu:
ChooseCheckdeposittrans. →Post→IndividualList.
4. Calluptheprintpreviewforthecheckdepositlist(outputdeviceLP01).
a) Solutionfor displayingthecheck deposit list.
See menu path for solution 1-2 . . .
ChooseCheckdeposittrans. →Print→IndividualList(outputdevice
LP01) → Print Preview.
5. Run the batch input session to update it.
a) Solution forupdating the sessions.
ChooseSystem→Services→BatchInput→Sessions→NEBU##–
SelectSession→Process-Processintheforeground.
The 10,000 EUR are now posted to bank clearing account 113108
(incomingcheck) againstcustomer T-F00B00, whoisclearedatthe
same time.
6. CheckthetransactionsincustomeraccountT-F00B00orthebankaccounts.
Makeanoteofthedocumentnumberinaccount113108.
a) SolutionforcheckingthetransactionsincustomeraccountT-F00B00
or the bank account.
Customer account:
ChooseSAPEasyAccess→Accounting→FinancialAccounting→
AccountsReceivable→Account→Display/ChangeLineItems.
Enter your account number. SelectCleared Items - Clearing Date:
Today.
G/L Account
ChooseSAPEasyAccess→Accounting→FinancialAccounting→
GeneralLedger→Account→Display/ChangeLineItems.
Enter account number 113108. Select Open Items - Open at Key
Date: today.
Continued on next page
72
©2006SAPAG.Allrightsreserved. 2006/Q2
第 81 页 / 共 213 页
AC805 Lesson: Application View: Check Deposit
7. Takealookathowthisaffectsthecashposition(grouping: ACBANKEN).
a) Solutionforcheckingtheeffectsofthisinthecashposition(grouping:
ACBANKEN).
Hint: See the previous exercises.
73
2006/Q2 © 2006 SAP AG. All rights reserved.
第 82 页 / 共 213 页
Unit3: CheckDeposit AC805
Lesson Summary
You should now be able to:
• Explainthetechnicalprocedurefordepositingchecks.
• Enter checksandprint the check deposit list.
• Create and run batch input sessions.
• Postprocesspostings (sessionswith errors).
74
©2006SAPAG.Allrightsreserved. 2006/Q2
第 83 页 / 共 213 页
AC805 Lesson: Customizing: Check Deposit
Lesson: Customizing: Check Deposit
Lesson Overview
Thislessonlooksatcustomizingthecheckdepositprocedure.
Lesson Objectives
After completingthislesson, youwillbeable to:
• Make the Customizing settings required for entering and posting check
deposit transactions.
• Create screen variants.
Business Example
Having decided to use the check deposit function in your business, you have
to make the necessary system settings.
Figure38: CustomizingProcess–Transactions/PostingRules
In the first step, posting rules(internal transactions) are defined. The posting
rulesrepresentpostingtransactionstypicalofthecheckdeposit.
Assigningapostingruletoatransactionusedintheapplicationmakesitpossible
toupdatethetransactionforthecheckdeposittoo. Youcandefinethetransaction
nameasyouwant. YouspecifythetransactionnameintheTransactionfieldin
the initial check deposit screen.
75
2006/Q2 © 2006 SAP AG. All rights reserved.
第 84 页 / 共 213 页
Unit3: CheckDeposit AC805
Transactionvaluedate: nameoftherulefordeterminingthevaluedatefromthe
postingdate(example: postingdate+2days)Youdefinetherulewiththebank
terms.
Accountdeterminationiseffectedusingthepostingrules. Thesystemusesthe
internaltransactiontodeterminetheinformationnecessaryforposting(posting
keys, accounts, document type, and so on).
Bank statement items that have been selected for clearing can now posted
on-account. Thiscan beanadvantageif thecustomerfortheoriginal clearing
hasbeenidentifiedandthepaymentcanbepostedtothecustomerledgerforlater
clearance. Inaddition,bankclearingaccountscanbeaccessedwithinthesystem
for thepurposeof makingtheon-account posting.
Figure 39: Postings and Account Determination
This graphic shows an example where, for organizational reasons, bank and
subledgerpostingsaretobegeneratedwhenacheckisdeposited.
Depending on whether a posting transaction affects general ledger accounting
onlyor bothG/Landsubledgeraccount, youenterpostingrulesforoneortwo
postingareas. Thepostingareadetermineswhetheritemsarepostedtothegeneral
ledger/bankaccounting(=1)and/orthesubledger(=2).
The posting type controls the data update.
Itdeterminesthepostingrule(examples: G/Lposting,subledgerposting,withor
without clearing).
76
©2006SAPAG.Allrightsreserved. 2006/Q2
第 85 页 / 共 213 页
AC805 Lesson: Customizing: Check Deposit
TheG/Laccountsarefoundusingtheaccountsymbols(example: INCOMING
CHECK).Partiallymaskedentriesrefertotheclearingaccountthatbelongstothe
G/Laccount. ThesystemusestheentryintheCurrency fieldtosendchecksin
foreigncurrencytotherequiredforeigncurrencyaccount.
Select thecompression indicator so thatthe checksareposted asa total rather
than individually.
Apostingkeyoraccountisstillfreeinpostingarea2(subledgeraccounting). The
datarequiredherefortheclearingpostingsistakenfromthecheckinformation
(drawer, document number, and so on).
Figure 40: Creating Screen Variants
Youcan create your own account assignment variants for the check deposit,
therebytailoringthearrangementand/orselectionofaccountassignmentfieldsto
yourspecificrequirements. Thestandardwedelivercontainsonevariantwhich
you cannot change.
Ifyoudonotwanttousethestandardvariant,youcanswitchitoff. Newvariants
must be activated once they havebeencreated.
The fields required for check entry are selected in the order you want them
displayed on the screen. To do this, place the cursor on a possible field, and
double-clickthefieldorselectitusingthemenuoption.
77
2006/Q2 © 2006 SAP AG. All rights reserved.
第 86 页 / 共 213 页
Unit3: CheckDeposit AC805
78
©2006SAPAG.Allrightsreserved. 2006/Q2
第 87 页 / 共 213 页
AC805 Lesson: Customizing: Check Deposit
Exercise 7: Customizing: Check Deposit
Exercise Objectives
After completingthisexercise, youwillbeableto:
• Configure your own start variant.
• Create more bank clearing accounts.
Business Example
You want to create a variant of your own to complement the standard variant
deliveredbySAP. Thiswill enableyoutospecifyadditionalinformationwhen
you enter a check deposit list.
Task:
Inyourproject,youwanttogenerateanewvariantforenteringthecheckdeposit
list.
1. Addanewvariant,GR##,tothestartvariants. Thisvariantistocontainthe
fields 3-Digit Check Number, 8-Digit Bank Key, Bank Account Number,
CustomerNumber, andReferenceDocumentNumber.
Createonelinewithdataentryfields. Remembertoactivatethenewvariant.
2. Usethenewvarianttodisplayanoverviewofchecksalreadydeposited.
3. Add the following clearing accounts to the new bank detailsfor 11##00:
11##05, 11##08, and11##09. Useaccounts113105, 113108, and113109
as templates.
79
2006/Q2 © 2006 SAP AG. All rights reserved.