Thanks guys. I also am of the opinion it is because the reorder point in some of these items is empty. I am going to set some to 0 or 1 and make sure.

Thanks for your help John. Due to your post we are all fixed up and I did some additional training on bin transfers as it turns out the bin transfers after our physical move were done wrong and bins were deleted from item records without being emptied first.

There was 2" on my porch Sunday morning.

Yes, I thought so as well, however experience has shown that if reorder point is blank it does not register the item on the Order Items Page. If Reorder Point is any non-null integer the item shows up to order.

confirmed. If the reorder point is blank the item does not show to be ordered at all. I gots me some updating to do. Thanks again.

I remember this thread now. Thanks for pointing it out. I think the root of the problem goes back to when we physically moved the operation and did some bin switcheroos after that. I have to get out and get some sh*&kicking boots before I start 2 stepping. Thanks again John

The item does not yet exist in Netsuite. This will be a new line for us

Tom, I would love to work with you on this. Send me a PM and we can discuss it and once we have a solution we can post it here for all to see. I have this issue on my list to take to Suiteworld and "Ask the Expert" as well.

I think so. But just to make sure its understood. The core is not a physical product that is shipped to the customer. What happens is the new item, which is a circuit board, is shipped to the customer. The customer is charged a refundable core charge. When the new board arrives the customer places the old board (the core)…

The vendor. They include a return shipping label in the box with the new part so the customer can just slap that on the box and hand it to UPS. It goes back to vendor. Once they receive the core they issue us a credit and we would refund/credit the customer.

its the same thing as buying an alternator for your car at a supply shop. You are turning in the old part so they can utilize it for refurbishing. In a weird way it is a physical inventory item just not likely to be a good candidate for kits. Thats what I was afraid of. We would like to feature these products on our web…

You should be able to do an Inventory Adjustment by -1. Unless NS changed something recently John, I think they mean the Bin On Hand is 1 but the Total On Hand is 0. They have to do the two step methinks.

Thanks. After some time with support it turned out to be exactly what John Cirocco was describing in that thread. All fixed now and I know how to find it in the future should that little demon pop up again.

Thank you so much!!

I have run into this several times recently and it was usually caused by one of 2 factors. 1) the item used to be in another bin and the bin was removed from the item record without transferring qty or 2) the items are hanging out in what I call the ether which means they have not found their way to a bin yet. I normally…

Did you ever figure this out? I would think the trigger event would be After Record Submit, event type "create", and context "user interface".

After some research I discovered that a bin had been deleted from the item record. That bin had held the on hand qty. I put that bin back in the item record and it automagically contained the on hand qty. I then transferred qty from that bin to the correct bin and deleted that bin and everything is golden brown and…

We had the same problem with our system. I exported the base (selling) price of the items from the old system and was able to simply upload this field into the base price field of the new item structure. We did end up changing our pricing structure as NS is limited with options and did not fit our old pricing structure.…

Add 1 more criteria Transaction : Main Line is true worked for me

I was able to get it done by defining the transactions I was looking for. To isolate the items that had been in the system but not sold since migration I had to include Bill transactions, since that is how they were migrated into Netsuite before go live. Thanks for all your suggestions.

I did that already, but like I said it does not capture parts that have no invoice activity. I found an item on my own that has been on the shelf since the migration to Netsuite. Not a single unit has been sold since then so there is no transactions other than inventory counts and bin transfers. Those are what I need to…

I am going to ask a dumb question. Is that formula in the criteria or the results?

If it's not too late to change, a better option might be to create a custom field with a list of return reasons. In addition to making the reporting easier, it also gives you the ability to make the field mandatory. That is brilliant. Thanks for the inspiration. I will let you know how that turns out.

OK, thanks Carl

Reports>Sales>Sales by Customer>Customize Summary EDIT COLUMNS Lower right side shows alternate Date Range Type – Choose Relative to Report Date Below that shows Alternate Date Range – Choose Last Fiscal Year to Date Below that shows Range Segment – I chose Accounting Period SAVE and RUN the report When I run the report I…

are you using ZIP Code "is" 77030 as your search parameter? If no, what are you using?

Robert, Thank you for the quick response.

Thanks Andy I did as you instructed. The column shows up on the invoice but is not populated. So I unchecked Store Value and they showed up. Thanks for your help.

Ours print out the item name/number I have attached a screenshot of the settings I believe control that. Let me know if this helps or is at least moving towards helping [ATTACH=CONFIG]n408086[/ATTACH]

Screen Fields is no longer a choice and therefore neither is columns.