Frank Lau Red Ribbon

Does it work? As I am reading the codes now, I do not see anything on the codes that are related to the address field. REALLY ? REALLY ? You saw King Kong jumping in your backyard?

If you enter data on any online forms that you have, trying to update the existing data in the entity fields. Even though the online forms do not include any address fields, the data on the online form you submit will make the COMPANY NAME overwrite the default address (defaultaddress). The orignial address still exist…

To NetSuite: An user like "The Wizard of Oz" just replied and echo my case. This is what I was talking about !! I treid to make changes under "Set Up Workflow" but none of the setting can stop overwrtiing the default address. *************** I'm getting this too after being upgraded to 2009.1 No address fields in my forms,…

Hi, The problem is, I have looked at all of the possible places in script and NetSuite, I do not find anything codes that set the sender to Sales Rep. If I saw the code, I would change to the users orther than the Sales Rep. I assume the default is set to mailing to Sales Rep, does your auto-reply send to Sales Rep too?…

I don't see #2) you mentioned below. Not sure about the field having any restrictions but maybe this open script submitted by the NetSuite Development Team can give you an alternative method to capture the information. It’s based on branching logic. To gain access to it:[LIST=1] [*]Log into NetSuite with permission to the…

I have tried many-to-many relationship between supplier and customer records. It works great in NetSuite. And yes, you need to know both of them are parent records of each other. So you need know there are two data entry points if you need to do searching and reverse searching.

Yes, I have the same issue. For some reasons, NetSuite is not buddy up with many HTML tools anymore. What I did was changing them to links. You could try to upload those icons to your File Cab, and then use their URL for your intention.

Hi Olivier, I Just want to understand a bit more. So you mean using workflow or scripting can let me lock the update to custom record. which field or what kind of value get set so the record is locked? thanks a lot, Workflows or scripting

Hi Olivier, I did a testing and it works. However, the updating in custom records through importing is effective when the importing preference "Run server scripts and trigger workflow" is ON But we can have it ON all the time, and it is toublesome that we have to turn it ON during importing. Are there any to bypass this…

Awesome !! Thanks In script, you would do a beforeLoad script (and maybe a beforeSubmit just to be safe) that will simply throw an error. In workflow there is literally a lock record action.

1. On the custom record 1 config, you need to use "Include Name Field" 2. This method is doable on selection drop down list. So the weight value is showing up first, then another selection list can show the result of the comparsion. Once the field is a "List/Record" type, you can find the comparsion config under…

Hi, I find that email template can be used through custom record >> message function. Doing this, email template can display the records on file. Yet I do not see that we can make this working in bulk merge. thanks

Hi Shubs, You are right on "can not directly create custom records from a lead" online customer forms and custom record online forms are two different tools and they do not go thogether unless you use a suitelet or an user event script to filfill the criteria above. A custom record can be used as a selection on a dropdown,…

I made an incorrect finding, custom record is not an option on the "field type" in email template. Can someone from NetSuite respond to my question soon? Can email bulk merge work with custom records? How do I insert the custom record fields on the email template?

Hi, thanks. For sure it works with email bulk merge also? As long as you check "allow mail merge" in the custom record setup , you should be able to merge from it

I suggest that you make molds of #1, #2, and #3. Spend hours on understanding their configrations in custom record, and how you can build relationships among them. After your feet are wet, then you can make the molds as the production and script the #4 Hi Shubs, You are right on "can not directly create custom records from…

for example: customer main record called "main" sub record 1 called "subOne" field 1 called "fieldA" sub record 2 called "subTwo" field 1 called "fieldA" Make a search based on main, in the formula, use: subOne.fieldA = subTwo.fieldA I'm trying to do something similar, and I'm not sure how to join the record types through…

Your idea only can be done through User event scripting, yes make copy of a parent record and its child records is doable in scripting. but I do not see any rooms to work this out in UI... Hi Thanks for your help! Can I enable the grid (subtab) in the UI? I can't add new line (child record) in the same moment (when I've…

This is the same thing as you make a copy of a customer entity record, or a prospect record. Making copy of a parent record does not mean its related child record will get copied over. When you make a copy, the new parent record has a new internal ID so the original child records do not link to the new internal ID of the…

I see. Based on weight of an item, you want to know what the shipping clost is, correct? Try this: You need a custom record#1 that lists all of your shipping options including weights and costs. then on another custom record#2, first add the primary index of #1 under its own primary index of #2, assuming this index is the…

If there are no links between two custom record types, you will need to use formula/script. In the formula, you first will need to link up two record types using their primary index, then the referring to the rest of the fields is possible. A wild card search on any non-indexed fields without using through primary index is…

This is the same thing as on a search, you can not trace another custom record from a custom record. You can trace a tree structure of parent-child relationaship in up and down direction but not at the same level without going up first.

I had a similar issue like this before. A customer record has a child record type, and there are many child records in this record type for this one customer. You make create their uniqueness by using these on a search: 1) internal ID of each child custom record 2) assign unique ID to "Name" field 3) external ID is not…

Is the field "store value" checked? Is the field sorcing from the other fields? one of the combos in (store value + scorcing + default formula value) does not work well on the search. We have a problem here as well. Example: We have a formula currency field named "custentity_actual_gp". The field works perfect on forms and…

Marty, I think I get the idea. Not sure if the following topic in HELP will help, but try to see if you can make the best for your goal. Standard vs. Dynamic Mode Code Samples Thank you for the response. I should be clearer. On custom records, the customform appears to be an integer. Notice below that the customform…

Marty, Are you talking about the "internal ID" of the custom record entry form? As far as I know, internal ID on the entry form does not change, it is assigned by the system. If you delete the entry form, surely it is gone forever. Using internal ID to do referrence in NetSuite script is the receommended way, much better…

Hi Olivier, thanks, it works. However, I could not find the internal id for the custom form of the custom record type. I simply used nlapiSetFieldText(''customform, "formname") Do you know how I can see the internalID of a custom record type custom form? nlapiSetFieldValue('customform',FORM_INTERNAL_ID_HERE) should work

Marty, How about the standard form, standard form id gets changed also? If customform id changes, do you think it will work if ONLY one ACTIVE form stays and thus the script can make the record without specifying the form id? or... after the depliyment, scan through all of the script and retype the id. or... make a sub…

Yang, my mistake, it should be the standard form. Well, every record type (custom record) has an option to have standard forms or custom forms. I have a costom record to store the address of our customers, and once the new address is saved through the forms, I would like the custom code on the forms pass the new addresses…

Thanks, but as the administrator, I still can see every record type that is underlined even though they have blank owner, is it because I am the "Administrator" ??