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

FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster

8 Views

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

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?