CORP Book SetupFA Setups - CORP Books (Applicable only for Corp book that doesnt have any Tax book attached to it)TasksActivityComments1Basic Set ups1.1Use Fiscal Calendar -> RDA CALENDAR FISCAL YEAR ( Description - RDA CALENDAR FISCAL YEAR)

1.2Create Depreciation/Prorate calendar - >RDAFYMONTHLY (Description - RDA FISCAL CALENDAR) -- Please select Period Suffix as Fiscal

1.3Define Prorate Conventions (Refer Prorate conventions sheet)

1.4Define Corporate Books ( Refer Book Naming convention sheet) Important Note: Pls. verify twice whether Allow Mass Changes and Allow Revaluation are applicable to New Corp Book with the Old Corp Book Setupsa. Select the class as Corporateb. Attach the respective GL SOB similar to the existing FA Corp book.c. Attach the depreciation calendar RDAFYMONTHLY created aboved. Ensure the system defaults the Fiscal Year as RDA CALENDAR FISCAL YEARe. Attach the prorate calendar RDAFYMONTHLY created abovef. Select the current period as JUL-FY-16g. Current Fiscal year should be deafulted as 2016.h. Divide depreciation should be same as existing Corp booki. Rest all the setups(Accounting Rules,Natural Accounts,Journal Categories) should be copied from the respective existing FA Corp book.

2Assign the new book to the categories(check the default rules setup @ the category level) Extract Categories from old asset book in data loader format. Use the query on the shared drive Change the book code name to the new asset book in the extract Change the prorate convention from calendar year equivalents to Fiscal year equivalent in the category extract . (Follow the prorate convention excel sheet ) Ensure that the life is loaded accurately ( Example: years having multiple entries for months 10 years 1 month)

3Take an extract of categories from existing & new FA book and ensure there is no difference. Run the compare query to compare categories in the new asset book with old asset book. Use the query placed on the shared drive Ensure that there is no difference in the number of categories loaded, the prorate convention and life as in the old asset book along with the default accounts.

4Run the dep and close the existing FA book till Jun-2015 -- This will be done by business when we migrate FA to Prod Instance.

5Extract the active assets from the existing FA book as on Jul-15 and prepare Web ADIRun the asset query as placed on the shared drive to extract assets from old asset bookSave the worksheet to the shared driveRun the web adi format query and prepare the web adi templateRename the asset numbers by prefixing with "F" for corporate asset uploadsRename the tags by prefixing with "F" Make sure the Depreciation flag and life are extracted correctly from the old book. Check for couple of assets if the query is accurateMake sure the life in months coulmn in the web adi template is extracted from the useful life field. Check for couple of assets 6Load active assets into new FA book through WEB ADI on Jul-15Change the Prorate convention from RDAFYMONTHLY to RDAFYNXTMN for all those assets having DPIS as 31JUL13.RUN Mass Change to change the prorate convention.Run compare query to check if all assets have been loaded with accurate dataEnsure Original cost, Prorate date, convention, DPIs, Life, Remianing life, acc dep is loaded as in old books and please check the prorate convention also as we have found few assets with DPIS 31JUL13 that has got the prorate convention as RDACYMTHLY instead of RDAFYNXTMN.7Run Depreciation in the month of JUL-CY-15 in the new set of books and validate the results Run the depreciation for Jul in the new set of books(First we need to run the depreciation in soft mode for both old and new corp books and compare the journal entry reserve report for both books,then run the Depreciation in close mode) and valid the accounting entires Validate the YTD depreciation that holds only Jul depreciation8 Transfer the Accounting entries to GL for Jul 20159Reverse the Asset Addition entries in GL in Jul 2015

Tax Book SetUp

FA Setups - Corp books with Tax BooksTasksActivity1Basic Set ups1.1Creation of Fiscal year,Calendars and conventions should have been done already (refer Corp Book Setup Sheet)

1.2Create Corporate book( (refer Corp Book Setup Sheet)

1.3Define Tax Books ( Refer Book Naming convention sheet) a. Select the class as Tax and associate the respective Corp book .b. Attach the respective GL SOB similar to the existing FA Tax book.c. Attach the depreciation calendar RDA MTH CY-FY15 created aboved. Ensure the system defaults the Fiscal Year as RDA FISCAL YEAR CYFY 15 created abovee. Attach the prorate calendar RDA MTH CY-FY15 created abovef. Select the current period as JUL-FY-16g. Current Fiscal year should be deafulted as 2016.h. Divide depreciation should be same as existing Tax booki. Rest all the setups(Accounting Rules,Natural Accounts,Journal Categories, Tax Rules) should be copied from the respective existing FA Tax book.

Compare Asset Categories B/W old CORP and old TAX book4Extract corp catgeories from old corp books and tax catgeories from old tax book. Compare and ensure that all Tax Categories are existing as part of the Corp Categories. ( Ex: Category id 746.000.010.000 existing in Tax Category should also exists in Corp Categories)Follow the category definitions from corp categories - Ex: prorate convention should be as of corp category) Nothing should be changed. Follow corp catgeory definitions

Corp Categories5Assign the new book to the categories(check the default rules setup @ the category level)Load categories from the listing prepared in the Sl No 4. Change the book code name to the new asset book in the extract Change the prorate convention from calendar year equivalents to Fiscal year equivalent in the category extract . (Follow the prorate convention excel sheet )Check if the prorate conventions are already decoded within the query Ensure that the life is loaded accurately ( Example: years having multiple entries for months 10 years 1 month)Check if the issue has been fixed in the query

Corp Category Check6Take an extract of categories from existing & new FA book and ensure there is no difference. Run the compare query to compare categories in the new asset book with old asset book. Use the query placed on the shared drive Ensure that there is no difference in the number of categories loaded, the prorate convention and life as in the old asset book

Tax Categories7Assign the new book to the categories(check the default rules setup @ the category level) Extract Categories from old Tax asset book in data loader format. Use the query on the shared drive Change the book code name to the new asset book in the extract Change the prorate convention from calendar year equivalents to Fiscal year equivalent in the category extract . (Follow the prorate convention excel sheet ) Ensure that the life is loaded accurately ( Example: years having multiple entries for months 10 years 1 month)

Tax Category Check8Take an extract of categories from existing & new FA Tax book and ensure there is no difference. Run the compare query to compare categories in the new asset book with old asset book. Use the query placed on the shared drive Ensure that there is no difference in the number of categories loaded, the prorate convention and life as in the old asset book

Asset Extraction - Preparation of web adi9Ensure that the old corp and old tax book have been depreciated till June 2015.

aExtract assets from old Tax Book - Use the query name "XXX" to extract the assets from the shared drivebExtract assets from old CORP Books Identify the assets that are in sync( All assets created after 31-jul-2013 will be/are in sync) by comparing assets in tax and corp books(a, b) Query or Manual identificationPrepare web adi with the following:

Tax Assets Not in Sync with CORP AssetsLoad asset details from old tax books with Cost = 0, Acc Dep = 0, YTD Dep = 0, dep flag = No for the assets that are not in sync with old corp booksDPIS = Tax original DPISProrate Convention = Will default from catgeory which is now the corp category. The actaul tax value will be updated with new tax book using tax update interfaceLife - same as aboveDep Method = same as aboveProrate date - will default based on conventionLocation FF same as old corp book.Create a unique Location Flexfield for these assets (Update the location , so the spare is loaded as 001. This will enable us to retire all of the assets easily.)Please make a note of the changeUse a default depreciation code for these assetsUse the appropriate clearing accountAdd the 001 value to the Value Set --- RDA_FA_LOCATION_SPARE Tax Assets In Synch with CORP Assets

Details of the tax assets that are in sync must be updated with the corresponding asset details of the corp booksCost = cost of the asset from the old corp book Acc dep = Asset acc. Dep from the old corp book YTD dep = 0, Dep Flag = From Corp asset BookProrate convention = Will default from asset corp catgeory. The actual value will be updated with details from the old tax book using tax update interfaceLife - same as aboveDep Method = same as aboveProrate date - will default based on prorate convention attached to the category

WEB ADI:Two Web Adi worksheets are prepared to upload assets into CORP BooksWeb Adi 1: All Tax Assets that are in SyncAll Tax assets that are not in SyncWeb Adi 2: All Assets from old CORP Books Minus the assets that are in Sync.Check the DPIS and default it to "STL" in the non sync assets while loading into corp books(Eg: tax dep methods are STL, macro and AMT HY and these are not available in corp books)Loading of Assets10Load Assets into new Tax Book Run Wed-adi 1 to upload Tax assets into new corp Books. Check for any errors and fix themRun the inital mass copy to transfer the assets loaded into CORP Book to Tax bookRun Compare Query to check assets between old tax books and new tax booksQuery neededUpdate the Tax book details through Upload Tax Book Interface//All the tax assets loaded in new corp book with 0 value will come in asset additions report with value 0, but most of these assets were retired in the existing corp book.We need to convince business on this or else we need to do mass retirement // For doing mass retirement we should have unique value say our location field should be unique for all these 0 value tax assets. Update the following:DPISOriginal CostCostAcc DepProrate Convention based on Fiscal Values Ex: RDA Monthly for RDACYMTHLYDep MethodUseful LifeVerify data in new Tax books with Old Tax booksIf the query returns 0 records, proceed to next stepRun the Post processRun the Tax update interface to update Depreciation FlagRun the post process11Retire Tax Assets loaded into New CORP Book - Over the month of August Retire the Tax Assets where location spare = 001 and all Tax assets loaded that are not in sync, will be retired.Retire in next month as you can retire assets cretaed in the same month12Load Assets from Old to New CORP BooksThen Upload the Web ADI 2 prepared for corp assets Disable all the Mass copy related check box in NEW Tax Book controls formRun Depreciation in New Corp book for July 2015 and close the bookRun periodic mass copy from New Corp book . None of the corp assets will be transferred as we have disabled the mass copy related check boxes.Run depreciation for New Tax book for Jul 2015 and close the periodEnable the Mass copy related check box in Book controls form for the New Tax Books.Validate the YTD depreciation that holds only Jul depreciation Transfer the Accounting entries to GL for Jul 2015Do not run periodic mass copy in July after the check controls are enabled in Tax book.11Any new assets that needs to be added in July will be added in August 2015 with the correct DPIS = July 2015 and when depreciation occurs, the acc depreciation does a catch up and assets could be copied to New Tax book sthrough periodic mass copy.12Reverse the Asset Addition entries in GL in Jul 2015

Book Naming Convention Naming ConventionSL.NOFixed Assets BooksSet of Books Name Fiscal Change (y/n)New FY Asset BookResponsibilityWork WithstatusFinal ReviewerFinal Review Status1RDA TAX ANZRDA ANZ SET OF BOOKSYesRDA ANZ TAX FYMuraliSriniGeeta2RDA CORP ANZ2RDA ANZ SET OF BOOKSYesRDA ANZ CORP FYMuraliSriniGeeta3RDA CORP TWNRDA TW SET OF BOOKSYesRDA TWN CORP FYMuraliSriniSrini4RDA TAX DEURDA EURO SET OF BOOKSYesRDA DE TAX FYShankar MurthyMuraliSrini5RDA CORP DEURDA EURO SET OF BOOKSYesRDA DE CORP FYShankar MurthyMuralisrini6RDA TAX US FEDRDA US SET OF BOOKSYesRDAUS FEDTAX FYShankar MurthyMuraliGeeta7RDA TAX US ACERDA US SET OF BOOKSYesRDAUS ACETAX FYShankar MurthyMuraliGeeta8RDA TAX US AMTRDA US SET OF BOOKSYesRDAUS AMTTAX FYShankar MurthyMuraliGeeta9RDA CORP USARDA US SET OF BOOKSYesRDA US CORP FYShankar MurthyMuraliGeeta10RDA CORP SGNRDA SG SET OF BOOKSYesRDA SGN CORP FYThiruSriniSrini11RDA CORP BGRRDA BG SET OF BOOKSYesRDA BGR CORP FYThiruSundarSrini12RDA CORP CANRDA CA SET OF BOOKSYesRDA CA CORP FYShankar MurthyMuraliSrini13RDA CORP NLDRDA EURO SET OF BOOKSYesRDA NLD CORP FYThiruSundarSrini14RDA CORP UKCPRDA UK SET OF BOOKSYesSundarNo active assets to upload15RDA CORP CHFRDA CH SET OF BOOKSYesRDA CHF CORP FYThiruSundarNo active assets to upload16RDA CORP THNRDA TH SET OF BOOKSYesSriniNo active assets to uploadNo Journal entries in production from Jan1517RDA CORP HKGRDA HK SET OF BOOKSYesSrini7 active assets with 0 valueNo Journal entries in production from Jan1518RDA PH CORPRDA PH SET OF BOOKSYesSriniNo active assets to uploadNo Journal entries in production from Jan1519RDA CORP PRCNRDA PRC SET OF BOOKSYesSrini2 active assets with 0 valueNo Journal entries in production from Jan1520RDA CORP BENRDA EURO SET OF BOOKSYesMuraliNo active assets to uploadLatest opened period - MAR-CY-1521RDA CORP INRDA IND SET OF BOOKSYesMuraliWill check with Rajesh/Marcel22RDA CORP CZKRDA CZ SET OF BOOKSNo23RDA CORP SLKRDA EURO SET OF BOOKSNo24RDA CORP HUNRDA HU SET OF BOOKSNo25RDA CORP PLNRDA PL SET OF BOOKSNo26RDA PLN TAXRDA PLN TAX SET OF BOOKSNo27RDA CORP RMNRDA RM SET OF BOOKSNo

Prorate ConventionsCommentsPRORATE_CONVENTION_CODEDESCRIPTIONFISCAL_YEAR_NAMEDEPR_WHEN_ACQUIRED_FLAGLAST_UPDATE_DATELAST_UPDATED_BYCREATED_BYCREATION_DATELAST_UPDATE_LOGINATTRIBUTE1ATTRIBUTE2ATTRIBUTE3ATTRIBUTE4ATTRIBUTE5ATTRIBUTE6ATTRIBUTE7ATTRIBUTE8ATTRIBUTE9ATTRIBUTE10ATTRIBUTE11ATTRIBUTE12ATTRIBUTE13ATTRIBUTE14ATTRIBUTE15ATTRIBUTE_CATEGORY_CODEDO NOT USERDAMONTHLYRDA MONTHL AT START OF MONTHRDA FISCAL YEAR CY-FY 15YES04/14/2015 16:25:1528,562.001,027.0005/04/2000 03:01:5252,022,973.00DO NOT USERDAHALFYRRDA HALFYEAR GERMANYRDA FISCAL YEAR CY-FY 15YES04/19/2001 05:28:001,166.001,166.0004/19/2001 05:28:00499,516.00DO NOT USERDANXTMONRDA MONTHLY AT START OF NEXT MONTHRDA FISCAL YEAR CY-FY 15YES09/19/2001 19:45:021,003.001,003.0009/19/2001 19:45:021,167,752.00DO NOT USERDAHALFMONRDA MONTHLY AT MIDDLE OF MONTHRDA FISCAL YEAR CY-FY 15YES11/05/2001 07:19:485,210.005,210.0011/05/2001 07:19:481,456,854.00DO NOT USERDAACTMONRDA JAN-DEC ACTUAL MONTH - FOR CHINARDA JAN-DEC FISCAL YEARYES11/13/2001 03:53:352,146.002,146.0011/13/2001 03:53:351,510,199.00DO NOT USERDACZYEARCZ TAX YEAR PRORATE CONVENTIONRDA JAN-DEC FISCAL YEARYES12/21/2001 05:47:555,542.005,542.0012/21/2001 05:47:551,757,539.00DO NOT USERDACZMONRDA CZ MONTHLYRDA JAN-DEC FISCAL YEARYES05/20/2009 10:15:497,364.005,542.0012/21/2001 05:59:5625,841,533.00DO NOT USERDABEGYEARRDA DEPRECIATE BEGIN YEAR (PT & SP)RDA FISCAL YEAR CY-FY 15NO04/14/2015 15:08:3128,562.006,091.0009/11/2002 06:51:0752,022,973.00DO NOT USERDA SKYRRDA SK FULL YEAR (ADDITION 100%)RDA JAN-DEC FISCAL YEARYES05/20/2009 10:14:147,364.001,461.0005/18/2004 08:07:2525,841,533.00DO NOT USERDA SKHAYRRDA SK HALF YEAR (ADD.& RET. 50%)RDA JAN-DEC FISCAL YEARYES05/18/2004 08:09:061,461.001,461.0005/18/2004 08:09:067,746,024.00DO NOT USERDA SKRETRDA SK RETIREMENT USED ASSETS YR1&LASTRDA JAN-DEC FISCAL YEARYES05/18/2004 08:10:521,461.001,461.0005/18/2004 08:10:527,746,024.00DO NOT USERDACY1/2MHRDA CY - MONTHLY AT MIDDLE OF MONTHRDA CY CALENDARYES03/15/2010 13:53:509,483.009,483.0003/15/2010 13:53:5029,494,559.00DO NOT USERDACY1/2YRRDA CY - HALF YEAR CONVENTIONRDA CY CALENDARYES03/15/2010 13:55:299,483.009,483.0003/15/2010 13:55:2929,494,559.00DO NOT USERDACYBGCYRDA CY - BEGIN CALENDAR YEARRDA CY CALENDARYES03/15/2010 13:58:109,483.009,483.0003/15/2010 13:58:1029,494,559.00DO NOT USERDACYMTHLYRDA CY - AT START OF MONTHRDA CY CALENDARYES04/15/2015 12:34:5628,562.009,483.0003/15/2010 14:02:3052,023,073.00DO NOT USERDACYNXTMHRDA CY - MONTHLY AT START OF NEXT MONTHRDA CY CALENDARNO09/23/2010 04:47:3616,517.009,483.0003/15/2010 14:11:3532,252,586.00DO NOT USERDACZCYMONRDA CZ MONTHLY FOR CY YEARRDA CY CALENDARYES03/15/2010 19:29:1412,665.0012,665.0003/15/2010 19:29:1429,497,124.00DO NOT USERDAMTHLYRDA MONTHLY MEXICORDA JAN-DEC MXYES12/20/2002 10:46:026,091.006,091.0012/20/2002 10:46:024,298,778.00DO NOT USERDANEXTMTHRDA MEXICO NEXT MONTHRDA JAN-DEC MXYES12/27/2002 13:08:106,091.006,091.0012/27/2002 13:08:104,321,533.00DO NOT USERDABGCYRDA BEGIN CALENDAR YEARRDA FISCAL YEAR CY-FY 15YES09/27/2007 10:15:297,364.007,364.0009/27/2007 10:15:2919,640,166.00DO NOT USERDANXMONTHRDA NEXT MONTHRDA JAN-DEC FISCAL YEARYES12/12/2011 15:59:5419,418.0019,418.0012/12/2011 15:57:2738,087,864.00DO NOT USERDACYNXTRDA MONTHLY AT START OF NEXT MONTHRDA CY FISCAL YEARYES09/23/2010 04:46:5316,517.0016,517.0008/03/2010 02:19:2132,252,586.00

Newly CreatedUseRDAFYMTHLYRDA FISCAL YEAR CY-FY 15YesUseRDAFYHLFYRRDA FISCAL YEAR CY-FY 15YesUseRDAFYNXTMNRDA FISCAL YEAR CY-FY 15YesUseRDAFYHLFMN RDA FISCAL YEAR CY-FY 15Yes

CalendarsASSET CALENDARDEPRECIATION CALENDARRDAFYHLFMNRDAFYHLFYRRDAFYMTHLYRDAFYNXTMN

Query NamesShared Drive:

QATCalendarASSET CALENDAR

RDA CALENDAR FISCAL YEAR RDA CALENDAR FISCAL YEAR RDAFYMONTHLYRDAFYMONTHLY ASSET CALENDARDEPRECIATION CALENDAR

RDAFYHLFMNRDAFYHLFYRRDAFYMTHLYRDAFYNXTMN

Sheet1Allow purge option not selected at book controls