Microsoft Dynamics AX (Archived)

Cannot create record. The Record already exists.

(0) Share

Report

Posted on by ALAhmed

916

Hi there,

i'm trying to insert new record in table based on another object :

In the form i create a button with clicked method .so i want when i click on the button duplicate the object with one field will be changed. i tried this :

void clicked()
{
    NumberSequenceTable     newNumSeqTable;
    super();

    ttsBegin;
    newNumSeqTable.clear();
    newNumSeqTable.NumberSequence           =   numberSequenceTable.NumberSequence;
    newNumSeqTable.Txt                      =   "blabla";
    newNumSeqTable.NumberSequenceScope      =   numberSequenceTable.NumberSequenceScope;
    newNumSeqTable.Continuous               =   numberSequenceTable.Continuous;
    newNumSeqTable.Format                   =   numberSequenceTable.Format;
    newNumSeqTable.Highest                  =   numberSequenceTable.Highest;

    newNumSeqTable.CleanInterval            =   numberSequenceTable.CleanInterval;
    
    newNumSeqTable.insert();
    
    ttsCommit;
}

this not work . i get Error :Cannot create a record in Number sequence Scope (NumberSequenceScope). Reference: 0.The record already exists.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

XB 1,875 on at

Like (0)

Report

RE: Insert new object in table

Check non duplicate index, I think you are duplicating record

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report
RE: Insert new object in table

yes , i have tried to customize like this :

public static void DuplicateNumSeqByPeriod(NumberSequenceTable _numSequenceTable) { NumberSequenceTable newNumSeqTable; FiscalCalendarPeriod fiscalCalendarPeriod; NumberSequenceScope numSequenceScope; buf2Buf(NumberSequenceScope::find(_numSequenceTable.NumberSequenceScope),numSequenceScope); while select * from fiscalCalendarPeriod where fiscalCalendarPeriod.FiscalCalendarYear == FiscalCalendarPeriod::find(numSequenceScope.FiscalCalendarPeriod).FiscalCalendarYear && fiscalCalendarPeriod.Type == FiscalPeriodType::Operating && fiscalCalendarPeriod.RecId != NumberSequenceScope::find(_numSequenceTable.NumberSequenceScope).FiscalCalendarPeriod //notexists join numSequenceScope //where numSequenceScope.FiscalCalendarPeriod == fiscalCalendarPeriod.RecId { numSequenceScope.FiscalCalendarPeriod = fiscalCalendarPeriod.RecId; numSequenceScope.insert(); buf2Buf(_numSequenceTable,newNumSeqTable); newNumSeqTable.NumberSequenceScope = numSequenceScope.RecId; newNumSeqTable.Insert(); } }

so also i have the some error

Cannot create a record in Number sequence Scope (NumberSequenceScope). Reference: 0.The record already exists.

The problem is on index , when i add this

numSequenceScope.DataArea = "othercompany"; works fine

Was this reply helpful? Yes No
Suggested answer

XB 1,875 on at

Like (0)

Report
RE: Cannot create record. The Record already exists.

I review index and see that exists one called SeriesIdx that don't allow duplicates and have two fields NumberSequence and NumberSequenceScope so if you are copying this two values from another exist records you'll have an error.

newNumSeqTable.NumberSequence = numberSequenceTable.NumberSequence; newNumSeqTable.Txt = "blabla"; newNumSeqTable.NumberSequenceScope = numberSequenceTable.NumberSequenceScope;

Was this reply helpful? Yes No

Community site session details

Cannot create record. The Record already exists.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Cannot create record. The Record already exists.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates