Date Error on Demand Forecast Entries

Hi:

I’m trying to import data into the MRP Sales Forecast table, which is 99000852 — Demand Forecast Entry.

Unfortunately, I’m receiving the following error upon attempting:  “Forecast Date must have a value in Demand Forecast Entry: Entry No. = 37955: It cannot be zero or empty.”

Below, I have pasted the details of the error message.

I have tried all sorts of ways of formatting the “Forecast Date field” date.

I have even gone the route of just testing an import for only one record.  I’m still having no luck.

I have asked colleagues, experts, and AI to no avail.

I have enabled Allow Record Inserts, Do Two-Step Insert, Allow Record Updates, Validate all fields, Run OnInsert Trigger, and Run OnModify Trigger.

Does anyone have any ideas?

Thanks!

John

If requesting support, please provide the following details to help troubleshooting:

Error message:
Forecast Date must have a value in Demand Forecast Entry: Entry No.=39755. It cannot be zero or empty.

Internal session ID:
f18b4aae-b3df-45e4-8a3f-e12509632d4b

Application Insights session ID:
27fd0d45-3012-4290-bb46-21a73a25ad39

Client activity id:
8c2d6487-5019-41cf-8140-bb177ac524ec

Time stamp on error:
2026-02-22T20:38:47.7671658Z

User telemetry id:
1a05c8f2-c2c5-4df4-8893-fae1086500cc

AL call stack:
“Production Forecast Entry”(Table 99000852).OnInsert(Trigger) line 4 – Base Application by Microsoft version 27.3.44313.46026
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).loadRecord line 15 – Import Export PowerTool by Insight Works version 1.0.8845.1
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).populateFields line 5 – Import Export PowerTool by Insight Works version 1.0.8845.1
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).doAfterImportRecord line 15 – Import Export PowerTool by Insight Works version 1.0.8845.1
“IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).”Integer – OnBeforeInsertRecord”(Trigger) line 10 – Import Export PowerTool by Insight Works version 1.0.8845.1
“IWX IEPT Universal Imp. Exp.”(Page 23067856).doImport line 17 – Import Export PowerTool by Insight Works version 1.0.8845.1
“IWX IEPT Universal Imp. Exp.”(Page 23067856).”acImport – OnAction”(Trigger) line 2 – Import Export PowerTool by Insight Works version 1.0.8845.1