FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster

[Former Member]

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?

[Former Member]

Hi Bonnie-Lynn

Make sure you have your expenses mapped in the synch manager - tables - expenses screen

[Former Member]

Yup - first thing I checked - they are mapped correctly in the Synch.