Taxes invoice journals

(0) Share

Report

Posted on by Jorge Btc

115

Hello,

I am doing an invoice journal, I capture the first invoice with its id and its taxes, I'm going to call it F1 for example with an amount of $100 and taxes of $16.

Secondly, I capture another invoice F2 with an amount of $200, and taxes of $32.

Finally I capture the third invoice, this is a tip that belongs to invoice one (F1), but it has a different account and it doesn't have taxes, so I capture again F1 with an amount of $30 without taxes $0.

The total of this taxes it should be $48, but if I consult totals I get $64, aparently it is duplicating the taxes of F1 captured in first line.

If I consult the entry before I register the journal, the amount of the taxes is correct, if I register the journal and after that I review the entry is correct too, the problem is that when user consult totals apparently the calculation is wrong, so user is afreid of register the journal due to a bad tax calculation.

Does anyone has a similar problem? Any help?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jorge Btc,

Can you let us know what you are doing with the third invoice that you enter? It is not very clear from the description above.

Can't the problem of the tax calculation for your third invoice simply be removing the sales tax group or the item sales tax group for the third invoice line?

Some additional information possibly supported by some screenprints might help.

Many thanks,

Luwig

Was this reply helpful? Yes No
Jorge Btc 115 on at

Like (0)

Report

F1

F2.

F1 Without taxes

Totals.

Was this reply helpful? Yes No
Jorge Btc 115 on at

Like (0)

Report

Hi Ludwig,

I already removed the sales tax group, apparently It doesn't calculate anything but if I consult totals I have a different amount.

I added some pictures about the example.

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

Like (0)

Report

Hello Jorge Btc,

Does the first line in your journal include a sales tax Group & item sales tax Group?

If so, can you try to remove it?

Can you also test if the total tax amount changes if you completely remove the item sales tax group and tax group for your third line?

It seems that the total tax amount is not correctly updated. Yet, would be great if you could test whether the removal of the tax/item tax Groups changes anything.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Jorge Btc 115 on at

Like (0)

Report

Yes, first line includes sales tax Group & item sales tax Group but this is correct, and the calculation of taxes of this line is correct as you can see in the picture.

If I remove the item sales tax group and tax group for my third line the amount in totals is the same, it doesn't change. Only if I change de amount in first line the total tax amount changes but it is calculating wrong again.

If I change the order of lines, I capture second line (F2), then first line (F1), and finally third line (tip of F1) the taxes calculating is right.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jorge Btc,

I tried to replicate your issue in a demo machine and was able to get things right.

Can you check your tax Setup?

I believe that there must be something wrong with the calculation parameters setup in your tax codes.

Would be great if you could check this and let us know.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Jorge Btc 115 on at

Like (0)

Report

Hello Ludwig Reinhard,

I already did that, I have the same configuration as you mentioned.

I did the example again as yours, and I get the correct taxes calculation, I think this is because you didn't put the ID of the invoice.

This is the same example with id's, you can see how the amount of taxes calculation is different than the first one.

Please capture the same ID to your second and fourth line, and another ID to third line and check again.

Would be great if you could check this and let me know.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jorge Betancourt,

I actually run into a similar issue than the one you describe above when I enter the invoice ID in all lines.

However, after updating all dates - that is re-entering the date value it disappeared.

By the way, why do you enter the invoice ID in all lines?

You actually need it only in the line where you specify your vendor.

What AX version do you run AX2012 R2/3 CU8/9/...?

Have you already checked LCS for an available hotfix?

... and, what is more important, have you tried posting the voucher in a test/demo System?

Best regards,

Ludwig

Was this reply helpful? Yes No
Jorge Btc 115 on at

Like (0)

Report

Hi Ludwig,

The user does this in order to identify each line with its voucher because we have a lot of vouchers in this journal.

We have Microsoft Dynamics AX 2012 R3 CU9. I don't know if there is a hotfix to this issue.

I already posted the journal in a test system and the entry is correct, apparently it is just the view, but this is confused to the user.

Best regards.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jorge Betancourt,

So, it is a display issue. That somehow a good news as the postings are ok.

I checked on LCS but have not found a hotfix that matches exactly your issue.

Having said that I blieve that you have two options to go forward.

The first (and probably fastest) option is to grab a developer who helps you getting this fixed in the code.

The second option is to open a MS support request and ask MS to fix it for you and all other AX users through a hotfix.

The alternative would be to live with the issue but - as you mentioned - this does not seem to be an option for he users.

Best regards,

Ludwig

Was this reply helpful? Yes No