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 / Finance | Project Operations, Human Resources, ... / Item Stock Inquiry scr...
Finance | Project Operations, Human Resources, ...
Suggested answer

Item Stock Inquiry screen question

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,788 Moderator

We have an item that was added to inventory in June of 2021. The beginning quantity was set by doing an inventory adjustment. The quantity was 159. Going to the Item Stock Inquiry screen right now shows that inventory adjustment of 159. The question comes in about the balance. The balance shows as 1,460. There have been plenty of POP receipts and SOP sales after June but none before. Looking at the IV10200 tables confirms this. Other items added in June all appear to be correct. What could be causing this?

Categories:
Microsoft Dynamics GP
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Item Stock Inquiry screen question

    Running these four scripts yielded no discrepancies.

    Where else can I look for what is causes the quantity balance difference?

    -- List all receipt also found in IV30300

    SELECT *

    FROM [NYSID].[dbo].[POP10500]

    WHERE ITEMNMBR='F6645-0000-000' AND TRXLOCTN='HANDM' AND APPYTYPE = 1 AND POPRCTNM IN (SELECT DOCNUMBR FROM [NYSID].[dbo].[IV30300])

    -- List all receipts not found in IV30300

    SELECT *

    FROM [NYSID].[dbo].[POP10500]

    WHERE ITEMNMBR='F6645-0000-000' AND TRXLOCTN='HANDM' AND APPYTYPE = 1 AND POPRCTNM NOT IN (SELECT DOCNUMBR FROM [NYSID].[dbo].[IV30300])

    -- List all invoices also found in IV30300

    SELECT *

    FROM [NYSID].[dbo].[SOP30300]

    WHERE ITEMNMBR='F6645-0000-000' AND LOCNCODE='HANDM' AND SOPTYPE=3 AND SOPNUMBE IN (SELECT DOCNUMBR FROM [NYSID].[dbo].[IV30300])

    -- List all invoices not found in IV30300

    SELECT *

    FROM [NYSID].[dbo].[SOP30300]

    WHERE ITEMNMBR='F6645-0000-000' AND LOCNCODE='HANDM' AND SOPTYPE=3 AND SOPNUMBE NOT IN (SELECT DOCNUMBR FROM [NYSID].[dbo].[IV30300])

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Item Stock Inquiry screen question

    It appears that there are records missing. I will compare the records in the SOP30300 and POP10500 tables.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Item Stock Inquiry screen question

    This is interesting. The net of all the ins and outs in the

    IV10200 table = 2366

    IV30300 table =  906

    The difference is 1,460 which is the balance quantity at the beginning of the grid.

    So one or both of these two totals are wrong.

    I am going to need to look at the individual POP and SOP lines and find the difference.

  • Suggested answer
    Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Item Stock Inquiry screen question

    Hi Richard,

    The window pulls from 2 main tables in Dynamics GP:

    · IV00102 - Item Quantity Master

    · IV30300 - Inventory Transaction Amounts History

    The totals and balances are pulling from different tables.  Above the Total Stock quantity and all the lower fields in the bottom part of the window are stored in IV00102 and are static values.  However, if the balances in IV00102 are wrong, the window will calculate the balance at the top incorrectly.

    The IV30300 is where the detail (inflows & outflows) is pulling from.  The system uses the quantities in these tables in its calculation to get to the balance displayed on the top of the window.

    It starts with the balance in the IV00102 and works its way backwards (starting at the bottom of the window) through transactions in the IV30300.  Once it gets to the last transaction in the table (based on date) the system puts the calculated amount at the top of the page for the 'balance'.

    For more troubleshooting advice on the values shown in this window I would recommend reviewing the following:

    docs.microsoft.com/.../incorrect-balance-item-stock-inquiry

    Best Regards,

    Jeff

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Item Stock Inquiry screen question

    IV Reconcile was the first thing tried. Item transaction was entered using GP. There were other transactions entered the same day and they are fine. I cannot figure out from where this number is coming. Do you know what tables and/or equations that are used in this grid?

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Item Stock Inquiry screen question

    Dumb question : but have you tried to run a reconcile ? I guess yes... how are those transactions processed ? any external integration ? Was the HITB tracking enabled at some point before or after that date ?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,375 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans