Date Error Message???????????

rinki123

Ques:Whenever I raise a Sales Order a message has come on the screen,
You cannot base a date calculation on an undefined date.
Date:OD
Formula:

Why this is happening?????????

Luc_VanDyck

Try enabling the debugger and raise the Sales Order again. Then you know what code is causing this message.
Somewhere a Date Formula of 0D is used, but the question now is on which record & field.

rinki123

Luc Van Dyck wrote:

Try enabling the debugger and raise the Sales Order again. Then you know what code is causing this message.
Somewhere a Date Formula of 0D is used, but the question now is on which record & field.

hi thanx for the reply , if i am enabling the debugger it taking me to

Sell-to Customer No. - OnValidate()

but i am nott able to trace the error..
any suggestion..

kriki

Put "Breakpoints on trigger" to false before enabling the debugger. Then do what you need to do to get the error.
The debugger will stop on the error.

Probabily it will be something like "Some Date" := CALCDATE(dateformula,"Some Other Date");

pitt95

I got the same error message by using XMLPort to import Sales Oder.

Payment Terms Code - OnValidate()

IF xRec."Payment Terms Code" = "Prepmt. Payment Terms Code" THEN BEGIN
IF xRec."Prepayment Due Date" = 0D THEN
"Prepayment Due Date" := CALCDATE(PaymentTerms."Due Date Calculation","Document Date");
VALIDATE("Prepmt. Payment Terms Code","Payment Terms Code");
END;

Any idea on how to fix this? Thanks

mohana_cse06

You can try by changing the code to

IF (xRec."Prepayment Due Date" = 0D) AND
  (FORMAT(PaymentTerms."Due Date Calculation") <> '') 
THEN
  "Prepayment Due Date" := CALCDATE(PaymentTerms."Due Date Calculation","Document Date");