SAP FICO 后台配置系列三：Period End Closing.doc

FI后台配置系列三：PERIOD END CLOSING这部分主要是月结要做的内容：分成后台配置和前台操作两部分后台配置：- Valuating - define valuation areas, valuation methods & prepare automatic postings for foreign currency valuations.- Regrouping - define valuation areas, define adjustment accounts for GR/IR clearing for goods recd, invoice not recd etc,- Documenting - define financial statement versions- Reporting - sales/purchases tax returns etc- CarryForwarding - define retained earnings account前台操作：- Check/Count - F.03 Comparison gives a list of differences due to documents not posted etc if any.- Valuate - F.05 foreign currency valuation- Regroup - F.19 GR/IR clearing- Document - audit trails- Report - Balance sheet, Profit & Loss etc- Carrying Forward - F.16 balance carry forward这里这本书里除了以上内容之外并没有任何的其他参考，只好免为其难的自己摸索一下了Valuation外币评估部分系统之中有两类科目需要进行外币评估的- Foreign currency balance sheet accounts, that is, the G/L accounts that you run in foreign currency.The balances of the G/L accounts in foreign currency are valuated.就是一些没有进行open items管理的bs类型的总账科目，如果使用外币记账，需要对bal进行评估- Open items posted in foreign currency.The line items in foreign currency are valuated.进行open items管理的bs类型的总账科目，如果使用了外币记账，需要对行项目进行评估更改记账汇率类型路径：OBA7SAP缺省用exchange rate type: M来value所有的外币行项目，我们察看document type的资料，注意default values这部分里面有个字段是ex. rate type for forgn crncy docs，所有的document type的这个字段都是空白的，这样SAP会用缺省的M来进行记账，如果需要修改的话，可以在这里填入你想要的rate type。见图78定义valuation method路径：OB59系统预先定义了一些valuation method了，可以自己创建一些供自己公司使用，要以Z开头，图79，80在做外币评估F.05的时候需要选择一个valuation method的里面的字段大致说明一下：valuation procedure部分有几种方式lowest value prncpleThe valuation is only displayed if the valuation difference between the local currency amount and the valued amount is negative, that is an exchange rate loss has taken place. The valuation is calculated per item total. Items with invoice reference are viewed together.就是只有汇兑损失的才进行，同一张invoice的items一起评估strict lowest value principleThe valuation is only displayed if, as a consequence, the new valuation has a greater devaluation and/or a greater revaluation for credit entries than the previous valuation.The valuation is calculated per item total. Items with the same invoice reference are viewed together.好像同前一种差不多always valuateIf you select this procedure, revaluations are also taken into consideration.总是进行revalue onlyIf you select this method, the system carries out evaluations only.有盈才评估Example: Foreign curr.Local cur.1 100 USD 150 DEMValuation exch.rate 1.6 +10 DEM Revenue 10 DEM2 -100 USD -150 DEMValuation exch. rate 1.6 (-10 DEM) No valuation due to expenseValuation exch. rate 1.45 5 DEM Revenue 5 DEMresetIf you select this parameter then the open items are valuated at the acquisition price. This way the valuation difference is set to zero. The old valuation method is reset. The account determination is reversed: The revenue that arises is posted to the expense account.这个用来反冲之前做的评估，反冲之后valuation变成0balance valuat.If you select this parameter, open items are balanced per account or group and currency. The balance is valuated according to the valuation method. The valuation difference is posted as an expense or revenue (per account, only revenue OR expense).If you do not select this parameter, the open items are summarized and valuated per reference number. If there is no reference number, each line item is valuated individually. The differences that arise are posted as an expense or revenue (per account, expense AND revenue).如果选择这种这个，open items会基于科目的余额，就是合计来进行评估，差异将会记入预先定义的费用或者收入科目如果没有选中，open items会根据reference number来汇总进行，如果没有reference number的话会单个进行。同样差异将会记入预先定义的费用或者收入科目。Example: 3 line items: A, B and CA Reference number 1 100 USD 190DEMB Reference number 1 30- USD 50-DEMC No reference number 10 USD 15 DEM1) No balance valuation, lowest value principle, spot exchange rate 1.8(没有选中的情况) Total fromA + B70 USD140 DEMValuation difference 14- DEM ( 70 * 1.8 = 126 126 - 140 = - 14) C10USD15 DEMNo valuation, due to lowest value principle ( 10 * 1.8 = 18 18 - 15 = 3)2) Balance valuation, lowest value principle, spot exchange rate 1.8(选中bal. valuation) Total A - C 80USD155 DEMValuation difference = 11- DEM (80 * 1.8 = 144 - 155 = - 11) The total is posted as an expense.3) No balance valuation, revaluation and devaluation, spot exchange rate 1.8 (没有选中的情况，这是always的procedure) Total A + B 70 USD 140 DEM valuation difference14- DEM ( 70 * 1.8 = 126126 - 140 = - 14) C 10 USD 15 DEN valuation difference+3 DEM Postings, expense 14 DEM, revenue 3 DEMpost per line itemNormally the valuation results are posted in a summarized form. If you select this parameter, a line item is generated for each valuated item in the valuation posting as well as in the adjustment account, such as the expense or revenue accountvaluation记账的时候是否为每个评估的科目一个行项目，没有选中会一笔记入费用和收入，不分科目document typevaluation记账的document typeexchange rate determination部分exchrate type for devit balexchrate type for credit bal分别定义科目余额为正负时候使用的exchange rate typedetermine rate from account balanceIf you select this field, the account balance/group balance in the relevant foreign currency is used to determine the exchange rate type.exch. rate type from invoice referenceIf you select this field, the balance per invoice reference number and currency is considered for the exchange rate type determination.lily_google 上传了这个附件：2008-7-24 09:3378.GIF (46.87 KB) 2008-7-24 09:3379.GIF (33.07 KB) 2008-7-24 09:3380.GIF (38.15 KB) 接下去要定义外币评估的automatic posting路径：OBA1这一个KDF, 见图81-83需要为每个需要做外币评估的总账科目定义相关的automatic posting的科目图83分别有realized的科目 loss ,gain是在open items清账时候汇兑差异记账的科目valuation部分是月结外币评估时候用的汇兑差异loss, gain, adjustmentlily_google 上传了这个附件：2008-7-24 09:3481.GIF (33.72 KB) 2008-7-24 09:3482.GIF (22.24 KB) 2008-7-24 09:3483.GIF (27.59 KB) Regrouping - define valuation areas, define adjustment accounts for GR/IR clearing for goods recd, invoice not recd etc路径：OBYP定义GR/IR的调整科目，做balance sheet试算表的时候需要把invoiced but not yet delivered 和delivered but not yet invoiced分出来，这时候就需要做一些regrouping的工作。invoiced but not yet delivered BNGdelivered but not yet invoiced GNB操作也同其他automatic posting一样，见图84-86reconciliation account是vendor的统驭科目，需要为每个统驭科目定义adjustment accountThis account is displayed in the balance sheet/ profit and loss statement together with the account to be adjusted.这个是统驭科目调整科目target accountAccount to which the amount is to be posted and by which the balance of the specified account is to be adjusted.这是统驭科目调整科目的offsetting科目lily_google 上传了这个附件：2008-7-24 09:3584.GIF (24.77 KB) 2008-7-24 09:3585.GIF (24.06 KB) 2008-7-24 09:3586.GIF (22.32 KB) Documenting - define financial statement ver