Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
2 errors when using Acc Schedules (NAV 5.1)
Davedave
Member Posts: 88
Hi all,
I'm running a 5.1 NAV database here and I have run into two problems when using the Acc. Schedules.
1) The first error occurs when I try to set a Dimension filter. The error msg is pretty long so pls refer to the url below.
http://s623.photobucket.com/albums/tt320/Yakuza117/?action=view¤t=Error1.jpg
2) The second error occurs when I try to export my Acc. Schedule to Excel. When I click on the Functions button >>> Export to Excel, I am able to see the screen where I get to choose whether to 'Create Workbook' or 'Update Workbook' but the moment I click on the Ok button, the error msg below pops up.
" An exception was raised in method value. The OLE Control or Automation Server has returned error (HRESULT) -2147352567. The component did not provide the exception description."
Can anyone help?
Thanks
Dave
I'm running a 5.1 NAV database here and I have run into two problems when using the Acc. Schedules.
1) The first error occurs when I try to set a Dimension filter. The error msg is pretty long so pls refer to the url below.
http://s623.photobucket.com/albums/tt320/Yakuza117/?action=view¤t=Error1.jpg
2) The second error occurs when I try to export my Acc. Schedule to Excel. When I click on the Functions button >>> Export to Excel, I am able to see the screen where I get to choose whether to 'Create Workbook' or 'Update Workbook' but the moment I click on the Ok button, the error msg below pops up.
" An exception was raised in method value. The OLE Control or Automation Server has returned error (HRESULT) -2147352567. The component did not provide the exception description."
Can anyone help?
Thanks
Dave
0
Answers
Will test this out. If I'm not mistaken, I have to go to the G/L Entry table >>> Design >>> View >>> Keys and add in the proper combination there.
Will update this thread once I get the results.
1) The first error occurs when I try to set a Dimension filter. The error msg is pretty long so pls refer to the url below.
http://s623.photobucket.com/albums/tt32 ... Error1.jpg
Answer: After adding the relevant G/L Entry tbl keys, seems like some customization done previously was causing the problems. Got the tech fellas to solve it.
2) The second error occurs when I try to export my Acc. Schedule to Excel. When I click on the Functions button >>> Export to Excel, I am able to see the screen where I get to choose whether to 'Create Workbook' or 'Update Workbook' but the moment I click on the Ok button, the error msg below pops up.
" An exception was raised in method value. The OLE Control or Automation Server has returned error (HRESULT) -2147352567. The component did not provide the exception description."
Answer: This was because in the Rows, there were several lines with the characters "==============" in there. It was being used as a separator between two sections in the Acc Schedule Rows. Once I removed that, I managed to export to Excel.