Hi, Need your help as I'm into making a Attendance Management System for a college POC and stuck in-between. Basically, I have created a Daily Attendance Form (through Suitelet) for marking Students as Present/Absent through checkboxes which gets saved on my Custom Record Type in Custom List. Here only I have created another checkbox for "On Leave" & I want to include leave status of students on the basis of their leave applications which students submit to their respective Professors. so I want that the 'On Leave' checkbox on my Daily Attendance form gets disabled for that particular date. Unable to find a way-out. Please suggest how to do on this current system OR shall I try any other option?

Hi All, I have a Suitelet form in Netsuite which shows monthly view of attendance of a college. I want to create a button this Suitelet form to get the attendance data as a .csv file to be downloaded & saved and also if required is to be emailed. How can I do it and How should i proceed? Please suggest!

Hello All, Getting file.file,file.file output while printing a pdf using suitelet in netsuite. May I know anyone having idea on this. Thanks in advance!!

How do I add a carriage return to a concatenated formula so each result is on a separate line?

Hello, Is there a way to remove this unreconciled balance (to make it 0 perhaps) from the reconciliation report?

#C5Y8YA27Q #C298P0BCK #C29J1BPM3 Has anyone successfully added a custom field to the ownership transfer record? If so how did you accomplish this?

Hi everyone, hope you’re doing awesome! (If this is not the right channel please point me to the right place) I was tasked with helping out connect to a 3rd party to share product details (basic info with stock and price) via a Scheduled Script, but I’m pretty new to Netsuite and I’m quite lost: • Can anyone point me to some basic examples on pulling product data? I’m able to do a basic

search.create({type: search.Type.INVENTORY_ITEM…})

but what if not all custom fields are part of that type? • Is there a way to visualize the whole DB schema or to find out all the custom fields that were created for this company? (I was not here when these were created). Currently the script is pulling 3 custom fields from _inventory_item_ but two of those are returning simply “1” and “2" instead of their actual value. Plus there are other fields that I cannot for the life of me figure out where I can get them from. I tried exploring by going to Setup > Records Catalog and I did find some of the stuff I need but I do not understand what the Join column really means. • Once I figure out how to get the remaining data, is there an easy way to join together the results if they’re not part of the same search? (sort of like when you do joins in a sql query?) Happy to share code or join a quick call if need be.

Hello everyone👍, good morning. I'm delighted to join this group; I'm new here. I would like to ask for help with the following issue: I have a workflow that triggers when creating a purchase order and sends an email with a template to the supplier of the order. I would like to send two different templates depending on the subsidiary of the purchase order, but I can't figure out how to add that condition in the workflow. I greatly appreciate your help. Greetings.🙌

Hi 👋 I want to add a field Category to my "New customer" form, but the field is in the subtab: "Relationships" then inside the form "Contacts", When I go to Customize Form, I can not find the "Contacts" form that is inside "Relationships"

Hi! I have a noob question)) I have stock items on two warehouses. And I create new custom search to use this as a widget. In this widget I want to see how many items store on my warehouses. But in this new custom search, all items store in one location (MidWest). Why all items location on this widget is MidWest?

i have a noob question as well. Any reason why I can't remove the following field on the form level? Its grayed out but randomly becomes available to uncheck and when I uncheck after I click save it automatically gets checked again.

Hello everyone! I am newer to NS... I would like to get certified. I've found a study guide but would be interested in some online or in person training. Of course going through Oracle is expensive, they dont sell individual LCS seats any more and they want to sell us a large company-wide pass. This is a no-go for us. Any thoughts on individual training paths?

Anyone have a collection of Links you send brand new NetSuite users to learn NetSuite?

I want to fetch PO, SO, InventoryItem from NetSuite and create ItemFulfillment, Receipt for multiple customers using my app. What should be the best way to go? REST, SOAP or any other?

Hi 👋 I want to make a custom field of type

List/Record

and I want the list to only show active customer. Can I somehow add a condition to not show all customer, or do I need to make a new custom list of active customer and use that?

Can we create saved search for customer payments received in last 4 weeks

Sorry if this is a VERY beginner question - is there a way for me to set a default list view for certain types of transactions independently of one another? I'd like a default list view for sales orders, a different list view for work orders, a different one for inventory adjustments, etc.

If I rename a saved search does it change the search's link/bookmark?

Hi all! Can anyone help me understand how to process shipments through UPS in NetSuite?

Hi, can anyone share some study materials or resources they used recently for the suite foundation exam? Thnks!

Hi there, How do you void any transaction using SuiteTalk Rest API? I didn’t find any dedicated

/void

endpoint. We have

transactions.void()

API for suitescript. Looking for something similar with Rest API. TIA

Is it possible to configure a customer saved search to filter for Sales Rep = Me only if the current user is a sales rep? Otherwise I would like the search to filter for "Sales Rep = All" by default. Sales Rep would be ideally be selectable in the filter region. I am trying to set up a search to email, but would like a certain recipient (who is not a sales rep) to receive results for all customers. Sales reps would receive search results for only their customers. I've got a formula numeric filter that gets me halfway, but not sure how to make it work with the filter region

case when {user.issalesrep} like 'F' then 1 when {user.issalesrep} like 'T' and {salesrep} like {user.entityid} then 1 else 0 end

#C298P0BCK #C29J1BPM3 #C29HKGM6J #C2A1ZEMF0 Is it possible to make a role that has access to see the Income Statment, Balance Sheet and Trial balance, but NOT allow the user to see any of the actual transactions? They just want to see all the financial statements, but not be able to view any specific transaction like not view an invoice, but still see all the Revenue in the I/S Is this possible?

Hello, I am a novice with NS Workflows and simply trying to create one for Work Orders. Upon completion with backflush of the first operation on a WO, I want the workflow to compare

orderquantity

to

completedquantity

and if

completedquantity

is greater, pop up a message. Seemed like it would be simple, but I'm not seeing these fields available as a condition. Any ideas?

👋 Hello, team!

Hi, I got this a while back. I dont know that we use any SOPA service. Is there any where i can see what SOAP services we have in NetSuite ?

Your NetSuite account has been identified as currently using one of the unsupported SOAP web services endpoint versions (versions 2017_2 to 2021_1). To ensure the continuity of your web service integrations, and efficient support, you must upgrade to a supported endpoint version as soon as possible.

Hi team, Have very urgent scenario. The customer Sales order name got renamed Because of the keyboard malfunction Can you please help me rename Thank you.

Join us today! We're excited to bring together some of the top NetSuite experts along with users like you from a wide range of industries across North America for today’s virtual user group! It’s a great opportunity to network, share ideas, and hear the latest updates and insights from the NetSuite community. 👉 Join us here — we look forward to seeing you there! https://21715241.hs-sites.com/netsuite-users-virtual-meetup-2

Morning All, I have a query regarding Saves Searches - how can a dynamic field be used in a saved search?

In the inventory adjustment section, there are inventory detail fields such as inventorydetailreq, inventorydetailavail, and inventorydetailset. When I click Inventory detail fields, it opens another page that contains related fields from another object. the related fields are bin and quantity. How should I find these fields?