Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Number series with Month
KARPURSHRIKANT
Member Posts: 35
I used the below way and it worked.
viewtopic.php?f=14&t=1745&start=0
But i have one problem...................
When I go to next line and change the date with different month, the document number does not change as required,,
Like
line no Posting date document no
1000 10/04/2010 04-00001
2000 10/05/2010 04-00002
its should have been
line no Posting date document no
1000 10/04/2010 04-00001
2000 10/05/2010 05-00001
Please can anyone help?
viewtopic.php?f=14&t=1745&start=0
But i have one problem...................
When I go to next line and change the date with different month, the document number does not change as required,,
Like
line no Posting date document no
1000 10/04/2010 04-00001
2000 10/05/2010 04-00002
its should have been
line no Posting date document no
1000 10/04/2010 04-00001
2000 10/05/2010 05-00001
Please can anyone help?
0
Answers
My Blog - nav.education
But its impractical to change the workdate every time you wish to pass some backdated entry.....
But i got the solution i could write the following code on the validation of posting date field...for table 81
GenJnlTemplate.GET("Journal Template Name");
GenJnlBatch.GET("Journal Template Name","Journal Batch Name");
GenJnlLine.SETRANGE("Journal Template Name","Journal Template Name");
GenJnlLine.SETRANGE("Journal Batch Name","Journal Batch Name");
IF GenJnlBatch."No. Series" <> '' THEN BEGIN
CLEAR(NoSeriesMgt);
"Document No." := NoSeriesMgt.TryGetNextNo(GenJnlBatch."No. Series","Posting Date");
END;