Small and medium business | Business Central, N...

State code must have value in Vendor

(0) Share

Report

Posted on by IMDS

Hello Friends,

I am trying to import vendor master using Config Package. I am getting error message which says"State Code must have a value in Vendor: No.=60001. It cannot be zero or empty.". In the upload file I have correctly mentioned state code as "DL" but still getting the same error. Attached upload file and error file for reference. In the state code column, I have tried putting value as "DL", "07", "Delhi" but still same error is coming.

Default27_5F00_05_5F00_2021_5F00_21_5F00_57_5F00_29.xlsx Config_5F00_Package_5F00_Errors-_2800_2_2900_.xlsx States-CAHRISHIKESH-2021_2D00_05_2D00_27T17_5F00_13_5F00_44.xlsx

All responses (2)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: State code must have value in Vendor

Thank you for sharing final solution. That really helps other that experience the same issue.

Thanks.
Suggested answer

IMDS on at

Like (0)

Report

RE: State code must have value in Vendor

After trying different approaches to solve this issue, i found that this particular issue is resolved once you change the processing order of "State code" before "GST Vendor Type" and "GST Registration". Refer attached screenshot. To access "Edit - Config. Package Fields" go to Config. Package Card, then fast tab "Tables", then click on "Table" and then "fields". IN the attached screenshot, the processing order of state code earlier was 86 which i changed to 6. After doing it, the error is resolved.

Not very sure about why it worked but my error was resolved.