The HITB report and GL Trial Balance do not reconcile

There are various reasons why HITB and GL could be out of balance with each other.  Review this list for some possible reasons why.

1. You posted a transaction that affected the item's cost or quantity through Inventory, Sales Order Processing, Purchase Order Processing, etc. but then deleted the transaction before posting through GL.

2. You posted a transaction that affected the item's cost or quantity through Inventory, Sales Order Processing, Purchase Order Processing, etc. but then before posting the transaction through GL, the inventory account or amount was changed.

3. You posted a transaction using the inventory account directly in GL.

4. You posted a transaction that affected the item's cost or quantity through Inventory, Sales Order Processing, Purchase Order Processing, etc. but did not use an inventory account. Verify that you have the correct inventory account on your items in Item Account Maintenance or in Posting Account Setup.

5. You posted a transaction that did not affect an item, but used an inventory account for the debit or credit side of the entry.

6. On a transaction that affected an item's cost or quantity, the same inventory account was used for both the debit and credit entries. This created no transaction in GL (or a washing one), but updated the item.  This would be a normal situation for Inventory Transfer transactions where the quantity is being moved from site to site, but should not be the case for increases or decreases to quantity. One way to verify this has not happened is to review the IVIVINDX and IVIVOFIX fields in the SEE30303 table to see if they are the same for transactions that are not related to transfers. Here is a script that may be helpful for this. Any results should be investigated.

Select

* from SEE30303 where IVIVINDX = IVIVOFIX and DOCTYPE not in (3, 103)

7. You received an item on a PO for the full quantity on the PO, but then invoiced the shipment for a lesser quantity.  If there was a cost variance between the shipment receipt and the invoice, there will be a difference between HITB and GL.  GL will be updated for the variance related only to the quantity that was invoiced.  HITB will be updated for the variance of the full quantity shipped. If the remaining quantity is invoiced at a different cost than the original invoice, this difference between the GL and HITB will remain.  For this reason, we do not recommend matching more than 1 invoice to a single shipment receipt.

8. You experienced an interruption while posting a transaction that affected an item's cost or quantity thereby not updating both the SEE30303 and GL tables completely. We recommend restoring a backup from prior to the interruption and posting again to ensure all tables are properly updated.

9. You use a 3rd party customization that does not use the GP posting logic and is not writing to the HITB table.  If you find this is the case, contact that 3rd party developer to see what changes can be made to the product so that it works with HITB.

10. The transaction has been posted in the subsidiary module so HITB is affected, but has not been posted in GL. Once the GL batch is posted, the difference should resolve.

11. Verify the dates and restrictions being used on the 2 reports are comparable.

12. You have made several unsuccessful attempts to close the General Ledger year that you have not addressed.

13. You ran scripts in SQL that changed or updated inventory related transactions or items, that were not re-created in the SEE30303 table.

14. When a Purchase Order Processing unrealized purchase price variance or purchase price variance is posted, the Historical Inventory Trial Balance report displays the variance using the unrealized purchase price or purchase price variance account assigned to the item record or assigned in the Posting Setup window. If you edited the unrealized purchase price or purchase price variance account before posting a Purchase Order Processing transaction, the account displayed on the Historical Inventory Trial Balance report might be different from the account actually used.

15. There may be rounding issues between the Historical Inventory Trial Balance report and the General Ledger when the Extended Cost of a receipt is entered instead of the Unit Cost, or if landed costs are involved.