have you tried {item.memberitem} ?

This message was deleted.

are matrix items not able to have a unitstype? getting unexpected error when I try to add “each” to one

Hi guys can we source value from inventory location record into a custom field ? on sales order line?

Maybe? Are you talking a custom field on the location? Or are you trying to capture inventory location on hand or available values at time of entry? Definitely can be done from a script either way but generally I discourage the second because inventory is what inventory is, who cares what it was at the time you got the order when you can't fill it?

How do you disable the ability to drive inventory negative?

Anyone see this error before? "The following Bin numbers are not available: ". It blocks any modification or saving of the fulfillment record. Can't seem to find anything within NetSuite help.

Looking for help on triggering an email alert for a search. I've done these for other searches but am struggling with this one. What I am looking for the mail to do is to be triggered when an item is received that meets the criteria. Here is the criteria and result; Type is Purchase Order Status is any of Purchase Order:Partially Received, Purchase Order:Pending Billing/Partially Received, Purchase Order:Pending Bill, Purchase Order:Fully Billed Closed is false Main Line is false Quantity Shipped/Received/Picked Up is greater than or equal to 1 Item : Ecommerce Set Aside (Custom) is true Item : Size (Custom) includes none of Large, Small, X-Large, X-Small, XX-Small, 2X-Large, 3X-Large, 7 1/4 Status Fulfilling/Receiving Transaction : Date Date Document Number Doc # Location Loc Quantity Fulfilled/Received Qty Rec Item UPC Code (Custom Column) SKU

Looking for mobile device license information for WMS 2019.2? I know that solutions like OzLink are using webservices, so they have their own server and we don't need a whole bunch of Netsuite licenses... Do you know how works the licenses for WMS inside Netsuite? Thx!

is there a way to fulfill additional items on an item fulfillment after it has originally been saved and picked?

is there a way to partially receive a transfer order that was fully fulfilled? Every time i try to do that i get an alert saying that I am not allowed to receive less than i have fulfilled.

Maybe a dumb question, but we usually use kits (which pulls from inventory when sales order / fulfillment is tied to the kit), and trying to understand when to do an assembly build versus an assembly inventory adjustment? Do assembly builds increase the assembly and decrease their components, whereas an assembly inventory adjustment strictly increase assembly? Thanks

If you are talking standard inventory adjustment transaction, yes you are right. I don't know that I've heard of a specific transaction for assembly inventory adjustments so that might be a custom transaction

is there anyway to special order quantity on backorder and commit the inventory available

so like a partial special order

when we do a special order for the back order quantity it sets all the quantity to back order

how do you guys do your stock count? are your creating the item location configuration and then running the stock count feature?

hi - is in-transit inventory reflected in on-hand?

is there a way to set up an approval process for inventory adjustments?

On an item saved search is there a way to specify a parent inventory location while excluding the location children? For example we are building an 'out-of-stock' inventory saved search for a parent location though for some reason it continues to recognize available inventory in the child locations.. Thanks!

Is there a way to have the average cost on an item only be affected by a certain subsidiary? We're finding that our sales to a child company of ours, is affecting the Avg cost of an item, however, we still need the average cost, but need it averaged by only certain subsidiaries.

Anybody able to create offsets or running totals in pivot tables in analytics workbook? I want to take last week's ending balance and add it to this week's change in inventory.

I could probably accomplish that with a combination of nasty case statements and sums/max/min in a standard saved search - I don't know if it'd be possible in the workbooks though.

New to search formulas and trying to add on hand inventory by location to an existing item search using a formula. Able to use {quantityonhand} to pull all on hand inventory but unable to show just a single location. Anyone have any thoughts to what is wrong with this statement? CASE WHEN {location} = 'FBA' THEN {quantityonhand} else 0 END

@Reed Dettrich there is a separate field for location quantity on hand -

locationquantityonhand

Is it possible to use a Matrix Item parent on a Customer Item Pricing Sublist to apply the correct pricing for any of it’s children when selected on a Transaction?

Currently we’re left having to add every variation of an item to the Customer Item Pricing sublist along with the corresponding Price Level. We’ve managed to speed this up by some clever copying and pasting and CSV Import, but I’d love to find out I’m missing something that could make this easier to implement.

is there a standard slow-moving stock report in NS?

Hello. On an Open Sales Order report: can I exclude the component items associated with the assembly/build item?

Has anyone ever created a search which could tell you how many days an item was out of stock at a location during a historical time period?