x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 138 subscribers
  • Views 790 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
209
topics
410
replies
Sage Intelligence Reporting
121
topics
322
replies
davidy

Importing template to custom simple object causes duplication of detail records

Posted By

hi everyone

i have been created  a custom  head/detail tables and the object, windows,screen,funtion, and it work good.

head table:ZPACKH, detail table:ZPACKD

ZPARKH -> index: ZPKID + FCY

ZPACKD  -> index:ZPKID+VCRLIN

i can creation / update / delete records succful 

then i create the import/export template and export one record :

H;TST22050039;FCY1001;alice;danny;2022-07-07;CUS004741
D;1000;ITM1031;456

i change the exported file and change to 

H;TST22050039;FCY1001;jason;danny;2022-07-07;CUS004741
D;1000;ITM1031;123

import the file is successful, but i found deatil data was duplicated。head table was be update normal

H;TST22050039;FCY1001;jason;danny;2022-07-07;CUS004741
D;1000;ITM1031;456
D;1000;ITM1031;123

could anyone help me how to update deatil data? 

thanks al lot

Parents Reply
  • 0 in reply to davidy

    Good day, do you have the mapping correctly setup on your custom object, on the import section you need to define which screen is linked to header and which is linked to the details with line indicator. I suspect the supervisor does not load your line into the screen, hence why it gets duplicated. 

Children
No Data

*Community Hub is the new name for Sage City