NS Administration – Page 23

Configuring IP Address Validation in NetSuite

NetSuite provides a feature that allows you to assign multiple IP addresses to an employee record. During login, NetSuite verifies the employee’s current IP address against the addresses listed in their record. Access is granted only if there’s a match and the login credentials are correct. This feature can also be utilized to create access… Continue reading Configuring IP Address Validation in NetSuite

Export All User Notes

Scenario User would like to export all of the User Notes in their account. Solution Navigate to Lists > Search > Saved Searches > New Select User Note Click Preview Click the Export (Excel) Icon

Key Considerations for Migrating Transactions from Zoho Books to NetSuite

When migrating transactions such as card payments, fund transfers, and deposits from Zoho Books to NetSuite, follow these steps to ensure a smooth process: Export Transactions: Unlike bills, invoices, journals, credit memos, and vendor credits, you cannot fetch a list of transactions like card payments, fund transfers, and deposits directly from Zoho Books. Export the… Continue reading Key Considerations for Migrating Transactions from Zoho Books to NetSuite

‘Applied To’ and ‘Applying Transaction’ Types based on Transaction Type in Search

Scenario User wants to know all possible types of transactions linked through Applied To and Applying Transaction join fields for Saved Search. Solution The table below outlines all possible types of transactions linked through Applied To and Applying Transaction join fields. This is useful when creating transaction saved searches, so users are guided what correct join field to use based on the… Continue reading ‘Applied To’ and ‘Applying Transaction’ Types based on Transaction Type in Search

Create Employee Report with Last Login Date

Scenario User need to generate Employee saved search to display an Employee Report with Last Login Date. Solution Navigate to Setup > Users/Roles > View Login Audit Trail Click Create Saved Search Search Title: Enter Title Example: Employee Last Login Date Search Click Results Field: Note: For every required field use the drop-down menu to select and once adjusted click Add if needed.… Continue reading Create Employee Report with Last Login Date

The amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record

Scenario User wanted to know why is the Amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search is different from the amount in the Balance fields on the Vendor Record, Solution The Balance column on the Vendor Saved Search extracts information from the Vendor Record > Subsidiaries tab > Balance (Base) field of the Primary Subsidiary. The Balance (Foreign Currency) column extracts information from the Vendor Record > Financial tab… Continue reading The amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record

Map Reduce script showing error:-THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY

SCENARIO: A map reduced script is being executed for a custom transaction and getting following error: “Advance Funding ID: 998065, Error: The account used by the transaction is not available on this subsidiary” {“type”:”error.SuiteScriptError”,”name”:”THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY”,”message”:”The account used by the transaction is not available on this subsidiary.”,”id”:””,”stack”:[“Errorn at suitescript/resources/javascript/record/recordImpl.js:156:24n at Object.submitFields (suitescript/resources/javascript/record/recordImpl.js:154:30)n at Object.reduce (/SuiteScripts/Jobin and Jismi… Continue reading Map Reduce script showing error:-THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY

Transaction Column not Auto populating value for a Role

SCENARIO: The value in Journal line column “class” is currently made auto populated from the Project record in relation with a custom segment called “project Code” via a script. But for a particular Role Accountant role this functionality is not working. While checking the Role permission it has been provided with Custom segment permission. Reason:… Continue reading Transaction Column not Auto populating value for a Role

Show Budget Amount in the Reports when using Custom Role

Scenario The User wants to show Budget Amount in the Reports when using Custom Role. Solution 1. Using Controller Role, Navigate to Home > Set Preferences 2. Go to Analytics tab 3. Under Report by Period, select All Reports 4. Click Save

Permission to Edit Exchange Rate on Existing Transactions

Scenario The transaction date controls the exchange rate value in a transaction based on data found in Lists > Accounting > Currency Exchange Rates. For non-administrator roles, the Exchange Rate field is grayed out when user tries to create or modify a new transaction due to lack of permission. Solution To allow users to modify the value in the Exchange Rate field for non-base currency transactions,… Continue reading Permission to Edit Exchange Rate on Existing Transactions