Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Check 1401 has extra zero's (.00) are present ie 50.00.00
itsandsllc
Member Posts: 13
I've searched and tested and worked with another consultant so this is why I am posting a new topic.
On NAV2013 R2 NA, on a upgraded client database (from NAV 2009 R2) we are experiencing the following behavior.
On the standard check report the amount when paying a check with no cents IE $50.00 the output on the check line for the amount field on the check will show 50.00.00
This does not occur on standard cronus database or any other database we have upgraded.
Here is what I have done. Added country region code to company information and bank setup, I know this can cause an issue with 'CA' text in the dollar amount words. Checked the report exported against an unmodified database with no difference identified. Exported the rdlc from this database and cronus and compared in custom vs 2012 solution and tested - the issue is present on the upgraded version but not the std cronus. Compared the exported dataset's and there are some small differences but nothing out of the ordinary (probably missed something) only noticed changes in things like check no's and vendor invoice number applications - nothing jumped out at me from the datasets the amount results look the same and there are no changes to the reports they are both standard but in the upgraded database the check still shows $50.00.00. I have also re-ran code unit 2 company initialize - shot in the dark but hey.... worth a try. I have checked MSDN, updates, partnersource, and search google. I have also gone through every application setup area I can think of.
All of this leads me to believe this has to be related to some setup elsewhere in the application front end that I'm not aware of and can't find. I just don't know where and have exhausted my options at this point. ](*,)
Thank you in advance for any help.
On NAV2013 R2 NA, on a upgraded client database (from NAV 2009 R2) we are experiencing the following behavior.
On the standard check report the amount when paying a check with no cents IE $50.00 the output on the check line for the amount field on the check will show 50.00.00
This does not occur on standard cronus database or any other database we have upgraded.
Here is what I have done. Added country region code to company information and bank setup, I know this can cause an issue with 'CA' text in the dollar amount words. Checked the report exported against an unmodified database with no difference identified. Exported the rdlc from this database and cronus and compared in custom vs 2012 solution and tested - the issue is present on the upgraded version but not the std cronus. Compared the exported dataset's and there are some small differences but nothing out of the ordinary (probably missed something) only noticed changes in things like check no's and vendor invoice number applications - nothing jumped out at me from the datasets the amount results look the same and there are no changes to the reports they are both standard but in the upgraded database the check still shows $50.00.00. I have also re-ran code unit 2 company initialize - shot in the dark but hey.... worth a try. I have checked MSDN, updates, partnersource, and search google. I have also gone through every application setup area I can think of.
All of this leads me to believe this has to be related to some setup elsewhere in the application front end that I'm not aware of and can't find. I just don't know where and have exhausted my options at this point. ](*,)
Thank you in advance for any help.
0
Comments
The best way to fix this problem is to do your formatting in NAV, append the extra zeros needed when needed. There is logic in NAV already to count the number of decimals - than pass the correctly formatted amount to the check program.
The other gotcha in the North American edit is the check translation report that thinks US Dollars miraculously become Canadian dollars.
You should change the multi-language for the text variable for US Dollars to be US Dollars for other languages.
http://mibuso.com/blogs/davidmachanick/
I guess my big issue after check all windows regional settings / etc is that how come this is not an issue on the many customers who have been upgraded and in Cronus. Why is this only an issue on this upgraded database.
I know alterations to the check layout can be pretty common but I should not have to nor have I ever needed to change the original code in the check - granted maybe adding an extra field to the stub but never a change for something like this.
It just doesn't make sense - there has to be something else and this sort of thing drives me crazy. :x
Anyone else have any idea's, comments ?
Any MVP out there... that'd be great. Thanks. [-o<
There is probably some Windows setting that is different.
Sometimes it is just easier to fix what you understand.
http://mibuso.com/blogs/davidmachanick/