Skip to Content

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
0
Total 680272 671080 9191.56

Jayaprakash

info@simplexit.com

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Shanmugam V

    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.

    Regards,

    Shanmugam V.

    (0) 
  2. Doan Ngoc

    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

    (0) 

Leave a Reply