Mike, I did not explain it well. In short, the fielded address is on the sales order but you cannot get to it. 1) Open a sales order 2) On the end of the URL put &xml=T https://system.netsuite.com/app/accounting/transactions/salesord.nl?id=4019&xml=T 3) Search for shipaddr1 and you will find <shipaddr1>123 My…

Mike, I had a similar issue. I am not sure if my solution is "officially" supported but it does work. The sales order and purchase order ship to fields are "fielded". We actually ignore the ship to on the drop ship PO and pull it directly from the sales order. Here is a link to the post, let me know if you want the…

Wow 2, this was painful. I spend about 2 hours trying to figure out what happened. Thank you for the post.

The code below is generating the following error: "ReferenceError: "arrayIndexOf" is not defined. (beforeSubmit#1503)" This error is generating at the nlapiStringToDate. Can someone help the dork (me) who cannot figure this out? var vcustitem_vendor_restock = newItem.getFieldValue('custitem_vendor_restock');…

Support case 607516 nlapiStringToDate does not like the date format of DD-Mon-YYYY. This format results in: ReferenceError: "arrayIndexOf" is not defined. (beforeSubmit#1503) When I change the date format is Setup | General Preferences to MM/DD/YYYY, the code works fine. Would anyone have suggestions on whether this is a…

Support case 607516 I am being told the error: "ReferenceError: "arrayIndexOf" is not defined. (beforeSubmit#1503)" is being generated by web services. We use web services to write to this entity but this error is generated when I am pressing Save from the UI.

Yang, By using nlapiLogExecution("Debug"..., I can tell something is different when I execute the script via UI / Web services versus using a mass update. 1) Below is the debug log for when an item is edited via the UI: vitemId=5, vcustitem_item_number=17312 The above shows we are working on internalId=5 and…

...can determine which fields are being updated by calling newItem.getAllFields()... Yang, Thank you for the note. Does getAllFields() get updated during the execution of a beforeSubmit? If the beforeSubmit sets: Item.setFieldValue('preferredlocation',NewPreferredLocationId); Will the Item.getAllFields() as the next step…

1) This sounds like a bug to me. Please enter a case with support and it will be investigated as soon as possible. Created Case 598972

Hi Yang, I have tried using nlobjSearchRecord to retrieve the long state name from the location table. var filters = new Array(); filters[0] = new nlobjSearchFilter('internalid', null, 'equalTo', preferredlocation_id, null); var columns = new Array(); columns[0] = new nlobjSearchColumn( 'state' ); var searchresults =…

Thank you to Nathanah, Evan and Yang. The following works! Questions: 1) Is there an optimization I should consider? 2) What does the ",null, null" stand for in nlobjSearchColumn('inventorylocation',null,null)? I cannot find documentation. Note: This is not PHP code but posting as PHP seems to make it easier to read.…

I am seeing the same challenge. As a note, each of these would return null: alert(item.getLineItemValue('locations', 'quantitybackordered', i)); alert(item.getLineItemValue('locations', 'dorkyfield', i)); This would return the internalid properly: alert(item.getLineItemValue('locations', 'internalid', i)); Are the…

Ok, having tons of fun out here. :-) I would like to filter the result set on the two "Make Inventory..." fields on the location table. If either field is False, then I would like to exclude that location. The join id concept is still a bit confusing to me. Anyone have any suggestions on what to try for <join id> below?:…

BeforeLoad scripts for pages that are displayed in the webstore. Is this the use case you are referring to? Yes, I am guessing the BeforeLoad script would be the technique to populate the values prior to displaying in the webstore. It seems like it would work but is the performance hit an issue? I have not been able to…

...set using a beforeSubmit SuiteScript upon each save of the item record... First, I have a silly question -- Assuming multiple locations is turned on, when an order is approved or fulfilled for an item, does the beforeSubmit for the item table fire? Second, I will need to create a beforeSubmit on the location records. If…

...But I thought the goal was to get the location state into an item custom field so it could be used int he item template? Evan, Yes, you are correct, the goal for this thread was to get the preferred location state into an item custom field. In the same script, I would like to set the preferred location based upon the…

Currently, there is a beforeSubmit user event which is applied to Inventory Part. This beforeSubmit determines the preferred location and whether the item should be listed in the web store. The business issue is that once a given warehouse runs out of stock, the location for the item needs to change immediately. The…

Mark, Were you able to figure out how to access Location.quantityonhand? If so, would you provide a hint on how you did it?

Trevor, Actually, we are just going through the process of porting our site to NetSuite. I do not know the exact details on where to place the div's. That said, I did see that in a soon to be here version, we will be able to define doctype. I will be on v2007 on Saturday morning so I will know more then. After we get a…

Will you be using the div's for placement? If so, then be aware that you cannot define the DocType, therefore the page will render in Quirks mode.

Long, Were you able to determine how to determine quantities for a specific location? QOH, qty on order, back order, etc.

There's a plugin which uses SIP directly (not Asterisk dependant) to handle dialing out using TAPI http://www.enum.at/index.php?id=479 Tim, Thanks for the information on siptapi.tsp! It works great for click2dial. The users phone rings almost immediately. Now if I can just figure out how to get eye-beam to call the…

Hi Carl, It is Bill. The range is 6 months. It could be a couple of users that would do it. It is mainly the user editing the invoice, going to the Accounting tab, then unchecking the Taxable box.

Agree with best practice but... The tax information is not a field in System Notes. It is a "impact" field which shows the G/L accounts impacted by the change.

@al3xicon it does help; to be more descriptive is when the following occurs: 1) widget A is preferred vendor 1 2) widget B is preferred vendor 2 The buyer decided both should go through vendor 2; the best solution found is to edit the SO form to display the preferred vendor and rate.

fjannelle that is a great idea!

@Olivier Gagnon NC Thanks for the tip, that is a good one! I don't think there is a "native" way of doing it.

Olivier Gagnon NC & carl.billings thank you for your replies. Yes - it appears there is no way to limit. We are trying to build saved searches that combine outstanding A/R with activity management. Thank you again.

Thank you all for your input, We need the separate customer records for territory alignment. Sounds like import / export is the way to do it when there are many customer records.

Wow, this has turned out to be more difficult that I thought. Here is the business case: 1) We make a deposit of $1,000 to vendor A 2) Vendor A ships / invoices $250 3) We apply the deposit against the invoices from #2 above 4) We then run a report or saved search to give to vendor A so they can apply the credit to match…