AC205_EN_Col92_FV_Part_A4 (第7页) | ERP软件技术分享

第 270 页 / 共 417 页

Unit7: ClosingCockpit AC205

SelectyourClosingTestsubfolder. Right-clickandchooseAddTask

.... Enter the following information:

Description Maintain Financial Statement

Version

Responsible AC205-##

Processing AC205-##

TypeofTask: SelectTransactionandenterOB58.

AssignmenttoClosingTypes: ChooseUseinMonth-EndClosing.

Continue (Enter)

Save your template.

Add a second task to your Closing Test subfolder: Select your

Closing Test subfolder. Right-clickand choose Add Task .... Enter

the following information:

Description ExecuteFinancialStatement

Responsible AC205-##

Processing AC205-##

TypeofTask: SelectProgramandenterRFBILA00.

EnterVariant: GR##(##=yourgroupnumber).

Under Assignment to Closing Types, choose Use in Month-End

Closing.

Choose Continue.

Save your template.

Nowdouble-clicktheDependenciestabatthebottomofthescreen.

In the Organizational Structure area, double-click your Execute

Financial Statement task.

PositionthecursorontheMaintainFinancialStatementVersiontask

andusedraganddroptomovethetaskbelowtheExecuteFinancial

Statementtask intheDependenciesbox.

Save your template.

Continued on next page

250

Description	Maintain Financial Statement Version
Responsible	AC205-##
Processing	AC205-##

Description	ExecuteFinancialStatement
Responsible	AC205-##
Processing	AC205-##

第 271 页 / 共 417 页

AC205 Lesson: Closing Cockpit

Task 5: Second Task List: Creation and Execution

1. Now create a task list for your template:

Key Date: Today's date

Description: Task List 2 (GR##)

Closing Type: M (Month-End Closing)

Fiscal Year: Current fiscal year

Posting Period: Current period

Status: Released

Transfer and Close

Save your task list.

a) Choose Template/TaskList →CreateTaskList. Enter thefollowing

information:

Key Date: Today's date

Description: Task List 2 (GR##)

ClosingType: M (Month-End Closing)

Fiscal Year: Current fiscal year

Posting Period: Current period

Status: Select Released.

Transfer and Close

Save your task list.

2. Now call the Closing Cockpit (transaction CLOCO). (Menu: SAP Easy

Access → Accounting → Financial Accounting → General Ledger →

PeriodicProcessing→Closing→CLOCOClosingCockpit)

ChooseChange. Callupyourtasklist: Menupath: Template/TaskList→

Other Template/Task List ...

Select yoursecond tasklist(statusReleased):

Expand template G##TEMPL and double-click the second task list for

today. Ontheleft, expandtheorganizational structureuntilyoufindyour

ClosingTestsubfolder. Double-clickthefolder. Thetwotasksinthisfolder

are listed on the top right.

Switch to the monitor display.

Continued on next page

251

第 272 页 / 共 417 页

Unit7: ClosingCockpit AC205

Intheorganizationalstructurearea,double-clickyourClosingTestsubfolder

againsothatitisdisplayedinthemonitorasafolder. Next,chooseZoomIn

severaltimesinordertodisplaythedependencymoreclearlyinthemonitor.

Switch back to the list display.

Nowselectyoursecondtask(ExecuteFinancialStatement)andchoose

Schedule Selected Tasks.

Thesysteminformsyouthatthetaskhasbeenscheduledsuccessfully.

Waituntilthestatusmessage(Processingisactive)andtheiconforthejob

displayhavebeensetandthenchooseManualUpdate.

ThestatusofthetaskshouldchangetoStop(Taskwascanceled).

Now click the icon for displaying jobs.

Oneofthemessagesis“Predecessor'MaintainFinancialStatementVersion'

tothetask'ExecuteFinancialStatement'hasstatus'TaskExecuteFinancial

Statement cancelled'”.

Choose the green arrow to go back.

Nowselectyourfirsttask,MaintainFinancialStatementVersion.

Right-click and choose Execute Transaction. Scroll down until you

find your financial statement version FS## (## = your group number).

Double-click your version.

Choose Fin. statement items.

Expandthestructureuntilyoufinditem3061000WagesandSalaries. In

thelower-levelitem3061090Otherwageandsalarycosts,theassignment

of account 433000 is missing.

Thisistheaccounttowhichyoupostedinthefirstvendorinvoiceandyou

will need it later for variouscockpit tasks. Add thisaccount to thisitem.

Remember to set the debit/credit indicator.

Continue (Enter)

Saveyour version. Thefollowingmessageappears: “Financial statement

version FS## saved”.

Gobacktoyourtasklist(choosethegreenarrowthreetimes).

Changethestatusofthetask: SelectyourMaintainFinancialStatement

Version task, right-click and choose Change Stat. Manually then

Processingcompletedwithouterrors. Thefollowingmessageappears: Do

youalsowanttochangethestatusofthedependentobjects? ChooseNo.

Thestatusof thetaskisnowendedwithout errors. Nowdouble-clickthe

Maintain Financial Statement Versiontask.

Continued on next page

252

第 273 页 / 共 417 页

AC205 Lesson: Closing Cockpit

Inthedetailinformation,displaythechangedocument(withthenewstatus)

for this task.

Choose Change Docs.

Transfer and Close

Nowselectyoursecondtask,ExecuteFinancialStatement. ChooseSchedule

Selected Tasks.

The systemdisplaysthefollowing message ina separate window: “Task

ExecuteFinancialStatementscheduledsuccessfully”. Closethiswindow.

Waituntilthestatusmessage(Processingisactive)andtheiconforthejob

displayhavebeensetandthenchooseManualUpdate.

Thestatusshouldchangetoendedwithouterrors.

Displaythejoblog(oneofthemessagesis“PredecessorMaintainFinancial

StatementVersionoftaskExecuteFinancialStatementhasstatusTaskended

withouterrors. TaskExecuteFinancialStatementstarted)”.

Alsodisplaythespooloutputforyourfinancialstatement.

Youcanfindmore information, suchasthestart andendtimes, duration,

andselectioncriteria, intheDetail Informationarea. Nowset the status

ofyoursecondtasklisttoCompleted(→Edit→BasicData... Setstatus

to Completed).

Transfer and Close (Enter)

Save the task list.

The following message appears: Task list XXXXXXXXXX on date

XX.XX.XXXX saved successfully.

ChoosethegreenarrowtoreturntotheSAPEasyAccessmenu.

a) CalluptheClosingCockpit(transactionCLOCO)(SAPEasyAccess

→Accounting→FinancialAccounting→GeneralLedger→Periodic

Processing→Closing→CLOCO-ClosingCockpit). ChooseChange.

Call up your task list: Menu path Template/Task List→ Other

Template/Task List ....

Selectyoursecond tasklist(statusReleased):

ExpandtemplateG##TEMPLanddouble-clickthesecondtasklistfor

today. Ontheleft, expandtheorganizationalstructureuntilyoufind

yourClosingTestsubfolder. Double-clickthefolder. Thetwotasksin

this folder are listed on the top right.

Switch to the monitor display.

Continued on next page

253

第 274 页 / 共 417 页

Unit7: ClosingCockpit AC205

Intheorganizational structurearea, double-clickyourClosingTest

subfolderagainsothatitisdisplayedinthemonitorasafolder.

Next,chooseZoomInseveraltimesinordertodisplaythedependency

more clearly in the monitor.

Switch back to the list display.

Now select your second task (Execute Financial Statement) and

choose Schedule Selected Tasks.

Thesysteminformsyouthatthetaskhasbeenscheduledsuccessfully.

Waituntilthestatusmessage(Processingisactive)andtheiconforthe

jobdisplayhavebeensetandthenchooseManualUpdate.

ThestatusofthetaskshouldchangetoStop(Taskwascanceled).

Nowclick theicon for displaying jobs.

Oneof the messages isPredecessor'Maintain Financial Statement

Version' to the task 'Execute Financial Statement' has status 'Task

Execute Financial Statement cancelled'.

Choose the green arrow to go back.

Nowselectyourfirsttask,MaintainFinancialStatementVersion.

Right-clickandchooseExecuteTransaction. Scrolldownuntilyou

findyourfinancialstatementversionFS##(##=yourgroupnumber).

Double-click your version.

Choose Fin. statement items.

Expandthestructureuntilyoufinditem3061000Wagesandsalaries.

Inthelower-level item3061090 Other wage and salary costs, the

assignmentof account433000ismissing.

Thisistheaccounttowhichyoupostedinthefirstvendorinvoiceand

youwillneeditlaterforvariouscockpittasks.

Add this account to this item. Remember to set the debit/credit

indicator.

Continue (Enter).

Save your version. The following message appears: Financial

statement version FS## saved.

Gobacktoyourtasklist(choosethegreenarrowthreetimes).

Change the status of the task:

Continued on next page

254

第 275 页 / 共 417 页

AC205 Lesson: Closing Cockpit

SelectyourMaintainFinancialStatementVersiontask,right-click

and choose Change Stat. Manually then Processing completed

without errors.

Thefollowingmessageappears: Doyoualsowanttochangethestatus

of the dependent objects? Choose No.

Thestatusofthetaskisnowendedwithouterrors.

Nowdouble-clicktheMaintainFinancialStatementVersiontask.

Inthedetailinformation,displaythechangedocument(withthenew

status) for this task.

Choose Change Docs.

Transfer and Close.

Nowselectyoursecondtask,ExecuteFinancialStatement.

Choose Schedule Selected Tasks.

Thesystemdisplaysthefollowingmessageinaseparatewindow: Task

ExecuteFinancialStatementscheduledsuccessfully.

Close this window.

Waituntilthestatusmessage(Processingisactive)andtheiconforthe

jobdisplayhavebeensetandthenchooseManualUpdate.

Thestatusshouldchangetoendedwithouterrors.

Display the job log (one of the messages is Predecessor Maintain

FinancialStatementVersionoftaskExecuteFinancialStatementhas

statusTaskendedwithouterrors. TaskExecuteFinancial Statement

started). Alsodisplaythespooloutputforyourfinancialstatement.

You can find more information, such as the start and end times,

duration,andselectioncriteria,intheDetailInformationarea.

NowsetthestatusofyoursecondtasklisttoCompleted(→Edit→

BasicData... Set status to Completed).

Transfer and Close (Enter).

Save the task list.

The following message appears: Task list XXXXXXXXXX on date

XX.XX.XXXX saved successfully.

ChoosethegreenarrowtoreturntotheSAPEasyAccessmenu.

255

第 276 页 / 共 417 页

Unit7: ClosingCockpit AC205

Lesson Summary

You should now be able to:

• Create templates

• Create task lists

• Execute tasks in a task list

• Use the Cockpit Monitor to check tasks

Related Information

SCMAPROGRAMS:ContainsallthereportsconnectedtotheClosingCockpit

SCMATRANSACT:ContainsalltheSAPtransactionsregisteredfortheClosing

Cockpit

Notes for component: CA-GTF-SCM:

• 325118: Link customer-specific reports

• 551743: Connection of any reports

Authorizations:

B_SMAN_WPL: Display/change authorization for transactions

CLOCOC/CLOCO: ACTVT (Activity)

• 01 – Create or generate

• 02 – Change

• 03 – Display

• 06 – Delete

• 16 – Execute

• A3 – Change status

B_SMAN_SEQ:Flowdefinitions: ACTVT (Activity)

• 01 – Create or generate

• 02 – Change

• 03 – Display

256

第 277 页 / 共 417 页

AC205 Unit Summary

Unit Summary

You should now be able to:

• Create templates

• Create task lists

• Execute tasks in a task list

• Use the Cockpit Monitor to check tasks

257

第 278 页 / 共 417 页

UnitSummary AC205

258

第 279 页 / 共 417 页

第 280 页 / 共 417 页

第 281 页 / 共 417 页

Unit 8

Intercompany Reconciliation

Unit Overview

Lesson Introduceto Intercompany Reconciliation

Unit Objectives

After completing thisunit, you will beableto:

• describethefunctionalityofinter-companyreconciliation

Unit Contents

Lesson: Intercompany Reconciliation........................................260

Exercise 14: Inter-company Reconciliation.............................275

259

第 282 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Lesson: Intercompany Reconciliation

Lesson Overview

In this lesson you will learn about possibilities to simplify the inter-company

reconciliation

Lesson Objectives

After completingthislesson, you will beable to:

• describethefunctionalityofinter-companyreconciliation

Business Example

Yourcompanywouldliketocheckifthenewinter-companyreconciliationstool

can simplify the reconciliation process.

Figure 117: Inter-company Reconciliation

260

第 283 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure 118: Reconciliation Process

Thereconciliationprocessconsistsofthefollowingsteps:

1. Collect data from different companies

2. Store this data

3. Present reconciledandnon-reconciled data

4. Communicate differences

5. Post correction documents

261

第 284 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure 119: Intercompany Reconciliation: Functionality

Theprogramstoresthedataof itsreconciliationprocessinseveral tables. The

programoperatesontheopenitemsprovidedduringthepreviousdatacollection

phasefor agivenkey dateforeachcompany andpartner company. Therefore,

onlythedatawhichisup-to-dateisstoredinthetables.

Theuserinterfaceisgearedtowardquicklyidentifyingthebiggestdifferenceson

a company pair level and finding the documents that cause the differences. It

providesatotaldifferencepercompanypair. Fromthere,theusercandrilldown

to the document level.

Inordertominimizethedatavolumeuseareferencenumbertoassigndocuments

toabusinesstransaction. Ifthedocumentsforabusinesstransactiontotalzero,

thedocumentsarenotdisplayedbydefaultsincetheydonotseemtobecausing

differences. Theusercanconcentrateondocumentsthathavenotbeenassigned

toabusinesstransactionyetaswellasdocumentsalreadyassignedtoabusiness

transaction but causing a difference due to posting errors (wrong amount in

transactioncurrency, wrongtransactioncurrency, etc.).

Theprogramalsoprovidesfunctionsforassigningdocuments

262

第 285 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure120: ClosingProcessWithoutInter-companyReconciliation

The reconciliation of account balances and items between partner companies

frequentlycausecumbersomeandtime-consumingworkloadsduringperiod-end

closing.

Inpractice,inter-companyreconciliationconstitutesabrakingfactoronthewayto

expedient fiscal closing.

Becauseofdifferingdisclosuresinthegroupunits,thereporteddataforthefiscal

closingiseithernotsuitableforconsolidationpurposes,orelseleadtoexcessive

varianceswhichhavepartlytobepostedouttoitemsaffectingnetincome.

Forconsolidationthereislittletransparencyregardingthereasonsforvariances

and the reconciliation status.

Reconciliationisconductedonpaperorusinginadequatetools.

Therearenoclearguidelines(orif any, theyarenotadheredto) forsettlement

processing.

263

第 286 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure121: ClosingProcessWithInter-companyReconciliation

Intercompany-reconciliationsupportsyouinthereconciliationofopenitemsin

Generalledgerandinthesubledgers(normallyaccountsreceivableandpayable).

Inaddition,youcanexecutepostingsonaccountsforwhichthereisnoopenitem

management(e.g. expenseandrevenue). Forthispurposetherelevantpostings

are collected and analyzedin a central system.

ThepurposeofICRistoensurethatintercompanydocumentsfromaccounting

transactions within the corporate group correspond to one another. It contains

tools which check that documents have been correctly assigned to a business

transactionandwhichalsoenableyoutofindcorrespondingdocumentseasilyand

to make additional assignments. ICR operates on the level of companies and

partner companies (trading partners).

If the reconciliation process is successful this will ultimately lead to reduced

differences in corporate group consolidation

264

第 287 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Therearetwomaingroupswhowouldbenefitfromusingthissolution:

1. Firstly,individualcompanieswouldbenefitfrommatchingupdocuments,

because they need to ensure that their own documents from accounting

transactionscorrespondtothedocumentsofinternaltradingpartnerstoavoid

delaysanddisputeswhenpaymentsaresupposedtobeprocessed.

2. Theconsolidationparentcanthenmakeaglobalcheckoftheresultsforall

the companies.

Theprogramisdesignedtomaintainconstantcontrolandcanberunatany

time. Thismeansthatthedeadlinepressurewhichnormallyarisesduring

monthlyclosingandyearendclosingcanbeavoided.

Figure 122: Steps of Inter-company Reconciliation

The main steps are the following:

1. Document selection and data storage

2. Automatic assignment of documents

3. Manual reconciliation and communication

Data will first beselected from the sender systemsand thenstored centrallyin

the reconciliation system. Data records which fit together are automatically

assignedusingcustomizedcriteriasothatonlyitemswithvariancesremainfor

analysis The responsible persons of the group companies check the variances

interactively, assign documents manually and communicate variances to the

accountants involved with the help of the integrated communication support.

After this, corrections(as well asnew documents) areposted. Thesewill then

be included in the next data selection.

265

第 288 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure 123: Supported Business Processes

Thefollowingbusinessprocessearesupportedbytheintercompany-reconciliation:

Reconciliation of open items

Reconciliationofgeneralledgeraccounts(e.g. ICRevenues/Expenses)

Process 001 GL Open Items

Thisprocessisintendedforreconciliationofopenitems. Youshouldchoosethis

process if most of your inter-company receivables and payables are posted to

GL accounts.

Process003 Customer/Vendor Open Items

ThisprocessisintendedforreconciliationofA/RandA/Popenitems. Youshould

choosethisprocessifmostofyourinter-companyreceivablesandpayablesare

posted to customer and vendor accounts.

Process 002 Accounts

This process is intended for reconciliation of documents which are posted to

accountswhichdonothaveopenitemmanagement. Thisprocessismostlyused

for reconciliation of profit and lossaccounts

266

第 289 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure 124: Data Model of Inter-companyReconciliation

Besidesmandatory characteristicsandadditional document fields used for the

Intercompany-reconciliation;e.g. Company,PartnerCompany,relevantdocument

information etc., further characteristics, e.g Profit Center Group, Region,

Referencekeyandanyotherpermanentfieldscanbespecifiedincustomizingto

betakenintoaccount for thereconciliationprocess.

267

第 290 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure 125: Data Selection & Storage: Open Items

Process001: General Ledger Open Items

and

Process 003: A/R and A/P Open Items

Theprogramswillselecttherelevant datarecordsforthespecifiedcompanies.

Thefiscalyearandperiodwillbeusedtodeterminethekeydatefortheselection

of open items.

The programs will produce a protocol displaying some statistical information

about theprogram runaswell asmessagesfor any issuesthat came up during

the program run.

268

第 291 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure 126: Data Selection & Storage: G/L Accounts

Prozess 002: General Ledger Accounts

The programwill select the relevant data records for the specified companies.

Sincethisprogramisnotworkingwithopenitemsdeterminingtherelevantdata

recordsismuchmoredifficult. Therelevantdatarecordsareallintercompany

document lines which havebeen posted toaccountsto bereconciled sincethe

lastsuccessfuldataselection. Inordertofindthesedocumentlinesthestandard

logic requires that a special ledger is created in the sender systems for table

FBICRC002T(orFBICRCS002Tforreleases<ERP2004).

Thisledgershouldbesetupwithaledgerselectionwhichwillallowonlyrelevant

documentlinestobepostedintotheledger: i.e. documentlineswherethetrading

partnerisspecifiedandwhicharepostedtotheaccountswhichyouwouldliketo

reconcile;additionalrestrictionscanalsobeappliedaccordingtoyourneeds.

The program will then select the newlyposted lineitems from thisledger and

marktheselectedlineitemsastransferred(fieldRTYPEissetto4).

Incasesomeofthepreviouslytransferreditemshavetobetransferredagainyou

havetomarkthecheckboxReselectDataandspecifythepostingdateforwhich

the data is supposed to be retransferred.

The program will produce a protocol displaying some statistical information

about the program run as well as messagesfor any issues that came upduring

the program run. .

269

第 292 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure 127: Reconciliation Rules

Aftertherelevantdocumentshavebeentransferredtothereconciliationsystem,

they are analyzed by the program. An attempt is then made by means of

customer-definedrulestoassignthosedocumentsbelongingtothesamebusiness

process.

270

第 293 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure 128: Data Presentation: Flexible Layout

This is the IC main functionality and supports the user in the selection of

documents which have variances.

The tree shows the company on the first level and the partner on the second

level. The third level contains a link to the documents to be reconciled. The

second column shows the difference on the business relationship level in the

displaycurrencywhichtheusercanspecifyontheselectionscreen. ICRworks

ontransactioncurrencyamounts. Butinordertodisplayonetotalperbusiness

relationshipthetransactioncurrencyvaluesareconvertedintoadisplaycurrency

duringprogramexecution. Theusercanspecifythedisplaycurrencytobeused

on the selection screen.

Theuserwillthenclickononeofthedifferencestodisplaythedocumentsfora

business relationship.

The work area is divided into 3 areas. The unassigned documents posted by

the company of the selected business relationship are displayed in the left top

area. Theunassigned documentsposted bythepartner of theselectedbusiness

relationshiparedisplayedintherighttoparea. Documentswhichwereassigned

eitherautomaticallyormanuallyaredisplayedinthebottompartofthedisplay.

However,bydefault,documentgroupswithabalanceorzeroarenotdisplayed.

TheycanbeaddedtothedisplayusingfunctionWithoutDifferences. Thelayout

oftheindividualdisplayareascanbechangedaccordingtotheuser’srequirements

271

第 294 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Figure 129: Data Presentation: UserInterface Functions

Theusercanmanuallylookforassignabledocumentsandthenassignthem. The

assigned items will then beadded to thelower areaof thedisplay. He/shecan

also have possible assignmentssuggested. For this, therules areshown which

havebeenpreviouslycustomized. Afterarulehasbeenchosen, theunassigned

documentsareanalyzedandassignmentssuggested,ife.g. thedocumentcurrency

and amounts correspond with each other

Theusercanthenassignmanually. He/shecan,ofcourse,overruletheassignment

at any time.

Allselecteditemswillbeassignedtothesamedocumentgroupnumber.

272

第 295 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Figure 130: CommunicationSupport-MessageTemplates

FunctionCommunicationwillstartadialogwhichcanbeusedtosendtemplate

basedmessagestoaccountantsinthepartnercompany. Asafirststeptheuserhas

toselect atemplateandthelanguageofthemessage.

On the next screen the user is offered contact persons which the message is

supposed to be sent to. Per default the contact persons for the partner in the

selected business relationship are displayed. After confirming the selected

recipientstheuserwillbetakentotheSAPofficesendscreen. Theusercansend

themessagewithoutany additional actionsor display thedocument and editit

manuallyifnecessary. AllSAPofficefunctionsareavailableforthedocument.

After sending the message or canceling the dialog the user returns to the

reconciliation screen.

Note: If the messagewassentsuccessfullytheCommunicationStatus

ofthedocumentswhichthemessagewassentforisautomaticallysetto

Mail Sent.

FunctionSetStatusallowstheusertosetthestatusforadocument. The

standardstatusfieldsareProcessingStatusandCommunicationStatus.

Otherstatusfieldscanbeaddedthroughcustomizing.

273

第 296 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

274

第 297 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Exercise 14: Inter-company Reconciliation

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Inter-comapnyReconcilationpotingswiththehelpofDocuments

Business Example

TheICRProgramoffers,amongotherthings,theopportunitytoreconciliateopen

A/R and A/P items

Task 1:

DefineCustomerandVendorMasterDataasapreparationforthereconciliation

process.

1. CreatethecustomerCUST-##inCompanyCode1000. UseCUSTOMER##

inCompanyCode1000asreference. Enteraname,searchtermandaddress

of your own

IntheControlDatapartoftheGeneralDataenterAC##inthefieldTrading

Partner

Save your customer

CreatethevendorVEND-##inCompanyCodeAC##. UseAGENCY##in

CompanyCode1000asreference. Enteraname,searchtermandaddress

of your own

IntheControlDatapartoftheGeneralDataenter1000inthefieldTrading

Partner.

AllotherfieldsintheGeneralDataandCompanyCodepartscanbetaken

over.

Save your vendor

Task 2:

Preparatory Postings

1. Asafurtherpreparationforthereconciliationprocessyounowneedtopost

3 customer and 3 vendor invoices.

Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry →Invoicewiththefollowingdata

Continued on next page

275

第 298 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate Current date

Reference GR##-REF1

Amount 1000

Currency tax EURChoosecalculate

Tax Code A0

b) G/L line items

Fieldnameofdatetype Values

G/L acct: 800200

D/C: Credit

Amount indoc. Curr: 1000

Tax code: A0

Profit center: PRCTR##

2. Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry→Invoicewiththefollowingdata::

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: Noreference(leaveempty)

Amount: 2000

Currency: EURChoosecalculatetax

Tax code: A0

b) G/L line items:

FieldnameorDatatype Values

G/L acct: 800200

D/C: Credit

Continued on next page

276

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate	Current date
Reference	GR##-REF1
Amount	1000
Currency tax	EURChoosecalculate
Tax Code	A0

Fieldnameofdatetype	Values
G/L acct:	800200
D/C:	Credit
Amount indoc. Curr:	1000
Tax code:	A0
Profit center:	PRCTR##

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	Noreference(leaveempty)
Amount:	2000
Currency:	EURChoosecalculatetax
Tax code:	A0

FieldnameorDatatype	Values
G/L acct:	800200
D/C:	Credit

第 299 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Amount in doc. Curr 2000

Tax code A0

Profit center: PRCTR##

Choose the Register Details.

EnterGR##-RFSCHLinthefieldRef. key1(Businesspartnerreference

key)

3. Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry →Invoicewiththefollowingdata:

FieldnameorDataType Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: GR##-REF2

Amount: 3000

Currency: EURChoosecalculatetax

Tax code: A0

b) G/L line items

FieldnameorDatatype Values

G/L acct: 800200

D/C: Credit

Amount in doc. Curr 3000

Tax code: A0

Profit center: PRCTR##

4. EnteraVendorInvoice(FB60)inCompanyCodeAC##SAPEasyAccess

→Accounting→FinancialAccounting→AccountsPayable→Document

Entry →Invoice with the following data:

Continued on next page

277

Amount in doc. Curr	2000
Tax code	A0
Profit center:	PRCTR##

FieldnameorDataType	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	GR##-REF2
Amount:	3000
Currency:	EURChoosecalculatetax
Tax code:	A0

FieldnameorDatatype	Values
G/L acct:	800200
D/C:	Credit
Amount in doc. Curr	3000
Tax code:	A0
Profit center:	PRCTR##

第 300 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

FieldnameorDatatype Values

Vendor: VEND-##

InvoiceandPostingDate: Current date

Reference: GR##-REF1

Amount: 1000

Currency: EURChoosecalculatetax

Tax code: . V0

ChooseTreeon(DisplayTemplates). ForyouritemlinechooseZ_WITH

COST CENTER (with cost center).

b) G/L line items:

FieldnameorDatatype Values

G/L acct: 476500

D/C: Debit

Loc.curr.amount: 1000

Tax code: A0

Cost Center: T-A20A##(##=Groupno.)

5. EnteraVendorInvoice(FB60)inCompanyCodeAC##SAPEasyAccess

→Accounting→FinancialAccounting→AccountsPayable→Document

Entry → Invoice with the following data:

Enter the following data:

FieldnameorDatatype Value

Vendor: VEND-##

InvoiceandPostingDate: Current date

Reference: no reference

Amount: 2000

Currency: EUR

Tax code: V0

Choose“Treeon(DisplayTemplates)”. ForyouritemlinechooseZ_WITH

COST CENTER (with cost center).

Continued on next page

278

FieldnameorDatatype	Values
Vendor:	VEND-##
InvoiceandPostingDate:	Current date
Reference:	GR##-REF1
Amount:	1000
Currency:	EURChoosecalculatetax
Tax code: .	V0

FieldnameorDatatype	Values
G/L acct:	476500
D/C:	Debit
Loc.curr.amount:	1000
Tax code:	A0
Cost Center:	T-A20A##(##=Groupno.)

FieldnameorDatatype	Value
Vendor:	VEND-##
InvoiceandPostingDate:	Current date
Reference:	no reference
Amount:	2000
Currency:	EUR
Tax code:	V0

第 301 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

b) G/L line items:

FieldnameorDatatype Values

G/L acct: 476500

D/C: Debit

Loc.curr.amount: 2000

Tax code: A0

Cost Center: T-A20A##(##=Groupno.)

Choose the Register Details.

EnterGR##-RFSCHLinthefieldRef. key1(Businesspartnerreference

key).

6. EnteraVendorInvoice(FB60)inCompanyCodeAC##(SAPEasyAccess

→Accounting→FinancialAccounting→AccountsPayable→Document

Entry →Invoice with the following data:

FieldnameorDatatype Value

Vendor: VEND-##

InvoiceandPostingDate: Current date

Reference: GR##-REF2

Amount: 3000

Currency: USDChoosecalculatetax

Tax code: V0

b) G/L line items:

Fieldnameordatatype Value

G/L acct: 476500

D/C: Debit

Amount indoc. Curr: 3000

Tax code: A0

Cost Center: T-A20A##(##=Groupno.)

Continued on next page

279

FieldnameorDatatype	Values
G/L acct:	476500
D/C:	Debit
Loc.curr.amount:	2000
Tax code:	A0
Cost Center:	T-A20A##(##=Groupno.)

FieldnameorDatatype	Value
Vendor:	VEND-##
InvoiceandPostingDate:	Current date
Reference:	GR##-REF2
Amount:	3000
Currency:	USDChoosecalculatetax
Tax code:	V0

Fieldnameordatatype	Value
G/L acct:	476500
D/C:	Debit
Amount indoc. Curr:	3000
Tax code:	A0
Cost Center:	T-A20A##(##=Groupno.)

第 302 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Task 3:

3.ReconcileDocumentsManuallyfortheIntercompanyReconciliation

SAP Easy Access → Accounting → Financial Accounting → Accounts

Receivable→PeriodicProcessing→Closing→Check/Count→Cross-System

IntercompanyReconciliation→ReconcileDocumentsManually

Organizational Units: Enter thefollowing data:

FieldnameorDatatype Value

Company 1000

Trading Partner: AC##

Time Period: Enter the following data

FieldnameorDatatype Value

Fiscal Year: Current year

Posting Period: Current Period

Further Settings: Enter the following data:

FieldnameorDataType Value

Object group: 100 (Open items)

Execute.

Click on theicon Expand All Key in the system

TheCompany1000, theTradingPartner AC##andtheDifferenceAmountare

shown.

Doubleclick on thelinewiththedifferenceamount.

WhenyoudothisyouwillseetheunassigneddatarecordsforCompany1000

and Partner AC## on the right hand side..

IfyoupressontheButton below WithoutDifferences, youwillautomatically

see the assigned data records.

Changethelayout for theseassigneddatarecords. BringthefieldsDocument

NumberandReferenceNumberintothedisplay. Youseetherethattheprogram

hassucceededinassigningtherecordpairbymatchingthereferencenumberin

both documents.

ChangethelayoutabovefortheunassignedrecordsofbothCompany1000and

PartnerAC##. TakeoverthefieldReferencekey1intothelayout

Continued on next page

280

FieldnameorDatatype	Value
Company	1000
Trading Partner:	AC##

FieldnameorDatatype	Value
Fiscal Year:	Current year
Posting Period:	Current Period

FieldnameorDataType	Value
Object group:	100 (Open items)

第 303 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

The 2recordsshowingthesame Referencekey 1shouldnowbetakenover as

assigned by the system.

Press on the icon Suggest Assignments

Among others the fields XREF1, TSL, RTCUR (from Rule DOC1) will be

offered. Click on this.

YoureceivealistoftherecordpairwhichhavethesameReferencekey. Theyare

now offered for assignment.

MarkbothlinesinthelistandpressontheiconAssignItems.

Now press on the icon End Suggestions

Youcannow seethisnewassignment underneathinthelist of‚Assigned Data

Records’

Onlyoneunassignedrecordpairnowremainsabove. Bothdocumentshavethe

samereferencenumberandamountinthetransactioncurrency,butthetransaction

currency of both are NOT identical.

YoushouldnowsendacorrespondingMailtoyourcolleagueinthetradepartner

company.

Markbothrecords(CompanyandPartner)andchoose

Mail > Create Mail Using Template

Doubleclickonthetemplate004AR/APAssignableItems: WrongTransaction

Currency andalso marktheLanguageEEnglish

Choose Continue (Enter).

TheuserAC205-99isofferedasContactPerson. Chooseanddoubleclickonthis

line and mark theline below under Recipient.

Choose Continue (Enter).

IntheWindowSendDocumentreplacetheRecipientAC205-99withyourown

user name. Thenmarktheboxwith SendExpress.

Now send the document > Send

YouarenowreturnedtotheWindowIntercompanyreconciliation: Cus./venOpen

Items: Reconcile Documents.

ChooseReconciliation→Exit.YoushouldthenreceiveanExpressDocument

ClickonExecute andreadthedocumentwhichyouhavereceived

281

第 304 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

Solution 14: Inter-company Reconciliation

Task 1:

DefineCustomerandVendorMasterDataasapreparationforthereconciliation

process.

1. CreatethecustomerCUST-##inCompanyCode1000. UseCUSTOMER##

inCompanyCode1000asreference. Enteraname,searchtermandaddress

of your own

IntheControlDatapartoftheGeneralDataenterAC##inthefieldTrading

Partner

Save your customer

CreatethevendorVEND-##inCompanyCodeAC##. UseAGENCY##in

CompanyCode1000asreference. Enteraname, searchtermandaddress

of your own

IntheControlDatapartoftheGeneralDataenter1000inthefieldTrading

Partner.

AllotherfieldsintheGeneralDataandCompanyCodepartscanbetaken

over.

Save your vendor

a) –

Task 2:

Preparatory Postings

1. Asafurtherpreparationforthereconciliationprocessyounowneedtopost

3 customer and 3 vendor invoices.

Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry→Invoicewiththefollowingdata

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate Current date

Reference GR##-REF1

Continued on next page

282

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate	Current date
Reference	GR##-REF1

第 305 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

Amount 1000

Currency tax EURChoosecalculate

Tax Code A0

b) G/L line items

Fieldnameofdatetype Values

G/L acct: 800200

D/C: Credit

Amount indoc. Curr: 1000

Tax code: A0

Profit center: PRCTR##

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: GR##-REF1

Amount: 1000

Currency: EURChoosecalculatetax

Tax Code: A0

b) Choose Tree on (Display Templates) For your item line choose

ZPROFITCENTER.

Fieldnameofdatetype Values

G/L acct: 800200

D/C : Credit

Amountindoc. Curr: 1000

Tax code: A0

Profit center: PRCTR##

2. Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry→Invoicewiththefollowingdata::

Continued on next page

283

Amount	1000
Currency tax	EURChoosecalculate
Tax Code	A0

Fieldnameofdatetype	Values
G/L acct:	800200
D/C:	Credit
Amount indoc. Curr:	1000
Tax code:	A0
Profit center:	PRCTR##

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	GR##-REF1
Amount:	1000
Currency:	EURChoosecalculatetax
Tax Code:	A0

Fieldnameofdatetype	Values
G/L acct:	800200
D/C :	Credit
Amountindoc. Curr:	1000
Tax code:	A0
Profit center:	PRCTR##

第 306 页 / 共 417 页

Unit8: IntercompanyReconciliation AC205

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: Noreference(leaveempty)

Amount: 2000

Currency: EURChoosecalculatetax

Tax code: A0

b) G/L line items:

FieldnameorDatatype Values

G/L acct: 800200

D/C: Credit

Amount indoc. Curr 2000

Tax code A0

Profit center: PRCTR##

Choose the Register Details.

Continued on next page

284

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	Noreference(leaveempty)
Amount:	2000
Currency:	EURChoosecalculatetax
Tax code:	A0

FieldnameorDatatype	Values
G/L acct:	800200
D/C:	Credit
Amount indoc. Curr	2000
Tax code	A0
Profit center:	PRCTR##

第 307 页 / 共 417 页

AC205 Lesson: Intercompany Reconciliation

EnterGR##-RFSCHLinthefieldRef. key1(Businesspartnerreference

key)

FieldnameorDatatype Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: Noreference(leaveempty)

Amount: 2000

Currency: EURChoosecalculatetax

Tax code: A0

FieldnameorDatatype Values

G/L acct: 800200

D/C: Credit

Amount in doc. Curr 2000

Tax code A0

Profit center: PRCTR##

Choose the Register Details.

Enter GR##-RFSCHL in the field Ref. key 1 (Business partner

reference key)

3. Enter a Customer Invoice (FB70) in Company Code 1000 SAP Easy

Access→Accounting→FinancialAccounting→AccountsReceivable→

DocumentEntry →Invoicewiththefollowingdata:

FieldnameorDataType Values

Customer: CUST-##

InvoiceandPostingDate: Current date

Reference: GR##-REF2

Continued on next page

285

FieldnameorDatatype	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	Noreference(leaveempty)
Amount:	2000
Currency:	EURChoosecalculatetax
Tax code:	A0

FieldnameorDatatype	Values
G/L acct:	800200
D/C:	Credit
Amount in doc. Curr	2000
Tax code	A0
Profit center:	PRCTR##

FieldnameorDataType	Values
Customer:	CUST-##
InvoiceandPostingDate:	Current date
Reference:	GR##-REF2