I am trying to update the Customer Equipment Card table (OINS) from a UDF that I have created however cannot seem to find the repByIns field inside of the SAPbobsCOM.CustomerEquipmentCards control. To update other fields inside of the table I have just used code similar to the example shown below.
Dim CEC As SAPbobsCOM.CustomerEquipmentCards
CEC.CustomerName = ""
The repByIns field is being used to link different items contained inside of the OINS table together by placing the linked item's insID into the repByIns field. Does anyone know how I can update the repByIns field using the CEC control or will this have to be done using an SQL statement and recordset control.
Yatsea Li replied
Using the property: ReplacedBySN
CEC. ReplacedBySN = 1
Sets or returns the S/N of the replacement equipment (Replaced By S/N) that replaced the equipment of the Replace S/N equipment card. This enables concatenation of replacement equipments.
Field name: repByIns.
This is a foreign key to the CustomerEquipmentCards object.