Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Inquiry>Inventory>Item Stock (item/product details not shown)

Posted on by
Item stock inquiry does not show details for some items, even the maintain history option is marked for that item.
Categories:
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 145 on at
    Inquiry>Inventory>Item Stock (item/product details not shown)
    Hello,

    The Item Stock Inquiry window is going to look at two tables. The IV00102 and the IV30300. 

    The Total Stock quantity and all the lower fields in the bottom part of the window are stored in IV00102.  If the balances in IV00102 are wrong, the window will calculate the balance at the top incorrectly.

    The IV30300 is where the detail (INFLOWS AND OUTFLOWS.  The system uses the quantities in these tables in its calculation to get to the balance (4).


    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”.  See screenshot above, 4 is the balance.
    Based on your scenario, if stuff is missing from the window, then it is likely missing out of the IV30300 table.  

    Things that are know to cause this.
     
    1. Not maintaining IV history.
    2. Removed data via SQL from the IV30300.
    3. Posting interruption where data didn’t make it into the IV history tables.
    4. Changed U of M equivalent.  Ex.  1 each is the base, 6 each= 1 case.  Customer changes the equivalent and now 8 each = 1 case.  The system allows you to change the U of M equivalent, but there is no warning that this will be the ramifications of this act.  A
    5. Serial/lot quantity overrides.  Brought in 3, sold 5 and overwrote quantity. 
    As you are missing lines, you will need to determine what lines are missing and create insert statements to insert the missing records.
    One thing I would suggest checking is the Historical Inventory Trial Balance report and see if this shows you the missing information. This report should capture everything.

    The link below has information on the HITB report.

    I hope this helps!

    Thank you!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans