Disallow the creation of bill if reference already exists for a vendor through csv imports.

if (scriptContext.type == scriptContext.UserEventType.CREATE), then check whether it is a vendor bill. Get the values of vendor and reference number from the current record. Create search to get the count of reference number which is entered in the vendor bill. Return the count. var searchBillResultCount = vendorbillSearchObj.runPaged().count; return searchBillResultCount; If count is greater than zero,… Continue reading Disallow the creation of bill if reference already exists for a vendor through csv imports.

Built-ins for strings used in advanced pdf/html template.

Built-ins for strings used to split the data into fields in advanced pdf/html template. keep_afterRemoves the part of the string that is not after the first occurrence of the given substring. For example:TEMPLATE${“abcdefgh”?keep_after(“de”)}will printOUTPUTfgh keep_after_lastSame as keep_after, but keeps the part after the last occurrence of the parameter, rather than after the first. Example:TEMPLATE${“foo.bar.txt”?keep_after_last(“.”)}will printOUTPUTtxt… Continue reading Built-ins for strings used in advanced pdf/html template.

Permission for Administrator to open any close order.

We would like to take away ability from all roles except Administrator to re-open any closed order.Any Administrator should be able to open any close orders. -> Create the workflow1.Navigate to Customization > Workflow > Workflows > New.2.Set the following field values:a. Name:b. Record Type: Select Transactionc. Sub-Types: Select Sales Orderd. Execute as Admin: Enter… Continue reading Permission for Administrator to open any close order.

Restrict the Item Fulfillment creation if a custom checkbox is checked.

Restrict the Item Fulfillment creation if a custom checkbox is checked. No need to show Fulfill button in the Sales Order User Event Script is used.beforeLoad is entry point selected.1.First create a custom checkbox in NetSuite Customization > Lists, Records & Fields > Transaction Body Fields > new a. label: Hold Fulfillment b. type: Check… Continue reading Restrict the Item Fulfillment creation if a custom checkbox is checked.

Apply Journal Entry to an Open Bill as a Payment

User needs to apply a Journal Entry to an open Vendor Bill as a Payment SolutionCreate a Journal Entry 1.Navigate to Transactions > Financial > Make Journal Entries 2.Enter mandatory details 3.Click Lines tab a. Account: Select Accounts Payables -Debit: Enter Amount -Name: Select Vendor to ensure to link this Journal Entry to the Vendor… Continue reading Apply Journal Entry to an Open Bill as a Payment