Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Double sales tax in PO Invoice for Project

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I have an issue regarding the voucher created from PO invoice of some Projects.

The problem is :

There are 2 lines of Posting Type "Sales Tax" for each invoice. one line is VAT in the other is VAT Out. They offset each other. below is the screenshot :

8171.Capture2.PNG

My question is :

Why is this happen ? If there are some wrong setup, then where do I check ? or start ? I haven't experience this before and in total darkness here.

Additional info that might help :

1. The project type is fixed price with WIP feature turned on for everything (item,expense,hour, & on account)

2. The line property is Chargeable

3. The actual invoice from vendor is indeed have sales tax on it.

4. The sales tax for PO line inside AX is filled in properly (has sales tax group & item sales tax group)

Any help is much appreciated & if you need additional info, please do not hesitate to reply.

Regards,

Satria

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Hi,

    This should be ok. Yet be prepared that your accounting colleagues might need a bit more time at month end when they prepare their tax reports. Probably make a note that you changed the tax settings on 07 Oct at 14:30 (or whatever your current time is over there). This info might help them.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Thx for the advice Ludwig.

    But I decided to uncheck it for now, because after checking, from all legal entity, only this one is checked, and it's wrong. I think it is the result of someone tampering with the setup.  

    As for the reconciling. is creating general journal to adjust this not enough ? Sorry I'm really not familiar with how tax works in DAX.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Hi sat141a,

    Yes, if you uncheck it you should get only one single tax transaction and posting and not the offset anymore.

    Yet, please don't make this change in a running system during the working day!

    I would recommend that you test it first in a demo system and if everything is fine that you change the parameter setting over the weekend or during a time when nobody is working in your system.

    Otherwise, reconciling taxes will get very hard.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    yeah it is checked on the sales tax group setup). so uncheck this will resolve the issue ?

    8507.Capture.PNG

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Hi Satira,

    Have you already modified any of the parameter settings?

    The in-out posting is typically triggered by the activation of the 'apply U.S. Taxation rules paramter' and the activation of the following sales tax group parameter

    5618.tax.png

    Can you check whether the use tax parameter is activated in your case?

    If it is not, then can you provide some more details (screenprints) of the transaction and tax setup (sales tax group, item sales tax group, sales tax codes and the tax related ledger posting setup)?

    Thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Hi Ludwig,

    Thx for the reply. as for my country. currently this happen in IDN (Indonesia) country.

    As for tax advisor. she said that it should not happen. she said this kind of tax is for USA.

    As for the GL parameter. can you point out which one is the setup ? as for my AX GL setup is like this :

    34048.Capture.PNG

    Regards,

    Satria

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Double sales tax in PO Invoice for Project

    Hi Satria,

    Some countries have special tax rules that require such a VAT and concurrent VAT out posting. I do not know for your country; probably check with a tax advisor. The trigger for this in-out posting is the 'use tax' parameter setup in the sales tax group form in GL.

    Hope this helps,

    Ludwig

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans