Sage 100

 View Only
  • 1.  I have a customer asking the following regarding M

    Posted 09-24-2011 03:09
    I have a customer asking the following regarding MAS scripting in 4.4: Using Sales Order Entry as an example, can I pass variables to the script that aren't in SO_SalesOrderHeader and SO_SalesOrderDetail. Specifically, I'd like to pull some values from CI_Item based on items in the order entry lines panel. If not, supposing I added some UDFs to SO_SalesOrderDetail, would they be available to scripts? While I think the answer is yes I wonder if our scripting gurus - @AlnoorCassim @RobertWood @DawnAnastasi could confirm/deny?


  • 2.  RE: I have a customer asking the following regarding M

    Posted 09-24-2011 04:06
    When do you sleep?????? I don't think they would have to use a UDF to display data from the CI_item as you should be able to display the informaton directly. I say this based on my conversations with Dan Burlseson on the topic.


  • 3.  RE: I have a customer asking the following regarding M

    Posted 09-24-2011 04:36
    You should be able to add them to the screen without scripting depending on what your end game is. But the answer to your question is yes.


  • 4.  RE: I have a customer asking the following regarding M

    Posted 09-24-2011 05:32
    Thanks guys I'll pass this along


  • 5.  RE: I have a customer asking the following regarding M

    Posted 09-24-2011 09:21
    The answer is Yes but there are different approaches available depending on the big picture goal. As we know, with Customizer alone you can just map a CI_Item field into SO_SalesOrderDetail as a UDF and add it to the Lines tab. But if you just need the CI_Item value for scripting purposes (and avoid UDFs), you can do it in 1 of 2 ways: 1) Use the GetChildHandle method to the ItemCode data source. This is the best way because you don't have to get a new object (less script overhead) 2) Use GetObject to get the CI_ItemCode_bus object


  • 6.  RE: I have a customer asking the following regarding M

    Posted 09-24-2011 12:16
    Ditto on what Alnoor said. I've gotten info from CI_Item from a SO_SalesOrderDetail script many a time.


  • 7.  RE: I have a customer asking the following regarding M

    Posted 09-25-2011 16:07
    Thanks much!