Best Of

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.

Hi Patrick!

Sometimes I wonder if there is anything you do NOT know :)

So, I followed all your steps, and I use advanced/legacy taxes, and I already had all of them in place.

Today I ran it again, and now tax is calculated indeed - I wonder if this could have been a maintenance-related issue, because I was working on this PST time around 11pm at night.

All in all, it works perfectly, and now I know where to check the tax - in the accounting subtab.

Thanks!

Best guru ever.

My apologies - I thought I posted yesterday, but didn't finish the post. I was able to use a list field rather than a checkbox in the workflow and this is working for us. Thank you again for your suggestions.

Hi @Kedalene

When a subsidiary is marked as inactive in NetSuite, the subsidiary is no longer available for selection in transaction forms and other areas where subsidiary selection is required. This inactive status means:

• The subsidiary won't be included in the revaluation process, so no new revaluation entries will be made for it.
• It won't generate or receive new elimination journal entries since it's not considered an active subsidiary during the elimination process.
• The existing balances will stay in the system, but no new adjustments will be made unless the subsidiary is reactivated and included in future processes.

This worked, Jervin. Thanks for your help!

Thank you for taking the time looking into it,

So I think the best workaround here is to create a custom field that does the memo field's job and use it in the statement. Will come back with updates!

Hi, Yes I did and the columns name do match.

I've found the solution to my problem by removing the '<#if result_index ==0>' part and adding a '<#if results?has_content>' before the list elelment, not sure why this caused an issue as result_index should have returned a value.

Anyway all working now.