Changing Cash Flow Staggered Allocations

By default, cash flow staggered allocation is set to four months from the period of purchase. In this example, the staggered allocation is spread to six months by modifying the Add Asset business rule.

  To change a cash flow staggered allocation:

  1. Log on to Essbase Administration Services Console, expand Business Rules, Repository View, Rules, and then select the Add Asset business rule.

  2. Change the variable, cashStaggeredPers to 6 from 4 at the following statement “IF (CashFlowIncidence== –1) |cashStaggeredPers = 6;”

  3. Save the business rule.

  To verify the change:

  1. Open data form 02. New Asset Requests.

  2. Right-click an asset class that has staggered cash flow incidence, such as Machinery and Equipment, and then select Add New Asset.

  3. Enter new asset request details with an Asset Rate of 180000 (and other details of your choice), and then click Finish.

  4. Right-click the new asset line item, and then select Cash Flow Impact.

  5. In the Cash Flow Impact data form, select FY07, and then click GO.

    Verify that the basic cost (180000) has been allocated across six months instead of four, and each month's cash flow is 30000.