Unable to import Excel file with UDF

Unable to import Excel file with UDF

Environment: 

iVend 6.6 with SAP B1 9.2

 

Problem Statement:  

Product Masterfile unable to re-import with user defined field (UDF) 

 

Symptoms:  

On exporting the product master from iVend from Export Data functionality, after making changes in the exported excel file imported the file again but the changes made did not appear without any message(neither success nor failure).


Resolution/Work Around:   

It was found that some UDF’s were created for object type product (invproduct). Out of those UDF’s on UDF was having the parameter 'Display only' as checked. Once we unchecked that parameter and restarted the system the excel file got updated successfully.