Friday, February 5, 2010

Peoplecode Tips

DYNAMIC PROMPTS

  1. Create a dynamic view.
  2. In the required event PeopleCode, do the following
    &SQL1 = "select field1 from Record1 where Eff_date = "|pagefield.effdt;
    &getfield(Record.Fieldname).sqltext = &SQL1
    where getfield will instantiate the field for which the dynamic view is used as a prompt record.

TRANSFER TO ANOTHER PAGE

Local Record &TXFR_ADD_KEYS;

&TXFR_ADD_KEYS = CreateRecord(Record.VCHR_SRCH_VW1);

&TXFR_ADD_KEYS.GetField(Field.BUSINESS_UNIT).Value = PYMNT_ADVICE.BUSINESS_UNIT;

&TXFR_ADD_KEYS.GetField(Field.VOUCHER_ID).Value = PYMNT_ADVICE.PAY_DOC_ID;

Transfer (False, MenuName.CREATE_PAYMENTS, BarName.INQUIRE, ItemName.VOUCHER_INQUIRY, Panel.VOUCHER_INQUIRY, "U", &TXFR_ADD_KEYS);

*******************************************************************************

Transfer to Process Monitor & Application Message Monitor

*******************************************************************************

Transfer ( True, MenuName.PROCESSMONITOR, BarName."INQUIRE", ItemName."PROCESSMONITOR", Panel."PMN_PRCSLIST", "U");

Transfer ( True, MenuName.APPMSGMONITOR, BarName."USE", ItemName."APPMSGMONITOR", Panel."AMM_OVERVIEW", "U");

Peoplesoft AssetManagement

PeopleSoft Asset Management is equipped to use the following different formula-based depreciation methods:

  • Straight Line

  • (IND) Straight Line Percent

  • Declining Balance with a Switch to Straight Line

  • Declining Balance with Depreciation Limit

  • Declining Balance

  • Flat Rate

  • Sum of the Year's Digits


  • Declining Balance with a Switch to Straight Line

Declining Balance with a Straight Line Switch performs two simultaneous equations to calculate yearly depreciation. One equation calculates declining balance depreciation and the other calculates straight line depreciation. PeopleSoft Asset Management then compares the two yearly depreciation amounts and applies whichever is greater.

Note that in this type of calculation the asset’s net book value is multiplied by the declining balance percentage times the straight line depreciation percentage.

NBV x ((Number of Periods to Depreciate / Life) x DB%)


Remaining Value is calculated by the formula:

Remaining Value = Cost - Accumulated Depreciation