Skip to Content
0
Former Member
May 02, 2015 at 05:30 PM

Period data loading - Error " Check that the PERIODID sequence for levels 2 3 is not broken"

82 Views

Hi Experts, I am new to IBP S&OP, am trying to load Period data with below file but I am getting error " Check that the PERIODID sequence for levels 2 3 is not broken'. Please help how to solve this .I have attached the file I am using .

I have period levels as below in my Time Profile

1 Monthly

2 Quarterly

3 yearly

PERIODID PERIODSTART PERIODEND PERIODDESC PARENTID 1410 2014-10-01 2014-10-31 14-Oct 2144 1411 2014-11-01 2014-11-30 14-Nov 2144 1412 2014-12-01 2014-12-31 14-Dec 2144 2144 2014-10-01 2014-12-31 Q4-2014 3014 3014 2014-01-01 2014-12-31 Y-2014 1501 2015-01-01 2015-01-31 15-Jan 2151 1502 2015-02-01 2015-02-28 15-Feb 2151 1503 2015-03-01 2015-03-31 15-Mar 2151 2151 2015-01-01 2015-03-31 Q1-2015 3015 1504 2015-04-01 2015-04-30 15-Apr 2152 1505 2015-05-01 2015-05-31 15-May 2152 1506 2015-06-01 2015-06-30 15-Jun 2152 2152 2015-04-01 2015-06-30 Q2-2015 3015 1507 2015-07-01 2015-07-31 15-Jul 2153 1508 2015-08-01 2015-08-31 15-Aug 2153 1509 2015-09-01 2015-09-30 15-Sep 2153 2153 2015-07-01 2015-09-30 Q3-2015 3015 1510 2015-10-01 2015-10-31 15-Oct 2154 1511 2015-11-01 2015-11-30 15-Nov 2154 1512 2015-12-01 2015-12-31 15-Dec 2154 2154 2015-10-01 2015-12-31 Q4-2015 3015 3015 2015-01-01 2015-12-31 Y-2015