Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Historical Stock Statu...
Microsoft Dynamics GP (Archived)

Historical Stock Status Report Skipping Inventory Items

(0) ShareShare
ReportReport
Posted on by jspencer 50

I've recently been working on a project that requires duplicating the historical stock status report.  I've found the stored procedure that I assume it uses for the report, dbo.seeivPrintHistStockStatus, but when comparing the results between the stored procedure and the itemized print-out of the report, there are items that aren't being counted.  The weird thing is that there doesn't seem to be any correlation between the items being skipped; it's rather random. The same conditions are being passed into the stored procedure as in the report, and zero quantity items are also included.  Would there be any reason that gp would skip items when doing this report?

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Historical Stock Status Report Skipping Inventory Items

    The SQL Profiler results shall show you precisely the answer you are looking for.

    Please never hesitate to share any further inquires.

  • jspencer Profile Picture
    jspencer 50 on at
    RE: Historical Stock Status Report Skipping Inventory Items

    I would love to use HITB, unfortunately that is another problem I am facing.  It is being investigated as to the cause, but currently it would take over a week for HITB to run, so I am unable to take advantage of that table.  I am confident about the results I get when I run the stored procedure myself, and I am sure that I am using the same conditions as when the report is usually run, but I have no idea why certain items, especially ones that have recorded inventory transactions, fail to show up in the report.  I have yet to run profiler while the report is being run, however, so I will give that a try and see what results it gives me.

    Thanks for your help,

    Jared Spencer

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Historical Stock Status Report Skipping Inventory Items

    Dynamics GP Reports and inquiries are called through stored procedures exactly as you mentioned, although, the data is retrieved in sets. If you follow up on the SQL Profiler the processes being run when printing the report, you will find that GP will call (top 25 records) and so on until all data sets are retrieved.

    Therefore, I could assure you that no record will be missed out by the stored procedure. In order to get to the target of your post, which is getting a report for inventory items stock,  find the script for the Historical Inventory Trial Balance on the link below;

    GP Essentials - Historical IV Trial Balance Per Period

    The points below need to be considered according to your inquiry:

    • The report retrieves data from SEE30303 (Historical Inventory Trial Balance), which I would recommend instead of the Historical Stock Status (which reads from IV30300). 
    • Balances are grouped by Period

    Hope this helps,

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans