Inserting data in purchase header, "No." Already Exists

jhanvincent14

Good day,

Im a newbie programmer in navision, Im trying to insert multuple data from my custom page to purchase header and it gives me an error. I already Initialize the record but it still not working. just see attached Photo for your reference. Hope you can help me

Jan_Veenendaal

You do an INIT , but this will NOT clear the fields that are part of the primary key!

So probably the first time your code runs it will work OK, but the second time it will try to insert a new record using the same Purchase Order Number as the first time.

So you need to either use CLEAR instead if INIT, or manually clear the field(s) from the primary key (last option is for me the preferred option).

mohana_cse06

Is that order already existing in your db?
Is your no. series table updated correctly with last no. used?

Jan_Veenendaal

You do an INIT , but this will NOT clear the fields that are part of the primary key!

So probably the first time your code runs it will work OK, but the second time it will try to insert a new record using the same Purchase Order Number as the first time.

So you need to either use CLEAR instead if INIT, or manually clear the field(s) from the primary key (last option is for me the preferred option).

jhanvincent14

mohana_cse06 wrote: »

Is that order already existing in your db?
Is your no. series table updated correctly with last no. used?

@mohana_cse06 hello

Is that order already existing in your db? ~ Yes, It must be Order
Is your no. series table updated correctly with last no. used? ~ I use the INSERT fuction code, this code is inside on a loop. so I think yes,

RockWithNAV

I believe you need to modify your code. Go ahed once with Jan's approach.

jhanvincent14

thanks guys