Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hey @User_5FWNK, Yes, it can be done with SuiteScript. The workflow alone won't be able to catch all transactions before they are voided.

Hey @User_SPBJT, One of the main reasons for the inconsistency is the Labor Cost update on the Employee record while the Project was "In progress". Some companies prefer to keep the "original/historical" cost intact for "in progress" projects. The updated Labor Cost will apply to new/future Projects. If required, you can…

Hey @User_V05N1, Yes, many edit types would unlink the transactions if the "original link" no longer applies. If only the "Memo" is updated, the link may still remain intact.

Hey @Tessa, Are you the owner of the Custom View? If so, the results won't be the same for you even if you run the report from the Custom Role. NetSuite grants elevated access to the report owner. You have to set someone else as the owner to see the correct results from the Custom Role. The issue with the "Amounts" might…

Hey @Tessa, It could be that the "GL Register" is run with incorrect filters (e.g., Period, Subsidiary, etc), which is why it doesn't show the reversals. Please double-check the filters and run again.

Hey @User_9MX5L, Yes, you can create a budget from WBS. Here are some additional details: Creating a Budget from a Work Breakdown Structure

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