A red hand symbol appears next to an invoice in the "Open-transaction editing" dialog box when you try to apply a payment to the invoice in Microsoft Axapta or Microsoft Dynamics AX

Article ID: 894412 - View products that this article applies to.
Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
Expand all | Collapse all

SYMPTOMS

When you try to apply a payment to an invoice in Microsoft Business Solutions - Axapta, in Microsoft Dynamics AX 4.0, or in Microsoft Dynamics AX 2009, a red hand symbol appears next to the invoice in the Open-transaction editing dialog box. The red hand symbol indicates that a settlement exists for the transaction. You cannot select the transaction for settlement until the current settlement is either removed or updated.

CAUSE

This problem occurs when a record in the SpecTrans table incorrectly indicates that a payment is applied to the invoice. This problem may occur when any one or more of the following conditions are true:
  • Connectivity problems exist between the Microsoft Axapta client and the Axapta Object Server (AOS) instance.
  • Power interruptions occur at the database server, at the Axapta Object Server (AOS), or at the client computer.
  • Code has been modified in Microsoft Axapta.

RESOLUTION

To resolve this problem, follow these steps:
  1. Locate the record ID for the affected transaction. To do this, follow these steps:
    1. Open the Open-transaction editing dialog box.
      • For an Accounts Payable transaction, click Accounts Payable in Microsoft Axapta. Click Vendors, select the vendor, click Functions, and then click Open-transaction editing.
      • For an Accounts Receivable transaction, click Accounts Receivable in Microsoft Axapta. Click Customers, select the customer, click Functions, and then click Open-transaction editing.
    2. In the Open-transaction editing dialog box, select the record that incorrectly indicates that a payment is applied.
    3. Right-click the record, and then select Record Info.
    4. Click Show all Fields, and then locate the record ID.

      Note The record ID is linked to the RefID field in the SpecTrans table.
  2. Back up the database before you remove the record.
  3. Delete the record by using the Table Browser or by using SQL Query Analyzer.

    If you use SQL Query Analyzer, use the following statement. Replace the placeholders in the statement with the information that is correct for your situation.
    DELETE SPECTRANS WHERE REFRECID = <RECID FROM STEP 1D> AND DATAAREAID = <COMPANY DATA_AREA>

Properties

Article ID: 894412 - Last Review: July 25, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft Dynamics AX 2009
Keywords: 
kbprb kbmbsmigrate kbhowto KB894412

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com