Cloud Red Ribbon

Same with me... I can never get formulas to display on the webstore, I always get an error even though it works in NetSuite. Is there a setting that enables formulas on the webstore? Khultquist, My Formula {custitem14} works fine -The formula adds inventory and drop ship Qty, However when I add this formula field into…

Some of mine: http://www.utilitysafeguard.com/ Really like the Menu on this... care to show how you did this? thanks Even though I am not the Web Site Developer just training up to be Admin. Our Site : www.Gardensandhomesdirect.co.uk - Seems Pretty Cool but still loads of work to be done.

Has this been fixed since 2009? We have a customer who has 70 credit cards and has tried to order several times from our site each with different addresse going to the same postcode. I do not know if their is a postcode block? but I'm really interested in IP Block too. Thanks

Hi Robert, I used Maximum on Document Number and it worked great. Thank you.

Hi Robert, Sorry I should have mentioned its a Transaction saved search. Will this work? Currently I'm bringing in Customer, Name, Email, Phone, Date of Last Sales Order. So with this, I want to bring in the Latest Sales Order number, so If a customer ordered last in March and after that there was no more orders from that…

Hello, I didn't want to create a new thread for an existing problem. I want to bring the Parents or the name instead of the child. For example - Surgilube Lubricating Jelly : EF020537/EA, to show me Surgilube Lubricating Jelly. I've tried - ltrim(regexp_substr({transaction.item},'[:^]$*')) &…

anyone please?

Hi, Any update on this enhancement? A customer of ours have just flagged up they cannot purchase some of our items and it's due to a item option that is selected. We believe there is more than 400 items which might have this option selected but as it's not available in search, I cannot get a complete picture and it's hard…

Hi, I talked to my manager and they want to be able to group the depts together (be able to drill down to item to see which item sold in which category which as far as I know you cant do that in a search for either of them) currently selling under own site, eBay and Amazon. so we want to be able to show how many orders…

Thanks Mate. I will do that.

Hi Chuck, Thanks for the reply. So what does this defect#159205 mean? First time I come across the 'defect' issue. does it mean they going to fix it, if so when? Thanks

I am also trying to round up the total at the bottom. I tried function to hundreth but it doesnt do anything. Please can someone help? short summary 2 13.32 8.32 6 36.68 15 Total : 7.359999999999999 <-- is there a way to round this up to 7.40? and have another column 'average' in this search which reads :…

second thing, I am trying to get average order value. so my amount net which is a sum and sales orders which is count. I need to divide amount net by number of sales orders to get the average value. sum({transcation.net})/count({transcation.number}) but that doesnt work. I tried formula numeric, and currency.

ok quick update, it works :) great. However we also have amount net and purchase price as a total figure. I have tried count, and group but it doesnt display how I want it to... any ideas? I couldn't find main line.

Any help guys? :( also, I have done another report and I wanted all the items names grouped together, so it is easier to read and shows how many items have sold, but the problem I have is tying to get the name to display at the side without having to expand it further. I tried to group the display name but that still…

any help? :(

Thanks pal... I shall try that. :) you wouldnt by any chance help me with the other query?

-- cant delete this comment ()

im trying to get the average order value. Sales orders is count and then I am trying to divide it by Amount Net (which is a sum). so I tried count({transaction.number}) / Sum({transaction.netamount}) Any help? Thanks

Thanks K.Izer :) it helped me

Hi, I am unable to find that, all I found was :2681 Intercompany Setup. I am in install bundles, think thats the right one :)

Well, I do not know scripting and having a saved search won't help much, because anyone who ships/fulfills a item they will just mark both items by default.

We found that the Pick Ticket Printed flag gets reset to 'F' if you partially fulfill the order (using Pick/Pack/Ship). Went ahead and created a script (via a button) to reset the flag - it adds a dummy item to the order, fulfills that item, deletes the fulfillment, then takes the item off the order. It's not terribly fast…

Hi, I want it the other way.. Do anyone of you know how I can get the picking ticket to show 'Copy' if the picking ticket has already been printed - Currently we can print mulitple tickets and this could lead us sending items twice.. (which we have)... Thanks

Hi Bill, I know what you mean. I have opened a case with our Netsuite Seller Support,even they are useless! I will let you know, If they know why and have a fix.

Hi, We Got a response from Netsuite Support (not Our Netsuite Solution Provider -Useless!) and the only workaround is this : Select the line item and click the make a copy button which duplicates the line and sets the drop shipment column blank or false I assume they are going to investigate it further as they have said…

Hi Bill, Yes we are in the same boat, we are unable to check the 'Drop Ship' Check box. so we are having to refund using the Sales order and then close the Cash sale. Really a pain in the bum! Btw did you open a case with NS? Netsuite, any support or fix for this? Thanks

Hi J.J, Thanks. We're going to hire a search engine script writer so to create our own customized search. will this be a good starting point, is there any more references/worksheet we could use?

Thanks Dew!! :) it worked. forgot about the double pipe - D'oh! :eek:

Would anyone know how to host the Search Page? There are 2 searches in NS - Product Search and the other is Hosted. We're looking for the Hosted option. Thanks