Tapendra Singh · Full-Stack Wizard · Bronze Trophy

Hi @Vernita, I have used Pro and Max both plan have allowed me to add multiple NetSuite MCP connection in Claude. I am not sure about teams plan.

B

Hi @User_WA9MO , I did some sandbox and demo account testing to see what’s driving this behavior. The Approve / Reject / Reject with Note buttons are controlled by the Advanced Approvals on Time Records preference under Setup > Accounting > Accounting Preferences > Time & Expenses. Reference Links: Approve…

False

If you need true A1 formulas that your users can read and edit, generate a real .xlsx (Open XML) instead of SpreadsheetML. Open XML stores formulas natively in A1. You can do this from SuiteScript using SheetJS. One gotcha: the stock SheetJS bundle does not return anything through define(), Wrap it so it returns the…

Hi @Ankit Rawat, As per my understanding in a CSV item import, NetSuite matches the Purchase Unit and Stock Unit on the unit's Plural Name, not its abbreviation. You are passing "Kg" (the abbreviation), which is why you get "Invalid purchaseunit reference key Kg." Use the plural name instead. In your Units Type record, the…

Here it is @Elina Kourouzidou, Please let me know if this works. /** @NApiVersion 2 .1 @NScriptType UserEventScript Deploy on: Requisition (transaction) record type. Test in a sandbox and adjust field label to your form as needed. */ define(['N/ui/serverWidget','N/log'],(serverWidget, log) => { const beforeLoad = (context)…

True

Hi @User_0C38A, This is down to the formula reference style. I used R1C1 notation in the ss:Formula attribute, not A1 and it worked. Switch your formulas to R1C1. So instead of =SUM(B3:B14), write =SUM(R3C2:R14C2), where R is the row and C is the column. I ran this through the same N/encode and N/file flow you described.…

Hi @Elina Kourouzidou , I was not able to find a way to update the Total Box fields through configuration on the Requisition form. However, I am able to manipulate their labels (and hide them) using a beforeLoad User Event script. Please find below a screenshot of what I achieved with the script. Let me know if you would…

Hi @Niks Blando-Oracle, You are right that it is a system limitation. To add some depth, the rule is enforced at the server/data layer, not just on the form. A requisition requires at least one fulfillable (orderable) line, and fulfillability comes from the item type. Description items are non-fulfillable by design, so an…

False

@Elina Kourouzidou There you go! /** @NApiVersion 2 .1 @NScriptType UserEventScript Test in a sandbox and adjust field placement to your form as needed. */ define(['N/ui/serverWidget', 'N/query', 'N/log'], (serverWidget, query, log) => { const beforeLoad = (context) => { if (context.type !== context.UserEventType.VIEW)…

B

Hi Sam (@Dext3r), Can you please try REGEXP_SUBSTR(custbody_bb1_mss_trackinglink, 'href="([^"]+)"', 1, 1, NULL, 1) AS tracking_url

Hi @User_QTAW4, As per my understanding we cannot move it.

Hi @Elina Kourouzidou, I looked for a configuration to enable the Messages sublist on the Requisition record but couldn't find one. So I tried a different approach that worked, I used a User Event script to populate an Inline HTML field, rendering the messages as a custom sublist under the Communication tab. Let me know if…

Hi Sam (@Dext3r), Can you please try this as accountinglinetype column can distinguishing these lines. SELECT tl.id AS lineId, tl.linesequencenumber, i.itemid, tl.quantity, tl.accountinglinetype, tl.quantity, tl.mainline, tl.taxline FROM itemfulfillment t JOIN transactionLine tl ON t.id = tl.transaction JOIN item i ON…

Hi Nilesh (@User_FJEEG), Here's a working Suitelet you can use as a starting template. It has a simple login screen, then renders a time entry form and creates a native Time Bill record on submit. A couple of notes: This is a proof of concept / template, adapt it to your account. The login is demo-only. The…

@JingShien PFA is scriptable. Please find attached script. Let me know if you need further help

Thanks for Sharing this @Ivy Lopez-Oracle

Hi @JingShien, Yes, you can hide that button using a custom beforeLoad User Event script on the Payment File Administration record. The button id is custpage_2663_recreate_file (the 2663 prefix is bundle/account-specific, confirm yours by inspecting the button). const beforeLoad = (scriptContext) => { if…

I would like to Nominate @Sakshi_Garg – A consistently active and engaged member who shows up reliably and puts real effort in, recently completing all the June SuiteMaster challenges. That steady participation and enthusiasm sets a great example and keeps the community energized.

Hi @User_NJJIH, Agreed with @Clarisa De Torres-Oracle, Memo is the correct field. The line-level text you enter on the invoice comes through as Memo in a saved search, so selecting Memo will give you what you are after. Attaching a screenshot for reference.

Hi Nilesh( @User_FJEEG), There are a couple of directions here depending on how much you want to build. You can still create an employee record for this person without giving them login access, which lets you capture time against them and bill or pay based on those hours. Time can be entered on their behalf by an internal…

Thanks for sharing this @Jeanne Padilla-Oracle.

Hi @Carrie DRSD To help figure this out, could you share a bit more: How are you entering the adjustment, through a CSV import or directly in the UI? What type of transaction is it (for example, a Journal Entry)? When the error appears, is there a Subsidiary field on the screen or in your file, and does it have a value?…

Thank you for the recognition.

A

Hi @TEN, This is likely coming from a Purchase Contract. On the Order Requisitions page, when you select a vendor, NetSuite checks for a qualifying Purchase Contract for that vendor and item. If one exists, it auto-populates the Purchase Contract field and overrides the order rate with the contract's base rate (the lowest…