Currently, when running an Income Statement Detail report it is currently not possible to set the report to accounting period per column since the Column footer in the report is not available: This is currently an enhancement under 199011 Reports>Financial>Balance Sheet Detail/Income Statement Detail – show Column filter at the footer of the report If users… Continue reading How to create an Income Statement Detail per period
Category: NS Administration
All articles / code related to Netsuite administration
Customize Income Statement to show department subtotals per hierarchy
Users can customize Income Statement report to have a subtotal per department group, here’s how: 1.) Navigate to Report > Financial > Income Statement 2.) Click Customize 3.) Go to Edit Columns 4.) Click on the Financial Sections (Account Sections) eg: Income, Cost of Sales, Expense etc. 5.) Set Then By to Department, then click Show Hierarchy By clicking the Show… Continue reading Customize Income Statement to show department subtotals per hierarchy
Purchase Order status with Partial amount Billed
I created a Purchase Order with only Expenses not Item. Selected the account and amount and saved it. Now I billed the Purchase Order with partial amount. For e.g. Purchase order is created with amount of 1000 and billed only 400. But the status for the Purchase Order shows as Fully Billed not Pending. Solution:… Continue reading Purchase Order status with Partial amount Billed
Unable to Select Warehouse Location After Selecting WMS
Scenario User has no option to choose or select a Warehouse Location after selecting WMS on SCM Mobile Application. The Location defaults to Location A. Solution 1. View the employee record 2. Edit the record 3. Remove Location A on the Location field on the main line 4. Click Save
Effects of Disabling WMS MAKE WH SITE on Location Record
As per field level help, user can enable the WMS MAKE WH SITE preference on the Location record to make it a Warehouse Site for WMS Lite. Once the location becomes a warehouse site, user can then use this location for processes allowed by WMS Lite. The processes that can be performed in WMS Lite… Continue reading Effects of Disabling WMS MAKE WH SITE on Location Record
How to Add Login Failure in Reminders Portlet
Adding a “Login Failure” in the Reminders Portlet can be highly beneficial for various industries, especially those dealing with sensitive information and user accounts. By incorporating login failure reminders in the portlet, industries can enhance security, improve user experience, and proactively manage potential unwanted logins. This demonstrates a proactive approach to user account management, fostering… Continue reading How to Add Login Failure in Reminders Portlet
Changing Inline HTML Field Color Based on Approval Status in NetSuite
Dynamic styling in NetSuite allows for a highly customizable and visually intuitive user interface, especially when using inline HTML fields. A common use case is visually distinguishing approval statuses within records by dynamically altering text color based on the status. We need to create an inline HTML field that: Displays the approval status text. Shows… Continue reading Changing Inline HTML Field Color Based on Approval Status in NetSuite
Records Catalog Joins Available for SuiteScript and Rest Query API
The Records Catalog is available for all users with the Records Catalog permission. To assign the Records Catalog permission, first select the role you want to allow access to the Records Catalog in Setup > Users/Roles > Manage Roles. On the role page, you can then add the permission to view the Records Catalog under… Continue reading Records Catalog Joins Available for SuiteScript and Rest Query API
Duplicate Detection Preferences
You can change how NetSuite searches for duplicates on the Duplicate Detection page. You can have NetSuite search for duplicates among customer, contact, partner, or vendor records and search for matching information in certain fields. To prevent you from merging records that are not duplicates, you can only merge records if they have the same… Continue reading Duplicate Detection Preferences
Unexpected error in downloading workflow xml
The error causing because any action or transition condition is referring to a null value. It will give on formula typo. Example, if we add a formula as like the below will cause the issue: a!=!=12 this is one of the reasons recently found and resolved by taking NetSuite support.