Author: Divya Unnikrishnan

Scenario: When a vendor prepayment deposit has been made but part or whole of the amount is unapplied on the invoice and will be refunded by the vendor, the balance in the Vendor Prepayment account needs to be reversed and the GL trail must be precise. Currently, Vendor prepayment can only be applied to open… Continue reading Reversing balance on vendor prepayment account on receipt of refund in case of unapplied and partially applied transactions

RANK AND DENSE_RANK – SuiteID: 31414 • Rank – Computes the rank of a value in a group of values. This can result in non-consecutive rankings if values are the same.• Dense_Rank – Computes the rank of a value with respect to other values and returns the rank as a NUMBER. It always results in… Continue reading BASIC SQL FUNCTIONS IN NETSUITE

When the currency column in the Workbook consists of multiple currencies, we may need to convert it to a single currency to maintain comparison and consolidation accuracy. We can use the currency conversion option directly in the workbook for the same. Note: This option is only available for amount columns in Workbook. It will not… Continue reading Currency conversion in Workbook

Scenario: A Purchase Order was created and a vendor prepayment transaction was made. Later, the vendor prepayment was no longer valid as neither the Item receipt nor the refund was possible. The period is closed and the purchase order is in closed status. The vendor prepayment transaction is in paid status. It can’t be voided… Continue reading Application of Bill to Vendor Prepayment transaction to nullify open balance

Navigate to Fixed Assets > Setup > System Setup. On the General tab, set your company preferences for the Fixed Assets Management system: Post to Next Open Period if AP is Locked – Check this box to enable posting to the next open period if AP is locked. Clear this box to enable posting to the… Continue reading Fixed Asset Management – General Preferences

Under the Permissions tab of User Role, we may provide the following permissions depending on the Role’s responsibilities:  Transaction Subtab:  Fixed Asset Depreciation Entry  Fixed Asset Disposal Entry  Fixed Asset Revaluation Entry  Fixed Asset Transfer Entry  Lists Subtab:  Fixed Assets Register  Custom Record subtab:  FAM Alternate Depreciation   FAM Alternate Methods   FAM Asset   FAM Asset Proposal  … Continue reading FAM-specific Permissions for User Roles

Scenario: To display main line criteria, body-level location, and line-level location in the transaction search result, we may use the following formulas Mainline condition formula : Formula(text) – Case When {mainline}=’*’ then ‘True’ else ‘False’ end Body level location: Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘True’ THEN {location}… Continue reading Display Main line criteria, Body-level location, and Line-level location in transaction saved search using Formula

In a Saved Search, the default Item rate field will display results in the base unit rather than in the transaction unit. For instance, in a Sales Order where the rate is 200 per KIT and the conversion rate for KIT is 20 UNITS, the default Item rate in search will display 10. The Item… Continue reading Item rate behavior in Saved Search with respect to multiple units of measure in transactions

 General Preference   Navigate to Setup -> Company -> Preferences -> General preferences  Ensure that the company logo location is set to the folder we are planning to upload the logo to. Generally, this would be the Images folder.  Click Save.  Upload the Logo image [Logo files must be in GIF or JPG format, and the… Continue reading Setting company logo in NetSuite

The Fixed Assets Management SuiteApp enables you to transfer simple and compound assets across asset types, subsidiaries, classes, departments, or locations.    You will not be able to transfer the Asset Type at the same time as the Subsidiary, Department, Class, or Location. The Subsidiary, Department, Class, Location, and Asset Type fields on the Asset Record… Continue reading FIXED ASSET MANAGEMENT – ASSET TRANSFER