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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Items Without Lot Numbers
Microsoft Dynamics GP (Archived)

Items Without Lot Numbers

(0) ShareShare
ReportReport
Posted on by Hello World 80

Hello Forum,

I am currently trying to created a report of Items without Lot Numbers, but I am having some issues finding them. I know the items in table IV00300 are all the items WITH lots, and IV00101 are all of the items, but how do I find the items without lots?

My thoughts were to export the two lists of items to Excel and remove duplicates, but i'm not sure that would work. Any suggestions?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,631 Moderator on at

    You need to use the VLOOKUP function in Excel, comparing the results from IV00300 with IV00100.  That will identify which records in IV00100 don't have a corresponding record in IV00300.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at 
    SELECT  CASE ITMTRKOP
          WHEN 1 THEN 'No Tracking Option'
          WHEN 2 THEN 'Serial Tracking'
          WHEN 3 THEN 'Lot Number Tracking'
          ELSE ''
        END AS 'TrackingOption' ,
        ITEMNMBR 'Item Number' ,
        ITEMDESC 'Item Description'
FROM    dbo.IV00101 
ORDER BY 1

  • Suggested answer
    Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at

    The following script will give a list of items having traking option by lot and there is no record in IV00300 or IV30400:

    select ITEMNMBR,ITEMDESC from IV00101 where ITMTRKOP =1

    and ITEMNMBR not in (select itemnmbr from IV00300

                        union all select itemnmbr from IV30400)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans