When working with the Transaction record in SuiteQL, some fields return internal values that are not easily understood at a glance. For example: The Status field may return a single-letter code. Fields like Entity, Employee, and LastModifiedBy return internal IDs. The Type field displays abbreviations like SalesOrd or PurchOrd. These internal values are meaningful to the system but not very useful to end users or admins reviewing query results. To… Continue reading Display Values from the Transaction Record Using SuiteQL BUILTIN.DF
Category: NetSuite ERP
NetSuite ERP
Controlling Page Numbers and Forcing Odd/Even Page Starts in NetSuite PDFs
In NetSuite’s Advanced PDF templates, you can control the starting page number and ensure that certain pages begin on either an odd or even page. 1. Default Page Numbering By default, the first page of a PDF is numbered 1. You can override this default using the pagenumber attribute in the <body> tag. Example: <body… Continue reading Controlling Page Numbers and Forcing Odd/Even Page Starts in NetSuite PDFs
How to Create a PDF with Different Page Sizes and Layouts in NetSuite
In NetSuite’s Advanced PDF/HTML templates, it is possible to generate a single PDF that contains pages with varying sizes and layouts. This can be achieved using either the <pbr> tag or the <pdfset> tag. 1. Using the <pbr> Tag The <pbr> (page break) tag allows you to break the page and specify different size or… Continue reading How to Create a PDF with Different Page Sizes and Layouts in NetSuite
How to print a different header/footer per page
There are two options available for this. Option -1 With the PBR tag, a user can force a page break to pass an attribute to a section within the document. MACROLIST tag is specified on the HEAD element. It contains MACRO elements, which are assigned an ID used to reference later in the document. With… Continue reading How to print a different header/footer per page
BAI2 statement format
BAI2, also called the “Bank Administration Institute Version 2”, is the upgraded version of the BAI file format. It was introduced by the “Bank Administration Institute”, based in the US, to facilitate previous day reporting of account balance information to clients and their agents, for activities that have occurred on a client’s accounts. The main… Continue reading BAI2 statement format
Unexpected error while creating wave
Scenario: When attempting to generate a wave using the Warehouse Manager Role, the user encounters an error message stating: “An unexpected error has occurred. Please click here to notify support and provide your contact information.” Solution: This error arises because the system restricts wave generation with the WMS Warehouse Manager role when the Sales Order… Continue reading Unexpected error while creating wave
How to Allocate a Slight Overpayment and Round Off in a Single Customer Payment Entry?
Requirement I have a customer invoice in NetSuite with an amount of 3,475.50, but the customer paid 3,476.00. I want to apply 3,475.50 to the invoice and allocate the extra 0.50 as a rounding adjustment, all within a single Customer Payment entry. However, I do not see any option for Write-off or Discount on the Customer Payment page. I am logged in as Administrator, so permissions shouldn’t be… Continue reading How to Allocate a Slight Overpayment and Round Off in a Single Customer Payment Entry?
Apply Before Sales Tax checkbox is missing from Discount Item
The Apply Before Sales Tax checkbox becomes available after the Advanced Taxes feature is enabled. This is done by: 1) Navigate to Setup > Company > Enable Features. 2) Under Accounting tab, mark the Advanced Taxes checkbox. 3) Click on Save.
Now You Can Talk to NetSuite: Unlock Your Data with N/LLM and Intelligent Querying!
Introduction to N/LLM N/LLM is a newly introduced NetSuite SuiteScript 2.1 module that brings native access to a Large Language Model (LLM) directly inside NetSuite. With it, you can: Generate text based on custom prompts. Create documents to provide context for more accurate responses. Control generation parameters (tokens, temperature, penalties). Track citations, linking AI responses… Continue reading Now You Can Talk to NetSuite: Unlock Your Data with N/LLM and Intelligent Querying!
Project Task Configuration and Work Tracking
Setting Up a Parent Task When creating a Project Task as a Parent Task, ensure the Planned Work field is set to 0 (zero). This configuration is required for the task to appear in the Parent Task dropdown menu. Understanding Work Tracking Fields The following fields are automatically populated by the system based on time… Continue reading Project Task Configuration and Work Tracking