Sage 100

 View Only

  • 1.  Alias Item table UDFS in SO Entry for Scripting Purposes

    Posted 04-24-2020 16:01
    HI there,

    I have some UDFs setup on the Inventory Item Alias table (IM_AliasItem)  I need to pull these UDFs into Sales Order detail when the Alias is entered/selected there upon entering a sales order

    I am having issues connecting to the IM_AliasItem table via the Item code and Alias keys within a script.

    Has anyone managed to get this connection to work?  or is anyone interested in giving me a quote on doing a script that does this?

    Thank you,
    Marc




    ------------------------------
    Marc Cregan
    Technology Integrators
    ------------------------------


  • 2.  RE: Alias Item table UDFS in SO Entry for Scripting Purposes

    Posted 04-24-2020 17:08
    Edited by Dan Burleson 04-24-2020 20:32
    I have done this using the following snippet. Were you padding out the ItemCode?
    		retVal0 = oAliasItem.SetIndex("KITEMCUSTOMER")
		
		retVal1 = oAliasItem.SetKeyValue("ItemCode$", Left(sItemCode & Space(30),30))
		retVal2 = oAliasItem.SetKeyValue("Type$", "G")
		retVal3 = oAliasItem.SetKeyValue("ARDivisionNo$", "")
		retVal4 = oAliasItem.SetKeyValue("CustomerNo$", "")
		retVal5 = oAliasItem.SetKeyValue("AliasItemNo$", sAliasItemNo)
		retVal6 = oAliasItem.Find()​


    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 3.  RE: Alias Item table UDFS in SO Entry for Scripting Purposes

    Posted 04-24-2020 18:05
    Hi Dan - 

    Thank you! Thank you!  I had forgotten about doing the padding piece!

    thank you,
    Marc

    ------------------------------
    Marc Cregan
    Technology Integrators
    ------------------------------

    Original Message


Related Content