Author: Nifi C Joy

Creating Employee Rates

We can create employee payroll rates in NetSuite by performing either of the following tasks: Importing an employee rate CSV file Manually creating an employee rate Importing an Employee Rates CSV File The following template and sample CSV files for importing employee rates are available in the File Cabinet of your NetSuite account: TemplateImportEmployeeRates.xlsx: SuiteBundles… Continue reading Creating Employee Rates

Saved Search to Generate a List of Item Receipts Created From Return Authorizations

Scenario User may need to create a Transaction Saved Search to display Item Receipts created from Return Authorizations. Solution Navigate to Lists > Search > Saved Searches > New Click Transaction Search Type Search Title: Enter Title Click Criteria tab Click Standard subtab Filter: Note: For every required field use the drop-down menu to select it and once adjusted click Set if needed. Select Type Type: Select any of Select Item Receipt Select Created From Fields…… Continue reading Saved Search to Generate a List of Item Receipts Created From Return Authorizations

Return Authorization Import

Return authorization records track information about items returned by customers. These records store data such as quantity and value of returned items, and return status. The return authorization record is updated at each point in the return process, including when the return is initiated, when the returned item is received, and when the refund is… Continue reading Return Authorization Import

Receive Return Authorization: An unexpected error occurred due to null value on Inventory detail column

Scenario An unexpected error occurred due to null value on Inventory detail column upon clicking the Receive button in the Return Authorization Solution Upon Receiving Return Authorizations created from Orders with an Item that use Bins but the Use Bins checkbox was unmarked on the Item Record after creating the Return Authorization.    This was due… Continue reading Receive Return Authorization: An unexpected error occurred due to null value on Inventory detail column

Create Transaction Saved Search for Sales Orders With Duplicate Purchase Order Number

User wants to create a Transaction Saved Search showing Sales Orders with duplicate Purchase Order number.     Solution Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title: Enter Title  Example: Sales Order Saved Search with Same PO# Click Criteria Click Standard Filter: Select Main Line Type: Select Yes Click Set Select Type Type: Select Sales Order Click Set Select PO/Check Number PO/Check Number: Select not empty Click Set Click Summary Filter: Summary Type: Select Count Field: Select Document Number… Continue reading Create Transaction Saved Search for Sales Orders With Duplicate Purchase Order Number

Resolve Error: “Department/Class/Location Are Mandatory Lines.” When Saving a Journal Entry that Uses a Custom Form

This notice happens when the following Accounting Preferences are enabled: Make Departments/Class/Locations Mandatory = True Always Allow Per-Line Classifications on Journals = True Allow Empty Classifications on Journals = False Also, in the Custom Journal Form, Department/Class/Location is not shown on the line level field. To resolve this, a user may follow these steps: Navigate… Continue reading Resolve Error: “Department/Class/Location Are Mandatory Lines.” When Saving a Journal Entry that Uses a Custom Form

Department/Class/Location Value is Unset When Journal Entry Lines are Edited

When user edits a Journal Entry that has Department/Class/Location populated at the line level, the field becomes empty when other values are changed. The field becomes empty because the original Department/Class/Location was set to Inactive. Set Department/Class/Location back to Active  Navigate to Setup > Company > Department/Class/Location Show Inactives : Mark Checkbox Unmark Inactive checkbox… Continue reading Department/Class/Location Value is Unset When Journal Entry Lines are Edited

Text Stretching Issues in PDF Template Table Cells

When generating PDF documents with table cells, developers may encounter an issue where text characters appear stretched across the available cell space. This formatting irregularity can affect the document’s professional appearance and readability. Solution The solution involves implementing proper HTML structure within the table cell by encapsulating the data within paragraph (<p>) tags. Here’s the… Continue reading Text Stretching Issues in PDF Template Table Cells