How to Find Out Duplicate Data

Hello All,

Table Name Item Unit Measure Entry

I need To find Out incorrect Data means Same ItemNO and Qty per Unit measure and this record should put in report… need urgent Help

Regards

Palak

What have you tried?

Think about how you would do this if the information was not in NAV. Let’s say it was in a spreadsheet or even just written down on a paper.

1st i will mark out duplicate Qty per Unit measure’s value should be 1 then after i will seach that in marked record item no is not repeating then i will unmark that record and in the end i will get my result… Marked record…

Please help me to find out this result in nav-2009 r2…

Regards

Palak