Item Ledger Entry

lloyd
Member Posts: 12
Before writing a record to the item ledger entry I want to test if the item has an item tracking code. If it doesn't I want to ask the user if the item should be item tracked before creating the record as you cannot change the item tracking code after the record exists.
My issue is that the OnInsert trigger on the Item Ledger Entry table doesn't execute so the code to check the item details doesn't run.
Does anyone know where I should place the check?
My issue is that the OnInsert trigger on the Item Ledger Entry table doesn't execute so the code to check the item details doesn't run.
Does anyone know where I should place the check?
0
Comments
-
To the CU 21 - there is place for tests before posting... do not insert Confirm after begin of transaction...0
-
You should never write any code that creates Item ledger entries directly. Instead, you should create an Item Journal line and post it through the standard posting routines. Those already have checks like that embedded.0
-
Thanks Kine. Problem solved.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