月结作业

FI GL GL Closing Revised by Date revised Page Status 1 of 22 Draft 操作( Operation)： 1. GR/IR automatic clearing 2. 外幣評價(Foreign Currency Valuation) 3. 輸入應計/遞延文件 4. Regroup(Business Area 財務數字調整) 5. 匯率維護 6. FI開關帳控制 7. Carry Forward – Balance(Year end closing) 8. Carry Forward – 分類帳科目(AP/AR) (Year end closing) GR/IR automatic clearing T-Code: F.13 Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Automatic Clearing->Without Specification of Clearing Currency GR/IR account is a GL account with open item. Credit item will be created when GR, and Debit item when IR. 必須使用此功能才能使此open item cleared. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 1 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 2 of 22 Draft Company code, Fiscal year: Posting date: 過帳日期區間(通常一個月處理一次, 所以輸入一個月的區間). Select G/L accounts: 勾選. G/L accounts: GR/IR clearing account. (Ex:215200) Test run: 正式執行記得不要勾選. 執行結果 系統後端的設定是以相同的Assignment + Business Area + Trading partner + Vendor才可以互相沖銷. Assignment就是主檔提到的Sort key field. GR/IR clearing account的預設值為”014” (purchase order) C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 2 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 3 of 22 Draft 系統自動沖銷後(Automatic Clearing), 緊接要執行T-Code: FBL3N看還有哪些open line item尚未被清除(系統有時無法正確辨識能自動沖銷的分錄, 所以要由人工選取可以沖銷的分錄作沖銷). 選取Open items, 日期定在上月月底. For example: purchase order(4520000003) and item number(00010). 其總金額為零(-676600 + 2700 + 405960), 所以這三個分錄可以互沖. 作這個處理可以清楚的知道哪些GR(Goods received)尚未IR(Invoice received). C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 3 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 4 of 22 Draft 執行F-04(Post with Clearing)作沖帳 Account: GR/IR clearing account. Account type: S. Additional selection: Assignment. (其實選取資料的條件可以依據個人習慣, 此處用Assignment是因為這個科目是依此欄位(purchase order)作沖銷判斷) 按下功能鍵”Process open items” C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 4 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 5 of 22 Draft 輸入剛才的採購單號(purchase order + item) 按下功能鍵”Process open items” 結果畫面, 按下功能鍵觀看分錄後過帳. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 5 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 6 of 22 Draft 外幣評價(Foreign Currency Valuation) T-Code: F.05 Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Closing->Valuate->Foreign Currency Valuation 一般外幣評價處理兩種科目: Bank外幣帳戶(一般作已實現損益過帳), AP/AR open items(including GR/IR clearing account, 一般作未實現損益過帳). 執行前應先確定匯率已經維護(T-code: S_BCE_68000174) 外幣評價: Bank外幣帳戶. Company code: Evaluation Key Date: 結帳月份的最後一日. Valuation method: 一般會定義兩種方種方式因應兩種外幣評價, 此處定義為”BANK” or “OPEN”. Valuation in curr. Type: 10(company currency). Creating postings: 勾選才會執行過帳作業. 測試執行時不用勾選. Batch input session name: 與Creating postings聯用, 要勾選並在此指定批次作業名稱, 才會產生批次作業. Reversal posting date, Reverse post period, Reverse postings: 當過帳傳票在次月一號要迴轉時輸入資料(類似未實現損益過帳). C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 6 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 7 of 22 Draft Valuate G/L account open items, Valuate G/L account balances: 總帳科目如有open item control選前者, 否則選後者. G/L account: 外幣帳戶科目. Evaluate GR/IR account: 當科目為GR/IR clearing account時勾選. Valuate P&L accounts: 當科目為損益科目時勾選. 執行 結果報表 按下功能鍵”Postings”預覽過帳分錄 C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 7 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 8 of 22 Draft 傳票僅產生一張且過帳日期為該月最後一號, 通常過帳的科目為已實現匯差. 由於目前系統後端沒有設定過帳調整科目, 所以看不見科目代碼. 外幣評價: AP/AR open items. Valuation method: 選擇OPEN. Batch input session name: 記住批次處理作業名稱. Reversal posting date, Reverse post period, Reverse postings: 不用輸入. 雖說未實現損益在下月應有迴轉分錄, 但open item的外幣評價系統已經會自動在下月產生迴轉分錄, 所以不用輸入. 注意: open item的外幣評價只能作一次, 系統不會幫你檢查是否處理過, 重複作會使你的未實現損益科目的金額增加. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 8 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 9 of 22 Draft 一般分三次處理 AR: 勾選Valuate customer open items.(不用選擇Customer code) AP: 勾選Valuate vendor open items. (不用選擇Vendor code) GR/IR clearing account: 勾選Valuate G/L account open items, Evaluate GR/IR account. G/L account: 輸入GR/IR科目. For example: AR open item.(有選擇客戶代碼是為了方便驗證) 結果報表 按下功能鍵”Postings”預覽過帳分錄 C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 9 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 10 of 22 Draft Open item foreign currency revaluation 會產生兩張傳票, 一張過帳在結帳月份, 另一張為迴轉分錄過帳在次月一號. 使用SM35執行批次作業, 此時傳票才真正立帳. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 10 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 11 of 22 Draft 輸入應計/遞延文件 T-Code: FBS1. Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Closing->Valuate->Enter Accrual/Deferral Doc. 指定Reversal reason以及Reversal date, 其餘輸入與輸入一張總帳傳票相同. 完成後Save. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 11 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 12 of 22 Draft 執行迴轉應計/遞延文件 T-Code: F.81 Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Closing->Valuate->Reverse Accrual/Deferral Document 輸入要迴轉資料的條件, 除了一般的傳票號碼之外, 可以用指定的迴轉日期(Reverse posting date)與使用者名稱(User name)當做選擇條件. Test run: 正式執行時不要勾選. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 12 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 13 of 22 Draft Test run result. 此張迴轉傳票還無法過帳, 因為八月的帳尚未開啟. Regroup(Business Area 財務數字調整), 僅在啟用Business Area時使用. T-Code: F.5D Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Closing->Regroup->Balance Sheet Adjustment->Calculate 因為少數傳票的分錄, 其業務範圍(Business Area)並不一致或是空白, 這會使Business Area的財務數字總和不為零, 系統經由此功能計算各Business Area之間的差額. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 13 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 14 of 22 Draft 輸入公司代碼後執行 由於目前測試環境並沒有啟用Business Area, 所以沒有任何計算結果. 計算完後, 可用人工輸入調整傳票或是執行F.5E讓系統自動調整. 匯率維護 T-Code: S_BCE_68000174 Path: Accounting->Financial Accounting->General Ledger->Environment->Current Settings->Enter Translation Rates 目前已知使用的匯率有平均匯率(M), 海關三旬匯率, 外幣評價匯率. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 14 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 15 of 22 Draft 使用使用或是(複製)來新增匯率 來查詢已存在的匯率 新增匯率 Exchange rate type: Ex:M. Valid From: 從何時生效 Indir.quot: 反向匯率換算.小數點最多五位. From: 從何種幣別換算. Dir.quot: 正向匯率換算.小數點最多五位. To: 到何種幣別. 建議雙向都要輸入, 避免換算時錯誤發生, 本來設定可以改成只輸入單向換算, 但更改原有設定可能會遭到否決. 目前有用到的幣別有NTD, USD, RMB, HKD, EUR, GBP, CAD, NZD, JPY.每種均應維護對公司幣別NTD的換算匯率. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 15 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 16 of 22 Draft 使用來查詢已存在的匯率 輸入Exchange rate type, From currency, To-currency. 依條件整批複製匯率 Selection criteria->By contents C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 16 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 17 of 22 Draft 只要第一次所有幣別的換算匯率均已輸入, 以後可用此方法複製換算匯率 勾選要輸入的欄位: Ex: Exchange rate type, Valid from. 輸入Exchange rate type, Valid from(第一次完整輸入的日期) 按下”Choose” C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 17 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 18 of 22 Draft 全選複製 更改完所有的資料後儲存. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 18 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 19 of 22 Draft FI開關帳控制 T-Code: S_ALR_870032 Path: Accounting->Financial Accounting->General Ledger->Environment->Current Settings->Open and Close Posting Periods 找到與公司代碼相同的代號(Ex: TWHH). 第二行(Account type): +(全部), D(AR), K(AP), M(庫存科目), S(總帳科目). 你可以依照科目控制過帳區間. From period1..To period: 控制實際日期過帳區間.(Ex: 2004/06 – 2004/07, 只有這段期間可以過帳, 通常開放兩個月: 目前月份與上月) From period2..To period: 控制特殊過帳期間. (特殊過帳期間為13-16, 而且其過帳日必須落在十二月) C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 19 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 20 of 22 Draft Carry Forward – Balance(Year end closing) T-Code: F.16 Path: Accounting->Financial Accounting->General Ledger->Periodic Processing->Closing->Carrying Forward->Balance Carry Forward Company code: Carry forward to fiscal year: Test run: 正式執行時不要勾選. 此程式可重複執行. 每當上個會計年度財務數字有調整的時候, 記得要再執行一次此功能. C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 20 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 21 of 22 Draft 執行結果 按下功能鍵觀看科目數字明細 C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 21 of 22 2014/12/18

Prepared by Date prepared Functional area FICO Module Title Herstein Liu 2004/07/21 Version 1.0

FI GL GL Closing Revised by Date revised Page Status 22 of 22 Draft Carry Forward – 分類帳科目(AP/AR) (Year end closing) T-Code: F.07 Path: Accounting->Financial Accounting->Accounts Receivable->Periodic Processing->Closing->Carry Forward->Balance Company code: Carry forward to fiscal year: Select customers: 勾選. Select vendors: 勾選. Test run: 正式執行時不要勾選

C:\\iknow\\docshare\\data\\cur_work\\245523014.doc Page 22 of 22 2014/12/18