Author: Mindu Paul

Make Custom Record a Child of a Transaction Record

There are cases wherein users need to make a Custom Record Type a child of a Transaction Record. In order to achieve this, a field with List/Record type must be created with the Record is Parent checkbox marked. Navigate to Customization > Lists, Records, & Fields > Record Types Custom Record Type: Click Edit Click… Continue reading Make Custom Record a Child of a Transaction Record

Initiating a Netting Transaction

Initiating a Netting Transaction The Balance Overview page provides a grid view of the open payable balances for subsidiaries. This page groups transactions by subsidiary-subsidiary-currency. Each subsidiary-subsidiary-currency group displays the following open balances: Balance due – Includes accounts payable and accounts receivable balances from all open posted transactions. Netting amounts – The Available for netting… Continue reading Initiating a Netting Transaction

Intercompany Netting

The Intercompany Framework feature includes the intercompany netting functionality. Intercompany netting enables you to settle mutual intercompany open balances across subsidiaries set up as represented customers and vendors. Intercompany netting automatically generates settlements, which reduces inaccuracies made through manually generated settlements. When you use intercompany netting throughout an accounting period, you reduce the number of… Continue reading Intercompany Netting

To upload zip file to the file cabinet

On your Computer, collect all your images and make sure to name them accordingly. Move it to one folder then Archive it Login as an Administrator Navigate to Documents > Files > File Cabinet Click Advance Add Zip Archived to Add: Select Zip file Destination Folder: Select Folder Destination Unzip Files: Enter Checkmark Click Add

Impact of Memorized transactions in reports and inventory counts

In NetSuite, memorized transactions are used to automate the creation of recurring transactions, but they do not generate any accounting impact or update inventory levels until they are actually processed. As a result, future memorized transactions will not appear in reports or show projections for future sales or inventory values. Only once the memorized transaction… Continue reading Impact of Memorized transactions in reports and inventory counts

CRM functionalities in NetSuite

NetSuite CRM (Customer Relationship Management) is a fully integrated CRM solution that helps organizations manage customer data, improve sales performance, streamline marketing campaigns, and enhance customer service operations. It provides a 360-degree view of customers and facilitates seamless communication and interaction across departments. Here’s an overview of the main CRM functionalities available in NetSuite: 1.… Continue reading CRM functionalities in NetSuite

How to exclude intercompany transactions in revenue reports

Navigate to Reports: Go to Reports > Financial > Income Statement. Customize the Report:  Click on the “Customize” button to create a new version of the Income Statement. Modify Filters: In the customization options, go to the Filters section and add conditions to exclude intercompany transactions. You might filter based on transaction types or specific… Continue reading How to exclude intercompany transactions in revenue reports

Update the address in the PDF template based on the selected subsidiary.

<td margin-top=”18px” font-size=”9pt” padding=”-0.2in 0in 0.2in 0.0in” class=”nameandaddress”>   <span>     <#if record.subsidiary == ‘Subsidiary1’>       4528 55 Ave NW, Edmonton AB T6B 3S2<br />       &nbsp;105-10711 74 ST SE Calgary AB T2C 5T2<br />       &nbsp;101-30923 Wheel Ave, Abbotsford BC V2T 6G7<br />       &nbsp;P: 888-435-6466 &nbsp;&nbsp; E: sales@expertec.ca     <#elseif record.subsidiary == “Subsidiary2”>       Company name<br />       &nbsp;3880 S Power Rd… Continue reading Update the address in the PDF template based on the selected subsidiary.

Automate Monthly Spend Report for Blanket Purchase Orders

We need to create an automated report in NetSuite that will be sent out on a monthly basis. This report should detail the spend against specific blanket Purchase Orders (POs). Navigate to Lists > Search > Saved Search > New Select the type as ‘Blanket PO’. Blanket Po is a custom record Under the criteria… Continue reading Automate Monthly Spend Report for Blanket Purchase Orders