2212871 – How to Update UDO Data Using DTW

DTW update UDO

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:          UDT.JPG
  • Under Tools → Customization Tools → User-Defined Fields – Management, add several User-Defined Fields for the two tables, for example:        TableStructure.jpg
  • 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.

UDO Data.jpg

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:

AddNewRow.jpg

A. Open DTW, log in to the company.

B. In Step 1 choose Master Data; in Step 2 choose Update Existing Data; in Step 3 select User Defined Data → Objects(UDO) → UDO_MyTable; in Step 4 select the import file.
C. In Step 5, choose the “Source Data” tab, there you can see that there is a ComboBox as shown below: (Select the option as ‘Keep Existing Lines and Add Source Lines’)
ComboBox.jpg DTW UDO
D. Perform the update operation by following next steps. After that you will find that a new row is added for the record with the existing data as well.
2. If you want to update the data by updating an existing row, fill the template with all the rows that exist for that record in the template. Also fill the data on the rows that you want to update as shown in the image and do the following:
UpdateExistingRow.jpg DTW UDO
A. In Step 5, choose the “Source Data” tab, there you can see that there is a ComboBox as shown in the image above: (Select the option as ‘Delete Existing Lines and Add Source Lines’)
B. Perform the update operation by following next steps. After that you will find that the row data is updated for the record and the remaining data is same.
Picture of Trần Văn Sơn

Trần Văn Sơn

Với 18+ năm kinh nghiệm và 50+ dự án thành công, tôi chuyên giải quyết bài toán quản trị từ gốc rễ quy trình và con người. Phương châm của tôi là hướng doanh nghiệp vận hành theo chuẩn SAP B1 toàn cầu, đảm bảo hệ thống vận hành đơn giản, hiệu quả ở hiện tại và dễ dàng nâng cấp, mở rộng trong tương lai.
Thảo luận và chia sẻ kinh nghiệm
Bạn có gặp tình huống tương tự khi sử dụng hệ thống SAP Business One?

Bài có liên quan theo chủ đề đang xem

Scroll to Top