Date Formula Error in RTC

dekka22
Member Posts: 11
When creating a Purchase Order in the RTC, I get an error that is as follows
"error - The date formula '0' should include a time unit", this error occurs as soon as I try to insert into any field other than the No. field in the PO header.
If I create the same order in Classic I have no problem.
I have replaced the page from a site where the PO works in RTC, we have also replaced the service tier but to no effect.
The database is a Nav SP1 running on SQL 2008. We suspect it is an SQL problem but do not know where to look?
Any help or if anyone has seen this problem before would appreciate to pointers as to where to look.
"error - The date formula '0' should include a time unit", this error occurs as soon as I try to insert into any field other than the No. field in the PO header.
If I create the same order in Classic I have no problem.
I have replaced the page from a site where the PO works in RTC, we have also replaced the service tier but to no effect.
The database is a Nav SP1 running on SQL 2008. We suspect it is an SQL problem but do not know where to look?
Any help or if anyone has seen this problem before would appreciate to pointers as to where to look.
Derek Brown
0
Comments
-
Check with Debugger..0
-
It could be a problem of data. Check e.g. Payment terms for dateformula "0" instead "0D".0
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