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

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

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

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

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.

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

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

can you show to me this code if possible

thanks

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;

OK thanks