Invalid Field Name Synching Orders Errors
I have upgraded a client from WebTools PL06 to PL11. They are not yet live with WebTools. At the same time we upgraded SAP from 2005 to 2007A SP00 PL35.
We created a new copy of the SAP database as a test DB and ran a initial synch. The synch worked and everything looked good. However, after creating a web order, the Orders cannot synch over to SAP B1. The following error appears in the SynchManager:
Invalid Field Name
at SAPbobsCOM.FieldsClass.Item(Object Index)
at NetPoint.SynchSBO.SBOObjects.SBODocument.NP_2_SBO(Documents& document, NPOrder order)
at NetPoint.SynchSBO.SBOObjects.SBOOrder.NetPointToSBO(NPQueueObject qData)
I have reran the synch plugin, tried different customers and still get the same error. I looked at another thread with the same problem but did not see a solution. From the thread I looked at the OWHS table and did not see a zipcode UDF.
They are using a Valogix substitute add-on, LiveWare, Citixsys Credit Card and True Commerce EDI.
Any suggestions are appreciated.
If memory serves me, the offending field is ORDR.zipcode.
Both Webtools and Citixsys install the UDF "zipcode", except WT installs "ZipCode" and Citixsys installs "zipcode" (different case).
There are two ways to resolve this.
1. Remove the ORDR.zipcode and re add ORDR.ZipCode
2. remove both Citixsys and WT and re install WT before you install Citixisys.