Announcements
No record found.
Hi all,
I need to put a trigger on table PurchaseLine such that if a record/line item is inserted on Purchase order, the [Quantity (Base)]=Quantity. How do I achieve this in AL??. I don't want to do it in sql.
Kindly assist.
You can either use table extension and use the the trigger or
use event subscriber and subscribe to the event.
Teddy Herryanto,
I know most of table extension goes in hand with the page extension. Do I need to create a page extension here??. And which is the best trigger to use Oninsert or onmodify or onvalidate??.
It depends what you would like to achieve.
You have to find out the right spot where to subscribe your own based on what your private IP is meant for.
If this is just a check before inserting the record then there is no need to create a page extension but a codeunit with a function that subscribe to the appropriate event published where you would like to trigger your own procedure.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 719 Super User 2026 Season 2
YUN ZHU 410 Super User 2026 Season 2
AndrewThomas81 369 Super User 2026 Season 2
