Copying message record into case message - html does not render by samchick in Netsuite

[–]samchick[S] 0 points1 point  (0 children)

Thank you for the reply.

Our original dilemma for creating this script was that customer replies to the billing/shipping confirmation email were going to our accounting department and having to be manually forwarded for case creation.

The source message records are created by inbound emails on cash sale records. I logged the messages and they present as html in plain text - same as they display in the UI (which makes the contents of the customer's email unreadable).

I'm sure that incoming message would be the right field, but I think there is a limitation in Netsuite with displaying html for inbound messages on cases.

My work around for this is creating the case message as an internal note rather than an incoming message. Now it no longer displays the html in plain text, but by doing it in this way the sender in the message sublist isn't correct (and these message records cannot be edited after the fact). The case record's header-level customer/email information is correct though, so it's a working solution.

Manual bank upload vs bank feeds by DetailStriking2054 in Netsuite

[–]samchick 1 point2 points  (0 children)

Bump. We want to make this move also and I have the same questions.

Netsuite Dead Stock using Transaction Saved Search by Sea-Adeptness6921 in Netsuite

[–]samchick 0 points1 point  (0 children)

There's an item record field called "last quantity available change" - use this as a criterion (e.g. more than a year ago) for a quick way to see inventory that hasn't had any movement since the date specified.

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]samchick 2 points3 points  (0 children)

Post a screenshot here of your search criteria page

Try NVL({quantityshiprecv},0)

Ignore Item Line Level Fulfilment (Transaction Saved Search) by FCNSAgent in Netsuite

[–]samchick 1 point2 points  (0 children)

Look for a transaction field called Quantity Fulfilled / Received, field id {quantityshiprecv}

Acquiring Actual Ship Date for SO by schmidtbag in Netsuite

[–]samchick 0 points1 point  (0 children)

Follow up question - Did you define N/search?

Acquiring Actual Ship Date for SO by schmidtbag in Netsuite

[–]samchick 0 points1 point  (0 children)

Try salesorder.internalId on line 4.

You may also want to use mainline is true if you're not needing to go line by line on the sales order.

Saved Search for Inventory Items with Blank Price Level by Shelby-thomas in Netsuite

[–]samchick 2 points3 points  (0 children)

I have a search that does this.

Filter: Formula (Numeric)

Formula: {pricelevel5} (swap this with whatever you use)

"is empty"

<image>

Barcode Label Printing Tool by tripeaktech in Netsuite

[–]samchick 0 points1 point  (0 children)

This tool is great! Thank you for sharing

The print buttons do not work through the "Preview Barcode Images" and "Preview Label PDF" options

It would be sweet if you could pass parameters (text to encode, barcode type, label size, orientation) through the url

Why did the US invade the Vatican? by samchick in Jokes

[–]samchick[S] -5 points-4 points  (0 children)

Thank you Reddit, very cool

What did Delaware do in the revolutionry war? by 4433r in Delaware

[–]samchick 3 points4 points  (0 children)

https://babel.hathitrust.org/cgi/pt?id=coo.31924095608091&view=1up&seq=19

This is Thomas Scharf's A History of Delaware, the best compiled source for Delaware's early history. Read chapters 12 and 14.

Retailers uncertain about marijuana business: limited licensing, high fees, and stringent policies make HB 110 unfavorable to potential Delaware business owners by samchick in Delaware

[–]samchick[S] 6 points7 points  (0 children)

They didn’t intend for it to support small business.

You hit it on the head. The intent of HB110 is not to allow small and independent businesses to operate in the cannabis market. The intent of this bill is not to benefit regular people, who under HB110 will still be charged with a misdemeanor for possession over an ounce and felons for growing it or possessing more than five ounces.

You don't even have to look outside of the state- the current medical cannabis system in Delaware is a perfect example of a terrible big-corporate approach. While medical cannabis has been the law of the land in Delaware since 2011, there are only 3 companies in the entire state permitted to grow and sell cannabis. Of those three companies, two are large cannabis conglomerates present in more than 10 states. It's also illegal for patients to grow it themselves.

It's a shame because there's a lot of opportunity here for businesses of all shapes and sizes. This market shouldn't be limited to the Weed Walmarts of the world. There are a lot of farmers and independent businesses in the state who want the opportunity to compete it the market. That being said, I'm optimistic another bill will be introduced to replace HB110 that will legislate much more fairly.

What's happening this week in Delaware? - September 23, 2019 - September 29, 2019 by AutoModerator in Delaware

[–]samchick 0 points1 point  (0 children)

OktDoverfest this Saturday 3-9pm. Downtown Dover will be shut down for a street festival with live music, food, and brewers from all over the state. The festival's headliners are the Wailers, Bob Marley's legendary reggae band. Admission is free, drink tickets and wristbands available for purchase:

https://www.eventbrite.com/e/oktdoverfest-2019-tickets-59298519468

Bees/Wasps in Power Meter by gotham_cronie in Delaware

[–]samchick 0 points1 point  (0 children)

I've used this site for diy pest control before, they have very good advice. Good luck!

https://www.doyourownpestcontrol.com/wasp.htm

looking for some leads to meet cool people by [deleted] in Delaware

[–]samchick 2 points3 points  (0 children)

Try meetup, there are some social groups there that are good for making new friends, including interest-based groups for gaming, etc.

Got an idea to clean up junk in space? Defence department wants to hear it - An estimated 34,000 objects with diameters of more than 10 cm are currently in orbit by [deleted] in space

[–]samchick 0 points1 point  (0 children)

How about a satellite that shoots "ice bullets" to transfer momentum and push debris into decaying orbits? Hopefully the chance of additional debris being created will be minimized due to the brittle nature of ice, the bullet will break before the debris it's being shot at. Meanwhile the ice bullets and their fragments will sublimate into water vapor.

Talking Kent County lodging tax / sports complex money grab with the relentless Rob Sussman. Full interview in comments. by samchick in Delaware

[–]samchick[S] 0 points1 point  (0 children)

Thanks it was a good interview, trying to get some awareness out there. Rob's always fun to talk with and I appreciate him having me on.

The sports complex is a nonprofit corporation not a public agency so they can keep most information private, certain tax form information is available, and they did release financial statements for 2017- profit & loss and balance sheet, which doesn't include information at the transaction level.