Articles written by John David Dy
Articles written by
John David Dy
Currency Field Disabled when Creating New Project for Multi-Currency Customers
When creating a newProjectfor multi-currencyCustomers, theCurrencyfield is disabled.
How to create a new multi-currency payment file format:
Go to Payments > Setup > Payment File Templates > New.
Use Income Accounts on Multi-Currency Transactions
Currencyfield is grayed-out when creating anIncome type Account(Lists > Accounting > Accounts > New). On existing Income type Accounts, Currency field is not displayed.
Journal Shows the Same Figures in Columns Net Amount and Tax Amount in the Business Activity Statement Total Sales Box G1 in a VAT/GST Report
Reports>VAT/GST>Business Activity Statement> Drilldown Total Sales Box G1 > Journals show the same Figures in Columns Net Amount and Tax AmountHere are few illustrations of the standard behavior when applying GST in Journal Entries.
GST Sales Tax Code is Appearing on Purchase by Tax Code Report
The user has a Tax Code which is specifically made for Sales Transactions. However, whenthe user runs the Purchase by Tax Code report, the said Tax Code is appearing on the report.
Journal Import of Sales with GST Not Showing Up in the Business Activity Statement Report
The user has imported a sales transaction through CSV import of general journals and the CSV template has no mapping for Tax Account column in the Journal which in result made the sales transaction not reflect in the Business Activity Statement Report.
Shipping Tax Code Blanks After Changing Shipping Address
Shipping Tax Code becomes blank after user changes Shipping Address in new Sales Order.
Permission to Access Review Negative Inventory Page
Scenario :
Solution :
- Navigate toSetup>Users/Roles>Manage Roles
- Custom Role: ClickEdit
- ClickPermissions
- ClickLists
- Permission:SelectItems
- Level:Select at leastViewlevel
- ClickAdd
- ClickSave
Review Inventory Activity
If you use NetSuite OneWorld, this task opens a customizable version of the Inventory Activity Detail report. This report provides a view of specific inventory values. The report details are based on the item level total inventory value in a specific subsidiary context.
Review Inventory Cost Accounting
When closing a period, you must run the costing accounting process for the period close. To complete this task, ensure that there are no costing items to be corrected and that inventory costing calculations are not already currently running.
Reviewing Negative Inventory
You can identify any negative inventory values that can be corrected by adjusting them to be positive. This process does not create a physical count. A physical count should already be completed before you begin this task.
To add the My Login Audit portlet to your dashboard:
ClickPersonalizein the upper right corner of your dashboard or usePersonalize Dashboardin theSettingsportlet.
Error: The subsidiary selected for To Subsidiary on the journal entry and Representing Subsidiary of Intercompany Vendor/Customer must match if you want to run Intercompany Elimination for this line
Create Advanced Intercompany Journal Entry > error: "The subsidiary selected for To Subsidiary on the journal entry and Representing Subsidiary of Intercompany Vendor/Customer must match if you want to run Intercompany Elimination for this line."
Cannot Select Intercompany Customer in Intercompany Journal Entry
On Intercompany Journal Entry, the Intercompany Customer of a Subsidiary does not appear in the Customer field.
Removing Restrictions for Tax Control Accounts
Note: This feature is available for all nexuses, except US and Canada.
Creating a Tax Control Account
Note: Tax types and tax codes are created separately. Changing the tax control account on the tax type record does not automatically update the tax control account shown on the tax code record. Transactions post tax to the tax control account shown on the tax code record. Editing the tax code record updates the tax control account fields.
Tax Types Overview
A tax type determines where the tax paid or collected is tracked on the balance sheet. The balance sheet account to which NetSuite posts the collection or payment of tax is called the tax control account.
Tax Control Accounts Overview
Tax control accounts are accounts in your general ledger or chart of accounts. These are the accounts to which the amounts computed for indirect taxes such as sales tax and VAT are posted.
Setting Up Tax Agencies as Vendors
In most countries, businesses are required to collect tax from sales. Then, the collected tax must be paid to the tax authority on behalf of the customers. Default tax agencies are automatically set up by the system when you create a subsidiary or nexus, but you must edit the tax agency vendor record to provide details such as address information.
Nexuses and Taxes in OneWorld
A nexus is a tax jurisdiction. Nexuses are part of the NetSuite Advanced Taxes feature, required for NetSuite OneWorld. Each subsidiary must be associated with at least one nexus. The first nexus is automatically assigned to a subsidiary based on the country entered for the subsidiary's address. A subsidiary can have more than one nexus. A nexus and its related tax items can be shared by multiple subsidiaries.