How to remove duplicate record in dataport?

Aravindh_Navision

Hi Friends,

I have a doubt in dataport. I am exporting a set of records from G/L Entry through dataport. After exporting, I could see that, there are some records with duplication.

I need to omit the the next record if the "Document No." value is same so that I will get the unique set of records.

Can anyone tell me how to do this?

Thanks in advance,
Aarvi

Savatage

I don't know exactly what and why you need to export just one document no. But for things like this I don't use dataports. I would create a report and group on the document no and export that with the report.

Or have you tried creating your own variables for the data you need to export. Then using code.... Within. Loop... if findfirst then...something...else currdataport.skip;

But usually g/l tables are large and this will take a long time to finish processing.

Unless you can be clearer on exactly what the final goal is that you are trying to achieve. There might be alternatives.