NetSuite provides specialized country-specific layouts for each subsidiary’s financial statements.When you customize a financial statement, the most recently used subsidiary context for that report is selected for your custom report. The selected subsidiary context and its associated layout displayed on the Edit Layout page in the Financial Report Builder. To customize a OneWorld financial statement… Continue reading A financial statement using the correct subsidiary layout
Month: April 2022
Introduction to Postman
Postman is a standalone software testing API (Application Programming Interface) platform to build, test, design, modify, and document APIs. It is a simple Graphic User Interface for sending and viewing HTTP requests and responses. While using Postman, for testing purposes, one doesn’t need to write any HTTP client network code. Instead, we build test suites… Continue reading Introduction to Postman
Include a Link in the Email Template to View the Transaction Record
Navigate to Documents > Templates > Email Templates Email Templates: Click Edit Click Div</> or Source Text Editor: Enter <br> <a href=”${transaction.url}”>View Record</a> <br> Click Save
The Intersection and difference between two arrays
There are cases when we need to find common elements from two arrays; in such cases we can use the formula let intersection = arr1.filter(x => arr2.includes(x)); taking common elements from array 1 and array 2 If we want to take all elements from array 1 that are not in array2 then you can use… Continue reading The Intersection and difference between two arrays
A/R Aging/ A/P Aging Report Amount mismatch with Trial Balance Report
A/R Aging & A/P Aging Report Amount mismatch with Trial Balance Report
NetSuite Analytics Warehouse
With NetSuite Analytics Warehouse, you can broaden the analyses of your NetSuite data beyond what is currently available in SuiteAnalytics Workbook. 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… Continue reading NetSuite Analytics Warehouse
Link Inbound Shipment Search to Purchase Order
Create a Inbound search for getting Shipment number Criteria : No need to add anything in here . You can add as per your requirement Result : Shipment Number (Group) for removing Multi lines and Formula (Text) Available Filters : Need To add “Item:PO” field for mapping each shipment with its Purchase order Need to… Continue reading Link Inbound Shipment Search to Purchase Order
CREATE A CUSTOM FIELD THAT USES CALCULATED DATA FROM A SAVED SEARCH
Sample: Determine the total quantity of all items on a sales order Step 1: Create Saved Transaction Search For our Results, we only need to include the field that we are calculating on. In this example, it’s the Quantity field. Once we choose the field, we will use SUM as our Summary Type. Set a… Continue reading CREATE A CUSTOM FIELD THAT USES CALCULATED DATA FROM A SAVED SEARCH
How to set up an FTP connection in integrator.io
A File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of computer files from a server to an application on a computer. You can grab existing JSON, XML, CSV, and other files to upload them into a second application (Amazon Seller Central, Acumatica, etc.), or add files to the server from… Continue reading How to set up an FTP connection in integrator.io
Accounts Receivable (A/R) Aging Report
The Accounts Receivable (A/R) Aging Report shows you how much you’re owed (unpaid invoices, statement charges & Credit Memos) at any point in time by each of your customers. A/R Report includes the following sections: Customer. Transaction Type: Below mentioned transactions are Involved in ‘A/R Aging’ report … Continue reading Accounts Receivable (A/R) Aging Report