Tapendra Singh · Full-Stack Wizard · Silver Medal

Hi @Vishnu M, I think Inventory Items is the right approach for your scenario. It supports FIFO costing, quantity tracking, and value tracking out of the box. On the other item types: Gift Certificates track outstanding liability not physical quantity or cost, and each line is limited to a quantity of 1 so bulk tracking is…

Hi @ACVP Yes, this is doable with a Client Script. Use fieldChanged on the taxdetails sublist: On taxcode change: load the salestaxitem record, grab custrecord_ste_taxcode_taxrate, strip the %, and set taxrate with ignoreFieldChange: true. On taxbasis change: calculate taxamount = taxbasis * (taxrate / 100) and set it with…

Hi @Kevin Hosea, It looks like a budget record already exists in NetSuite for the same dimension combination (Subsidiary + Year + Account + Department/Class/Location), not that your CSV has internal duplicates. Have you checked in NetSuite is you already have one of the budget you are trying to import?

Thanks for tagging me here @Francesca Nicole Mendoza-Oracle Hi @User_APXUW For requirements 1-3 (creation permissions, Submit for Approval button, Approve button), a standard Workflow handles these cleanly using role based permissions, Set Field Display Type to lock the Approval Status dropdown, and workflow driven buttons…

Hi @Wishal44 , This is a generic error message and cannot say anything specific. can you please Script Execution Logs and any active script or Workflow logs to find error details.

Hi @User_K51C7 For the Assembly Item, saved search formulas don't support subqueries, so you can't repeat the assembly item on every component row natively. Alternatives: SuiteQL, a Transaction Column Custom Field stamped via User Event script, or a two-column layout (one for assembly, one for components).

Hi @kees.netsuiteadmin No native "default order quantity" field exists on item records that auto-populates PO lines on manually created POs, based on my understanding. Your options: Memorized Transactions : create a PO with your standard items/quantities and memorize it. Works well if your order list is stable and vendor…

@User_TJ3OT Using the file and mapping below, I successfully created an Item Receipt. However, as @Shorin Rio Daa-Oracle mentioned , partial receiving does not seem possible right now. I tested various mapping combinations, but NetSuite automatically adds the second line item to the receipt even when it's excluded from the…

@Bee Yook It's difficult to pinpoint the exact issue without looking at the logs, but in my experience, an unhandled error in a library file or a separate User Event script can cause the main script to throw an "unexpected error." Have you tried removing the script and deployment ID filters, and just filtering by the date…

Thanks for sharing this @Robert Nedelkow-Oracle

Thanks for Sharing this @Michelle Jabanes-Oracle

Thanks for sharing this @Michelle Jabanes-Oracle

Hi @User_PCF01 , Looking at your workflow diagram, the Returned to Submitter state currently only transitions downward into the END state. The Add Button action only handles rendering the button on the screen. To make it execute an action and resubmit the record, you need to create a Transition that links back to your…

Hi @Glaced99991 Can you please share the exact error message you are receiving? Also, have you tried explicitly setting the iscrosssubtransaction field to false (or true depending on your workflow) in your initialization payload? When Cross-Subsidiary Fulfillment is active, NetSuite often expects that flag to explicitly…

Hi @User_TJ3OT, Did you try adding fields Item Receipt - Items : Order Line Item Receipt - Items : Receive

Hi @David_R, Please configure Inventory Adjustment - Adjustments : Location and you only configured Inventory Adjustment : Adjustment Location.

B

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…