Wednesday, August 30, 2017

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.


Monday, August 28, 2017

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

Tuesday, August 22, 2017

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.


Tuesday, May 2, 2017

FIFO Reservation with Standard Cost Inventory Model AX 2009

If your inventory model is Standard cost and you still want to have the on-hand reservation by FIFO, oldest batch number first, you can change the logic a little bit to get this ability Because of the oldest batch so it also means the oldest inventdim. So the trick is to get the oldest inventDim Id

Thursday, April 20, 2017

Print report on a pre-printed paper

When you have an issue where one user prints a report to a pre-printed paper has different layout with another user. One of the things you should check is to make sure they all have the same font size for reporting.

dimension lock issue

In AX 2009, when a sales order line is reserved against a purchase order or transfer order, and the dimensions are locked. When warehouse tries to receive the purchase order or transfer order line to another location, AX will not allow it. Depend on your customization that you may have a automated function to do the reservation based on the supply and demand. Behind the scene the unlock is pretty simple and straightforward.
On the inventTrans record, there is a field called InventDimFixed, if you find out each locking has its own defined number. In my example: 4 locked dimensions have value 263, 2 locked dimension has value 257. So you can just create a job or function to update the value accordingly. This will release the required dimension for receiving at the warehouse