Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
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 248 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!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans