-
create a formula but shows ERROR: Invalid Expression
I need some help. I want to create the formula column in "item saved search". But still ERROR: Invalid Expression Information 1. Use the system field. such as (quantityonorder + quantityonhand) - minimumquantity 2. I use the formula numeric and formula text did not work. the system still show error 4. There are no criteria…
-
Split Bin Numbers into seperate rows in a Report?
Hello, I'm trying to split items by their varied Bin Numbers on an Inventory Valuation Summary such that the single line of multiple grouped Bin Numbers will be separated into rows, but will keep their grouping. However, I can't seem to find a way to easily do this. I've attached some pictures that I hope will help clarify…
-
Creating a search that only pulls in the last update 'date' for purchase price on an inventory item
I am trying to create a search to use in a workflow. However, I am not having much success so hope you all can help me again. I need the search to provide me with the inventory item and the last time the purchase price was updated only. I did pull from system notes but do not need all times it update, just the last.
-
Saved search using Associated Images?
Hello, Is there a field in NetSuite that can be added to a saved search that shows if an item has an "associated image" or not? I tried something called "Image URL", but it didn't work. Thank you, Lily
-
Item with Serial Number
Hi! Is there someone that can help us with our saved search? Basically, what we want is to see the serial numbers for the On Hand items but unfortunately, the result is more than the on hand. as you can see, the on hand is 247 white the lines for the result is 333. thanks
-
saved search for quantity on hand for specific date
Dear Guru, can you please help me out in creating a saved search to pull out the quantity on hand per date . Note :: i am aware of the standard reports we have for inventory on hand but the issue here is as we know that NetSuite reports are not scriptable, Best Regards Aman Mirza
-
How to Setup Automated email with Inventory Saved Search results?
We have customers requesting that we send them our inventory on a regular basis - some daily, others weekly. These are low-volume customers, so there is no way we will set them up on EDI. To provide them with a tool they can use, I have written two saved searches, one that sends weekly and one that sends daily. Is there a…
-
How do I remove duplicate lines for Transaction Serial/Lot number?
Hi I am creating a search from item fulfilments to determine the quantity fulfilled for lot numbered items. There are duplicate lines for any transactions with more than 1 line on the IF. Criteria: Type: is Item Fulfillment Main Line: is False Results: Item:Name Date Transaction Serial/Lot Number Quantity Notes (Custom…
-
How to create saved search for system notes of field with most recent change only?
Hi all I have a custom field. I want to see the most recent change to this field on a search. I have the date refined to today and am looking at the System note date Field name Old Value New Value I cannot use a summary search. The old and new value fields are numbers and none of the numerical functions work, using max…
-
Work Order Item Summary with the Earliest PO Vendor Confirmed Date
Good morning! I have a Saved transaction search that shows Parts not issued to work orders based by sales order. What I would like to see is the earliest purchase order per part with the vendor confirmation date and the quantity on order. Is this possible? this is how my search is currently set up: Transaction search Main…