Mismatch Between Audit Report And Trial Balance

[former_member218051]

Hi all,

There is a difference between Inventory Audit Report And Trial Balance figure.

how to match both the things ?

Thanking you

Malhaar

[jitin_chawla]

Hi,

There could be lots of things.

Check Note No. : [1461889|https://b1-support.wdf.sap.corp/sap/support/notes/1461889]

There is a query in the Note. Please check.

Check if it helps.

Kind Regards,

Jitin

SAP Business One Forum Team

[former_member218051]

Hi jitin ,

I'm not able to access that note.

There is a problem in page.

Thanking you

Malhaar

[Former Member]

Hi

http://www.easymarketplace.de/note-display.php

follow the link and just type the note number.

It will prompt you for S-user id and pass...

[jitin_chawla]

Hi,

Please check this Link :

[Notes Page|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/smb_index.htm]

on left enter the Note No. : 1461889 and check.

Kind Regards,

Jitin

SAP Business One Forum Team

[former_member218051]

Hi Kambadasan and Jitin,

I executed the script provided.

It returned me the blank rows.

Honestly I executed it as it is.

would you please explain me what that script is all about ?

Thanking you

Malhaar

[jitin_chawla]

Hi,

The script is there to check for incorrect account settings :

Inventory accounts or inventory-related accounts might be incorrectly defined in the company database. For example, an inventory account, which is a balance account, may have been used as a Profit & Loss account

If the query returns no result then the account settings seems to be correct.

Check for any manual transactions which are there in the stock account.

Kind Regards,

Jitin

SAP Business One Forum Team

[former_member218051]

Hi Jitin,

I checked for the manual journal entries but there is no such entry.

Thanking you

Malhaar

[Former Member]

Hi Malhaar.....

I thing you need to update the Trial Balance template in Financial Report Template in order to get the figures matched with Audit Report.....

Regards,

Rahul

[former_member218051]

Hi Rahul,

I generated the Trial Balance Template but no difference.

Thanking you

Malhaar

[jitin_chawla]

Hi,

If there is no manual transation then you can then check the following page:

[Inventory valuation Checkup|https://websmp204.sap-ag.de/~sapidb/011000358700001515052008]

There is a script in the link which provides you the determination of the database or the system which could present inconsistent inventory values between stock audit reports and general ledger stock accounts, resulting in potential asset valuation discrepancies.

Check the link. You would be needing S-user ID and password for it.

Check Note No. : 1563308 as well.

Kind Regards,

Jitin

SAP Business One Forum Team

[former_member218051]

Hi Jitin,

RSP script is not accessible.

Going through the documentations.

It's full of information.

THANKS

Thanking you

Malhaar

[former_member218051]

Hi Jitin,

As per your suggestion I ran the script and it gave me zero rows.

After that as per the documents provided by you I studied the Inventory Set up. It is also as per the standards.

Inventory Valuation Check Up tool is not accessible.

How to run that IVC. Do we need partner support or can we directly tell SAP.

Please guide about the proceedings.

Thanking You

Malhaar