Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Inventory Transactions Do Not Match Historical Inventory Trial Balance

(0) ShareShare
ReportReport
Posted on by 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:
  • 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

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,483 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans