To open a file in a suitescript we can use file.load() function.e.g:var fileObj = file.load({id: ‘Images/myImageFile.jpg’});fileObj.description = ‘my test file’;var fileId = fileObj.save();The id field takes the path to the file like shown in the above example or internal of the exact file. See this example:var fileObj = file.load({id: 123});fileObj.description = ‘my test file’;var fileId… Continue reading Using relative path for file.load() function
Month: April 2022
Open invoice and csv import
An open invoice is a detailed document that shows the amount owed and the due date of the payment. Generally the invoice is sent by vendors to the accounting department or accounts payable department of the company that owes them. The invoice can also show if there is any past due amount from previous transactions… Continue reading Open invoice and csv import
Unapply Journal Entries Through CSV Import
A Journal Entry can be applied to a Bill or an Invoice. In the user interface, editing the journal entry that has an applied transaction will result to a message, “This journal is paying other transactions. Editing the journal will cause these payments to be unapplied. Are you sure you want to edit it? Click on… Continue reading Unapply Journal Entries Through CSV Import
Give Access to Employees via CSV Import
Need to give access to employees via CSV import. To give access to employees via CSV import, please follow the steps below: Create and save a CSV file with the following columns – Internal ID (of the Employee record) Role Password Confirm Password Require Password Change Give Access Update the Employee Record via CSV Import… Continue reading Give Access to Employees via CSV Import
The transaction currency does not match the currency of the name
Scenario: Saving a Journal Entry throws an error message: ‘The transaction currency does not match the currency of the name.’ Solution Edit the Vendor or Customer record and add the secondary currencies. Users will not be allowed to save the Journal Entry without adding the secondary currencies in the above scenario. Navigate to Transactions >… Continue reading The transaction currency does not match the currency of the name
Create a SuiteScript that will Refresh and Redownload the Page and Contents
Create a Client ScriptName: Refresh CacheID: customscript_refreshcacheRecalc Function: RefreshCacheScript File:function RefreshCache(){window.location.reload(true);} No need to deploy Client SuiteScript since this will be called by the button generated by the User Event Script Create a User Event ScriptName: Button CacheBefore Load Function: beforeLoadScriptScript File:function beforeLoadScript(type, form, request){form.setScript(‘customscript_refreshcache’); //reference the Client SuiteScriptform.addButton(‘custpage_clearthatcache’, ‘Refresh Cache’, ‘RefreshCache()’ ); //add button}… Continue reading Create a SuiteScript that will Refresh and Redownload the Page and Contents
Close Order Button is not available on the Sales Order
Close Order Button is not available on the Sales Order
Use Parent Customer Name Instead of Child Name in the Transaction Search
On a Transaction Saved Search, when a Customer is a Child or Sub customer the Name column will show as Parent Name: Child Name format. In order to use the Parent name only, use the following on Transaction Saved Search; Go to Results tab > Columns subtab Add Formula (Text) | Formula: CASE WHEN ({customer.parent} is Null) THEN {customer.entityid} ELSE {customer.parent} END Click OK Then Save & Run the search
Assigning new resources directly to Project Task
Usually if you want to add a resource to a project task, that resource should first added to project. Then only you can add them in to the project task. But you can add resources directly to a project task. For that the project record, which has the corresponding project task, there will be a… Continue reading Assigning new resources directly to Project Task
Dashboard and Portlets
DASHBOARDA dashboard is a summary of tabbed pages in your NetSuite user interface. This consists of a home page and pages according to your NetSuite role. Your dashboard data is dynamically displayed in portlets and provides direct accessinto raw data, KPIs, trend graphs, chart-based work-books, and reporting. You can create a unique dashboard set up… Continue reading Dashboard and Portlets