Magi Thomas – Page 4 – knowledgebase JJ

Error: Unable to export the matrix item. because the linked matrix children items might not have one of the following required criteria details: – Variation Theme and Variation Options – eTail Channel, Shopify Store – eTail Shopify Item ID map

The error you’re encountering during the matrix item export in NetSuite, suggests that some of the matrix children items are missing required criteria for Shopify integration. Here’s what the missing details imply: Variation Theme and Variation Options: The matrix children must have a variation theme (e.g., size, color) and their respective variation options set properly… Continue reading Error: Unable to export the matrix item. because the linked matrix children items might not have one of the following required criteria details: – Variation Theme and Variation Options – eTail Channel, Shopify Store – eTail Shopify Item ID map

Error : All matrix children doesn’t contain same product_id.

The error “All matrix children doesn’t contain same product_id” in Celigo typically occurs when syncing a matrix item from NetSuite to Shopify. This happens because Shopify expects all variants (matrix children in NetSuite) of a matrix item to share the same product_id, whereas in NetSuite, each matrix child might be treated as a separate product.… Continue reading Error : All matrix children doesn’t contain same product_id.

Customer relationship surveys

Relationship surveys show you at a high level where your customer experience needs improving and where you are doing well in your business. They ask customers to rate you based on their overall experience rather than on a specific product or service. The most popular and well-known relationship survey is the NPS survey. Relationship NPS… Continue reading Customer relationship surveys

Sort by Results in a Saved Search

Open the Saved Search: Navigate to Reports > Saved Searches > All Saved Searches. Find and edit the search you want to modify or create a new one. Go to the Results Tab: Click on the Results tab in the saved search editor. Choose Fields for Sorting: Under the “Columns” section, select the fields you… Continue reading Sort by Results in a Saved Search

Automating Revenue Arrangements in NetSuite Using Advanced Revenue Management (ARM)

To automate the creation of revenue arrangements after a sales order in NetSuite, leveraging the Advanced Revenue Management (ARM) feature is essential. Here’s a step-by-step guide to help you set this up: 1. Enable Advanced Revenue Management (ARM): Go to Setup > Company > Enable Features. Under the Accounting tab, ensure that Advanced Revenue Management… Continue reading Automating Revenue Arrangements in NetSuite Using Advanced Revenue Management (ARM)

Create Time Sheet in NetSuite

let timesheetRecord = record.create({ type: record.Type.TIME_BILL, isDynamic: true }); timesheetRecord.setValue({ fieldId: ’employee’, value: empId }); imesheetRecord.setValue({ fieldId: ‘trandate’, value: formatteddatetime }); timesheetRecord.setValue({ fieldId: ‘customer’, value: taskDetails.companyName }); timesheetRecord.setValue({ fieldId: ‘casetaskevent’, value: taskDetails.internalId }); let timeHours = hours / 60; timesheetRecord.setValue({ fieldId: ‘hours’, value: timeHours }); timesheetRecord.setValue({ fieldId: ‘isbillable’, value: false }); timesheetRecord.setValue({ fieldId: ‘approvalstatus’, value:… Continue reading Create Time Sheet in NetSuite

Customize the size of the table in Bil payment voucher check PDF

To increase the size of the statement in your advanced PDF template, you can adjust the height, width, and potentially the font size within the <td> tag. Adjust the height and width: Increase the height and width values to make the table larger. Increase the font size: Use inline CSS within the <td> tag to… Continue reading Customize the size of the table in Bil payment voucher check PDF

saved search that concatenates the invoice number with the currency for each customer

1. Saved Search Setup: Type: Transaction 2. Criteria: Type: Invoice Customer/Internal ID: Add any specific customer filters if needed (optional). Main Line: Set this to False to include line-level data. Status: You can add this filter if you want to include/exclude specific statuses (e.g., open, paid). 3. Results: Customer: Field: Customer Summary Type: Group (if… Continue reading saved search that concatenates the invoice number with the currency for each customer

Merging Customers in NetSuite

Merging customers in NetSuite is a way to consolidate duplicate customer records. Here’s a step-by-step guide to merge two customer records: Navigate to Customer Records: Go to Lists > Relationships > Customers > All Customers. Find the Customer Records to Merge: Locate the two customer records you want to merge. You can use filters or… Continue reading Merging Customers in NetSuite

How to Set a Default Value for Project Preference ‘ Limit Time and Expenses to Resources ‘

/** *@NApiVersion 2.x *@NScriptType UserEventScript */ define([‘N/record’,’N/config’], function(record,config) {‌ function beforeLoad(scriptContext) {‌ var projectRec = scriptContext.newRecord ; projectRec.setValue(‘limittimetoassignees’, false); } function beforeSubmit(scriptContext) {‌ var projectRec = scriptContext.newRecord ; projectRec.setValue(‘limittimetoassignees’, false); } return {‌ beforeLoad: beforeLoad, beforeSubmit: beforeSubmit }; });