Error: Values DO NOT exist for values that DO exist during Data Import of Supplier List

ERPNext Accounting
,
1

I am getting error during import of Supplier List

image
image1260×159 17 KB

It says values do not exist however I have already populated Tax Withholding Category List

image
image1321×830 67 KB

image
image1289×815 55.9 KB

image
image1278×819 56.1 KB

image
image1294×826 56.3 KB

image
image1291×831 56.1 KB

image
image1278×828 57.2 KB

image
image1284×807 55.7 KB

2

I think it’s because of the extra space in your entry ("WC100 " instead of “WC100”). in your excel try to erase it by using =TRIM(A1) command. Where A1 refer to the column of your problematic content. That should do it.

3

You are correct. It is very unnoticeable, I have extra space on my Supplier List template but your method works like a charm. Thank you.

1 Like