web
You’re offline. This is a read only version of the page.
close
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, not Equal to Ledger Stock Report, why??

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All

I am running the historical stock status report for the end of month, however when I run the ledger trial balance report for the same time period the balances are not equal, when it should be the same.

Therefore, how am I supposed to know what the value of the stock is?

Please help if you can, why are these two not equal?

Also, a transaction went through the system two months after the "as of" date on the historical stock status report but this shows on the report for two months earlier, why?

Please help anyone, if you know anything.

Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hello,

    If you are doing your month-end financial close and tying your inventory subledger to the general ledger, then you should be running the Historical Inventory Trial Balance report (HITB), not the Historical Stock Status.  The stock status report should be correct for quantity, but may not match for cost depending on your item valuation type.

    As for the date issue, I suspect there is a 2 month difference between your transaction date and your posting date.  The report options allow you to choose which one will be used.

    If the HITB report is off, then you'll need to look for transactions that didn't post to the GL or manual journal entries to the inventory accounts or other anomolies.  It's not always easy to find, depending on how long it's been since you reconciled.  Good luck!

    -Trevor

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Historical Stock Status Report retrieves data from IV30300 which is a historical table that doesn't get affected with Cost Adjustments; one of the most crucial reasons when it comes to reconciling GL versus Inventory.

    Therefore, you should consider HITB (Historical Inventory Trial Balance) which retrieves data SEE30303; an inventory table that is linked to GL per Journal Entry, recording cost adjustment documents for reconciliation purposes.

    In case your Dynamics GP version is 2013, please make use of the Reconcile Utility. Otherwise, I could provide you with a script to match inventory versus GL per journal entry to help you tie your Sub Ledger with your General Ledger.

    For further details on the Inventory versus General Ledger issues, you could review my blog for essential topics.

    Your feedback is highly appreciated to dig for further details if required.

  • Community Member Profile Picture
    Community Member on at

    hi There

    Could you provide me with that script to compare HITB with general ledger.  I also need script to compare HITB to stock status report.  I am off by $15k and I think it is all the negative amounts in the HITB that are not on the stock status report, although I do not want to adjust my GL to  match HITB because is would be a debit to COGS instead of a credit. Thank you so very much!!!!!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans