Skip to Content
avatar image
Former Member

Stock Audit report running very slow (more than 45min)

Dear Experts,

stock audit report running more than 45 min for executing the report.

we have around 85 warehouses and 2000 line items.

These are selection criteria given as below:

Date: 01.11.15 to current date (normally one yr)

Warehouse: only two warehouse

Report running time is more or normal time?

Please, Can you give suggestion on this issue?

Thanks in advance.

Anand

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 19, 2017 at 11:10 PM

    Hi,

    Try with lesser posting dates. May be from 01-11-15 to 31-12-15 and then try try 010116 to 311216.

    Also select only one warehouse.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 11:24 PM

    try paging the report and you can define number of lines per page..depends on the B1 version ...there is an option

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 08:57 AM

    Hi Nagarajan,

    I have tried with one yr posting date, even though it took more than 30min.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 20, 2017 at 11:57 AM

    There is an acceleration technology called Diffuser which could help you.

    Add comment
    10|10000 characters needed characters exceeded