When doing Mobile Configuration for WMS, setting the Visibility Condition to 'False' for a Page Element (specifically an Action Button) does not seem to be 'hiding' the button from the Mobile Screen. Is there something else that needs to be done to make this happen?

regarding Matrix Items, while the Matrix Option in very useful for creating multiple products off of a parent ne with options, one problem I'm running into is that under the Accounting / Matrix Items tab, lists every option list we have, Is there any way to limit this so it only displays option lists that are specifically related to the product, or option lists that are used by the parent product?

I'm trying to develop a search for back orders and trying to display the warehouse which has enough quantity to cover this order. When I introduce a location level DECODE to a saved search, it outputs a bunch of rows but from my commands, I would think they would all have the same result since I'm hard coding each location into the DECODE, so there's no room for it to think I'm talking about another location. But it still shows wrong data. So then I can't use the MAXIMUM grouping on the saved search because it's got incorrect data in each of the multi rows. Here's a short video explaining what I was trying to do and how it messed up Here's the formula I tried to add in the video:

CASE WHEN {item.quantityavailable} >= {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) THEN CASE WHEN nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) THEN 'Atlanta' ELSE CASE WHEN nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) THEN 'Houston AFM' ELSE CASE WHEN nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) THEN 'Youngstown' ELSE CASE WHEN nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) THEN 'Jackson' ELSE CASE WHEN nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Atlanta', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Youngstown', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Houston AFM', {item.locationquantityavailable}),0) AND nvl(DECODE({item.inventorylocation}, 'Charlotte SG', {item.locationquantityavailable}),0) > nvl(DECODE({item.inventorylocation}, 'Jackson', {item.locationquantityavailable}),0) THEN 'Charlotte SG' ELSE 'Not enough stock' END END END END END ELSE 'Not enough stock' END

Any ideas? I know it can probably be done using SQL but I just don't know how to do that yet, I was hoping there may be something I'm overlooking.

has anyone come across this error before? its throwing this error on a quote when I select an inventory item. The only difference from when this didn't happen to when it has started happening is by turning the International Currency module. Thanks in advance;

Good morning all. Is there an easy way to handle the following: Item A exists in both Subsidiary 1 and Subsidiary 2. I need to have a different base price for if the item is added to a transaction under Subsidiary 1 than Subsidiary 2. So if Item A is added to a SO for Subsidiary 1, the base Price is $10 and if Item A is added to a SO for Subsidiary 2, the base price is $20.

Is there anyone out there that has implemented Supply Allocation that would share some info on their setup and how they have implemented it? I am getting help from a consultant but I dont feel they really understand the function (I gather it’s new and I believe they are learning it as they help us) and I also dont think they know how a business works from a cash flow standpoint. Consequently I dont think i’m getting good information on how to properly set up and use this function--everything they keep telling me is that what we want cannot be done at all, but no guidance on a best-practice. I simply want 2 things: 1. I want sales orders and reservation orders with future supply-required-by dates to pull from future supply orders FIRST, and only after the future supply is exhausted to pull from inventory that’s on hand now. I am being told this is not possible because supply allocation always takes from on-hand inventory first. (I thought the whole point of supply allocation was to avoid that?) 2. And, If I have on-hand inventory that is allocated to a future sales order or an order-reservation, I want to be able to place a new supply purchase order and have the reallocation calculation automatically re-allocate the demand to the future supply, leaving the on-hand inventory free for new sales in the interim. I am being told that once on-hand inventory is allocated to a demand order, regardless of the supply-required-by date it is impossible for an automatic recalculation to re-assign that demand to a future supply order, that is must be done manually…which seems quite onerous. This seems like bread and butter simple to me, yet I am being told these things are simply not possible. Can anyone with first-hand experience comment on how they set up supply allocation and maintain it to accomplish this? If our consultant is correct (??) I have a hard time understanding how the supply allocation function is going to accomplish what I need without adding a huge amount of manual work that in my past experience was all automatic. Thanks very much in advance.

anybody use RF Smart for handheld scanning/fulfillments and receipts?

Tons of people do

anybody having issues with group items and fulfillments using the handhelds?

I would expect members of item groups to pose problems.

as well as kits

That said - best people to ask are RF Smart.

Anyone know if it's possible to use quality bundle without inventory status?

Anyone know how to write the logic for a workflow that I'm working on? I'm trying to keep new inventory items from being saved without any of the three price level fields being blank or $0. I know the fields needed are the following:

{pricing.pricelevel.id}=18
{pricing.pricelevel.id}=20
{pricing.pricelevel.id}=21

I thought about CASE WHEN but not sure how to finish out the logic. Any help will be greatly appreciated.

Is it possible to bring in a custom field from a sales order into the WMS mobile picking screen?

Hello - anyone knows why the system would change allocation on a sales order without any user action?

Happy Holidays Y'all. Quick transactional COGS question. We had a bad purchase price (rate) on a PO that was received in full. In addition we have shipped some goods out on IF. We would like to correct the inventory amount so our average cost is correct. I can see in the UI and fix the rate in the IR, but what is the standard process to update the IF in NetSuite? I don't see that field available via the UI to update.

NetSuite WMS question: Are there commonly recommended hardware/handhelds? Understand the minimum requirements but wanted to see what recommendations people have seen or equipment they've utilized.

Ok am I losing it or is there not a way to see child items from a parent item record that's not an Assembly or Matrix? I know this Item (type=Inventory Item) has child items, but I don't see a sublist anywhere on the item record listing its children. Yes I'm on the standard form. I know it would be easy enough to run a search with Subitem Of=[this item] to get them, but it seems super weird they're not linked somewhere on the item record.

I would like to create a matrix on an existing item. Is that possible? I don't want to recreate the item because then I'm going to lose the purchase history on the items. Is there a work around this?

Hello All...any WMS users out there? I'm trying to set up WO Picking in WMS, after I do my pick task, I try to go to a staging bin and there are none available. I keep creating bins with other options (staging in, staging out, etc.), but none of my bins show up as available for Staging. What is required on the bin for it to appear as a WO picking staging bin? Thanks in advance...

OOOK...Bin needs to be of type WIP. Thanks trial and error 😞

At the current moment you can not choose lot numbers on the sales order for kit items I heard a rumor this is changing in 2022 any way to find out

What is the best practice on the quantity to be sent to online customers in the Inventory Advice saved search (a custom one)? Right now, we send and show only 25% of the quantity available to them. But the issue is if we have 8 online customers where 5 of them ordered the entire 25%. That'd be 125% which causes us problems.

Anyone got experience with order allocation strategies in relation to lot numbers? We only want to supply an order with one and the same lot number but the order allocation is ignoring any lot numbers. I see there is a FEFO order allocation script but that's for first expiring and we're needed the one with the closest quantity difference

Hey Gurus - hoping someone can give some direction here; so the client went live with items with no values, they have been doing inventory adjustments for 2 months without any actual item values, hence they have been down dollars wise. The items had no base/sale price hence nothing made its way to the IA's. What I found was that Item values on existing IA's cannot be modified, it’s a system limitation so trying to see if inventory worksheet would help in any way however I doubt it will but I could be wrong. The other approach in mind is to work through JE's to balance GL for those 2 months, or the 3rd option I am thinking is to delete those IA, and reimport them in once after all items have had values entered on them. Any pointers would be helpful, thanks!

Good afternoon all! I am trying to do a mass bin transfer. The history is that one of our offices is moving and I have created new bins under the Illinois office. The office moving is in Illinois and was generically named as it is our only office there. I am struggling with a way to import the bin transfer via csv and Google searches have turned up somewhat fruitless. I can't imagine that I'm the only person to ever run into this issue. Any help will be greatly appreciated!

I'm now trying to do the inventory transfer as a CSV import but can't get past the internalID/ExternalID portion as NetSuite can't find the record no matter what I choose. What should the internalID/ExternalID be? I can't seem to find any documentation that defines what these should be on a CSV import?

It shows as Inventory Transfer: Internal ID on the field mapping screen.

Nevermind. I figured it out.