Updating the Payment Method on a Sales Order using a script

[remmett365]

Hi all,

A customer I am working with is looking to update a Card payment that has failed on a Direct Delivery Sales Order to an 'On Account' payment so they can invoice it.

For context, we are unable to update the payment manually, as the delivery note has been posted. Also, because this is linked to an invoiced Purchase Order we are unable to cancel the delivery note on the SO.

We would like to create a script to update the field 'Payment Method' from 'Card' to 'On Account'.

I would also like to know, if we develop a script to update the payment method from 'Card' to 'On Account;, will we also need to edit other fields also. For example,

CardTypeID - Currently 'Mastercard' - Do we need to update this to be blank if on account?
CustPaymType - Currently 'CreditCard' - Do we need to update this to on-account?