Re: Can not insert records in ledger balance trx. SQL issued an error?
mohamed nisthar
Resolution:
1. Install new instance of SQL with collation SQL_Latin1_General_CP1_CI_AS and run service pack3 for sql
2. Install newly the AX
3. restore the database if you need the old data of AX
4. Copy and paste old application files into new application folder of AX to have youe application in current stage.
5. go to Microsoft Dynamics AX 2009 Server Configuration and change the AOS instance. (keep one AOS only in run)
6. Open AX post the JV - It will work
> On Tuesday, April 07, 2009 12:26 AM Koon wrote:
> I had install AX2009, SQL2005 SP3.
> When i try to post journal, sales order, system always get error msg:
> Cannot insert multiple records in Ledger balance transactions
> (LedgerBalancesTrans). Account number: , .
> The SQL database has issued an error.
>
> Does anyone face this problem? Please guide me.
> Thank you very much.
> regards,
> Koong
>> On Monday, May 18, 2009 2:24 AM Frank wrote:
>> You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.
>>> On Saturday, March 19, 2011 2:43 AM mohamed nisthar wrote:
>>> the is a temp table with prefix # is created with the fields of small letters and the same table is called with fields of capital letters. Example field f1 is created when temp table creation and then AX is using select F1 from the temp table which cause the issue. It should be both situation to have same case (f1 and f1).
>>>
>>> So AX itself has the bug and do not know how to avoid this.