OK, with the large volume of parts, documents and revisions, it may behoove you to invest in building a custom solution. We are a Netsuite consulting firm and can implement a solution if you're interested. Feel free to email me directly at blaine.cooper@availentsystems.com and we can chat more.

@"paula.courtemanche" , I don't have your email address, so sent you a friend request. Or feel free to reach me at blaine.cooper@availentsystems.com

would it be possible for the folks who generate these files to save as PDF before you attach to Netsuite? If not you could use a converter tool or print driver to print to pdf to convert these files to PDF, then attach in Netsuite. There are even browser extensions you can get to perform the conversion in your browser.…

It is ok to switch between source and WYSIWYG, just keep in mind that if you make changes on the WYSIWYG side, it could make changes to the source that break the template or other source changes that you've made directly in the source.

@"paula.courtemanche" One change you'll want to make is to terminate the pbr tag in itself rather than including "</pbr>" (last line of sample you provided). So go with: <pdf> your estimate content <pbr ... size="Letter"/> content for next page - your T&Cs </pdf> Another solution (if you have your T&Cs in a separate PDF…

@"KennyT" Yes this is possible. You would just need a client script that looks up and fills in the item field on the SO/PO once the user types in / selects the model number since the item record link is in the item field and is required when adding an item line. I am a Netsuite consultant and can help you with this if…

Hi @"Biomerics_Admin" What is the file type you want included with the BOM print? If it is a format that's readable as text (non-binary), it may be possible to automate converting it to PDF, so it will be printable with Netsuite's native print BOM functionality.

Regarding the statement "the item will almost always be used in production once it is created"; is the "production" another assembly item that your subsidiary stocks/accounts for? Or can you explain this further? We've done different setups with Contract Manufacturers, consigned inventory, etc., so I might be able to help…

Have you thought about creating a suitelet? You could do something like this in a suitelet. I'm a netsuite consultant and can help you with this if you need. Cheers Blaine Cooper availent systems blaine@availentsystems.com

I don't think there is a way to activate/configure this in netsuite natively, but I do have a suggestion. You could create a PO to each vendor and put the items you are monitoring on lines in that PO (note you don't have to issue the PO to the vendor(s) if it's just for tracking). You could then add a couple custom fields…

Have you thought about storing the "Points Awarded" on each transaction, then just showing the sum on the Customer record? when you merge the customer records, the transactions will be updated to reference the merged customer record and you would get an updated sum accordingly. The sum can be handled either by customizing…

If you are using a script on a before load event, form is available as a parameter and is an nlobjForm object. you can use .getTab and .getSubTab methods on this object. Have you tried that?

Not sure why your code isn't working, but you may want to consider another approach so that you don't have to touch code if you decide to add/remove a country from the process of 1 invoice per order. You can accomplish this by creating a custom record that maps country to the option (1 invoice per customer or 1 invoice per…

Hi Kristin Yes, a parameter on the script record holding the id of the saved search should work. Just set the default value of the parameter as the id of the saved search you are using. Cheers Blaine Cooper Availent systems blaine@availentsystems.com

So assuming you intend to group on the statusref column, something like: new nlobjSearchColumn('statusref', null, group), Don't forget that any other columns in a grouped search MUST define a summary/aggregate type. Note that group must be in single quotes, so the line should be: new nlobjSearchColumn('statusref', null,…

One possible solution is to create a custom record "Grower Contract" where you enter all the information around volume, rate, split, etc. Then when you are ready to receive the grain, have a function to create the POs based on the information entered on the Grower Contract record. You can then receive, enter the vendor…

Evan This can be accomplished with a fairly simple suitescript. I'm a Netsuite consultant and can help you with it if you want. Cheers Blaine Cooper availent systems blaine@availentsystems.com

kastnerd Creating a vendor for each price level will be very difficult to maintain over time. I'd be happy to discuss the details of how your vendor pricing works and help you come up with a solution. Cheers

Depending on how all these different type of discounts work, it could be as simple as adding Discount or non-inventory items for purchase on your PO; or as complex as adding a custom record for pricing schedules with scripting to perform calculations and business logic. I imagine you probably have both of these cases or…

OK, well in that case you may need to make journal entries. this can be automated with scripting based on your business rules. I'd be happy to dive into details with you to figure out the best solution.

For Challenge 1, you can create a custom record for the pricing schedules/discount calculations, then use scripting on the PO to determine the purchase price for the item. For Challenge 2, can you not date the vendor bill the same date as your invoice? Otherwise, you could use some scripting to make journal entries in this…

Hi Kelly If you try to update in the context of the case, Netsuite thinks you are selecting a different contact and that's why it's nulling out the email address. What you can do is go to the newly created contact record for that email address and update all the info there. You'll also want to move that contact from…

We found the Netsuite "case" caters toward the helpdesk and so we built a service management app with service ticket records, site visit reports, equipment records, follow-up tasks/phone calls, etc. If you're interested, let me know. We can dive into more details about your requirements and I can propose a solution for…

If you want the email to go out as soon as the customer record is saved, a workflow is probably the best way to go. You can do a sendEmail on after record submit, if new value doesn't equal old value for the particular field. With a workflow you can create whatever email content you want and show data in the email. I'm a…

You can create a custom field called "Latest SO" on your customer record of list/record type - Sales Order, and then create a script that updates this field everytime a SO is entered for that customer. With this field it will automatically provide a hyperlink to the SO record from the customer page or any customer saved…

There is a report called "Physical Inventory Worksheet" you can use to capture counts, then use inventory adjustments to get the right numbers in Netsuite. We are a Netsuite consultant, if you need any help with this or other functions in Netsuite. Thanks Blaine Cooper blaine@availentsystems.com

I agree, Malcolm, adding a custom field to enter the actual quantity would be a good solution. With a script you can default it to the quantity that was shipped/fulfilled, then if the user changes it to a lower number, do an inventory adjustment with a script. Would you ever expect the quantity to increase? (e.g. Potatoes'…

If you sell the projectors and use the CRM module, the normal process would be to receive the projector back in on an RMA. Then the item would show on the associated Repair Sales Order and you can get actual freight on the item fulfillment when you ship it back. Note: out-of-the-box Netsuite treats items returned on RMAs…

Andry I like the SO idea, but keep in mind these SO will show up on Sales reports (e.g. "Sales by Item"). And if you aggregate quantity sold and sum of sales price, you would get skewed results for average sale price. Do you want these items to show on Sales reports? If not you could accomplish this with some custom…

sorry ... contact info didn't show in previous post. You can email me at blaine.cooper@availentsystems.com.