Alexander Jansen

Hi, A few months ago we had an external developer build a NAV-CRM integration solution in Scribe for our business. Today we encountered an error with a single record in our NAV database - unfortunately, the error doesn't state exactly which record failed. I'm pretty confident however it's a human data-entry mistake and would probably be an easy fix, so I would like to get this figured out without having the developer get involved. The Scribe error log: Operation failed. Label: Lookup cat_contractline, Name: cat_contractlineLookup, Message: Dynamics 365 Connector Unable to format the data '' for cat_contractline.cat_subcontractnonew.: Error in calling Operation Query (Lookup Block) When navigating to this block we have the following in place: cat_subcontractnonew equals REPLACE(REPLACE(NAVProd_SubcontractZZFetch.Sub_Contract_No,"Z",""),"V","") cat_subcontractnonew is a decimal field and NAVProd_SubcontractZZFetch.Sub_Contract_No is a string field with values containing a number and in some cases also a letter (e.g. ZZ5, 3.2V). The point of the formula above is to strip away any Z's and V's from this. I'd like to figure out what kind of data could possibly cause Scribe to be "unable to format the data" and throw this error, as in my mind it doesn't make sense this operation should ever fail.