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.

Is there a way to factor in Holidays as well?

Wow this is perfect! Thanks Patrick!!

got it thanks

How do I get the {custom} option to appear from the list for the Alternate Date Range?

Hello, It is a Sales: Transaction Total (Revenue) Report

How can I add 30 days to this formula instead of just the next business day? Examples: PO Ship date is creation date + 30 PO Requested delivery date is creation date + 45

This is perfect. Thank you Ivy.

Hello Joy, NetSuite engineers have detected a defect with the logic related to the rename transaction records. This fix will be deployed for all NetSuite accounts in 1 to 3 weeks. Appreciate the check in, Have a great day!

The enhancement you requested is now available in SuiteIdeas for voting. Issue Number: 648856 Abstract: Ability to Put Picked to directly to Pallets (Skip Building Cartons) Details: Alternate Solution: None Current Status: Open - Accepting Votes Case: 4470606: Pick to Pallets

Thank you, I have submitted an enhancement request and will attach it to this once posted.

Thank you.

Also, since this pertains to WMS lite, which is no longer available, I do not see this in SuitIdeas under that ID or on search by cycle count:

Thank you for this. So even if I mark all for each set of 30, it wont release all correct?

Ok, determined it does let me have the zeros, problem is it's looking at on hand inventory instead of available. The 192 qty for this bin is actually in packed status and not technically at the bin anymore. How can I have NetSuite remove picked/packed items from the count? I don't want these included in the Cycle count…

Thank you.

Thanks Joy, I will look into this commit schedule.

This is exactly what I needed!! Thank you so much!!!

Ideally, if I have a charge item, it would get applied when the order ships and is not invoiced until it is shipped. Today, my charge item is set to auto fulfill (can be fulfilled is unchecked), but this appears as a billable sales order in the bill sales order queue for accounting. If I do mark that as checked, the…

Hello, That is how I have it today, problem is it's appearing to be invoiced already even though no shipment has occurred. Is there another way to add fees to sales orders?

I figured this out. I was able to do this via an after field Sourcing trigger workflow.

Looks like there's an issue:

It was my 3rd condition!! This is the correct formula. {subtotal}<=500.00 AND {entity.custentity7.id} = 'F' AND (UPPER({entity.custentity6})!=UPPER('4 - 500K +') or ({entity.custentity6} is null)) AND ({entity.custentity_custbuyinggroup.id} is null or {entity.custentity_custbuyinggroup.id} not in (2,8,24)) I am all set!…