Tapendra Singh · Full-Stack Wizard · Silver Medal

@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…

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…

Hi @User_APXUW I would not call any single formula universally correct. Two common interpretations: Sellable from stock you physically have now: ATS = On Hand − Committed (open SO) Here open POs are not included, since that stock has not arrived yet. This matches NetSuite's native Available field. Promisable including…

Hi @Keat Yee, Both are achievable, but neither is fully native, both need a User Event script on the Item Receipt. 1. Duplicate DO Number Use a beforeSubmit script that queries existing Item Receipts for the same DO number and throws an error if a match is found, blocking the save. A saved search alone cannot stop the…

Hi @Elina Kourouzidou, Sourcing will not work for this, because the Requisition to PO link is not stored in a sourceable field on the PO. When you create a PO from a Requisition, the relationship is kept in NetSuite's internal transaction link table (nexttransactionlink), which is what drives the Related Records subtab. To…

Thanks for sharing @Jeanne Padilla-Oracle.

Thanks for sharing @Francesca Nicole Mendoza-Oracle.

Yes, you can handle that in the script. Instead of reading one fulfillment, search all Item Fulfillments linked to the originating Sales Order, then loop through them and collect serial numbers from each one's inventory detail, skipping any that have none. The logic: from the invoice line get the source Sales Order, search…

Hi @TheCrawford, The reason your template edits are not working is that the serial numbers do not actually exist on the invoice line. When the invoice is transformed from the Sales Order, the inventory detail (where serial numbers live) does not carry onto the invoice line, so ${item.inventorydetail} has nothing to render.…

Hi @Kevenale, The account depth (4000 > 4001 > 4004) is driven by the actual account parent-child structure, and the Financial Report Builder always renders every level in that chain. The layout editor controls sections and summary rows, but it cannot flatten the GL hierarchy, so there is no native way to show CEN >…

Hi @User_8LGY2, This is by design. The Match Bill to Receipt checkbox is an item-level field that only appears on item types received through an item receipt, like inventory items. You can see it on the Inventory Item record under Item/Cost Detail (next to Drop Ship and Special Order), but it does not exist on the Service…

Hi @Dext3r, Solid setup, Sam. The queue pattern where the UE just drops a lightweight record and the MR/SS does the real work is a good way to keep load off the UE and client side. Reusing the same model for the ecommerce integration makes sense to me. One thing if you have SuiteAnalytics Connect you could push some of the…

Hi @kees.netsuiteadmin As far as I know, there is no out-of-the-box way to achieve this. For what you need, a custom solution is the way to go. The approach would be a Suitelet based item search page that reads the current user's department from their employee record and filters the item results to only those relevant to…

Hi @User_APXUW, The native quantity fields (On Hand, Committed, Available, On Order) will not give you a true ATS, since Available is only On Hand minus Committed and does not factor in incoming POs or transaction dates. For future-dated supply and demand, NetSuite's Available to Promise (ATP) feature is the native route.…

Hi @User_IM2YY, This error comes from the Transaction Line Distribution SuiteApp (com.netsuite.vendorinvoicedistribution). On save, the fetchSubsidiaryDetails method runs a SuiteQL query that joins the Subsidiary, Customer, and Vendor tables to build intercompany details. This path triggers when the Intercompany feature is…

Very useful write-up @Jeanne Padilla-Oracle. The callout on period locking being driven by subsidiary time zone is an easy one to overlook, especially for distributed teams. Thanks for sharing.