Stan? Any update to this:
Thanks for the reply Stan. I've looked into those tables a bit and I found what's causing the problem.
With OPC enabled, when a new order is placed the jos_vm_order_user_info table gets 2 rows, one for each address type (BT,ST). So an order ID appears twice and that probably is what's knocking out the ERP connection.
Here is an image where you can see the first 5 orders (1 from 1 customer and 4 from another) that were made with OPC disabled and then 4 more orders with duplicate entries (user id 169).
http://img15.imageshack.us/img15/5208/josvmuserinfo.pngIs there any way we can stop this from happening? We don't mind loosing some of the features of OPC in order to get this working as it's vital to the company.
thank u.