Hi everyone, We have an auto invoicing script that had been working for over a year begin to break very recently with this error:

name: "INVALID_RCRD_TRANSFRM",

message: "That is not a valid record transformation.",

on this code:

record.transform({

fromType: record.Type.SALES_ORDER,

fromId: data.salesId,

toType: record.Type.INVOICE,

isDynamic: false

});

can the sales order be transformed into an invoice from the ui?

Yes

what does the url look like while doing so

Is this happening on all your sales orders?

It’s not doing it on all orders. Probably, about 20%. But it just started happening about 1 week ago and previously it always worked just fine.

I've only seen that error if the from ID is bad or you've messed up the to/from record types which doesn't seem to be the case here.

the most common ones are that the sales order cant be billed into an invoice

yeah the bad ID was lumping in there but thats gotta be it

Yeah, it’s billable, and the id on the sales order is valid

Do you have a Sales Order that worked vs this one that isn't that you can just do a visual compare against to double check?

Yes, and so far the issue seems to be with SOs from a specific department where the payment method is blank as terms are set to net 30. That’s the only thing I am seeing so far, but, AFAIK the payment method should be that way on those orders.

what does the script look like

It’s a bit of a long script that checks for several fields on Item Fulfillment records on the SO, and if all that criteria meets certain settings, it then grabs some shipping values, adds those up, and creates the invoice and adds a fee to the invoice. So, I am hesitant to paste the entire thing here. But, for example, this saved search grabs the SOs from two departments. If I change that department lines of the filters to just ‘35’ nothing will break. It only breaks on dept 37, and the only thing I’ve seen there are the payment methods thing I mentioned above. But it otherwise works, and was even working for dept 37 until about a week ago:

var salesorderSearchObj = search.create({

type: "salesorder",

filters:

[

["type","anyof","SalesOrd"],

"AND",

["status","anyof","SalesOrd:F","SalesOrd:E"],

"AND",

["mainline","is","T"],

"AND",

["department","anyof","35", "37"]

],

columns:

[

search.createColumn({

name: "internalid",

sort: search.Sort.ASC,

label: "Sales Order Internal Id"

}),

search.createColumn({name: "total", label: "Total"}),

search.createColumn({name: "tranid", label: "SO"}),

search.createColumn({name: "status", label: "status"}),

search.createColumn({name: "paymentmethod", label: "Payment Meth"})

]

});

the usual is enough code to reproduce the issue

just an update here, this started working on it’s own again the following day without any changes. 🤷‍♀️🙄