VAT calculation issue on Bank payment fee (Sales Tax )

(0) Share

Report

Posted on by Community Member

Dear All,

Need your help on below issue;

Running the below scenario on vendor payment with bank fee and vat required to calculate on bank fee, following financial entries required to generate;

Dr Entries

Vendor Payment 100

Bank Fee 7

VAT/Sale tax 0.35

Cr Entries

Bank cr for Vendor 100

Bank cr for Bank fee 7

Bank cr for Vat 0.35

Same scenario works if we mark price include sales tax check box, but we need same for excluding sales tax

Please consider that for Indian region we use sales tax word for VAT.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

I replicated your transaction in Ax2012 and in my opinion this works out of the box.

Here is my journal setup

Here is my $100 payment

Here is my $7 fee

Note: My tax rate is 19% => 19% x $7 = $1.33 tax

After posting the journal, I got the following voucher

This looks - to me - what you want to have.

Can you try replicating this process in a contoso demo environment?

I used the German (DEMF) company for that.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your Reply.

Already check on AX2012 AND 365 on both working perfectly fine,i am facing this issue on ax2009

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

What Ax2009 version do you run exactly?

Best regards

Ludwig

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

I got the same result when I tested that in AX2009.

I tested this in the CEE demo company with the following setups

Can you try to test this with similar settings in your environment?

Note: the application Version that I used here is 5.0.1500.6491

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Do you have Access to the CEE MS contoso demo company and can you try to replicate the transactions that I posted?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for you reply.

Checked on demon data in CEU company,but facing the same issue.please share the configurations screenshot then i will match with my configurations.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

I did not make a specific configuration. My journal is setup as follows

and my tax Code calculation method as follows

The tax code is assigned to the sales tax group (AP-DOM) and the item sales tax group (RED).

I have not changed any of the other setups in the Contoso CEE demo system.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Doing the same but not getting success

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Muhammad Danish,

My guess would be that there is something different with the tax code and tax calculation setup but this is difficult to assess without being able to see your setup in detail.

Can you share some screenprints of what has been setup in your environment and how you processed the transaction?

Best regards,

Ludwig

Was this reply helpful? Yes No