PaulFleetwood Silver Medal

@Peter_Shun_Li_22 - can't believe this was 3 months ago! - it's been in my 'to do' list all this time but I've just implemented this and it works really well. Just wanted to say thanks again for posting - really helpful (and now I've found this option to link scripts to forms, I am thinking of other ways this could be…

This is a significant issue in a number of places within NetSuite - and I don't think it can all be attributed to 'bad process'. Customer Record - someone who is responsible for Customer Pricing could be entering Custom Pricing for Items and Groups on a Customer - this could easily take 10minutes, and often longer. If…

@Leonard Mallare-Oracle thanks for your thoughts and suggestions. I've just checked the main product page (to match your screenshot above) and that is now showing 'available Tuesday': We are now past the 'Same Day Pickup Cut-Off Time', so i would expect it to be different to the date shown this morning, but I can't…

Running a test order this morning (before cutoff time, so should be available for collection 'today'), and it is showing this in the Order Basket: That location is not even set as 'open' on a Sunday?? Shows this when viewing Stores for that Item:

Thanks very much @Erick Dela Rosa-Oracle - that works really well!

@Erick Dela Rosa-Oracle I am still struggling with this - I think there is something special / peculiar about the shipaddr1 field (and presumably address 2 and city fields). I can use this fieldname to source a Custom Transaction field that does not store the value - this works fine: However, if I use the same details in a…

Yes. clearing the cache seemed to resolve this for the affected users - thanks. I've not seen this error message before.

Support have recommended clearing the browser cache which seems to have resolved the issues. I'm still not sure if this was an actual NetSuite issue (nothing has been logged on the Status page), or some kind of local browser issue?

Yes, I have now. I am also working with the 3rd party to see if I can extract the address data to custom fields and have those available in the API extract. I have created 4 identical fields, sourced from the address fields. To be honest I wasn't expecting any of them to appear in the API results, but strangely one…

They are using SOAP API

Thanks @Jack Daryl Espiel-Oracle I can't get this to work - it is failing to meet the criteria - I suspect it may be a 'null' value problem? I tried adding: and {paymenteventresult}!='Payment Hold' To my criteria (that was previously passing as 'True') and it started returning False I've also tried:…

I will speak to the developer to confirm the type of API It seems strange that the API for the Sales Order transaction can return a Custom Address without issue, so why can't the API for the Return Authorisation? Is this a bug or defect? Is this something that could be addressed? Should we raise an Enhancement request for…

Yes, I check that site regularly, but there is no mention of any issues today. We were suffering very poor performance for at least 2 hours this morning (although that seems to be improved now), and then when I came to log the issue, SuiteAnswers was not working (which appears to be my only route to support). Is there…

Yes, it is working again now

Thanks The top two don't directly relate to multi location orders, but rather the general inadequacies in the Print Picking Tickets screen (and both of those were raised by me previously!). I have added my vote and comments to the third one, and I can't find the fourth one when searching SuiteIdeas (either by number or…

OK thanks - we shouldn't be creating standalone invoices (but I will have to check into that), but it is good to know I can remove that field from the normal invoices. I may look to see if it is possible to identify if the Invoice is standalone or from a Sales Order via workflow, and either show/hide the field or change…

@Joahnna Given Uy-Oracle We are now using the Line Level Location fields on Sales Orders to fulfill Items from multiple locations on a single Sales Order When you use the Print Picking Tickets screen (to print multiple picking tickets), this respects the Location set on that screen and only includes Items to be picked from…

Thanks @Joahnna Given Uy-Oracle - that is part of the solution, but is there a way to print a picking ticket filtered to a Items from a specific Location?

Thanks @Joy Noreen Magoling-Oracle I would be interested to know if there is a customisation option for this.... Is it possible to access the User's Location field within the Advanced PDF Template? If so, I might be able to build some logic into Freemarker to filter by location?

Michelle I haven't really tried using the Marketing Reports (to be honest we rarely use reports outside of Finance!), but I think I have configured it correctly. I filtered it to the relevant Campaign ID. This is what I am seeing: Which appears to be the same as the Event Responses: But the sent email list still shows 340:…

Michelle The SuiteAnswers article says: Queued – The email is in a queue to be sent but has not yet been sent. But that doesn't make sense in my examples above because the Sent EMail list shows 244 sent successfully. You are saying (different to the SuiteAnswers article) that the 174 'Sent' emails are ones where the…

@Matrim - Thanks!! That looks ideal - I was looking for something like that 'Greatest' function you have shown above - I assumed there must be some 'clever' way of doing this :) Yes, I think your second option could be ideal - I will run some tests. Thanks again - really, really helpful

Thanks @Dominica Sevilla-Oracle @Ivy Lopez-Oracle - your example is essentially what I have been trying - my problem is the 'amount' that I am basing this formula on is not held in a field (or custom field) - it is the output of a very complex formula. I cannot include the complex formula 3 times in a single new formula…

@Jack Daryl Espiel-Oracle Thanks for testing this - I did exactly as you have shown above yesterday when I first tested this, and it returned a £0 value. I have run the same Statement template this morning (on the same customer) and it now returns the correct Deposit Value as expected. Apologies, it must have been some…

Sorry - slight correction: I have a Saved Search for Invoices, Cash Sales, Credit Memos and Cash Refunds. Invoices and Cash Sales should be included when formula result is positive, but negative results should be shown as 0 Credit Memos and Cash Refunds should be included when formula result is negative , but positive…

OK thanks Jeff - it is unfortunate that this best practice was not recommended by our Oracle NetSuite SuiteSuccess implementation team - I will add that to my (ever-growing) list of reasons not to use NetSuite PS in future.... Thanks for your advice and suggestions, I will look to see how we can adjust our current…

What is general accepted 'best practice' for recording locations on transactions? Is this generally done at line level or header level? Similarly, how should the Shipping Method field be used? Should this only be used for Shipping (and left blank for collections), or is it normal to have 'Collection' as a Shipping Method?…

Thanks Michelle - yes the customer I was having this issue with 2 days ago will now let me add an order. I've tested one where the coupon was used today, and although it errors when I try a second order, I can place a second order using a different browser and NetSuite user. I will do some more testing to try and determine…

Michelle - apologies, perhaps I wasn't clear in my original post. Yes, the promotion will work once for each customer as expected (so testing on a different customer shows the discount on the first order, but not on subsequent orders). My problem is that whilst the promotion is running, and customer who has received the…

OK thanks Jeff I will approach support and see if they will look at this for me (but I suspect they won't under standard support)