PROPOSAL SUMMARY The purpose of this proposal is to detail the integration plan between NetSuite and Magento through REST APIs, with a specific focus on synchronizing inventory items from NetSuite to Magento. REQUIREMENTS Szco Supplies, Inc is seeking to establish a seamless integration between their NetSuite system and Magento ecommerce website. The goal is to… Continue reading NetSuite – Magento Product Sync Proposal
Author: Lakshmi priya Suresh
Sending Grant Certificates to appropriate Suppliers on quarterly basis – Scheduled MR Script
Requirement: Client requires a statement of account for each MA pertaining to the financial year within a specified date range. This statement or certificate is intended to display the payments made to each MA throughout the year. As the MAs have email accounts in NetSuite, client wishes to automate the process of generating these certificates/reports… Continue reading Sending Grant Certificates to appropriate Suppliers on quarterly basis – Scheduled MR Script
Auto invoicing Inventory Items on Schedule basis
Requirement: When an item fulfillment status becomes ‘shipped’, the item fulfillment should get automatically invoiced, but only the inventory item should be invoiced. Solution:
Grouping Objects in an array by a key with Amount Summation
The code provides a solution for grouping objects based on a common key, in this case, the ‘reference’ key. It takes an array of objects as input and creates a new array where objects with the same ‘reference’ value are grouped together. Additionally, it calculates the sum of the ‘amount’ values for objects within each… Continue reading Grouping Objects in an array by a key with Amount Summation
MA Grant Certificate – Proposal
Proposal Summary This proposal outlines the solution designed for automating the quarterly distribution of “Grant Certificates” to the relevant member associates via email. The grant certificates will be in PDF format and attached to the email. Requirement Client requires a statement of account for each MA pertaining to the financial year within a specified date… Continue reading MA Grant Certificate – Proposal
Create transfer order for items having quantity available in a location less than the re-order point.
Requirement: A transfer order needs to be created for items in location A having quantity ordered less than reorder point from location B to A if B has enough quantity and also another transfer order will be created for the items having quantity available in A greater than the preferred stock level from location A… Continue reading Create transfer order for items having quantity available in a location less than the re-order point.
Sales Order Has a Default Tax Item Value Even if the Item Is Non-Taxable
Scenario: When a Sales Order is created for a Non-taxable Item, a Tax Code is being pulled up instead of -Not Taxable- Tax Item. Solution: The Tax Item Setup is being bypassed by the system when there is a Tax Item set on the Customer Record. Taxes are charged for all items on the Sales Order regardless of… Continue reading Sales Order Has a Default Tax Item Value Even if the Item Is Non-Taxable
How to remove a folder from file cabinet using suitescript?
To remove a folder from the File Cabinet using SuiteScript, you can use the N/record module. The following code demonstrates how to delete a folder:
RepairDesk Customer Authentication API Creation
Requirement: When a customer logs in to RepairDesk, we need to identify if the customer is an authorized NetSuite customer using their email address. Solution: We have developed a Restlet script that takes customer email address and password as request body and return a success response if a customer with this email address exists in… Continue reading RepairDesk Customer Authentication API Creation
Update Records Locked by Workflow
When a record is locked by Workflow, it cannot be edited and submitted regardless of the role used. In SuiteScript, the equivalent APIs of these two actions (edit and submit) are record.load() and record.submitFields(). If these APIs are executed against a locked record, the following error is thrown: RCRD_LOCKED_BY_WF: This record has been locked… Continue reading Update Records Locked by Workflow