Skip to Content
0
Former Member
May 23, 2008 at 08:33 PM

Orders/Quotes/Invoices Not Synching Due To Expenses Not Being Linked

29 Views

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?