Skip to Content
0
Aug 31, 2023 at 10:44 AM

Date field Error on Updating Forecast

103 Views

Hi Everyone,

I have a very strange Error here. This is a long one.

I am trying to update a forecast. Here are the files. This is just one as I am trying to fault find. (Please read until the end because I have tried many situations.)

FOCT

image.png

FCT1

image.png

The error is "Date is not the start of the start of the month [FCT1.DATE]" Even though you can clearly see it is.

I save this as a txt file and then choose the update option when importing in DTW.

Using SAP Business One 9.3 (9.30.150) PL: 05 (32-bit) and 32 DTW.

Scenarios I have tried:

1. Change the LineNum to BLANK- Error "Date is not the start of the start of the month [FCT1.DATE]"

2. Change the LineNum to 0 1 2 3 - Error "Date is not the start of the start of the month [FCT1.DATE]"

3. Change the LineNum to 0 0 0 0 - Error "Date is not the start of the start of the month [FCT1.DATE]"

4. Change the LineNum to 1 1 1 1 - Error "Date is not the start of the start of the month [FCT1.DATE]"

5. Changed the End date to the start of the month for OFCT1- Error "Date is not the start of the month [OFCT.ENDDATE]

6. Changed the View to M - Error "Date is not the start of the start of the month [FCT1.DATE]"

7. Chnage the AbsID to ForecastCode - Error "Date is not the start of the start of the month [FCT1.DATE]"

I am completely out of ideas.

Please can someone point out the obvious that I am clearly not seeing?

Thank you.

Attachments

image.png (10.0 kB)
image.png (11.6 kB)