Delete

Tejaswini
Member Posts: 75
Hi,
How to delete the records except first record based on document no
please suggest me the code
How to delete the records except first record based on document no
please suggest me the code
0
Answers
-
can you be more clear please.0
-
ok0
-
remove this filter GenLine.SETFILTER("Account No.",GenLine."Account No.");
sort on vendor no and create a global variable called prevvendorno.
check in repeat statement that Prevvendorno is same as account no. of the genjnlline.
if yes then add the amounts and delete the line
if not assign account no. to prevvendorno.
0 -
Thanks
Could you please tell me in writing the code
I have understand your logic , but I don't know how to write it properly
please suggest me the code
0 -
forum is to give suggestions only and not to write code for you.
please try yourself3 -
Thank you.0
-
I totally agree with Mohana. There's a saying (not sure of the origin)...
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
...I believe Mibuso (a fantastic forum) is for teaching people how to fish - not giving them a fish0
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