Beas script for Inventory Transfer with Bin Location

Comments

7 comments

  • Avatar
    Martin Heigl

    Hi Alvin,

    - via DataIntegrationHub

    http://www.beascloud.net/docs/help/online_eng/index.html?datenimport_-export.htm

    - via common interface

    http://www.beascloud.net/docs/help/online_eng/index.html?common_service.htm

    - via window event system

    http://www.beascloud.net/docs/help/beasscript2/index.html?win-handle.htm

    - or the "modern way" in beas 9.3 PL 2 via web service (BSL)  - current only BETA Version

    http://www.beascloud.net/docs/help/bsl/index.html  ( <- current BETA )

    Comment actions Permalink
  • Avatar
    Alvin Daroy

    Hi Martin,

    Thanks for the reply. I'm currently using the common interface. but I don't know exactly what script to be use to perform the Bin Booking. Can Please provide sample script?

    Thanks,

    Alvin

    Comment actions Permalink
  • Avatar
    Martin Heigl

    Hi Alvin,

    which beas version do you use? Is it possible to use beas 9.3 PL 2?

    Comment actions Permalink
  • Avatar
    Alvin Daroy

    Hi Martin,

    i"m using beas 9.3 PL2

     

    Comment actions Permalink
  • Avatar
    Martin Heigl

    Hi Alvin,

    in beas 9.3 PL 3 you can use the new beas service layer over common service

    Really simple

    Comment actions Permalink
  • Avatar
    Martin Heigl

    beas script example:

    destroy=res
    declare=res=ue_reservation
    res=planned=new=transfer
    // Add all lines here
    res=planned=addline=itemcode=1111<tab>&
    whscode=BW<tab>&
    bincode=001003<tab>&
    towhscode=BW1<tab>&
    tobincode=A-0102<tab>&
    quantity=1
    // save
    res=planned=updateline
    // execute
    res=transfer=comments=myTransferDoc1
    destroy=res


    You can test this in server manager




    and it is possible to convert this in C# code

    if you click on this icon, the system save follow in the clipboard

    String sql = "insert into \"BEAS_COMMON_INPUT\"";
    sql += "(\"COMMONTYP\", \"PARAMETER1\", \"TEXTPARAMETER\") values('script', '',\r\n";
    sql +="destroy=res\r\n";
    sql += "declare=res=ue_reservation\r\n";
    sql += "res=planned=new=transfer\r\n";
    sql += "res=planned=addline=itemcode=1111<tab>&\r\n";
    sql += "whscode=BW<tab>&\r\n";
    sql += "bincode=001003<tab>&\r\n";
    sql += "towhscode=BW1<tab>&\r\n";
    sql += "tobincode=A-0102<tab>&\r\n";
    sql += "quantity=1\r\n";
    sql += "res=planned=updateline\r\n";
    sql += "res=transfer=comments=myTransferDoc1\r\n";
    sql += "destroy=res )";

    SqlCommand command = new SqlCommand (sql,connection);
    command.ExecuteNonQuery();

     

     

    Comment actions Permalink
  • Avatar
    Alvin Daroy

    Hi Martin

    This solved my problem. Thank you so much.

    Regards,

    Alvin

    Comment actions Permalink

Please sign in to leave a comment.