AC805_EN_Col62_FV_Part_A4 (第3页) | ERP软件技术分享

第 88 页 / 共 213 页

Unit3: CheckDeposit AC805

Solution 7: Customizing: Check Deposit

Task:

Inyourproject,youwanttogenerateanewvariantforenteringthecheckdeposit

list.

1. Addanewvariant,GR##,tothestartvariants. Thisvariantistocontainthe

fields3-Digit Check Number, 8-Digit Bank Key, BankAccount Number,

CustomerNumber,andReferenceDocumentNumber.

Createonelinewithdataentryfields. Remembertoactivatethenewvariant.

a) Solutionforaddinganewvarianttothestartvariants.

Choose SAP Reference IMG → Financial Accounting → Bank

Accounting → Business Transactions → Check Deposit → Define

Variants for Check Deposits.

ChooseCreateandenterthenameofyournewvariant.

Createonelinewithdataentryfields. Double-clickthefollowingfields

from the list of tasks.

• 3-digit check number

• 8-digit bank key

• Bank account number

• Customer number

• Reference document number

Save and activate the new variant.

Ifthesystemrequiresit,createanewCustomizingrequest.

Continued on next page

第 89 页 / 共 213 页

AC805 Lesson: Customizing: Check Deposit

2. Usethenewvarianttodisplayanoverviewofchecksalreadydeposited.

a) Solutionforusingyournewvarianttodisplayanoverviewofchecks

already already deposited.

ChooseSAPEasyAccess→Accounting→FinancialSupplyChain

Management→CashandLiquidityManagement→CashManagement

→Incomings→EnterManualCheckDeposit.

ChooseOverviewandclickthebankaccountaccountforwhichyou

haveenteredthecheckdepositlist. SelectthelistandchooseTransfer.

To call up the screen for selecting variants, choose Settings –

Specifications. Choose your new variant as the start variant and

confirm.

PressReturntoproceedtothecheckdepositlistandviewthestructure

controlled by your new variant.

3. Add the following clearing accounts to the new bank detailsfor 11##00:

11##05, 11##08, and11##09. Useaccounts113105, 113108, and113109

as templates.

a) Solutionforaddingclearingaccounts11##05,11##08,and11##09.

Choose SAP Easy Access → Accounting → Financial Accounting

→General Ledger → MasterData → G/L Accounts →Individual

Processing → Centrally .

Useaccounts113105,113108,and113109astemplates.

第 90 页 / 共 213 页

Unit3: CheckDeposit AC805

Lesson Summary

You should now be able to:

• Make the Customizing settings required for entering and posting check

deposit transactions.

• Create screen variants.

第 91 页 / 共 213 页

AC805 Unit Summary

Unit Summary

You should now be able to:

• 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.

第 92 页 / 共 213 页

UnitSummary AC805

第 93 页 / 共 213 页

Unit 4

Manual Bank Statement

Unit Overview

Thischapterlooksatthefunctionsofthemanualbankstatement.

Unit Objectives

After completing thisunit, you will beableto:

• Explainthetechnicalprocedureforenteringbankstatementsmanually.

• Enter bank statements manually.

• Carryoutandpostprocesspostings(batchinputsessions).

• Make the customizing settings necessary for manually entering bank

statementsandtheentryandupdateoftherelatedtransactions.

• Define bank statement transactions for standard postings, and define the

relevant postingandaccountdeterminationrules

• Configureaccountsymbolsandallocateaccountnumbers

Unit Contents

Lesson: Application View: Manual Bank Statement ........................86

Exercise 8: Bank Statement: Manual Entry..............................93

Lesson: Customizing: Manual Bank Statement ............................102

Exercise 9: Customizing: Manual Bank Statement....................107

第 94 页 / 共 213 页

Unit4: ManualBankStatement AC805

Lesson: Application View: Manual Bank Statement

Lesson Overview

Thislessonlooksatthemanualbankstatementapplication.

Lesson Objectives

After completingthislesson, you will beable to:

• Explainthetechnicalprocedureforenteringbankstatementsmanually.

• Enter bank statements manually.

• Carryoutandpostprocesspostings(batchinputsessions).

Business Example

Certain banks send bank statements to your company by post. You now want

to familiarize yourself with the optionsand procedure for entering these bank

statementsmanually. How,andunderwhatconditions,canyoupostprocessbank

statements entered manually?

Figure 41: Manual Bank Statement Procedure

The account assignment process for the bank statement is the same as that for

the check deposit.

The manual bank statement is a fast entry tool that substantially reduces the

manualworkinvolvedinprocessingbankstatements. Youonlyneedtoenterthe

bankstatementitemsandnottheentirepostingrecords.

第 95 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

The system then automatically makes the postings to the bank account, bank

clearingaccount, andcustomeraccount, alongwiththepayment clearing. You

have two options here:

• Immediate posting

• Create and then run abatch input session.

Postprocessingalsodiffersdependingonwhichoptionyouchoose.

Themanualbankstatementiswritten,butnotposted,afterthechecksaresaved

inthedatabase. Youcanmakechangesregardingthestatementwhileithasthis

status. Oncethepostingprocesshasbeeninitiated,nofurtherchangesarepossible.

Figure 42: Entering the Bank Statement

Thisscreenonlyappearsthefirsttimeyouenterabankstatement.

Here,youstipulatetheaccountassignmentvariant. Thestartvariantdetermines

whichfieldsaredisplayedwhenyoucometoenterthebankstatement. Youcan

changetheaccountassignmentvariantatanytimeduringprocessing.

The start variant specifies the account assignment variant for the individual

postings. Youcanusecustomizingtocreateentryscreens(variants)ofyourown.

Ifyouselectinternalbankdetermination,thesystemidentifiesthebankusingthe

internalnameinsteadofthebanknumberandexternalaccountnumber. Youcan

useeither,accordingtowhatisusualinyour company.

The matchcode IDs D andKand the contents of theCustomerMatchcodeand

Vendor Matchcode fields on the next screen make up the matchcode of the

customer/vendor account the system searches for (account determination for

payment settlement).

Thefurther processingtypedetermineswhether thepostingsinthebatch input

session are made online or in the background.

第 96 页 / 共 213 页

Unit4: ManualBankStatement AC805

Transfer valuedate: Thevaluedate from the bank statementis copiedintothe

posting if you select this.

Figure43: ProcessingtheBankStatement(1)–BankandPaymentAdvices

Enter the following data in theinitial screen:

HouseBank/BankAccount ID:Here, youenter thehousebank IDandaccount

ID(forInternalBankDetermination),orthebanknumberandexternalaccount

number (for External Bank Determination).

Statement number and date

SelectionofPaymentAdvices: Aspartofstatemententry, paymentadvicesthat

have come into Cash Management by way of memo records can be copied to

the bank statement automatically. This clears them. Various selection criteria

areavailableforthispurpose. Forexample, youcanselectallpaymentadvices

enteredinaparticularplanningperiodorasofaparticularbankstatementdate.

In Further Processing, you can enter session names, if you are working with

batchinputsessions. Youcanalsorestrictprocessingtobankpostingsonly(this

improvessystem performancein onlineposting).

第 97 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Figure 44: Processing the Bank Statement (2) – Bank Document and

Selection

Youusethetransactiontocontrolwhichtypeofbankpostingyouareprocessing,

for example, credit memo, wire transfer or check payment. You define the

transaction types you need in Customizing.

Youselectindividualdocumentsinsubledgeraccountingusingcriteriasuchasthe

documentnumber,orusingthematchcode(accountdetermination)andadditional

information(documentdetermination)suchastheamount,allocation,postingdate

or document date. Which selection fields are queried depends on the account

assignmentvariant andtheinterpretationalgorithm.

Youcanselectmemorecordsrelatingtothebankstatementintheinitialscreenby

meansof variouscharacteristics. Thesearethen defaultedin thedetailscreens

forenteringtransactions. Selectedmemorecordsthatdonotagreewiththebank

accountstatementscanbedeletedaspartofentryscreenprocessing.

Ifyouhaveaccidentallyenteredthewrongbeginningandendingbalances, you

cancorrectthemintheentryscreen. Todoso,chooseGoto→ChangeControls.

第 98 页 / 共 213 页

Unit4: ManualBankStatement AC805

Figure45: ProcessingtheBankStatement(3)–FurtherProcessing

Youcandisplay,change,anddeletebankstatementsbeforepostingthem.

You can either post bank statements separately or post all the bank statements

entered in the current work session together.

ThePostoptiongeneratesthebatchinputsessionsrequiredforthebankaccount

postingsandsubledgeraccountpostings,orpoststhemimmediately.

Thecheckbybankstatementnumberensuresthatpostingscannotbemadetwice.

Thesystemgeneratesapostinglog,showingthebatchsessionnameifappropriate.

YoucanusetheOverviewtogainanoverviewofallyourbankstatements. The

processingstatusshowsthestagebankstatementpostinghasreached. Forthenext

day, choose New Statement.

第 99 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Figure 46: Example: Posting Manual BankStatement1

Figure 47: Example: Posting Manual BankStatement2

第 100 页 / 共 213 页

Unit4: ManualBankStatement AC805

Figure 48: Example: Posting Manual Bank Statement 3

第 101 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Exercise 8: Bank Statement: Manual Entry

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Post incoming and outgoing invoices.

• Enter and post a manual bank statement.

Business Example

Certain companies send bank statements to your company by post. You now

want to familiarize yourself with the options and procedure for entering these

bank statements manually.

Task:

Post the following transaction.

1. Post an incominginvoice of EUR500,000.

Vendor: T-F00B00

G/L Account : 400020

Invoice Date/Posting Date: 7 days ago

Payment Terms: ZB00

Input Tax: 10%

2. Pay this invoice with anoutgoing check.

Bank account: 113101

Invoice date/posting date: 6 days ago

Makeanoteofthedocumentno. (______________).

This clears the vendor account.

3. Post the following transaction.

Outgoing invoice EUR 590,300

Customer: T-F00B00

G/L Account : 800200

Invoice Date/Posting Date: 7 days ago

Payment Terms: ZB00

Output tax: 10%

Continued on next page

第 102 页 / 共 213 页

Unit4: ManualBankStatement AC805

4. Bank113100sendsyouthefollowingbankstatement:

External bank details:

Bank Number: 20050000

Bank Account: 111111## (##= groupno.)

Bank Statement Number: 1

Bank Statement Date: Today

Beginning Balance: 0,-

Ending Balance: 100.000,-

Enter this statement. Do not post it yet. Take into account any payment

advices(patent). Seebankstatementitem1(transaction001).

Use variant 1010 for account assignment.

No. Trans- Value NotetoPayee Amount D/C

action Date

1 001 Today Outgoing check - 500, 000 D

for document (do not forget

number…….. minussign)

(document number

from 1-2)

2 070 Yester- Credit from check 9.700,- C

day deposit

3 051 Yester- Transfertocustomer 590.300,- C

day T-F00B00

Usethefollowingsessionnames: BABU##forbankpostingsandNEBU##

for subledger postings.

5. Youwanttomakefurtherchangestothebankstatement.

Displayanoverviewofthebankstatementsentered.

Select the statement and change the value date from <today> to

<yesterday>.

6. Postyourbankstatementbygeneratingthesessionsandrunningtheminthe

foreground. Firstpostthebankaccountingsessionandthenthesessionfor

the postings in the subledger.

7. Checkthecashposition. Isyourmanualmemorecordstilldisplayedinthe

ACBANK-IST grouping?

No.	Trans- action	Value Date	NotetoPayee	Amount	D/C
1	001	Today	Outgoing check for document number…….. (document number from 1-2)	- 500, 000 (do not forget minussign)	D
2	070	Yester- day	Credit from check deposit	9.700,-	C
3	051	Yester- day	Transfertocustomer T-F00B00	590.300,-	C

第 103 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Solution 8: Bank Statement: Manual Entry

Task:

Post the following transaction.

1. Post an incominginvoice of EUR500,000.

Vendor: T-F00B00

G/L Account : 400020

Invoice Date/Posting Date: 7 days ago

Payment Terms: ZB00

Input Tax: 10%

a) Solution for postingtheincoming invoice.

Choose SAP Easy Access: Accounting →Financial Accounting→

Accounts Payable→ Document Entry → Invoice - Company Code

AC##.

Enter your data.

Ifnecessary,leavethepaymenttermsunderPaymentatZB00.

Field Name or Data Type Values

Vendor T-F00B00

Invoice Date <-7 days>

Posting Date <-7 days>

Amount EUR 500,000

Input tax 1l (10%-Training)

Calculate Tax Set indicator

Payment Terms ZB00 (no cash

discount)

G/L Account 400020

Amount EUR 500,000

2. Pay this invoice with anoutgoing check.

Bank account: 113101

Invoice date/posting date: 6 days ago

Makeanoteofthedocumentno. (______________).

Continued on next page

Field Name or Data Type	Values
Vendor	T-F00B00
Invoice Date	<-7 days>
Posting Date	<-7 days>
Amount	EUR 500,000
Input tax	1l (10%-Training)
Calculate Tax	Set indicator
Payment Terms	ZB00 (no cash discount)
G/L Account	400020
Amount	EUR 500,000

第 104 页 / 共 213 页

Unit4: ManualBankStatement AC805

This clears the vendor account.

a) Solutionforpayingtheinvoicewithanoutgoingcheck.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsPayable→DocumentEntry→OutgoingPayment→Post

Enter your data.

Field Name or Data Type Values

Document Date <-6 days>

Posting Date <-6 days>

Bank Account 113101

Amount EUR 500,000

Value Date <-6 days>

Vendor T-F00B00

Whenyousavethedata,theopenitemiscreatedforthisvendor.

3. Post the following transaction.

Outgoing invoice EUR 590,300

Customer: T-F00B00

G/L Account : 800200

Invoice Date/Posting Date: 7 days ago

Payment Terms: ZB00

Continued on next page

Field Name or Data Type	Values
Document Date	<-6 days>
Posting Date	<-6 days>
Bank Account	113101
Amount	EUR 500,000
Value Date	<-6 days>
Vendor	T-F00B00

第 105 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Output tax: 10%

a) Post an outgoing invoice.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→DocumentEntry→Invoice.

Enter your data.

ChangethepaymenttermsonthePaymenttabpagetoZB00.

Field Name or Data Type Values

Customer T-F00B00

Invoice Date <-7 days>

Posting Date <-7 days>

Amount EUR 590,300

Output Tax 1O(10%-Training)

Calculate Tax Set indicator

Payment Terms ZB00 (no cash

discount)

G/L Account 800200

Amount EUR 590,300

4. Bank113100sendsyouthefollowingbankstatement:

External bank details:

Bank Number: 20050000

Bank Account: 111111## (## = group no.)

Bank Statement Number: 1

Bank Statement Date: Today

Beginning Balance: 0,-

Ending Balance: 100.000,-

Enter this statement. Do not post it yet. Take into account any payment

advices(patent). Seebankstatementitem1(transaction001).

Use variant 1010 for account assignment.

Continued on next page

Field Name or Data Type	Values
Customer	T-F00B00
Invoice Date	<-7 days>
Posting Date	<-7 days>
Amount	EUR 590,300
Output Tax	1O(10%-Training)
Calculate Tax	Set indicator
Payment Terms	ZB00 (no cash discount)
G/L Account	800200
Amount	EUR 590,300

第 106 页 / 共 213 页

Unit4: ManualBankStatement AC805

No. Trans- Value NotetoPayee Amount D/C

action Date

1 001 Today Outgoing check - 500, 000 D

for document (do not forget

number…….. minussign)

(document number

from 1-2)

2 070 Yester- Credit from check 9.700,- C

day deposit

3 051 Yester- Transfertocustomer 590.300,- C

day T-F00B00

Usethefollowingsessionnames: BABU##forbankpostingsandNEBU##

for subledger postings.

a) Enter a bank statement.

ChooseSAP EasyAccess→Accounting→Financial SupplyChain

Management→CashandLiquidityManagement→CashManagement

→Incomings→ManualBankStatement→Enter.

Enter your data.

Donotforgettheminussignforoutgoingchecks.

Fortheoutgoingcheck,youmustalsoenterthedocumentnumber;for

theincomingtransfer,enterthecustomermatchcode.

Field Name or Data Type Values

InternalBankDetermination Donotsetflag

ReadCashManagementAdvices Set indicator

Start Variant 1010 (Man. Bank

Statement)

Processing Type 1-asbatchinput

Bank Key 20050000

Bank Account 111111##

Currency EUR

Statement Number 1

Statement Date <today>

Beginning Balance 0

Ending Balance 100.000

Continued on next page

No.	Trans- action	Value Date	NotetoPayee	Amount	D/C
1	001	Today	Outgoing check for document number…….. (document number from 1-2)	- 500, 000 (do not forget minussign)	D
2	070	Yester- day	Credit from check deposit	9.700,-	C
3	051	Yester- day	Transfertocustomer T-F00B00	590.300,-	C

Field Name or Data Type	Values
InternalBankDetermination	Donotsetflag
ReadCashManagementAdvices	Set indicator
Start Variant	1010 (Man. Bank Statement)
Processing Type	1-asbatchinput
Bank Key	20050000
Bank Account	111111##
Currency	EUR
Statement Number	1
Statement Date	<today>
Beginning Balance	0
Ending Balance	100.000

第 107 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Field Name or Data Type Values

Posting Date <today>

Planning Type BV

Bank Posting Session BABU##

Subledger Session NEBU##

Thefollowingtableshowsthreeitemsfromthebankstatement.

No. Trans- Value Amount Doc. no. Customer

action Date

1 001 today 500.000- Doc. no. of -

outgoingcheck

2 070 Yester- 9.700 -

day

3 051 Yester- 590.300 T-F00B00

day

Informationforitem1: Ifyouhaveselectedamanualmemorecord,

justaddthetransactionnumber(001)andenterthedocumentnumber

fromTask1(thesystemproposestheremainingdata). Save.

5. Youwanttomakefurtherchangestothebankstatement.

Displayanoverviewofthebankstatementsentered.

Select the statement and change the value date from <today> to

<yesterday>.

a) Change the bank statement.

(as in the previous exercise)

Inthebankstatementoverview,positionyourcursoronthestatement,

double-click and chooseTransfer.

Choose Return.

Enter your changes. Save.

Continued on next page

Field Name or Data Type	Values
Posting Date	<today>
Planning Type	BV
Bank Posting Session	BABU##
Subledger Session	NEBU##

No.	Trans- action	Value Date	Amount	Doc. no.	Customer
1	001	today	500.000-	Doc. no. of outgoingcheck	-
2	070	Yester- day	9.700		-
3	051	Yester- day	590.300		T-F00B00

第 108 页 / 共 213 页

Unit4: ManualBankStatement AC805

6. Postyourbankstatementbygeneratingthesessionsandrunningtheminthe

foreground. Firstpostthebankaccountingsessionandthenthesessionfor

the postings in the subledger.

a) Post a bank statement.

(as in the previous exercise)

Inthebankstatementoverview,positionyourcursoronthestatement.

Double-clickandchooseTransfer. ChooseBankStatement→Post→

IndividualStatementtopostthestatementsorcreatethesessions.

To run the sessions, choose System → Services → Batch Input →

Sessions .

SelectasessionandchooseProcess→Processsession.

7. Checkthecashposition. Isyourmanualmemorecordstilldisplayedinthe

ACBANK-IST grouping?

a) Check the cash position.

(as in the previous exercise)

Ifyouselectthemanualmemorecordinthescreenforenteringbank

statements and post it with the bank statement, the manual memo

recordforthepatentfee(BV)isnotdisplayedintheACBANK-IST

grouping. (Themanualmemorecordhasbeenarchivedautomatically

andis located in archiving category A.)

100

第 109 页 / 共 213 页

AC805 Lesson: Application View: Manual Bank Statement

Lesson Summary

You should now be able to:

• Explainthetechnicalprocedureforenteringbankstatementsmanually.

• Enter bank statements manually.

• Carryoutandpostprocesspostings(batchinputsessions).

101

第 110 页 / 共 213 页

Unit4: ManualBankStatement AC805

Lesson: Customizing: Manual Bank Statement

Lesson Overview

ThislooksatCustomizingforthemanualbankstatement.

Lesson Objectives

After completingthislesson, you will beable to:

• Make the customizing settings necessary for manually entering bank

statementsandtheentryandupdateoftherelatedtransactions.

• Define bank statement transactionsfor standard postings, and define the

relevant postingandaccount determinationrules

• Configureaccountsymbolsandallocateaccountnumbers

Business Example

Havingdecidedtousemanualbankstatemententry,youwillnowlearnhowto

usetheCustomizingsettingsrequiredtoregulatepostingsaccordingly.

Figure 49: Posting Rules and Transactions

Thefirststepistodefinepostingrules(internaltransactions). Thepostingrules

representpostingtransactionstypicalofthebankstatement.

Assigningapostingruletoatransactionmakesitpossibletousethetransactionin

thebankstatement. Youcandefinethetransactionnameasyouwish. Youmust

specify thetransaction referenceinthe Transactionfieldinthebankstatement

detail screen. You can use the standard list of business transaction codes for

German banks as a guide.

102

第 111 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

Accountdeterminationiseffectedusingthepostingrules. Thesystemusesthe

internaltransactiontodeterminetheinformationnecessaryforposting(posting

keys, accounts, document type, and so on).

Youcanuseaccountmodificationstohavepostingssenttoaccountsotherthanthe

standard account assignment.

Theinterpretationalgorithmdetermineswhichfieldsareevaluatedfortheclearing

transaction or document determination.

Figure 50: Posting Details

The internal transactions are used to find the posting rules and necessary

information(postingkeys, accounts, andso on).

Thesystemusesthepostingareatodeterminewhetheritshouldposttheitemsto

the general ledger (1) or subledger (2).

The posting type controls the data update.

Theaccountsaresetwiththeiraccountsymbols. TheAccountSymbolsareused

todeterminewhichaccountnumbeshould beused.

Advantage: Nonewtableentriesarerequiredforpostingsofthesametypemade

to different banks.

Apostingkeyoraccountisstillfreeinpostingarea2(subledgeraccounting). The

datarequiredherefor theclearingposting istaken from the check information

(drawer, document number, and so on).

Bank statement items that have been selected for clearing can now be posted

on-account. Thiscanbeanadvantageifthecustomerfor theoriginal clearing

can beidentified asthepaymentcan be postedto the customer ledger for later

103

第 112 页 / 共 213 页

Unit4: ManualBankStatement AC805

clearance. Inaddition,bankclearingaccountscanbeaccessedwithinthesystem

for the purpose of making the account posting. The same applies to clearing

postings in the general ledger.

Figure 51: Determining Accountsfrom House BankData

Account Determination Rules

1. TheaccountsymboldeterminestheG/Laccounttowhichpostingsaremade.

2. TheG/LaccountisdeterminedusingtheG/Laccountnumberassignedtoan

account ID (full masking).

3. Partiallymaskedentriesreferencetheclearingaccountthatbelongstothe

G/L account.

4. The system uses the entry in the Currency field to send transactions in a

foreigncurrencytotherequiredforeigncurrencyaccount.

5. EntriesintheAccountModificationcolumnarefreelydefinable. Theyare

required by the customer exit for company-specific posting transactions

(forexample: classificationofaccounttransactionsbypersonresponsible,

incoming/outgoingpayments,selectionbydeliverynotenumber).

104

第 113 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

Figure 52: Posting Rule and Account Determination

Thisgraphicshowsexamplesofsomeentriesinthecustomizingtable.

105

第 114 页 / 共 213 页

Unit4: ManualBankStatement AC805

106

第 115 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

Exercise 9: Customizing: Manual Bank

Statement

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Makeallcustomizingsettingsuptoaccountdetermination.

Business Example

Youwillenterallthecustomizingsettingsforasamplebankstatement.

Task:

Make the following Customizing settings.

1. Define a key forposting rule ##05(## =your groupnumber) for check

debit memo GR##.

2. Assign posting rule ##05 to external transaction ##05 – Vendor Check

Deposit GR##.

3. Defineaccountdeterminationforpostingrule##05.

→ First, create account symbols:

##-BANK Bank account GR##

##-OUTCHECK. Outgoing check GR##

Save your entries.

ThenassignaccountsintheINTchartofaccountstotheaccountsymbols.

Use the facilitiesfor partial and full masking.

##-BANK + + ++++++++++

##-OUTCHECK. + + +++++++++1

Save your entries.

Now you can define posting specifications for posting rule ##05 (only

necessaryforposting area1- bank accounting).

Youdonotneedtospecifyapostingkeyinthedebitposting(OUTCHECK).

In the credit posting (##-BANK), specify posting key 50. This is a G/L

accountdocumentwhichshouldclearthebalanceintheG/Laccount.

Continued on next page

107

##-BANK	Bank account GR##
##-OUTCHECK.	Outgoing check GR##

##-BANK	+	+	++++++++++
##-OUTCHECK.	+	+	+++++++++1

第 116 页 / 共 213 页

Unit4: ManualBankStatement AC805

4. Nowpost anincoming invoicefor22,000EUR.

Vendor: T-F00B00

G/L Account : 400020

Invoice Date/Document Date: 7 days ago

Payment Terms: ZB00

Input Tax: 10%

5. Pay this invoice by outgoing check:

Bank Account: 11##01

Posting/Document/ValueDate: 6 days ago

Makeanoteofthedocumentno. (______________).

6. EnteramanualstatementforbankGR##CURR.

Ifyouhavealreadyenteredastatementforyourbank,choosetheOverview

buttonandallowthesystemtoproposeaNewStatement. Thebankdetails,

newstatementnumber,statementdate,andbeginningbalanceareproposed

by the system.

You should not have entered any bank statements yet, however. This is,

therefore, the first statement.

ChangethespecificationstoInternalBankDetermination.

Entertheremainingdata,suchasthenewfinishingbalance,thepostingdate

(today), and, if required, the session name.

Enter the transaction you just created.

The vendor cashes the check: minus sign

7. Postyourbankstatementandrunthebatchinputsession.

8. DisplayvendoritemT-F00B00andgeneralledgeritem11##01. Havethe

items been cleared?

108

第 117 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

Solution 9: Customizing: Manual Bank

Statement

Task:

Make the following Customizing settings.

1. Define a key forposting rule ##05(## =your groupnumber) for check

debit memo GR##.

a) Solutionfordefiningakeyforpostingrule##05.

Choose SAP Reference IMG → Financial Accounting → Bank

Accounting → Business Transactions → Payment Transactions →

ManualBankStatement→DefinePostingKeysandPostingRulesfor

ManualBankStatement,chartofaccounts(INT)→CreateKeysfor

Posting Rules. Double-click this option.

Choose New Entries.

Nowenteryourdata(##05–“checkdebitmemoGR##”)andsaveit.

Posting Rule Text

##05 Check debit memo GR##

Choose Save.

Continued on next page

109

Posting Rule	Text
##05	Check debit memo GR##

第 118 页 / 共 213 页

Unit4: ManualBankStatement AC805

2. Assign posting rule ##05 to external transaction ##05 – Vendor Check

Deposit GR##.

a) Solutionforassigningthepostingruletoexternaltransaction##05.

Choose SAP Reference IMG → Financial Accounting → Bank

Accounting → Business Transactions → Payment Transactions →

ManualBankStatement→CreateandAssignBusinessTransactions.

Nowenteryour data(Transaction: ##05; +-: -; PostingRule: ##05;

Text: Vendor check deposit GR##).

Transac- +/- Posting Text

tion Rule

##05 - ##55 Vendor check deposit

GR##

Choose Save.

3. Defineaccountdeterminationforpostingrule##05.

→ First, create account symbols:

##-BANK Bank account GR##

##-OUTCHECK. Outgoing check GR##

Save your entries.

ThenassignaccountsintheINTchartofaccountstotheaccountsymbols.

Use thefacilitiesforpartial andfull masking.

##-BANK + + ++++++++++

##-OUTCHECK. + + +++++++++1

Save your entries.

Now you can define posting specifications for posting rule ##05 (only

necessary for posting area1 -bankaccounting).

Youdonotneedtospecifyapostingkeyinthedebitposting(OUTCHECK).

In the credit posting (##-BANK), specify posting key 50. This is a G/L

accountdocumentwhichshouldclearthebalanceintheG/Laccount.

Continued on next page

110

Transac- +/- Posting Text tion Rule
##05 - ##55 Vendor check deposit GR##

##-BANK	Bank account GR##
##-OUTCHECK.	Outgoing check GR##

##-BANK	+	+	++++++++++
##-OUTCHECK.	+	+	+++++++++1

第 119 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

a) Solution for defininga newpostingrule.

Choose SAP Reference IMG → Financial Accounting → Bank

Accounting → Business Transactions → Payment Transactions →

ManualBankStatement→DefinePostingKeysandPostingRulesfor

ManualBankStatement, chartofaccounts(INT).

SeveralstepshavetobecarriedoutinCustomizing.

Enter your data.

Create account symbols.

Choose New Entries.

Account Text

##-BANK Bank account GR##

##-OUTCHECK. Outgoing check GR##

Save your entries.

Assignaccountstoaccountsymbols(chartofaccounts: INT).Usethe

facilities for partial and full masking.

Choose New Entries.

AccountSymbol Account Currency G/LAccount

Modif.

##-BANK + + ++++++++++

##-OUTCHECK. + + +++++++++1

Save your entries.

Define posting rules.

Choose New Entries.

FieldNameorDataType Values

Posting Rule ##05

Posting Area 1 (bankaccounting)

DEBIT PostingKey Empty

Account Symbol ##-OUTCHECK.

CREDITPostingKey 50

Continued on next page

111

Account	Text
##-BANK ##-OUTCHECK.	Bank account GR## Outgoing check GR##

AccountSymbol Account Currency G/LAccount Modif.
##-BANK + + ++++++++++
##-OUTCHECK. + + +++++++++1

FieldNameorDataType	Values
Posting Rule	##05
Posting Area	1 (bankaccounting)
DEBIT PostingKey	Empty
Account Symbol	##-OUTCHECK.
CREDITPostingKey	50

第 120 页 / 共 213 页

Unit4: ManualBankStatement AC805

FieldNameorDataType Values

Account Symbol ##-BANK

Document type SA

Posting Type 4(clearG/LaccountDEBIT)

Save your entries.

4. Nowpost anincoming invoicefor22,000EUR.

Vendor: T-F00B00

G/L Account : 400020

Invoice Date/Document Date: 7 days ago

Payment Terms: ZB00

Input Tax: 10%

a) Solution for postingtheincoming invoice.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsPayable→DocumentEntry→Invoice.

Enter your data.

FieldNameorDataType Values

Vendor T-F00B00

Invoice/PostingDate <7 days ago>

Amount 22.000

Currency EUR

Calculate Tax X

Tax Code 1l

Payment Terms (Payment tab ZB00

page)

G/L Account 400020

Amount *

Tax Code 1l

Save your entries.

5. Pay this invoice by outgoing check:

Bank Account: 11##01

Continued on next page

112

FieldNameorDataType	Values
Account Symbol	##-BANK
Document type	SA
Posting Type	4(clearG/LaccountDEBIT)

FieldNameorDataType	Values
Vendor	T-F00B00
Invoice/PostingDate	<7 days ago>
Amount	22.000
Currency	EUR
Calculate Tax	X
Tax Code	1l
Payment Terms (Payment tab page)	ZB00
G/L Account	400020
Amount	*
Tax Code	1l

第 121 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

Posting/Document/ValueDate: 6 days ago

Makeanoteofthedocumentno. (______________).

a) Solutionforpayingthisinvoicewithanoutgoingcheck.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsPayable→DocumentEntry→OutgoingPayment→Post

Enter your data.

FieldNameorDataType Values

DocumentDate/PostingDate <6 days ago>

Company Code AC##

Bank Data

Account 11##01

Amount 22.000

Value Date <6 days ago>

Open ItemSelection

Account T-F00B00

Account Type K

Choose Process Open Items.

Activatetheopenitemof22,000EUR(ifithasnotyetbeenactivated)

by double-clicking the item.

Choose Post.

Makeanoteofthedocumentnumber(_______).

6. EnteramanualstatementforbankGR##CURR.

Ifyouhavealreadyenteredastatementforyourbank,choosetheOverview

buttonandallowthesystemtoproposeaNewStatement. Thebankdetails,

newstatementnumber,statementdate,andbeginningbalanceareproposed

by the system.

You should not have entered any bank statements yet, however. This is,

therefore, the first statement.

ChangethespecificationstoInternalBankDetermination.

Entertheremainingdata,suchasthenewfinishingbalance,thepostingdate

(today), and, if required, the session name.

Enter the transaction you just created.

Continued on next page

113

	FieldNameorDataType	Values
DocumentDate/PostingDate		<6 days ago>
Company Code		AC##
Bank Data
Account		11##01
Amount		22.000
Value Date		<6 days ago>
Open ItemSelection
Account		T-F00B00
Account Type		K

第 122 页 / 共 213 页

Unit4: ManualBankStatement AC805

The vendor cashes the check: minus sign

a) Solutionforenteringthemanualbankstatement.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

Banks→Incomings→BankStatement→EnterManually.

Enteryourdata. Makesurethatyouenterthebankstatementforyour

bank.

ChangethespecificationstoInternalBankDetermination.

Choose Settings → Specifications.

FieldNameorDataType Values

InternalBankDetermination X

Start Variant 1010 (manual bank

statementisstandard)

Processing Type 1 (batch input)

Choose Enter.

FieldNameorDataType Values

Company Code AC##

House Bank GR##

Account ID CURR

Statement Number 1

Statement Date <today>

Beginning Balance 0

Ending Balance 22.000 -

Posting Date <today>

Bank Posting Session Bank-##

Subledger Session Empty

Choose Enter.

Continued on next page

114

FieldNameorDataType	Values
InternalBankDetermination	X
Start Variant	1010 (manual bank statementisstandard)
Processing Type	1 (batch input)

FieldNameorDataType	Values
Company Code	AC##
House Bank	GR##
Account ID	CURR
Statement Number	1
Statement Date	<today>

Beginning Balance	0
Ending Balance	22.000 -
Posting Date	<today>

Bank Posting Session	Bank-##
Subledger Session	Empty

第 123 页 / 共 213 页

AC805 Lesson: Customizing: Manual Bank Statement

FieldNameorDataType Values

Transaction ##05

Value Date <yesterday>

Amount 22.000 -

Document Number <number of your

outgoing check>

Save your entries.

7. Postyourbankstatementandrunthebatchinputsession.

a) Solutionforpostingthemanualbankstatement.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

Banks→Incomings→BankStatement→EnterManually.

Choose Overview.

Select the right bank andbank statement.

Choose Transfer.

Post the statement (click thedisk icon).

Run the session.

ChooseSystem→Services→BatchInput→Sessions.

SelecttheBANK-##sessionandrunit(press“Process”).

Process in foreground.

8. DisplayvendoritemT-F00B00andgeneralledgeritem11##01. Havethe

items been cleared?

a) Solution for displaying vendor item T-F00B00 and general ledger

item 11##01.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsPayable→Account→Display/ChangeLineItems.

Vendor: T-F00B00

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

GeneralLedger→Account→Display/ChangeLineItems.

G/L Account: 11##01

115

FieldNameorDataType	Values
Transaction	##05
Value Date	<yesterday>
Amount	22.000 -
Document Number	<number of your outgoing check>

第 124 页 / 共 213 页

Unit4: ManualBankStatement AC805

Lesson Summary

You should now be able to:

• Make the customizing settings necessary for manually entering bank

statementsandtheentryandupdateoftherelatedtransactions.

• Define bank statement transactionsfor standard postings, and define the

relevant postingandaccount determinationrules

• Configureaccountsymbolsandallocateaccountnumbers

116

第 125 页 / 共 213 页

AC805 Unit Summary

Unit Summary

You should now be able to:

• Explainthetechnicalprocedureforenteringbankstatementsmanually.

• Enter bank statements manually.

• Carryoutandpostprocesspostings(batchinputsessions).

• Make the customizing settings necessary for manually entering bank

statementsandtheentryandupdateoftherelatedtransactions.

• Define bank statement transactions for standard postings, and define the

relevant postingandaccountdeterminationrules

• Configureaccountsymbolsandallocateaccountnumbers

117

第 126 页 / 共 213 页

UnitSummary AC805

118

第 127 页 / 共 213 页

Unit 5

Bank Statement – Electronic Entry

Unit Overview

Thischapterlooksattheprocedureforprocessingbankstatementselectronically.

Unit Objectives

After completing thisunit, you will beableto:

• Import bank statement data electronically.

• Explainthevariouspostingoptionsandtherelatedpostprocessing.

• Handlethetransactionsforclearingopenitems(documentdetermination).

• Seetheconnectionbetweenexternaltransactions(businesstransactioncodes

-BTC)andinternaltransactions(postingandaccountdeterminationrules),

and explain the related posting processes

• Explainhowthenotetopayeeisinterpreted, andwhattheoptionsarefor

clearing open items

Unit Contents

Lesson: Application View: Electronic Bank Statement Entry .............120

Exercise 10: Electronic Bank Statement................................129

Lesson: Customizing: Electronic Bank Statement Entry ..................136

119

第 128 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Lesson: Application View: Electronic Bank Statement

Entry

Lesson Overview

Thislessonlooksatthefunctionsforenteringbankstatementselectronically.

Lesson Objectives

After completingthislesson, you will beable to:

• Import bank statement data electronically.

• Explainthevariouspostingoptionsandtherelatedpostprocessing.

• Handlethetransactionsforclearingopenitems(documentdetermination).

Business Example

Youusebankingsoftwareeverymorningtoaccessbankstatementselectronically

from oneor more of your housebanks. Nowyou want to familiarizeyourself

with the options and procedure for importing these statements into SAP Cash

Managementelectronically. Howdoesthesystemidentifytheopenitems? How

can you postprocess the bank statements?

ElectronicbankstatementprocessinginSAPCashManagementisbasedonthe

MultiCashformat. Otherformats,suchasSWIFTMT940orBAI,aresupported,

but you are advised to use MultiCash.

Figure 53: Electronic Bank Statement – Features (1)

120