SQL ERROR in Purchase Invoice Posting

vivek4121

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.

bbrown

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)

sumitnandha

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

Has someone modified the table and added the "Cancelled" column directly from SQL? Check the table definition in SQL.

tinoruijs

Probably modified objects. Logging out and in in NAV should solve the problem.