1. Administering Planning Modules
  2. Configuring Workforce
  3. Configuring Workforce
  4. Configuring Benefits, Taxes, and Additional Earnings
  5. Creating Custom Calculation Logic in a Component
  6. Creating Custom Formulas for OWP_Custom Expense

Creating Custom Formulas for OWP_Custom Expense

Use these tips and the formula examples that follow to help you create custom formulas for OWP_Custom Expense. These tips assume that the application granularity is Employee and Job.

  • Data for properties such as Payment Terms, Payment Frequency, and Value Type are stored at the corresponding Property member > No Currency > Begbalance > Account (Benefit1:10/Earning1:10/Tax1:Tax10) at the Employee and Job combination.
  • Rates are stored at OWP_Value > Currency > Account (Benefit1:10/Earning1:10/Tax1:Tax10) at the Employee and Job combination.
  • Thresholds are stored at OWP_Maximum Value > Currency > Account (Benefit1:10/Earning1:10/Tax1:Tax10) at the Employee and Job combination.
  • You can refer to the provided formulas for evaluating the periods to calculate the expenses based on Cal Tp-Index of the month, corresponding to different Payment Terms options.
  • To add multiple custom formulas, nest them in the OWP_Custom Expense member formula.