Requirement: The User has successfully completed the Historical Transaction Process (HTP). However, the User cannot generate Revenue Recognition Journal Entries for the Secondary book even if Create Revenue Recognition and Amortization Journal Entries are set to True. Solution To check if Revenue Arrangements are also copied to Secondary book: 1. Navigate to Transactions > Financial >Revenue Arrangements 2. Click Customize View 3. On… Continue reading Setting Revenue Recognition Journal Entries for Secondary Book from HTP
Author: Praiselyn Fiana D
Adjustment-Only Books
This is a feature in Multi-Book Accounting. Adjustment-only books allow you to post book-specific adjustments to a secondary, adjustment-only book at closing. They serve as a light version of multi-book accounting, but you do not need the Full Multi-Book Accounting feature to use them. Adjustment-only books differ from standard secondary books in that they do… Continue reading Adjustment-Only Books
Unexpected Error in saving Bank Reconciliation Page
Requirement: The user would like to use the old Bank Reconciliation function which is the Reconcile Bank Statement page. While editing the Account record and unchecking the Match Bank Data and Reconciliation Pages, it throws an error: “An Unexpected Error has occurred. Please click here to notify Support.” Solution Navigate to Lists > Accounting > Accounts Click Edit on a Bank Account… Continue reading Unexpected Error in saving Bank Reconciliation Page
Populate Terms Field on a Sales Order
Requirement: The Sales Order created does not auto-populate the Terms field on the transaction. This should auto-populate with the Terms assigned to the Customer’s record. Solution Create a Workflow for the Sales Order that would set the field’s value depending on the Term that is set on the Customer’s record. Navigate to Customization > Workflow > Workflows > New Basic Information: Name: Enter NameExample: Sales… Continue reading Populate Terms Field on a Sales Order
Inventory Activity Detail Report in Saved Search
Requirement: A user wants to show the Item with Quantity only that will match with Inventory Detail Report. This search should only expose the Item and Quantity Summary Initially but upon clicking on the Item it should expose all the relevant transactions for it. Solution Create a Transaction Saved Search by navigating to Reports > Saved Searches > All Saved… Continue reading Inventory Activity Detail Report in Saved Search
Separate GST and TDS in Saved Search
Requirement: Client would like to see GST and TDS in separate columns in the search. Using NetSuite Standard behavior, it is obtained as Amount (Tax) in search. Solution: Create a Transaction Search. In Criteria Subtab, -Add Type is Bill -Mainline is False In Results Subtab, Add necessary fields. For TDS, Field: Formula Currency, Function Absolute… Continue reading Separate GST and TDS in Saved Search
Create Transaction Detail Report to show Related Transactions of Item
Scenario User would like to create a report to show all related transactions of an item. Solution You may follow below steps: 1.) Navigate to Go to Reports > Financial > Transaction detail > Customize2.) Rename the report3.) Under Edit Columns, add fields: Transaction Type: Transaction Type Long Name Transaction: Date Transaction: Item Transaction: Document Number Transaction: Account Full… Continue reading Create Transaction Detail Report to show Related Transactions of Item
Workaround for customizing Administrator role
Product: NetSuite 2021.2SuiteApp: Custom Administrator – No 2FA | Bundle ID: 249470 Scenario User needs to create a Role that is similar to the Administrator role. The standard Administrator role cannot be edited in the Manage Roles page for security purposes. As an aletrnate solution user needs to install a bundle that contains a custom role that… Continue reading Workaround for customizing Administrator role
FEFO Lot Assignments Preferences
FEFO Lot Assignments preferences has to be set as part of FEFO Lot Suite App configuration. It can be set up by navigating to List> FEFO Lot Assignment > FEFO Lot Assignment Preference FEFO Lot Assignments preferences are set separately for each location. Following are the preferences:
Negative Profit in Customer Profitability Report
The Customer Profitability report pulls its data from Item Fulfillment and Invoice records. The report includes Item Fulfillment records that are not yet invoiced. This causes the negative profit. To illustrate, say for example, Sales Order 1 and Sales Order 2 are created and have the following related records: Sales Order 1 amounting to $10.00 Item Fulfillment 1 amounting to $10.00 Invoice… Continue reading Negative Profit in Customer Profitability Report