NetSuite enables you to import up-to-date sales tax codes for the states in which you charge sales tax. Each month, NetSuite updates its database table that stores the tax rates for all U.S. states. The Version field on the State Tax Import page indicates the effective date of the tax rate change. NetSuite receives the tax table… Continue reading State Tax Import
Category: NS Financials
NS Financials
Using Journal Entry Import for Updates
The Single Journal Entry Import Assistant does not support updates. For existing journal entries and existing intercompany journal entries, you need to use the CSV Import Assistant at Setup > Import/Export > Import Tasks > Import CSV Records, which can: Update transaction body field values Add lines to existing transactions Update values in existing journal entry… Continue reading Using Journal Entry Import for Updates
Intercompany Income Account Field on Item Record
Intercompany Income Account – Select the account to use for intercompany income for this item. This account is used to record transactions between subsidiaries in NetSuite OneWorld accounts. To be available for selection, an account must have the Eliminate Intercompany Transactions box checked. If the Eliminate Intercompany Transactions box is later cleared on the account, intercompany… Continue reading Intercompany Income Account Field on Item Record
UK VAT 100 PDF Error
When trying to generate the report “Periodic VAT return – VAT 100” for UKin pdf format, the report is showing the below error: Error message: {“type”:”error.SuiteScriptError”,”name”:”USER_ERROR”,”message”:”Error Parsing XML: The entity name must immediately follow the ‘&’ in the entity reference.”,”id”:””,”stack”:[“Errorn at VATFormController.exportToPDF (/SuiteBundles/Bundle 237699/com.netsuite.suitetaxreports/src/app/controller/VATFormController.js:524:36)n at VATFormController.exportVAT (/SuiteBundles/Bundle 237699/com.netsuite.suitetaxreports/src/app/controller/VATFormController.js:456:35)n at Object.onRequest (/SuiteBundles/Bundle 237699/com.netsuite.suitetaxreports/src/component/su/CountryForm_su.js:32:49)”],”cause”:{“type”:”internal error”,”code”:”USER_ERROR”,”details”:”Error… Continue reading UK VAT 100 PDF Error
Ad Hoc Reports
Choices for Ad Hoc Reports Metric, Report Title, Field, Format Summary Detail Matrix Subtotal Grouping, and (for matrix format reports) Matrix Column. Example Ad Hoc Report Results Summary Sales Report 2.Detail Sales Report 3.Detail Sales Report
Audit Trail Saved Search for Chart of Accounts Changes
Navigate to Lists > Search > Saved Searches > New Select Account Under the Criteria tab, add the following filter: – System Notes fields… Type = Change Under the Results tab, add the following fields: System Notes fields… Click the Add Multiple button Select the following: Field, Old Value, New Value, Set by, Context, and Date Click Add button Click Preview or Save and Run
Cost Accounting Status on Item Records
Inventory and assembly item records include a Cost Accounting Status field that identifies the state of Cost Accounting calculations for that item. For Multi-Location Inventory users, the status is identified per location. This field is hidden by default. You must customize the item page to display this field The Cost Accounting Status indicated can be… Continue reading Cost Accounting Status on Item Records
User with an administrator role tries to delete an asset and receives a SuiteScript error: This Asset cannot be deleted because it is active for depreciation.
FAM assets with related records that are actively depreciating cannot be deleted. Below are the steps we done to delete the asset record: *Make sure Allow Asset Value Editing box = YES on Fixed Assets > Setup > System Setup (Administrator). Navigate to Fixed asset > Lists > Assets Click Edit beside the FAM asset. Set the following: • Current Net Book Value = 0.00 • Asset Status =… Continue reading User with an administrator role tries to delete an asset and receives a SuiteScript error: This Asset cannot be deleted because it is active for depreciation.
Fixed Asset Disposal Methods
Disposal-Sale An asset at or near the end of its useful life can be disposed via sale to another party. The Asset Manager can perform an Asset Sale Disposal. The following activity will take place: The appropriate Customer (sell-to party), Asset Item, and Item Amount (sale price) is entered. The Asset Sale will result in two NetSuite… Continue reading Fixed Asset Disposal Methods
Fixed Asset Management Reporting
Fixed Asset Management Reporting The following searches come native with FAM bundle and are recommended for use with the Asset Manager role and dashboard. Any role with Fixed Assets permissions can access these reports: Depreciation Monthly Report Additions Disposals Period Movement Asset List Asset Register Proposal History