Question:

How does a Period Distribution/Project Cash Flow document automatically update the Budget?

Answer:

Note: In V23, the Period Distribution Doc type was renamed Project Cash Flow and the Period Distribution (PD) workbook was renamed Project Cash Flow (PCF) workbook.

When a Project Cash Flow document is approved, the approval automatically creates and posts a Budget revision document. The Budget revision adjusts any lines that were (re)distributed in the Period Distribution and for which the sum of the distribution does not match the total budget (i.e., the remainder is not zero). The purpose of the Budget revision is that the new budget amount now exactly matches the amount distributed. The remainder on the next Period Distribution will start as zero. Project Cash Flow requires that the work breakdown structure be already defined. Project Cash Flow does not support adding cost codes or account lines. Workflow likely starts with the import of the initial budget and then proceeds to distribution and adjustments.

The automatic Budget revision uses the budget snapshot taken for the Project Cash Flow and has net amount changes for relevant lines.

The pictures below illustrate the following bullets:

  1. The snapshot for the Project Cash Flow workbook is taken when the Microsoft Excel workbook is first opened.
  2. If the workbook has lines that were distributed but have non-zero remainders then a budget revision is created and attached.
  3. For example, two lines were distributed in this worksheet, but have remainders. It is important that no budget changes are generated for lines whose distribution is not changed.
  4. The Budget revision document is already approved. The note is added automatically.
  5. Note below that the snapshot time in the BFA workbook matches the snapshot time on the Project Cash Flow – even though it is created much later.
  6. Note the two adjustments to the budget that correspond to bullet 3.
  7. The adjustments lines are marked with the indicated note and show up in history drill downs.
  8. Automatic Period-Based Budget Revisions are enabled by default.  The feature can be disabled via the BudgetConfig Rule (see KBA-01176).

Additional Comments


KBA-01300; Last updated: February 17, 2026 at 9:00 am;

Related Post