I utilized this API in pageInit for removing the 1 line coming from the opportunity when generating the estimate and insert different items.

Quick Question/confirm with scripting: figured out The preferred statement is always used when you call nlapiPrintRecord(...). Currently there is no way to specify a particular statement form to use (presumably what you are referring to with formnumber). The only options you can configure are statement date…

How can you return to the outer array after counting the number of same invoices within an array? My script stopped after the first subset of a customer's invoices (ends at the for j loop) I have a SS of invoices, and there are multiple invoices per customer. Figured it out by initializing j=i - also see my other post for…

I worked around using Mass Update with script. Does anyone have a solution for updating transaction line items? Particularly Purchase Order line items? I just created 2 new column fields on Purchase Orders and they show the "Item Type" and the "Project/Job" (entitynumber). Right now on every transaction they are blank, but…

Thanks for the idea. In our case, we have to run the script on customer record, Email function is to be available for emailing "open" SOs or invoices as PDF attachments, and we have to know for which record its PDF is to be attached and similar for the next ... - I can see searchRecord is neeeded - What would be your logic…

Sounds like you need a saved search on a scheduled script. Hi Kevin and all gurus. Related to the saved search and scheduled script, How would you accomplish this: when more than 1 invoice, send the Customer Statement as PDF. When only 1 invoice, send the Invoice as PDF. ? Hope to receive more insights from you.

@khltquist: I ahven't started out to expand your script, but will it allow multiple attachments, for the purpose of sending multiple open invoices or multiple SOs to the customer per their request. We had the same thought, but it's either all or none in standard NS. The way around it is a user event script for invoices…

Did you figure out on this saved search? I have a similar saved search to run: My first_create_date = minimum(datecreated) within previous one year (past 12 months). Next_renewal_date = first_create_date+12months. On your q about monthly sales, I would group by month. When it comes to sum(amount net) since…

@bdougherty: With scripting, were you able to update the custom Column fields of posting transactions (cash sales, e.g.) of already closed accounting periods? How do get around the line # in setLineItemValue('item','field_id',1,nlapiGetContext...) on transactions that have more than 1 Item Line and each item can be be on…

I just found out we do not have the action button "Close" on the PO. When a PO/service has only 1 item, we'd like to just click on "Close" in View mode and that 'll close the entire PO. We don't want the closed PO still showing "Fully Billed" status. But this action button seems to disappear at some point or not in 2010.2,…

The trick I found is, just uncheck the box to not fulfill. That will remove that Item line from the TO. WE are having an experience with transfer orders in google chrome, but not explorer. I am hoping NS sees this and fixes! Here is the report I got from staff doing the transfer orders: when I go to a transfer order and I…

Can we also set the "Quantity" to be pre-assigned a negative sign (-) befor any qty entered, based on a body custom field value? I am challenging myself. This idea won't work as the std column field expects a numeric value... Hello Yes I found the group membership function and set this: function trans_lineInit() {…

Has anyone implemented Land as non-financial asset and how would you track land parcels (for lease) as Asset Items in NetSuite?

Has anyone worked with Land as non-financial asset and how would you track land parcels as Asset Items in NetSuite?

I was able to link SO report (from front end) to the PO report (from ODBC) to get a report displaying both SO# and associated PO# and therefore customer name and vendor name. However, not all Vendor Names appear on the SOs report/saved searches (even the Vendor : Legal name would not display all vendor name). These are the…

This is a very important task and alway a TOP of the list to DO when inplementing. From NetSuite's transferred knowledge and from experience, always remember: BALANCE in first.

The same situation we are currently having on our company's NetSuite app. NetSuite seems to make customer name as a default email recipient whenever we want to email-reply from within the related issue record. A lot of times we copy the correct email address from the CC: and paste into the Email Address box, but can't get…

Will you be able to help me with customizing the sales order record to have different approval process (auto-approved and fulfilled) for different item? Thanks in advance.

Can we change the maxlength of a system field, e.g. "Ref. No." (tranid) Currently this field can not contain more than the maximum number ( 45 ) of characters. Thanks.

There is a built-in sublist under Sales > Items sub-tab on customer record. you can go from there.

With the similar idea, we want to track the %committed or fulfilled on the sales order, calculated from the Item level. The logic for tracking: when total of qtycommitted = total of qty, %commited=100%; when total qtycommitted < total qty, calculate the %commited. Questions: 1. With the custom body field (%committed) in…

Yes, it would be nice. I looked into this and realized the only way is to export the reports out in other formats and load them back in the folders. Any other ideas?

I built a custom report tab and created a number of report "categories" and then used a "link" portlet to show them, this works well for us. Cool, I'll try this out. Thanks for the idea.

I got the idea, with printing out both date and time on the Picking Ticket, as an added Element. Type: Date/Time. Dynamic Default: Current Date/Time. Yes, add a transaction body field Type : Time of Day Store Value: Unchecked And have that print on the transaction pdf form

With similar idea, can we also have the Time/Date printed out when the Picking Ticket is printed? If found it it the system note; but not available for sourcing to the custom field. We have done something very similar with a saved search on ones which to be printed = true, issue = none. Issue is an internal tickbox which…

I am reading your quotes as we are in the process of integrating PaceJet with NS... and delay the Go-Live.... PaceJet has "Freight Cost/Price" on its own tab. One issue we experience is the "Shipping Cost" not being updated on the Invoice Any ideas on how you would tackle this? Yes it is. The problem with NS solution only…

Thanks for the idea. With that in mind, I will end up having a Partially Fulfilled SO!? It's not what we wanted to achieve, but an option to consider. What you are trying to do is impossible. Netsuite will not allow you to fulfill from an order that is Pending Approval (or set an order to Pending Approval once it has been…

Hope you have figured it out. Our current system uses the same process you were looking into. This is achievable via: - How you define the items (non-inventory vs. inventory, use of Dummy vendor, fulfilled or to be fulfilled, or drop-shipped or not) - Form customization - note the vendor (column field) on the SO would…

Hope you have figured it out. Our current system uses the same process you were looking into. This is achievable via: - How you define the items (non-inventory vs. inventory, use of Dummy vendor, fulfilled or to be fulfilled, or dropped shipped) - Form customization - note the vendor (column field) on the SO would become…

If I want a script scheduled to batch-bill multiple services per vendor on daily basis, based on the custom saved search, what would be best to bill against: item fulfillments or POs (in Pending Bill status) ? I've read in the Developer's Guide that you can bill sales order's. How would that work for purchase orders?