VAT Calculation
-
2012년 4월 24일 화요일 오후 1:06
Hallo @ all,
I would like to have crm dynamics 2011 do the VAT calculation Automatically. I would very much appreciate any help on how to achieve this. At the moment we can only enter the tax manually.I would like the crm to automatically calculate VAT of 19% (Germany VAT) and if possible an option to calculate 19.5%, 20% , just incase the taxes should ever be increased or decreased in the future.
Somesort of free Add-on would be more appropriate for me.
A java script is also welcome (please make it very easy to implement ) I have no knowledge of javascripting and I have also not used it in crm.
I sincerely thank you all in advance for your help.
모든 응답
-
2012년 4월 24일 화요일 오후 1:54중재자
This is a pretty standard jscript type of a problem. in settings - customizations - customize the systems - entities - pick an entity - forms you can attach jscript web resources to the onload, onsave of the form, you can also attach jscript to the onchange of fields to do these types of calculations.
http://danielcai.blogspot.com/2011/04/microsoft-dynamics-crm-2011-javascript.html
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- 답변으로 제안됨 Jamie MileyMVP, Moderator 2012년 4월 24일 화요일 오후 1:54
-
2012년 4월 24일 화요일 오후 1:59
Hi,
You can do this in many ways.
1) You can write a plugin.
2) You can do it in JScript (JavaScript) on the OnSave event.
Also if you are worried of changing percentages, then create a configuration entity. It only has 2 fields: Key and Value. You can then create a record with Key = VAP and Value = 19%. When VAT changes to 19.5% or 20% or any other value, then update this field. Now at the time of calculation just read this value every-time you do calculations.
The other option is to hard-code this value in the code. For example lets say you want to calculate VAT in you JScript. Then just save this 19% in a variable. Writing JScript is simple. All you need to know is how to read a value from a field and how to save the calculated value in another field. Take a look at the blog below:
http://crmbusiness.wordpress.com/2011/02/17/crm-2011-javascript-xrm-page-basics/
I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: 
- 답변으로 제안됨 Ashish Mahajan Australia (Architect) 2012년 4월 24일 화요일 오후 1:59
- 답변으로 표시됨 Joelbike 2012년 5월 2일 수요일 오전 7:27
-
2012년 4월 26일 목요일 오후 12:46Hi,
If any of the responses answered your question and you are satisfied, please mark the response as an answer and vote as helpful. This will help others to search on similar problems.
Thanks in advance.Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin:
