web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 Stock on hand re...
Microsoft Dynamics GP (Archived)

GP 10 Stock on hand reports - Can they be run with dates parameters or only based on live data?

(0) ShareShare
ReportReport
Posted on by Max Catenacci 150

I have been told that Stock on Hand reports can only be run based on live data.

So what happens if I want to know what my stock levels actually were at the end of an accounting period as compared to my physical count at the same time?

Would appreciate any feedback and possible solutions to this issue.

This is currently also slowing down our month end procedures and naturally making things highly inefficient.

*This post is locked for comments

I have the same question (0)
  • NF-28051600-0 Profile Picture
    NF-28051600-0 2 on at
    GP 10 Stock on hand reports - Can they be run with dates parameters or only based on live data?
    I tried HITB as of a previous date. Report shows nothing in its print. It prints only as of now. 
    Mahmood, do you have any recommendations how to run HITB as of previous date?
     
    Thanks
     
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GP 10 Stock on hand reports - Can they be run with dates parameters or only based on live data?

    In order to print a report for a historical period, you can consider the HITB report (Reports > Inventory > Activity), choose the Historical IV Trial Balance option.  Now, on the ranges, you can pick a date (From, To) and report your stock quantity and value at a specific historical period.

    Additionally, I have developed several scripts for the same purpose, such as:

    Inventory Item/site Summary – HITB report

    HITB Per Period (Cumulative) – Inventory Balance on a Prior Date

    Historical IV Trial Balance - Per Period

    Your feedback is highly appreciated,

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: GP 10 Stock on hand reports - Can they be run with dates parameters or only based on live data?

    Hi Max,

    This probably isn't the cleanest solution and hopefully someone can provide a better one but one option is to take a backup of the company prior to running month end and restore it under a different company name. This would leave you with an intact copy of the database you can reference.

    Regards,

    Kirk

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans