DTW for Sales Forecast

[Former Member]

Hi Experts,

Good morning.

What is wrong with these CSV files?  When I run Import in DTW, only one record in OFCT table is created.  No FCT1 record is created.

OFCT.csv have 1 record and FCT1.csv have 240 records.

I tried changing values of LineNum from blank to:

• sequential number (unique number per row from 1 to 240),
• sequential number per ItemCode (each ItemCode have the same LineNum like 1 for Oct, 1 for Nov & 1 for Dec.  Numbers 1 to 80 are used since there are 80 ItemCodes), and
• sequential number for each ItemCode (each ItemCode have LineNum 1 for Oct, 2 for Nov & 3 for Dec.  Only numbers 1, 2 & 3 are used in LineNum.

There are no error messages during Import.

Thanks,

Noel

[Former Member · Accepted solution]

Hello,

The error in FCT1 is the year (yyyy).  Should be 2014 and not 2104.

Thanks,

Noel