"Invalid Use of Null" when integrating Sales Order Processing transactions with SQL Optimized Adapter Content provided by Microsoft TechKnowledge Content Question:Integrating a Sales Order Processing transaction with the SQL Optimized Adapter and receiving an "Invalid Use of Null" error. With the same source data I am able to integrate the Sales Order Transaction integration with the standard adapter.Answer:Currently in version 6.03 of Integration Manager the SQL Optimized adapter requires multi-currency information to exist. Checklinks on the SOP setup is required so the population of the non-inventory currency information occurs. The integration will use the functional currency for SOP transactions during the integration process.This article was TechKnowledge Document ID: 24683 INTERNAL Article ID : 855836 First Published: : 2/18/2002 Last Revised: : 12/29/2014 Revision : 4.0 Modification Type : Major Language Locale : en-us Article Status : Published Externally Confidentiality : Public Last Updated: 4 Apr 2017 Was this information helpful? Yes No Tell us what we can do to improve the article Submit Thanks! Your feedback will help us improve the support experience.