Tapendra Singh Bronze Medal

Hi @Bee Yook , Do you have the Lot and Serial Number Trace (Bundle ID: 322956) bundle installed? If so, you can navigate to Reports → Lot/Serial Trace → Lot Trace to see exactly where that specific lot is being used. It is highly possible that the missing quantity is currently committed to another transaction.

Hi @User_JKLFU Those specific payment fields and tabs appear to be part of a custom bundle (likely installed by Bill.com) rather than native NetSuite. If they are custom, a good place to check is the custom entity field configuration under Customization → Lists, Records, & Fields → Entity Fields to see if a default value…

Hi @User_MZTGL ${item.quantityfulfilled!""} is working for me . I have attached the complete pdf template could you please try it.

Thanks for posting this, @Richard James Uri-Oracle.

Thanks for posting this, @Richard James Uri-Oracle.

Hi User_K51C7 Because NetSuite groups the Summary box into the core page structure, there isn't a native permission setting to hide it. The best workaround is to hide it visually using a CSS injection inside a User Event Script. You can deploy this User Event Script code on the Sales Order record or any other specific…

Thanks for posting this, @Ivy Lopez-Oracle . It’s one of those character limits that operations teams usually only discover after hitting an error on a massive item receipt.

Hi @User_ZPOBI , Native NetSuite permissions don't allow you to separate "Create" from "Edit" on customer records, as both require the Lists → Customers (Edit) permission level. The cleanest way to enforce this restriction is using a User Event Script on Before Load Function. The script can detect if the user is attempting…

Hi @User_88J4Q , You've run into a classic limitation with NetSuite Workflows. While you might be able to hack this with a complex sub-workflow using Workflow Action Script, this can actually be handled much more cleanly and reliably using a User Event Script . The script can quickly look up the parent, find the other…

Hi @User_IRGI3 We are using Vena and they have created couple of saved searches to export data from NetSuite and some time they have asked to add filters/columns to enhance the result.

Hi @Andrew B_ , The Employee Center role won't allow those specific OAuth/integration permissions, but you don't necessarily have to jump to a full-access license. If you are trying to connect NetSuite with tools like Claude or ChatGPT, we successfully achieved this by creating a Custom Center named Customer Success. It…

Hi @User_K51C7 , There is no native functionality for this out of the box, but it can absolutely be achieved using a couple of custom scripts. To give you an idea, I recently helped someone build this exact feature. We created a popup window, similar to the native Add Multiple button that allowed users to easily select…

@Angela Bayliss While LLMs are useful tools, I always recommend validating their output before putting it to use. Regarding the NetSuite Records Catalog (found under Setup → Records Catalog), it actually displays both standard and custom fields. Because NetSuite built this as a tenant-specific tool rather than a generic…

Thanks for the tag, @Clarisa De Torres-Oracle . Hi @Didik_Rohadi , short answer: not with the standard tools alone. The NetSuite MCP Standard Tools (com.netsuite.mcpstandardtools) only expose basic create, update, and query operations. An Item Receipt cannot be produced with a plain record create, because it has to be…

Hi @User_K51C7 A quick way to get all fields, standard and custom, for any record is to use SuiteQL: SELECT TOP 1 * FROM transaction Just use your record type. The column headers in the result give you the full field list including custom field IDs. Which record type are you working with, and is it standard or custom…

Hi @Audrey G. Yes, NetSuite hard-blocks this specifically for Invoices. The error code APPROVED_1_CANNOT_BE_SET_TO_PENDING_APPROVAL_OR_REJECTED_STATUS is thrown at the engine level and there is no native way around it - even SuiteScript hits the same wall. This is Invoice-specific though. Other transaction types like POs…

Hi @Kevenale The Next Check Number field is a native integer field in NetSuite, so it will always display with comma formatting (12,345,678) and strip any leading zeros. The stored value itself is correct (12345678) without commas. A quick question first, are you seeing the comma issue on the actual printed check, or is it…

Hi everyone! Happy to be part of this community. I am based in San Antonio, TX. I work as a NetSuite Techno-Functional Analyst managing NetSuite across multiple subsidiaries. I primarily work across ERP, OneWorld, Manufacturing, WMS, SuiteScript, SuiteQL and building custom application and integrations using technologies…

Hi @Jet Zhang The Fixed Asset Transfer and Disposal form is a Suitelet within the Fixed Assets SuiteApp and the underlying scripts and files are locked, so unfortunately custom fields cannot be added directly the way you would with a native NetSuite record. I would recommend reaching out to NetSuite Support to see if there…

Hi @User_UFWLI Thanks for sharing! Could you please share the execution log ? It would really help narrow things down since INVALID_REQ can mean different things depending on whether it is throwing in the input, map, or reduce stage. Also were there any recent changes to the script or deployment around June 8th? Thanks…

Thanks for the tag @Clarisa De Torres-Oracle Hello @Mary Rivas I have used Unapplied Customer Payments for this in the past and it worked well. Just create the Customer Payment records and leave the Apply sublist blank. The credit sits on the customer account, shows up in aging as a negative in the CURRENT bucket, and when…

Hi @Kevin60175 This is a known platform limitation. NetSuite's Legacy Tax engine does not support independent tax codes for shipping vs. handling. A couple of things worth checking: 1. Are you on SuiteTax?If yes, handling can be taxed separately from shipping natively. If you're still on Legacy Tax, migrating may be worth…

Hi @User_APXUW We ran into the same issue and found two ways to identify the offending item without opening every pick task. SuiteQL (fastest): Run this against your wave in the SuiteQL tab: SELECT pt.id AS pick_task_id, pt.name AS pick_task_number, BUILTIN.DF(pt.item) AS item_name, pt.quantity AS pick_task_qty,…

Hi @Kevenale I think you already have it. Is the below formula not working? (CASE WHEN {account.type} = 'Income' THEN {amount} ELSE 0 END) - (CASE WHEN {accounttype} IN ('Cost of Goods Sold', 'Expense', 'Other Expense') THEN {amount} ELSE 0 END)

Hi @Bee Yook Looking at the script execution log, the flow appears to be: Work Order Completion > Transfer Order (ID: 18630106) > Item Fulfillment (SrcLocation=537) > Item Receipt > JE Creation (Approval) The error is failing at afterSubmit_JE_Approvals which is the last step. This suggests something upstream in the Item…

B

Hi @User_R01AW The amortization schedule only gets created if the template is attached to an approved Bill. Once approved, you should see the schedule number populate on the expense line and clicking it will show all 12 periods with amounts. Amortization journals do not run automatically by default. You need to trigger…

Hi Scott (@User_F5QAS) We run into this frequently as well. For customers on Microsoft 365, emails from NetSuite's shared sending infrastructure can get silently quarantined by Microsoft Defender. No bounce or NDR is sent back, which is why NetSuite shows a successful send and you never hear anything. Worth asking those…

Hi @Kevenale A Transaction Saved Search might be right approach here. There is a NetSuite Answer ID 89639 that walks through building a GP saved search, but it will need a few adjustments for your use case: Transaction Types: Include all relevant types (Invoice, Credit Memo, Vendor Bill, Vendor Credit) not just Invoices…

Hi @User_S8PAJ Can you check how your integration is setting the shipping address? Specifically: Why is it setting the Override checkbox? Is it populating the structured address fields (addr1, city, state, zip) or just the free form addrtext field?