You’re offline. This is a read only version of the page.
119
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
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?
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.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
