Many thanks Kirk, That is certainly a good alternative, but I was hoping for a more dynamic Customer Saved Search solution...My skills for figuring out a formula fall short. I suppose if I could figure out a script that would run nightly that searched transactions for the criteria to then update customer records checkbox…

Very good input, many thanks! To elaborate on my dilemma, I am creating dynamic Customer Groups that can only use a Customer Saved Search. Selecting items individually is too limiting / cumbersome, therefore if there was a way to search the Items Purchased for sub-fields of the items such as Color or Size or Country or…

Thank you very much for pointing me in the right direction. The null value certainly is the key in a saved search. The following works just great returning the desired value: nvl({item.quantityavailable},0)+nvl({item.quantityonorder},0)-nvl({item.quantitybackordered},0) Now, what I'm looking for is a .js script to work on…

The null value thought does seem to be correct as even if I just change the default value to {quantityavailable} and there is an available quantity, the field displays, ERROR: Field Not Found I believe the multiple locations is the problem, but I'm really at a loss on how to tweak the script to work. The internal ID for…

Brett - Thank you SO much for this! Re-working the script at this level is above my skill set, so I think I'll add this to the to do list. I've added your link to my favorites and will be in touch. Many thanks and cheers, Pete

Olivier - Excellent! That does seem to work, but we have to create a faux employee where I'm the supervisor and the faux employee is an A/P Clerk...So, I'd have to log-out, log-in, then enter a PO, log-out, login again...We're a small company (6 users that are all admins). So I very much appreciate the viable solution, but…

Terry - OMG....Thank you SO much...That is exactly what we need! Many thanks and cheers, Pete

Barry - Many thanks! I think we understand the mechanics much better. All the best, Pete

I love answering my own inquiries :-) I'm pretty sure this is revaluating currencies... Transactions > Financial > Revalue Open Currency Balances Question is will this ONLY affect the Cash Account - Euro when checked, or will it also revalue transactions accross the board, ie; Average Costs for Items? This is one of the…

Hi Russell, Thank you for taking the ball on this. I look forward to the fix. Cheers, Pete

All seems to be working again. Many thanks for correcting these errors! Cheers, Pete

Russell, It looks like all the scripts for advanced promotions were updated on 07/18/2013 5:53 am...That's roughly the time we started experiencing all the problems. Anyway to just revert back to the working scripts? Cheers, Pete

Mark & John - Many thanks for your assistance! This seemed to work as I have a different form for registrations (external): Setup -> Website -> Shopping Tab -> Customer Registration is (I changed from Optional to Existing Customers) I was concerned this would shut out people from browsing our website, but that does not…

I think the way to attack your issue if I'm understanding it properly is to create a variable: subsid_available_qty = on_order - qty_back ordered Then display the subsid_available_qty as desired.... To change the text for "stockStateMesageHTML" which generally displays "(Out of Stock)" or <%=getCurrentAttribute("item",…

I just created a saved search which searches the system date for display on website within last 90 days and the search result is sorted by system date so it lists the items in date added order...Really cool concept...We have been using a category for these for quite some time, so I think this will be a big time saver and…

We've had our fun searching for our items in our webstore. We ended up having to populate the keywords in the item to help it out a little bit. You'll probably also want to populate the Store Name, Store Description with the keywords too. A baffling one for me is if an item contains a single quote in the name ('), our item…

We had an item today that was quite elusive...We un-checked Display on website...Saved it...Then checked-it-off, saved it and voila! It appeared...

Hi Tara - Can you copy and paste all of text from the item list template ? My guess is that there's just a little tweak to the code that's needed... Cheers, Pete

If you figure this out, please let me know! We have tens of thousands of items in different categories and it is a critical need to simply delete or overwrite the list in the item's individual Store Categories. I have tried a CSV import and it just adds a category to the item...There must be a way to delete or overwrite…

Wow! Some great sites here which I'm learning a lot from visiting! I'm starting to finally gain some confidence and have fun tweaking our website after using Netsuite for 5 years. We've now got Auction items integrated with inventory items, and non-inventory items (which look and act like inventory items which has made…

Same here ~ It adds an un-needed step to our process and thus reduces productivity. Can it just default to 'more' and hidden on the form? I tried, but it doesn't seem to take.

How do we make it smaller and shorter again? I have to say our muscle memory for getting ready for the next click while waiting...and waiting...is creating a challenge for our employees. I find myself hovering over a button, then the whole screen jumps down an inch and I've now clicked on something else in error.

Many thanks for the direction and explanation. That worked! Cheers, Pete

Our merge operation has not been working since the upgrade. I was hoping NetSuite would've resolved this by now if others are having issues. In any event, we now receive this error when attempting the merge duplicates. I only have the e-mail address set to detect duplicates. I don't understand what credentials are? Thank…

Thanks Maria -We got the location onto the Sales Order and Purchase Order forms as a work around. Looking forward to this being repaired! Pete

I'll be looking for this fix soon too...We offer many items for Spring delivery and customers are ordering away expecting them to ship immediately...A real problem! We use the term "Pre-Arrival" in lieu of "Back Ordered"... However, here's a temporary fix to add to your item cell template that seems to get around the…

Well, as far as our website is concerned, it is not correct. We are still experiencing the same problem(s).

Hi Bill - I can not find any documentation either. However, I know the search even includes the 'Detailed Description'. In our case, our customers have been able to search for wine that has "blackberries" in the tasting note...And that's still the case on many/most items even though there is nothing in the keyword field…

Many thanks. I did investigate that, but keywords are not the problem/solution though. For example, I don't have any keywords in any of the items. I did try adding some keywords and waiting a couple of days...Still not picking it up. I also tried changing the category/ies on a few of the items to test if it was category…

Hi Darren - Many thanks for the quick reply. re: 1) No, we are not using the Currency Integration Feature. re: 2) Yes, the Dollar/Euro rate is currently set at 1.366 but €3,143.52 -469.02 (yes, that's a negative!) appears in the list of accounts and in the Balance Sheet. And the bank register for that account shows:…