Olivier Gagnon NC Red Ribbon

Try going in the report options and tick in "Show Zeroes"

You can use List->Mass Update->Update Prices to manually do it every month. The only fully automated solution is scripting.

CASE WHEN {account}='BT Deferred Revenue Account' THEN '4010: Sales BT Websites' ELSE {account} END

Reports do not allow OR logic (yet). Saved Searches can allow OR logic by clicking the "Use Expression" checkbox on the search builder.

Depends on the report type. If you're talking about a financial report, you can use the Financial Report Layout Builder to create sections that allow OR filtering. In other cases you can perhaps use standard filtering and use "anyof" and select all the possible values.

No, that is not possible

I read the original post kind of fast on my reply, and re-reading it now it may be that mainline = true is not the answer, but I would still give it a shot. You can add Mainline from a customer search by going on your "Transaction..." field and selecting mainline = true from there.

Add a filter for Main line = true

To add complementary information to Angela's answer, do note that even if you make a report 'public' as described, people who do not have rights to see Cases will still not be able to see a 'public' Case report (which makes sense).

Yes starting with a Transaction type search is probably a good start.

Reports are not modifiable in this way. It can be done with a saved search, yes. You will need to recreate the "Profit & Loss" report from scratch as a search, and then include POs in there are well. However, I don't think that will be simple, as you'd need to ignore POs that have turned into Bills to avoid double counting…

Right what happens is the Euro gets converted to GBP which gets converted to Euro. The simplest fix is to ensure the consolidated exchange rate between B and A is the exact inverse of the rate between C and B. Of course that will also affect all other children of B and B itself. Do NOT modify the exchange rate of any…

Why can't you edit the subsidiary filter? That is what I've done in the past, not had any limitations there. What are you seeing when you try that?

Hmmm. What about your Consolidated Exchange Rates? Did you double check them?

Yeah that's not going to be possible with base reporting. It could be done with a Saved Search, but the formatting will be pretty ugly. I just don't see this happening easily. Maybe if you did it via ODBC, or maybe a Suitelet specifically built for that report, something like that.

It's not a reporting problem, it's a data problem. Customers are hard-coded to belong to a single subsidiary. You would need to recreate the customer under the new sub and then possibly migrate some of their financial history if desired, and then start using that new customer from now on. If you are patient, NetSuite will…

You can, at the Role level, remove the "Export List" permission. But, this is all-or-nothing. You cannot place the export restriction on just these two report. Might be worth saying, also, that very little would stop someone from grabbing all the info and copy/pasting it into Excel. The export limitation just makes things…

Hmm, I'm not an accountant so don't know what you mean by "a balance sheet as an accountant defines a balance sheet". Can you elaborate on that? Also, Answer 23921 seems to refer to Yammer so I'm guessing there's a typo in there. Otherwise, what I can say is that a balance sheet in NS is a running total of everything from…

Running the TB directly won't really work because it does not allow pivoting on Subsidiaries. I recommend you run the Income Statement and Balance Sheet seperately. You just need to run them as the consolidated level, and set the COLUMN field (bottom right of report) to Subsidiary. You can then see your sub in USD.

When setting up a OneWorld account, the reporting currency is a critical question to ask. What should have happened here is that your implementor should have placed a USD parent subsidiary on top of your AED one. Without this, it will not be possible for you to report in USD. You can still go through the process of trying…

This screen is not customizeable. The "Reconciled" checkbox is not available in any other way, so there is no real other workaround. The only possibility would be to make a screen (a suitelet, most likely) representing the UI you wish to see for your reconciliation screen. You won't be able to expose the Reconciled…

What isn't supported?

I do not know what the statuatory requirements are in India, but via the Financial Layout customization tools, you can make reports with groupings however you see fit, so most likely India's requirements can be met.

While it's funny someone with the title of NS Employee is asking this, the "modern" answer is that partial ownership can now be managed via Multi-Book Accounting. So, no, it is not exactly maintained in the same way. The setup and maintenance of the Multi-Book Accounting would require additional effort. However, it also…

Yes, set up an Elimination company and write off 60% the value of your company on it. Run a Trial Balance for the partially-owned sub, export to Excel, calculate the 60% write-off, and import that as a Journal to your elimination sub. Note that this will only show the total, summed consolidated value. If you use the…

Yes, I've worked on several OW accounts with multi-currency. CTA can indeed be a tricky beast, but I'm afraid I don't visualize the problem you're having. The CTA is normally handled automatically by Netsuite and should post to just one (virtual) account. It's always tricky to read balance sheets with CTA, but that's…

A secondary book may be a good approach - in some cases probably better than elimination. There are other potential methods (including "non-solutions" like doing it in Excel), but multi-book or elimination are typically going to be your best bets.

Ahh, I see. Ok, couple of options. You'll notice at the bottom right of the P&L (and most other financial reports) that there is a "Total" footer filter. You can set that to "Period" - this will show you the evolution of your P&L throughout periods, so that's one very quick and simple way to run basic comparative. To…

Yes, of course. What kind of issues are you having?

Yes, like I said, you can customize your reports/searches to view only specific accounts. I had guessed you made location-specific accounts for AR and stuff. Part of the problem is that you won't be able to do this with all accounts. Unless you want to manage location-specific SKUs, your COGS cannot be managed in this way,…