RE: 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,

clarencefoos Rookie Asked on May 20, 2020 in How To's.
Add Comment
1 Answers

Return Authorization Import

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.

Intermediate Answered on May 20, 2020.

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?

on May 21, 2020.

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.

 

on May 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.