• 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
    }



  • 相关阅读:
    Ubuntu
    VSCode
    VSCode
    Astyle
    Qt
    待办
    Qt
    Qt
    Qt
    python pip常用命令、配置pip源
  • 原文地址:https://www.cnblogs.com/Fandyx/p/1908268.html
Copyright © 2020-2023  润新知