Resolve raise system red hand problem on the Open vendor transactions editing
AP - > Vendor detail - > Functions - > Open transactions editing - > Is marked
Problem description
I am not able to select invoices on open transaction editing form of Accounts Payable payment journal. its triggering error message "This transaction has been marked for settlement by another user" with Red hand stop symbol for all vendors and for all transactions.
Resolve as below,you can delete the record from SpecTrans
wrote by Jimmy Dec. 16th 2010
resolved Red hand
static void Jimmy_ClearSpecTrans(Args _args)
{
SpecTrans SpecTrans,delSpecTrans;
;
print tableid2name(212);//LedgerJournalTrans
select firstonly SpecTrans
where SpecTrans.RefTableId == tablenum(VendTransOpen)
&& SpecTrans.RefRecId == 5637193902;
print SpecTrans.RecId;
print tablenum(VendTransOpen);
delete_from delSpecTrans
where delSpecTrans.RecId == SpecTrans.RecId
&& delSpecTrans.RefTableId == SpecTrans.TableId
&& delSpecTrans.RefCompany == SpecTrans.dataAreaId;
pause;
// 5637190813
}