Insert and get the number

superbruger
Member Posts: 41
Hi all
If I use
SH.INIT;
SH.SetHideValidationDialog(TRUE);
SH.VALIDATE("Document Type",SH."Document Type"::Order);
SH."No." := '';
SH.INSERT;
Where SH = Sales Header, how do I get the "No." that was just inserted?
Its Attain 3.10
Regards,
Brian
If I use
SH.INIT;
SH.SetHideValidationDialog(TRUE);
SH.VALIDATE("Document Type",SH."Document Type"::Order);
SH."No." := '';
SH.INSERT;
Where SH = Sales Header, how do I get the "No." that was just inserted?
Its Attain 3.10
Regards,
Brian
0
Comments
-
You would need to change your INSERT to INSERT(TRUE).
This is because the code that does the No. Series Management gets called from the insert trigger.
After that you can just use SH."No." to get the number (the instance that the the trigger uses is the same instance that you are currently using).This isn't a signature, I type this at the bottom of every message0 -
Yes (of course)
My bad.
Some times You just look and look, and cant find it .... :roll:
Regards,
Brian0
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