I tried synching the SAP Demo company with a fresh copy of Web Tools. I'm using SAP B1 PL43 and Web Tools v625. I get about 40-90 errors when trying to synch orders, invoices, and quotes that look similar (if not identical) to this:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OrderExpenses_OrderExpensesMaster". The conflict occurred in database "B1WebTools_SAP_Demo", 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.SBOQuote.SBOToNetPoint(SBOQueueObject qData) at NetPoint.SynchSBO.SynchObjectBase.Synch()
I believe this is related to how the expenses tables are mapped. I used SynchManager's Tables section to define all of the Web Tools codes for the corresponding records from SAP, but I'm not sure if I'm doing it correctly. I also didn't do anything within Web Tools' administration to try to get the synch working. How does this section work? Am I doing something wrong?