Symptom
How to update UDO data using DTW
(or)
When updating UDO from DTW/DIAPI/B1i , you receive Unknown error -1005 !65171,
Solution
How to create UDO:
1. You are using SAP Business One 8.82 PL13 or higher; SAP Business One 9.0 PL06 (Version for MS SQL) or higher; 9.0 PL03 (Version for HANA) or higher; or SAP Business One 9.1.
2. You have created User-Defined Tables and User-Defined Fields, and have registered the User-Defined Object as follows:
- Under Tools → Customization Tools → User-Defined Tables Setup, add two User-Defined Tables, for example:
- Under Tools → Customization Tools → User-Defined Fields – Management, add several User-Defined Fields for the two tables, for example:
- Under Tools → Customization Tools → Objects Registration Wizard, add a new object by following these steps:
- In step Modifying Basic Settings, enter a Unique ID (“MyTable” for example), Name(should not be empty), Type and choose Table Name “MYTABLE_HEADER”. Choose Next.
- In Step Modifying Services, choose any service you like, and then choose Next.
- In Step UI Settings, select the Default Form checkbox and select Header Line Style. You can check in Menu Item and put it in any Menu ID, for example Sales – A/R.
- Configure the next steps.
- In step Linking Additional child user tables, select the object “MYTABLE_ROW”, and then choose Next.
- In step Modifying fields for a child table default form, select the form “MYTABLE_ROW” and select several fields. Choose Next, then Finish.
- Now you can open the User-Defined Object “MyTable” in the Sales – A/R menu.
Note:
a. If you are using 9.1 PL10 or below,UDO Code and the UDO Name of the UDO should be the same.
b. UDO names including spaces and brackets cannot be handled by DTW. You will receive an error “Unknown error -1005 !65171”. (This applies to all SAP Business One Versions)
Pre-requisite before data preparation:
Create the template choose “Templates → Generate UDO Templates” and select the relevant objects beginning with UDO_.
Note:The UDO_ templates are based on UDTs. You create separate templates for the parent and the child UDTs each time selecting the parent/child UDO_ object.
1. If you want to update UDO data by adding a new row, fill the template with the new row details that you want to add as shown in the image and perform the following:
A. Open DTW, log in to the company.