transactions on voucher do not balance

In AX 2009 or AX 2012, from time to time you may encounter this issue.

There are many causes for this error, such as currency exchange, rounding issue. In this case, I would like to show one more, there could be a broken inventory transaction unfinished.

Below is an example, there is unbalance of inventory transaction for a quarantine order.

You can write a job to update the amount to offset the Sold or Purchased transaction. In the example above, there are 2 transactions need to be updated to match the Sold and Purchased ones. Note that they go in pair in this case.

Attempting to read illegal array index AX 2009

If you have the error like this when printing to pdf or run a function in AX that create the pdf file. It could be that the document you are trying to create has a special character that your pdf driver doesn't accept it.

Look up at every text field in the document, remove the special character, then try again, it should work.

It can be in the order line name, item name, comment, etc..

User Cache issue when update logic in AX 2009

You may into a situation when you need to update a change in a form in AX 2009 in production environment, and for some reasons, one or more users do not see the changes even after you restart AOS service, clear their user cache.
The solution is to make the user admin in AX, go to the object that needs to be updated, compile and restore to get the latest changes. Test to make sure the change is now applied to them. Revoke the Admin permission, done.

Item ... is locked for updates in warehouse ... because it is being counted - AX 2009

Sometimes you encounter this message when trying to post a picking list, or packing slip, etc. And you have checked and there is no open cycle counting journals.

The issue is in the table InventItemLocation, the field "CountingStarted" is not unchecked by AX.

Just open the table, go to the record and uncheck the field, if you are sure there is no open counting journal line for the selected item.

Quarantine order transaction

This is the illustration of the how the transactions are created for the Quarantine order in AX 2009.

The first one is when Quarantine order is at status Started

This one is when the Quarantine order is at status Report as Finished. After this you can End the order.

AIF Setup HTTP issue 404.17

2. HTTP Error 404.17 

i)Navigate to the path where ServiceModelReg exe is stored

(Eg.-C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Communication Foundation)

ii)Run the command

                          ServiceModelReg.exe -i -x

Original link: http://shankardynamicsax.blogspot.ca/2011/05/common-errors-of-aif-web-services.html

Clear the Marked Payment From Customer Payment Process

This is typical issue when the Red Mark hand is shown on the open invoice transaction from Customer Details > Open Transaction Editing

Sometimes after marking and process the payment, the red hand doesn't go away. It is stuck in a table called Spectrans.

The relation to get to the record to delete is

Get the Recid from CustTrans table from invoice number
Get the Recid from CustTransOpen table from CustTrans Recid under RefRecId
Get the Record from Spectrans table from CustTransOpen Recid under RefRecid
Remove the record from Spectrans will remove the red hand.