how to round this vat / CST amount
hansika
Posts: 373
Hi,
Nav 4.0 Sp3.
I created a Purchase order with Localvcurrency .
That Vat amount is showing is 112. 34
So i need to round that amount = 112.
For this i done In General Ledger setup
Vat Rounding precision = 1 , Nearest
Still it is showing the same 112.34.
So how to round this vat / CST amount ?
Please let me know.
Nav 4.0 Sp3.
I created a Purchase order with Localvcurrency .
That Vat amount is showing is 112. 34
So i need to round that amount = 112.
For this i done In General Ledger setup
Vat Rounding precision = 1 , Nearest
Still it is showing the same 112.34.
So how to round this vat / CST amount ?
Please let me know.
hansika
0
Comments
-
While calculating Tax, CST takes rounding precision from VAT rounding setup defined in G/L Setup.Thanks,
Ritesh K Singh0 -
ritesh.singh wrote:While calculating Tax, CST takes rounding precision from VAT rounding setup defined in G/L Setup.
Thanks ritesh,
I done that setup in G/L setup . still it is not rounding that amount.
Experts please pass a Transaction about this .
May be it is a BUG in navision. :-khansika0 -
It works fine.
Delete the PO details and enter afresh.
If it doesnt works, check if any mods are there.Regards,
Deep
India0 -
Thanks Deep,
I am working on Nav 4.0 sp3 HF 6. cronus databse.
No Modifications,
I created a P Order with Localy currency .
Could u explain what setups I need to do to round the Vat amount because I already setup the Vat rounding precision = 1 , Vat rounding type = Nearest..
I am still getting the values with out rounding.
Please suggest me.hansika0 -
experts, please help me...............hansika0
-
[-o< let me know about this setup................. ](*,)hansika0
-
hi experts,
still i am getting the same problem.
let me know how to solve this proble.hansika0 -
Vat Rounding Precision on G/L Setup card is the only setup you need to create for rounding VAT/CST amount. Recreate the order and check.CA Sandeep Singla
http://ssdynamics.co.in0 -
Thanks ,
I am working Nav 4.0 SP3 HF6
Before I create the p Order I done all setups regarding TDS, TCS, service tax, Vat in General Ledger setup.
Not only vat TDS, TCs , Service tax is also not rounding .
For all Taxes Rounding precision = 1.0
Rounding Type = nearest.
Still it is not rounding .
So let me know what is the problem.hansika0 -
It is not working...
I have modified the code in purchase line (for purchase invoice).
Follow the steps
open purchase line table
f9
find "india vat"
After this line "VAT Amount" := "VAT Base Amount" * "VAT %" / 100; write below code
GLSetup.GET;
IF GLSetup."VAT Rounding Precision"<>0 THEN BEGIN
IF GLSetup."VAT Rounding Type"=GLSetup."VAT Rounding Type"::Nearest THEN
Direction:='='
ELSE IF GLSetup."VAT Rounding Type"=GLSetup."VAT Rounding Type"::Up THEN
Direction:='>'
ELSE IF GLSetup."VAT Rounding Type"=GLSetup."VAT Rounding Type"::Down THEN
Direction:='<';
"VAT Amount" :=ROUND("VAT Amount",GLSetup."VAT Rounding Precision",Direction);
END;
This should resolve the issue..
Note: Direction is Text type variable.Thanks,
Ritesh K Singh0
Categories
- All Categories
- 75 General
- 75 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions