Odata General Journal - issue when saving changes to the NAV database when I setup a batch name
jeqdev
Member Posts: 8
Hi,
I have exposed an Odata web service in NAV to read and write General Journals, I am using the default page 39 - General Journal. Everything seems to work fine if I set the Journal."Journal Template Name" := 'GENERAL' and the Journal."Journal Batch Name" := 'CASH', the issue comes when I try to use a different "Journal Template Name" or Journal."Journal Batch Name".
I get the following exception error: "The Gen. Journal Line already exists. Identification fields and values: Journal Template Name='GENERAL',Journal Batch Name='CASH',Line No.='10000'". If I inspect the collection of entities in the DataServiceContext just before calling SaveChanges it looks like it contains the values I have set up. However, when calling SaveChanges it seems to ignore my the changes in the Journal Bach Name field.
I am wondering if it is supported, or if there is any way of fix this issue using any other standard NAV page.
I would appreciate if anyone could help me with this issue.
Many thanks!
I have exposed an Odata web service in NAV to read and write General Journals, I am using the default page 39 - General Journal. Everything seems to work fine if I set the Journal."Journal Template Name" := 'GENERAL' and the Journal."Journal Batch Name" := 'CASH', the issue comes when I try to use a different "Journal Template Name" or Journal."Journal Batch Name".
I get the following exception error: "The Gen. Journal Line already exists. Identification fields and values: Journal Template Name='GENERAL',Journal Batch Name='CASH',Line No.='10000'". If I inspect the collection of entities in the DataServiceContext just before calling SaveChanges it looks like it contains the values I have set up. However, when calling SaveChanges it seems to ignore my the changes in the Journal Bach Name field.
I am wondering if it is supported, or if there is any way of fix this issue using any other standard NAV page.
I would appreciate if anyone could help me with this issue.
Many thanks!
0
Answers
-
THIS! Dude, I've been having this same issue. I cannot track down why the ODATA only has a reference to the DEFAULT Journal Batch. You can change the DEFAULT to another one manually in NAV, but you still can't write to anything that's not set as the default.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 333 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