Olivier Gagnon NC Red Ribbon

The exchange rate is a field available on invoices. So yes, it's just a standard formula - multiply the two fields together.

Julieeeeeeeeeeee!!!! I don't know about the dense_rank, that might work too. But my first instinct would be to do the same you're trying right now. Maybe you're just getting the error because NS always wants you to protect against divisions by zero... so just alter the last bit to be…

wrap your last case statement in: nullif(CASE TO_CHAR({trandate},'YYYY') WHEN '2018' THEN decode(to_char({trandate},'YYYY'),2018,{quantity}, 0) ELSE 0 END,0)

This is not documented anywhere. But taking a stab at those I can guess at: style=NORMAL --> This is the "Normal" or "Grid" layout view report= --> dunno grid= --> dunno dle=T --> Direct List Edit, aka ability to change some fields right from the search sortcol=Transaction_TRANDATE_raw <-- this one might be important but…

This is not possible. Export your results to Excel, then do some excel gymnastics to achieve that there.

Try this: CASE WHEN {quantityavailable} = 0 and {outofstockbehavior} = ‘Remove item when out-of-stock’ THEN ‘discontinued' ELSE (CASE WHEN {quantityavailable} = 0 and {outofstockbehavior} = ‘Allow back orders but display out-of-stock message’ THEN 'pre-order' ELSE (CASE WHEN {quantityavailable} > 5 THEN 'In Stock' ELSE…

You can create multiple saved searches, and then jurry-rig them together. You can use a formula to create a hyperlink with proper GET parameters that calls the next search, and so on.

It's a bit more complicated than a case when. So, your search will need to return all lines (mainline false). For each line, add a formula something like CASE WHEN {item.id} IN (123,456,789,...) THEN {description} ELSE '' END Then group all other field (assuming they are all body fields, thus the same for all lines), and…

Rreeeeaally Can you expand a little on what this ns_concat() does exactly?

I don't think that'll be possible purely in SQL. You would need to use scripting to paste/append messages into a hidden field on the Case as they come in. Then in the search you can just output this single, massive field. It is possible though the character count will pop anything NS can handle. Could happen in theory.

Might not be null. Might be equal to ''

No, this is not supported by NetSuite.

No, that is not possible. I believe you can add "Cleared" though, which is almost the same thing. A reconciled transaction is always cleared, but you can clear transactions without reconciling them, so it'll depend on your normal use of the Cleared checkbox for this to work.

Just open the little popup to select value and select "- None -"

That's not especially possible. Probably the easiest workaround is to just type in the number in your search. Alternatively, being imaginative, you could put a store value = false transaction body field with a default of 500. That should then be available in searches, more or less acting like a global.

Oh, sorry As a Transaction search (with filters to include only opportunities) formula: case when {datecreated}-{customer.custentity11}>0 then 1 else 0 end criteria: equal to 1

formula: case when {custentity11}-{datecreated}>0 then 1 else 0 end criteria: equal to 1 Note: not sure if it's datecreated or createdate, you'll need to check using the formula builder

You can't export it from the sublist view on the Project, but you can go on the actual saved search and export it from there

1. Make sure your formula field is of type Text 2. append "END" at the end of you case: CASE WHEN {systemnotes.field.id} = 'entitystatus' AND {systemnotes.newvalue} = 'Suspect' THEN {systemnotes.date} END Try that. Still might not work, but let's take it from there

Item Fulfillments should have a hit to COGS as well as Inventory Asset.

Try filtering on the Account or at least the Account Type. Keep only hits to your Inventory Asset account. That usually works very well.

You can try to achieve something by padding your column titles with characters sure as underscore (I think NS will chop of blank spaces), but otherwise, there is no other formatting options to achieve this, no.

I may be misunderstanding your problem, but you can get this using the Balance Sheet report or going into the specific bank account's Ledger.

Hello Olivier, Thanks for responding. I have tried to customize balance sheet general ledger to show only two bank accounts. I need to show Open balance on Monday, Debits, Credits, Current balance with only one value. I shouldn't show details of all transactions:( By adding a few filters I managed to get Debit, Credit,…

So, we ran it up NS Support to see what was up. Here is the reply (bold mine): Thank you for your email. Regarding your concern, I have checked the latest issue details of Defect 257755 and I have verified that the fix rolled out last 8/8/2013 is that all accounts that were attached to the issue will be rolled back to the…

Update: the "patch" option is designed as a temporary hold until the account can edit all of its searches. It'll stop working beginning of next year.

The information we have received is that NS will not (or cannot) revert to the previous behaviour on a wide scale. They have indicated to us they can "patch" accounts that specifically request to revert to the old behaviour. No word how long this "patch" is designed to remain in place for. My guess would be not…

Where are you executing your URL grab? Suitelet, user event, client script?

Hi Cherrie, decode({account.number},'10000','123456789','20000','2222222') You can read that as IF {account.number} IS 10000 THEN WRITE 123456789 ELSE IF IT IS 20000 THEN WRITE 2222222

What we've done in the past is add URL to search results pointing ot OTHER search results. It's a kind of drill-down.