The Analytics Warehouse enables businesses to analyze historical data from multiple sources and determine how to improve their business. When enabled, you can begin transferring your data to the Analytics Warehouse. You can then blend your NetSuite data with data from other sources, and analyze it with a wide set of visualizations. Feature to Enable… Continue reading NetSuite Analytics Warehouse
Author: Anila George
Unable to Unapply the payments in the Journal.
To edit the customer name in a journal in which a payment has already been applied, the journal should unapply from the payment record. But in some journals, unable to see any payment record. The associated payments could not be seen as another journal amount had been applied and the payment amount was zero. So… Continue reading Unable to Unapply the payments in the Journal.
Unable to Edit the Name field in the Journal
even if the accounting period is open, the Name filed at the line level is unable to be edited. The status of the journal is “Approved for Posting Payments Applied”. The reason why the user is not able to edit the Customer on the transaction line of the Journal is because it is applied to… Continue reading Unable to Edit the Name field in the Journal
Saved search formula to exclude not only the lines but the entire record.
Requirement – In the saved search, the purchase order records need to be excluded if any of its line items satisfies a condition. When adding the condition, only the item line is excluded from the search, not the record. Solution – The condition should be applied as the summary condition. CASE WHEN item.class =’labor’ THEN… Continue reading Saved search formula to exclude not only the lines but the entire record.
Cross Subsidiary Fulfillment for special work orders
With the cross-subsidiary fulfillment feature in NetSuite, it is possible to create a sales order in one subsidiary and fulfill it from another subsidiary. But in the case of special Purchase Orders and Work Orders, the functionality will not work. No automatic work order will be created for Special Work Order items when Sales Order… Continue reading Cross Subsidiary Fulfillment for special work orders
First Day in Weekly Timesheet
Issue – The first day of the week is changing from employee to employee. Solution – The first day of the week is based on the employee subsidiary. If the first day of the week is different in subsidiaries, it will also be reflected in the weekly timesheet form. The first day of the week… Continue reading First Day in Weekly Timesheet
Role Restriction on the Custom Fields
A restriction needs to be applied to a custom field based on roles. The custom field should only be visible to some higher-level roles. This can be done in the field setup itself. In the custom field setup, navigate to the ‘Access’ tab. Select ‘None’ in the ‘Default Access Level’ and ‘Default Level for Search/Reporting’… Continue reading Role Restriction on the Custom Fields
Unexpected error on importing Inbound Shipment
The user is importing Inbound Shipments via CSV Import. In the CSV response, some records were not successfully created and the error states: “An Unexpected Error has Occurred”. The user must ensure that each line on the CSV File match the lines on the Purchase Orders that will be used for the Inbound Shipment. The… Continue reading Unexpected error on importing Inbound Shipment
No access to release preview account
Even though requested the release preview account, can not access the RP account. Solution – One possible reason may be with the role permission. Initially, only users with an Administrator role have access to the Release Preview account. A user with the Administrator role can give Release Preview access to other users as needed for… Continue reading No access to release preview account
Unexpected error when using the ‘Age in Days’ function.
Issue – The ‘Age in Days’ function is used in the saved search with Formula(Date) and an unexpected error is shown when running the search. The Formula(Date) is used to calculate the expiry date age here. So, no need to use the Age function here as the difference between today and the expiry date is… Continue reading Unexpected error when using the ‘Age in Days’ function.