Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists. Dynamics Ax 2012

Hi, All today I got error while creating Leger entry

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

I found some issue with free sequence number in NumberSequenceList . I manually delete the free sequence number with following statement.

static void Job14(Args _args)
{
NumberSequenceList list;

while select forUpdate * from list where
list.NumberSequenceId ==5637145445 && list.Status ==NumStatus::Free
{
ttsBegin;
list.delete();
ttsCommit;
}

}

 

I got again got help from Andre answer on dynamics Ax community

Reference: https://community.dynamics.com/ax/f/33/t/138926