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) / Wrong on hand quantity
Microsoft Dynamics GP (Archived)

Wrong on hand quantity

(0) ShareShare
ReportReport
Posted on by Refeesh Ali 5,201

h0876.100456_5F00_qty.png"The quantity entered is greater than Quantity avilable.do you wants to use the quantity avilable".
actually my physical quantity is '2' but in my item 100456  quantity maintenance and inventory check list and all window is showing '17' quantity.

how can i fix this issue. i reconcile the said item but no change in the quantity.

its too urgent to fix for auditing purpose.

thanks,

showing 17 qty in item quantity maintenance window

*This post is locked for comments

  • Rashid Farooq Profile Picture
    Rashid Farooq 1,000 on at

    Try to reconcile the item using Reconcile Utility from Tools-->Utilities-->Inventory-->Reconcile.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    Do you have other inventory locations or is WHJAVA the only one? Could they physically be someplace else? Try running these three reports under Reports->Inventory->Activity

    1) Purchase Receipts

    2) Stock Status

    3) Historical IV Trial Balance

    Report back what you find.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator on at

    Also Refreesh, do you use Field Service or Project Accounting?  Both those modules can affect allocated quantities.  If you use either or both of those modules, make sure you reconcile them also, before reconciling your inventory quantities.

  • Community Member Profile Picture
    Community Member on at

    Not sure if this is related but your In Use qty seems kinda high for that item.  Is it supposed to be that high?

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    H0312.3.png"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/32/0638.1.png" border="0" />

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    Please send me the results of these two scripts which you will run in SSMS.

    select * from iv00102 where itemnmbr='100456'

    select * from sop10200 where itemnmbr='100456'

    select * from iv10001 where itemnmbr='100456'

    If this item is part of a build run this as well

    select * from BM10300 where itemnmbr='100456'

    There is an open transaction(s) somewhere consuming 15 of these items. We need to find it.

    You could also run an inventory item inquiry on this item.

    Inquiry->Inventory->Item Transactions run a report for this item and send the results.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    Hi Richard, i run the below 4 querries and find only one table is existing data's which is IV00102 (attached) also attached the Item Transaction Report

    [View:https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Discussions-Components-Files/32/1070.IV00102_2D00_1.XLS.xlsx:550:0][View:https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Discussions-Components-Files/32/3857.IV-Item-Transaction-Inquiry.pdf:550:0]

     

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    Rfeesh, can you please the Excel spreadsheet again and this time make sure values go into individual columns. It is very difficult reading it when each row is just  string. Also, send me the output of

    SELECT * FROM IV10200

    WHERE ITEMNMBR='100456'

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    Hi Richard, please find the requested data.

    IV10200

    [View:https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Discussions-Components-Files/32/4212.IV10200.xls:550:0]

     

    IV00102

    [View:https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Discussions-Components-Files/32/1018.iv00102.xls:550:0]

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    OK, these two reports agree that you have 60 on hand right now.

    Can you please run this script and send back the results. This will search your company database for the occurrence of 100456. There must be something that is consuming this part. Perhaps there is a PO return? Once you have the list of tables look for pop10110, pop10500 maybe it is part of a bill or an unposted inventory transaction. You can look at these tables yourself in SQL or send me the results. This script will take a while to run so be patient.

    DECLARE

       @search_string VARCHAR(100),

       @table_name SYSNAME,

       @table_id INT,

       @column_name SYSNAME,

       @sql_string VARCHAR(2000)

    SET @search_string = '100456'

    DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects WHERE type = 'U'

    OPEN tables_cur

    FETCH NEXT FROM tables_cur INTO @table_name, @table_id

    WHILE (@@FETCH_STATUS = 0)

    BEGIN

       DECLARE columns_cur CURSOR FOR SELECT name FROM sys.columns WHERE object_id = @table_id AND system_type_id IN (167, 175, 231, 239)

       OPEN columns_cur

       FETCH NEXT FROM columns_cur INTO @column_name

       WHILE (@@FETCH_STATUS = 0)

       BEGIN

        SET @sql_string = 'IF EXISTS (SELECT * FROM ' + @table_name + ' WHERE ' + @column_name + ' LIKE ''%' + @search_string + '%'') PRINT ''' + @table_name + ', ' + @column_name + ''''

        EXECUTE(@sql_string)

        FETCH NEXT FROM columns_cur INTO @column_name

       END

       CLOSE columns_cur

       DEALLOCATE columns_cur

       FETCH NEXT FROM tables_cur INTO @table_name, @table_id

    END

    CLOSE tables_cur

    DEALLOCATE tables_cur

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans