web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Duplicate record check
Microsoft Dynamics NAV (Archived)

Duplicate record check

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,099

Hi

 In a report i have Item ledger Entry as Dataitem. I want if same Document No is read then that record should be skipped.

Data should be stored in Temporary table and checked if Document No exists then record from Item Ledger Entry should get skipped.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    TempTable.RESET;

    TempTable.SETRANGE("Document No.",ItemLedgEntry."Document No.");

    IF NOT TempTable.IsEmpty THEN

      CurrReport.SKIP

    ELSE

      //insert temptable record here

  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi Teddy

      How Temp Table should be defined.

    Thanks

  • manish.yadav Profile Picture
    manish.yadav 1,893 on at

    Please go in assigned variable and  set the property Temporary - YES.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    If you go to the properties of the variable, you should be able to see the Temporary properties. Set it there.

  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi Teddy

       Do we need to define Record DataType. Then what should be its SubType

    Thanks

  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi

      Do we need to define Record DataType. Then what should be its SubType

    Thanks

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Yes, the datatype can be whatever you want it to be. If you put Item Ledger Entry, the temporary record will take the Item Ledger Entry table structure.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans