Hi, in the new projects UI, the file drag and drop box has been moved from the top of the project form to the Communications > File tab. Does anybody know how I can put this back at the top of the page?

My friends, I try to get a search in Netsuite of payments applied to invoices booked on a specific revenue account. I have in criteria type = payment and applied to transaction item = revenue account. The search yields no results. I've tried applied to transaction account = revenue account as well but can't seem to get it to work. I am sure i should use applied to transaction but what kind of inner critera should I use?

Hi All, trying to do something that sounds like it should be simple but getting stumped... I have a multi select attribute on my items that is sourced from a custom record type. The custom record has various fields itself. On the item form, it only shows the name of the selected records. Is there a way to change the attribute it shows for lists sourced from other records?

NetSuite automatically creates a new tax control account for each tax nexus. Is that the best practice? So, if I'm transacting in 50 states, I'll have 50 GL accounts for sales taxes? It helps in filling out the tax forms (but not for all states). Or is it normal to maintain a single sales tax account for all states and just use analytic tools to get more granular data?

UOM: We have multiple conversions for a single case. Some may contain 6, 12, 15, and so on. Is it better to create a one UOM type for each variation or just create a single UOM type with multiple conversions underneath it?

In a saved search, is it possible to return the countries code or abbreviation?

Hi Vivian, I only have a minute before I log off. Something like this should work: <#if transaction.giftcertapplied !=0> ${transaction.giftcertapplied} #else</#if>

https://gyazo.com/7b39f6704e273784e0be92e8fe62a616 If you search BLD-8225.056.Z it shows up, but BLD-8225.056.ZW it doesn't.. any ideas?

Anyone know how to indent a line in an adv PDF?

Hi All!

Curious what people are using for shipping integrations with NetSuite? We need something that can do both Parcel and LTL. Would love you hear what you are using, your experience with it, and what issues you have run into with it. Thanks for the feedback!

A saved search would be a better way to do this. Put a criteria of Document Number=[your JE number] and whatever fields you need on the Results subtab.

Hello! 👋 Does anybody know if it is possible to edit the addressbook (State and ZIP) on beforeSubmit?

Does anyone know which Check Number (suffix) is controlled by the Auto Generated page? There's a few types of checks and it's a little confusing

Do access tokens work in sandbox?

Anyone been able to get FedEx labels to print out that require Signature? We're setting the fields properly as per the SA article, but have been getting a variety of errors. NS Support hasn't been that helpful. We've tried setting the address as "Residential" and adding in some of the Home Delivery stuff, but we're still having problems. Any ideas?

Why can't I delete a bank GL account? No transaction history No bank statement import No bank reconciliation Not in company bank details Not used in any custom record Not assigned as default supplier payment account Not used in allocation schedules Not used in item records

Hi, I am trying to create a workflow that on entry, sets a value on the vendor bill based on whether it is created from a PO or not. "Applied transaction = empty" was my first thought, but that's not available as a filter in workflows. I can do "vendor is empty / not empty", but that doesn't work all the way, since you can go to a vendor and create a vendor bill directly from that vendor. Any ideas?

I was just creating a saved search on the Location segment record. Parent of {parent} is a field on the record and is on the records browser, but the field is not available on a saved search. Just wondering if anyone knows why. One of those weird things I have trouble explaining to a client. (Or if it is available and I've just missed it, I'd love to be wrong.)

I have a question regarding credit card payments on SOs. My understanding is native Netsuite functionality will automatically send a reversal request to the credit card processor when a SO is canceled. Our company has a need to write a customization that will find all SOs that are at high risk of not fulfilling within 7 days (VISA compliance) and perform a credit card REVERSAL on those SOs WITHOUT canceling the SO. The direction we may take is a MR that will locate the at risk SOs and perform that REVERSAL on the credit card auth. My question is regarding programmatically being able to use any Netsuite native features to make that REVERSAL call. We use Cybersource today. For our MR solution, do we have API access within Netsuite to leverage the REVERSAL of the credit card auth on the SO without having to cancel the SO? Our other option is to write a custom REST API that will integrate with Cybersource's API to perform the auth reversal. Then from the Netsuite MR, we could call that REST API. Trying to avoid buidling a custom REST API if Netsuite has a native feature we could leverage.

I'm working on the Group Invoice advanced form. I see the invoices, is there's a way to get the otherrefnum of each invoices ?

I want to create a pipeline report or search that shows our open sales orders, but only the amounts remaining to be billed, does anyone know of a way to do this?

Good afternoon folks. We have tons of inactive saved searches. Ideas on how to go about deleting them all?

What field is this filter using? Is it custom?

Is it missing on the customer record or the sales order it was generated from?

Can anyone send me a link to easily copy a saved search from sandbox to production?

Is it possible to add multiple KPI scorecards to a dashboard? I have one that is based on Period, but need another to not be Period based to display other metrics?

Is there a way to create an email with a custom template every time a record is created WITHOUT a workflow or script?

Hi, I'm trying to create a custom "Transaction Detail" report that includes the project task. But there doesn't seem to be a way to add the project task to the report. Has anybody done this before?

I'm attempting to create an item saved search that will show items on Sales Orders but only if all of the child items are on that sales order. I've made it work with a transaction saved search, but that summarizes the data in a way that doesn't work downstream because I'm then trying to modify a transaction item sublist with a workflow. Anyone have any ideas?