User_EIPWY Red Ribbon

NetSuite's landed cost handling is limited. It doesn't support multiple methods or multiple currencies. In the past I've calculated everything in Excel (for me the issue was converting to a single currency), and then set landed cost manually.

Thanks for the update, that's good to know.

Yeah, that's lame. Seems to me all, or at least nearly all, fields on standard records should be available for merge.

Two possibilities I know of, the first is more likely: 1) There's granting the permission, but there's also a user being able to navigate to it through the UI. The second is determined by the center assigned to the roll. In some cases, you'll find that despite having granted a permission to a role you don't still see a…

Can't do it in a report. Formulas in reports don't go beyond basic arithmetic. Evan

That's kind of a philosophical question. The simple answer is no, there's no reason beyond the mere fact that it's impossible. Obviously, NetSuite could redo the reporting engine, and make stuff like this possible. And as it happens, that is what I've heard is happening. It was discussed a little at SuiteWorld this year,…

Because of the issues you're encountering, I've usually preferred searches to reports. What do you want to see when you drill into On Order? You're best bet is probably to build an item search that joins in PO data, summarize the results (e.g. group by item, sum of on hand, sum of on order), and include the transaction…

My guess is that the overdue debtors 30/60/90 saved search that Tim refers to is from this thread, and I wouldn't be surprised if many of the other examples are user submitted (the 100 ways to use formula fields thread has a wealth of examples). That said, I'm a fan of NetSuite's documentation. It's not perfect, but it…

We looked at doing exactly what you're describing. Our idea was to script a report using saved searches as inputs. Would take about 40-120 hours of mostly scripting work, depending on the person doing it (low-end is for someone who knows suitescript, financial reporting, and your instance). I wouldn't recommend the ODBC…

You can create a custom field for Created By, which would then be available in reports. A simple workflow could auto-stamp it.

If you're using the standard reports, or saved customs, you can set them to auto-email, assuming you close on the same day every month. There's no way to send all the reports at once, on demand (single button that sends 'em all), other than script. Evan

It is odd, but there's no mystery secret about getting it to work unfortunately. It doesn't work. You can either manually add specific months, or export the whole thing to Excel and edit. Enhancement 203799 And you'll want to also vote for 130536 if you're using OneWorld.

The enhancement is still "Open-Accepting Votes", which is the first stage I believe, i.e. not yet "Under Review" or "Under Investigation", whatever comes next. The wording was mine, NetSuite didn't make the first part explicit. It was more something like: [It doesn't work. Therefore] it's not supported, at this time.

I don't think it's supported. NetSuite can do P&Ls by period, but not balance sheets, or trial balances. Some of the system calculated accounts (e.g. retained earnings) cause problems. You can force the system to run a balance sheet by period, but some accounts will be way off; I don't think there's a way to force it to…

Yep, my case was joined to the defect as well Defect 248804 Fix release is scheduled for tomorrow night. Evan

Do you mean the page that loads when I user clicks on "View GL Impact"? I don't believe you can customize this.

Can you say some more about what you're looking for? Some of that is native with OneWorld, e.g you can definitely run consolidated financials, with multiple periods side by side using native reports in OneWorld. Evan

Hmmm, just checked this, and noticing the same behavior. When I export the GL report to Excel, it's correct. But when you view it in the system, the final balance is the same as the balance/fwd number, as you describe. The problem is the with the final balance number. Have you reported this to NetSuite? Please post back…

While the UI allows one to generate a consolidated balance sheet by accounting period, it's inaccurate, and so thus 'not supported'. Enhancement # - 130536 SIC Reporting > Please allow to run Consolidated Balance Sheet by Accounting Period, Week, and etc. Summary: Ability to generate the Consolidated Balance Sheet by…

Turns out this isn't supported.

They will not be as you configured them in your dev environment, in a manner that is unpredictable. In other words, fields and sections move around, "Show" checkbox gets unchecked, etc. In our deployment instructions, we always include a step to verify/make form changes.

I will throw out that one thing that frequently doesn't bundle well is form layouts.

I'm Canadian, but living and working in Austin Texas. Originally from Vancouver.

Hi Kaze, You could enable account numbers and only use them for statutory numbering, though be warned that because of NetSuite's convention of combining record Names and Numbers in the Name field in reports, this may cause some users confusion in creating reports/searches. Otherwise I don't think there's an easy way to…

In the criteria, set a filter for "This Month to Date" on the Date field. Evan

Advanced projects is a separate module that has to be purchased--is it part of your subscription? Regarding creating a project from the customer record--do you see a projects tab on your customers? If that's there, there should be a "New" button at its top. If it's not there, customize the customer entity form to add the…

Nope, not possible.

We're not, but, for what's it's worth, Fonality runs on NetSuite. I'd think that would mean they integrate well with NetSuite.

No, but you could export the ones you want to copy via a custom search, remove the transactions numbers, and then set the import to "Add". Other than getting a script to cycle through a list of invoices to copy I think that'd be your fastest. Evan

Thanks Mo, much appreciated.