Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

You need the "Setup → SuiteScript" permission.

Hey @User_FL4CK, Per SuiteCloud Supported Records, Customer Refund doesn't support CSV Imports. The "documented" alternatives import options are SuiteScript, SOAP Web Services, SuiteAnalytics Connect, and REST Web Services. Another option would be to use a Workflow, as it supports "Customer Refunds". I used Workflows in…

Hey @Jim Miller, I found that this article covers everything that needs to be done to ensure emails sent from NetSuite are delivered to intended recipients: Five Golden Rules for Outbound Email

Hey @User_PAU1A, The only NetSuite record/table that stores script logs is called "Server Script Log".

Hey @Valdi, That's correct, when that preference is checked, items that use Standard costing are not available to be transferred.

Hey @User_Y04XD, In some cases, hiding a line-level field from Invoice Lines also affects its functionality, where the values stop populating. If you want to ensure the values will still populate, you can "clear the field label" instead of "unchecking the checkbox to hide the field". That way, the field is hidden from the…

Hey @User_FNWKM, Yes, you need the Advanced Electronic Bank Payments License to use the payment templates for other countries.

I looked into this in a customer Sandbox and confirmed that NetSuite stamps the "-System-" as the "Set By" instead of the actual user who approved the transaction. We can retrieve the list of approvers for transactions approved via email, as those are logged under the "Email Approval Log" Custom Record. For Invoices…

Hey @AmitCohen, Only Customer Support can change the Foreign Currency Decimal Precision. Please open a Support Case and list the currencies for which they need to change the decimal precision.

Could you check the "System Information" for one of the approved invoices and share the screenshot? Do you see something like this? If yes, you should be able to create a Saved Search with the "System Note → Set By" = "Mine" filter, along with additional criteria on the related System Note field changes, to dynamically…

@Jet Zhang, You can get the "Account Credit" if you have the "Main Line" = "False" in the Criteria and "Account" in the Results to see the "Account Credit". If you need to see the "Account Debit", select "Account (Main)" in the results.

Hey @ABDUL HANNAN, You can build a Saved Search that accesses the line-level System Notes. For example, if that's an Invoice Saved Search, you have to have "Main Line = False" in the criteria to ensure the report is run on the transaction line-level. In the results, you have to use "Line System Notes" join to access the…

Hey @User_V05N1, What is the balance of the Cumulative Translation Adjustment (CTA)? Typically, NetSuite balances out the Multi-currency Consolidated Financials via CTA. Here are helpful articles on the topic: Cumulative Translation Adjustment (CTA) Overview Cumulative Translation Adjustment-Elimination (CTA-E)

Hey @User_S6FVQ, The SuiteSuccess Canned Dashboards rarely work, if ever, as they are built for very specific scenarios. If any of the "expected" settings aren't enabled or the "expected" transactions or fields are missing, they won't work. My recommendation is to build your own dashboards rather than spend time trying to…

Hey @Jet Zhang, When you are saying "Invoice Credit Amount," are you referring to the "Applied Payment"? If yes, you can use the "Paying Transaction" join to get those amounts. Note that you may need to use advanced formulas if multiple invoices are applied to multiple payments.

Hey @Craig_Verde, The Item Receipt is probably using the Daily Exchange Rate, matching the Transaction Date.

Hey @XimenaB, Yes, you can build a Saved Search showing that. Are you using a custom Approval Workflow or something else? Where is the Approver information stored in the approved Transaction? One way is to create a Saved Search that is based on the Approved Transaction System Notes to dynamically show all transactions to…

Hey @User_8LGY2, Are you using the Legacy/Classic Tax Engine? If yes, then you have to do the Tax Group updates manually.

Hey @User_WA9MO, NetSuite Employee Center doesn't support CSV imports. It should be possible to achieve that via customization, if absolutely needed.

Hey @User_6CNWR, NetSuite natively can't do that. You can build a customization to track that. For example, you can create a "Rental Details" custom record and a related script to track the required information on it. There are also 3rd party tools, such as NetScore and Proscope, that have NetSuite bundles that help with…

Hey @Febin Antony, This tool should help: https://netwrix.com/en/resources/freeware/flashlight-netsuite/ I only used their paid version, but the free version may be sufficient, too.

Hey @Red9, You need to build a script to achieve that. It won't be a complex customization, but you can't do it with native functionality or a workflow.

I see what you mean, and, in theory, the formula should have worked. At the same time, because you are referencing "WHEN [type] = …", NetSuite should scan all transaction types to find the right types. These roles likely don't have access to all transaction types, which is causing the issue. Can you check whether the…

Hey @Dext3r, Most likely, the users don't have access to the records where the Formula is applied. The "Run Unrestricted" can be confusing. It lifts some of the Role restrictions, but you should assign the right permissions to the related Custom Roles. Here is an extract from SAID 8474

You can update Vendor Addresses via CSV Import. Choose the "Update" option and map the Address fields you want to update. Test on one vendor first to ensure you are doing it correctly before doing it for the whole set.

Yes, that's correct, you should set the Final Conversion Period to Value Based. You may get to a point where you have $1 or $0.1 left on the balance, and you may need to do a Write Off to clear that.

Hey @User_HV6EH, I agree that NetSuite's Marketing Automation isn't as easy to use as dedicated Marketing Tools. If you use an external tool, I recommend building an integration to ensure NetSuite Contacts are up to date and that Marketing Campaign results are auto-tagged to the related NetSuite entity and transaction…

Hey @ABDUL HANNAN, Great questions and observations. NetSuite Analytics Workbook isn't a full-fledged BI Tool. It covers the basic BI capabilities and something that most ERPs don't have at all. The features you are requesting are standard in BI Tools such as Looker. They aren't available in NetSuite. I don't like the…

Hey @Ken Zhang-Oracle, Can you try opening it via the Admin Role and see if that works? If not, you may need to reinstall the SuiteApp as some of its files got corrupted after the original installation.

Hey @Prakruti Swain, Do you currently have the "Annual Depreciation, Monthly Posting" (or similar annual-based settings) in the Depreciation Method? When set to "Annual," NetSuite attempts to calculate the depreciation for the full year in advance and then divides it by 12. Since WDV is non-linear (the amount drops every…