I had a client who set up their PeopleSoft 9.2 system for the three standard US Asset books (CORP, FEDERAL, and AMT). In their legacy systems there had only been a single book and the tax accountants had then applied all of their fancy formula to calculate FEDERAL and AMT amounts. We were able to obtain rules for the FEDERAL book, but could never get a complete set of rules for AMT. As is normal, the day of conversion arrived and without the answer we needed, we loaded the assets using FEDERAL to populate AMT.
Now fast forward 2 or 3 months on the new software and everything is humming along just fine. The question comes up – ‘Why are we creating entries in the AMT book if we don’t know what the rules are? Isn’t it just making a duplicate of the FEDERAL book?’ Cut to the end of the discussion and the decision is made to remove the AMT book and give the tax accountants something to do at year end.
Which Business Units have AMT book attached?
SELECT BUA.BUSINESS_UNIT, BUA.AMT_BOOK
FROM PS_BUS_UNIT_TBL_AM BUA
WHERE (BUA.AMT_BOOK = ‘AMT’)
ORDER BY BUA.BUSINESS_UNIT
SELECT BB.BUSINESS_UNIT, BB.BOOK
FROM PS_BU_BOOK_VW BB, PS_SP_BU_BK_NONVW A1
WHERE (BB.BUSINESS_UNIT = A1.BUSINESS_UNIT
AND BB.BOOK = A1.BOOK
AND (BB.BOOK = ‘AMT’))
ORDER BY BB.BUSINESS_UNIT
Which assets have entries in the AMT book?
SELECT B.BUSINESS_UNIT, B.ASSET_ID
FROM PS_BOOK B
WHERE (B.BOOK = ‘AMT’)
ORDER BY B.BUSINESS_UNIT, B.ASSET_ID
What other tables that contain ‘Book’ entries should warrant concern and review?
ASSET_NBV_TBL
BOOK_HIST
COST
DEPRECIATION
DEPR_RPT
DIST_LN
OPEN_TRANS
Removal Plan: Validate in DEV/TST environment before applying to PRD
- Remove individual asset entries (Find out how many to validate the delete rows)
- SELECT COUNT(*) FROM PS_ASSET_NBV_TBL ANT WHERE ANT.BOOK = ‘AMT’;
- DELETE FROM PS_ASSET_NBV_TBL ANT WHERE ANT.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_BOOK B WHERE B.BOOK = ‘AMT’;
- DELETE FROM PS_BOOK B WHERE B.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_BOOK_HIST BH WHERE BH.BOOK = ‘AMT’;
- DELETE FROM PS_BOOK_HIST BH WHERE BH.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_COST C WHERE C.BOOK = ‘AMT’;
- DELETE FROM PS_COST C WHERE C.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_DEPRECIATION D WHERE D.BOOK = ‘AMT’;
- DELETE FROM PS_DEPRECIATION D WHERE D.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_DEPR_RPT DR WHERE DR.BOOK = ‘AMT’;
- DELETE FROM PS_DEPR_RPT DR WHERE DR.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_DIST_LN DL WHERE DL.BOOK = ‘AMT’;
- DELETE FROM PS_DIST_LN DL WHERE DL.BOOK = ‘AMT’;
- SELECT COUNT(*) FROM PS_OPEN_TRANS OT WHERE OT.BOOK = ‘AMT’;
- DELETE FROM PS_OPEN_TRANS OT WHERE OT.BOOK = ‘AMT’;
- Remove book from BU Definition
- Setup Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition
- Enter BU > Search
- On AM Business Unit Definition tab – Clear ‘AMT Book’ so that it is blank
- On the Business Unit/Book Definition tab – Remove the row for AMT using the minus button
- Save the definition
- Leave Profile information for future use.
- Until the Book is added back to the BU, rows will not be created.
- As information becomes available, the AMT portions of the profile can still be updated.
You’ll always end up coming through
But you’ll find yourself lost in space now and again