Dynamics AX 2009 : Cannot create a record in Sales order header - Updating table (SalesParmSubTable)

During Sales order posting I encountered an issue which was being generated due to below error message:

"Cannot create a record in Sales order header - Updating table (SalesParmSubTable). Sales order:*, *. The record already exists."

 After some analysis and searching this issue I found that this issue sometimes occurs due to database logging enabled on some tables related to Sales Order i.e. SalesParmSubTable, SalesParmSubLine, SalesParmTable,SalesParmUpdate ....

Removing these tables from that specific Company Database log setup resolved the issue.

Note: For similar issue related to PO I also found a Microsoft fix which may also be helpful in similar scenarios:
https://support.microsoft.com/en-us/kb/961909

Comments

Post a Comment

Popular posts from this blog

D365: SSRS Report Development/ Customization

Image
Hi guys, Today in this blog I will be demonstrating the procedure for the SSRS Reports development and customization in D365FO. Before proceeding with the Development or customization make sure that you have created a new model for your customization since we will be using extensions approach in our customization because An extension enables you to add functionality to existing model elements and source code. Coming back to the main objective of this blog which is to Develop SSRS reports in D365. One point to keep in mind is that there is no change on How you develop query based report and RDP based report in D365FO . The only change is you have to use extensions for standard report. If you are developing brand new report based on custom tables, there is no change. So in this Blog I will discuss How to customize an existing SSRS Report in D365 using Extensions approach step by step: Step#1:  The first step is to create a new model, Below are the steps to create a new model: Na...
Read more

D365: Modifying check report along with the slip text

Today I came across a requirement to modify the standard check format in D365F&O. The requirement was to modify the design and also change the slip text that displays on the check report. Below are the steps for reference purpose that I followed to achieve the desired solution: STEPS: 1. Duplicated the Check_US report in my specified Model. 2. Modified the design accordingly. 3. Create the extension of the "ChequeController" class in order to call my newly created report and design, the code is as below: [ ExtensionOf ( classStr ( ChequeController ))] final class LevChequeController_LevridgeEquity_Extension {     /// <summary>     /// Determine the report menu item.     /// </summary>     /// <param name = "_chequeFormType">The check form type.</param>     /// <param name = "_bankChequeLayout">The bank cheque layout table buffer.</param>  ...
Read more

D365/ Ax2012: X++ code for custom lookup to show customer account and Name

public void lookup()         {             Query query = new Query();             QueryBuildDataSource queryBuildDataSource, qbds;             QueryBuildRange queryBuildRange;                 SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), this);                 sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));             sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup));             sysTableLookup.addLookupField(fieldNum(CustTable, Party), false);             queryBuildDataSource = query.addDataSource(tableNum(CustTable));             qbds = queryBuildDataSource.addDataSource(tableNum(DirPartyTable)); ...
Read more