Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We have a scenario where some free text invoices results in wrong amounts within the posted vouchers. The customer is running AX2012 CU3. (no customizations on this part)The amounts on the invoice, customer transaction and Sales tax transactions are correct, but within the legder itself the Tax amount is doubled and the amount on the customers account is raised with this amount as well. Mostly credit notes have this issue.
We found a possible hotfix within CU5 (KB2789665).
Has anyone this issue as well and/or knows how to reproduce this problem? We have to test the hotfix, but did not manage to reproduce this behaviour.
Never seen anything even remotely like this.
The sales tax functionality in my experience is fairly "stable"
did you manage to find any common denominator between all the wrong transactions?
are they using the same tax group/item tax group?
when you do the EXACT same transaction (including same date, same amount ,same customer) do you not manage to recreate the problem?
Thanks for your reply. From the around 600 invoices 4 went wrong. So it is a very rare situation. 3 of them are credit notes. What we also noticed is that the accounting date of the ledger transactions and the Sales transactation is different. As said there is no customization at this part. The situation were these dates are different is some more than the 4 occasions. As this does not have too much impact, we are focussing on the wrong amounts posted. But we keep this date difference in mind. There is a situation where the invoice date will be changed before posting the free text invoice. This must be something where it could go wrong with the date. I looked at the code change of the hotfix and it seems like there is a fix when the amount changes sign (so perhaps from positive to negative).
We now turned on database logging to see what the changes are before something goes wrong again, but we are waiting on a new occasion...
Tax group//item tax group, amount, date etc the same does not give me the situation I was hoping for reproduction.
In the 12 years I work with AX I have never had a situation where I could not manage to reproduce an issue.
It also happened in my AX... I totally have no idea how it happened...
Note: I am new to AX 2012
My AX is:
Kernel ver: 6.0.947.862
We still have not the reproduction scenario for this issue. We have installed the hotfix KB2789665 after evaluation of the differences. There is one major difference about how to handle negative or positive sign.
As it was a rare scenario, we have not made the conclusion that it is solved. When it does not happen for 6 months, we can make the conclusion that this was the correct hotfix.
Perhaps you can ask for this fix as well.
Thanks for the update. I need to check with my vendor is this Hotfix already apply to our AX or not...
Even we had a a couple of cases where Sales Tax was posted in a different date compared to Invoice Date.
Hello,This is very old post, but I have currently the same issue with AX2012 CU10 for free text invoices.I try to look for your Hotfix to get more information, but I can't find it anymore. I found one with the same number in LCS, but everything what was written there was for something totally different.One what I found is about: KB 2789665The Free Text invoice displays negative values after processing a Sales Tax Adjustment
Maybe you remember does your hotfix at the end fixed your issue?
I don't know if the issue was solved or not. At that time I was hired temporary. I haven't heard anything after my contract ended. If you are on CU10, then this hotfix should already be part of your installation as it was included in CU5.
After 4 years, unfortunately, I don't remember all details anymore.
I have the same problem at one of our customers. This customer is running AX2012FP CU3.
I think it has to do with the TaxUncommitted table. What I notice is that the free text invoices, where the Tax amount is double posted, (still) have a record in the TaxUncommitted table. In addition, these wrong vouchers have a different TransDate in the TaxTrans than the vouchers have in the CustTrans and CustInvoiceJour.
Normally when you create a free text invoice you will only get a record in the TaxUncommitted table when you press the button Sales Tax before posting the invoice. After posting the invoice, this record disappears from the TaxUncommitted table.
Does this information give you a hint for a possible cause?
Heidi de Boer
I have seen the same in the past with FP CU3. When possible, try to upgrade to a more recent version as there are some issues fixed already.
Business Applications communities