Tapendra Singh · Full-Stack Wizard · Gold Medal

Hi Sam(@Dext3r), What Type did you set on the P-Card payment method (Payment Card, Offline, etc.)? Is this your customers paying you by P-Card?

Hi @User_QTJUL Adding to @Trixie Amora-Oracle answer: You can use Enhanced Validations and Defaulting SuiteApp (SuiteAnswers 86556). Just make sure you hit both settings, or it won't actually block the save: Enable Negative Inventory Validation and check Work Order under supported transactions. Go to Setup > Company >…

Hi @Dext3r , There isn't a native SuiteApp for it, just the one on the Microsoft Marketplace. That app should be all you need to get it set up.

Hi @Elina Kourouzidou, This can be done using User Event script with afterSubmit function. Please find attached script and screenshots. Tested in a sandbox and it works, the Employee ends up as the original requestor rather than whoever clicked Create Purchase Order.

False

Hi @User_KCDN4 , The Location Type field is a native system field with a fixed drop-down (Warehouse, Store), so new values can't be added directly to it. As a workaround, I recommend creating a custom field (List/Record type) linked to a custom list. This will allow you to include all the location options you need, such as…

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

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…