After assigning a custom item field as either a Field Set or a Sort Field in Suite Commerce Advanced website we cannot edit particular custom field this is because to prevent the user from deleting a custom field which is already used in “Field Set or a Sort Field”. As a workaround, users will have to remove the custom field from being assigned as Field Set or Sort Field in Suite Commerce Advanced website follow below steps. 1. Navigate… Continue reading Know how to Edit Custom Fields assigned as “Field Sets or Sort Fields” in Suite Commerce Advanced.
Category: NetSuite ERP
NetSuite ERP
How to Set Up ACH Payments
To enable ACH payments on your Commerce site, you’ll need to complete two key steps: Set up a Payment Instrument for ACH Activate ACH Payment Options Step 1: Setting Up a Payment Instrument for ACH There are two ways to create a payment instrument: Through NetSuite’s Order Management feature Directly by the customer on your… Continue reading How to Set Up ACH Payments
Amounts Are Showing Either Negative or Positive on the Saved Search Results
Applies To Product: NetSuite 2020.2 Scenario When working on a Transaction Saved Search, users may sometimes see negative amounts. Solution For amounts to show as negative on a Saved Search results, the nature of the account impacted as well as the impact of the transaction being pulled up have to be considered. When the impact of… Continue reading Amounts Are Showing Either Negative or Positive on the Saved Search Results
NetSuite Ship Central
NetSuite Ship Central enables packing or shipping capabilities with shipping carrier integration within your NetSuite account. It also provides the app that lets you pack and ship orders through a tablet or kiosk device. Based on your fulfillment requirements and setup, you can pack or ship through the app or NetSuite UI. If you set… Continue reading NetSuite Ship Central
Invoice Linked to Journal Entry, But Payment Record Missing
User creates a customer payment record by applying an invoice and a journal. But after saving it, the payment record is not visible. This is because, when applying a journal entry to an invoice, a customer payment record is not created if the journal entry amount matches the invoice amount. In this case, the invoice… Continue reading Invoice Linked to Journal Entry, But Payment Record Missing
How to generate Single Invoice from Many Sales Orders
Natively, NetSuite does not allow you to bill multiple Sales Orders on one Invoice. There are a couple of options you could explore as alternative approaches: If you have SuiteBilling you can use Consolidated Billings. See Suite Answer 9204: Using Consolidated Billing for Projects and for Payments You could leverage Group Invoicing which might help facilitate… Continue reading How to generate Single Invoice from Many Sales Orders
Capturing Payment Event Reason in Cancel Sales Order Email
Requirement Include the Payment Event Reason (from the Billing tab) in the Cancel Sales Order email template. Since this field is inline and not directly mappable to the email template, a workaround is required. Solution Overview To surface the Payment Event Reason in the email template: Create a custom transaction field on the Sales Order… Continue reading Capturing Payment Event Reason in Cancel Sales Order Email
Allow Asset Value Editing – Fixed Asset Management Setup
In Fixed Asset Management, one of the key setup options is the “Allow Asset Value Editing” feature. The Allow Asset Value Editing option will give the Administrator and other Custom Roles the ability to modify fields in the Asset Record To enable this: Navigate to Fixed Assets > Setup > System Setup General Tab… Continue reading Allow Asset Value Editing – Fixed Asset Management Setup
E-Invoice Generation Enhancements for Overseas Customers
Summary This article explains enhancements made to the E-Invoice module in NetSuite to support overseas customers (i.e., those whose billing country is not India). These updates ensure appropriate field visibility, default values, and IRN payload compliance for export transactions. Enhancement Overview 1. E-Invoice Button Visibility Logic Condition: The E-Invoice Generation button is now visible if… Continue reading E-Invoice Generation Enhancements for Overseas Customers
DISPLAYING TIME ELAPSED IN DAYS AND HOURS
What to be done??? Normalize the values with TO_NUMBER and TO_NCHAR, then concatenate them using the following formula: CONCAT(CONCAT(‘Days: ‘,TO_NCHAR(FLOOR(TO_NUMBER(TO_NCHAR({timeelapsed}/24))))), CONCAT(‘ Hours: ‘,TO_NCHAR(MOD(TO_NUMBER(TO_NCHAR({timeelapsed})),24)))) What would be the output??? String