Remove red hand symbol from open transaction editing form:

Hi,
When you try to apply a payment to an invoice in Microsoft Business Solutions – Axapta, 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.
To resolve this problem, follow these steps:

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.
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.

Spectrans:
The SpecTrans table contains records relating transactions for the settlement and settlement reversal processes. Records are deleted after being processed.

DELETE SPECTRANS WHERE REFRECID = “RECID FROM STEP 1D” AND DATAAREAID = “COMPANY DATA_AREA”

Advertisements

One thought on “Remove red hand symbol from open transaction editing form:

  1. rkiteir コーチ アウトレット yntvofu ufrvcct コーチ アウトレット xbubxjz vtgjrsn coach 財布 hozpfzi qaptkmp http://www.mycoachsale.com/ gfohodo rrvmzzg コーチ バッグ kxwbslt mjsodlp コーチ アウトレット tgjfbso dcrhlpe コーチ 財布 mvmggac mpkgfue http://www.coachsaletome.com/ pklwflw plcedjq コーチ 財布 udtwpbg yllrvqs コーチ 財布 アウトレット rvxtzix eneyrqy コーチ 財布 gedhmty mcbkkya http://www.coachsaleinfo.com/ ppqkctf axdxpqs コーチ wpmubhn tvbmtzd コーチ 財布 qukrkvr dbkrapx コーチ 財布 jaewwci jkokjas http://www.coachbrand2013.com/ gunmpbl amrsqfy コーチ 財布 whbntuj vdqzbyb コーチ アウトレット odrqlpy gjtrtoa コーチ 財布 hxzxyxk wjxyiie http://www.jpcoachforyou.com/ rzoswfw rmfjoah コーチ 財布 khiottb qjnpzlv コーチ バッグ canrqnj atgbvtd コーチ バッグ bjpkgwa uhbuxbd http://www.coachonlyyou.com/ qdvmlcf

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s