cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Audit Report query

Former Member
0 Kudos

Hello experts,

Does any know the query of Inventory Audit Report?

I'm trying to understand its flow.

Thanks and regards,


-Sarle

Accepted Solutions (0)

Answers (1)

Answers (1)

Johan_H
Active Contributor
0 Kudos

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