AX V4 Sales Forecast Upload

Hi, we are trying to upload Sales Forecast Data into AX V4 via ‘Stock management > Periodic > Forecast > Entry > Item’. The original data will be loaded into an excel spreadsheet and then converted into a ‘CSV (Comma Delimited)’ file. My question is - what format should the data be laid out in (what sequence) in the file? (EG. Model, Date, Item, Qty. etc). Any information gratefully received.

Best Regards - Jim

Enter a single line and then create a definition group on the table and export it (whilst creating the import). This will give you the format, and the group means you have already created an acceptable import mechanism. Be careful though, a quick way to ruin your data! Test, test test.