Proposal Summary This proposal covers the scope of generating two reports of Item pricing based on customer and transaction. The two reports should include item and item pricing fields with filters applied. Requirement Create two reports in the standard NetSuite Report Builder format as follows: Report 1 as ‘New Item Pricing based on previous 12… Continue reading Proposal For Item Pricing Report
Author: Anila George
Proposal For Shipping Method Updates in NetSuite
Proposal Summary This proposal covers the scope of Shipping Method Updates in NetSuite. Requirement Blueleaf Ltd. Needs a functionality to enter shipping methods at Client address level rather than the Client record level. Where a client record has multiple delivery addresses, they want the opportunity to allocate the shipping method for each address which has… Continue reading Proposal For Shipping Method Updates in NetSuite
Close Partially Received Purchase Order with related Inbound Shipment
Requirement – Some items will be inactivated and created new corresponding Items. These inactivated items need to be changed to new ones in open transactions. Purchase orders with partially received status and Inbound shipments, can not be edited. Solution – Edit the item quantity to the received quantity in Inbound shipment. Edit the item quantity… Continue reading Close Partially Received Purchase Order with related Inbound Shipment
Apply Currency Filter for Custom Field
Requirement – Created a custom transaction line field for Landed Cost templates. This field should only show the Landed Cost templates of the items with the same currency as the PO currency Solution – The filter can be applied to the custom field setup itself. Under the Sourcing and Filtering subtab, select currency in the… Continue reading Apply Currency Filter for Custom Field
Customer Item Pricing Hierarchy in Saved Searches
The customer search for the unit price of items shows the item prices based on the Netsuite system logic on a certain priority. This is the same logic as the default item price in the sales orders. The Hierarchy being followed is: The Item unit price will be based on the Price Level set on… Continue reading Customer Item Pricing Hierarchy in Saved Searches
Make A Field In Custom Record Globally Searchable
Requirement – created a custom record by not including the standard Name field. Created a custom field in that record for storing names. The standard Name field is not included as the name is not mandatory for the custom record and the standard Name field is mandatory if included. But the custom field for storing… Continue reading Make A Field In Custom Record Globally Searchable
Automatically Create Child Custom Record
Requirement – Create a child custom record upon the creation of a parent record. There is a custom child record in the Item record. And whenever an item record is created a child record should be created automatically in the same name as the parent Item. Solution – We have put a workflow in the… Continue reading Automatically Create Child Custom Record
Excel Setup for Dynamic connection
Requirement – Need to Connect a report in NS to excel dynamically Solution – Create a saved search the same as the report in NS. Create a suitelet link to load the search to excel. Connect the saved search with excel using the suitelet external URL. The excel setup is as follows On Windows PC … Continue reading Excel Setup for Dynamic connection
Proposal For Shipping Method Updates in NetSuite
Proposal Summary This proposal covers the scope of Shipping Method Updates in NetSuite. Requirement BlueLeaf Ltd. needs the functionality to enter shipping methods at the Client address level rather than the Client record level. But the client record has multiple delivery addresses, they want the functionality to allocate the shipping method for each address which… Continue reading Proposal For Shipping Method Updates in NetSuite
No Bins are available in the Assembly Build Helper
When creating an Item Receipt for purchase orders, if the item is using the ‘Bin’ feature, i.e., If you choose to use bins for this item, you must associate at least one bin with the item using the Bin Numbers subtab. For that, you must perform Inventory Detail for that item. And in the Assembly… Continue reading No Bins are available in the Assembly Build Helper