Skip to Content
avatar image
Former Member

Inventory Audit Report query

Hello experts,

Does any know the query of Inventory Audit Report?

I'm trying to understand its flow.

Thanks and regards,


-Sarle

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 21, 2015 at 10:45 AM

    Hi Sarle,

    The inventory Audit Report is a very complicated report, that takes all transaction types into account, that can potentially affect stock balances, and stock values.

    It is a reasonably self-explanatory report. The result shows you all transactions in chronological order for the selected item(s), and calculates the balance on the fly.

    If you wish to know what query or queries are involved, you may use the SQL Server Profiler tool from the MS SQL Management Studio.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded