Inserting into Table With code

mo_x

Hey,
I'm trying to insert a new sales Line programmatically. However, I'm a bit lost on where should the code be written. I tried on Onvalidate trigger for No field.
and Oninsert trigger. But neither of those two worked. I used setrange, init, and some fields, but nothing happened.

Antoniomvalls

automatically i think it isnt possible in a easy way but u can put the code in a button. you can use oninsert and onmodify in order to insert a new line and refresh the data on that new line (every time the record is modified manually or modify(true); ) but i think it is better doing it with a button

think about the consecuences of doing it in oninsert and onmodify triggers. Oninsert means in each new line created by the user (maybe program flow too) another line will be created.
More important, in onmodify trigger means that every modification will suposse an error or a modification of another line. (error if u cant save the objective line in a new field)

Antoniomvalls

Try it on a new report or codeunit. Report with an integer dataitem filtered by number = how many lines u want

document no., line no. document type insert
etc
etc
etc
modify;

mo_x

You right, i could try it on report. but i want to insert new sales line when creating sales order.

when salesline1 is created.
then automatically salesline2 should be inserted.
it should have the same values as salesline1, but only number should be different: For example:
no. 1000
no.1100 < new line.

Antoniomvalls

automatically i think it isnt possible in a easy way but u can put the code in a button. you can use oninsert and onmodify in order to insert a new line and refresh the data on that new line (every time the record is modified manually or modify(true); ) but i think it is better doing it with a button

think about the consecuences of doing it in oninsert and onmodify triggers. Oninsert means in each new line created by the user (maybe program flow too) another line will be created.
More important, in onmodify trigger means that every modification will suposse an error or a modification of another line. (error if u cant save the objective line in a new field)

Antoniomvalls

but the data refresh only works if u can say what is the line objective. and that u can only know at the moment of creation.

Moreover u have to think that if u make automatically u can be modifying the functionality of the standard in ways u dont want

Antoniomvalls

add a button in the subform, not in the main page. (put it in page/form 46 not in 42)