Best Of

Hi @User_18AKJ ,

Upon checking internally, this seems to have been a bug and should be reported to Customer Support by creating a case with Support.

The only solution so far that I saw from other customers who experienced the same issue was to wait it out and by creating a case, Support can track this instance for future purposes as this seems to only be intermittent as you've mentioned you've only just upgraded your NS version.

I hope this provided some insight. Unfortunately, this is the best I could find.

Please let me know if you need any more help. 🙂

---

If you found this helpful, please consider clicking "Yes" on "Did this answer the question?" It's a quick and easy way to help others with the same question find the answer quickly. Plus, you'll earn points and unlock the Answer Accepter badge.

Thanks!

Hello, uncheck the store value on the field. You may also want the value to be decimal rather than integer since the value is a currency.

Thanks for the insights @CDuf 🙂

Yes, that is correct, it is currently not possible to merge one subsidiary to another.

Hi @User_RLV0D

You may check this discussion about merging subsidiaries.

You can reach out your Account Manager. Transferring transactions from one subsidiary to another can be done, however, this will require you the help of our Professional Services team as Cduf mentioned🙂

Hi thank you for replying.

The entry has been approved, but not yet billed. I mainly want to find out why the line gets hatched/greyed out, and the system does not allow editing and under what circumstance does it occur.

any advice on this?

Hello, i have found the solution to this.

Tagging here some of our top contributors in case they ran into this same situation before:

@Angela Bayliss @Dext3r @Midhun Nath @Amanda Edwards @Vernita @Paul Salkeld @Hormese Paul @Tigran Shahnazaryan

Hello everyone, your insights would be very much appreciated.

Thanks!

If you are trying to populate fields on item records with quantities fulfilled, and quantities committed or on backorder, these are native fields on the item records. If you're using advanced item location configuration, then the quantities on order, backorder, available and committed show natively.

Is this the information you are trying to pull into a search to add to an item field?

~angela

Hi @jt_kelly,

Glad to have you with us today and thanks for posting here in the NetSuite Support Community!

Hello, everyone! Feel free to participate in the discussion and share your valuable insights.

--

In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the most out of their NetSuite journey. Click here for more details.

Hello, @jt_kelly. Thank you for posting this question.

Unfortunately, there is no native way in NetSuite to automatically change the From Email Address to the Purchase Order Creator's instead of the Final Approver's in emailing the Purchase Order after Approval when the "To Be Emailed” box is checked.

Currently, the setting that controls the From Email Address when emailing transactions in general is the From Address For Emailed Forms preference which can be found by navigating to Setup > Company > Email Preferences > Transactions subtab.

Below are the options you can choose for this preference.

• Company Return Email Address – Email is sent from the address you enter in the Return Email Address field at Setup > Company Information.
• Subsidiary Return Email Address – Email forms generated in NetSuite are sent using the email address defined in the Return Email Address field at Setup > Company > Subsidiaries.
  • This option is useful when you have many subsidiaries and you send forms to your customers and vendors using email. You can use this setting to be certain that customers or vendors reply using an email address from the appropriate subsidiary and the information is delivered where it belongs.
  • Note: This option is available only in NetSuite OneWorld accounts.
• User Email Address – Email is sent from the address you enter in the From Email Address field at Home > Set Preferences. If you do not enter an email address here, email is sent from your login email address.

In your account, most likely, the option selected is User Email Address and, in the Final Approver's user preference (Home > Set Preferences), the From Email Address field is either blank or set to his or her own email address. This explains why on the Purchase Order email, the From Address Field is set to the Final Approver's.

There is a manual option that you could perhaps choose, which is to set the From Address For Emailed Forms preference to User Email Address and, on the Final Approver's user preference, he/she can set the From Email Address field to the to the Purchase Order Creator's email address. However, this may be inconvenient for you because the Final Approver will have to change the From Email Address field every time he/she is approving the Purchase Order of a different creator.

This limitation is currently covered by the enhancement request logged on Enhancement # 233052 Approved Purchase Requests: Ability to change value on the "From" field of Purchase Order email alerts from Purchase Approver/Supervisor to Purchase Requestor.

You can go to SuiteIdeas page to vote for the enhancement.

Apologies for the inconvenience this limitation may be causing you but I hope this helps clarify your concern.

Hi @emcee_uk, per SAID 7711, here's how Consolidated Exchange Rates are computed:

• Current rate - uses the base currency (GBP) rate from the Currency Exchange Rates list as of the end of the period (ex. January 31)
• Average rate - is a weighted average based on transactions amounts posted to all accounts with a general rate type of Average.
• Historical rate - is a weighted average based on transactions amounts posted to all accounts with a general rate type of Historical. 

For the Average and Historical, they are based on transactions posted on that Subsidiary to accounts with general rate type of Average/Historial. This can be the reason why they have different consolidated rates even though they the same base currency between Subsidiaries.

Here's also an article which shows you how to verify the computation which includes creation of saved search - NetSuite Admin Tip | How to Verify the Computed Average Consolidated Exchange Rate

Hope this helps! :)