AC210_EN_Col92_FV_Part_A4 (第6页)

第 188 页 / 共 337 页

Unit4: Integrationandotherrelatedissues... AC210

Startyour drilldownwith theselectionsof yourvariantVAR##andcheck

your plannedvaluesbynavigatingaccordingly.

Hint: Ifyouhavenotsavedavariant,usethefollowingselections:

CurrencyType: 10

CompanyCode: AA##

Ledger: 0L

ControllingArea: 1000

FIS Annual INT

Rep.Struc:

Plan Version: The plan version in which the plan data

was entered

Fiscal year: Current fiscal year

Fromperiod: Current period

To period: Current period

Output type: Youcanchoose–graphicalorclassic

a) Application: Accounting → Financial Accounting → General

Ledger → Information System → General Ledger Reports (New)

→ Reports for Profit Center Accounting → Profit Center Group:

Plan/Actual/Variance

b) ChooseGoto→Variants→Get... fromthemenutoselectthevariants.

9. Canyounowgofromthedrilldowntoaplanlineitem?

a) Click the plan value in the Plan column and choose Goto → Call

report... from the menu bar.

b) Inthedialogboxthatappears,choosetheline/reportPlanLineItems

FI.

c) Result:Thesystemdisplaysaplanlineitem.

Task 2:

Optional:Integrated planning with CO

1. Toensureintegratedplanningexerciserunssmoothly,werecommendthat

there is a planning version 0 with the following settings in the training

system:

Continued on next page

174

第 189 页 / 共 337 页

AC210 Lesson: Planning / Planning Options

Ledger: 0L

Version: 0

Manual Planning: X

IntegratedPlanning: X

VersionDescription: FIplanversion0(or similar)

Hint: Ifthereisnoplanversion0,pleaseinformyourinstructor.

Fromthecontrollingapplication,startthecostcenterplanningtransaction

(cost and activity inputs).

Whenthesystempromptsyou,entertheCOplannerprofileSAPALL.

WerecommendthatyouworkwiththeCOplanninglayout1-101andenter

theplandataforyourcostcenterT-F05A## asfollows:

Plan Version: 0

Planningperiod: Current period/current year

Cost Element: Direct labor costs(420000)

UsingtheOverviewScreenbutton(F5),younavigatetothechangemodeof

COplanning. Enteraplannedcostfixedamount(thiscanbeanyamount

you choose).

Save your CO plan data.

a) Application: Accounting→Controlling→CostCenterAccounting→

Planning→CostandActivityInputs→Change

2. SincetheprofitcenterPC##mustbedefinedinthemasterdataforthecost

centerT-F05A##,duringcorrectCO-FIintegratedplanning,theCOplanned

valuemustalsobedisplayedintheprofitcenterPC##inFI.

Checkagainintheplandrilldown(PCgroup: plan/actual/variance).

StartyourdrilldownwiththeselectionsofyourvariantVAR##andcheckthe

plannedvaluesforyourprofitcenterPC##bynavigatingaccordingly.

a) Application: Accounting→FinancialAccounting→GeneralLedger

→InformationSystem→GeneralLedgerReports(New)→Reportsfor

ProfitCenterAccounting→ProfitCenterGroupPlan/Actual/Variance

b) ChooseGoto→Variants→Get... fromthemenutoselectthevariants.

Continued on next page

175

第 190 页 / 共 337 页

Unit4: Integrationandotherrelatedissues... AC210

3. IntheFIplandrilldowncalled,(thisisavailableasofEhP3),youcanalso

navigateaccordingtotheCOcosttypesornavigateto variousCO(plan)

reports.

You can go from the FI plan line items to the CO plan line items (by

double-clicking).

a) Click the plan value in the Plan column and choose Goto → Call

report... from the menu bar.

Now select the corresponding row / report in the dialog box that

appears.

176

第 191 页 / 共 337 页

AC210 Lesson: Planning / Planning Options

Lesson Summary

You should now be able to:

• ... Describe various planning options

• ... UnderstandtheintegratedplanningofthenewG/LwithCO

177

第 192 页 / 共 337 页

UnitSummary AC210

Unit Summary

You should now be able to:

• ... Enter postings in accounts payable, accounts receivable, and asset

accounting

• ... Perform post-capitalization of cash discounts for assets in real-time,

thanks to document splitting

• ... Understand how follow-up costs can be distributed in CO online and

decidewhetherthismethodwouldbegoodforyourcompany

• ... Configureandusethereal-timeintegrationofControllingwithFinancial

Accounting, and understand its meaning

• ... UnderstandthemeaningofathirdperiodintervalwithintheFIposting

period maintenance

• ... Recognize that applications related to FI are also “linked” with new

general ledger accounting.

• ... Perform allocations in FI

• ... Understand you must make a decision about “where” profit center

accounting is supposed to be mapped

• ... Describe various planning options

• ... UnderstandtheintegratedplanningofthenewG/LwithCO

178

第 193 页 / 共 337 页

AC210 Test Your Knowledge

Test Your Knowledge

179

第 194 页 / 共 337 页

TestYourKnowledge AC210

Answers

180

第 195 页 / 共 337 页

第 196 页 / 共 337 页

第 197 页 / 共 337 页

Unit 5

Selected Periodic Processing

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• ... Analyze and name the periodic tasksthat will be no longer necessary

when you use the new general ledger

• ... Configureandrunaforeigncurrencyvaluation

• ... Execute the depreciation run

Unit Contents

Lesson: (Selected) Periodic Processing.....................................182

Exercise7: ForeignCurrencyValuation(ofCustomerReceivables) 195

181

第 198 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Lesson: (Selected) Periodic Processing

Lesson Overview

• UsingNewGeneralLedgerAccountingtoaccelerateperiod-endclosing

• Foreigncurrencyvaluation(programFAGL_FC_VALUATION)

Lesson Objectives

After completingthislesson, you will beable to:

• ... Analyze and name the periodic tasks that will be no longer necessary

when you use the new general ledger

• ... Configureandrunaforeigncurrencyvaluation

• ... Execute the depreciation run

Business Example

AsyousawrepeatedlyintheIntegrationunit,usingthenewgeneralledgercan

saveyoufromperformingmanyperiodicclosingandreconciliationoperations,

because the system performs them in real time. This accelerates period-end

closing.

182

第 199 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Figure 72: Faster Period-End Closing

Hint: Examples of periodic processing tasks that have not been

discontinuedbut thathavebeenchangedslightlyasaresultofthenew

“ledgerlogic”orthatarebasedonnewprogramsandthatarenotshown

explicitly in AC210 are:

• Balance carryforward (in FI)

• Reclassification/sortingofreceivablesandpayables

• Flat-rate individual value adjustment

183

第 200 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Figure73: FCValuation–programFAGL_FC_VALUATION(1)

Tostarttheadjustmentposting,calltheprogramFAGL_FC_VALUATIONinSAP

ERP (new G/L must be active).

After you activate the new general ledger, you can no longer execute the old

program, SAPF100.

IntheSAPEasyAccessMenu,youcanfindthenewprograminseveralplaces,for

example,inaccountspayableaccountingunder: PeriodicProcessing→Closing

→Valuate→ForeignCurrencyValuationofOpenItems(New).

Note: Thetransferoftheprofitcenterandsegmentinthevendorandtax

lineitemsshowsthatdocumentsplittingisactiveforthepostingshown

in the example.

184

第 201 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Figure74: FCValuation–program FAGL_FC_VALUATION(2)

YoucanfindtherelevantCustomizingpathsunder: FinancialAccounting(New)

→GeneralLedgerAccounting(New)→PeriodicProcessing→Valuate→...

Thevaluationareastodefineshouldnotbeconfusedwiththedepreciationareasin

AssetAccounting(FI-AA).TheseareoriginalFIvaluationareas.

Hint: These valuation areas will be / are used if you want to model

parallelaccountingprinciplesintheSAP system. If youonlyneedthe

local valuation approach, asisassumedinthisunit, thenyouwill only

havetodefineonevaluationarea. YoucanselecttheIDandnamefreely.

Suggestion: LO – local valuation area

*Outlook:TheParallelFinancialAccountingunitinAC210providesinformation

about mapping multiple valuation approaches.

185

第 202 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Figure75: FCValuation–programFAGL_FC_VALUATION(3)

Tocreate aposting, theexpenseand correction accountshaveto bedefined

firstinthesystem: Customizing: FinancialAccounting(New)→GeneralLedger

Accounting (New) → Periodic Processing → Valuate → Foreign Currency

Valuation → Prepare Automatic Postings for Foreign Currency Valuation =>

TransactionExchangeRateDif.: OpenItems/GLAcct=>selectthesettingsfor

account160000ofchartof accountsINT,for example.

Hint: Although the foreign currency valuation program

FAGL_FC_VALUATIONrequiresavaluationarea,ablankentryforthe

valuationareaissufficientinaccountmaintenance–thatis, youdefine

theaccountswithoutavaluationarea. Formoreinformation,seethetopic

Ledger Approach in the New G/L.

TheFIentitiesfromtheoriginalvendorinvoice/openitemsaretransferredin

theFCvaluationdocumentsifdocumentsplittingisactive.

Caution: Ifsplittingisnotactive,theaccountsareonlysuppliedwiththe

correspondingvalueswithoutattributes;theFIentitiesarenottransferred

in thecorrectionand / or valuation posting.

You can see this as even (just ) one P&L consideration for each

characteristic (forexample, for each profit center) wouldnot be100%

complete without document splitting.

186

第 203 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Iftheaboveexampleinvolvedanoriginalvendorinvoicewithvariousexpense

lineitemsanddifferentcharacteristicvalueassignments,thecorrectiondocument

would also be split, if splitting were active.

Hint: * If you want to or havetoavoid reset documents / reversal

documents (during OI valuation), you must make additional

configurations. See next graphic.

Figure76: FCValuation–program FAGL_FC_VALUATION(4)

Caution: The(system)prerequisitesshowninthegraphicmustalready

bemetwhenthevendorinvoiceisposted(inaforeigncurrency).

Internationalcontext:Therevenueaccountfromcurrencyvaluationcanalsobe

defined as a cost element. In this case, negative costs would be posted to the

correspondingCOobjectafteracurrency-relatedreductionofthepayable.

YoucannavigatefromthelineitemsoftheCOreporttothepostedCOdocument,

and from there back to the FI document.

187

第 204 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Figure77: FCValuationintheNewG/LwithDeltaPostingLogic

A deltavaluation areaisdefinedin Customizing: FinancialAccounting(New)

→ General Ledger Accounting (New) → Periodic Processing → Valuate →

Activate Delta Logic.

Note: You can also start the functions directly in the view

V_FAGL_FCV_DELTA.

For more informationabout this, seeNotes960661 and1006684. Thesenotes

provideinformationabouttheSupportPackagesthatprovidethedeltalogicinthe

different ERP releases.

Hint: *Insomecountries,acancellationpostingtakesplacethefollowing

month. Duringavaluationrunattheendofthefiscalyear,thismeansan

adjustmentpostinginanotherfiscalyear,whichisnotallowed.

188

第 205 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Figure 78: FC Valuation: Delta Posting Logic

ThevaluationdifferencesarestoredinthetableFAGL_BSBW_HISTRY.

Notes960661and1006684providemoreinformationaboutthistopic.

189

第 206 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Figure 79: FC Valuation: Delta Posting Logic (2)

Hint: You can set an additional indicator in the same Customizing

transaction: The indicatorforusing theclearing dateasthereversal

date.

Why might you set this indicator?

Note: Please read the following explanation again once the Parallel

Accounting unit has been discussed.

In new G/L, when clearing a document in a foreign currency (in the example

shown in AC210 this is clearing of a vendor invoice), in contrast to classic

G/L accounting it is not possible to enter the actual realized exchange rate

difference immediately. The reason for this is that the clearing document is

enteredinallledgersofnewG/L.Theexchangeratedifferencetoberealizedmay

(often)bedifferentindifferentledgers. Asaresult,forclearingdocumentswith

foreign currency in the new G/L, the difference amount between the original

invoice date and the clearing date is always displayed/posted as the realized

exchange rate difference.

The correct, realized exchange rate difference is then determined for each

valuation area (first) during the next FC valuation run (from the difference

amountsrecordedinthetableFAGL_BSBW_HISTRYandtheactualexchangerate

ontheclearingdate)andpostedagainsttherealizedexchangeratealreadyentered.

190

第 207 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

This(second)postinginitiallyhasthedateofthevaluationrun,usuallytheendof

themonth,asthepostingdate. Youcansettheindicatorforusingtheclearing

date as the reversal date to ensure that the posting date of the (correction)

valuationrunistheclearingdateof thevaluateditem.

However:Theclearingdateshouldonlybeusedforthereversalpostingifthisis

absolutelynecessarybecausetheprogramcannotensurethattheperiodtobeused

isopen. Iftheperiodisclosed,thesystemissuesanerrormessageandtheposting

isnotcarriedout, ratheritissavedinabatchinputsession.

Figure 80: Program RAPOST2000 (and RAPOST2010)

TheRAPOST2000programpostsdepreciationforAssetAccountinginRelease

R/34.7andonwards. ThisprogramisthesuccessortoprogramRABUCH00.

Note: The main difference between RAPOST2000 and RABUCH00

is that the newer depreciation posting program no longer uses batch

processing,butinsteadpostsdepreciationtothegeneralledgeraccounts

inFI immediately during theprogramrun.

Another interesting question is whether and how the FI attributes(such as the

segment)arepassedoninthedepreciationpostingdocuments.

191

第 208 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Figure 81: Settings forthe Depreciation Posting Run

About account assignment types:

• Depreciation area 20 must have account assignment type depreciation

posting run if area 20 is the area for posting the cost-accounting values

(depreciation/interest) to Controlling. In this case, the cost-accounting

depreciationaccountisdefinedasacostelement,andrequiresaCO-relevant

account assignment during the depreciation posting run. However, this

accountcanonlybeselectedifthecorrespondingCOobject(suchascost

center,order,orWBSelement)islinkedwiththeaccountassignmenttype

depreciation posting run.

• Valuation area 01 records book depreciation. The system requires the

account assignment typedepreciation posting runfor area01 even if the

depreciationexpenseaccountisnotdefinedasacostelement,whichmeans

thesevalues are only postedin FI. Thisistheonlyway for the system to

derivetheprofitcenterandthen(possibly)thesegmentfromtheCOobject

for the book depreciation document.

Hint: Onlytheactualamountpostedtoanaccountthat isalsodefined

as a (primary) cost element actually ends up in Controlling – both

depreciationamountsendupintheleadingledger.

192

第 209 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Assoonasthedocumentsplitisactivated,thedepreciationdocumentsalsohave

to meet the document split criteria, which means the corresponding accounts

have to be defined as item categories.

• Depreciationexpenseaccounts,suchasordinarydepreciationorunplanned

depreciation.

• Cost-accountingexpenseaccountssuchasdepreciationexpensesorinterest

expenses.

• Clearing accountsfor cost-accountingexpenses.

• Note: Accumulated depreciation accounts are already defined as item

category Asset.

Note: FI-AA already takes care of the split at attribute level for

depreciation documents.

193

第 210 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

194

第 211 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Exercise 7: Foreign Currency Valuation

(of Customer Receivables)

Exercise Objectives

After completingthisexercise, youwillbeableto:

• ... Understandandstarttheprogramforforeigncurrencyvaluation

Business Example

Youwill only runthelocal valuationin this unit; youwilladdan international

valuation in the following unit.

Task:

ForeignCurrencyValuation(ofCustomer Receivables)

Hint: Task 1. You only need to conduct this exercise if you have not

alreadycreatedcustomer210##intheoptionalexerciseintheDocument

Splittingexerciseorintheexerciseonallocation.

1. Createacustomer210##inyourcompanycodeAA##.

Youcanusecustomer1000incompanycode1000asatemplate. Donot

modify the input field Account group.

Fill in all the required-entry fields for the address data (=> for example,

transportationzone0000000001)andsaveyourdata.

2. Nowenteracustomerinvoice(inUSD)foryourcustomer210##forthe

amount of $5,000.00.

Thismeansyouarecreatinganinvoicefora(major)internationalcustomer

intheircurrency. AlsoassumethattheUSDexchangeratewas0.83333on

thepostingdate. ThiscorrespondstoaEURexchangerateof1.20(1divided

by1.20is0.8333)Accordingly,theEuroisstrongcomparedtothedollar,or

alternatively: Thedollar is relatively weak.

Enterthefollowingdatainthepostingtransaction:

Customer: 210##

Invoice date: 07.07.Last year

Reference: 1##

Posting Date: 17.07.Last year

Continued on next page

195

第 212 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Amount: 5.000,–

Currency: USD

IndicatorCalculatetax: Set

Hint: Tosimplifythings, enter the documentwithout taxes(tax

code A0).

EnterthevaluesandswitchtotheLocalcurrencytab.

Checkthe(current)exchangerate(takenfromtableTCURR)andchangeit

manuallyto/1.2or0.83333,inlinewiththeassumptionsmadeabove.

Hint: This process is very simple if you use the F4 help for the

Exchangeratefield,andthenmaintainthefollowingentry:

1 EUR = 1.20000 X 1 USD

... AndthenapplytheexchangeratewiththeF8button.

=> See the notes specified below.

Hint: YoucanpressEnterto skipanywarningmessages dueto

valuesthatdifferfromthetableexchangerate.

Hint: Tip:IftheExchangeratefieldisnot(ornolonger)readyfor

input,youcanspecifytheEuro-denominatedamountof4,166.67in

theAmountinLCfieldonthesametabpage.

Youarenowmissingtherevenueaccount/credititemfortheposting: Enter

G/Laccount800200inthelowersectionoftheinputscreenandenter“*”to

copytheamountof$5,000.00. Asyoualsowant/havetoassignasegment

accountfortheposting,entertheprofitcenteryoucreated–PC##–inthe

corresponding field.

Simulate and save the document.

3. Displaythedocumentagainfromthepostingtransaction. Theprofitcenter

and the segment are passed on to the receivable line item in the general

ledgerview. YoucanchoosetheDisplayCurrencypushbuttontodisplaythe

amounts in Euros and U.S. dollars.

4. Now enter a second invoice for the same customer. We now assume,

however,thattheinvoiceispostedlater,atatimewhenthedollarisrelatively

strong(comparedtotheEuro)–useaEURexchangerateof0.80.

Continued on next page

196

第 213 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

=>ThismeansarelativelystrongUSDexchangerateof1.25forthisposting

since 1 divided by 0.8 is 1.25.

The procedure is otherwise exactly the same as for the second task step.

Use the following data:

Customer: 210##

Invoice date: 08.01. of the current year

Reference: 2##

Posting Date: 10.01. of the current year

Amount: 4.000,–

Currency: USD

IndicatorCalculatetax: Set

Note: Tosimplifythings,enterthedocumentwithouttaxesagain

(tax code A0).

EnterthevaluesandswitchtotheLocalcurrencytab. Changethedisplayed

exchangeratemanuallyto/0.8or1.25,inlinewiththeaboveassumption.

ThisprocessisverysimpleifyouusetheF4helpfortheExchangeratefield,

and then maintain the following entry:

1 EUR = 0.80000 X 1 USD

AndthenapplytheexchangeratewiththeF8button.

Caution: YoucanchooseEntertoskipanywarningmessagesdue

tovaluesthatdifferfromthetableexchangerate.

Hint: If the Exchange rate field is not ready for input, you can

specifytheEuroamountof5,000intheAmountinLCfieldonthe

same tab page.

You are now missing the revenue account / credit item for the posting:

Enter G/L account800200 inthelower part of the entryscreenand enter

“*” to copy the amount of USD 4,000. Because you also want / have to

assign a segment account for the posting, enter profit center1000 in the

corresponding field.

Simulate and save the document.

5. Now start a customer line item list for your customer 210## to display

the posted open customer invoices.

Continued on next page

197

第 214 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Optional:If you desire, you can change the layout (of the results list) to

displaytheeffectiveexchangerate(technicalfieldname: 1-KURSE)andthe

referencefield (technical field name: 1-XBLNR) ifthesearenot already

displayed.

Saveyouruser-specificlayout,L##,withnameLayoutGr. ##.

6. Younowhavetoconfigurethesystemforforeigncurrencyvaluation. You

firstmaintain/checktheaccountsyouwanttopostto. Starttheappropriate

Customizingtransactionandperformthefollowingactivities:

=> Select transaction KDF

=> Select chart of accounts INT

=>G/L/reconciliationaccount140000(tradereceivables)

=>TakealookatthelogicalfieldgroupValuationandcheckwhetherthe

following accounts are already stored:

Expenseaccount: Account 230 011

Revenueaccount: Account 280 010

Balance sheet adjustment Account 140 099

account:

Hint: This is a test exercise – please do not change the system

configuration.

Note: Ifyouhadtovaluateforeigncurrencypayablesaswell,you

wouldalsoassignexpense,revenue,andadjustmentaccountstothe

payablesaccount (for example, 160000).

7. Sincedocumentsplittinghasbeenactivatedforyourcompanycode,AA##,

theexpense, revenue, andcorrection accountshaveto be definedasitem

categories for theforeign currency valuation. Check whether the entries

230010,230011,280010and140099alreadyexistforchartofaccountsINT.

Ifthisisnotthecase,pleasenotifyyourcourseinstructor.

Hint: This is a test exercise – please do not change the system

configuration.

8. To start the (new) foreign currency valuation run later, avaluation area

must be passed on in SAP ERP – regardlessof whether or not different

valuationapproachesareneededforparallelfinancialaccounting.

Continued on next page

198

第 215 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Caution: The valuation area you define now has nothing to do

withdepreciationareasinAssetAccounting; itisavaluationarea

that is defined in FI.

Create aseparate valuation area in FICustomizing. TheID of thenew

valuationareashouldhavetwoletters. Thefirstletterofeverygroupis“L”.

ThisLstandsforlocalinthisexample. Selectthesecondletterforyour

group from the following table:

Group 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18

Letter A B C D E F G H I J K L M N O P Q R

Examples:

Group1receivestheletterA:ThevaluationareaisthereforecalledLA.

Group5receivestheletter5: ThevaluationareaisthereforecalledLEand

so on.

Enterthefollowingdatafor thenewvaluationarea:

Area: L# (=> # stands for the second letter from

the above table)

Valuationmethod: Leave blank for now

Crcy type: Company code currency

Add.curr. Leave blank

FS Vers Leave blank or enter INT

LongText: Local valuationareagroup##

9. AlsocreateavaluationmethodinCustomizing. Youwillneedittodefine

how a run is to be valuated. Name your new valuation methodL## and

define it as follows:

Description: Localvaluationforaveragerate,group##

ValuationProcedure: Lowest Value Principle

DocumentType: SA

ExchRate Type for

Debit/Credit Bal: Mforboth(=>M=averagerate)

Continued on next page

199

Group	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18
Letter	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R

第 216 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

10. You assign thenew valuationmethodL##(retrospectively)toyour new

valuation area L# from task step 8.

Hint: PriortoSAPERP,thevaluationmethodwasnotenteredin

the application until the actual run. Thisis no longer possible in

New General Ledger Accounting.

11. You have now configured all the settings for the actual foreign currency

valuation,providedyouonlyneedtocomplywithoneaccountingprinciple

andonlywanttovaluateopenitems(asisassumedforthissetofexercises).

Startthevaluationrun,forexamplefromtheaccountsreceivableaccounting

application. As you will see in the SAP Easy Access menu, when New

General Ledger Accounting is activated, you can no longer start the old

valuationprogramSAPF100(ForeignCurrencyValuationofOpenItems).

YouhavetousetheoptionForeignCurrencyValuationofOpenItems(New).

This is program FAGL_FC_VALUATION.

Youcanstartwithatestrunandcontinuewiththeproductionrun.

Enterthefollowingdataintheselectionscreenfortheprogram:

CompanyCode: AA##

ValuationKeyDate: Lastdayofthepreviousmonth

Caution: IfyourAC210trainingcoursetakesplaceinJanuary,use

January 31 of thisyear as the key date.

Valuation Area: L#

CreatePostingsindicator Donotsetuntil afteratestrun, whenyou

start the production run.

Hint: You donot need to specify a folder name, asyou will not

use a folder.

The program now needs to know which “objects” will be processed,

regardlessofwhetherthisisatestorproductionrun.

Open tab page Open Items:

SettheValuateCustomerOpenItemscheckbox.

You can now start the program.

Continued on next page

200

第 217 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Startingintheresultslist,youcannavigatetothesimulatedpostings(aftera

testrun)ortotheactualpostings(afteraproductionrun).

Remainin theresultslist ofthevaluation run.

Hint: Becausethisrunis“local”,usingthelowestvalueprinciple,

onlytheopenitemisvaluated; asofthekeydate,itnolongerhas

avalueof€5,000.00,butinstead€4,000.00. Intheexample,this

shouldbetheseconditem–thedocumententeredinthecurrent

year.

12. Whenyouexaminethevaluationorcorrectiondocumentaftertheproduction

run, youwillseethat thesegment fromtheoriginal customer invoicehas

been passed through to the documents from the valuation run. In the

example,thisshouldbesegmentSEGB.Ifyourdocumentshaveadifferent

segment,don’tworry–youprobablyenteredadifferentcostcenterforyour

postingthantheone specifiedin theexercise.

13. Theoreticalquestion:Inthespecifiedsystemconfiguration,anewvaluation

run alwayscreates a reset document on the first of the following month.

Howcan you change this system behavior?

14. Configurethesystemsothatyour FI valuationareaL#isavaluationarea

that uses “delta logic”.

15. Thenstarttheforeigncurrencyvaluationprograminthetestrunagain

with the following settings:

Company Code: AA##

ValuationKeyDate: Lastdayofthecurrentmonth

Caution: If your AC210 training course takes place in January,

use February 28 of this year as the key date (in a leap year, use

February 29).

Continued on next page

201

第 218 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Valuation Area: L#

CreatePostingsindicator: Do not set initially

Hint: You donot need to specify a folder name, as you will not

use a folder.

Open tab page Open Items:

SettheValuateCustomerOpen Itemcheckbox.

You can now start the program.

16. (Duringanupdaterun),checkwhetheronlyonepostingiscarriedoutand,

asaresult, thecancellation postingisnot made.

202

第 219 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Solution 7: Foreign Currency Valuation (of

Customer Receivables)

Task:

ForeignCurrencyValuation(ofCustomer Receivables)

Hint: Task 1. You only need to conduct this exercise if you have not

alreadycreatedcustomer210##intheoptionalexerciseintheDocument

Splittingexerciseorintheexerciseonallocation.

1. Createacustomer210##inyourcompanycodeAA##.

Youcanusecustomer1000incompanycode1000asatemplate. Donot

modify the input field Account group.

Fill in all the required-entry fields for the address data (=> for example,

transportationzone0000000001)andsaveyourdata.

a) SAP EasyAccessmenu →Accounting →Financial Accounting→

AccountsReceivable→MasterRecords→Create

2. Nowenteracustomerinvoice(inUSD)foryourcustomer210##forthe

amount of $5,000.00.

Thismeansyouarecreatinganinvoicefora(major)internationalcustomer

intheircurrency. AlsoassumethattheUSDexchangeratewas0.83333on

thepostingdate. ThiscorrespondstoaEURexchangerateof1.20(1divided

by1.20is0.8333)Accordingly,theEuroisstrongcomparedtothedollar,or

alternatively: Thedollar is relatively weak.

Enterthefollowingdatainthepostingtransaction:

Customer: 210##

Invoice date: 07.07.Last year

Reference: 1##

Posting Date: 17.07.Last year

Continued on next page

203

第 220 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Amount: 5.000,–

Currency: USD

IndicatorCalculatetax: Set

Hint: Tosimplifythings, enter the documentwithout taxes(tax

code A0).

EnterthevaluesandswitchtotheLocalcurrencytab.

Checkthe(current)exchangerate(takenfromtableTCURR)andchangeit

manuallyto/1.2or0.83333,inlinewiththeassumptionsmadeabove.

Hint: This process is very simple if you use the F4 help for the

Exchangeratefield,andthenmaintainthefollowingentry:

1 EUR = 1.20000 X 1 USD

... AndthenapplytheexchangeratewiththeF8button.

=> See the notes specified below.

Hint: YoucanpressEnterto skipanywarningmessages dueto

valuesthatdifferfromthetableexchangerate.

Hint: Tip:IftheExchangeratefieldisnot(ornolonger)readyfor

input,youcanspecifytheEuro-denominatedamountof4,166.67in

theAmountinLCfieldonthesametabpage.

Youarenowmissingtherevenueaccount/credititemfortheposting: Enter

G/Laccount800200inthelowersectionoftheinputscreenandenter“*”to

copytheamountof$5,000.00. Asyoualsowant/havetoassignasegment

accountfortheposting,entertheprofitcenteryoucreated–PC##–inthe

corresponding field.

Simulate and save the document.

a) SAP Easy Access menu: Accounting → Financial Accounting →

AccountsReceivable→DocumentEntry→Invoice

Continued on next page

204

第 221 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

3. Displaythedocumentagainfromthepostingtransaction. Theprofitcenter

and the segment are passed on to the receivable line item in the general

ledgerview. YoucanchoosetheDisplayCurrencypushbuttontodisplaythe

amounts in Euros and U.S. dollars.

a) SAP Easy Access menu: Accounting → Financial Accounting →

AccountsReceivable→DocumentEntry→Invoice

ChooseDocument→Displayfromthemenu.

4. Now enter a second invoice for the same customer. We now assume,

however,thattheinvoiceispostedlater,atatimewhenthedollarisrelatively

strong(comparedtotheEuro)–useaEURexchangerateof0.80.

=>ThismeansarelativelystrongUSDexchangerateof1.25forthisposting

since 1 divided by 0.8 is 1.25.

The procedure is otherwise exactly the same as for the second task step.

Use the following data:

Customer: 210##

Invoice date: 08.01. of the current year

Reference: 2##

Posting Date: 10.01. of the current year

Amount: 4.000,–

Currency: USD

IndicatorCalculatetax: Set

Note: Tosimplifythings,enterthedocumentwithouttaxesagain

(tax code A0).

EnterthevaluesandswitchtotheLocalcurrencytab. Changethedisplayed

exchangeratemanuallyto/0.8or1.25,inlinewiththeaboveassumption.

ThisprocessisverysimpleifyouusetheF4helpfortheExchangeratefield,

and then maintain the following entry:

1 EUR = 0.80000 X 1 USD

AndthenapplytheexchangeratewiththeF8button.

Continued on next page

205

第 222 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

Caution: YoucanchooseEntertoskipanywarningmessagesdue

tovaluesthatdifferfromthetableexchangerate.

Hint: If the Exchange rate field is not ready for input, you can

specifytheEuroamountof5,000intheAmountinLCfieldonthe

same tab page.

You are now missing the revenue account / credit item for the posting:

EnterG/L account800200in thelower part of theentry screenand enter

“*” to copy the amount of USD 4,000. Because you also want / have to

assign a segment account for the posting, enter profit center1000 in the

corresponding field.

Simulate and save the document.

a) SAP Easy Access menu: Accounting → Financial Accounting →

AccountsReceivable→DocumentEntry→Invoice

5. Now start a customer line item list for your customer 210## to display

the posted open customer invoices.

Optional:If you desire, you can change the layout (of the results list) to

displaytheeffectiveexchangerate(technicalfieldname: 1-KURSE)andthe

referencefield (technical field name: 1-XBLNR) ifthesearenot already

displayed.

Saveyouruser-specificlayout,L##,withnameLayoutGr. ##.

a) SAP Easy Access menu: Accounting → Financial Accounting →

AccountsReceivable→Account→Display/ChangeLineItems

b) Enteryourcustomer210##andyourcompanycodeAA##,andrunthe

programtodisplaytheopenitemsasoftoday’sdate: MenuProgram

→ Execute.

6. Younowhavetoconfigurethesystemforforeigncurrencyvaluation. You

firstmaintain/checktheaccountsyouwanttopostto. Starttheappropriate

Customizingtransactionandperformthefollowingactivities:

=> Select transaction KDF

=> Select chart of accounts INT

=>G/L/reconciliationaccount140000(tradereceivables)

=>TakealookatthelogicalfieldgroupValuationandcheckwhetherthe

following accounts are already stored:

Continued on next page

206

第 223 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

Expenseaccount: Account 230 011

Revenueaccount: Account 280 010

Balance sheet adjustment Account 140 099

account:

Hint: This is a test exercise – please do not change the system

configuration.

Note: Ifyouhadtovaluateforeigncurrencypayablesaswell,you

wouldalsoassignexpense,revenue,andadjustmentaccountstothe

payablesaccount (for example, 160000).

a) Customizing: Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Foreign

Currency Valuation → Prepare Automatic Postings for Foreign

Currency Valuation

b) Gothroughthesameprocedureasdescribedforthetask.

7. Sincedocumentsplittinghasbeenactivatedforyourcompanycode,AA##,

the expense, revenue, and correction accountshaveto be definedasitem

categoriesfor theforeign currencyvaluation. Check whether the entries

230010,230011,280010and140099alreadyexistforchartofaccountsINT.

Ifthisisnotthecase,pleasenotifyyourcourseinstructor.

Hint: This is a test exercise – please do not change the system

configuration.

a) Customizing: Financial Accounting (New) → General Ledger

Accounting(New)→BusinessTransactions→DocumentSplitting→

ClassifyG/L AccountsforDocumentSplitting

8. To start the (new) foreign currency valuation run later, avaluation area

must bepassed on in SAP ERP – regardless of whether or not different

valuationapproachesareneededforparallelfinancialaccounting.

Caution: The valuation area you define now has nothing to do

withdepreciationareasinAssetAccounting; itisavaluationarea

that is defined in FI.

Create aseparate valuation area in FICustomizing. TheID of thenew

valuationareashouldhavetwoletters. Thefirstletterofeverygroupis“L”.

Continued on next page

207

第 224 页 / 共 337 页

Unit5: SelectedPeriodicProcessing AC210

ThisLstandsforlocalinthisexample. Selectthesecondletterforyour

group from the following table:

Group 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18

Letter A B C D E F G H I J K L M N O P Q R

Examples:

Group1receivestheletterA:ThevaluationareaisthereforecalledLA.

Group5receivestheletter5: ThevaluationareaisthereforecalledLEand

so on.

Enterthefollowingdataforthenewvaluationarea:

Area: L# (=> # stands for the second letter from

the above table)

Valuationmethod: Leave blank for now

Crcy type: Company code currency

Add.curr. Leave blank

FS Vers Leave blank or enter INT

LongText: Localvaluationareagroup##

a) Customizing: Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Define

Valuation Areas

9. AlsocreateavaluationmethodinCustomizing. Youwillneedittodefine

how a run is to be valuated. Name your new valuation methodL## and

define it as follows:

Description: Localvaluationforaveragerate,group##

ValuationProcedure: Lowest Value Principle

Document Type: SA

ExchRate Type for

Debit/Credit Bal: Mforboth(=>M=averagerate)

a) Customizing: Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Define

Valuation Methods

Continued on next page

208

Group	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18
Letter	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R

第 225 页 / 共 337 页

AC210 Lesson: (Selected) Periodic Processing

10. Youassignthenewvaluationmethod L##(retrospectively) to yournew