Inventory Posting Group - Sum Flow field - Slow down the reports - Navision 2016

mpdevnav
mpdevnav Member Posts: 34
in NAV Three Tier
Hi ,

We have more than 5 Sum FlowField in Inventory posting group Table in Nav 2016.

Some of the inventory related report fetching the data from that table only.

Reports are taking time day by day presently some of the report takes more than 30 min.

Even if I run that table from Development environment it will take more than 5 min to shows the records.

Kindly advise any solution to optimize that table to speed up the reports.

8swzvzmx894o.png



Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    You may need to (re)define your indexes and/or SIFT fields on the table the data is summed from - but without knowing the actual flowfield definitions no one will be able to tell how

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories