REQUIREMENT: Context: The client is using a Standard Cost for both the Assembly and Inventory (its components). The count of Assembly is around 1k, the count of Inventory (RM) is around 3k. Concern: I need to perform Inventory Adjustments to the newly imported Assembly and Inventory (RM); however, upon saving Inventory Adjustment transaction I get this error: “Inventory… Continue reading STANDARD COST IMPORT SETUP
Category: NetSuite ERP
NetSuite ERP
Separate GL Accounts for Invoice and Credit Memo on the Same Item
REQUIREMENT: Currently, NetSuite posts both Invoice and Credit Memo transactions to the same Income Account defined on the item record. However, this behavior does not align with the accounting requirements. We would like to configure NetSuite so that: Invoice postings using a specific item go to the regular Revenue account Credit Memo postings using the same item are posted to a separate Deduction Revenue account SOLUTION: current… Continue reading Separate GL Accounts for Invoice and Credit Memo on the Same Item
Troubleshoot Missing Columns in Saved Searches with HTML
Scenario: When a user with a custom role attempts to view or edit a Saved Search that includes HTML content, the following warning message appear Reason/ Solution: To evaluate HTML code within a saved search, you need to use a Formula(HTML) field. To ensure that Formula(HTML) fields are displayed correctly in saved searches, go to Setup… Continue reading Troubleshoot Missing Columns in Saved Searches with HTML
How to apply journal entry to bill
function transformBillToPayment(billId, journalId, incomeTaxAmount) { try { let payment = record.transform({ fromType: record.Type.VENDOR_BILL, fromId: billId, toType: record.Type.VENDOR_PAYMENT, isDynamic: true }); let applyLineCount = payment.getLineCount({ sublistId: ‘apply’ }); for (let i = 0; i < applyLineCount; i++) { payment.selectLine({ sublistId: ‘apply’, line: i }); payment.setCurrentSublistValue({ sublistId: ‘apply’, fieldId: ‘apply’, value: false }); payment.commitLine({ sublistId: ‘apply’ });… Continue reading How to apply journal entry to bill
Creation of Journal Entry for Bill
function createJournalEntry(bill, incomeTaxAmount) { try { let vendorId = bill.getValue(‘entity’); let apAccount = bill.getValue(‘account’); let subsidiary = bill.getValue(‘subsidiary’); let currency = bill.getValue(‘currency’); let trandate = bill.getValue(‘trandate’); if (!apAccount) { log.error(‘Missing A/P account on Vendor Bill’); return null; } let journal = record.create({ type: record.Type.JOURNAL_ENTRY, isDynamic: true }); journal.setValue({ fieldId: ‘subsidiary’, value: subsidiary }); journal.setValue({ fieldId:… Continue reading Creation of Journal Entry for Bill
How to Resolve Error “Your current role does not have permission to perform” in REST API
Issue We are getting below error in postman Get call with custom role for Sales Invoice https://xxxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice/ error :Your current role does not have permission to perform this action.”, There is no error with custom role if we give invoice number as below https://xxxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice/12632 No error if we run with Admin role I able to access invoice list using custom role in UI screen but… Continue reading How to Resolve Error “Your current role does not have permission to perform” in REST API
Create HTML Formulas in Search permission overview
Create HTML Formulas in Search permission overview By default, NetSuite saved searches output text only for viewing. Some customers need to include HTML formatting and controls in the saved search output. Including HTML in the output provides the ability to: reference other data on the internet, reformat the data, and include active content such as… Continue reading Create HTML Formulas in Search permission overview
Remove Standard Center Tabs for Roles
Some Standard Center Tabs can be removed for Custom and Standard Roles. If the “Set Up Custom Tab” link can be seen under Center Tab Overview, then this Tab can be removed for a Role. 1. Navigate to Setup > Users/Roles > Manage Roles. 2. Customize the Role and note the Center Type. 3. In Permissions tab > Setup subtab > set Custom Center… Continue reading Remove Standard Center Tabs for Roles
Understanding Facts, Subject Areas, Dimensions, and Attributes in NetSuite Analytics Warehouse (NSAW)
NetSuite Analytics Warehouse (NSAW) is a powerful cloud-based data platform that enables businesses to analyze NetSuite and external data with advanced visualization and reporting capabilities. At the core of NSAW’s data model are Facts, Subject Areas, Dimensions, and Attributes—key components that drive meaningful insights. Facts are numerical data or measurable business metrics such as… Continue reading Understanding Facts, Subject Areas, Dimensions, and Attributes in NetSuite Analytics Warehouse (NSAW)
Show Amount Due for Each Invoice on a Customer Statement Using Advanced PDF/HTML Template
Scenario The user needs to display the Amount Due for each Invoice on a Customer Statement printed with the Advanced PDF/HTML Template. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Custom Statement PDF/HTML Template: Click Edit Top right corner: Toggle Source Code Look for the line of code that contains class=”itemtable” Within the <thead> tag, insert the following code: <th align=”right”>Amount Due</th> Within… Continue reading Show Amount Due for Each Invoice on a Customer Statement Using Advanced PDF/HTML Template