Event for on before entering sales line

samantha73
Member Posts: 118
Hi
I have a requirement to check sales header fields entred before any line is inserted for example location on sale sheader bfore a user enters any lines. There is an event on the sales header - onBeforecreatesalesline but I cannot get it to work. Is there any better event or method to achieve this
I have a requirement to check sales header fields entred before any line is inserted for example location on sale sheader bfore a user enters any lines. There is an event on the sales header - onBeforecreatesalesline but I cannot get it to work. Is there any better event or method to achieve this
0
Best Answer
-
I would put the checks on before releasing the order, it makes more sense to me, if you just want to check if "location code" is populated just do Rec.testfield("Location code"). You can also include ShowMandatory property so it shows the "red dot" but it's not going to force the user.
If you want to check before inserting the line you can just subscribe to insert event:
[EventSubscriber(ObjectType::Table, Database::"Sales Line", OnBeforeInsertEvent, '', false, false)]
local procedure MyProcedure()
begin
end;
However it's not very "clean" to do there: What happens if record is modified? what happens if the user then deletes the location code but lines were already inserted?
That's why running checks make more sense to me before releasing the order.
0
Answers
-
I would put the checks on before releasing the order, it makes more sense to me, if you just want to check if "location code" is populated just do Rec.testfield("Location code"). You can also include ShowMandatory property so it shows the "red dot" but it's not going to force the user.
If you want to check before inserting the line you can just subscribe to insert event:
[EventSubscriber(ObjectType::Table, Database::"Sales Line", OnBeforeInsertEvent, '', false, false)]
local procedure MyProcedure()
begin
end;
However it's not very "clean" to do there: What happens if record is modified? what happens if the user then deletes the location code but lines were already inserted?
That's why running checks make more sense to me before releasing the order.
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions