Requirement We will be implementing an API to fetch the customer balance data from Netsuite to an application. Request : GET Parameters: CompanyCode : Company code(Company code field in the subsidiary record corresponding to subsidiary field in customer record)- Mandatory CustomerCode : Customer Code(id:custentity_code) field in the Customer record- MandatoryPageIndex: Index of the page(starting from… Continue reading Customer Balance Integration API
Month: January 2022
Customer Data Integration API
Requirement We will be implementing an API to fetch the customer data from Netsuite to an application. Request : GET Script: Restlet Parameters: CompanyCode : Company code(Company code field in the subsidiary record corresponding to subsidiary field in customer record)- MandatoryCustomerCode : Customer Code(id:custentity_code) field in the Customer record – Mandatory Solution
Mass update for all historical transaction records for edit and save (performing user event).
Performing a mass update script to edit and save all historical transaction records.
Renaming Records and Transactions
Users of NetSuite with administrator role can Rename records and transaction . Navigation to Rename records Go to Setup > Company > Setup Tasks > Rename Records/Transactions. On the Rename Records/Transactions page, the default names for records are autofill in the fields. In the fields at the top half of the page, edit the names of relationship records… Continue reading Renaming Records and Transactions
Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.”
Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.” Issue: Enter Item Quantity Pricing in item record manually or via CSV Import 2. Save item record 3. Error: Each Quantity pricing level must be greater than the previous quantity pricing level • The error… Continue reading Enter Item Pricing in Item Record Results to Error: “Each Quantity pricing level must be greater than the previous quantity pricing level.”
Update Field on Work Order from Sales Order via Script
Automatically updating a field on the Work Order from Sales Order via Suitescriptcould save you some time.Doing this on Suitescript by using aftersubmit function of User Event script thatwas deployed on the Work Order Record is one way.A sample of this is available in SuiteAnswers article id: 45149.Same scripting logic could be applied to other… Continue reading Update Field on Work Order from Sales Order via Script
Remove Parent Item Name in Saved Searches
When creating Item Saved Searches, the Name field displays the parent matrixitem name before the matrix child, (example: Parent Item : Matrix Child).The Ability to remove the parent matrix item in Inventory Reports is not availableyet in the system and Enhancement # 161435 has been filed requesting for this.As a workaround to display only the… Continue reading Remove Parent Item Name in Saved Searches
How to access sublist data in a suitelet
Suitelets allow us to create custom pages within NetSuite. One of the commonimplementations for a suitelet is getting data from a user and then processing the datafor display. To get and process the fields that are created in the suitelet, we useserver request.parameters to access the values of the fields. A sublist can also becreated… Continue reading How to access sublist data in a suitelet
Customize your Vendor/Customer Global Search Results to Show its Subsidiaries
Users usually determine the Primary and secondary subsidiaries by opening theVendor/Customer record and navigating to the classification section and subsidiariestab. If you think about it, that will require a lot of steps if you need to check on multiplerecords. So, here’s a tip that will make things easier for you! Instead of going over eachrecord,… Continue reading Customize your Vendor/Customer Global Search Results to Show its Subsidiaries
Vendor Bill error – “Your formula has an error in it…”
Encountering an error on the Approval Page of transactions may hinder users toperform bulk approval which can also prolong their daily tasks and processes.Users can mass submit for approve, reject, re-submit for approval in the ApproveVendor Bill Page if the Approval Routing = T. The Actions in the Approve Bills Page arethe actions from the… Continue reading Vendor Bill error – “Your formula has an error in it…”