Hi all, hopefully easy one - is there a way to send an existing attachment on a transaction with an email, without having to re-attach in the email window or hunt through the File Cabinet folders? Hopefully a checkbox or link that I'm missing.. 🙂

is there a way in suiteql to identify the transactionline is being picked from the item and apply sublsit only. I tried it with iscogs='F' and istaxline = 'F', looks liek gettign the right results, but just wanted to confirm, if there is any other way to get the right records, maybe some joins will make it more clear.

We recently reduced the number of bins that we use at one of our locations. Now, our Inventory Counts are listing 2 bins for each item...the old and the new. How can we make sure the old bins are excluded from counts?

Hi Everyone 🙂 I need to upgrade to Netsuite2 soon. I have 3 ODBC connections with 3 different softwares, Fabric, Solution 7 and a payroll system. Do I need to update the connections at the same time? They won't effect each other will they? So I could update one this week, one next week and so on? Also, the upgrade won't effect the UI at all will it? Do I even need to do anything on that front? we dont use in depth analytics or anything. Thanks in advance!

I'm not even sure exactly what I'm asking here, but does anyone have any insight or personal anecdotes on what the ratio of netsuite/it workers they have based on the number of employees or general size of the company? We have 1 full time admin and 1 part time admin who are responsible for all the customizations/reporting/maintenance/etc for a company of around 250~ employees with 5+ different sales channels. Starting to feel a bit of the pain of being spread too thin, but I don't know if we're just doing it wrong or are generally inefficient as admins.

Can someone porivde me sample suitescript to remove a specific item and replace with itemtype itemgroup on the saleorder, I am trying to do it with a userevent script event type edit but getting error and unable to set the itemgroup type item?

Hi everyone, I’m working on a SuiteQL query in NetSuite and I need to pull the '*cogsamount'* field. I tried checking the Transaction, TransactionLine and TransactionAccountingLine records, but I’m not seeing a clear way to get it in SuiteQL. Has anyone successfully retrieved cogsamount in a SuiteQL query? If yes, could you please guide me on which table/field to join or query from? Thanks In Advance!🙏

Hi everyone. We have the need of changing the exchange rate for a specific revenue arrangement line since the customer would love the plan be calculated from the date of the event (fulfillment). Since I think this is not possible, have you ever found a solution / is there an official pattern to do so? I was thinking about projects and milestones for example. Otherwise the only thing I have in mind is to create different sales orders and then group the invoices into 1. Any other idea?

Hello everybody, if you're attending Suiteworld in Vegas in Oct and want to meet up to discuss integrations/Celigo/ZangaBox then send me a DM on henk@zangabee.com

Anyone else loving how Celigo now added a eTail Order ID field to combat their eTail Order Id field???? Not sure why this was necessary but I just wonder how many levels of approval this went through and yet still no one thought this was a bad idea......(smh) 😑

Hey all, Is there a way to switch between center tabs using keyboard commands?

Anyone have experience integrating P6 project management software? In either NetSuite or Quickbooks?

Hi! I am using a Fedex API call to track my orders. If orders show delivered, I want the delivery date to write back into Netsuite into my "delivery date" field on my Sales Order. Does anyone have experience doing this via API calls (and/or python scripting?)?

Did anyone else using CyberSource get this notice last month? Did you do update your key successfully? I performed the prescribed change today (update the P12 key with a new one) and it completely broke our Credit Card processing. We're an ecommerce business so it's destroying our sales today. Now I fear for the weekend. I've been getting the standard run-around from NS Support for 5 hours now. I know the key is generated correctly, and had support watch me do it start to finsih to validate. Also, the key works..... but ONLY for my specific user. (No other user or context outside of my user in the UI can get a response from CyberSource). It smells of file permissions type problem on the new P12 key, but Support is scratching their heads on this.

Does NS WMS or RF Smart WMS support storage constraint considerations? For example, Bin A can only hold as much as X weight or volume or whatever units of measure. This would then skip the bin and not recommend in putaways.

have a odd question. I was tracking down a sales order that wasn't fulfilled all the way but was billed all the way out.. How was I able to invoice for full quantity without fulfilling the line item all the way? Would it have to have been changed in the invoicing screen?

Oh so NetSuite are now retiring SOAP. Fantastic.

Hi all. I have a customer that wishes to Automate the creation of Amortization Journal Entries. Has anyone had experience to automate this process? Is it even possible to automate this process?

Another question on Projects. On Implementations, we have set that the Resource must be assigned to the project before Assigning them to a Project Task. Once the resource is on the Resource Tab, there is a delay of hours before they appear on the Project Task in the Assignee drop down. Other than changing the Project Preferences, is there another way to update the Projects Lists in the background to speed up the availability of the Resource on the Project Task Assignee dropdown?

I'm trying to pull a saved search for my Assemblies. I am getting what I want for the most part but really just want to see Assembly item with quantity built for that assembly 2 components fields (Packaging Labor and Mixing Labor) with what I have now it's pulling all items in assembly when all I really want is the assembly item with quantity produced and the 2 component fields above. Do I need to change some summary types to get where I want to go?

I have question on Purchase order standard "bill" button : in admin role : success transform to bill, in other role : stuck in "recall button" , show in picture

Hi - I've created a workflow to make a field on a custom record mandatory based on a value entered in another field. [If field A = x, make field B mandatory] I first triggered on Entry but that didn't work for new records - it allowed field A to be x and field B wasn't mandatory. But if I edited that record, field B was mandatory. I tried on Exit, and that didn't work. I tried After Field Edit, which works, sort of. If I set field A to x, field B is mandatory, but if I then set field A to y - before saving the record - field B is still mandatory. Is there a better way to do this? Thanks!

someone with this problems?

Anyone else notice how the Commitment preferences no longer work for an item fulfillment? We have had it set to "Allow Committed" for years with no issues. Now you can't post an item fulfillment for uncommitted items! We had to change it to Ignore COmmitments? Weird

I have an order with committed parts less than order quantity, but we have a boat load in stock at another location. Is there a way to have my committed parts pull from any available location or do I have to transfer the parts to that location for committed parts to fulfill?

Hey! We're using EBP and I'm looking into having Approvals on vendors' Bank Details record. If one edit a vendor's primary bank detail record we want it to require an approval before its bills show up under Bill Payment Processing in EBP. So far, the only solutions I've come up with is unticking EFT Bill Payment on the vendor. That does not feel very clean. Is there someway to add a filter on a custom field to the search? Seems like that is the case for Generate Bill Payment File but not for Bill Payment Processing.

Hey guys, I have a custom record that has associated a contact and items, additional the custom record only has a name as mandatory field. The items source a multiselect field, I'm using pipe | symbol to separate the items the following works for creating a new instance of my custom record:

items, contact , name

id1 | id2 | id3, customer name : contact name , custom record name

A very similar CSV for update is throwing me an error that the item internal id is invalid. Invalid items reference key "21743". Is there any special trick for multi select fields sourcing from items?

So... we are in the US and have customers both in the USA and Canada to date. We were on the "legacy" tax system that lets us set up taxes for those two countries. We do NOT use OneWorld and have no need of international subsidiaries. We now have to support the collection of United Kingdom VAT on orders from a customer in England. But other countries are not available as tax nexuses in the "legacy" tax system. NetSuite created SuiteTax in 2019 and that supposedly would give us access to tax capabilities for over a 100 countries including the UK. After installing it in our sandbox, I still do not have the UK, or any country other than USA and Canada, in the new nexus creation page. I have installed all the associated bundles and apps that instructions told me to... bundles: suitetax engine, suitetax data records, EMEA localization marketplace suiteapps: United Kingdom localization ...but still no additional countries available in the new nexus screen. The full list of countries, including the UK are available in Setup/Company/Countries I have a ticket in with support but was hoping for any help here as it is fairly urgent to get this set up.

Hello, can anyone guide me to as how to do single sign on between oracle apex and netsuite?

I created a customer part number for an item, I thought when you make a customer part number it changes your in house number to their number on all documentation. I did this change after entering a Sales Order and it did not update across the board..our part# is still on SO and Packaging slip. Will this not go into effect until I do a new SO ?