Skip to Content
Author's profile photo Former Member

Inventory audit report and the TB does not match

Our customer is not able to close the accounts because the inventory audit report figures and the TB figures does not match. I’ve run the IVC check and the database is healthy. and I;ve corrected the incorrect account mapping as per Note 1461889 – inventory account for future. The problems was due to incorrect account mapping and manual JE. Now my problem how do I correct the earlier errors and match the TB and close the account. the document wise differences are as follows:

                                        Document                         As per TB               As per audit               Difference

Opening balance OB 221697 224686 -2988.78
Stock Transfer IM 1527299 1527299
Journal Entry JE 62952 0 62952
GRPO PD 2186330 2186330 -0.33
Goods receipt PR -18324 -18324 0
A/P Invoice PU 494 494 0
Goods receipt SI 1309 58077 -56768.36
Goods Issue SO -3297260 -3302348 5088.03
Stock Verification ST -4225 -5134 909
Total 680272 671080 9191.56


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      hi KM,

      If it is a previous finacial year you should be pass one more JV like your stock creadit and P&L account  debit.

      If it is a current finacial year you should do through inventory reconcillation.

      hope this will help you.


      Shanmugam V.

      Author's profile photo Former Member
      Former Member

      For manual JE, cancel it and use Inventory revaluation to allocate amount to the specific list of items

      For other stock transactions, I've never seen any cases that make the differences between TB and audit reports.

      Take OB as an example, you should provide more details information

      Thanks and regards,

      Doan Ngoc