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