Tyson Moore

Consultant, Developer, Volunteer

how to retire an asset that is in Transfer status in Peoplesoft asset management

January 13th, 2010 by Tyson No comments »

We have an asset in Transfer status with some balance on it. How do I retire this asset?
Suggestions please

I’d be happy to help. I need some additional information, though. When you say that the asset is in Transfer status but has a balance on it, do you mean that someone performed a partial transfer on the asset, thus leaving the balance? Or was the transfer somehow corrupted and accidentally left a balance in the old cost center/BU?

I believe it’s a partial transfer and thus leaving balance.

If the partial transfer was within the same business unit, PeopleSoft will want to fully retire the asset, or partially retire both “parts” of the asset. This is because this is still technically one “asset”, just split between cost centers. The only way I would know how to fully “retire” part of the transfer is to go in and perform a cost adjustment on the line you wish to “retire.” Adjust it all the way down to zero and create the retirement entries manually in the GL.

If the partial transfer was an interunit transfer, you should just be able to go to the Retire page and fully retire the asset in question.

…

A great response by kettbs on IT Toolbox to this question:

If you did a partial transfer of cost from one asset to another both assets should be in a status of “In Service”. If you have an asset that has cost and/or depreciation and is in the status of “Transfered”, there is an issue with the asset. Normally the issue maybe be caused by an adjustment to the cost of the asset such as adding additional cost. Review the cost tables and all the chartfields including the Chartfield Sequence Number Field and Activity Switch field. Determine if the chartfield information is the same for all entries in the cost and depreciation tables. (this includes, dept, projects, etc.).

Once you have determine which fields the cost is in, add a new asset for .01 with the same chartfield information that the original assets has. Run depreciation and then transfer the .01 asset to the original asset. Because you are transferring cost back into the asset with the same chartfields this process should change the status of the asset to “in Service” and you should be able to retire it (after running depreciation calculation.) This does not require any SQL’s it is all manual.

Share and Enjoy:

No comments »

Posted in Asset Management, PeopleSoft

Asset Management – Remaining Life

January 12th, 2010 by Tyson No comments »

I had a request to create a query that would return an asset’s remaining life from PeopleSoft Asset Management 9.0. This presumes you have loaded the PS_ASSET_NBV_TBL (asset NBV table) for the asset, that you are running it as VP1, and the Run ID used is NBV. Obviously you should change these variables to match your current configuration.

SELECT A.BUSINESS_UNIT, A.ASSET_ID, A.BOOK, A.IN_SERVICE_DT,
A.BEGIN_DEPR_DT, A.LIFE,
CASE
WHEN A.LIFE-(COUNT(D.ACCOUNTING_PERIOD)+((C.END_DT-A.BEGIN_DEPR_DT)/
     (C.END_DT-C.BEGIN_DT))-1) < 0 THEN 0
ELSE A.LIFE-(COUNT(D.ACCOUNTING_PERIOD)+((C.END_DT-A.BEGIN_DEPR_DT)/
     (C.END_DT-C.BEGIN_DT))-1)
END AS REMAINING_LIFE
FROM PS_BOOK_CUR_VW A, PS_BU_BOOK_TBL B, PS_CAL_DETP_TBL C,
     PS_CAL_DETP_TBL D, PS_SET_CNTRL_REC T
WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
AND A.BOOK = B.BOOK
AND A.BUSINESS_UNIT = T.SETCNTRLVALUE
AND T.REC_GROUP_ID = 'FS_02'
AND T.RECNAME = 'CAL_DETP_TBL'
AND C.SETID = T.SETID
AND B.CAL_DEPR_PD = C.CALENDAR_ID
AND D.SETID = T.SETID
AND B.CAL_DEPR_PD = D.CALENDAR_ID
AND A.BEGIN_DEPR_DT >= C.BEGIN_DT
AND A.BEGIN_DEPR_DT <= C.END_DT
AND D.END_DT >= C.END_DT
AND D.END_DT <= (SELECT DISTINCT N.AS_OF_DATE FROM PS_ASSET_NBV_TBL N
     WHERE N.OPRID = 'VP1' AND N.RUN_ID = 'NBV' AND A.BOOK = N.BOOK)
GROUP BY A.BUSINESS_UNIT, A.ASSET_ID, A.BOOK, A.LIFE, A.IN_SERVICE_DT,
     A.BEGIN_DEPR_DT, C.END_DT, C.BEGIN_DT
ORDER BY A.BUSINESS_UNIT, A.ASSET_ID, A.BOOK;

Note: The SQL hasn't been performance tuned yet. I will post ways to tune this SQL, or appropriate indexes for the tables referenced, once I have them identified.

Share and Enjoy:

No comments »

Posted in Asset Management, PeopleSoft

Tags: peoplesoft asset management remaining life sql

IRS Form 990 for non-profits

January 12th, 2010 by Tyson No comments »

I finally got the Delta Sigma Phi Alpha Upsilon ACB books all caught up from my transition with our previous treasurer, which was at the beginning of 2008. Since I couldn’t file the 2008 Form 990 until I had the books caught up and audited, I just got it sent out to the IRS.

I filed our 2007 Form 990 immediately after my transition as the new treasurer, and although it was a bit complicated, I worked through it eventually. Unfortunately the IRS decided to completely redesign the form for the 2008 tax year, adding several additional requirements, making the entire process much more difficult for a non-CPA to complete.

So what’s the impact? For me, a little more frustration trying to abide by federal laws and submit our Form 990 on time (and accurate, I might add). But for the rest of the non-profit world out there that can’t afford to hire a professional accountant to do their taxes every year, I think it’s a step in the wrong direction. Instead of making their forms more user friendly and understandable to the common American, they are creating long, ambiguous, and complicated forms that will cause more organizations to: incorrectly file, file late, not file at all, or be forced to dissolve their organization.