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
- 266 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
Date Format - October 19, 2009 vs. 10/19/2009
lgp
Member Posts: 77
Hi!
I am modifying the AP check for a client running NAV 2009 RTC and have run into a strange date issue. I originally modified the check (just some little position changes) in the Cronus database and tested it - all looked good. Then I imported the check into the client's database, and noticed that the date was printing differently. I did not make any changes to the date field! In Cronus, the check prints with date: October 19, 2009. In the client's database, the check prints with date: 10/19/2009. The client would like the date to print as: October 19, 2009. I cannot find a setting for the date to print this way, and have spent a lot of time going through the code and haven't found anything there either. Has anyone else run into this and found a solution?
Thanks!
L. Paul
I am modifying the AP check for a client running NAV 2009 RTC and have run into a strange date issue. I originally modified the check (just some little position changes) in the Cronus database and tested it - all looked good. Then I imported the check into the client's database, and noticed that the date was printing differently. I did not make any changes to the date field! In Cronus, the check prints with date: October 19, 2009. In the client's database, the check prints with date: 10/19/2009. The client would like the date to print as: October 19, 2009. I cannot find a setting for the date to print this way, and have spent a lot of time going through the code and haven't found anything there either. Has anyone else run into this and found a solution?
Thanks!
L. Paul
Leanne G. Paul
Business Applications/IT Advisor, Competitive Edge Services
Business Applications/IT Advisor, Competitive Edge Services
0
Comments
My Blog - nav.education
1.Old check program (V2.5 1401) used format no. 4 to manage the format of the date printed on the check.
CheckDateText := FORMAT("Posting Date",0,4); //Prints October 19, 2009 for date
2.New check program (10401) and now (50000) for NAV2009 uses the Check Translation Management program to format the date as specified on the Vendor Card Foreign trade tab. This means the date has been printing in the format of 10/19/09 since the client went live and there have been no complaints from the client
CheckDateText := ChkTransMgt.FormatDate("Posting Date",CheckDateFormat,DateSeparator,CheckLanguage,DateIndicator); //Prints 10/19/2009
3.The issue presented is: on the old version of the check the dates printed as October 19, 2009 and the new version it prints as 10/19/2009. When tested on the Classic 2009 cronus database it was printing with the words, which is where I did the initial change because I did not have a converted client database at the time I was bringing across the modifications. The reason it was ok was because of the setups on the Company Information and Vendor Cards for the Cronus database.
In order to get the Date to print with words instead of number the following setups should be completed:
Company Information Card needs values for the countries (fields: US Country/Region Code, Canada Country/Region Code).
Vendor Cards need Language, Bank Communication fields populated and blanks in the Check Date Format and Check Date Separator Fields.
Due to the setups above the logic path actually ends in Formatting the Date as is does in the program 1401, it uses logic in Report 10400-ChequeDate function to accomplish the date formatting based on the setups. If the vendor has the Check Date Format and Check Date Separator populated then the date will be formatted according to those specifications rather than the default format no. 4.
Business Applications/IT Advisor, Competitive Edge Services