You’re offline. This is a read only version of the page.
Announcements
I am trying to get consistent numbers from the Item Stock Inquiry screen. The client has been using GP since April of 2019. I just ran scripts to completely remove all IV transactions and set qtyonhnd for all items for all locations to zero. I had backed up the IV30300 and used SmartConnect to import the transactions. What I now find that is odd is that if I pull up the Item Sock Inquiry screen and enter an item and leave the site at all, and set the UofM to lbs the Total Stock quantity agrees with the balance quantity on the last line. If I change the Display Unit of Measure to DRUM those two numbers no longer agree. A drum consists of 500 lbs.What makes no sense is that if I proceed through the 5 locations they all agree whether UofM is POUND or DRUM. How can that be? What would cause this? The DRUM balance is 155.192 whereas the POUND balance is 5,697.782. The number should be 11.395.
155.192 = 191.986-(4.296+16.806+12.058+3.632). The numbers in the parentheses are 4 trucks and the 191 number is the main shop out of which inventory transfers occur.
But 5,697.782 / 500 = 11.395. The match for each truck is correct.
I have checked the UofM schedules for both GP and PA so they agree. None of the tips in the KB for Item Stock Inquiry have applied here. Please provide suggestions as to how I can finally correct this.
Shannon, this has been an ugly one. Nothing was ever setup properly and I got pulled in to mop things up. U/M schedules were changing and history was not being kept. Speaking of which, what additional tables, besides IV30300, will be hit now that history has been turned on. Now that I did the reset I am going to monitor each day and see if differences begin to appear again.
Hi Richard,
The stock inquiry window utilizes the IV30300 table in conjunction with the IV00102 table to determine the numbers in this 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 that balance at the top of the page for the “balance”. Typically we see the information in the following KB help to resolve any discrepancies in this window:
support.microsoft.com/.../the-balance-in-item-stock-inquiry-is-incorrect-in-microsoft-dynamics-g
If this is the KB that you have already reviewed and that did not help to resolve your issue, then it might require further analysis that would be difficult to provide through a forums post. I would recommend that you open a support case so that we can troubleshoot the issue further if the information above does not help resolve the issue.
#1
André Arnaud de Cal...
293,304
Super User 2025 Season 1
#2
Martin Dráb
232,149
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
