I'm trying to transfrom a sales order to a cash sale, but it keeps erroring on the below code. I am getting an unexpected_error. Has anyone ran into this issue before? fyi: It works from the UI

var invoiceObj = record.transform({
    fromType: record.Type.SALES_ORDER,
    fromId: i_so_id,
    toType: record.Type.CASH_SALE,
    isDynamic: true
});

try turning off dynamic mode?

Are you sure that is a valid transformation? It doesn't sound like one. In other words...Sales Order and Cash Sale are kind of synonymous transaction types, the only difference is how payments occur. Transformations don't work that I know of between transactions like this, but rather creating another transaction like an Invoice from a Sales Order.

I'd check your IDs. Unexpected Error typically means you did something stupid and netsuite doesn't know how to handle it. May be the ID is bad for the Sales Order. Would def try removing dynamic mode.

I agree with @creece. Add this before the transformation.

log.debug({title: "SALES_ORDER_ID_AUDIT", details: i_so_id});

So the ID is correct. I did the log and it is correct. The SO is the correct id and turning dynamic false doesn't fix it. I even just did a record.transform() record.safe() and it still errors with "unexpected error"

Check what other scripts operate on the Cash Sale. I have had errors cascade from other scripts to tranformations.

var invoiceObj = record.transform({
    fromType: record.Type.SALES_ORDER,
    fromId: i_so_id,
    toType: record.Type.CASH_SALE,
    isDynamic: true
});
log.debug("stuff", {
    createdfrom: invoiceObj.getValue("createdfrom"),
    customform: invoiceObj.getValue("customform")
})
invoiceObj.save();

all of it logs the expected info

also try making the

i_so_id

explicitly a string or an integer

Might want to change save to be the following just in case.

invoiceObj.save({ignoreMandatoryFields: true});

Tried that already Marvin 😕

My only other guess is there is some specific defaultValue you need to set when doing the transform

@creece hardcoded the created from id and set isDynamic false & true and both resulted in the same "unexpected error" when calling .save()

Per @Sandii you might want to try explicitly set entity.

var invoiceObj = record.transform({
    fromType: record.Type.SALES_ORDER,
    fromId: i_so_id,
    toType: record.Type.CASH_SALE,
    isDynamic: true,
    defaultValues: {
        entity: entity_id
    }
});

@Marvin cashsale.nl?id=36745&memdoc=0&transform=salesord&e=T&itemship=5125952&whence= does that mean itemship is a default value?

certainly worth a try

@Marvin If I set anything as a default, entity, itemship, etc it gives the error

ou have entered an invalid default value for this record transformation operation

Comment out each and see which it is.

Both did it. I tried them individually

That's weird

entity

is documented as available as a default value.

agreed!

Permissions?

it's a map/reduce running as admin. Plus it works on some and not on others

Memorized transactions?

It doesn't say memorized on the IF or sales order

If it works on some and not others. Sounds like it's not the syntax of the code. Do you have multiple subsidiaries?

Nope, just 1 😕

If you aren't already, then if you're transforming it in dynamic mode, then you'd need to set whatever fields you need to set in the UI on the Cash Sale before saving. I would honestly take that out of the equation and see if you can do a transform and save without doing anything other than the transform.

order status?

@creece that's what I've been testing with. A straight transform followed by a save. Still gives an unexpected_error

Did you try ignoreMandatoryFields: true for the save yet?

Yup

is there a script on the cash sale doing something?

I disabled all of them and ran it and still got it lol. Same with workflows

SOs don't have GL impact

For some reason I have to set the "paymentoperation" even though it's set on the sales order 🤦🏼‍♂️

did anyone mention backordered? pretty sure cash sale do inventory on the same step, so if back ordered, it'll be blocked??