I need to find duplicate serial numbers in inventory through the Item Ledger Entry table. Is it possible to do a NL function that selects only those records with duplicate serial numbers? I did something similar when we connected directed to NAV but can't get that method to work using the Item Ledger Entry table in the data warehouse. Thanks in advance.
Date
Votes
1 comment
-
Jet Asia Support Hi Connie,
The easiest way that i can think of to achieve this in Jet Professional is to pull out a unique list of serial numbers (for example by using Rows Values), then create a NL count of transactions for each serial numbers and use Conditional Hiding to hide these serial numbers with count less than 1.
With Jet Enterprise, you can create a SQL View for this.
Hope this helps.
Regards,
JK
Please sign in to leave a comment.