Dynamics 365 for Finance and OperationsMicrosoft Dynamics Fix for Invoice Posting Locks in Dynamics 365 for Finance and Operations October 15, 2018988 views0 Share By Navneeth Nagrajan Share One of the common issues that we face in a User Acceptance Testing (UAT) session is the database locks on invoice posting tables. Issue: When multiple users log in and are posting free text invoices or purchase invoices, the database was locking and preventing the invoices from being displayed. Table of Contents Toggle Fix: (Invoice Posting Locks in Dynamics 365)How to check the invoice posting locking issues:Technical Reason:Free Text Invoice/Sales Invoice:Purchase Invoices: References: Fix: (Invoice Posting Locks in Dynamics 365) In General Ledger, there is a parameter under the section Source Document called Process source document lines in parallel. This should be set to ‘No’ instead of setting it to ‘Yes.’ How to check the invoice posting locking issues: While posting a free text invoice, sales invoice or a purchase invoice, if the Dynamics 365 for Finance and Operations takes a while (ideally more than a minute to post an invoice), then choose the environment where we are monitoring the processing of invoices (i.e., UAT in this case) and choose SQL Insights -> Live View -> Currently Executing Statements. In the Currently executing statements section, you will see a LCK_M_U wait typeset on the tables CustInvoiceInfoLine or CustInvoiceTable (if we are posting sales invoices) and/or on VendInvoiceTable or VendInvoiceInfoTable (if we are posting purchase invoices). Fig 1 – Table locks in Lifecycle Services Technical Reason: The database locking for invoice posting tables usually occurs when the ‘Process source document lines in parallel’ is set to ‘Yes.’ This setting prevents the update of a specific field called SourceDocumentLine or SourceDocumentHeader on the line or header tables. This update fails when multiple users are logged into Finance and Operations and are trying to post Free Text Invoices or Sales Invoices or Purchase Invoices. Details of the database fields are given below. Free Text Invoice/Sales Invoice: Every time multiple users are posting purchase orders (existing or newly created) there is a field called the SourceDocumentLine that’s updated on the CustInvoiceLine table or the SourceDocumentHeader that’s updated on the CustInvoiceTable. The field will not update when the General Ledger parameter ‘Process source document lines in parallel’ is set to ‘Yes’ (as happened in this case initially). Purchase Invoices: Every time multiple users are posting purchase invoices (existing or newly created) there is a field called the SourceDocumentLine that’s updated on the VendInvoiceInfoLine or the SourceDocumentHeader on the VendInvoiceInfoTable. The field will not update when the above mentioned General Ledger parameter ‘Process source document lines in parallel’ is set to ‘Yes.’ Fig 2 – Process source document lines in parallel References: Microsoft Dynamics Lifecycle Services Engineering Blog https://blogs.msdn.microsoft.com/lcs/ General Ledger and Financial Reporting https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/general-ledger/general-ledger Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 Navneeth NagrajanNavneeth Nagrajan is a Technology Specialist at Deloitte Australia focussing on design, development, integration, and implementation of the Microsoft Power Platform (primarily PowerBI, Common Data Service and Flow) and Dynamics 365 for Finance and Operations ERP. Other areas of focus include Azure DevOps, Github (related to Dynamics 365 for Finance and Operations deployments), and Dynamics Lifecycle Services. Profile: Twitter: http://www.twitter.com/nav21n LinkedIn: https://www.linkedin.com/in/navneeth-nagrajan-94a9aa5/ Twitter
Applying X++ Updates/Binary Updates to a Microsoft Dynamics 365 for Finance and Operations Environment
PowerBI Premium Storage Settings – Dynamics 365 Finance and Supply Chain (F&O) Environment Setup By Navneeth NagrajanJanuary 13, 2020
Dynamics 365 for Finance and Operations F&SCM Customer Integration Through CDS (Common Data Service) for Apps By Navneeth NagrajanApril 11, 2019
Dynamics 365 for Finance and Operations Using Document Template Refresh Capabilities to fix Open Lines in Excel in Journals By Navneeth NagrajanFebruary 11, 2019
Dynamics 365 for Finance and Operations “Click to Copy Password” button in Microsoft Dynamics Lifecycle Services In this post, we will highlight a new feature that is launched in Microsoft Dynamics ...
Dynamics 365 for Finance and Operations Report with Security Roles, Users Assigned Duties, Privileges and the Required Tables Often in many Dynamics 365 for Finance and Operations implementation projects, there is a question ...
Dynamics 365 for Finance and Operations Dynamics 365 for Finance and Operations Managed Premium Disks Recently, there has been a change with regards to Dynamics 365 for Finance and Operations ...
Dynamics 365 for Finance and Operations Applying X++ Updates/Binary Updates to a Microsoft Dynamics 365 for Finance and Operations Environment Microsoft Dynamics Lifecycle Services (LCS) is an application lifecycle management and a collaboration portal that ...