Author: Diniya A J

Fulfilling/receiving join in a sales order search shows results as item fulfillment and invoice

The reason for the task description is the item types in the transaction records. If a sales order contains a service item/ non-inventory item, the saved search will display invoice records in fulfill/ receipt transaction join fields. The reason is that service items in NetSuite are considered non-inventory items that require a fulfillment or receipt… Continue reading Fulfilling/receiving join in a sales order search shows results as item fulfillment and invoice

Reverse Shipped Sales Order and Received Purchase Order

Requirement: Reversing sales orders that have been shipped but not invoiced, as well as those that have been shipped and invoiced. We will also explore the scenario of reversing a purchase order that has related transactions. Solution: In NetSuite, there is no standard functionality for reversing sales orders that have already been shipped. As an… Continue reading Reverse Shipped Sales Order and Received Purchase Order

Different subsidiaries based on the base currency are in Separate columns in Workbook

Select the Pivot option in workbook In Layout: Add the Account field to the Rows Add a Subsidiary field to the Columns Add the Amount to the Measures Click three dots icon next to the Amount field To show the amount in the consolidated level, select Apply Consolidated option. To show the amount in Base… Continue reading Different subsidiaries based on the base currency are in Separate columns in Workbook

Generating a Workbook for Standard Income Statement Report in NetSuite

Go to the Analytics menu. Create a new Dataset for Transaction by clicking on New Dataset button. 3. Select Transaction dataset and add the following criteria and columns: Criteria: Account Type: Income, Cost of Goods Sold, Expense, Other Income, Other Expense Posting is True Columns: Account Type(Transaction Line: Account: Type) Location(Transaction Line: Location) Class(Transaction Line:… Continue reading Generating a Workbook for Standard Income Statement Report in NetSuite

Best practices when working with discount

Use Descriptive Item Names: Use clear and descriptive names for your discount items to help identify them quickly and easily. For example, you could use “10% Discount” or “Free Shipping.” Specify the Discount Type: When creating a discount item in NetSuite, specify whether it is a percentage discount or a specific dollar amount discount. For… Continue reading Best practices when working with discount

How discount values are calculated and fetched in saved searches and reports

If the discount amount is in Currency format: To calculate the amount of discount that each item receives, we can follow these steps: Calculate the total value of the order before any discounts are applied. For each item on the order, calculate the weight of the item as a proportion of the total value of… Continue reading How discount values are calculated and fetched in saved searches and reports

Report on the behavior of discount items in sales transactions

Non-Posting/ Account Line Discount Item/ Body Discount Item Discount amount reduces from field… in saved search Non-Posting Line Discount Item – In Record: The discount amount will be reduced from the subtotal of an item.– In saved search: Will show the discount item in a separate line. Also, the disc amount will be reduced from… Continue reading Report on the behavior of discount items in sales transactions

Transaction and Line Item Discounts

Transaction Discounts A discount item can also be used to reduce the total amount of a transaction. To apply a discount item to a transaction’s total, select the discount item you want to apply in the Discount field. NetSuite autofills the item’s rate and the transaction’s discounted total. Body-level discount items are items that are… Continue reading Transaction and Line Item Discounts