Each import can create one new inventory worksheet. You cannot use the inventory worksheet import to update an existing NetSuite inventory worksheet or to create multiple inventory worksheets at one time. Each inventory worksheet import can import data for one combination of class, department, location, and, if applicable, subsidiary values. You must do multiple import… Continue reading Inventory Worksheet Import Limitations
Author: Sinto Alappat
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
Approving the journal entries in bulk
The Approved checkbox is not displayed if you have enabled the Journal Entries Approval Routing Accounting Preference. This preference enables you to use SuiteFlow to create a custom journal entry approval routing workflow. If the preference is enabled, an Approval Status Field will be displayed instead of an Approved checkbox. In this case, the Approved checkbox cannot be mapped during CSV import as it is not showing on… Continue reading Approving the journal entries in bulk
Blanket Purchase VS Purchase contract
Blanket Purchase Agreement You create blanket purchase agreements when you know the details of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the details of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before… Continue reading Blanket Purchase VS Purchase contract
Creating Statutory Adjustment Journal
Use the statutory adjustment journal to adjust the calculated CGST, SGST/UTGST, or IGST on advance receipt or payment at the time of supply of goods and services. In addition, you can also use statutory adjustment journal to enter ITC (Input Tax Credit) reversal adjustment for GST claims in case you do not meet the specific… Continue reading Creating Statutory Adjustment Journal
Chart of accounts merging
You can merge one account into another if they are the same account type and the account you want to merge has no attached subaccounts. You can combine an account with a parent account or with a subaccount. For example, a store owner has a bank account for petty cash and a bank account for… Continue reading Chart of accounts merging
Legacy Tax: Set Chart of Accounts as Tax Control Accounts for United States and Canada
Scenario: A user with an Administrator role wants to set accounts created in the Chart of Accounts page (Lists > Accounting > Accounts) as their Tax Control Accounts for United States and Canada but is unable to do so. These accounts are not available in the Liability/Sales Tax Account and Asset/Purchase Tax Account drop-down selection… Continue reading Legacy Tax: Set Chart of Accounts as Tax Control Accounts for United States and Canada
Creating a Saved Search for Subsidiary Specific items
A company using NetSuite OneWorld, where they operate in multiple types of businesses represented by their multiple subsidiaries, may have a variety of items being sold or purchased. For instance, one subsidiary specializes in electronics, another in IT services, and another in manufacturing smart appliances, each focusing on different product categories. Some items may be… Continue reading Creating a Saved Search for Subsidiary Specific items
Remove Parent Item Name in Saved Searches
When creating Item Saved Searches, the Name field displays the parent matrix item name before the matrix child, (example: Parent Item : Matrix Child). The Ability to remove the parent matrix item in Inventory Reports is not available yet in the system and Enhancement # 161435 has been filed requesting for this. As a workaround… Continue reading Remove Parent Item Name in Saved Searches
India Localization Enhancements
Every GST registered taxpayer in India must file GSTR-9 annually. The India Localization SuiteTax Reports SuiteApp version 4.00.0 lets you generate the following reports to file GSTR-9. ■ GSTR9 4 Outward ■ GSTR9 5 Outward ■ GSTR9 6 ITC Availed ■ GSTR9 17 HSN Outward ■ GSTR9 18 HSN Inward These reports contain details about… Continue reading India Localization Enhancements