Author: Manu Antony

Item Fulfillment has No GL Impact

Scenario User noted some Item fulfillment that does not post any value in the GL impact. Solution Item Fulfillment may not post value in the GL impact due to the following reasons: 1. Item shipped is a Non-inventory Item 2. Item Fulfillment was created form a Dropshipment order 3. Inventory item was sold underwater or has a negative inventory at the time of fulfillment To determine if there are… Continue reading Item Fulfillment has No GL Impact

Open Bill Report (Drop Ship Orders) with Customer Invoice Number, Invoice Due Date, Status

These are Open Bills related to Drop Ship Orders. This report checks if the related Sales Order is already been invoiced.1. Navigate to Reports > Saved Searches > All Saved Searches > New 2. Click Transaction link 3. Enter preferred search title 4. Under Criteria tab > Standard subtab, add the following filters: Type | is Sales Order Applying Link Type… Continue reading Open Bill Report (Drop Ship Orders) with Customer Invoice Number, Invoice Due Date, Status

Hide the Payroll Subtab on Employee Records

If the Payroll feature is enabled, users who have access to employee records can view the employees’ payroll information via the Payroll subtab. To restrict non-Administrators from viewing payroll information of employees but still allow them to access other information about the employees, a custom form can be set up where Payroll subtab is hidden.… Continue reading Hide the Payroll Subtab on Employee Records

Adjust Inventory Value Without Affecting The Item Quantity

There are two ways to adjust Inventory value of an item without affecting its quantity: Note: however that this only applies to Regular Inventory Item and not applicable to Lot and Serialised Items  1. Use Adjust Inventory Worksheet (Transactions > Inventory/Items > Adjust Inventory Worksheet)  —Use COGS or any other GL account as the Adjustment Account.… Continue reading Adjust Inventory Value Without Affecting The Item Quantity

Create Foreign Currency Variance Posting Rules >

Scenario Customer ran the Revalue Open Currency Balances task in the Period Close Checklist and got the following error: “Bulk Processing Abnormal Termination” If the Foreign Currency Variance Mapping under Setup > Company > Enable Features > Accounting tab > Advanced Features section is currently enabled, we are required to create rules for the posting of Unrealized Gain/Loss from currency revaluations. When creating rules under Setup >… Continue reading Create Foreign Currency Variance Posting Rules >

Reallocate Items using SuiteScript

Reallocate committed items from Sales Order using SuiteScript. Please Note: NetSuite SuiteAnswer says scripting is not supported for Reallocate Items record, but this is possible via Suitescript. So this might become available in future NetSuite releases as a new feature. So I advise everyone to use this with precaution for now.

SagePay Integration Proposal

Proposal summary This proposal details how to enable SagePay as an external payment gateway in NetSuite with the help of SagePay APIs.  Requirement  Payments (Via the SagePay Integration) will be triggered from the Sales Order record only via a button/popup. On Customer Deposit Record The Deposit record must be created from the Sales Order to… Continue reading SagePay Integration Proposal

Klaviyo Integration Proposal

Proposal summary The proposal covers the Klaviyo Integration with NetSuite for the following scope :  Item Catalog Sync :Transquip should provide a saved search in NetSuite for Product Catalog integration that contains Item details including id, title, description, item link, item image link.We can build the connection but the trigger should be manual. Entity Sync… Continue reading Klaviyo Integration Proposal

Custom Promotion Proposal

PROJECT GOALS Purpose Custom solution – “NBS Promotion” design  Types of Promotions: Promotion Type – Minimum Order only on the 1st Order   Description Buy any items minimum total order amount AND this is the customer 1st order and get total Z % discount optional start and end date Solution Custom solution – “NBS Promotion” Result… Continue reading Custom Promotion Proposal

Shipping Cost Calculation Proposal

Proposal summary This proposal is to implement a custom solution to calculate Shipping Cost based on multiple parameters. Requirement  Key requirement is that this functionality must work in both SCA and NetSuite UI. As before shipping rules should exist dependent on destination country (allowing multiple countries via country code) As before shipping rules should exist… Continue reading Shipping Cost Calculation Proposal