Best Of

@Martin Randall

I know this is an enhancement request & I hope you voted for it and provided a business case as to the burden of not having the enhancement and benefit of having it.

We use Celigo CloudExtend, currently the Google Workspace version but previously the Microsoft 365 version & both overall, worked the same way. The MicroSoft 365 version is more feature rich, however.

We store our executed contracts on a shared google drive and link the folder to the necessary NetSuite record.. (We used to store on Microsoft OneDrive and worked the same way.)

Once the folder is on the NetSuite record (Entity, Contact, Transaction, etc) you can also drag & drop any new files to the folder on the record & it is stored in the source folder on our Google Drive….

You might think about it. It's relatively inexpensive.
Below is a link to some related videos
https://www.youtube.com/results?search_query=cloudextend+netsuite

If you want/need anyone's contact information, let me know.

Hi all,

Yes, I was able to install the bundle #509148 yesterday.

Hope that helps!

I can't recall if I ever tested this on historic transactions. It probably won't impact anything historical. If you have a Sandbox, you can try it there.

The other option is to create RMAs for the applicable Sales Orders.

Hi @User_KBEB1,

As per SuiteAnswers Id: 80840, "Any changes made to the Create and Maintain Revenue Element Upon Closed Sales Order preference is prospective in nature" This means that it will only affect those transactions closed after the changes to this preference.

Hi @User_WA9MO

you need to add the manual exchange rates

refer SuiteAnswer Id7717

Grace Catabian-Oracle, we were able to get the formula corrected. This is the one that worked. (custbody28 is the Amazon Date Time Stamp that is brought over into the custom field)

Setup > Accounting > Setup Taxes

Hi @User_WA9MO

1. Enable the Currency Exchange Rate Types feature lets you store multiple currency exchange rates for a currency pair and date.

2. This feature is available in NetSuite OneWorld only after you enable the Multiple Currencies and Intercompany Framework features

3. You cannot disable the Currency Exchange Rate Types feature after you enable it.

4. NetSuite permits up to three active currency exchange rate types, including the default. You can rename the default type, but you cannot make it inactive. Each currency exchange rate type must have a unique name.

Hello @Dext3r,

Just to confirm, yes, inventorydetail.inventorynumber is the right filter to use.

I was able to verify this on my end. Here is a sample saved search that works on my end.

var transactionSearchObj = search.create({
   type: "transaction",
   filters:
   [
      ["inventorydetail.inventorynumber","noneof","@NONE@"]
   ],
   columns:
   [
      search.createColumn({name: "tranid", label: "Document Number"}),
      search.createColumn({
         name: "inventorynumber",
         join: "inventoryDetail",
         label: " Number"
      })
   ]
});

I hope this helps!

If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.