- Locate the record ID for the affected transaction. To do this, follow these steps:
- 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.
- In the Open-transaction editing dialog box, select the record that incorrectly indicates that a payment is applied.
- Right-click the record, and then select Record Info.
- Click Show all Fields, and then locate the record ID.
Note The record ID is linked to the RefID field in the SpecTrans table.
- Open the Open-transaction editing dialog box.
- Back up the database before you remove the record.
- 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>
No comments:
Post a Comment