System Message while updating Sales Order

[Former Member]

I am getting the following system message when trying to update the children of this item in Item Master Data. I am updating the Wholesale and Purchasing Prices for this product, I have included a [screen shot|http://www.footsolutions.com/_srnsap_30067/system%20message.bmp]

[Former Member · Accepted solution]

Hello Nate,

May I ask you how you update this? Do use a query or do you use the businessobjects.

Update/add with an sqlquery is not allowed by sap support (you could loose your support..).

This looks like an sql error.... Take a look in the SDK helpfile for more info about objects.

Hope this helps,

Regards

[Former Member · Accepted solution]

I update the item master and then send it through the Matrix to update the children.

[former_member583013 · Accepted solution]

I think it is more to do with the AddOn. Please run a SQL trace and see what SQL is hitting the OITW table.

[Former Member]

Hi Nate,

Is there any manual modification in table OITW?

Check if PK ItemCode and WhsCode are dropped. Compare with DemoDB.

Regards,

Jacqueline Jiang

SAP Business One Forums Team

[former_member583013]

Are you using any Matrix AddOn's. How are you updating the Sales Order?

[Former Member]

For table OITW, there is ItemCode plus WhsCode as a primary key. You must somehow try to insert the exact same value twice to that table.

You can run query in OITW table for the itemcode you try to update to check.

Thanks,

Gordon