Finance | Project Operations, Human Resources, ...

Item Stock Inquiry screen question

(0) Share

Report

Posted on by Richard Wheeler

75,852 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)

All responses (6)

Answers (0)

Sort by

Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Jeff Grant Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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])

Was this reply helpful? Yes No