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
- 305 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
RapidStart Services - Table 9657 - Custom Report Selection
sahildalal
Member Posts: 2
Hello,
I am getting an issue when trying to perform an import to table 9657 (Custom Report Selection).
We have started a project to ensure all our Customer Statements are emailed automatically on a periodic basis,
using a RDLC Template for the file and a Word template for the email body.
I used RapidStart services to export the schema (with 1 test entry), I did some excel manipulation and then had a list, ready to import back into the system, ensuring I took the AR email address as the 'Send Email' and all other fields correctly filled.
When I try to import, I get a simply error relating to the 'Sequence' field. This appears to be system assigned and I have tried leaving blank, 0, importing the blank values so it produces sequence numbers, reexport, excel and then reimport using the numbers the system generated and I always get the same error.
What is even stranger, is I have managed to get it working in a different test environment, but my process is unchanged.
I cannot figure out why I had a successful run (it did take a few errors to work) and why I cannot repeat the result again?
Is there any recommendation about how to insert rows to this table via Rapidstart?
Is there some recommended way of handling table inserts which contain 'Sequence' fields?
Kind Regards, Sahil
I am getting an issue when trying to perform an import to table 9657 (Custom Report Selection).
We have started a project to ensure all our Customer Statements are emailed automatically on a periodic basis,
using a RDLC Template for the file and a Word template for the email body.
I used RapidStart services to export the schema (with 1 test entry), I did some excel manipulation and then had a list, ready to import back into the system, ensuring I took the AR email address as the 'Send Email' and all other fields correctly filled.
When I try to import, I get a simply error relating to the 'Sequence' field. This appears to be system assigned and I have tried leaving blank, 0, importing the blank values so it produces sequence numbers, reexport, excel and then reimport using the numbers the system generated and I always get the same error.
What is even stranger, is I have managed to get it working in a different test environment, but my process is unchanged.
I cannot figure out why I had a successful run (it did take a few errors to work) and why I cannot repeat the result again?
Is there any recommendation about how to insert rows to this table via Rapidstart?
Is there some recommended way of handling table inserts which contain 'Sequence' fields?
Kind Regards, Sahil
0