As I mentioned, our warehouse guys know exactly where items are located. When programmed correctly, it works fine.

Give me a little time- been an intense week, and if I am not concentrating, I may skip something in the report that I percieve as obvious. I don't want to do that, because it can cause a lot of strife and dissention, culminating from confusion. I will get you the parameters, but like I said, it is a little more complex.

I don't understand this :- "If open purchase orders are either received or billed, then closed manually, this will also throw you out of balance." What do you mean manually, as against what? Thanks for your help. I mean, someone goes in and clicks on the "close PO" button, as opposed to completing the cycle of po-item…

Hi Snoggers, I use bins, and when I print a picking ticket, it displays the bin location of the on hand inventory as well as the qty on hand in that bin. On the fulfillment screen, the bin numbers are blank, but there is a small icon list to the right side, allowing users to designate which bins the items were pulled from.…

I think you can use the Unit of Measure. Specify your base unit and the conversion rate. For example, 1 pc is your base unit and in 1 carton there are 24 pcs. So per 1 carton, 24 is your conversion rate. Then create the item code and specify the Stock Units (how do you want to stock your items), the Purchase Units (which…

Andrew, you are wonderful. The adjustment worksheet doesn't sound so bad, after all. go figure ;) Thanks.

Hi Paul, Sorry I had to cut you off on IM, I had to run to an appt. I understand your confusion, so let me rephrase my answer to you. First of all- the po cycle contains three elements, with advanced receiving. Those elements are: the PO(non posting), the item receipt(posting ), and the bill(posting). This being said, you…

we do- all serialized inventory- use a scan gun to ensure the serials are entered correctly, bar codes created listing serials on each item.

Hi Nate, Not trying to butt in, but if you mfg your own stuff, try this: Create a vendor for the items you purchase- name it whatever you want. personally, I use "MFG" list this as your preferred vendor for the item, with the price you need listed as the purchase price in the preferred vendor field (main tab, inventory…

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.