{amount}/nullif({quantity}-{quantityshiprecv},0)

Are you talking about a physically created Retained Earnings account, or the normal dynamically generated one? Are you sure there are values in the past Financial Year? Did you customize your Report? Did you customize the Financial Layout? Even if using the standard BS report, you may be ucing a custom Financial Layout

That looks like a custom financial layout. You need to check what's going on in regards to the definition to see what the report is doing.

All technologies allow a broad "transaction" type search without needing to specify the exact transaction type.

All technologies - scripting (including RESTlets), Web Services and ODBC have access to Transaction type searches.

Hmm, yes. One of the locations probably returns the location in the format "Parent: child" while the other one returns just "child " I believe changing the formula to use internal Ids ought to resolve that, which you can do like this: Formula (Nmeric) decode({item.inventorylocation.id},{location.id},1,0) equal to 1

I would infer that NetSuite told you the workflow was doing that because the workflow must be causing a re-save of the opportunity. Ideally, the workflow shouldn't be doing that - it's bad practice.

Yeah, requires a bit of formula-jit-su add a Criteria as follows: Formula (text) decode({item.inventorylocation},{location},1,0) equal to 1 What you're telling NS here is to evaluate all the returned item's location against the transaction's location. If they match, return 1, else 0. Then, your criteria is to only show…

Made an error in there. For slightly more optimized performance, the formual should be of type (number), not (text). It'll execute faster as a number.

Hmm. If you're talking about Fulfillments for Inventory type items, maybe add a filter to only show account type = COGS. Drop Ships don't have that. This won't work if we're talking about non-inventory type items though.

Internal IDs will be exposed to Reports starting in release 2014.1. You can check the release notes for details.

NetSuite offers the ability to pick the Consolidated Exchange Rate Method on a per-account basis. So if your company does things a little differently, this is not a problem as you can pick the method to use yourself. Let me know if you have any other questions

Basic question perhaps, but, is it actually Billed?

Pretty cool! Thanks Brian!

No.. this is wrong. This does not allow you to pick the subsidiary *context*, it just filters the subsidiaries. This is a very different behaviour. Something is wrong here. I recommend you call NS Support if you do not have a Partner to help you along with your implementation.

Oh, I see. Ok.

This shouldn't need any customization, actually. The Subsidiary Context field should show on all Financial reports by default in a OW account.

What about doing an End User search? You can join on one side the Items and on the other the Contacts, no?

Are you doing a Saved Search or a Report?

Hmm... There is the "Contact..." join on Customers, no?

It's not wholly possible, no. Commitment is affected by what becomes available through stock modifications. That means any and every transaction that affects your stock levels can affect commitment. That's a long list of possible transactions. You would need to place an after submit script to execute on every single one of…

Yeah, that would be too easy ;)

sum({field1})-sum({field2}) i.e. sum() is a valid function you can use within formulas

How, in Netsuite, do you deal with terminated employees? Do you Inactivate them? Do you enter a Date of Termination?

Do a transactions search, filtered on invoices or Cash Sales columns: Name (group) Date (min) Labeled as "First Order" Formula Currency (sum): case when ({trandate}-min({trandate}))<=365 then {amount} else 0 end labelled as "Sales in 12 months after first sale" Try this? Haven't tested it

Sometimes NS presents multiple lines based on the accounts being hit. My guess is your historical cash sale import included Inventory Items on them, so that would have ran a Inventory Asset and COGS hit as well as Sales. To confirm, add the Account field to your search. Once confirmed the duplication is due to the account,…

Yep, possible. Create yourself a saved search with some footer filters. Observe the URL. Now, set some of the footer filters. Observe the URL now. Using footer filters affects the URL as the param values are passed as GETs. This means with a little strong concatenation, you can build direct links to saved searched with the…

Hmm, that's odd. Maybe you can try casting the dates, just to make sure. to_char({today},'MM/DD/YYYY')-to_char({trandate},'MM/DD/YYYY')) If that doesn't work try using the function to calculate months between 2 dates, I forget the exact name.

Trunc operates on a date. Substracting 2 dates returns a number. Hence, Trunc is blowing up. Get rid of it and I think the formula should work. Make sure you are using a formula (numeric) type field, too.

Inventory Activity Detail report