Howdy, Stranger!
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
- 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
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Acc. Sched. to see same period last year -1Y not working
bgadhvi1
Member Posts: 7
I seem to have a problem with checking the same period last year in Account Schedule. I'm fairly new with NAV so any help would be appreciated. I've created a column in column layout called 'Difference Last Year' with the coloumn type as 'Net Change'. Within the 'Comparison Date Formula' I've put in '-1Y'. Now when I filter on the date, for example, '01/01/11..30/04/11', I dont get the correct figure in the 'Difference Last Year' column, it gives me the figure for the entire year last year, not the period I've filtered on. If I use the pre-defined periods of 1 Day, 7 Days, 1 Month, 3 Months or 1 Year, it works fine, but not when I specify a certain date in the filter which doesnt correspond to these pre-defined filters.
Any help is much appreciated!!
Bhavesh
Any help is much appreciated!!
Bhavesh
0