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
}

 



posted @ 2010-12-16 15:19  Fandy Xie  Views(486)  Comments(0Edit  收藏  举报