I have developed a customized DLL which will convert the planned MRP purchase order into a Sales Order and Purchase order in a multisite company set up

When transferring orders using the DLL, I am getting "Reference error(606)" sporadically even though the reference values (tdsls041.orno refering to tdsls040.orno). are correct. This is not consistent also and it makes debugging difficult. Is there any way to check this scenario?.

Thanks

As soon as the error occurs, look into the log.bshell and log.oracle8 (assuming you are using ORACLE8). It will tell you which reference the program is complaining about, including the data value.

Hope this helps.

Note that it is not only the order number that is a reference, there are many others - customer code, order type, etc. etc. Looking into the log.bshell will point you to the one giving you the problem.