D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Third party Invoice Integration Performance

  • 1.  Third party Invoice Integration Performance

    Posted 24 days ago
    I have one third party integration, which is posting invoices to ERP. Since last few days, the posting process is taking hell of time to post a single invoice. Digging alot on my integration code, found that some ERP tables are main culprits for the delay. Can you let me know the how can I improve the performance of following tables

    DIMENSIONATTRIBUTEVALUESETITEMVIEW
    CUSTINVOICEJOUR
    CUSTINVOICETRANS

    ------------------------------
    Hassan Rahman
    IT Business Analyst
    Arla Foods - KSA
    ------------------------------
    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 2.  RE: Third party Invoice Integration Performance

    SILVER CONTRIBUTOR
    Posted 22 days ago
    One issue might be SQL index fragmentation.   I have seen a similar issue and was able to resolve it by reindexing the tables.

    ------------------------------
    Sailaja Bondlela
    Trader Interactive, LLC
    Princeton NJ
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role