Skip to Content
Former Member
Jun 12, 2009 at 06:20 PM

FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster


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

The SBO orders and quotes will not synch up with the Web. The additoinal expenses on closed orders is causing the issue. In open orders or quotes - if I delete the additonal expenses - it will synch.

Any thing fancy to try?