Sage 100

 View Only
  • 1.  Customer is requesting an automatic print of picki

    Posted 12-13-2012 07:50
    Customer is requesting an automatic print of picking tickets after the SO is printed So we did a post write on so sales order header: There is no error message but nothing happens. Can't figure out what I am missing. Any help would be appreciated. Sub PostWrite500() retVAL = oSS1.nSetProgram(oSS1.nLookupTask(""SO_PickingSheetPrinting_UI"")) soPrint = oScript1.NewObject(""SO_PickingSheetPrinting_rpt"", oSS1) 'oSS1.nTerminateUI() retVAL = soPrint.nSelectReportSetting(""STANDARD"") retVAL = soPrint.nSetKeyValue(""ReportSetting$"", ""STANDARD"") retVAL = soPrint.nSetKeyValue(""RowKey$"", ""1"") ' RowKey 1 or 2 retVAL = soPrint.nGetOptions(strOp) retVAL = soPrint.nSetKey() retVAL = soPrint.nSetValue(""SelectField$"", ""Order Number"") retVAL = soPrint.nSetValue(""SelectFieldValue$"", ""Order Number"") retVAL = soPrint.nSetValue(""Tag$"", ""TABLE=SO_SALESORDERHEADER; COLUMN=SALESORDERNO$"") retVAL = soPrint.nSetValue(""Operand$"", ""="") retVAL = soPrint.nSetValue(""Value1$"", OrderNo) retVAL = soPrint.nWrite() retVAL = soPrint.nProcessReport(""PREVIEW"") End Sub


  • 2.  RE: Customer is requesting an automatic print of picki

    Posted 12-13-2012 08:04
      |   view attached
    There is a setup option in Sales Order Options Quick Print tab


  • 3.  RE: Customer is requesting an automatic print of picki

    Posted 12-13-2012 10:07
    I've never seen BOI methods (those with an ""n"" prefix) used in an event script. When initiated from an event script I've always executed them as an external app. Are you sure this is supported?


  • 4.  RE: Customer is requesting an automatic print of picki

    Posted 12-13-2012 17:02
    I agree with what @DanBurleson says. Unless you've instantiated a new ProvideX.Script object that you're not telling us about, this would probably fail. Could you include a picking sheet (based on the SO_SalesOrderWrk table) as a sub report in the page footer/report footer of the Sales Order form?


  • 5.  RE: Customer is requesting an automatic print of picki

    Posted 12-13-2012 18:26
    I was thinking exactly that @AaronClark. Putting the picking sheet in the footer would probably be easier.