One final way ...just add one DEF to the original SO with the price for that line set to zero. Make sure shipping isn't recalculated after adding the free DEF item. Save the adjusted SO and hen create a new fulfillment to fulfill the new line as usual, but actually send the ABC that was missing from original order.

Yea, leave the Pieces like you have them, just add a new UoM entry to accommodate the new vendor. So, if you have a UoM called "Pieces" Pieces = 1 (base unit), 12 pack, 24 pack case, 1000 pc pallet. So a new vendor comes along and has a 1200 pc pallet and a 10 pack. Change your UoM to this. Pieces = 1 (base unit), 10 pack,…

A kit item containing matrix items would be an option, but currently not possible. Vote for enhancement number 83720. -Tom

The solution is to set your line to zero quantity, but put a dollar amount equal to what you want to give back to the customer. Sometimes you need to bill before an item ships. We sell custom items and the customer owns them as soon as we take the order because we can't undo these particular customizations ....so they…

So, NetSuite will NOT calculate any item's ROP simply because the item has existed for less time than the preferred OAI time period. I've asked for an issue or an enhancement to fix that bug/shortcoming. I need it to still calculate ROP for these new items, but just use zeros for the sales volume for any of the time period…

I've got an item that has no "Reorder Point" and no "Preferred Stock Level". We've got "Reorder Point" and "Preferred Stock Level" set to auto-calculate. We've got "Safety Stock Level = 30 days" and "Preferred Stock Level = 75 days". This set-up is used elsewhere in our account and works fine. This item is something we've…

Also, a slight issue exists where we have the SSL = say "25", this is going across each inactive location (4) that has a "0" value as a reorder point and then adding to show the mnimum or "reorder point" (4*25=200). This is the same as defect 160802

I've got an enhancement for one of the inventory issues. Please vote on it if you want your newer items to have an reorder point calculated. Enhancement #184170 - Reorder Point and Preferred Stock Level calculation: Setup > Accounting > Inventory Management Preferences > Order Analysis Interval > if the item didn't reach…

NS support confirmed the issue. They basically said that if your Order Analysis Interval is set for 6 months, Netsuite needs to see transactions for at least 6 months prior to the date of calculation or else it will NOT calculate a value for ROP! How weak is that? Why is it that way? It doesn't choke on a one year old item…

Brett, I don't understand. Our ROP is set to auto-calculate. The system is calculating it as ROP = "<null>". When testing, I turned off auto-calculate and plugged in an arbitrary number as our ROP. Then I turned auto-calculate ROP back on and waited a day for changes to occur ....it still doesn't work. Also... The support…

We are also effected by Defect 161788 and would like to see it fixed. I guess everyone is effected that holds inventory and has multiple locations including locations that are no longer active. -Tom

WOW this defect was reported in 2008 and filed as S2 (S2 = Average of 60 days) and it still isn't fixed. I was told that Defect 160802 is causing this problem. Defect 160802 - Home > Reminders Portlet > Items to Order > shows items to be ordered for inactive location > Preferred Stock Level still auto calculates for…

Thanks Steve, Not sure how this lines up with your experience, but thought I'd consolidate the knowledge into this thread. This is from someone in our office and was posted in another thread on this topic... I think I've figured out the work around for adding freight to the Item Cost (landed cost). First you need to make…

We have multiple locations. We do auto-calculate "reorder point" and "preferred stock levels" on most items. Today my dashboard reminder says "26 items to order". I click on the reminder and I see a list of 16 items. It is set to locations = ALL. So, why does it say I have "26 items to order" when I don't have 26 items to…

the idea is to delete the min/max values in the location in question. Leaving it at "0" will have it auto calculating again. We set it to ZERO and we also tried deleting (or setting to Null) as you suggested. in either case, it recalculated the need for more items at the old location. Turning off auto-calculations for…

same issue here...we disabled a location completely and we can see the min/max levels are still seeing the values from the inactive location. A lot of manual work to zero them out. We found we had to delete any entry in the min/max (not just zero) because if you uncheck the auto min/max boxes and then come back later and…

I feel your pain. The "Auto-calculate reorder point" feature also doesn't do anything to help our business because of another NS inventory bug. We moved a bunch of our inventory, but NS has no way of recognizing the move. We aren't closing the old location, we just don't want to stock a particular group of items at that…

How do you filter out matrix parent items from inventory reports? Matrix parent items aren't "real" items and can't be ordered or counted as inventory, so why are they in there? I called NS and they said they can't be removed from inventory reports ...by design. I can filter them out when doing a "saved search", but the…

Enhancement #146229 - Ability to Search items by the Item Drilldown Template field. Has anyone found a work-around? -Tom

I've always thought there should be an item dashboard linked from every item with such information plus sales graphs/ kpi's/ best customer ... etc.

Is the change in the shipping cost or in the cost of the merchandise? T

Thanks JCirocco. I'll try it. I've done lots of CSV imports of items and such, but I didn't even know one could CSV import a quote/estimates. So, if we have 5000 SKUs, we'd end up with 5000 estimates. Interesting. -Tom

oh. got it: Use the formula: median({XXX}) /* avg() */ 2. Set the Summary type to Average

Thank You!

This didn't work by the way. Ug. I wish NS just had a field called "Count of Lines" that worked and only counted the number of line items on any transaction record.

Using totalquantityonhand was the ticket. How do you find out about these undocumented fields? In here... I guess!

formula: "{thumbnailurl}" = ERROR: Field Not Found

I need a text "availability flag" for a feed. I need it in a custom text item field. Any reason why this isn't working.... [INDENT]CASE WHEN {isdropshipitem} = 'T' THEN 'in stock' WHEN type = 'Kit/Package' THEN 'in stock' WHEN {quantityonhand} > 1 THEN 'in stock' ELSE 'out of stock' END[/INDENT] It always says ERROR: Field…

No, we didn't.

For CONCAT of more than two fields you can not do this (from my experience anyhow)..... CONCAT(data1, data2, data2) You start with CONCAT(data1, data2) then, if you need a third variable added, you replace data2 with CONCAT(data2, data3) like this... CONCAT(data1, CONCAT(data2, data3) ) The same goes for data4 and data 5…