Global SAP Implementation Program - SAP FICO - .doc

Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance will have no further activity Legend Grey highlighted box represents a dormant company SAP Consolidate Units will have no further activity Legend Grey highlighted box represents a dormant company SAP Consolidate Units hence it is irrelevant to FI document type mapping RV SD Invoice Postings of Sales Invoice from SD transactions A Sales Order and delivery need to be completed before Sales Invoice is created in SD RW SD Invoice Interco Postings of Intercompany Invoice from SD transactions A Stock Transport Order STO and delivery need to be completed before Sales Invoice is created in SD RC SD Credit Memo Postings of Credit Memo from SD transactions A Credit Memo Request a special Sales Order Type need to be raised before Credit Memo is created in SD RD SD Debit Memo Postings of Debit Memo from SD transactions A Debit Memo Request a special Sales Order Type need to be raised before Debit Memo is created in SD RR SD Credit for Return Postings of Credit Memo from SD transactions as arose from Return A Return Order a special Sales Order Type and return delivery need to be completed before Credit Memo for Return is created in SD RS SD Rebate Credit Memo Postings of Rebate Credit Memo from SD transactions A Credit Memo Request a special Sales Order Type need to be raised before Rebate Credit Memo is created in SD Number range assignment It links to the number range table below FI document numbers are Fiscal Year Dependent Meaning in interpreting a FI document system always require users to quote the Fiscal Year involved e g FY2004 Doc no 2000000 Account Type This is the SAP code in defining which type of account can be posted to particular type of document This is preset by SAP system in the FI Document Type definitions Here are the SAP Account Types A Asset D Customer K Vendor M Material S General Ledger Reverse Document Type Upon reversal of a particular FI document the system will use this Document Type for the reversal transaction This way certain reversal documents can be separately analysed if needed In standard SAP setting all the reversal document types are the same as original document type Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance ItemVendor GroupRelevant To MM 1Vendors with PO 2Intercompany 3One Time Vendor 4Vendors without PO 5Boards of Directors 6Employees Account Group is used to control the assignment of vendor code and to maintain the consistency of vendor master data to be maintained for the vendors in same account group The vendor groups are mutually exclusive The SAP system can assign vendor codes internally or externally At AAA Bbb vendor codes will be created automatically based on the system numbering sequence The exception will be intercompany vendors that where vendor codes will be externally assigned Regardless of the assignment method specified above the range and format of vendor codes are predefined in customization Any specification of vendor code especially the external assignment beyond the valid vendor code range will not be accepted by the system For global vendors a group key will be placed in their master record to allow single reporting monitoring of all related vendor records in each Branch In SAP the data in vendor master records control how transaction data are posted and processed for a vendor The vendor master record also contains all the data you require to do business with your vendors Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance Asset Details ABT1N Save Document ABT1N Asset Retirement Define Asset Retirement Save Document Month End Asset Transactions Completed Post missing Asset Transactions NO YES Can Retire Asset A With Revenue F 92 B Without Revenue C By scrapping ABVAN Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance Plan Version after Corporate Review Denote the value on different time span e g Plan Version First quarter Plan Version Second Qtr etc The followings are the Plan Versions to be configured for AAA Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance influence account determination by means of account modification Post processing for posting proposals line items which cannot be cleared Note Electronic Bank Statement format SWIFT MT940 is compactable with SAP TR CM Standard algorithm for clearing documents is available in the predefined form in SAP Customisation as stated in point 6 above will be needed to cope with AAA specific requirements on Bank Reconciliation The review task will be performed on the Detail Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance no future postings will be applied All future Elim company postings will be done through SAP s consolidation procedures and manual adjustments will be posted in the Consolidation Ledger 3 13 2 Consolidation Groups This is a user defined group of consolidation units created for consolidation and reporting purposes The key information of a consolidation group is Description Name Correspondence data Consolidation ledger assignment Assignment of underlining consolidation units or consolidation sub groups A list of the consolidation group and units is shown below Cons group subgroup Cons group descCons unitCons unit descParent in group subgroup CG1000AAA Bbb Group1000AAA Corporate USYes 4200AAA Bbb Canada 4500Starprint Corp 3400AAA Bbb France 3500AAA Bbb Hungary 6300AAA Australia CG5100CCHK Cons Subgroup CG3000CC Europe Cons Subgroup UK CG3300CC GMBH Cons Subgroup CG4100CC Cons Subgroup for Keystone Sales CG5100CCHK Cons Subgroup5100AAA Bbb HK LtdYes 5200AAA Henggang 5300AAA Shenzhen CG3000CC Europe Cons Subgroup UK 3100AAA Bbb Europe Ltd UK Yes 3200Goldline Europe Ltd CG3300CC Europe Cons Subgroup GmBH 3300AAA Bbb CC GMBH Yes Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance however the current design is that cash receipts wil be applied manually Asset Management Ref RequirementMust Have Nice to Have Not Import ant Requirement Comments FA 1 Ability to track additions by P O number voucher number asset number or vendor number for a specific range of periods X Not using Dynamics today Assets are tracked in Excel Yes Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance Forecast depreciation for future assets can be set up in IM Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance ControllingApproved by XXXXXXX 3392580ba9a872b5af4a70de7ea96382 pdf Printed on 1 6 2020 8 42 上午上午Page 165 of 168 FA 22Provide a complete audit trail of transactions X Yes FA 23Interface with accounts payable X Yes FA 24Interface with the general ledger X Yes FA 25Provide a retirement register by month asset by Division X Yes FA 26Provide a retirement register by month asset by Department X Yes FA 27Provide a retirement register by month asset by Master account X Yes FA 28Provide a retirement register by month asset by Sub account X Yes FA 29Provide a retirement register by month asset by Product code X Yes FA 30Provide a retirement register by month asset by Retirement type X Yes FA 31Provide monthly and YTD activity reports for Transfers X Yes FA 32Provide monthly and YTD activity reports for Acquisitions X Yes FA 33Provide monthly and YTD activity reports for Sales X Yes FA 34Provide monthly and YTD activity reports for Disposals X Yes FA 35Ability to track vehicle licenses X Yes FA 36Support foreign currency Which ones X Yes FA 37Track leasing info X Yes FA 38Track assets by location state and division for state tax purposes X Yes FA 39Ability to indicate tax exempt status X Yes FA 40Provide asset retirement options such as Fully retire X Yes FA 41Provide asset retirement options such as Partially retire X Yes FA 42Provide asset retirement options such as Retire by units X Yes FA 43Provide asset retirement options such as Retire by cost X Yes FA 44Provide asset retirement options such as Reinstate retired assets X Yes FA 45 Provide asset retirement options such as Current and prior period retire in the same period X Yes FA 46 Ability to provide unique reporting requirements such as Capital budgeting and forecasting features as well as correct net book value for a past period X Capital budgeting and forecasting features To be able to correct net book value for a past period Yes correct net book value for a past period but capital budgeting is managed in the Investments Management module FA 47 Ability to print a report showing accumulated depreciation by a user specified date X Yes FA 48Ability to support property tax registers X Yes FA 49Ability to support physical count process X Yes Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance ControllingApproved by XXXXXXX 3392580ba9a872b5af4a70de7ea96382 pdf Printed on 1 6 2020 8 42 上午上午Page 166 of 168 Cost Management Accounting Ref RequirementMust Have Nice to Have Not Import ant Requirement Comments Product Costing PC 1 Support any all of the following cost types Standard Actual Average Simulated or User defined X Note Product costing is currently being supported by CIS4Yes PC 2Ability to store frozen current and or pending standard costs X Yes PC 3Support regenerative and selective cost generation modes X Need more information PC 4Support inclusion of scrap yield and shrinkage in cost calculations X Yes PC 5Support yield calculations specified by batch and or process X No Need clarification on the meaning of yield calculation PC 6Support cost rollup selectable by cost type or part number X Yes PC 7Support cost rollover selectable by cost type X Yes PC 8Provide the capability to store actual costs X Yes PC 9Support cost updates by all items single items or item class X Yes PC 10 Ability to calculate freight overhead carrying cost etc in actual and standard cost X Yes PC 11 Ability to include freight overhead carrying cost etc in actual and standard cost X Yes PC 12Provide standard cost for labor X Yes PC 13Capture actual cost for labor X Yes PC 14Provide labor variance reporting X Yes PC 15Provide downtime reporting by reason code X No Need more information Cost Reporting PC 16Provide reports for Costed single level BOM X Yes PC 17Provide reports for Costed multi level BOM X Yes PC 18Provide reports for Cost summary X Yes PC 19Provide reports for Cost comparisons X All reports will be addressed after Global SAP Implementation Program Phase OnePrepared by Finance Design Team Conceptual Design Document Finance ControllingApproved by XXXXXXX 3392580ba9a872b5af4a70de7ea96382 pdf Printed on 1 6 2020 8 42 上午上午Page 167 of 168 Conceptual Deisgn Signoff PC 20Provide reports for Product Cost sheet X All reports will be addressed after Conceptual Deisgn Signoff PC 21Provide reports for Cost change report X All reports will be addressed after Conceptual Deisgn Signoff PC 22Provide reports for Cost analysis exception report X All reports will be addressed after Conceptual Deisgn Signoff PC 23Provide reports for Cost generation exceptions report X All reports will be addressed after Conceptual Deisgn Signoff PC 24Provide reports for Item cost reporting X All reports will be addressed after Conceptual Deisgn Signoff PC 25Provide reports for Cost comparisons X All reports will be addressed after Conceptual Deisgn Signoff PC 26Provide reports for Product Cost sheet X All reports will be addressed after Conceptual Deisgn Signoff Variance Reports PC 27Support variance types such as Material usage X Yes PC 28Support variance types such as Material substitution X Yes PC 29Support variance types such as Purchase price X Yes PC 30Support variance types such as Shrinkage X Will be addressed in Detailed Design Stage PC 31Support variance types such as Yield by work order X Will be addressed in Detailed Design Stage PC 32Support variance types such as Component scrap X Yes PC 33Support variance types such as Parent cost adjustment X W