3951833 Green Ribbon

What are the record types? Something like this can work for transactions but to my knowledge you cannot search across every record type (unless you run multiple searches in script and assemble the results). If you are searching across transactions you can use the type filter to search across multiple transaction types.

Is workflow available on time records? I had thought not.

I have tried a post source script looking at a separate field that kept the old value in it but the quantity change doesn't seem to trigger postsource. This seems like a reasonable approach. Once the rate field is set you can backup the value into another field. Then when the quantity field is triggered when the checkbox…

Thanks guys. I'm familiar with Olivier's filtering technique but I haven't actually used the parameters technique on rescheduling. Good to know.

If you need to set fields, then yes you'll need to load and submit. If you're just reading fields (which is what i saw in your snippet) then you don't need to submit nor load. That's a great tip. How reliable is using nlapi in aftersubmit? I ran a test and found that when reading the status of the sales order it was…

Hi Latif. I've run into this issue before and unfortunately the only way to do it is use the rev rec journal screen. They can mass submit all journals in that screen so it could be as simple as clicking one extra button. It would be nice though if NetSuite could also automate that step as well as I've had a complaint about…

Thanks everyone. These are some great learning points. Nice suggestion Olivier.

Is the deployment set to Execute as Admin?

Thanks Olivier.

Maybe the lead has to enter in a sales rep ID on the form (you could use the internal ID of the sales rep). You could make that field mandatory on the form and then assign the sales rep based on that field. Instead of ID they could also just type in the sales reps name on the form. When the lead is created with that field…

Yes it's possible. You can add Ur own scripted field and filter that field. On save pass the value back to Ur regular field (which you could hide in edit mode).

You also have sales teams on the customer record. I see a couple of issues with your script. -I don't think you need nlapiGetUser as the value for the sales rep will already be in a field once the user saves the online form. You need to take the value in that field and set it in the sales team. E.g. //sales rep internal id…

Thanks J.J. I was looking for a way to automate the cancellation. It is not available in script, but your approach is one valid method. I prefer tagging the schedules as cancelled, although the issue is they will still show up every month. Maybe adding your mass update as a monthly process will be a good addition. Thanks.

Actually the issue seemed to be that the auto-generated number shouldn't have been turned on at all. This allows me to manipulate the schedule name to set to CANCELLED and this CANCELLED value also shows up on my sublist.

What you could do is copy the line IDs into a custom field on the sales order (when SO is generated). Then when the revenue commitment is processed those line IDs (from the custom field) gets copied over. This way the lines are linked.

Brett, thank you very much. NetSuite has got to get its help guide up to date. I saw it in the records browser but was not in the list of supported records.

Funny that you should ask Mark. I need the exact same thing urgently but doesn't look like it is doable. Can someone please tell me I'm wrong? Pretty please...

Sorry code, right. It doesn't have to be complicated, just set any rate and price level and see if it will stick in 2010.1 vs 2010.2. The price level in the item record will need to be populated (so you can see that the rate is taken from the item record). recSalesOrder.setCurrentLineItemText('item', 'price', stItemPrice);…

Thanks Oliver. We were able to set a price level and our own rate prior to 2010.2. This is really helpful for needing to report on price levels (which we do for commission purposes) and needing to keep legacy prices.

Hi Olivier, I'm aware that if you set the price level to custom you can use whatever rate you want. We would like to set the price level to other than custom and use whatever rate we want (which we were able to do in 2010.1). We use price levels for commission purposes and we don't want to change these, but rates on items…

I'm pretty sure I've been able to set fields in a before load. They've been list/record type fields. Point taken. What happens when someone deploys a beforeLoad user event before yours that sets the value of a stored field on an existing record. How could you differentiate with certainty between a stored value and a…

Did someone find a way to do this?

The weekly time sheet is still not scriptable (it is but you can't do anything with it). I just want to check some boxes but this is not doable via the weekly time sheet (it is in the standalone time sheet). I believe the majority of users use the weekly time sheet. Anyone found any workings without investing a lot of…

Does anyone know if anything has been done on scripting other relationships? Maybe through a transform or some other API?

Hi Alan. We sell a signature add-on for NetSuite called Echosign. I believe this will do what your looking for. Feel free to speak to Kurtis who is our Echosign expert at (416) 400-1126.

I can think of 3 ways to try. Some or all may work: 1-add a custom field and source the invoice number from the return auth. 2-add a workflow and set the invoice number from the return auth in a custom field 3-add a script and set the invoice number from the return auth in a custom field

Not sure if u knew but you can add custom fields to your printed PDF form so that you can include the invoice number on the top of the Page.

Nick your suggestion works well if the payment you are unapplying is NOT in a closed period. If it is in a closed period then you cannot un-apply. Is there no clean way to reverse a payment? Thanks.

I think multiple vendors is your only route. You can use custom fields to link the vendor records together. Ugly but what else can you do. Like the blog/posts on NetSuite by the way.

Marty, thanks for this.