Angela Bayliss · Senior Solution Architect · Silver Crown

I just recognized that the NetSuite recommended workaround of using IA's as a Bin Transfer is flawed and has some serious impact. I've only isolated one instance of this so far, but now I've got an APB out on other IA's similar to this one. Assumption: I've ensured that there are no other transactions leaning on my…

Hi Angela, Did you ever find a way to fix a situation where the bin count and inventory(location) count did not match? We can transfer stock out of one bin and into another, but if the total amounts are different, we get stuck - and we cannot remove the bad bin reference because Netsuite says there is stock in it. What a…

We have been using bins since October. We have also faced this problem, and our workaround has been to simply not use the bins on pre sold items. When using the bins, you will also find several other issues- once an item is assigned to a bin, it cannot be moved to another bin unless it goes through the…

I'm really miffed with myself that I didn't think of that! D'oh! Thank you! Matt O 'cmon Matt, you perfect these days? ;)

We have been using serial numbers for some time. When I go to troubleshoot, the most common issue I find when the serials on hand do not match available quantity, it usually means some of them are committed. We do not have the issue of typos in serials when fulfilling/receiving, because we use scanners and bar codes, and I…

Yes, Ray, It appears I need to attack this as well, and could use any documentation I can find. Where can we find it?

yes- we use advanced inventory, and use scanners to read serials (bar coded on each item)- not sure if this helps you...

It's possible, yes. One approach would be to start with a transaction search. Filter by the customer, and on the results tab, list the item, then pull the QOH, etc from the subitem list available. hth...

Howdy I have a saved search that shows the warehouse Sales Orders that have been billed in full and get be fulfilled for shipment. I want to highlight a transaction if not all items can be fulfilled but I'm stuck. I can highlight if the order is partially fulfilled, but we don't always part-ship. That's up to the warehouse…

Hi Guys, Looks like K. Izer and I posted at almost the same time. Just a note to clarify here--- In the years I have used netsuite, and the understanding I have of it's functionality, I have often found that when I become bound in solving something in a specific way (such as highlighting lines in a search) I usually end up…

I did it! A combination of all your help plus some acid... no wait... there was no acid... Will post results soon. Is that a dragon? I love you, Wiz. Entertaining as well as informative....

Ok then, Whiz, lets see if we can approach this from a different direction.... I'm leaning towards 'ship complete'. Take a look at the below information, and help me understand why these built in filters aren't working for you. If we can figure out what doesn't work, we can get around it. Nothing is impossible.... To…

Did you try adding 'transaction fields' of 'Amount (transaction total)' and 'Amount Paid?

The first thing I would check is under home-set preferences. Look in the 'restrict view' tab. is anything populated?

Thanks for the suggestion; I was not aware of that tab. Unfortunately it does not appear to be the problem. All of the dropdowns and checkboxes are blank/unset. I would file a case with Support, see what they can tell you.

ok then, let me ask this..... Is your search based on projects or customers?

Hi Doreen, Go to home-set preferences-general under optimizing Netsuite, place a check box next to 'Show Quick Add Row on Lists' save. that should do the trick. :)

I'm crushed... :( No energy to type now. Ma...t.......t It's the valium, sunshine.:rolleyes:

I would get your Valium ready and put your ODBC hat on if I were you. While that sounds like so much fun, I wouldn't jump into it quite yet. I'm on beta, and so far, serials are pulling like you would expect(yee haw). Ill let you know when I can really dive into testing them, but the whole day job thing is keeping me…

JMU- do you have advanced analytics? This is possible to do within CR, or even excel, if you do. I was assuming that you did not....:o

sorry, haven't a clue. I drop them into excel and use vlookup. but then again, I doubt I deal with the volume you do. sorry, maybe someone else can help.

Yep, we've got AA and ODBC access. Do you use CR much? If so, how do you like it? I don't, not much. Since my background is in accounting, I so much prefer Excel. The primary reason I don't like it is because I am very limited in my knowledge of it, and had not had it too high on my priority list to learn. (been a wee bit…

Hey JMU, how handy are you in excel? I can walk you through this relatively easily, if you like, but it is essentially done in excel..

Walter- are the items that should not be on the list sold or comitted? Try using the on hand = true, if the problem is that it returns sold serials.

you said criteria 2 isnt working- so what does it return? Can't help fix it if we dont know the problem.

ok, but can I first ask how you will know what serial will be shipped? I ask, because we also use serials, and do not know what serial will be used until the order is shipped. Since we cannot associate bin locations to serials, if a specific serial is sold, our warehouse guys would have to sort through lots and lots of…

The OnHand is a numeric as opposed to boolean. You can use it to list item with X Quantity On Hand. Is the ?Is Available is a boolean. Stumped. :) yep- your right. arrggghhh. what need are you trying to address? you want items available serials of items on hand. Does it have to be a search?

So- are you trying to eliminate the "inventory" sub tab in the item record? You want this information to not be visible at all? Or do you want to create a search that gives you the item and its cost all on the same screen?

May I ask the steps you are taking to 'clear' or 'reconcile' these? Specifically, what is the navigation path you are taking, and what steps do you follow? I'm a little confused on your process..... ~angela

Can you post some screen shots of the Reconcile Account's page you're looking at? ~angela