Wednesday, January 16, 2013

Use of the Corrected Sales Tax Amount/Actual Sales Tax Amount field in AX 2012

Recently, we've encountered an issue with the Corrected Sales Tax Amount(AX 2009)/Actual Sales Tax Amount (AX 2012) field on the Invoice Journal form.

In AX 2009 and prior, you could adjust the sales tax for a given invoice journal line by changing the value in this field. The field could be added to the lines section of the invoice journal and entered quickly.

In AX 2012 using this functionality with the Public Sector and Project configuration keys enabled causes several problems.

  1. Automatic sales tax calculations are no longer carried to Actual Sales Tax Amount field after a sales tax adjustment

    After performing a sales tax adjustment using the Actual Sales Tax Amount field, the Sales Tax Override field is set for all new records following. With the override field set and no Adjusted Sales Tax Amount specified in the Sales Tax dialog of the Invoice Journal form, the sales tax appears as 0.

    To correct this, a user must enter the Sales Tax dialog and reset the sales tax values.

  2. Records are not removed from the TaxUncommitted table

    A record for the adjusted sales tax is created in the TaxUncommitted table. If information is to change on the line (sales tax group, invoice, date) with a modification made to the Actual Sales Tax Amount, the record may not be removed. When attempting to post the journal, all records referencing the specific journal in the TaxUncommitted table are used to create the relevant ledger transactions. As there is an additional TaxUncommitted transaction, the voucher will not balance, preventing posting.

    Again, the solution to this issue is to open the Sales Tax dialog and reset the tax values.

Our solution has been to disable use of the Actual Sales Tax Amount field on invoice journals and have users open the Sales Tax dialog for adjusting sales tax entries.

3 comments:

  1. Is there a parameter where you can setup that will disable users to override the calculated sales tax amount?

    ReplyDelete
  2. Hi,

    I'm using Microsoft Dynamics AX 2012, I am trying to apply an amount in the adjusted amount origin.

    However, the amount origin is 0.

    Therefore, the initial adjustment is revert back to 0 everytime I push the Apply button.

    Is there anyway that I can apply adjusted amount origin when the amount origin is 0?

    Please advise.

    Thanks.

    ReplyDelete
  3. I will recommend anyone looking for Business loan to Le_Meridian they helped me with Four Million USD loan to startup my Quilting business and it's was fast When obtaining a loan from them it was surprising at how easy they were to work with. They can finance up to the amount of $500,000.000.00 (Five Hundred Million Dollars) in any region of the world as long as there 1.9% ROI can be guaranteed on the projects.The process was fast and secure. It was definitely a positive experience.Avoid scammers on here and contact Le_Meridian Funding Service On. lfdsloans@lemeridianfds.com / lfdsloans@outlook.com. WhatsApp...+ 19893943740. if you looking for business loan.

    ReplyDelete