3942122 Green Ribbon

One of the Netsuite guys suggested DAFT to us. Open Source Client tool. Just for info - Access Linked tables caused us issues by truncating text, and truncating the decimal places off of % values.

Arrggg. The CAD slid from parity to 1.3 in a matter of 3 weeks in September. Our products have 4-12 week lead times. This was not a pleasant surprise. Maybe its just me - should I have know to ask upfront about the multicurrency effect on the IRNB ledger, and whether the system was using the PO date (from months previous)…

We have had issues with bill credits being opened and resaved (on a day other than the initial transaction date). Even if you don't make ANY changes. The inventory values jump all over the place. We actually had to make a bunch of journal entries to fix our balance sheet as a result - it was filed as an issue (S2 - 60-90…

Besides creating a script to update all of the line items on unclassified transactions (which you could do on the server side), I've never seen a way to retroactively populate those fields from the item master - its a one way street.

Change the result "amount" field to Amount (Net of Tax).

Thanks for the note - I'll submit. The end result is a work around for credit limits. We need to enforce credit limits based on open orders PLUS open invoices. Most of our orders are custom industrial equipment, so we (as distribution arm) are "on the hook" for the stuff once we order it. It also takes 4-8 weeks to…

Just another note about credit limits, and master child relationships... If possible, the child limit should superceed the master credit limit, with the caveat that if you leave the child credit limit as <null>, the master credit limit will be used. We have several cases where the child pays the bills on thier own, and…

We are looking at scripting this ourselves or using Nolan business solutions. We (or they) create the upload file, which you then upload directly to your bank. One login process (the bank) to submit your biweekly file, but the transfers are direct from your bank.

Tks for responses. Not due to blank fields - (and yes, using legacy forms). Happens when they create the custom address and "override" (checkbox option). We have lots of equipment which needs inspection prior to ship, so to stop mistaken shipments, we set PO Ship address to "Call for shipping instructions". But its bottom…

This is a bit old - but I have been struggling with this also: Based on my experiments (support didn't seems able to help me here), it seems that if you choose "TEXT AREA" as the field type for a custom column transaction filed, and use a fomula - it will NOT print on the forms. If you use FREE FORM TEXT field, it WILL…

You would need to create a script to cycle through the line items and gather up the PO numbers from each line (adding to the list if you issued more than one PO). You'd then drop the info into a custom field on the SO which you can source to the invoices. You would have to look at server scrit to accomplish, as I assume…

You have to do it through script. We wanted to pull the phone, fax and contact person name into the address field on our estimates. Here's the code we use if you wanted to try to make it work. // This is to set the PREPARED FOR field if it has not been previously set. var shiptoA = nlapiGetFieldValue('shipaddress') // 1…

Mark, I haven't been able to decipher the recalc function. When does it fire?

We are doing something like this at present. We have a custom record in which we store info related to a number of "price groups". Desired margin, vendor, vendor multipler, shipping info, class (from before class was an item qualifier) etc... On the item, we have a dropdown that must be selected, assigning the item to a…

Well - color me silly. Tks!

We've been trying to do this also - we actually don't use the pricing - all our stuff is custom markup from cost - BUT - in order to have an item show on the website - it must have a base price set (who knew). So - just trying to set to 0.01 on ONE of the multicurrency price levels for items that get added. If we end up…

Interesting thread - we're fighting the filters today. Having a very hard time getting it to work. We are seeing the entire result set being returned, regardless of the filter, method etc we apply. :h_a_w: About to bail out to a saved search to make it work. Uggh. In my heart, I believe it works, but f'd if we can get…

We had this problem - I think we solved by setting closed to 'T' on each line - couldn't do at main level.

Yang, thanks for quick answer. sync call and insert helped , now trying to figure out how to get id of object to populate the collumn, but that's another question - and I try it by myself first :) thanks. Regards,

I'm trying to use nlapiCreateError() function on the server side script (beforeLoad function) but it seems to have no effect. Is there another function I can use to abort the script? I am trying to stop the user from going into the edit mode on a form.

Wow - Thanks for making this post! While its nice to know that I don't have to worry about backup etc..., I still can't go on vacation. Our company was shut down this morning, cause the error pop-ups were interfering with saving sales orders. We had to revert to non-scripted forms (which weren't activated) n order to get…

Scratch this - found out by the old reverse engineer format. If anyone is interested: nlapiGetLineItemValue('salesteam','isprimary',i); nlapiGetLineItemValue('salesteam','employee_display',i); B

I have had success running the searchRecord call from client suiteScript - I have been unsucessful when trying to use it to execute a specific saved search (more specifically when returning a sum formula field from the saved search). Have you been sucessful in this area?

Just got back to testing this. In Firefox - cache set to 100MB. All changes are lost on return to page, either using "go back" button, or back arrow in browser (assume they are both calling the same function). Is there another cache setting in Firefox I'm missing? In IE, the cache set at 100MB, and "check for new info on…

The record reverts to the last sucessfully saved version. Any changes that were made prior to the save attempt are lost. (It seems to reload the record from the database).

Hi Folks, Well, I came back to try and solve this problem, but I am just as stuck as before. I get an unexpected error thrown when I try to run nlobjSearchResult *on a summed saved search* from client side script. It will run fine when executed from the server side script. Any thoughts? Is there a speed issue with this…

Wasn't aware it was an option. In fact that makes the whole concept much more flexible and useful. I put the code into client script format and now throw a Netsuite javascript error when calling the saved seach for the open sales order total to apply to credit. Error: _funcname is not defined Source File:…

Here's the code/search: var columns = new Array(); columns[0] = new nlobjSearchColumn( 'formulacurrency' ); var searchresults = nlapiSearchRecord('transaction', 24, null, columns); for ( var i = 0; searchresults != null && i < searchresults.length; i++ ) { var searchresult = searchresults[ i ]; var result =…

Thanks, This solved the probelm. I removed the column ref all together - var searchresults = nlapiSearchRecord('transaction', 24, null, null); for ( var i = 0; searchresults != null && i < searchresults.length; i++ ) { var searchresult = searchresults[ i ]; var result = searchresult.getValue( 'formulacurrency',null,'sum');…

Doesn't seem like anything has changed. All issues indicated above are still in play. Workarounds? Should I be creating an issue, or is there development in the queue to sovle this?