Personalization, Customization and Productivity Tools

[dosborn]

Is there a way to programmatically invoke the Sales Order Copy From functionality so that I can essentially pass in an existing sales order to a copy from method and get returned a new sales order number?

[Natasha · Accepted solution]

SO_SalesOrder_bus has a CopyFromOrder method.  It doesn't assign a new sales order number.  You need to set a new order number, copy another order, then write the new order.

CopyFromOrder(order$, type$, clearJob, copyMemos)

order$ = the order to copy

type$ = the new order type (eg. "S" for standard)

clearJob = to clear job information on the order or not

copyMemos = to copy order memo or not

[dosborn]

I get that the object doesn't support this property or method.  I am guessing I am not doing something quite right:

Set order = oScript.NewObject("SO_SalesOrder_bus", oSS)
With order
     strNewOrderNo = ""
     .nGetNextSalesOrderNo strNewOrderNo
     .nSetKey strNewOrderNo
     .CopyFromOrder strOrderNo, orderType, false, true
     .nWrite
End With

[Gator]

.CopyFromOrder

missing the 'n'

You can also use order.sLastErrorMsg to see if the commands are succeeding or not.

[jepritch]

Hi dosborn,

You'll have to either replace orderType with "S" or some other value.   Also, it should be nCopyFromOrder

Elliott

[dosborn]

Thanks, can't believe I didn't notice that.