My Stuff
Check out Oracle NetSuite upcoming events and conferences here
See All the Unlockable Badges
See All the Unlockable Badges
Comments
-
I wanted to share one other thought on this topic. The above seems relatively cumbersome. Why not simply have a "Void" button on the Customer Payment record? In particular, it seems silly to have to make the deposit just so you can go back and issue the refund against a payment. I'm interested to hear anyone's thoughts on…
-
I've been experimenting with this for slightly different purposes, but figured out the following... If you go back to the Customer Payment, you can unapply it (assuming you're still in the same period). The payment also needs to *NOT* have been deposited into a NS banking account. Once those two steps are completed, you…
-
Thanks, Evan!!
-
That works, exactly as written. Thanks again! Since we are on a roll, here's another question: Let's say I wanted to change the font size, color, put it in bold, etc. Is that possible? My experimentation so far suggests that NetSuite simply ignores additional html tags within the div. For example, '<div align="right"…
-
Robert, That is simply awesome! Works like a charm. The results look a lot better when formatted that way. Thank you very much! Bonus question: It now formats as "left justified" - is there a way to make it revert to right justified? ~Dave p.s. I removed the ".99" part and, as expected, the decimal portion of the result…
-
ROUND({fieldname}) returns 9999 (no comma after the thousands digit)
-
Hi Robert, Thanks once more!!! You must be some type of Jedi :) That's enough info for me to experiment on my own and see what else might work. Best, ~Dave
-
Consider using the RMA process. You can even start from a sales order, then change the sku on the return order to the consignment/rework sku.
-
You may want to handle it differently if it is possible to remanufacture the product into saleable goods (same sku). In that case, I suggest transferring to a dummy location while the goods are in transit or at a vendor being reworked. Then you can simply transfer them back to FG inventory when they arrive back at your…
-
Once bins get really messed up (e.g. bin inventory counts don't sum up to Location count), it's very difficult to fix. I think that's why many people steer clear of them. Concur with JCIrocco - if you are going to use bins, you have to make the investment to do it right. For example, make bin assignments mandatory for all…
-
Try this: Saved search of type = Campaign Criteria: Campaign Event Type = Email Results: Title Event Campaign Recipient : Name
-
CASE, RANK, and DENSE_RANK are supported. KEEP is not. Please see: SuiteAnswers - SQL expressions SuiteAnswers - Search Formula Examples and Tips
-
You need to reverse the Group and Sum. Group the thing that you are counting (# of Contracts) and Sum the members (Success Coaches). Also, I think you're going to have to split this into two searches to get both of them Summed.
-
I was also told by NS support during last cycle that the beta systems email out to external addresses, but, in testing my experience was that beta email behaves the same way as sandbox email. I think there may be some misinformation circulating in the support org regarding this. Can someone from NetSuite please confirm?
-
I may be missing something obvious here, but I'm wondering why not use expressions? a. in criteria, check the box to "Use Expressions" b. group any sets of criteria each within parentheses c. set And/Or as appropriate for each line
-
If you are using NS-native PDF generation, you can also edit the PDF template and add a text block.
-
Our web guy says you can use ftp as a workaround, especially inside a firewall. He says pc's and servers allow designating folders as ftp. Once you did that, theoretically the link would work from a NS page.
-
In order for a custom field to be available for Direct List Editing, it must be shown on the Preferred form. In the case where you do NOT want the field showing on the Preferred form, add it anyway, and put it on a new tab so at least it is out of the way. When I have time, I'm planning to experiment with using role…
-
The only way I know of to force a second or third page is by having additional line items. Yes, it would be great to be able to add pages with, say, the text of a legal agreement, etc. especially with mail merge fields. I'm expecting that's going to be be a pending enhancement. Please do post whatever you find out.
-
My two cents on this, for what it's worth: Seems (to me at least) that there is a lot of work out there for web developers who can function inside of the NetSuite environment. I would love to hear others' opinions on this...
-
Scheduled scripts run in Sandbox, but NOT in Release Preview (beta).
-
mhill - glad you were able to get this working. Cool idea! May I ask where you are getting the lat & long values to store on your customer records?
-
Excellent!
-
Hi Olivier, Regarding use of an "Inline HTML" field: what would you consider to be a sensible use of this? Just for links?
-
Thanks, Joe! I also appreciate these posts. Good for increasing SuiteScript knowledge.
-
Thanks; that worked perfectly. Now I feel stupid :o
-
Brett - very good of you to post this. Thanks much for sharing. ~Dave
-
I have not seen Contracts Module, but I can tell you that under Software Edition (the predecessor to Contracts), the R05 script is in fact the one that creates the renewal Sales Orders.
-
Try having your order entry folks begin entering the RA from the Invoice. There's a button for "Authorize Return," and if you do that, NS will give you a "Created From" field that links back to the Invoice.
-
Regarding processing of the invoice - Once you receive a PO, you will have the option to Bill it. Billing a PO creates a vendor bill in your system, which is meant to go against the vendor's invoice to you. So, when the Invoice arrives, you simply attach the file to the vendor bill, then pay the bill as you would normally.…