Sage 100

 View Only

  • 1.  Updating IM_ItemWarehouse

    Posted 05-05-2020 16:05
    HI All,   I am by no means a scripting guru, i have studied at the feet of the Master but don't do it enough to be really good at it. (all praise to Alnoor)  I have a client that has a UDF in the CI_Item file.  They want it updated to IM_ItemWarehouse.   I have a script that does it by looping through all the records.  It works but it is slow (takes a second or two for the Accept button to "take") and seems a bit like a brute force update.  Is there a way to make this a bit more "targeted"?   

    Thanks for any thoughts.

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Updating IM_ItemWarehouse

    Posted 05-05-2020 16:27
    Use a browse filter... before your MoveFirst().  That way you are only scrolling through rows for that item (instead of the whole table).
    retVal = oIMIW.SetBrowseFilter(sItemCode & String(30-Len(sItemCode),Chr(0)))

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Updating IM_ItemWarehouse

    Posted 05-05-2020 22:14

    Hi Kevin,

       So, I have a really stupid question as syntax is what kills me in scripting.   Do you mean this line literally or is it an abbreviation for IM_ItemWarehouse? Or do I need to declare the object first?  

     

    retVal = oIMIW.SetBrowseFilter(sItemCode & String(30-Len(sItemCode),Chr(0))) 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    Use a browse filter... before your MoveFirst().  That way you are only scrolling through rows for that item (instead of the whole table).
    retVal = oIMIW.SetBrowseFilter(sItemCode & String(30-Len(sItemCode),Chr(0)))

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 4.  RE: Updating IM_ItemWarehouse

    Posted 05-06-2020 01:28

    Hey Kevin,

      I found it in my manual so I think am good.  Thanks much for pointing me in the right direction!!

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    Hi Kevin,

       So, I have a really stupid question as syntax is what kills me in scripting.   Do you mean this line literally or is it an abbreviation for IM_ItemWarehouse? Or do I need to declare the object first?  

     

    retVal = oIMIW.SetBrowseFilter(sItemCode & String(30-Len(sItemCode),Chr(0))) 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     





  • 5.  RE: Updating IM_ItemWarehouse

    Posted 05-06-2020 08:52
    All Hail to @Alnoor Cassim​​!!!!!

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 6.  RE: Updating IM_ItemWarehouse

    Posted 05-06-2020 10:25
    oIMIW would be replaced by the named object you opened to IM_ItemWarehouse... I just abbreviated.  :-)

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content