SAP外币评估配置及其操作

【实例简介】
sap外币评估指南 一步一步操作指南 超级有用
shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 定义兑换比率(是比率,不是汇率),我只定义了欧元兑人民币,美元兑人民币,下图的 意思就是未来在录入汇率的时候一个美元兑多少个一个人民币,一百个日元兑多少个一个 人民币,图中我只维护了三种外币兑换关系。随着业务的扩张,可添加。 Table View Edit Goto Selection Utilities System Help q1ge日|沿仍心a Change view "Currencies: Translation Ratios: Overview New Entries邑愿愿 E ExRt From To Valid from Ratio(from) R R012 EUR RME01,01.2012 1:1 2 IPY RME01.01.2012 100:1 2 SD RMB01.01.2012 Entry 1,925 of 1, 927 D RUS erpINS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 ·输入汇率,前台后台均可。汇率我随便写的,不代表实际情况、 Implementation Guide Edit Goto Additional Information Utilities System Help 4日e日沿的8像 Display IMG 3R3I Existing BC Sets &rBC Sets for Activity G Activated BC Sets for Activity RElease Notes Structure 2昌E Set countrie Set Geocoding Currencies 岛⑨ Check Currency Codes 息③ Set Decimal Places for currencies BO Define Standard Quotation for Exchange Rates B o Enter Prefixes for Direct/Indirect Quotation Exchange Rates Bo Check Exchange Rate Types E O Define Translation Ratios for Currency Translation BOEnter Exchange Rates 岛③ Maintain Exchange Rate Spreads B Define rounding rules for currencies B o Define Worklist for Exchange Rate Entr E O Assign Exchange Rate to the Worklist Expiring Currencies E Check Units of Measurement E O Maintain Calendar E 9 Maintain Calendar for Japan Time zones Field Display Characteristics Setting Variants for Help (SAP Library) Mobile Infrastructure PRUS erpINS Table View Edit Goto Selection Utilities System Help Change View Currency Exchange Rates": Overview 2 New Entries冷愿愿愿 E ExRt ValidFrom Indirquot Ratio(from) From Dir. quot. Ratio (to) R01201,02.2012 lEUR=10.00000 I RMB R01201.01.2012 L EUR 15.00000 xxx I RMB R01225,04.2012 1 USD 8.00000 I RMB R01223,04,2012 lUsD=6.000 I RMB R01201.01.2012 LUsD=10.00000X I RMB E-Pos ition.Entry 13,262of13,266 D RUS erpINS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 设置凭证的默认汇率类型,此处因为是学习系统,为了不影响别人的操作,我复制了总账 凭证类型SA,定义为ZZ,在汇率默认值中选择了R012,这样入Z凭证的时候就能按照 R012的汇率进行自动取值。 Implementation Guide Edit Goto Additional Information Utilities System Help Display IMG 3 5-I Existing BC Sets BC Sets for Activity & r Activated BC Sets for Activity H Release Notes Structure SAP Netweav Enterprise Structure Cross-Application Components Auto-ID Infrastructure SAP xApp Resource and Portfolio Management (SAP XRPM) Financial Accounting E Financial Accounting Global Settings o Activate New General Ledger Accounting Fiscal year Document Posting periods Document Number Ranges B Define Document Types 鸟④ Indicate Currency Differences for Partial Payments E o Check Assignment of Document Class to Document Type Le Check Display Authorization for Document Type 鸟④ Validation in Accounting Documents E O Substitution in Accounting Documents B Define Text IDs for Documents D RUS erp INS Table View Edit Goto Selection Utilities System Help 4e的Q日闐心幻③ Change View"Document Types": Details New Entries咱固圖图 Document Type 2z G/L document wih Ex P Number range umber range information Reverse DocumentType AB Authorization Group Account types allowed Special usage ASsets 口 Btch input only Y Vendor v Material YG/L account Control data Default values □ Net document type Exrate type for forgn crecy docs R0]2 Cust/vend check v Negative Postings Permitted □nter- company posts □ Enter trading partner Required durina document entry I Jointventure GADA D RUS erp INS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 对于外币评估,以应收的外币评估为例,会用到以下会计科目,需要自行FS00创建,财 务费用-未实现汇兑收益、财务费用-未实现汇兑损失、财务费用-已实现汇兑收益、财务费 用-已实现汇兑损失、往来应收-换算调整、其他业务应收-客户;应付的外币评估同理,不 同的科目是往来应付-换算调整、其他业务应付-供应商 外币评估 创建评估方法 Implementation Guide Edit Goto Additional Information Utilities System Help 4日e的日闐侣心③ Display IMg 3 5- LI Existing BC Sets d BC Sets for Activity Activated BC Sets for Activity i Release Notes Financial Accounting FInancial Accounting(New) Financial Accounting Global Settings (New General Ledger Accounting (New) Master Data Business Transactions Statistical Key Figures Check/Count Kontrola/vypott Define Valuation Metho 國 Define Valuation Areas Check Assignment of Accounting Principle to Ledger Group B Assign Valuation Areas and Accounting Principles Foreign Currency Valuation rollup SAP D RUS erp INS Table View Edit Goto Selection Utilities System Help Change view Foreign Currency Valuation Methods": Overview New Entries的国愿愿 Foreign Currency Valuation Method 民 Valuation method cription S049 valuation Area again BANK CAM Balance Sheet Revaluation(M Rate) DEMO aluation w/ Exchange Rate Type M IAS1 aluation w/ Exchange Rate Type M FC bal per acct, print LIs, lowest value principl KURS aluation w/ Exchange Rate Type M Z012 Model Valuation Methods 049 valuation area s040 lway evaluation S049 valuation Area s046 S049 valuation Area 49valuation Area Rat 国 Position Entry 1 of 15 D RUS erp INS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 Table View Edit Goto Selection Utilities System Help 回x 4凹@Q昌闐|眢仍③ Change View"Foreign Currency Valuation Methods": Details New entries的固固剧 Valuation method 012 Description Valuation Procedure O Lowest value Principle Group vendors O Strict lowest value principle Group Customers O Always evaluate 口 G/L Valuation Grp O Revalue only v Post per Line Item Document Type Extract Exchange Rate Determination Exch Rate Type for Debit bi D Exchange hedging Exch Rate Type for CreditBal ROl2 Minimum difference E/R Type for Translat O Determine Exch Rate Type from Acct Bal. O Exch rate type from invoice reference D RUS erpINS 如上图,评估方法顾名思义,在外币评估时候会发生借贷分录,借贷均需要指定汇率代 码,我指定为自己的汇率代码R012 ·定义评估范围,新建评估范围,自定义 Valuation,评估方法选择R012,是我之前定义的 评估方法,货币类型选择 Company code Currency,也就是说,非公司代码货币交易对公 司代码货币的影响。(比如外币交易对本位币交易的影响。) Implementation Guide Edit Goto Additional Information Utilities System Help q|日e@e日闐8③ Display IMG 38=I Existing BC Sets Gr BC Sets for Activity &e Activated BC Sets for Actlvity tRelease Notes Structure SAP xApp Resource and Portfolio Management (SAP XRPM BFinancial Accounting Financial Accounting (New) Financial Accounting Global Settings(New) General Ledger Accounting (New) Master Data Business Transactio Planning Statistical Key Figures Periodic Processing Check/Count Kontrola/vypocty valuate E Define Valuation Methods 乌 define val y 9 Check Assignment of Accounting Principle to Ledger Group B O Assign Valuation Areas and Accounting Principles CADA D RUS erpINS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 Table View Edit Goto Selection Utilities System Help 4凹|￠@囟凸聞|拍③ Change View"Valuation Area": Overview New Entries園愿愿 Valuation Area E Valuation Valuation method Crcy type Add. curr R012 Company code currency s040 Company code currency s049 Company code currency Company code currency DEMO Company~ currency DEMO Company code currency Position Entry l of 7 SAP D RUS erpINS 分配评估范围和会计准则,将我刚刚配置的评估范围01指向GAAP会计准则,我曾试图修 改会计准则,但是会在后期外币操作时报错,个人估计该SAP学习系统中系统默认或者帐 套设置已经被设置为GAAP。(仅代表个人想法) Implementation Cuide Edit Goto Additional Information Utilities System Help 0x Display IMG 2 Existing BC Sets BC Sets for Activity G Activated BC Sets for Activity i Release Notes Structure Business Transactions Planning Statistical Key Figures Check/ Count Valuate E Define Valuation Methods E o Check Assignment of Accounting Principle to Ledger Group ssign Valuation Areas and Accounting Principles 7 Foreign Currency Valuation Allocation Document Carry Forward Closing/opening Postings (Specific Countries only Information Syster D RUS erp INS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 Table View Edit Goto Selection Utilities System 一41日必④的日闐仍③ Change View "Assignment of Valuation Area to Accounting Prin 2 New Entries匣區區 Assignment of Valuation Area to Accounting Principl 昂 Valuation Area Ace Dying Ac GAAP GAAP GAAP GAAP IAS LOGA Us GAAP Position Entry l of 7 AP D RUS erpINS 定义评估的自动记账科目,也就是外币评估时,借贷分录如何自动对应到相关科目。 Implementation Guide Edit Goto Additional Information Utilities System help Display IMG 3541 Existing BC Sets r BC Sets for Activity &r Activated BC Sets for Activity RElease Notes B Cross-Application Cor Auto-ID Infrastructure SAP xApp Resource and Portfolio Management (SAP xRPM) Financial ting Financial Accounting (New) Financial Accounting Global Settings (New) General Ledger Accounting(New Master Data Business Transactions Planning Statistical Key Figure Periodic Processing Check/Count valuate s O Define Valuation Methods E 4 Check Assignment of Accounting Principle to Ledger Group B Assign Valuation Areas and Accounting Principles Foreign Currency Valuation B Prepare Automatic Postings for Foreign Currency Valuation E Define Account Determination for Currency Translation D RUS erpINS shorphonbaey@gmail.com 赛跑网 SAPOK爱好者原创 Posting Transaction Edit Goto Extras Utilities System Help Maintain FI Configuration: Automatic Posting -Procedures Group PWA Exchange rate differences Procedures Des cription Transaction Account determ Document Split for Currency Exchange CEX Exch Rate Diff using Exch Rate Key KDB Exchange Rate Dif: Open Items/GL Acct 回 Payment difference for altern currency KDW Payment diff for altern. curr (offset) Internal currencies rounding differences RDF0 SAP D RUS erp INS 选择业务中使用的会计科目表,我的是z012,总账科目,我这里设置的是应收账款 11310101(对应收外币评估的设置)。上面设置:汇率评估实现损:财务费用-已实现汇 兑损失,汇率评估实现益:财务费用-以实现汇兑收益,下面设置分别是,财务费用-未实 现汇兑损失、财务费用-未实现汇兑收益、往来应收-换算调整;同样我们可以为应付账款 等等其他外汇评估进行分别设置。如果贵公司的外币评估包含多个外币, Currency中不 选,不然评估会报错。 Table View Edit Goto Selection Utilities System Help 回x 4ge@Q闐|猫4a Change View "Acct Determination For ol Exch Rate Differences New Entries岛的固岛园 Chart of Accounts 12会计科目表 G/L Account 11310101 change rate difference realized L。ss 66030406 Gain 66030405 Valuation Valloss 1 66030404 Val gain 1 66030403 Bal sheet adj. 1 11310997 SAP D RUS erpINS 【实例截图】
【核心代码】