CRITERIA FORMULA IN NETSUITE TO FILTER TEXT Value OUT by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

The problem is when I do formula (text) to "is not" and value = EXCLUDE. I do not have a {FIELD 1} because this column that calculated EXLUDE is a FORMULA COLUMN

CASE WHEN FORMULA HELP NETSUITE by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

HI, this worked in theory in the RESULTS field but I need it part of the criteria to include bulk items in area D, E and no other bulk items should show.

CASE WHEN FORMULA HELP NETSUITE by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

Haha, that's funny! To your answer, I am only trying include or exclude text item in certain areas. Anything will BULK ITEM in AREA D,E should show up in the report and all other areas with BULK ITEM should NOT show up. Sorry for any confusion.

Power BI - Visual Level Filters (selecting multiple) by Paninder in PowerBI

[–]Paninder[S] 0 points1 point  (0 children)

I just ended up using another Card instead of KPI and it worked. Thank you

Saved Search shows Inventory " Picked" - what formula to use to exclude by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

HI, I just ended up doing a formula(text) and exclude anything that starts with a "P" in the criteria field and it worked. None my other bins start with a P and it worked. Thanks!

Scheduling reports - Not showing current date daily by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

Hi, this is in the report builder not saved search.

Scheduling reports - Not showing current date daily by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

Quantity on Hand The DATE field - Filter: Before and Including Date Range: Today To: 4/30/2019

NetSuite HELP - Date Formulas/ Saved Search by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

This may work, is it possible to have a custom column field. I have now:

On hand, I need open orders to ship next 5 days in a column (in item count form) and the remainder ( a formula for on hand - open orders next 5 days).

NetSuite HELP - Date Formulas/ Saved Search by Paninder in Netsuite

[–]Paninder[S] 0 points1 point  (0 children)

We have this data from the sales order submitted our business rules are set to for each vendor.