Options

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

rinki123rinki123 Member Posts: 367
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?????????
Regards,

Rinki

Comments

  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    rinki123rinki123 Member Posts: 367
    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..
    Regards,

    Rinki
  • Options
    krikikriki Member, Moderator Posts: 9,098
    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");
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    pitt95pitt95 Member Posts: 8
    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
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    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");
    
Sign In or Register to comment.