How to import a transaction and have it relate to another (Return Authorization to Sales Order)
I’m wanting to know if it’s possible to import new Return Authorization transactions and have them relate to a Sales Order the sale originated from. When I create an RMA through the UI from a Sales Order it is related, but I haven’t been able to find a way to do this via CSV import – they’ve all been standalone Return Authorizations.
Is this possible? And could it apply to other new imports like creating Credit Memos related to these Return Authorizations?
Thank you,
This import supports the import of standalone return authorizations, but not linked return authorizations (those created from cash sales or invoices and linked to these original sales transactions).
I would have low hope for this working.
I see, would have you have any advice on how to go about accomplishing relating these imported records via Suitescript? Is that possible in your experience?
If you’re using SuiteScript, you’ll need to use record.transform() to create the return authorization from the sales order. More details are here: https://netsuite.custhelp.com/app/answers/detail/a_id/45156
Here’s a quick snippet (taken from the help file).
// Add additional code.
...
record.transform({
fromType:'salesorder',
fromId: 6,
toType: 'invoice',
defaultValues: {
billdate: '01/01/2019'} });
...
// Add additional code.
