Offset Between Two Periods

Description

Allows a user to identify the number of periods between two periods.

Calculation Editor

Options

Input Parameter Values Input Values
Company Column or Literal
Period 1 Column or Literal
Century 1 Column or Literal
Fiscal Year 1 Column or Literal
Period 2 Column or Literal
Century 2 Column or Literal
Fiscal Year 2 Column or Literal
Accounting Interval 12-Period or 52-Period
Only Rollup If Generic Criteria

Examples

Example 1

  1. Design > Calculations > Offset Between Two Periods
  2. Inputs:
    1. Company: Co
    2. Period 1: 6
    3. Century 1: 20
    4. Fiscal Year 1: 17
    5. Period 2: 7
    6. Century 2: 20
    7. Fiscal Year 2: 17
    8. Accounting Interval: 12-Period
  3. Output: 1 (Period 6 of 2017 to Period 7 of 2017 is only a 1 period offset)

Example 2

Imagine the case in a balance table where you may want to show an actual amount if the period meets a certain threshold or a budget amount otherwise. Or let's say that if the period is in a period threshold range you want to show an amount, otherwise you want to show 0.

To solve this problem, you will need a reliable way to count the number of periods between two points:

(century + fiscal year + period)B - (century + fiscal year + period)A

For instance, point A could be the reference period and point B could be the current period.

To perform the Offset Between Two Periods calculation:

  1. Open a table with period information (e.g. Account Balances (F0902))

  2. Click Design | Calculations

  3. Enter Offset Between Two Periods

  4. In the Parameters, enter a static Company, grid column company or blank (for default JDE company)

  5. Enter values for the reference period: Period 1, Century 1, Fiscal Year 1

  6. Enter values for the other period: Period 2, Century 2, Fiscal Year 2

When you run your report, the Offset Between Two Periods column will contain the number of periods between 2 and 1.