This worked for us as well, wrote a very short script to default the 'payment amount' field to $1 on record submit to validate that the credit card is active and chargeable (we generally do not collect first payment for a few days up to a few weeks after the order, then each month after that). One issue we ran into is that…

There is a "Payment Amount" field under the "Billing : Payment" section of a sales order. I think this is not displayed by default, but you can customize your Sales Order form to display it. This field by default takes the entire transaction amount (total), but can be changed if you want to authorize a different amount.…

Why not use a Commission Schedule with a Calculation Scale set to "Marginal"?

What's the end goal here? If it's just to see how many days elapsed on open orders, there's a "Days Open" filter / column available by default. If you want the age of the order in days, use the function "Age in Days" on the Date field. [ATTACH=CONFIG]n412207[/ATTACH]

mma678 Try adding "Main Line" to the search criteria and set the value to "Yes"

Have you tried a summary search criteria of type Sum, on field Quantity Committed? You could also try a regular search criteria on the field Quantity Committed.

ajrey77 The duplicate check when using an online form for a custom record that allows ID (name) is vanilla NetSuite. It should work without any additional scripting or workflows, especially for the Name / ID field. I had to parse the value to remove the prefix in order to search against the internal id because I was…

Wouldn't the default Opportunity field (available on sales transactions) suit you?

markrCMD7 use the string to date API - nlapiStringToDate() - and set the field value using this APIs output nlapiSetDateTimeValue('myDateTime_field_internal_id', nlapiStringToDate(myDateToSet.FormattedString), myDateToSet.TimeZone); 

So is this possible for a transaction column field? I am looking to do this for line items also for expenses, and I am not seeing the fields in there for it. Not using a workflow. You'll have to write a script and probably use a validateLine function to make sure there's a value in the transaction column field that you…

tavanpat Not completely sure about this, but the syntax might be incorrect. Try this and see if you get the expected result. CASE {custrecordsfcountry} WHEN 'Cyprus' THEN 'CY' WHEN 'South Africa' THEN 'ZA' WHEN 'Ukraine' THEN 'UA' ... ELSE ' ' END

jalarson1 maybe the custom field ID is incorrect? To my knowledge, IDs for Other Custom Fields start with "custrecord"... If that's not the issue, we can look elsewhere in the code for the problem.

GarrettSulzman : I don't think a field level formula would do it, since the conversion rate is actually on a sublist of the unit record. Try a user event script.

You'll need to add another custom field that links the custom record to the parent (Project) record. This is pretty well defined in the Help Center or SuiteAnswers. Take a look at https://system.na1.netsuite.com/app/help/helpcenter.nl?fid=section_N2885788.html or look for "Understanding Parent-Child Record Relationships"…

How do you add in a list view into a Custom Transaction Form from a Custom Record? I have created a custom record, along with it own form to do status reports on active opportunities. I have set Opportunity to be the parent record for this custom record but cant seem to figure out how to display a list view of this custom…

This attempt was with two different searches with different criteria, but on the same record type. If I can figure this out, I'll expand the scope to different searches on different record types. The workaround I currently have in place is a single search with modified criteria to include results from both searches, and…

My mistake... I used the wrong indexes in getResults(). I'm an idiot.

Okay, this is odd. When I tried this on a test account (one of the TSTDRV accounts) with the same saved searches, same template and same code, it seems to work perfectly. I think I'll take this up with NetSuite support.

Sorry if that wasn't clear. I meant that you should comment out the line in red. You don't need to add quotes to the field id since it's already being passed as a string. I'm guessing that;s where the problem is.

What's the error message you see upon failure? And does the nlapiLogExecution before the failure log the correct value?

Okay. Comment this statement and then try - findme[b]='\''+findme[b]+'\'';

I need to bill sales orders automatically when they come in from our web store. Does anyone have an example of how to do that? I've also been told it can be done with a Workflow but have yet see anything that would do that. jmessersmith : It can be done with a workflow, but you can decide based on how comfortable you are…

Even though the string is in correct format 'custitem_name' it wont read it. I assume - 1. the field ID is correct ('custitem_name'?) and, 2. You've tried executing your code with the field ID hard-coded and it works? The logExecution captures the null value. If your statement nlapiLogExecution('debug', '?',thisfield);…

Use at your own risk. It may work but it's not how you access a sublist in SS 1.0. While tempting, I avoid this if at all possible. Not too long ago, merely calling JSON.stringify() on a nlobjRecord would throw an UNEXPECTED_EXCEPTION. I agree. I don't JSON.stringify() to actually access or use the record. That was just to…

You should be able to access the Credit Card's internal ID when you load the customer record. There are no separate flags to be set. Loading a customer record and then using JSON.stringify() on the loaded record yields this (I've only pasted the part with Credit card info) - "creditcards":[…

The same thing happens when I use Safari to access this forum. I just hit cancel on those pop-ups and everything seems to work normally after that.

However, like webbee stated, it should be in system information as well. I thought so too, but when I created an order from the customer center, using a contact login (not the default customer login), System Information only shows that the order was created by the customer. Not which contact of the customer. I think what…

Did you find a solution to this? If not, I think DocuSign provides APIs for you to use with any record type in NetSuite. You might want to see if that's a viable option.

kkregowski : Not sure what your first question is, but you've got the right idea. Setting up a custom field and filtering based on that should solve your problem of having to change reports / searches. For your second question - If you're searching on Customer records, then the Sales Rep filter will be based on the Sales…

I don't know a way to create a child record of the inventory number record. You could create a custom record to store the lot number and related sub -lot numbers, but this record would probably have to be populated AFTER receiving / shipping, not within the regular process. And you're right about not being able to track…