Tapendra Singh · Full-Stack Wizard · Gold Medal

C

Hi @jenluna, I added the Company Name (Customer/Project) field from Budget and Financial, and I can see both the Budget and Actual values in the same row. Could you please provide some additional details about the issue? If possible, please also share a screenshot so I can try to recreate the issue in my sandbox account.

User_JLBXV There you go I have updated the script to Set First name Last name and than Custom Employee ID Create the Script record Go to Customization > Scripting > Scripts > New. Select the javascript file(save the below code as javascript file on your local machine) and click Create Script Record. NetSuite reads the…

Hi @User_9V660, You can use the Mass Updates functionality to find multiple records, with outdated information and update all field values simultaneously of these records. let me know if you wanted to go to this route and will help you out if you have any issue.

Hi @User_JLBXV To achieve what you want there are multiple ways to do it like using workflow, User Event script, or client script. I did it using a client script, see the screenshot below. Let me know if that works for you and I'll share the script.

False

@Jayben Fung Currently, this is written as a standalone Suitelet script, but you can easily trigger it via a custom button click on any page. Unfortunately, this functionality isn't achievable using a standard Saved Search as per my best knowledge. Here is the Suitelet script: /** * @NApiVersion 2 .1 @NScriptType Suitelet…

Hi @User_OB3V0, Aside from current issue, there are two red flags with your partner's setup. First, NetSuite is actively phasing out SOAP Web Services, so building or maintaining an integration on SOAP instead of REST is not good. Second, targeting an outdated 2019.2 endpoint is a big liability since legacy WSDLs get…

Hi @Jayben Fung , I haven't tried modifying the Advanced PDF template. Instead, I created a lightweight Suitelet that replicates the print functionality and successfully consolidates the JEs. If you're looking for a similar solution, feel free to reply to this message, I’d be happy to share the boilerplate script with you!

Hi Nilesh(@User_FJEEG), To the best of my knowledge, the login audit trail only captures the IP address and does not provide additional device details.

Hi @Amjad Kasem , is there any reason you have not tried making an Advanced Intercompany Journal Entry?

FALSE

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