Users may occasionally encounter the following error when attempting to allocate resources to a project task: AT_LEAST_ONE_EMPLOYEE_ASSIGNED_TO_TASK_1_HAS_NO_WORKING_HOURS_BETWEEN_THE_START_DATE_2_AND_END_DATE_3 Understanding the Error This error typically indicates that at least one employee assigned to a project task does not have any working hours during the specified task period. In essence, NetSuite is unable to allocate the employee to… Continue reading Resource Allocation Errors Due to Work Calendar Mismatch
Author: Abhincy Thomas
Add Condition on Workflow to Include Amortization Journals
Scenario Workflow action is not executing for Amortization Journals. Solution Navigate to Customization > Workflow > Workflows Workflow: Click Edit Note: Edit your existing workflow. Upper Right Corner: Click the Pencil Icon Contexts: Select User Event Note: Hold Shift while selecting User Event to retain other selection. Click Save Click Workflow State State Pane: Actions: Click Pencil Icon Condition: Click Custom Formula Formula: Enter {isfromamortization} = ‘T’ Trigger On: Select After Record Submit Click Save SuiteAnswer ID: 84020
Important items to note about dynamic lookups in Celigo
A destination value is being mapped to a destination value. The difference is the destination value found is usually from a different destination API than where it’s being mapped. The dynamic lookup settings window is where references to the source can be added for filters/searches. The source field on a mapping row isn’t used in… Continue reading Important items to note about dynamic lookups in Celigo
Unexpected Errors Due to Invalid Time Format in NetSuite Timesheets
Overview When creating timesheets using SuiteScript, an issue has been observed where the hours are formatted as HH:MM, but NetSuite interprets these values incorrectly. This results in unexpected errors, particularly when handling cases where the minutes exceed 59. Understanding the Issue NetSuite expects time values in decimal format (e.g., 1.5 for 1 hour 30 minutes).… Continue reading Unexpected Errors Due to Invalid Time Format in NetSuite Timesheets
Configuring Inventory Details for Inventory Adjustments in SuiteScript
When configuring the inventory detail for inventory adjustment record, the serial/lot number needs to be set to the fieldId issueinventorynumber. function createInventoryAdjustment(itemReceiptDetails, rmaTranId, currentBin) { try { let inventoryAdjustmentRecord = record.create({ … Continue reading Configuring Inventory Details for Inventory Adjustments in SuiteScript
Restricting Access to Custom Fields
You can control who can access the information in custom fields, enabling you to maintain the security of your business information. The access you define determines how the field can be accessed both on the record as well as through search results and reports. Access to a field can be based on role, department, or… Continue reading Restricting Access to Custom Fields
Error During SSO Integration Testing from Azure
An error occurred when testing the SSO integration from Entra identity provider. The error was as follows: Only POST is allowed. This error occurred due to the missing of one parameter doing the configuration of the SSO in the identity provider. The missing parameter was the logout URL. This needs to be filled even though… Continue reading Error During SSO Integration Testing from Azure
Overview of Record Action and Macro API
NetSuite records offer two alternatives for executing native NetSuite logic: a user either clicks a UI button or runs a script that calls the API corresponding to the button. These script and UI alternatives both produce the same results. Macro and action APIs provide ease and flexibility for your scripting. These APIs are supported for… Continue reading Overview of Record Action and Macro API
3-Way Matching in Vendor Bill
This script sample outlines a 3-Way Matching in Vendor Bill to match the rate, amount, and quantity of the Purchase Order, Item Receipt and Vendor Bill. This workflow action script will be added as an action to an existing approval workflow for those bills created from a purchase order. /** * @NApiVersion 2.1 * @NScriptType… Continue reading 3-Way Matching in Vendor Bill
Restricting Line-Entry Custom Record Field Editing in Quote Form
The goal is to remove the plus symbol from the line-entry fields in the quote form for sales staff roles, ensuring that they cannot create or edit new records while still being able to view existing ones. Proposed Solutions 1. Update Permission Levels at the Role Level This approach involves adjusting the permission level for… Continue reading Restricting Line-Entry Custom Record Field Editing in Quote Form