Angela Bayliss · Senior Solution Architect · Silver Crown

Hey Andrew, oh guru of inventory adjustment worsheet, educate us. Why does this not work? (I cannot wait to hear this, it is no secret I dislike the inventory adjustment worksheet tremendously)

I looked, but I don't quite understand what would give 0 qty a negative value We did take a loss on this item we bought 4704 @ .60 / piece we sold 4704 @ .23 / piece i thought it would 0 out the inventory. it happens on the day of the sales order, but the value now is only -.02 cents. I'm thoroughly confused taking a loss…

ok, report #1- showing imbalances in PO's. Begin with the default "open PO report"-customize In Edit Columns: Remove the total amount column. Add in columns for: quantity received quantity billed date received ship to(optional, we use this for recon purposes) Also, add a formula column, using the formula difference x-y,…

you can cause a varience if there is a disruption in cost within the purchase cycle- for example, if your purchase order says 1-widget, 20 dollars. the widget is received (and automatically assigned a value of 20 dollars) the bill comes in and for whatever reason- is only 15 dollars. the bill is entered at 15 dollars. Your…

Existing items cannot be changed from one item type to another. You will need to create a new non-inventory for resale item, and then inactivate the inventory item. This is going to apply- however you decide to create the new type.

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?