mibuso.com
Home› NAV/Navision Classic Client
Options

How to remove duplicate record in dataport?

Aravindh_NavisionAravindh_Navision Member Posts: 258
edited 2015-02-01 in NAV/Navision Classic Client
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

Comments

  • Options
    SavatageSavatage Member Posts: 7,142
    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.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
Sign In or Register to comment.