"Invalid Use of Null" when integrating Sales Order Processing transactions with SQL Optimized Adapter

TechKnowledge Content


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.


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


Article ID : 855836
First Published: :


Last Revised: :


Revision : 4.0
Modification Type : Major
Language Locale : en-us
Article Status : Published Externally
Confidentiality : Public