I think loading and submitting the record should work fine. Obviously this could be a lot of work for the script to do if you are doing that for every item on every PO all the time, but it should work if the script is correct. Make sure your custom item field it set to store values (a checkbox on the item record). Should…

You could script it to set the create PO field based on the value on your custom field. Upon creating and saving the new sales order, User Event - Before Submit script could cycle through the lines and set as necessary. Seems pretty reasonable if you are familiar with a little SuiteScript (though I haven't dealt with that…

After talking with support, we came up with a work around by making size of the body fields very,very small on the PDF layout so that it doesn't show up on the print. While this works, I now have to add the true body fields as custom elements. It still seems odd that the custom field cannot find it's source for the data…

Ok no problem, I don't mean to use the forum in place of Netsuite support. I started Case #1665147.

Thanks Eric. I've mostly been trying this with beforeLoad User Event and on Copy as you suggest, but with 1.0. Can I access the parameters in SS 1.0? (Actually I recently read your blog on why one should switch to 2.0, so I need to get on that....) For the workflow option....am I missing something because I don't know…

Looking through the help on this - the order in which you set the fields does matter in dynamic mode. So, maybe the payment amount is being set to the value you want but then when you load customer/order it is being overidden to SO amount? I'd try with the 'payment' field being set last. Just a thought, I am new to dynamic…

I can't speak to precisely what changed, but we had the same issue on a script that has been running for quite some time. Netsuite support came through and advised to use the following: nlapiCreateRecord('customerdeposit', {recordmode: 'dynamic'}); They must have changed the default record mode or something. This fixed it…

Thanks Neil. I am getting closer but having trouble with matching up the array of results being using in setLineItemValues with the field IDs that I am using to add fields. I don't know what that field id needs to be when using a Joined field. (for example, its a transaction search pulling details about items from the item…

Seems to work fine like this, thought maybe not as flexible if I change the search. Let me know you see easier way? (still need to add the filter in script, it's filtered by internal ID in the search criteria for testing for now) var callObj = form.addSubList('custpage_ordersummary', 'list', 'Order Summary','summary'); var…

OK so I was working from a sales order - in order to delete the fulfillment I had to re-load that fulfillment. Works fine now - we are creating a work around that resets the Pick Ticket Printed flag. I think a suitelet would have been more efficient than CS, but at least it works.

My saved search is a list of Sales Orders, and I would send the automatic email when a box is checked on the purchase order (with the SS being dynamically updated based on the items on that PO). Since no records in my search are being updated, not sure how it could work. Something may be possible though along those lines…

Hmmm, well one key feature of sending it direct from the UI is that the search results all have a link within the email to the transaction record in Netsuite (I think via the Date field). Sounds as if I may be re-inventing the wheel a little bit if I want to send it automatically in the same format as the 'Send Within…

I don't get an error on the script, it just doesn't change the value. var overrideName = nlapiGetLineItemValue('item','custcol_override',1); nlapiSetLineItemValue('item','vendorname', 1, overrideName); I was able change the value of a different column than 'vendorname' on the PO, so the Netsuite field is definitely…

Thanks for the help, if I specify the Internal ID as a filter it did work fine. I am now going to try this to get MTD and YTD sales to populate item records: Run a scheduled script that first calls a saved search to find all items with qty available change in the last week. Using those results, update each item by using…

I was able to use a For loop and print line item price, ext.price and a total on our pack slip - so this method works. Sean, I tend to agree with you that it would be better to avoid using a custom column field. I don't have enough experience to know if it would be more or less complex to go get the rate directly from the…

beforeSubmit worked just fine, I thought I had tried that but apparently not correctly! Thanks for your help. The reason I am moving the rate to a different column on the Sales Order is to use the rate on the item fulfillment -> packing slip. I feel like I could be making it too hard - is there an easy way to, at the time…

How does reqPOId get returned to the client script? From there, I would use nlapiResolveURL with the record argument after the Suitelet window is opened? Just looking for clarification, I am new to Suitelets and need to open a newly created transaction after it has been created in the Suitelet.

Found the answer in the 'Using JScript to ALERT on VIEW of inventory item' thread (post by Eileen, especially). Now we can alert user notes on a View of sales order, customer, etc. Seems like more of a work-around than a solution, but plenty good enough for us.

How might I add data from the page to this alert? For example, alert the text that is in the 'memo' field. I must be missing something - should I be able to access that through the script text being populated to the html variable? Thanks, Leo

Here is a basic part of a script that we use to add items to an SO: recId = nlapiGetRecordId(); record = nlapiLoadRecord('salesorder',recId); record.selectNewLineItem('item'); record.setCurrentLineItemValue('item', 'item', 7006, true, true); record.setCurrentLineItemValue('item', 'quantity',2, true, true);…

Interesting....should the standard cash sale form be available natively from a sales order? We don't use cash sales and do use advance shipping, so I am thinking that when you fulfill a sales order with a payment method set it goes to cash sale at that time? So cash sale parallels more with an invoice than sales order?…

What item type are you returning? And the RA is not created from a drop ship? If its a standard RA of an inventory item, that IR should have COGS and Inventory impact. The only other thing I can think of is that it would be date-related. Netsuite is maybe adding a COGS adjustment if there is an item fulfillment reducing…

Well this is interesting (relatively speaking). When I first click Apply on the customer deposit, it pulls up a deposit application and defaults to the correct A/R account but lists no invoices. If I then change that A/R account to something else, any other A/R account, and then change it back - it pulls in the open…

I would say we more or less evaluate our profit margin, make sure the avg cost is correct, make sure no inventory went negative, etc before we invoice in our legacy system. In Netsuite inventory shouldn't be able to go negative via a fulfillment and the inventory/inventory cost will changes will happen at the fulfillment…

Thanks Olivier. That is about what I expected. By run the card, I do mean charge the card. It is definitely counter-intuitive to have that $$ not hit Income right away. Unfortunately, that is how our legacy system is running currently. We are looking at going ahead and using a SO to Cash Sale method, then any correcting…

If you fulfill from the sales order, you might just create a workflow that takes away the 'Fulfill' button if the authorization is not present? I don't know if you'd call that native, but it should be a relatively simple customization. 

Does the page come out of the printer more or less instantaneously like a regular printer?

Certainly the Netsuite CSV import tool would be able to handle it. Pretty straightforward once your read the NS help documentation, then a little trial and error to get a few transactions of each type to import. As always, the hard part is getting good clean data out of quick books and into a format that matches to the…

If the purchase order has the option to 'Mark Shipped', then it is a drop ship. For a special order, it would have a button to Receive. Also, if you look at the related records from the sales order, in the row for the PO the link type column will say either drop ship or special order (which I see you have now seen as…

Thanks for the responses. I had thought of using an automatic journal entry, assuming that we could necessitate that the costs on PO and SO always match. We are pretty limited in the scripting arena right now, but will look into that option. Any reason this wouldn't be achievable through a workflow?