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…?
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.
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.
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
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 := ‘’;