Skip to main content

Posts

Showing posts from August, 2016

Defining new Depreciation Bonus and applying to an Asset

In this post we will look into how to setup new depreciation bonus in Asset Management in PeopleSoft and applying it to an asset. First let us setup new depreciation bonus percentage. Defining Depreciation Bonus: Navigation: Setup Financials/Supply Chain -> Product Related -> Asset Management -> Depreciation -> Depreciation Bonus Enter bonus id, short and load description. Deprecation bonus can be in percentage/range. If you want to bonus value in the range, select the check box "Use bonus percentage range" else uncheck this option and enter the value. Acquisition and in-service dates: This will decide whether defined bonus can be applied to an asset or not. Asset inservice/acquisition date should be within the date range defined here, then only system allows to apply this bonus to an asset. Once deprecation bonus is defined, you can open the asset book and goto Tax tab where you can select the bouns and enter the bonus percentage which you w...

PeopleSoft Asset Management Tables

Below is the list of main tables being used in PeopleSoft Asset Management PS_ASSET PS_BOOK PS_COST PS_DEPRECIATION PS_DIST_LN PS_OPEN_TRANS PS_ASSET_ACQ_DETAILS PS_RETIREMENT When new asset has been created then it inserts asset details into PS_ASSET, PS_BOOK,PS_ASSET_ACQ_DETAILS & PS_OPEN_TRANS tables. If the asset has cost then there will be entry in PS_COST table. Once asset has been added, we need to run Depreciation calculation process. System will calculate the depreciation based on details in book and cost details, depreciation entries will be inserted into PS_DEPRECIATION table. Create Accounting entries or closure process will insert accounting entries into PS_DIST_LN table. In case if an asset is retired then an entry will be inserted into PS_RETIREMENT table. Apart from these base tables, there are two main reporting tables being used across AM reports. PS_DEPR_RPT  - This table holds cost and depreciation details break down to individual acc...

PeopleSoft eProcurement to AM

Below is the sequence or process flow for adding an asset from eProcurement: 1. Create Requisition, while creating requisition in Asset information tab, enter BU and profile id. Once after creation and approve the requisition. 2. Run Auto Requisition Selection process to stage the approve requisition data into PO Staging table. 3. Run PO Calculate process 4. Run PO Create process to create Purchase order for the staged data. 5. Approve the requisition and dispatch it. 6. Create Receipt for the dispatched PO:                   In Receipt page select "Interface Receipts" option and save it, this will trigger  RECV_02  PS job. This job  consists  of below process, basically these process will push the data from PO to AM, process the AM staged data and creates assets in AM. PO_RECVPUSH AMPS1000 AMIF1000