Small and medium business | Business Central, N...

OnOpenPage trigger issue

(0) Share

Report

Posted on by Romryan

Hi All,

This OnOpenPage() trigger is not executing the Hello world and UpdateQtyBase() procedure when I open a Purchase Order. What could be the issue?.

pageextension 50820 PurchLineExt extends "Purchase Lines"

{

trigger OnOpenPage();

begin

Message('App published: Hello world');

UpdateQtyBase();

end;

}

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

Are you sure that you extend the right page ? I don't think the "Purchase Lines" is the right page.

The Purchase Order pages are "Purchase Order List" or "Purchase Order".

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

Teddy Herryanto,

I just need the my function to learn after opening the PO window but when I put purchase order instead of Purchase line in my page extension, my procedure is not recognised and its underlined in RED.

My function looks at Quantity (Base) in Purchase Line table and if its not equal to Quantity, it updates it so that it can be at par with the Quantity field.

What can I do on purchase Order page extension so that when it opens, my function is executed?.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

You need to know why and how you want the trigger to happen. You definitely not supposed to update Quantity (Base) without going through validation.

I think it is not a good idea to update the record when you are opening the page. Try to re-engineer your logic. Does it make sense to do it OnOpenPage ? Does it make sense to do it OnValidate event ? Does it make sense to do it OnAfterGetRecord ? Etc.

Know what you are trying to achieve first before doing it.

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

Teddy,

I am asking this function is affecting Purchase Lines I tried OnInsert Trigger and OnModify but nothing good came that's why I opted to use OnOpenPage trigger. When I do use after insert trigger on SQL on this table, its working perfectly and my QtyBase is being updated but I know this is not the recommended way. Is there a trigger in AL that is equivalent to that after insert or after update of SQL??.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

We have OnAfterInsert trigger in Purchase Line table. Please using the event.

Was this reply helpful? Yes No
Suggested answer

Chameera Kavinda 510 on at

Like (0)

Report

Hi,

Can you try by extending the "Purchase Order Subform" page.

Thanks

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

Why not use OnAfterValidate of the Quantity or Unit of Measure Code field ?

Was this reply helpful? Yes No