A/R Aging & A/P Aging Report Amount mismatch with Trial Balance Report
Category: NS Implementation
All articles / code related to Netsuite implementation
CSV Import – Invalid Reference Key
The error occurs because in the Account internal id mapping, not choose the reference type as ” Internal ID”. To resolve this error; Click the pencil icon of the ” Account Internal ID ” and choose the reference key type as ‘ Internal ID ‘. Click Ok.
“Please Enter a Value(s) for: Tax Code”
This kind of error may come when intercompany transactions are performed. The standard Intercompany transaction process start with the creation of Purchase order. Using the option of Manage intercompany Sales order(Transaction>sales>Manage intercompany Sales order),Sales order is automatically creating in this flow. Here the error happens. solution: Kindly make the following changes in the setup 1.Go… Continue reading “Please Enter a Value(s) for: Tax Code”
Balancesheet monthwise-report customization
Balancesheet report shows the data for the ‘as of’ specification at the footer of the page.Client need the balance sheet data for specified period monthwise. Solution:We can customize the standard balance sheet report. 1.Alternative period range Type=Relative to report date 2.Check mark on cumulative value 3.Alternative period range=This fiscal year 4.Range segment=Accounting period Save.The report… Continue reading Balancesheet monthwise-report customization
Excel Row & Column Formatting Short cut Keys
To select the entire Row – Shift + Space To select the entire Column – Ctrl + Space To delete a column – Alt + H + D+ C To delete a row – Shift + Space, Ctrl + – T o hide a selected row – Ctrl + 9 To unhide a selected row… Continue reading Excel Row & Column Formatting Short cut Keys
Passing values to Script parameters via Suitescript
Script parameters are useful when there is a requirement to store data specific to a script but more accessible to all users other than developers. Using script parameterswe can avoid hardcoding certain values to the code that is required to be modified often. Also these values can be modified by anyone having access to the… Continue reading Passing values to Script parameters via Suitescript
Changing Names of General Ledger Accounts
You can change the name of an account by clicking its Edit link on the Chart of Accounts page. NetSuite automatically updates existing records when you change an account name. To change general ledger account names: Go to Lists > Accounting > Accounts. Click Edit next to the account to rename. Enter up to 31 characters in the Name field.… Continue reading Changing Names of General Ledger Accounts
CHALLENGES IN MASTER DATA IMPORTING
1. File size One of the most common CSV import errors is that the file is simply too large. That can be caused by too many fields or records in the file, too many columns, or too many rows. The import error can be caused by limits set by the program using the file or… Continue reading CHALLENGES IN MASTER DATA IMPORTING
Chart of Account Numbering
Many businesses use standard account numbers and the names of those accounts on their general ledger. You can set up account numbers that appear in your chart of accounts, transactions, and most financial reports. When you start to work with NetSuite, account numbers are not enabled. An administrator must enable the preference on the Accounting… Continue reading Chart of Account Numbering
MULTI – CURRENCIES
NetSuite Multi-currency allows for the assignment of more than one currency to a customer or vendor enabling you to do business with customers/vendors who use multiple currencies in their business. This feature enables you to enter transactions in multiple currencies for an individual customer or vendor. Set up > Company > Enable features > Under Company subtab… Continue reading MULTI – CURRENCIES