Dynamics Community Forum Thread Details

Inventory Transactions Do Not Match Historical Inventory Trial Balance

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:

Distribution

Inventory and warehouse management

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

Quick Links

Leaderboard