Hi,
after clearing of VAT accounts (via sales tax payment), sales tax report still showing a saldo on one of VAT accounts, despite of the fact that TB closing balance is 0. Does any one know what can be potential reason of that?
Thank you in advance for your support
Br
Kacper
*This post is locked for comments
Hello Kacper,
Can you check if somebody changed the setup of those accounts?
I would expect that.
Do you have the database log enabled?
Irrespective of that, I would expect that both lines are posted in combination with a sales tax code.
Can you check that in the general tab of your journal?
Many thanks,
Ludwig
Hi,
there is no locked on "Do not allow manul entry". It means that the system allow you to post on both accounts menthioned before.
This is the orginal voucher.
Hello Kacper,
If 27400 is a sales tax account then one should not be able to post directly on this account.
Can you test this in a demo system?
Thanks,
Ludwig
Hi Ludwig,
27400 is settlement account but the posting type is sales tax. What do you mean by overlooked?
Thank you for your advise
Br
Kacper
Hello Kacper,
Account 27400 is also a tax account, right?
From the transaction origin, I can see that the sales tax code was posted with account 27100 only.
Is it possible that it was overlooked to enter the sales tax code also for account 27400?
Best regards,
Ludwig
Hi Ludwig,
please find attached printscreen
And here is the report
Please advice
Br
Kacper
Good Morning Kacper,
The manual postings on account 27100 and 27400 is made on ledger accounts according to the screenprint shown above.
If you click the transaction origin button, do you see that the sales tax 'module' was affected by this posting?
In addition, can you run the GL-tax reconciliation report for the period in which this manual correction was posted?
Best regards,
Ludwig
Hi Ludwig,
I reveived additional info that may change the view of the issue. The system transferred (sales tax payment) 154k to much (instead of 82k). This thing created closing balance that was corrected by manual posting.
This was situation after when VAT account was cleared.
Accountant have booked a manual posting (Debet: account 27100/Credit: account 27400).
And TB is showing 0
What is strange that I cannot call this clearing because the vat account showed saldo after clearing.
Please suggest.
Br
Kacper
Hello Kacper,
Can you find out how the manual posting was made?
Usually you should not be allowed to make a posting on a main account that is classified as sales tax account.
AX should come up with an error message saying that direct postings on a sales tax account require the specification of a sales tax code.
Do you know if somebody change the type of the account and removed the 'sales tax' classification before they made the maual posting?
Can you share the voucher and transaction origin of the adjustment posted?
Many thanks and best regards,
Ludwig
Hi,
I got a new info Ludwig. I am sorry that I mislead you. Accountant cleared VAT account but the system didn't empty properly VAT account. After that account made a manual posting VAT account vs settlement account to clear vat (was not able to use sale tax payment again). Maybe that is probably the reason why the report is showing the saldo (the system doesn't take into considartion manual booking, looks like).
The report I used:
GL-Reporting-Reconciliation-Sales tax-Sales tax
Name of report will be "Sales tax/Ledger reconciliation"
What should be the next step to correct the value in the report. As I said, system doesn't allow to run again clearing.
Thank you for your advice
Br
Kacper
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (