Item numbering

Lea_Dodds
Member Posts: 4
Does anyone know of an way to add item numbering to invoices and quotations - without getting into a lot of customisation? Manual numbering would be OK, but automatic numbering (and renumbering after insertions) would earn the Oscar.
0
Comments
-
How about making the LineNumber field visible?
John0 -
The problem with using the line number is that any line gaps, insertions or deletions (and we tend to have lots of them) will create havoc with the sequence.
Surely this is a common problem - I am hoping to find an off-the-peg solution.0 -
OK, if you want consecutive numbering without too much hassle, I would simply add a Number field to the Sales Line table and put a button on the form which calls a function which loops through all Sales Lines for the quotation/invoice. The function would populate your own number field with a sequential number each time the function is called.
Doing this fully automatic is possible, but would require quite a bit of development work to cope with all situations and variations.
John0
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