Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales tax payment
Microsoft Dynamics AX (Archived)

Sales tax payment

(0) ShareShare
ReportReport
Posted on by Fabio C. 230

Hello, 

after a code upgrade from R2 to R3 for an italian customer we are facing problems with this report and the related transaction.

Scenario: September 2018 

Sales tax payment transaction close the related Vat (purchase and sales) main accounts to 0 

October 2018 

Sales tax payment transaction do not close the vat related main accounts (this is mandatory), they are open for a certain amount related to different taxtrans from different vouchers.

All the tax trans are from voucher with a sales tax with the 'use tax' active, and only few of the taxtrans related to these vouchers contribute to the difference on the main account

Since we upgrade in September 2017 we face this problem every month except for September 2018.

We try to understand where is the problem with the 'reconciliation sales tax report' that before posting of the October 2018 sales tax payment didn't show any deviation while after the posting show a difference related to a specific tax code (image attached)

2019_2D00_01_2D00_31-18_5F00_23_5F00_31_2D00_Window.png

Does anyone experience the same issue with the sales tax payment report?

Thank you.

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Sales tax payment

    Hi FBA,

    Not sure if I do understand your provided information. Are all invoiced posted with use tax or only these with the difference? If it is related to the use tax, are all  vendor invoices with use tax wrong after the update?

    It is normal that use tax will be posted in the system with a use tax and an offset account. It is not normal if it causes differences on the tax declaration.

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales tax payment

     

    Hi Andre,

    unfortunately not...

    I find out that transaction origin of vendor invoices affected by this problem show lines as follow

         transactionorigin.png

    The two lines with main account 2.531.002 and module Sales tax are the exact amount that I can retrieve from the taxtransgeneraljournalentry table, both with other two taxtrans  from other 2 invoice generate the deviation on the main account.

    All these vendor invoices are posted with the Use tax on the sales tax group

    According to you Is this behavior normal?

    thank you

    kind regards

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Sales tax payment

    Hi FBA,

    This TaxTransGeneraljournalaccountentry table is a link between the TaxTrans and the GeneralJournalAccountEntry. Have you also searched for possible manual transactions on the ledger account where no tax transaction is created?

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales tax payment

    Further analysis show that all the taxtrans have a transaction on the TaxTransGeneraljournalaccountentry table with Offset account type. Do you know when and why it creates a transaction on this table?

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: Sales tax payment

    Thank you both,

    we try to run an SQL query but no transactions match our deviation.

    About the hotfixes we are on CU12 and most of them concern previous versions.

    We proceed with the Sales Tax payment of December 2018, now there is another taxtrans related always to a Use tax voucher that deviate for december and which added to the november deviation.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax payment

    Hi,

    There have been a couple of hotfixes for Italian sales tax issues.

    Have you installed all of them?

    Please verify and compare you system version with the fixes released on LCS.

    See e.g. fix.lcs.dynamics.com/.../Results;dm=0&v=5_7&i=2_1_3_4&ct=1_3_5_4_2_6&ft=1_2_3&cu=&pi=&pm=&pc=&rd=&d=&envId=&permission=&x=7&y=16

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Sales tax payment

    Hi FBA,

    Can you find out if there are new transactions posted in a period prior to October? The TaxTrans records do get a version field (hidden from UI) filled when the TaxPayment is updated. You can run an SQL query on the TaxTrans table to see which records still have Version "0" and meet the amounts of your deviation.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans