starlingMark Green Ribbon

@kees.netsuiteadmin Because the advanced pdf engine runs without file cabinet access (at least that was the case in 2017). You can try without marking the files "Available Without Login" but it may not work.

Hi Mohit, The reports are pretty opaque - it's near impossible to determine the exact data that is being pulled. I believed there is some extra "magic" baked into those with invisible logic. Searches are very easy to dissect using the plugin that mdeal001 mentioned. However, there is still some "magic" behind the scenes of…

Hi there, Unfortunately no, the Commission Schedules are not updatable by CSV or mass update. It isn't supported by suitescript either.

vkwanengage You can get around this with some grouping and case statements. Columns ID - Group Formula Text - case when Translation.Name_E is not null then Translation.Name_E end - Max Formula Text - case when Translation.Name_F is not null then Translation.Name_F end - Max Formula Text - case when…

I don't have anything "on the shelf" so to speak. But if this is something you'd like an assist with we'd be happy to help out.

You are most welcome!

Giles, Instead of manually calculating the amount of time the invoice was open, you can used "Days Open". That *should* allow you to use the criteria from my first post.

What field type are you using on the item record? Image, URL, etc.

Hi kbarua, I have just tried this with a Contact search. When i set any available filters the columns are still shown in the results. I would open a case with support.

CF_Pro, That is a sticky one. The external URL for files never contains the "raw" file name. I have a few thoughts on how to get around this, but let me ask you a question first. Is this something that the 3rd party will call very frequently (ie several times a day) or infrequently? Is the 3rd party going to cache/store…

Hi JJ, Try this: Criteria: Account = {your account number} Results: Document Number, Account, Amount If you only want one line per transaction, group the document number and account and sum the amount. Hope this helps!

I'm not bringing you much good news today - very sorry about that. You can't join to the image, so that's out. What I would do (again, not ideal) is have a script that populates a hidden field to hold the URL of the image.

Another option would be to handle this with a Suitelet. You could allow the 3rd party to request an image by name (optionally with a directory) in a GET. Then the suitelet can search a given folder for a file with that name and return the contents of the file as a string. Alternatively, to leverage what you already have in…

I tried both - no dice.

I would open a ticket with NS support. Make sure to include the search id, search name, and the screenshot above. Server time of 34 seconds (and client time of the same) seems way longer than expected. In my experience, you should be able to load a search in edit mode (no matter how complex) in under 10 seconds.

Hey bsullivan, I have experienced the reverse too many times to count, but not your situation. After the edit mode finally loads, double click on the NetSuite logo. Where is the issue - server side, network, or client side?

Hi Giles, There is no direct method to retrieve a field value as of a certain date. You can get there by searching the system notes, but not all fields are tracked in the system notes. You could likely do what you want by standard criteria of: And Summary Criteria of:

Nic, I have just tried using your RANK formula as you posted it here and it works properly for me. I'm thinking it has more to do with how your search results are setup. Can you screenshot the "Results" tab of the search configuration?

This field will probably not match directly against a customer/vendor. If this data is not present in the data you get from your bank you can always use a dummy. Per the help (https://system.na3.netsuite.com/app/help/helpcenter.nl?fid=section_1508962727.html) this field is just text, so you should be able to choose…

Hi 420Science, Your best bet here is to put in a small workflow or script that will blank out the check number field whenever you create a new Bill Payment. I don't believe there is any setting to default this to blank.

Hi Amy, I've had limited success in using "non-approved" BAI2 bank files in NetSuite. Sometimes they work and sometimes they don't. If you can't get your bank's native BAI2 file to go in I would recommend trying to export the data to CSV or Excel and use the CSV import template available from Transactions -> Bank -> Import…

JCaudle Happy to lend some advice here as we do this kind of work with our clients regularly. One caveat - this would be best done inside the scope of a larger conversation. The most overlooked part of any of these configuration tasks is the planning and full storyboarding of the actual work flow. With that out of the…

This post deleted because it had bad information.

AndyC These fields are added by a NetSuite script, hence why they always appear in the same spot. You can move them, but you'll need to build another one of your own scripts to do it. Yes, I agree, this is frustrating.

theboywonder Your first thought is a good one. Using an linline HTML field you can put the image inside an anchor tag and display it on the page. Inline HTML fields do not store their value, so you will probably need two fields. One text field to store the URL and another to dynamically build the anchor tag and place the…

JCaudle I've dropped you an email - looking forward to our chat.

Hi eleran , Base price can be a tricky field because it can vary based upon currency, if you use multiple quantity price levels, etc. Because of these challenges, it has been my experience that it is best to source this 'base price' by script.

theboywonder Our friend Allllan is correct! Inline html fields do work in edit mode (just not in sublists). As Allllan eluded to, you will probably need two fields to make this work. One field holds the URL for the image while the inline html field dynamically creates an anchor tag with the image URL inside of it.

eleran Yes, this could be done with a small script to simulate a "click" on that element.

Hi Scott and welcome to the forum. The data you are trying to pull is actually linked to a location, so pulling it directly on the item record will not work for you. In case you haven't seen it already, check out the NetSuite Records Browser. It details all of the available fields, subtabs, and sublists on all standard…