Auto fill on insert

(0) Share

Report

Posted on by AntonisK

171

Greetings to all of you!

I will try to explain my question with an example:

Lets say that i want to insert a new line , through AL , in the sales line table.

If i had to do it through the interface like a normal user does, when i fill the quantity with the value 1 , the system will automatically fill the values of the relevant quantity fields.

My problem is that , if i input the line myself through code, and set the quantity of the item line to be equal to 1, the system wll not automatically fill the values of the relevant fields such as outstanding qty, qty to ship,qty to invoice e.t.c.

Due to that , i need to go myself and do it manually which is a little bit annoying.

I bet that there is a smarter way to do it that i just dont know about.

Any thoughts?

Thank you in advance lads!

All responses (3)

Answers (1)

AntonisK 171 on at

Like (0)

Report

RE: Auto fill on insert

Thank you both!!
Verified answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Auto fill on insert

Hi, I think you should fill the values using "Validate" method. For example, you can use it like InsertSalesLines.Validate(Quantity, 1); it will execute the onValidate() trigger of that particular field. and will automatically fill in all the relevant fields that depend on the quantity, just as you mentioned you do on the user interface.

I hope this helps you.

Regards
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Auto fill on insert

Hi,

Please use only like this

Insersaleslines.validate(Quantity,1);

Insersaleslines.insert(true);

rest leave on the system