Double sales tax in PO Invoice for Project

(0) Share

Report

Posted on by Community Member 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

All responses (7)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 ?
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

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 Microsoft Employee on at

Like (0)

Report

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 :

Regards,

Satria
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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