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) / Check all documents us...
Microsoft Dynamics NAV (Archived)

Check all documents using a specific No. Series

(0) ShareShare
ReportReport
Posted on by AndreaNardiello 148

Good morning,

does somebody know if it is possible to check where a specific No. Series has been used in the whole NAV?

My situation is the following: for Posted Sales Shipments, Posted Transfer Shipments and Posted Return Shipments I have the same No. Series (let's call it SHIPMENTS).

I'd like to check in one page/table all the documents whose No. Series is SHIPMENTS.

Thank you everybody in advance!

Andrea

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at

    hi,

    you can use this nice and fast SQL Script, may be a solution.

    "Search for a string in all tables of SQL Server Database"

    gallery.technet.microsoft.com/.../c0c57332-8624-48c0-b4c3-5b31fe641c58

    Example

    To search in a all table  (your case)

    EXEC SP_SearchTables @Tablenames = '%'

             ,@SearchStr  = '%SHIPMENTS%'     ....  (OR 'SHIPMENTS') in your case.

  • AndreaNardiello Profile Picture
    AndreaNardiello 148 on at

    Hi Roberto,

    thanks for your reply.

    Do you think is possible to user this SQL script in a NAV report?

    We'd like to have a page but it seems to me that it will be very difficult to develop. Do you agree?

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