[farrago]

Can we access {paymentmethod} in a fulfillment record? If so, how?

I need to show what sales channel each order came in through on our fulfillment record. The best way is to use a custom transaction body field that reference the payment method as each sales channel has a different payment method. So, I made a custom formula field like this (set it to ‘store value’= no)…

CASE

WHEN {paymentmethod} = ‘Amazon Payment’ THEN ‘Amazon’

WHEN {paymentmethod} = ‘Walmart-EFT’ THEN ‘Walmart’

WHEN {paymentmethod} = ‘eBay-Paypal’ THEN ‘eBay’

ELSE ‘www.ourdomain.com’

END

It works great on sales orders, but when applied to a fulfillments it gives us an error.
This is a cached copy. Click here to see the original post.

[erictgrubaugh]

If you can get it from the Sales Order, then on the Fulfillment you might try `{createdfrom.paymentmethod}` instead. This will reach back to the originating Sales Order and grab the payment method directly from there.

[chanarbon]

Agreeing with Eric. If you also check it from the Records Browser (https://system.netsuite.com/help/hel…lfillment.html) paymentmethod is not a field in the item fulfillment but it is rather a field sourced from the sales order to which it is created from.

[farrago]

Thanks. It worked. Used…

CASE

WHEN {createdfrom.paymentmethod} like ‘Amazon%’ THEN ‘Amazon’

WHEN {createdfrom.paymentmethod} like ‘Walmart%’ THEN ‘Walmart’

WHEN {createdfrom.paymentmethod} like ‘eBay%’ THEN ‘eBay’

ELSE ‘our web site’

END

Lets say the custom filed ID was {custbodysales_channel}, then when adding this custom field to the fulfillment email (via NetSuite’s customize website text), would we use to get that field into our fulfillment emails? I tried that and I get an “error processing dynamic tag” message appearing in those emails.

[farrago]

Found the convoluted workaround to adding the custom field to the fulfillment email in SuiteAnswers (Answer Id: 31505).

[Author]

Posts