Sync Errors

32 Views

I am getting over 2000 of these sync errors. Not sure what to check but nothing from SBO is loading into Ecommerce.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster". The conflict occurred in database "B1WebTools", table "dbo.OrderExpensesMaster", column 'ExpenseCode'.

The statement has been terminated.

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

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

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

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()

Thanks in advance!

Adam Hairston

Sitka Inc.