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…

Is it possible to use decode to determine if an item is a matrix child and set fields accordingly? Something like... DECODE({matrixType},'_child','this item is a matrix child','is item is not a matrix child')

Shouldn't or couldn't this be easier? -Tom

Thanks. It worked. Used... CASE WHEN {createdfrom.paymentmethod} like 'Amazon%' THEN 'Amazon' WHEN {createdfrom.paymentmethod} like 'Walmart%' THEN 'Walmart' WHEN {createdfrom.paymentmethod} like 'eBay%' THEN 'eBay' ELSE 'our web site' END Lets say the custom filed ID was {custbodysales_channel}, then when adding this…

Found the convoluted workaround to adding the custom field to the fulfillment email in SuiteAnswers (Answer Id: 31505).

I hate to say it, but we don't know enough about deploying scripts to take your script and make it part of our forms. PM me if you want to do it for us (and ear a little extra $) or post a step-by-step how-to if you have the time. Thank YOU, Tom

Yes, I did try that one. It didn't work. Do you have any more ideas? ${item.item} appears to be a combined field of "{ItemID} + Item {displayname}". We just want ItemID. I'm sure others would also want a column just for the part number on their sales orders and such. -Tom

ALSO, while we're at it, this field ${item.saleunit} doesn't work and was a column on our standard or legacy Sales Orders. -Tom

That is what I thought. Thats a bummer as we don't have people in-house that write js