So try this….Ĭaution: an error here can cause an anomaly in the database …and that would be bad – very bad! Use this with extreme caution and perhaps with the assistance of a technical person. That said … again you may find that there are no un-posted journals, and it is not possible to perform the above. Follow the steps as described in step above. If you click “No”, on the open transaction editing form, you can manually uncheck the record.Īs an alaternative, from the specification form itself you can navigate to the journal. Do you want to uncheck?” Click on “Yes” and it will be unlocked. The System will throw a message that “Marked transaction exist. Click Function and then open transaction editing. Go to that journal, open it, and search for the locked record usng the payment amount. You can see, for example the journal number / voucher number where the transaction is locked. This will also work with a Payment proposal. On the specification form, you will see to which payment journal it is locked. Select the record with red mark, click Inquiries and then Specification. Go to ‘All Vendors’ and then select the vendor and open 'Open transaction editing’ form. When I try to select the invoices again for payment, naturally the message “items are selected for settlement by another user” is displayed.Īssume that an invoice is marked for payment and is locked and you want to unlock it. Do you want to delete?” does not display, etc. When I create a new payment journal, nothing unusual occurs … but the message I expected … “transactions are marked for settlement. So … how do I unmark the invoices and remove the “big red mark”? However, there are no payment journals that are un-posted. It works for the client … maybe it will help someone else.Īn invoice is marked for payment. I think I have used a information from everyone! Here is what I have written as the solution. There might be some other way also, but i am not aware of that. But i will suggest to follow above mentioned steps. See, from the backend it may seem task to be easier in comparision to front end. Or…įrom the specification form itself you can navigate to the journal. If you click No, open transaction editing form. Do you want to unchheck.” Click on Yes and it will be unlocked. System will throw a message that “Marked transaction editing. You can go to that journal, open it, search the record with the help of payment amount. You can see, for example the journal number where the transaction is locked. On the specification form, you will see that which payment journal it is locked to. Select the record with red mark, click Inquiries and then specification. Go to the vendor and open ‘Open transaction editing form’ Now I need the SQL Query for the Table Browser (AX 2009 allowed not to delete the field RefRecId )Īssume that payment entry is blocked and you want to unlock it.

Delete the record by using the Table Browser or by using SQL Query Analyzer → AX2009.

Note The record ID is linked to the RefID field in the SpecTrans table. Right-click the record, and then select Record Info.Ĭlick Show all Fields, and then locate the record ID.

In the Open-transaction editing dialog box, select the record that incorrectly indicates that a payment is applied. Click Customers, select the customer, click Functions, and then click Open-transaction editing. For an Accounts Receivable transaction, click Accounts Receivable in Microsoft Axapta.Click Vendors, select the vendor, click Functions, and then click Open-transaction editing. For an Accounts Payable transaction, click Accounts Payable in Microsoft Axapta.Open the Open-transaction editing dialog box. Locate the record ID for the affected transaction.

To resolve this problem, follow these steps:

Uninstall redhand