Tybrneryan Blue Ribbon

Was able to accomplish this via Mass Updates. Thanks!

I figured it out. Just needed to add .id for the formula field name.

Thank you so much Ivy!!!😀

Thanks that worked! Is there a way to add a rounding component for it? Just need 0.00 decimal places.

Getting the ERROR: Possible Divide by Zero for SUM(CASE WHEN {account} = '4000 Sales' THEN {amount} ELSE 0 END)/SUM((CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * ({item.custitem_unitsinasp}))

got it to work: ((CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * ({item.custitem_unitsinasp})) So the combined version would look like this? SUM(CASE WHEN {account} = '4000 Sales' THEN {amount} ELSE 0 END)/SUM((CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) *…

Getting invalid expression error: Does that look right to you? SUM(CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END) * SUM({item.custitem_unitsinasp}))

Thank you. In order for this to work I need a formula for CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END multiplied by {customfield1)

and CASE WHEN {type} = 'Item Fulfillment' THEN {quantity} ELSE 0 END multiplied by units in asp field

This is great! Thank you!

Hello, It worked with kit items, but it appears it doesn't work with Item Groups as it's giving me the out of stock message. To confirm, are Item Groups supported by the free gift promotions?

I have selected a customer for the test transaction. When I click add nothing happens. I'll have to open a support ticket for this.

Do you know why it wouldn't save and apply? Status is N/A. Order needs to be over $500 and this is over $600.

For you screenshot below, how did you navigate to there? These are my promotions types:

Thank you, but can I specify the qty for each free item as well?

So, this rule is still allowing orders to appear that have items back ordered.

Thank for you this. The data is being validated and I will update as resolved once I get confirmation the data checks out.

We're back up.

1 (866) 522-1508

Update: At 12:13 pm ET, a fire alarm was activated due to smoke in the co-located Boston data center facility where the NetSuite service is hosted. As a safety measure, it was required that power to the building be shut off. This has impacted service to all customers hosted at this data center. This situation is all…

Just received this update from NS regarding the defect: An event has occurred in the NetSuite Boston datacenter which has forced the local team to disconnect power until the issue is resolved. This has impacted service for those customers. The local datacenter team and NetSuite engineers continue to work on restoring the…

@Dominica Sevilla-Oracle Any Rough ETA? The status updates are pretty useless.

Most Texas accounts are based at the Boston Data Center. https://status.netsuite.com/

https://status.netsuite.com/

If i want to concat more than two items like Below? How would I do that? CONCAT('GF SKU:' ,{custbody_celigo_assembly_item},{quantity},{item.description})

Awesome! Thanks Ivy,

How would I organize this for multiple ship to's? Example: when {custbody_edi_store_number}=0022 then ship to internal ID is 49722209 when {custbody_edi_store_number}=0030 then ship to internal ID is 49722212 when {custbody_edi_store_number}=0040 then ship to internal ID is 49722215

I removed my cast statement for when the item rate is lower than the customer item price and I am getting results. But, I need this report to only show when the order item rate is lower than the customer item price.

Hello, Doesn't appear to work. I get 0 results.

Maybe start with any or if you have to pick one, IF works as well.