To modify an existing journal entry: Go to Transactions > Financial > Make Journal Entries > List. If available, click Edit next to the journal entry you want to modify. The Edit link is not available for journals that already have been approved for posting or have been posted. On the Journal page, modify the account as needed. For information… Continue reading Modifying Journal Entries
Author: Sanket Pal
Void Transactions Using Reversing Journals Preference
Enable the Void Transactions Using Reversing Journals preference to permit the creation of journal entries that void transactions on days or periods different from the original transaction dates. To enable this preference, go to Setup > Accounting > Preferences > Accounting Preferences. On the General subtab in the General Ledger section, check the Void Transactions Using… Continue reading Void Transactions Using Reversing Journals Preference
Setting Up Customer Center Price Preferences
Set the display of current price in the Order Guide Entry popup window in the Customer Center role. To set up customer center price preferences: Go to Order Guide > Customer Center Price Settings > Customer Center Price Settings. The Customer Center Price Settings List page opens. Click Edit. The Customer Center Price Settings page opens.… Continue reading Setting Up Customer Center Price Preferences
Setting Up Item Records for Order Guides
On item records, you must set the following fields required to add the items to an order guide: Base Price – If absolute price is defined in the customer record, then that price is considered as the default current price. If absolute price is not defined, then NetSuite uses the base price from the item record… Continue reading Setting Up Item Records for Order Guides
Creating Order Guide Record Entries
Order guides reference the fields added by the Order Guides feature on item and customer records. You can add entries or values to the list in these fields: Item Group – An item group for order guides consists of items that customers order together. For example, you can create a group of items ordered by customers… Continue reading Creating Order Guide Record Entries
Enabling Project Features
To track projects with basic project records, you must enable the Projects feature. For more information on basic projects. To track projects with more advanced project records, you must enable both the Projects feature and the Project Management feature. To enable features: Go to Setup > Company > Setup Tasks > Enable Features. Check these boxes… Continue reading Enabling Project Features
Update Fields on Current Record using a Custom Module Script and a User Event Script
The following sample is a custom module client script named clientDemo.js. This script updates fields on the current record. After you upload the clientDemo.js script file to a NetSuite account, it can be called by other scripts. /** * @NApiVersion 2.1 */ define([‘N/currentRecord’], currentRecord => { return ({ test_set_getValue:… Continue reading Update Fields on Current Record using a Custom Module Script and a User Event Script
Create and Save a CSV File then Reload the File and Parse Its Contents
The following sample creates a CSV file, appends several lines of data, and saves the file. The script also loads the file and calculates the total of several values in the file. /** * @NApiVersion 2.x */ require([‘N/file’, ‘N/error’, ‘N/log’], function (file, error, log) { // This sample calculates the total for the… Continue reading Create and Save a CSV File then Reload the File and Parse Its Contents
Convert a Query to SuiteQL and Run It
The following sample creates a query for customer records, converts it to its SuiteQL representation, and runs it. /** * @NApiVersion 2.x */ require([‘N/query’], function(query) { var myCustomerQuery = query.create({ type: query.Type.CUSTOMER }); myCustomerQuery.columns = [ myCustomerQuery.createColumn({ … Continue reading Convert a Query to SuiteQL and Run It
How to generate automated journals when a vendor bill is created and approved
Upon creation of Bill/Bill credit records containing expense/item lines with specific tax codes, an automated journal entry needs to be generated for the notional tax amounts related to specific tax Codes. This entry will credit the purchases account and debit the expense account to the liability account. Additionally, we will need to incorporate a checkbox… Continue reading How to generate automated journals when a vendor bill is created and approved