System.Exception MethodName SendPostRequest, WebException Invalid column name 'U_status1'.

System.Exception MethodName SendPostRequest, WebException Invalid column name 'U_status1'.

Environment:  

iVend 6.6 with SAP B1

Problem statement:  

System.Exception MethodName SendPostRequest, WebException Invalid column name 'U_status1'. At ReplicationSBOIntegrationWinSer.IntegrationObjects.Base.IntegrationBase.SendPostRequest(List 1 listOfQueries, String isStoreProc)

 

​Symptoms : 

U_DCTOENC" is a 'Document' type user table that contains few Standard fields.Status field is already created by SAP as a standard field in the same table if incase user created another "u_status" field in the same UDT  which is not recommended.
 
so in that table "Status" and "U_Status" are two fields and therefore it is causing issue.

 

Resolution/Work Around: 

Delete the "status" field in User defined Fields Management from the DCTOENC table.

Recommendations /Suggestion:  

It is recommended to do not create any field that is part of standard fields.