Author: Vishnu Mohan

Supply Allocation prerequisites

Supply allocation in NetSuite is a process that enables businesses to prioritize the allocation of their available inventory or resources to meet the demand of their customers. This is a critical function for companies that have limited inventory or resources, or that operate in industries with high demand variability. By setting up supply allocation rules… Continue reading Supply Allocation prerequisites

Limitations of Suite tax

NetSuite SuiteTax is a software system that helps businesses comply with tax laws and regulations while simplifying tax processes. Nevertheless, similar to other software solutions, SuiteTax has certain Limitations. The following are a few examples. PRODUCT NAME ADDITIONAL INFORMATION NetSuite CRM No plans to support this NetSuite CRM+ No plans to support this NetSuite JCurve… Continue reading Limitations of Suite tax

Proposal for Subsidiary Hierarchy Updating

Please find enclosed the proposal that has been created for updating the subsidiary hierarchy in Netsuite. This proposal covers the Scope of changing the parent company of AURO Fruits and Nuts Pvt Ltd and for analysing the impacts of the change.

How to hide certain items While creating sales orders/ Purchase order/ Quote and so on.

Scenario: The user doesn’t want certain items to be hidden or doesn’t want to list the item whenever a sales order is being created Step1: Create a saved search Go to Reports and select Saved Searches, then choose All Saved Searches and click New. Select Item and click Criteria. Choose Standard and select Internal ID… Continue reading How to hide certain items While creating sales orders/ Purchase order/ Quote and so on.

Important points to consider before running Intercompany Elimination

points to consider while running intercompany elimination in NetSuite: Ensure that all intercompany transactions have been properly recorded and matched before running the elimination process. This includes making sure that all transactions are properly classified as intercompany and that the correct intercompany accounts have been used. Make sure that the elimination process is performed in… Continue reading Important points to consider before running Intercompany Elimination

Why 2 Intercompany elimination journal entries created for a single bill or Invoice

Scenario: The User gets 2 elimination journal entries for the same invoice or bill while running the intercompany elimination. Answer: In NetSuite, intercompany eliminations are typically performed in two stages: Intercompany matching, which matches intercompany transactions between subsidiaries. Intercompany elimination, which eliminates the matched intercompany transactions to avoid double-counting in consolidated financial statements. During the… Continue reading Why 2 Intercompany elimination journal entries created for a single bill or Invoice

Total Tax rates from invoices using saved search (Line total)

The Total tax rates from invoices or sales orders can be calculated using the formula: Total tax rate: ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 1’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype}… Continue reading Total Tax rates from invoices using saved search (Line total)