web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Resolved: How to c...
Microsoft Dynamics AX (Archived)

Resolved: How to change sales tax settlement period from month to quarter?

(0) ShareShare
ReportReport
Posted on by user5555 7,437

Hi,

It seems that my system was/is set to sales tax settlement periods of months instead of quarters. Periods on the sales tax per month show sales tax statements, but I want to have quarters. I used the sales tax list and the balance statement to do my VAT since I cannot not get it out of AX.

I checked Financials I and checked the complete setup. I change settlement period to quarter and created new periods and run recalculate period balances. I changed all settings to quarter and created the new periods in 2010 and 2009. However, if I look at Sales Tax Posted I see under 'special' that the sales tax continous to be posted on 'month' instead of 'quarter'. Also the version in which settlement took place is there. Recalculating balances does not help.

Does anybody know how to rewind this situation so that my tax statements of fiscal year 2009 are correct and AX also start posting in quarters instead of keeping posting in months? I have changed the settlement periods on the tax groups/ codes, but it simply refuses. I also looked in company --> sales tax if no setting is there about fiscal period = year/month/quarter.

I also tried to update the Period --> Sales Tax --> Sales Tax with quarters instead of months, but it says: period closed, no transactions. I think I need something to 'recalculate/ reset sales tax periods'.

 Any help appreciated.

J.

 

 

https://community.dynamics.com/forums/p/27767/47025.aspx#47025 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    In the TaxTrans table the settlementperiod is stored. If you have already made taxtransactions with Month as period and you now want to have the salestax payment based on quarter you would have to change the value from month to quarter in the taxtrans table. This will solve your problem. An update job or a SQL update job will do the trick.

    Kind regards,

    Dennis

     

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi Dennis,

    Thank you. I can do an update. But what I find strange is that the month period seems to be reported already and that the system does not do quarter posting now. I will give an sql update to try what happens.

    J.

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    Thank you. Resolved. The Report --> Sales Tax List and Period --> Sales Tax --> Sales Tax do match now. I cannot see a report which summarizes the total revenue. That would make checking revenue and sales tax easily. I also wonder how to post on 'sales tax payments' so that this information also becomes visible in AX or is this related to the 'vendor sales tax setup' and not used in Dutch tax system? So we use a ledger 'omzet belasting betaald' instead.

    J.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Under General ledger - Report - Transactions - Grouping there are two interesting sales tax reports. Sales tax transaction - details and salestax payment by code. Also via General Ledger - Inquiries - Tax - Posted Sales tax you can see all tax transactions.

    Normally when you use the period function sales tax payment and tick the update field all ledgeraccounts for sales tax are emptied to either the settlement account (which can be found in the posting profile for sales tax) or a vendor transaction is posted (the vendor is in this case the tax authority). The report that is presented with the sales tax payment function includes also the base amounts (if everything is setup properly of course :))

    Your question about how to post on sales tax payment i do not understand.

    Kind regards,

    Dennis

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi Dennis,

    No settlement account is set up for the Sales Tax --> Ledger Posting Groups. No vendor account is set up in the Sales Tax Authorities. This means an update actually does no update either the ledger, not the vendor account. I think the vendor account is used if you want to pay electronically. However, what if you receive money from this vendor? Can I read somewhere how to setup this functionality?

    J.

  • Community Member Profile Picture
    Community Member on at

    Hi J.

    more information can be found in Chapter 6 of the Finance I training documentation. This material is available via customersource.

    Kind regards,

    Dennis

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    Fixed: create vendor 'tax authority', create two ledger accounts: one for paid tax and one for tax to be paid. Add the vendor to the posting table so that if the vendor is found, it is posting against that ledger account. Assign the vendor to the tax authority. In this way the tax to be paid is posted on the leger 'tax to be paid' and then through the payment journal it is paid like a vendor.

    J.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans