Web Tools Sync Errors

[#1]

Hi Experts,

I am receiving this error on 25 orders in my webtools sync Business One queue detail:

The DELETE statement conflicted with the REFERENCE constraint "FK_ShipmentDetail_OrderDetail". The conflict occurred in database "SDLB1WebTools", table "dbo.ShipmentDetail", column 'OrderDetailID'.

The statement has been terminated.

at netpoint.api.data.DataFunctions.Execute(String SQL, IDataParameter[] parameters, String connectionstring)

at netpoint.api.NPBase.Delete(Boolean logTransaction)

at netpoint.api.commerce.NPOrderDetail.Delete(Boolean logTransaction)

at NetPoint.SynchSBO.SBOObjects.SBODocument.SBO_2_NP(Documents& document, NPOrder order)

at NetPoint.SynchSBO.SBOObjects.SBOOrder.SBOToNetPoint(SBOQueueObject qData)

at NetPoint.SynchSBO.SynchObjectBase.Synch()

Can anyone tell me what I need to do to stop the error messages?

Thanks and Regards

Jon

There is also this error occuring in deliveries:

Can not find NetPoint order for Delivery Document#88251

at NetPoint.SynchSBO.SBOObjects.SBODelivery.SBOToNetPoint(SBOQueueObject qData)

at NetPoint.SynchSBO.SynchObjectBase.Synch()

Edited by: Johnny Yen on Dec 11, 2009 1:34 PM

[Former Member]

If the data to be deleted is having dependence i.e some other data is refered by it then first of all we have to delete the dependent data then only can delete the one needed