\New GL Configuration Document

Revision History

Date / Author / Description
09/16/2008 / Nirav Vallabh / Original Configuration Detail Document – Change request 3124

Summary of configuration changes (Change request 3124):

  1. All GL Accounts will need to be ProfitCenter relevant. Field Status Groups will need to be modified to make profit center required in all Balance sheet accounts.
  2. Changed field status group Z005, Z008, Z009 and Z011 to make profit center required field. The remaining field status groups do not need any change because cost object will derive profit centers automatically.
  3. Created a new fields status group Z007 (Trading partner required & Profit center optional) for automatic inter-company clearing account (240050) in all company codes.
  4. Created a new field status group Z006 (Profit center optional) and derive default profit center from FAGL3KEH transaction table. Example is ICA Rollover account 259900 in all company codes.
  1. Review GL accounts mapped in 3KEH transaction and need to copy the relevant entries to a new table. The T8A30 table will be replaced with a new table in the SAP New GL. New transaction FAGL3KEH will be used to define default profit centers.
  2. Added default profit centers for each company codes.
  3. Segments have to define based on the segment reporting requirements and assign them to appropriate profit center. Decision is made to use 1 for Homes and 2 for corporate segments.

ProfitCenter / Company Code / Segment
1003 / 5350 / 1
1004 / 5288 / 1
1005 / 5352 / 1
1011 / 5000 / 1
1015 / 5358 / 1
1020 / 5356 / 1
1022 / 5030 / 1
1055 / 5026 / 1
1060 / 4008 / 1
1064 / 4009 / 1
1071 / 4045 / 1
1072 / 4036 / 1
1123 / 5000 / 1
4854 / 5000 / 1
4855 / 5000 / 1
4947 / 5000 / 1
5166 / 7142 / 1
5167 / 7143 / 1
5168 / 7144 / 1
5169 / 7145 / 1
5170 / 7146 / 1
5195 / 4466 / 1
5196 / 4467 / 1
5197 / 4468 / 1
5198 / 4469 / 1
5256 / 4483 / 1
5265 / 7157 / 2
5266 / 7158 / 2
5267 / 7159 / 2
5268 / 7160 / 2
5279 / 7162 / 2
5280 / 7163 / 2
5269 / 7161 / 1
  1. Configure new GL functionalities – Splitting, GL account mapping, scenarios, document types, posting key field status group, etc.
  2. Activated document splitting by profit center and each document will be balanced by profit center using a zero balance clearing account.
  3. Business transaction variant is assigned to all custom document types.
  4. All GL accounts are mapped to an item category.
  5. Activated real time integration from CO to FI
  6. Copied splitting method 12 to Z12 (Splitting: Customer, Vendor, Tax, Money, Company Code Clearing and follow up costs)
  7. Assigned document splitting rule to business transactions.
  8. Created two new clearing accounts – 235990 for CO to FI clearing account, 235991 for Auto document split clearing account for New GL and 235992 used to post an offset when both AR & AP are posted in one FI document using document “YF”. Then extend this new GL account to all SAP company codes.
  1. Defined default profit centers by company code using FAGL3KEH transaction. This default profit center is used, when the system automatically posts entries to inter-company auto clearing account (240050).
  1. Check validation rules defined for certain project types using GL account sets.
  1. Need to convert/migrate production data into new GL using SAP migration cockpit and this itself is a small project.
  1. Check substitution rules and see whether it can be deleted or need some changes.
  1. Make sure that one company to one company code relationship exists for inter-company transactions. It is a prerequisite for New GL.
  1. Have gone through the financial statement groups with the users and decided that profit center is needed at all financial statement levels. It is also decided that to use a profit center (currently one profit center is defined per company code) belong to the company code for document splitting and existing production interfaces.
  1. As part of blue printing, we identified programs that uses GLT0, GLPCA and GLPCT tables and those programs will be changed to utilize New GL tables.
  1. It is important to make sure that partner profit center field is populated for intra-company transactions.
  1. As part of blue print session, it is decided by the users that we will use auto clearing account in SAP New GL, so that every document will be balanced at profit center level. This will help Centex in the future, in case the division bank accounts are combined to a few.
  1. Test and validate all scenarios mentioned in the unit test script. These scenarios are used in production (SAP) today. New processes defined as part of ACE Financials will be tested as part ACE financials integration testing phase.
  1. It is decided to deactivate classic GL after the end of fiscal year 2009. So transactions will be posted only to the new GL tables from fiscal year 2010.
  1. Use document type “YF” to post both vendor and customer in one FI document using an offsetting balance sheet account. System will use the profit center from the offset account and move it to the open item line item.

Migration and Related Decision Points:

  1. Load New GL migration cockpit in Development
  1. Create migration plan for each fiscal year variant and execute steps mentioned in the cockpit.
  1. SAP will perform scenario validation in unit testing phase and test validation at the end of second integration test cycle.
  1. It is decided to company profit center (defined in SAP production client) to update FI documents as part of SAP New GL migration. This rule is applied only when there is no profit center in FI document.
  1. User will sign off on migration validation at the end of cycle 3 and production cutover. They will compare the GL balance before and after migration activities.
  1. Users will also sign off on integration testing on business transactions (configuration related) at the end of cycle 3 and production cutover.

D01 Client 100 – Change Document Number 3124

The current field status groups for GL accounts are :

G045Goods/invoice received clearing accounts

G052Accounts for fixed asset retirement

G056Amortization accounts

Z001P/L:CostCenter & Internal Order Opt

Z002P/L: Internal Order Required

Z003P/L: WBS Required

Z004ProfitCenter Required (no Cost Object)

Z005B/S: Line Item Text & PRCTR Required

Z006B/S: Line Item Text, TP, PRCTR Optional

Z008B/S: Trading Partner & PRCTR Required

Z009No Cost Obj or Text - PRCTR Required

Z010B/S: Reconciliation accounts

Z011B/S: Cash Operating-Bank&PRCTR Required

Z012P/L: WBS and Realtor Vendor # Required

Z013P/L:CostCenter& Internal Order Required

Z031B/S: Advances/Deposits from Cust-WBS Req



NEWGL_CONFIG1/23Nirav Vallabh. 09/16/08