Sales tax rounding off on tax declaration posting voucher

(0) Share

Report

Posted on by Pratik Bhosle

414

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.

Screen 3 Sales tax code set up

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pratik Bhosle 414 on at

Like (0)

Report

Hi Ludwig thanks

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pratik Bhosle 414 on at

Like (0)

Report

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.

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pratik Bhosle 414 on at

Like (1)

Report

Hi Ludwig

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

Thx

P B

Was this reply helpful? Yes No
Verified answer

Pratik Bhosle 414 on at

Like (1)

Report

Hello

The problem was solved changing the rounding form to NORMAL

Was this reply helpful? Yes No