The field cannot be empty. Please enter a value error message

Dynamics 365 Business Central/NAV User Group Developers Forum
#1

HI guys I make data port to transfer data from two tables

sales header( key is Document Type,No.)

sales line(key is Document Type,Document No.,Line No.)

from first database A to second database B but it give me error as following

“The field cannot be empty. Please enter a value”.

How to solve this problem if possible

#2

check all the primary key values are properly populated in teh file or not…is this happening at the time of import…?

#3

YES

what i notice is i see customer no is blank in sales header table so that this problem happen

ARE THERE ARE ANY PROPERTY OR CODE THAT PREVENT THIS FROM HAPPEN.

THANKS

#4

you take a variable in the case instead of field and then onafter import record just modify your records field with this variable

clear the variable after that.

but why are u trying to import records with customer no blank…? customer no should have some value in the sales header and sales line.

Thanks,

Anil.

#5

To be clear with you i need to export sales data from one database to another

#6

Do my code only at the time of import to another database…

#7

can you show to me this code if possible

thanks

#8

make customerno (code 20 ) variable and add it to the dataport fields for import and then onafter import trigger add the below code.

if customerno <>’’ then begin

salesheader.“sell -to customer no.” := customerno;

customerno := ‘’;

end;

#9

OK thanks