D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Sales Order Invoicing

  • 1.  Sales Order Invoicing

    Posted Apr 28, 2020 09:22 AM
    A few times the past week users have reporting that it is taking several minutes to view an invoice on a sales order.  We put a call into MS and they noticed there was a SIPD blockage and clear it for us.  We weren't able to identify what caused it though.  Then this morning it happened again and it started with a user trying to view an invoice with thousands of lines on the sales order.  My initial guess is this is way too many lines.  This lag creates a blockage for all other billers to process their invoice.  Has anyone had any experience here? Is there a best practice or process on how many lines a sales order should have?  Thanks in advance for any responses!
    Tabitha

    ------------------------------
    Tabitha Arneson
    BlueCrest Inc
    Danbury
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Sales Order Invoicing

    MICROSOFT MVP
    Posted 28 days ago
    Hi Tabiha,

    If you can find out the SQL statement which is causing the exact issue, you can review if something can be improved here. I have seen e.g. customizations with some quirks which led to several to more than 10 minutes delay.
    In one case, there was a loop triggered where the where clause variable was empty, so it looped all records for nothing. Putting an IF statement before this solved the issue. In another customization, I found out that an additional table was set to entire table cache which was in fact a transaction related table. The execution time was due to caching a full table on the AOS. When removing the cache setting, the execution was quick again.
    So, you have to find the exact SQL statement; then review if and how it can be improved.

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------

    Academy - Online Interactive Learning from Experts


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