Formulas
Predefined formulas are available for U.S. Federal Financials.
These predefined formulas are available for U.S. Federal Financials.
Predefined Formulas for Purchase Orders Change Order
These predefined formulas are available for U.S. Federal Financials.
|
Forumal Name |
Short Name |
Data Type |
Event Class |
Journal Line Rule |
Amount Field |
Formula |
|---|---|---|---|---|---|---|
| Anticipated Recoveries Formula | ANTICIPATED_RECOVERIES | Number | Purchase Orders | Allotments Anticipated Recoveries Anticipated Resources |
Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Anticipated Recoveries Amount" - "Purchase Order Change Order Reversal Entered Amount") ELSE "Anticipated Recoveries Amount" |
| Anticipated Recoveries Ledger Formula | ANTICIPATED_RECOVERIES_LEDGER | Number | Purchase Orders | Allotments Anticipated Recoveries Anticipated Resources |
Accounted Amount |
IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Anticipated Recoveries Ledger Amount" - "Purchase Order Change Order Reversal Accounted Amount") ELSE "Anticipated Recoveries Ledger Amount" |
| Budget Amount Formula | BUDGET_AMOUNT | Number | Purchase Orders | Federal Purchase Order Budget | Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Budget Amount" - "Purchase Order Change Order Reversal Entered Amount") ELSE "Budget Amount" |
| Budget Ledger Amount Formula | BUDGET_LEDGER_AMOUNT | Number | Purchase Orders | Federal Purchase Order Budget | Accounted Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Budget Ledger Amount" - "Purchase Order Change Order Reversal Accounted Amount") ELSE "Budget Ledger Amount" |
| Commitment Amount Formula | COMMITMENT_AMOUNT | Number | Purchase Orders | Federal Purchase Order Commitments Federal Purchase Order Commitments Prior Year |
Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Commitment Amount" - "Purchase Order Change Order Reversal Entered Amount") ELSE "Commitment Amount" |
| Commitment Ledger Amount Formula | COMMITMENT_LEDGER_AMOUNT | Number | Purchase Orders | Federal Purchase Order Commitments Federal Purchase Order Commitments Prior Year |
Accounted Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Commitment Ledger Amount" - "Purchase Order Change Order Reversal Accounted Amount") ELSE "Commitment Ledger Amount" |
| Unpaid Obligations Amount Formula | UNPAID_OBLIGATIONS_AMOUNT | Number | Purchase Orders | Unpaid Obligations | Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Amount" + "Purchase Order Change Order Reversal Entered Amount") ELSE "Unpaid Obligations Amount" |
| Unpaid Obligations Ledger Amount Formula | UNPAID_OBLIGATIONS_LEDGER_AMT | Number | Purchase Orders | Unpaid Obligations | Accounted Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Ledger Amount" + "Purchase Order Change Order Reversal Accounted Amount") ELSE "Unpaid Obligations Ledger Amount" |
| Unpaid Obligations Prior Year Amount Formula | UNPAID_OBLIGATIONS__AMOUNT_PY | Number | Purchase Orders | Unpaid Obligations Prior Year | Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Prior Year Amount" + "Purchase Order Change Order Reversal Entered Amount") ELSE "Unpaid Obligations Prior Year Amount" |
| Unpaid Obligations Ledger Prior Year Amount Formula | UNPAID_OBLIGATIONS_LDGR_AMT_PY | Number | Purchase Orders | Unpaid Obligations Prior Year | Accounted Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Prior Year Ledger Amount" + "Purchase Order Change Order Reversal Accounted Amount") ELSE "Unpaid Obligations Prior Year Ledger Amount" |
| Unpaid Obligations Prior Year Amount Offset Formula | UNPAID_OBLIGATIONS_AMT_PY_OFF | Number | Purchase Orders | Unpaid Obligations Prior Year Offset | Entered Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Prior Year Offset Amount" + "Purchase Order Change Order Reversal Entered Amount") ELSE "Unpaid Obligations Prior Year Offset Amount" |
| Unpaid Obligations Ledger Prior Year Amount Offset Formula | UNPAID_OBLIGAT_LDGR_AMT_PY_OFF | Number | Purchase Orders | Unpaid Obligations Prior Year Offset | Accounted Amount | IF ("Encumbrance Accounting Transaction Distribution Type" != 'I') THEN ("Unpaid Obligations Prior Year Offset Ledger Amount" + "Purchase Order Change Order Reversal Accounted Amount") ELSE "Unpaid Obligations Prior Year Offset Ledger Amount" |