How to set a FSG report that adjustment period can auto add into previous period in 16 periods ledge
We need to set a FSG report that period compare with previous period, but the ledger calendars is 16 month(i.e. Jan-17, Feb-17, Mar-17, Adj1-17, Apr-17...). We need to auto add adjustment period into previous period, for example:
Jan-17 Feb-17 Mar-17 Adj1-17 Apr-17
Account1 100.00 110.00 120.00 12.00 130.00
-----------------------------------------------------------
Case 1: POI is Feb-17:
Feb-17 Jan-17 Diff
--------- --------- ---------
Account1 110.00 100.00 10.00
-----------------------------------------------------------
Case 2: POI is Mar-17:
Mar-17 Feb-17 Diff
--------- --------- ---------
Account1 132.00 110.00 22.00
-----------------------------------------------------------
Case 3: POI is Apr-17:
Apr-17 Mar-17 Diff
--------- --------- ---------
Account1 130.00 132.00 -2.00