the employee currency can only be set to match the base currency of their subsidiary. you can probably still enter transactions and select a different currency for them though. the exchange rate will just convert the amount to the subsidiary base currency in Euro though.

I don't believe it is possible to change the currency of the Expense Report to one other than that specified in the employee record. We have the same issue but as we use OpenAir we were able to rollout a custom solution that will import the Employee expense report into NetSuite as a vendor bill and therefore in any currency we want. The solution on SuiteAnswers for NetSuite isn't great https://netsuite.custhelp.com/app/answers/detail/a_id/42248/kw/Expense%20Report%20currenc

I do the same thing with Concur for a few of our employees. we import it into netsuite as a bill and have those employees set up as vendors.

@swojnicz @mhendricks Thank you

How does "WHEN ORDERED BY FIELD" in searches work?!? Followed NS's help example exactly but got no results. Any tips/resources for this feature? TIA

@johnmontego Can you post a screenshot of your search criteria / results tabs

Thanks @michoel . It's literally what the help section says, >For example, to return the amount for the most recent transaction by each customer, create a Customer search, select a results Field of Formula (Date), a Summary Type of Maximum, and a When Ordered By field of Date Created.

@User uploaded a file:

@johnmontego Here is a search I use it in, and it seems to work fine. It's a list of all items purchased by a particular customer, with the date and price they last purchased

That's helpful, thanks @michoel. I'll take a look at it & try recreating it here. Thanks!

Hey - has anybody integrated with an HR platform? If so, any recommendations?

@User uploaded a file: and commented: anyone bothered with that message every time you try to open an excel file exported from NS?

I built a fix, if anyone need it

@User uploaded a file: Excel fix.zip

I can't call a fix, but it is a workaround, it will add one line on your reg. So bear in mind you might need to update the command according to your excel version which may differ the path

I just started downloading everything as a CSV. 🙂

that is a solution 😄

Hey guys, is there any documentation available for Site Builder. I've been tasked with making amendments to a site don't really understand where a lot of the info is coming from.

For example a bundle has been installed and on some pages the js libraries from the bundle are useable but on others they don't seem to appear at all.

Anyone know how to include a company field on a Quick Add portlet for a Task on dashboard?

For custom fields, I know there is a way you can do this by going under customization and checking the checkbox Quick Add. Not sure how you include the standard fields like Company field on a Task.

@User uploaded a file:

i have to believe that will do it @neerajrtiwari

whatever your preferred custom form is for tasks

confirmed:

@User uploaded a file:

Thank you @al3xicon - that helped!

sure thing @neerajrtiwari

well played

I wonder why NetSuite does not allow you to edit the standard entry forms. It always creates a new preferred form even if I made a small Quick Add change.