Ron
09/11/2025, 2:26 PMCeligo AI
09/11/2025, 2:26 PMAI generated answer (using internal Slack threads):The quickest and easiest way to duplicate a Purchase Order (PO) from production to sandbox without a refresh would be to manually recreate the PO in the sandbox. This is because NetSuite does not provide a direct way to copy individual records from production to sandbox without a sandbox refresh. However, if you have a large number of records to copy and manual recreation is not feasible, you could consider using SuiteScript to automate the process. You could write a script in your production environment to export the desired PO data to a CSV or JSON file, and then write a corresponding script in your sandbox environment to import that data and create new POs. Here's a basic example of how you might structure your SuiteScript:
javascript
// Export script in production
var po = nlapiLoadRecord('purchaseorder', poId);
var poData = JSON.stringify(po);
// Save poData to a file and transfer it to your sandbox
// Import script in sandbox
var poData = JSON.parse(poDataFromFile);
var newPo = nlapiCreateRecord('purchaseorder');
// Loop through poData and use newPo.setFieldValue(fieldId, value) to set the field values
nlapiSubmitRecord(newPo);
Please note that this is a simplified example and you would need to handle sublists and other complexities in a real-world scenario. Also, remember to thoroughly test your scripts in a safe environment before running them in production.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
09/11/2025, 2:26 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827148497
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818847716
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814819396
Celigo AI
09/11/2025, 2:26 PM