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.