Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Sales tax rounding off on tax declaration posting voucher

Posted on by 410

Hello Experts,

If this was asked previously please provide me link for the solution. The issue I am facing currently is rounding off after the posting and that small variance in pence 0.41 goes into ledger account. Screen 1 appears to have taken 0.41 pence into rounding off account where Screen 2 shows declaration correctly including pence. I have got VAT codes round off are set to 0.00 and have also tried 0.01 but both way it's rounding off pence on posting voucher. I have also tried removing rounding off difference from accounts for automatic posting but it's not letting me to run declaration without that set up. All i need is my voucher should post with exact amount as appears on VAT declaration.  

pastedimage1595344167482v1.png

Screen 3 Sales tax code set up

pastedimage1595344415449v2.png

  • Verified answer
    Pratik Bhosle Profile Picture
    Pratik Bhosle 410 on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hello 

    The problem was solved changing the rounding form to NORMAL 

    pastedimage1596463924645v1.png

  • Pratik Bhosle Profile Picture
    Pratik Bhosle 410 on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi Ludwig

    I will update once i hear back from developer in order to close this query.

    Thx

    P B

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hello P B,

    Just wanted to follow up on this issue and ask if you have been able to get some technical support and find out more about this rounding posting line?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi P B,

    From an 'end user' perspective there seems actually nothing that you can directly do here. The setup seems ok and does not seem to justify a rounding variance of 41 pc.

    Did you have a look at the sales transaction details? Is it possible that those tax amounts posted are made up of multiple (thousands of transactions) that result in this large rounding variance?

    If this is not the case then I would recommend asking a developer for some help to look at the record created.

    Best regards,

    Ludwig

  • Pratik Bhosle Profile Picture
    Pratik Bhosle 410 on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi Ludwig

    Screen 1 : VAT code round off is set to 0.00. Fyi i have tried changing from 0.00 to 0.01 and i still get the same rounding issue. What i am trying to achieve is i don't want system to round off on my posting voucher and the value should as same as sales tax declaration.

    pastedimage1595402702708v1.png

    Screen 2 : VAT group round off is set to VAT codes

    pastedimage1595402788439v2.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi P B,

    Can you check your sales tax groups as well and check what setup is made in the rounding by field?

    Is the parameter by ...'sales tax combinations' selected?

    Best regards,

    Ludwig

  • Pratik Bhosle Profile Picture
    Pratik Bhosle 410 on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi Ludwig thanks 

    Yes that account I use for rounding. Following screenshot from Audit trail and Original document that doesn't tell me much.

    pastedimage1595366844562v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax rounding off on tax declaration posting voucher

    Hi P B,

    If I understand you correctly then account 31111 is your rounding account. Is that right?

    Have you already checked the audit trial and the original document buttons on how this voucher and the posting on this account was created?

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans