cancel
Showing results for 
Search instead for 
Did you mean: 

Business One 9.3 PL: 07 incorrect data records with a strange ItemCode in table OITW

0 Kudos

Hello everyone,

in the Business One 9.3 PL: 07 32-bit and 64-bit Client I've found the following error: If you add a new ItemWarehouseInfo with an empty warehouse code to an Items object of the SAP Business One DI API 9.3, incorrect data records with a strange ItemCode are added to the table OITW. The error occured during the exection of a coresuite customize optimizer rule.

Business object: Items

Child object: ItemWarehouseInfo

Property: WarehouseCode

Database Table: OITW

Database Columns: ItemCode (PK, nvarchar(50) Not NULL), WhsCode (PK, nvarchar(8) Not NULL)

The used operating system is Windows 10 and the database system is Microsoft SQL Server 2016. It would be nice to fix that error soon.

Kind regards

Florian

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos
	SAPbobsCOM.Company oCompany = SwissAddonFramework.B1Connector.GetB1Connector().Company;
	SAPbobsCOM.Items oItems = (SAPbobsCOM.Items) oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems);
	
	string itemCode = "A00001";
	oItems.GetByKey(itemCode);
	oItems.WhsInfo.Add();
	oItems.WhsInfo.WarehouseCode = string.Empty;
	if (oItems.Update() != 0)
	{
		StatusBar.WriteWarning(oCompany.GetLastErrorDescription());
	}
ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Mr. Florian Brefeld,

Would you please help to provide the sample code in order to reproduce this issue?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support