A subtotal item can be inserted on any line of a transaction and will subtotal the items above it, up to the next subtotal line. This allows you some added flexibility when calculating discounts. If you want to calculate a discount on the entire transaction, you can enter a subtotal line and then enter a… Continue reading Subtotal Items
Author: Anila George
Items back ordered even if there is available quantity in SO location
In the sales order, the items went back-ordered even though there was an available quantity at the SO location. One of the possible reasons is that there is a location field at the line level and the user has only entered the location value at the header level. So NS will not consider any location… Continue reading Items back ordered even if there is available quantity in SO location
Email attachment types in transactions
Issue – when sending emails from transactions, the attachment sending as HTML doc rather than a PDF Solution: The email preference in the customer record may have been set ‘Default’ value. And in Set preferences(under the Home tab), the Transaction Email attachment format may be set as HTML (Under the transactions tab). Then when sending… Continue reading Email attachment types in transactions
Format Issue when exporting report in PDF
Issue – When exporting the report in PDF format, the row are not aligned properly and the values are overlapping to one another. Solution – If the report contains a large number of columns and values, then there may be format issues. This can be fixed by changing the layout of printing to landscape mode… Continue reading Format Issue when exporting report in PDF
Journals not showing in the Sales by Tax code report
Make sure the following A tax code is selected at the Journal line of expense Make sure a Tax account has been selected for that line. The Tax account selected is the same as the Sale Tax account selected in the corresponding tax code record.
The Tax code list in SO restricted
When entering a sales order, the tax code field at the line level shows only the tax codes of the transaction subsidiary country, even if there is a different country in the customer record. The tax code list will display the tax codes of the country specified in the customer’s address by default if the… Continue reading The Tax code list in SO restricted
Remove the -No Location- field in the Reports
The financial reports can be viewed/filtered by location/class/department. Then -No Location-(No Class, No Department) is one of the columns available on the report. The user wants to remove this column. Navigate to Reports > Financial > Income Statement Select Location from the Column filter Click the More button to show more filters Click the drop-down… Continue reading Remove the -No Location- field in the Reports
PAYG Tax Withheld Amount is zero in BAS
Issue – When generating the Business Activity Statement on Reports > VAT/GST > Business Activity Statement, after selecting the Tax Period, PAYG Tax Period, and Subsidiary (if applicable), the PAYG Tax Withheld Amount being returned is 0.00. When there are taxes withheld on NetSuite records. Solution – Go to Setup > Company > Setup Tasks… Continue reading PAYG Tax Withheld Amount is zero in BAS
The report name is Profit and Loss for Income statement
The income statement report is not visible in the report section, but when searching for the income statement, the Profit and Loss report comes up. By design, UK and Australia edition use Profit and Loss instead of Income Statement. For a US edition account and for a OneWorld account with a US root Subsidiary, the Language is set to English (U.S.) by default. If… Continue reading The report name is Profit and Loss for Income statement
Restrict Custom Form using Workflow
Scenario: The custom form needs to be restricted based on the user subsidiary. When entering a Sales Order, based on the user subsidiary, need to set the default custom form even if the preferred form is something else. But even if the conditions are set for the user subsidiary, the custom form is not set.… Continue reading Restrict Custom Form using Workflow