Slowness issue when processing Inventory Audit Report in SAP B1

[hemabhushan_g]

I am having a problem with our report processing (Inventory Audit Report), it takes more than 5 hrs to generate the report.

SAP B1 9.3 (9.30.150) PL: 05

SQL details:

Microsoft SQL Server Management Studio-12.0.6164.21

Microsoft .NET Framework-4.0.30319.42000

Thanks in advance for any suggestions

[azizelmir]

Hi hemabhushan.g, You can also use a query to extract data from the stock register.

[hemabhushan_g]

can you pls share the query.