Found an interesting case in DAX AX 2012 R3 of a Purchase Order that completed all approvals in workflow and approval status changed to “Approved” however the “Confirm” button was not enabled. So the business user could not proceed further.
On checking the PurchLine table via AOT, I found that the column named “Blocked” had records where Blocked=1.
On MSDN there was not much detail on the field as shown below:
Even though logging on the table was enabled it showed the user did not not update the same. None of the other POs in the system ever had any rows with blocked=1.
Based on this I manually changed this back to blocked=0 for the records in this PO. This fixed the issue as the button became enabled and user was then able to confirm the PO.
Keep on DAXing.