AC660_EN_Col51_FV_Part_A4 (第5页) | ERP软件技术分享

第 151 页 / 共 429 页

AC660 Lesson: Validation and Postings

2) Block the task STD POST in the data monitor for the entire corporate

group G1.

a) Reversal:

Toenterareversalagainstanalreadyposteddocument,runtheSTD

POSTtaskfromthedatamonitorforconsunitAbychoosingUpdate

run.or, in the application menu go to:

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→DataCollection→Manualposting→Enter

UnderCopyfromenterthedocumentnumberoftheentryyouposted

beforehand, andselect theReverse flag.

Afterenteringaheadertextforthereversal,choosetheLineItemstab.

ReversethisdocumentbychoosingPost(orUpdate).

Finally,blockthetaskSTDPOSTfortheentiregroupbyplacingthe

cursoratthecrosssectionbetweenthetaskandconsolidationgroup

G1, and selecting Block.

143

第 152 页 / 共 429 页

Unit3: DataCollection AC660

Lesson Summary

You should now be able to:

• Explain the concept of validations

• Describe postings and document types

144

第 153 页 / 共 429 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Explain the data collection methods from both SAP systems and the

non-SAP systems

• Use financial data in consolidation

• Describe the features of the status monitor

• Customize data monitor

• Assign tasks in the data monitor

• Describe the settings for online dataentry

• Define data entry layouts

• DescribeofflinedataentrywithMicrosoftAccess/Excel

• Explain flexible upload

• Explain the concept of validations

• Describe postings and document types

145

第 154 页 / 共 429 页

UnitSummary AC660

146

第 155 页 / 共 429 页

AC660 Test Your Knowledge

Test Your Knowledge

1. Incaseofdatacollectionfromnon-SAPsystems,thereisMicrosoftAccess

dataentryusinganadditionalMicrosoftExcelinterface.

Fillintheblankstocompletethesentence.

2. The dataisrecordedusingvariousdatacollectionprocedures.

Fillintheblankstocompletethesentence.

3. Which of these isNOT true about tasks?

Choosethecorrectanswer(s).

□ A Tasks are user-defined

□ B Tasks can begrouped intotaskgroups

□ C Tasks can only be run in test mode

□ D Taskscanberunsuccessivelyuptothenextmilestone

4. A group-dependent task group must always be a partial number of the

tasknumber and must alwaysstart with the first taskof the

global task group.

Fillintheblankstocompletethesentence.

5. Whichtaskcanbeenteredonlyonceinthedatamonitortaskgroup?

Choosethecorrectanswer(s).

□ A Balance carry forward

□ B Manual posting

□ C Rollup to consolidation groups

□ D Data collection

6. Explainhowyoucancategorizethedetaillevelofthefinancialdatareported

by a unit.

7. WhatareUser-definabledataentrylayoutsusedfor?

147

第 156 页 / 共 429 页

TestYourKnowledge AC660

8. WhencanyouuseofflinedataentrywithMicrosoftAccess/Excel?

9. Whenisflexibleuploadused indatacollection?

10. Duringflexibleupload,youcannotselectdifferentupdatesessions.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

11. You can check the validation result step-by-step in the

Fillintheblankstocompletethesentence.

12. Youdonotrequirevalidationacrossconsolidationunitsordimensions.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

13. Thepostinglevelstandardizesthepostingsinthe

system.

Fillintheblankstocompletethesentence.

148

第 157 页 / 共 429 页

AC660 Test Your Knowledge

Answers

1. Incaseofdatacollectionfromnon-SAPsystems,thereisMicrosoftAccess

offlinedataentryusinganadditionalMicrosoftExcelinterface.

Answer: offline

2. Thetotalsdataisrecordedusingvariousdatacollectionprocedures.

Answer: totals

3. Which of these isNOT true about tasks?

Answer: C

Taskscanberuninbothtestand updatemodes.

4. Agroup-dependenttaskgroupmustalwaysbeapartialnumberoftheglobal

tasknumberandmustalwaysstartwiththefirsttaskoftheglobaltaskgroup.

Answer: global

5. Whichtaskcanbeenteredonlyonceinthedatamonitortaskgroup?

Answer: B

ThetaskManualpostingcanbeenteredseveral timesin thedatamonitor

task group.

6. Explainhowyoucancategorizethedetaillevelofthefinancialdatareported

by a unit.

Answer: Youcanusefinancialdatatypestocategorizethedetaillevelsof

thefinancialdatareportedbyaunitandtodetailthecategoryofdatathatit

reports. For example, youcanassignonefinancial datatypetounitsthat,

duetotheirsizeandimportance, enterhighlydetaileddataandadifferent

data type to units of lesser importance.

7. WhatareUser-definabledataentrylayoutsusedfor?

Answer: User-definabledataentrylayoutsareusedforentering reported

financialdataonlineintheSAPsystem. Theycanalsobeusedforentering

data offline.

149

第 158 页 / 共 429 页

TestYourKnowledge AC660

8. WhencanyouuseofflinedataentrywithMicrosoftAccess/Excel?

Answer: You can use offline data entry with Microsoft Access/Excel if

oneormoreconsolidationunitsdonotuseanyintegration,butadminister

their reported financial data on PC.

9. Whenisflexibleuploadused indatacollection?

Answer: Flexible upload can be used in data collection if one or more

consolidation units do not use integration, but administer their reported

financial data on PC.

10. Duringflexibleupload,youcannotselectdifferentupdatesessions.

Answer: False

Duringflexibleupload,youcanselectdifferentupdatesessions,inorderto

guaranteethetreatmentofdatastreams,whichalreadyexist.

11. Youcancheckthevalidationresultstep-by-stepinthevalidationlog.

Answer: validation log

12. Youdonotrequirevalidationacrossconsolidationunitsordimensions.

Answer: False

You need validation across consolidation units or dimensions to ensure

reconcileddatainlegalandmanagementconsolidation.

13. Thepostinglevelstandardizesthepostingsintheconsolidationsystem.

Answer: consolidation

150

第 159 页 / 共 429 页

Unit 4

Currency Translation

Unit Overview

TheunitcoverscurrencytranslationinSAPConsolidation. Youwilllearnhow

to configure the translation methods for each consolidation unit. You will be

abletocreatetasksforcurrencytranslationandsetupspecialfinancialstatement

itemsthatarerequiredwhentranslationdifferenceswithaneffectonnetincome

areposted. Finally,youwillbeabletomaintaintheexchangeratetableandthe

table of translation ratios.

Unit Objectives

After completing thisunit, you will beableto:

• Determine the need for currency translation

• Evaluate currency translation methods

• Use currency translation keys

• Determine exchange rates

• Examinethetranslationofindividualfinancialstatementvaluesintogroup

currency

• Managecurrencytranslationdifferencesthatdonotaffectnetincomeorthe

ones that affect net income

• Explain rounding differences

Unit Contents

Lesson: Currency Translation Methods and Keys..........................152

Lesson: Translation and Rounding Differences.............................159

Exercise 9: Currency Translation.........................................171

Exercise 10: Validation II..................................................193

151

第 160 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Lesson: Currency Translation Methods and Keys

Lesson Overview

Thislessonwillgiveyouanoverviewofcurrencytranslationmethods. Thislesson

will cover currency translation keys andcomparethevaluesof two translation

keys. Youwillalsolearnabouttherelationshipbetweenthecurrencytranslation

keys and the exchange rate indicator.

Lesson Objectives

After completingthislesson, you will beable to:

• Determine the need for currencytranslation

• Evaluate currency translation methods

• Use currency translation keys

• Determine exchange rates

Business Example

Thegroup,G1,planstointroducethecomponent,SAPConsolidationbytheend

of this year. Financial data reported by consolidation units is collected in the

Consolidationapplicationinlocalcurrency. Noticethatthelocal currency of a

consolidationunitisnotthesameasthegroupcurrency. Youneedtotranslatethis

dataintogroupcurrencybeforeyoucancreateconsolidatedfinancialstatements.

152

第 161 页 / 共 429 页

AC660 Lesson: Currency Translation Methods and Keys

Currency Translation Methods

Figure 44: Currency Translation

Thecurrencytranslationtaskenablesyoutotranslatefinancialdatareportedby

consolidationunitsintheirlocalcurrencyintothecurrencyoftheconsolidation

group.

Currency translation is based on translation methods. You can define several

methodstotranslatedatareported by yourconsolidationunits. Youcan assign

everyconsolidationunit by timeperiodandversion.

Thetypeofcurrencytranslationyou usedependsontherelationshipsbetween

yourcorporategroupanditsindividualconsolidationunits(functionalcurrency).

Youcandefineanyofthecommonly-usedtranslationmethods,suchastemporal

methodandcurrent-ratemethod,foryourchartofaccounts.

153

第 162 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Figure 45: CurrencyTranslation -Customizing Elements

Translationmethodsindicatetheexchangerateusedtotranslatecertainitems,and

howanysubsequenttranslationorroundingdifferencesaretobehandled.

Translationmethodsareassignedtoconsolidationunitsintheirmasterdata.

Item sets are rangesof items that are translated using thesametranslation key

and exchange rates.

Example:

Fixed assets: Translated using historical rates

Current assets: Translated using current rates

Incomestatement: Translated using averagerates

Ifyouwanttranslationdifferencestobepostedwithaneffectonnetincome,you

needtocreateselecteditemsforautomaticposting. Thesearetypicallyitemsfor

retainedearnings/netincomeintheincomestatementandbalancesheet.

You store exchange rates for exchange rate types in the exchange rate table.

Exchangeratetypesareacombinationofthetranslationversionandtheexchange

rate indicator.

Translation methodsaredimension-dependent.

154

第 163 页 / 共 429 页

AC660 Lesson: Currency Translation Methods and Keys

Currency Translation Keys

Figure 46: Currency Translation Keys

Different financial statement item sets are normally translated using different

exchangerates. Youusevariouscombinationsofthecurrencytranslationkeyand

theexchangerateindicatortodeterminetheseexchangerates.

The currency translation key determines the base currency for translation, the

table used to find the exchange rate, and the procedure to calculate the group

currency values.

Thecurrencytranslationkeysarefixedandcannotbechanged,excepttranslation

key 7.

155

第 164 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Figure 47: Comparison of Translation Keys 1 and 5

Thefollowingexampleshowsthedifferencesinthetranslationofvalueswiththe

translationkeys1(periodendrate)and5(monthlyrate).

Theperiodvaluesandperiodratesareprojectedasinitialvalues.

Translation key 1

Period 1: LC 100 * 2.0 = GC 200

This value is posted.

Period 6: LC 250 * 3.0 = GC 750

The total annual value is translated here.

200hasalreadybeenposted. OnlytherestofGC550isbookedinperiod6.

Translation key 5

LC 100 * 2.0 = GC 200

LC 150 * 3.0 = GC 450

Here,onlytherespectivemonthlyvalueiscalculatedandposted.

156

第 165 页 / 共 429 页

AC660 Lesson: Currency Translation Methods and Keys

Determination of Exchange Rates

Figure 48: Determination of Exchange Rates

The translation keys 1, 2, 5, 9, and A require the entry of an exchange rate

indicator.

Theexchangerateindicatorspecifieswhether thecurrentrate, averagerate, or

historical rate is used.

You assign the exchange rate indicator to the exchange rate type, time and

version-dependent. Theexchangeratetypeisthekey,underwhichyoudefinethe

exchange rate in the system.

Whenyouconfigurethecurrencytranslation,youhavedefinedtheconsolidation

version in the global parameters.

The consolidation version contains the currency translation version. All

Customizingsettingsarestoredunderthisspecialversion. Asaresult,youcanuse

these settingsin other consolidation versions.

Theexchangeratetablecontainsavalidityareaandthecurrencyexchangerate

for each exchange rate type.

157

第 166 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Lesson Summary

You should now be able to:

• Determine the need for currencytranslation

• Evaluate currency translation methods

• Use currency translation keys

• Determine exchange rates

158

第 167 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Lesson: Translation and Rounding Differences

Lesson Overview

Thislessonwillhelpyouunderstandthetranslationdifferencesextensively. You

willlearnhowtomanagecurrencytranslationdifferences. Youwillalsolearnhow

tocalculateroundingdifferences. Inaddition, youwill examinetheconceptof

customizing. Finally,youwilllearnhowtoexecutecurrencytranslation.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Examinethetranslationofindividualfinancialstatementvaluesintogroup

currency

• Managecurrencytranslationdifferencesthatdonotaffectnetincomeorthe

ones that affect net income

• Explain rounding differences

Business Example

The group G1 plans to introduce the SAP Consolidation by the end of this

year. Youneedtodefinetheselectedthatyourequireforanupdateofcurrency

translation differences that affect net income.

Translation into Group Currency

Figure 49: IndividualFS: Translation into Group Currency

159

第 168 页 / 共 429 页

Unit4: CurrencyTranslation AC660

The individual financial statement values are first translated using areference

exchangeratethatyouassignedtothetranslationmethodbyspecifyingareference

exchangerateindicator. Thisensuresthatalltheitemsfromthebalancesheetand

income statement are translated consistently.

Duringcurrencytranslation,ifyouwanttotranslatecertainitemsusingparticular

exchangerates,suchastheincomestatementusinganaverageexchangerate,it

willresult intranslationdifferencesbetweenthetranslationusingthereference

exchangerateandthatusingtheaverageexchangerate.

Referenceexchangerateind. “*”: Thisentrymeansthatthevaluesthatalready

exist in group currency areusedto determine the translation differences. Asa

rule, groupcurrencyvaluesalready exist ifyouusetheautomaticdatatransfer

for real-timeupdates, periodicalextracts, or rollups.

Translation Differences

Figure50: TreatmentofDifferencesNotAffectingNetIncome

WhentheFSitemsoftheannualstatementofaccountsarenotcalculatedwitha

standardexchangerate,currencytranslationdifferencesoccur. Thesedifferences

canbepostednotaffectingnetincomeoraffectingnetincome.

Not affecting net income:

Both balance sheet and income statementdifferences that arise from currency

translationareallocated,withinthebalancesheet,withanownerequityitem.

160

第 169 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Youcandeterminehowyouwantnetincomeandretainedearningstobeaffected.

To do this, you select certain differential items for the translation item sets in

the translation method.

Typically, only the translation differences in the balance sheet are posted with

an effect on net income and retained earnings. In US GAAP accounting, the

differencesintheincomestatementarepostedbacktothebalancesheet.

Translationdifferencesintheincomestatementaretypicallypostedtoanincome

statementitem. Thedifferencesaffectneithernetincomenorretainedearnings.

Youalsohavethefollowingoptionsforpostingtranslationdifferences:

Post with subitems.

Breakdowndifferencesbypartnerunitortransactioncurrency.

Figure 51: TreatmentofDifferences Affecting NetIncome

In the Customizing of translation methods, if you define that balance sheet

currencytranslationdifferencesaretobepostedtoitemsintheincomestatement,

an imbalance occurs in the balance sheet and the income statement, from the

posting. Thisfinancialstatementimbalanceshouldnormallyflowintotheannual

net income and retained earnings.

Whenpostingtranslationdifferenceswithaneffectonnetincome,youwantto

differentiatebetweentranslationswithinthefirsttranslationaffectingnetincome

andthetranslationaffectingnetincomeinsubsequentperiods.

Duringfirsttranslation, theentiretranslationdifferenceispostedwithaneffect

on net income.

161

第 170 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Duringsubsequenttranslations,onlythechangeinthetranslationdifferencesince

thefirsttranslationcanbepostedwithaneffectonnetincome.

Inthesystem,adifferentiationbetweenthefirstandsubsequenttranslationwith

an affect on net income ismade by means of selected items. The system uses

thisselecteditemtostorethetranslationdifferencesfromthefirsttranslation. In

subsequenttranslations,itcalculatesthechangeintranslationdifferencesinternally

andpoststhisamount. Youspecifyselecteditems,suchasthestatisticalitemfor

currencytranslationaffectingnetincome,inthesectiontranslationCustomizing.

Figure 52: Example for Different Translations

Assets:

Inthisexample,theFSitemsofthefixedassetsaretranslateddifferently:

Theacquisitioncostisestimatedwiththeavailablevalueingroupcurrency,and

mid-yearacquisitionsaretranslatedatthecurrentexchangerate.

Receivablesaretranslatedatthecurrentexchangerate.

Liabilities and Equity:

Thecommonstockisestimatedwiththehistoricalvalueaccordingtothechanges

in investee equity.

Retainedearningsaretranslatedatthecurrentexchangerate.

Thetotaldifferenceof100-betweenthetranslationusingthereferenceexchange

rateandtherespectivespecialexchangerateisclearedinthecurrencytranslation

differenceitemon the liabilitiesand equityside.

162

第 171 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Figure53: TotalsDatabase-TemporalTranslationDifferencesRecord

Youcancalculatethetemporaltranslationdifferencesforitemswithoutsubitems,

asthecurrencytranslationindicatortakesonthefunctionofasubitem.

Forcurrencytranslationusingthecurrencytranslationkeyattheperiodendrate

(both 9 and 7), you can calculate temporal translation differences. Up to four

databaserecordsaregeneratedinlocalcurrencyfromonedatabaserecordingroup

currency. Thisisspecifiedinthemethodentriesandseparatelystoredinthetotals

database using the translation indicator.

Theaboveexamplepresentstherecordswiththetranslationindicator0(originalr

ecord)and2. Thetemporaltranslationdifferencebetweentheoldandthenew

referenceexchangerateisshownhereforthepriorperiodvalue.

Ifyoudonotactivatethetemporaltranslationdifferenceindicator,thefollowing

records of currency translation appear:

Originalrecord(translationindicator 0): Showsthetransactionperiodvaluein

localcurrencyandthereferencevalueingroupcurrency

Whenthetranslationmethodcontainsanotherexchangerateindicator,theperiod

valueshowsthedifferencebetweenthevalueingroupcurrencyandthetransaction

reference value (translation indicator 1)

Indrilldownreports,youcananalyzetheeffectofthecurrencytranslationusing

thecharacteristictranslation,anddisplaythegenerateddatabaserecordsforeach

currency translation key.

163

第 172 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Figure54: AssetHistorySheet: TemporalTransl. Diff. Record

Ifyoutranslateassetvaluesusingthecurrentexchangerateforthecurrentperiod

andnothistoricallybyyearofacquisition,thentemporaltranslationdifferences

occur if the current exchangeratechanges with anew fiscal year. Theclosing

balance for the prior year no longer corresponds to the opening balance of the

current year.

As the asset items are always defined broken down by subitems, you receive

a special record of translation differences using the transaction types for the

currency translation.

Thefollowingsubitems(consolidationtransactiontypes) areusedintheabove

asset history sheet:

105 Opening balancetranslation differences

205 Valueadjustment translationdifferences

100 Opening balance APC

200 Openingbalanceaccumulated depreciation

120 Acquisitions

220 Depreciation

164

第 173 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Figure 55: AssetHistorySheetat Current Rate: Method

Youcanrecordthetranslationdifferenceseparatelyusingthesubitemtransaction

type. To do this, you must make the following entries when you maintain the

currency translation method:

Ref. exchange rate ind.: Current exchangerate

Record closing bal. (APC or VA) prior year:

FortheFSitemsets,fixedassets,andvalueadjustments,specifyasubitemsetfor

OBAPC,OBVA,andasetforalltheothersubitems.

As aresult, only the itemsvalues assignedto thesubitemsOBAPC/ OB VA,

specified in the set are translated.

FixedassetsaretranslatedusingtheexchangerateindicatorCurrentexchangerate.

IfyouselectUseofprioryearratesinthemethodentry,theprioryeartranslation

rate is used.

Thecurrencytranslationpoststhetranslation differencetothetriggering items

with the subitems for translation differences.

Theotheractivities,suchastheacquisitions,retirements,andtransfers,aredefined

inthethirdmethodentry. Thesubitemsetcontainsalltheremainingsubitems.

165

第 174 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Rounding Differences

Figure 56: Rounding Differences

The translation of financial data can produce differences that are caused by

roundinginthesystem. Thesedifferencesarenotrelatedtotranslationdifferences.

Ifroundingdifferencesoccur,translatedfinancialdatadoesnotpasssubsequent

validationchecks,suchasTotalassets=Totalliabilitiesandequity.

Thesystemcalculatesthesedifferencesandpoststhemtothedifferential items

that you specify in rounding entries.

166

第 175 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

For the definition of rounding entries, the following three possibilities are

available:

• Using an item set.

– The values of items in this set must equal zero when added. For

example,thecorrespondingvalidationcheckswhetherthesumofall

the balance sheet items is 0.

• Usingtwoitemsets,checkwhetherthesumofitemsinthefirstset,suchas

thenetincomeandappropriationofretainedearnings,isequaltothesumof

itemsinthesecondset,suchastheretainedearningsinthebalancesheet.

• Using two item sets, the first of which is restricted to a set of subitems,

checkwhetherthesumofvaluesfor thesubitemsspecifiedinthefirstset

andthevaluesfromthesecondsetequalzero. Thefirstsetcancontainfixed

assetitemsrestrictedtodepreciationentries,andthesecondsetcancontain

depreciationexpenseitemsintheincomestatement.

Note: Whenyouspecifyasequenceforroundingentries,ensurethat

no entry invalidates an entry positioned earlier in the sequence.

The system only roundsif the criteria in arounding rulearemet

in local currency.

Figure 57: Rounding Entry for Item Reconciliation

Rounding differences can be used to reconcile financial statement items that

shouldhavethesamevaluesaftercurrencytranslation. Anexampleofthisisthe

retainedearningsitemsinthebalancesheetandtheincomestatementifyouusea

167

第 176 页 / 共 429 页

Unit4: CurrencyTranslation AC660

chartofaccountswithappropriationofretainedearningsintheincomestatement

and a reversed debit/credit sign. If you use varying exchange rates, currency

translationcancausedifferencestooccurbetweenthesefinancialstatementitems.

The example shows the historical translation of retained earnings (with the

appropriationofretainedearningsshownintheincomestatement),andtheneed

forroundingofentriesforreconcilingthefinancialstatementitems.

Balance carried forward 2002: carry forward the balance sheet item of the

retainedearnings. Theretainedearningsincomestatementitemiscarriedforward

to the same item in the new year, and with reversed debit/credit sign to the

unappropriatedretainedearningsiteminthenewyear. Inthisway, theincome

statement is cleared in the new year.

CurrencyTranslation: Asaresultofcurrencytranslation,theretainedearnings

(2001)aretranslatedinthebalancesheetatthe2001exchangerate(2.0),andthe

retainedearningsfrom2002aretranslatedatthe2002exchangerate(3.0). Inthe

incomestatement,thetotalretainedearningsaretranslatedatthe2002exchange

rate (3.0).

Itemreconciliationbetweentheretainedearningsitemsinthebalancesheet

and incomestatement: The difference ispostedto the retainedearningsitem

in the income statement with the corresponding debit/credit sign. The second

reconciliation corrects the value of the unappropriated retained earnings item.

Reconciliation of theentireincomestatementestablishes adifferenceof 1,000

units,whichisthenpostedtotheunappropriatedretainedearnings. Thisbalances

the income statement.

168

第 177 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Customization of Currency Translation

Figure 58: Customizing Currency Translation

Figure 59: Currency Translation - Process Flow

Currencytranslationcanbecarriedout“provisionally”or“finally”.

169

第 178 页 / 共 429 页

Unit4: CurrencyTranslation AC660

“Provisional” translation is primarily required in order to generate balance

reconciliationlistsingroupcurrencyfortheinteruniteliminationtaskthatfollows.

The type of translation run depends on the system settings and the status of

preceding tasks in the monitor.

The system runs a “provisional” translation, which cannot be blocked in the

following situations.

Ifyouhavedefinedthetranslationmethodandspecifiedexchangerates,however

you have not yet checked and activated the method. Or, if you have not yet

executedthetaskforvalidatingreportedfinancialdataand/ornotblockedthistask.

Boththe“provisional”and“final”translationcanbererunifthereporteddatais

subsequentlymodified. Previouslycalculatedvaluesaresimplyoverwrittenwith

newones. Restrictionsexistwiththereferenceexchangerateindicator“*”.

170

第 179 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Exercise 9: Currency Translation

Exercise Objectives

After completingthisexercise, youwillbeableto:

• DefineacurrencytranslationmethodExecutethetaskcurrencytranslationin

the data monitor

Business Example

The consolidation unit D reports itsdata inthelocal currency EUR. After you

define andassignatranslationmethod,demonstratecurrencytranslationusing

the consolidation unit D as an example.

Task:

Translation method

1. Translation entries

Define the translation method XY-01 (where XY stands for the chart of

accounts)usingreferenceexchangerateindicator5(=currentrate).

Hint: Thesetsyouneedbeginwiththeletterforyourgroup(Afor

group 01, etc.) and ahyphen (X-...).

Example:

Group 01: Set A-

Group 10: Set J-

Group 18: Set R-

ThesuffixconsistsoftheFSitemnumber,thesubitem,orthefrom

FS item number.

Makethefollowingsettingsinthemethod: Enterthefollowing:

Field/Data Type Value

Translation entry 010:

FS Item Set: From: 191500

X-191500FixedAssets

Continued on next page

171

Field/Data Type	Value
Translation entry 010:
FS Item Set: X-191500FixedAssets	From: 191500

第 180 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Field/Data Type Value

Subitem set: From: 100

X-100OpeningBalances

Translation key 6

Translationdifferences:

Item (debit/credit) 250910

Subitem category 6

Subitem 120

Translation entry 020:

FS Item Set:

X-191500FixedAssets

Subitem Set: From120to299

X-999FixedAssetMovements

Exchangerateindicator 5

Translation key 1

Translationdifferences:

Item (debit/credit) 250910

Subitem category 6

Subitem 120

Translation entry 030:

FS Item Set: From170100to170400

X-170100Investments

Translation key 3

Translationdifferences:

Item (debit/credit) 250920

Subitem category 6

Subitem 120

Continued on next page

172

Field/Data Type	Value
Subitem set: X-100OpeningBalances	From: 100
Translation key	6
Translationdifferences:
Item (debit/credit)	250910
Subitem category	6
Subitem	120
Translation entry 020:
FS Item Set: X-191500FixedAssets
Subitem Set: X-999FixedAssetMovements	From120to299
Exchangerateindicator	5
Translation key	1
Translationdifferences:
Item (debit/credit)	250910
Subitem category	6
Subitem	120
Translation entry 030:
FS Item Set: X-170100Investments	From170100to170400
Translation key	3
Translationdifferences:
Item (debit/credit)	250920
Subitem category	6
Subitem	120

第 181 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Field/Data Type Value

Translation entry 040:

FS Item set: From: 250100

X-250100CommonStock

Translation key 4

Translation differences:

Item (debit/credit) 250930

Subitem category 6

Subitem 120

Translation entry 050:

FS Item Set From100000to170099

X-299999 BS-Investments- From170401to191499

MachEquip-CommonStock

From191501to250099

From250101to299999

Exchange rateindicator 5

Translation Key 1

Translation differences:

Item (debit/credit) 250940

Subitem category 6

Subitem 120

Transaction Currency Checkthedefaultbox

Translation entry 060:

FS Item set: From300000to389999

X-389999IncomeStatement

Exchange rateindicator 6

Translation key 5

Translation differences:

Continued on next page

173

Field/Data Type	Value
Translation entry 040:
FS Item set: X-250100CommonStock	From: 250100
Translation key	4
Translation differences:
Item (debit/credit)	250930
Subitem category	6
Subitem	120
Translation entry 050:
FS Item Set X-299999 BS-Investments- MachEquip-CommonStock	From100000to170099 From170401to191499 From191501to250099 From250101to299999
Exchange rateindicator	5
Translation Key	1
Translation differences:
Item (debit/credit)	250940
Subitem category	6
Subitem	120
Transaction Currency	Checkthedefaultbox
Translation entry 060:
FS Item set: X-389999IncomeStatement	From300000to389999
Exchange rateindicator	6
Translation key	5
Translation differences:

第 182 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Field/Data Type Value

Item (debit/credit) 250930

Subitem category 6

Subitem 120

Translation entry 070:

FS Item Set From: 390000

X-299999 BS-Investments-

MachEquip-CommonStock

Exchangerateindicator 6

Translation key 5

Translationdifferences:

Item (debit/credit) 251200

Subitem category 6

Subitem 120

2. Rounding rules

Definethefollowingroundingrulesinthesequencelisted:

-Annualnetincomeinthebalancesheetandincomestatement: differential

item251200RetainedEarnings-CurrentYear,subitem120Additions

- Balance sheet

-Differentialitem250950CurrencyTranslationAdjustments-Rounding,

subitem 120 Additions

- Income statement

-Differentialitem321300CurrencyTranslationDifference,I/S

Continued on next page

174

Field/Data Type	Value
Item (debit/credit)	250930
Subitem category	6
Subitem	120
Translation entry 070:
FS Item Set X-299999 BS-Investments- MachEquip-CommonStock	From: 390000
Exchangerateindicator	6
Translation key	5
Translationdifferences:
Item (debit/credit)	251200
Subitem category	6
Subitem	120

第 183 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Field/Data Type Value

Translation Entry 010:

From: 191500

FS Item Set:

X-191500 Fixed Assets

From: 100

Subitem set:

X-100Opening Balances

Translation key 6

Translation differences:

FS Item (debit/credit) 250910

Subitem category 6

Subitem 120

Translation Entry 020:

FS Item Set:

X-191500 Fixed Assets

From 120 to 299

Subitem Set:

X-999FixedAssetMovements

Exchange rateindicator 5

Translation key 1

Translation differences:

Item (debit/credit) 250910

Subitem category 6

Continued on next page

175

Field/Data Type	Value
Translation Entry 010:
FS Item Set: X-191500 Fixed Assets	From: 191500
Subitem set: X-100Opening Balances	From: 100
Translation key	6
Translation differences:
FS Item (debit/credit)	250910
Subitem category	6
Subitem	120
Translation Entry 020:
FS Item Set: X-191500 Fixed Assets
Subitem Set: X-999FixedAssetMovements	From 120 to 299
Exchange rateindicator	5
Translation key	1
Translation differences:
Item (debit/credit)	250910
Subitem category	6

第 184 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Field/Data Type Value

Subitem 120

Translation Entry 030:

From170100to170400

FS Item Set:

X-170100 Investments

Translation key 3

Translation differences:

Item (debit/credit) 250920

Subitem category 6

Subitem 120

Translation Entry 040:

From: 250100

FS Item set:

X-250100CommonStock

Translation key 4

Translation differences:

Item (debit/credit) 250930

Subitem category 6

Subitem 120

Translation Entry 050:

FS Item Set From100000to170099

X-299999 BS-Investments-MachEquip- From170401to191499

Common Stock

From191501to250099

From250101to299999

Continued on next page

176

Field/Data Type	Value
Subitem	120
Translation Entry 030:
FS Item Set: X-170100 Investments	From170100to170400
Translation key	3
Translation differences:
Item (debit/credit)	250920
Subitem category	6
Subitem	120
Translation Entry 040:
FS Item set: X-250100CommonStock	From: 250100
Translation key	4
Translation differences:
Item (debit/credit)	250930
Subitem category	6
Subitem	120
Translation Entry 050:
FS Item Set X-299999 BS-Investments-MachEquip- Common Stock	From100000to170099 From170401to191499 From191501to250099 From250101to299999

第 185 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Field/Data Type Value

Exchange RateIndicator 5

Translation Key 1

Translation differences:

Item (debit/credit) 250940

Subitem category 6

Subitem 120

Transaction Currency Checkthedefaultbox

Translation Entry 060:

From300000to389999

FS Item set:

X-389999IncomeStatement

Exchange rateindicator 6

Translation key 5

Translation differences:

Item (debit/credit) 250930

Subitem category 6

Subitem 120

Translation Entry 070:

From: 390000

FS Item Set

X-299999 BS-Investments-MachEquip-

Common Stock

Exchange rateindicator 6

Translation key 5

Translation differences:

Continued on next page

177

Field/Data Type	Value
Exchange RateIndicator	5
Translation Key	1
Translation differences:
Item (debit/credit)	250940
Subitem category	6
Subitem	120
Transaction Currency	Checkthedefaultbox
Translation Entry 060:
FS Item set: X-389999IncomeStatement	From300000to389999
Exchange rateindicator	6
Translation key	5
Translation differences:
Item (debit/credit)	250930
Subitem category	6
Subitem	120
Translation Entry 070:
FS Item Set X-299999 BS-Investments-MachEquip- Common Stock	From: 390000
Exchange rateindicator	6
Translation key	5
Translation differences:

第 186 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Field/Data Type Value

Item (debit/credit) 251200

Subitem category 6

Subitem 120

3. Assignment:

Assign the translation method XY-01 (where XY stands for the chart of

accounts)toconsolidationunitDinthemasterrecord.

- You will use the data monitor to carry out currency translation for

consolidationunitD.Youthereforeneedtodefineonemoretask.

4. Defining tasks:

CallthecurrencytranslationtaskCURRTRANandassignittotaskgroup

DATA.

Make sure that currency translation is automatically blocked after it is

executed successfully.

5. RuncurrencytranslationforconsolidationunitDinthedatamonitor,and

examine the audit trail.

178

Field/Data Type	Value
Item (debit/credit)	251200
Subitem category	6
Subitem	120

第 187 页 / 共 429 页

AC660 Lesson: Translation and Rounding Differences

Solution 9: Currency Translation

Task:

Translation method

1. Translation entries

Define the translation method XY-01 (where XY stands for the chart of

accounts)usingreferenceexchangerateindicator5(=currentrate).

Hint: Thesetsyouneedbeginwiththeletterforyourgroup(Afor

group 01, etc.) and ahyphen (X-...).

Example:

Group 01: Set A-

Group 10: Set J-

Group 18: Set R-

ThesuffixconsistsoftheFSitemnumber,thesubitem,orthefrom

FS item number.

Makethefollowingsettingsinthemethod: Enterthefollowing:

Field/Data Type Value

Translation entry 010:

FS Item Set: From: 191500

X-191500FixedAssets

Subitem set: From: 100

X-100OpeningBalances

Translation key 6

Translation differences:

Item (debit/credit) 250910

Subitem category 6

Subitem 120

Translation entry 020:

Continued on next page

179

Field/Data Type	Value
Translation entry 010:
FS Item Set: X-191500FixedAssets	From: 191500
Subitem set: X-100OpeningBalances	From: 100
Translation key	6
Translation differences:
Item (debit/credit)	250910
Subitem category	6
Subitem	120
Translation entry 020:

第 188 页 / 共 429 页

Unit4: CurrencyTranslation AC660

Field/Data Type Value

FS Item Set:

X-191500FixedAssets

Subitem Set: From120to299

X-999FixedAssetMovements

Exchangerateindicator 5

Translation key 1

Translationdifferences:

Item (debit/credit) 250910

Subitem category 6

Subitem 120

Translation entry 030:

FS Item Set: From170100to170400

X-170100Investments

Translation key 3

Translationdifferences:

Item (debit/credit) 250920

Subitem category 6

Subitem 120

Translation entry 040:

FS Item set: From: 250100

X-250100CommonStock

Translation key 4

Translationdifferences:

Item (debit/credit) 250930

Subitem category 6

Subitem 120

Continued on next page

180

Field/Data Type	Value
FS Item Set: X-191500FixedAssets
Subitem Set: X-999FixedAssetMovements	From120to299
Exchangerateindicator	5
Translation key	1
Translationdifferences:
Item (debit/credit)	250910
Subitem category	6
Subitem	120
Translation entry 030:
FS Item Set: X-170100Investments	From170100to170400
Translation key	3
Translationdifferences:
Item (debit/credit)	250920
Subitem category	6
Subitem	120
Translation entry 040:
FS Item set: X-250100CommonStock	From: 250100
Translation key	4
Translationdifferences:
Item (debit/credit)	250930
Subitem category	6
Subitem	120