web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,848 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
I have the same question (0)
  • 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 ?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 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
    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,848 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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 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,848 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])

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,122

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans