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
Broken Posting Exch. Definitions in NAV 2013R2 rollup2/3
lynge
Member Posts: 85
Hi
Just installed rollup 2 for NAV 2013R2 at a customer, and discovered that bank reg. no, bank account and amount is now all 0's when exporting vendor payments to file (the Danish format BANKDATA).
Seems a Multiplication field was moved from table 1223 to 1225 in rollup 2 (the change log shows it, but I can't seem to find it documented in the fix list).
The problem is that the data is not copied to the new field, so this new multiplication field is always 0. In the export it is always multiplied to all Decimal fields, effectively leaving them at 0 in the bank file.
I know that I can just enter the missing values (I've already done that), but it this intended?
What have I missed?
Are there some transfer codeunit I need to run after installing rollups?
Are there new Posting Exchange Definitions (btw rather complex name for export bank file format definitions :-) ) which I need to import after installation of rollup 2?
Be warned: As far as I can tell all NAV 2013 R2 (and C5 2014) Post Exchange Definitions are hit by this... Easily fixed, but took some time to debug :-).
Btw: it seems that the Posting Exchange Definition form is not there (or maybe called something else?) before rollup 2 (so don't be worried if you can't seem to find it in your installation :-) ).
Regards,
Gert Lynge
Just installed rollup 2 for NAV 2013R2 at a customer, and discovered that bank reg. no, bank account and amount is now all 0's when exporting vendor payments to file (the Danish format BANKDATA).
Seems a Multiplication field was moved from table 1223 to 1225 in rollup 2 (the change log shows it, but I can't seem to find it documented in the fix list).
The problem is that the data is not copied to the new field, so this new multiplication field is always 0. In the export it is always multiplied to all Decimal fields, effectively leaving them at 0 in the bank file.
I know that I can just enter the missing values (I've already done that), but it this intended?
What have I missed?
Are there some transfer codeunit I need to run after installing rollups?
Are there new Posting Exchange Definitions (btw rather complex name for export bank file format definitions :-) ) which I need to import after installation of rollup 2?
Be warned: As far as I can tell all NAV 2013 R2 (and C5 2014) Post Exchange Definitions are hit by this... Easily fixed, but took some time to debug :-).
Btw: it seems that the Posting Exchange Definition form is not there (or maybe called something else?) before rollup 2 (so don't be worried if you can't seem to find it in your installation :-) ).
Regards,
Gert Lynge
0
Comments
Thank you for your post. I'm a company where we have just switched to NAV 2013, and I was trying to figure out how to import a bank statement. So I found the "Bank Export/Import Setup", but I don't know what to fill into the values. Do you know any guide on how to fill this in?
Best Regards,
Rasmus