Asset Book Removal

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

  1. Remove individual asset entries (Find out how many to validate the delete rows)
    1. SELECT COUNT(*) FROM PS_ASSET_NBV_TBL ANT WHERE ANT.BOOK = ‘AMT’;
    2. DELETE FROM PS_ASSET_NBV_TBL ANT WHERE ANT.BOOK = ‘AMT’;
    3. SELECT COUNT(*) FROM PS_BOOK B WHERE B.BOOK = ‘AMT’;
    4. DELETE FROM PS_BOOK B WHERE B.BOOK = ‘AMT’;
    5. SELECT COUNT(*) FROM PS_BOOK_HIST BH WHERE BH.BOOK = ‘AMT’;
    6. DELETE FROM PS_BOOK_HIST BH WHERE BH.BOOK = ‘AMT’;
    7. SELECT COUNT(*) FROM PS_COST C WHERE C.BOOK = ‘AMT’;
    8. DELETE FROM PS_COST C WHERE C.BOOK = ‘AMT’;
    9. SELECT COUNT(*) FROM PS_DEPRECIATION D WHERE D.BOOK = ‘AMT’;
    10. DELETE FROM PS_DEPRECIATION D WHERE D.BOOK = ‘AMT’;
    11. SELECT COUNT(*) FROM PS_DEPR_RPT DR WHERE DR.BOOK = ‘AMT’;
    12. DELETE FROM PS_DEPR_RPT DR WHERE DR.BOOK = ‘AMT’;
    13. SELECT COUNT(*) FROM PS_DIST_LN DL WHERE DL.BOOK = ‘AMT’;
    14. DELETE FROM PS_DIST_LN DL WHERE DL.BOOK = ‘AMT’;
    15. SELECT COUNT(*) FROM PS_OPEN_TRANS OT WHERE OT.BOOK = ‘AMT’;
    16. DELETE FROM PS_OPEN_TRANS OT WHERE OT.BOOK = ‘AMT’;
  2. Remove book from BU Definition
    1. Setup Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition
    2. Enter BU > Search
    3. On AM Business Unit Definition tab – Clear ‘AMT Book’ so that it is blank
    4. On the Business Unit/Book Definition tab – Remove the row for AMT using the minus button
    5. Save the definition
  3. Leave Profile information for future use.
    1. Until the Book is added back to the BU, rows will not be created.
    2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.