Setting up Workato sync to connect BigQuery and NetSuite

1. Prerequisites Before you start, ensure you have: ✅ Workato Account with access to Google BigQuery and NetSuite connectors. ✅ Google BigQuery Project with service account credentials (.json file). ✅ NetSuite Integration Role with Web Services and REST API permissions. 2. Connect Workato to BigQuery Go to: Apps in Workato. Click New Connection and select… Continue reading Setting up Workato sync to connect BigQuery and NetSuite

To set up multiple prices on item records:

To set up multiple prices on item records: Go to Lists > Accounting > Items. Click Edit next to the item. Click the Sales/Pricing subtab. Enter up to four prices in the Base Price, Alternate Price 1, Alternate Price 2, Alternate Price 3 and Online Price fields. Click Save.

Creating Price Levels

To enable multiple pricing: Go to Setup > Company > Setup Tasks > Enable Features.. Click the Transactions subtab. Check the Multiple Prices box. Click Save. To create a new price level: Go to Setup > Accounting > Setup Tasks > Accounting Lists > New. Click Price Level. On the Price Level page, enter a name in the Price Level field. This name should describe… Continue reading Creating Price Levels

To assign a foreign currency price to a sales item with Multiple Prices enabled:

To assign a foreign currency price to a sales item with Multiple Prices enabled: Go to Lists > Accounting > Items. On the Items list, click Edit next to the item for which you want to create foreign currency prices. Click the Pricing subtab. Click the currency subtab for which you want to set prices. Enter a price, in the… Continue reading To assign a foreign currency price to a sales item with Multiple Prices enabled:

To assign a foreign currency price to a sales item with Multiple Prices turned off:

To assign a foreign currency price to a sales item with Multiple Prices turned off: Go to Lists > Accounting > Items. On the Items list, click Edit next to the item you want to create a foreign currency price for. On the item’s record, click the Sales/Pricing subtab. Enter the price, denominated in the foreign currency, as an Alternate Price.… Continue reading To assign a foreign currency price to a sales item with Multiple Prices turned off:

How to import translation values for record names and field help added in NetSuite to an SDF

We cannot directly import translation for record names, labels, and field help added in NetSuite to an SDF. However there is a workaround, if you want to do the same. Follow these steps: 1. Create a Translation Collection in NetSuite. Refer to the article for the same jjknowledgebase.com/post/80301 2. Add the text and corresponding translations… Continue reading How to import translation values for record names and field help added in NetSuite to an SDF

How to import a NetSuite Translation collection string?

We can import a NetSuite Translation collection string by using the navigation: Customization > Translation > Manage Translations Under the ‘Strings’ subtab and ‘Import Jobs’ subtab, you can see the ‘Import Translation’ button. On clicking the button, you will get a pop-up where you can select the XLIFF file to be imported. On importing a… Continue reading How to import a NetSuite Translation collection string?

SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) – Tips

NetSuite provides SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) for external reporting and data analysis. Below are some key tips to ensure a smooth and efficient ODBC connection. Since SuiteAnalytics Connect runs on a read-only replicated database, optimizing queries is important. ✅ Use Saved Searches for Large Data Sets NetSuite’s ODBC database is not real-time. For large datasets, use… Continue reading SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) – Tips

How to export specific language translations from a NetSuite translation collection

We can export specific language translations from a NetSuite translation collection by using navigation Customization > Translation > Manage Translations Under the ‘Strings’ subtab, you can see the ‘Export Strings’ button. On clicking the button, you will get a pop-up where you can select the checkbox: ‘Include existing translations’ to choose the specific languages you… Continue reading How to export specific language translations from a NetSuite translation collection

Highlighting Transaction line fields based on the various conditions

To setup highlighting for certain line fields, use JQuery to change the background colour. For example, if (quantity > 10) {                 document.querySelector(`[data-label=’Quantity’]`).style.backgroundColor = “yellow”;             } else {                 document.querySelector(`[data-label=’Quantity’]`).style.backgroundColor = “white”;      … Continue reading Highlighting Transaction line fields based on the various conditions