SQL ERROR in Purchase Invoice Posting

vivek4121
vivek4121 Member Posts: 165
edited 2015-06-30 in NAV/Navision Classic Client
Hi All,

One of our client is facing the below error while posting a Purchase Invoice :
The following SQL error was unexpected. Cannot insert the value NULL into column 'Cancelled', table 'IMP_EME_TRAINING.dbo.DTL$Purchase Line'; column does not allow nulls. INSERT fails. The statement has been terminated.

Can anyone help me in that.

Thanks in advance.

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Why is a posting routine trying to insert "Purchase Line" records? Obviously been customized?

    Have you debugged to determine where the error is occurring? (if not, that's step 1)
    There are no bugs - only undocumented features.
  • sumitnandha
    sumitnandha Member Posts: 3
    Yes, It Must been Customized, table does don't have any field with name Cancelled.

    May It will not occurred in debugger.

    Thank you.
  • bbrown
    bbrown Member Posts: 3,268
    Has someone modified the table and added the "Cancelled" column directly from SQL? Check the table definition in SQL.
    There are no bugs - only undocumented features.
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Probably modified objects. Logging out and in in NAV should solve the problem.
    Tino Ruijs
    Microsoft Dynamics NAV specialist

Categories