A purchase order is your authorization for a vendor to provide items, materials or services to your company. In NetSuite, you can create purchase orders for expenses as well as items. To receive expenses, you must be able to add expenses to purchase orders. To enable this preference, an administrator can go to Setup >… Continue reading Receiving Expenses. Item receipt for Expense
Author: Hormese Paul
How To Audit Changes to Enabled Features in NetSuite
Steps 1. Navigate to Reports > Saved Searches > All Saved Searches > New or Lists >> Search >> Saved Searches >> New 2. Choose the ‘System Note’ search type 3. Fill out your Criteria 4. Fill out your Result columns 5. Add Highlighting and Filters as desired 6. Set up Email Schedule as desired Important: For optimal… Continue reading How To Audit Changes to Enabled Features in NetSuite
How to Quickly Find the Particular Saved Search that Triggered an Email With a Custom Subject Line in NetSuite
Scenario In this example, an end user received an email alert with the email subject “Projects Created Last Month” and needs the alert updated. Now, you need to find the saved search in order to make the updates. The only information you have is the subject of the email they received and the contents of… Continue reading How to Quickly Find the Particular Saved Search that Triggered an Email With a Custom Subject Line in NetSuite
exchange rate fields in General Ledger and Balance Sheet reports
Added exchange rate fields in General Ledger and Balance Sheet reports. However, the decimal point is not displayed.Enhancement # 145845 – Exchange rates should not be rounded off to 2 decimal places when exposed on saved searches and reports. Enhancement # 372832 – Balance Sheet Detail Report > Exchange Rate Field > Change Decimal Places to Match with the… Continue reading exchange rate fields in General Ledger and Balance Sheet reports
Review Inventory Cost Accounting
The purpose of Review Inventory Cost Accounting is for users to check if there is an ongoing or deferred inventory costing calculation. This is more of a tracker only. Note that it is not recommended to close a period when there is a deferred or ongoing costing calculation because it will get stuck. The main reason behind… Continue reading Review Inventory Cost Accounting
Plus icon/ add new in multi select field.
We cannot do the same by the standard as it is a limitation for custom records of multi-select type. So we need to add a new formula HTML field of inline type with store value false and default value. Then use the formula below. <!DOCTYPE html> <html lang=”en”> <head> <meta charset=”UTF-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1.0″>… Continue reading Plus icon/ add new in multi select field.
Formula(HTML) progress bar
First test: On my first test, I’ve replicated your concern with simpler values: ‘<progress style=”accent-color:red;” value=”‘||55-5||’” max=”100″></progress>’ Results: Which is to be expected based on your concern. Second Test: I followed your advise wherein if I change the arithmethic symbol to * or /: ‘<progress style=”accent-color:red;” value=”‘||10*5||’” max=”100″></progress>’ Results: With this, it shows the correct progress bar as… Continue reading Formula(HTML) progress bar
Total Sales Orders per Day Using SuiteQL
In NetSuite, SuiteQL allows you to extract and manipulate data from your NetSuite account. It offers flexibility and efficiency in accessing data, enabling users to write complex queries to retrieve specific information. Here’s a sample SuiteQL query to calculate total sales per day: SELECT TranDate, COUNT(*) as Count, SUM(ForeignTotal) as Total FROM Transaction WHERE ( Type = ‘SalesOrd’ )… Continue reading Total Sales Orders per Day Using SuiteQL
India Localization SuiteTax Engine Enhancements.
India Localization SuiteTax Engine SuiteApp version 8.00.0 includes the following new features and enhancements: Support for Exchange Rate During TCS Calculation You can now calculate TCS on a transaction in which exchange rate applies. The SuiteApp updates the accumulated tax bucket values in the base currency of a subsidiary or company and calculates… Continue reading India Localization SuiteTax Engine Enhancements.
Gain/loss account change
This is possible by enabling a feature named Foreign Currency Variance Mapping. The Foreign Currency Variance Mapping feature enables you to create foreign currency variance posting rules that determine the accounts into which foreign currency variances are posted. If your NetSuite implementation has no variance posting rules, NetSuite posts the gains and losses from fluctuations… Continue reading Gain/loss account change