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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory Transactions...
Finance | Project Operations, Human Resources, ...
Unanswered

Inventory Transactions Do Not Match Historical Inventory Trial Balance

(0) ShareShare
ReportReport
Posted on by debs.0824 10

This is hard to explain, but it's a big problem that I need to solve. I'll try my best!

Let's say that my Journal Entry has 3 line items. 

Journal Entry#999 - Part# LN101 - qty 1 - $1.50

Journal Entry#999 - Part# Cat6 PT - qty 1 - $2.00

Journal Entry#999 - Part# 1/2"NPT - qty 1 - $0.75

The Historical Inventory Trial Balance only shows that Journal Entry#999 had 2 transactions. Let's say the Cat6PT didn't show up...

But now, my Inventory Transactions do not match my Historical Inventory Trial Balance because they are now $2 off

I need to try to figure out why these Journal Entries are only partially correct. I have one Entry that has 25 lines, but only 1 line item did not show up on both reports. I've checked the coding for each part, but everything looks normal. Please help :(

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Inventory Transactions Do Not Match Historical Inventory Trial Balance

    Hey Deborah,

    This is going to be hard to resolve on the forums. Data is going to need to be reviewed to determine what might be going on with the inventory side. If the data looks fine, then we would need to look at the report itself and see if there is an option that needs to be included or not or if perhaps you are running into a product issue with the report.

    The HITB report pulls from the SEE30303 table. You could start by checking that table to see if the records exist for the entry you see in the GL. The article below will hopefully help with this.

    learn.microsoft.com/.../hitb-report-and-gl-trial-balance-do-not-reconcile

    If you can't find anything wrong, a possible option to bring these back into balance might be a HITB Reset. 

    My recommendation if you need help with this is to create a Support Request so we can take a look at the data and see if it even exists in the tables and if so, what might be causing it to not show.

    Thank you!

    Brandon | Microsoft Support Engineer

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 724 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 580 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 554

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans