To populate PayPack payment links on historical transactions (i.e. sales orders and invoices), utilize NetSuite's CSV import tool and follow these steps.
Create a CSV file with 2 columns.
- Transaction Internal ID
- PayPack Payment Link
Note: Leaving the payment link column blank triggers the transaction to generate a new value.
Download Sample CSV File: [Template] PayPack - Generate Invoice Payment Link.csv
Go to Setup → Import/Export → Import CSV Records.
Select the below CSV upload options.
- Import Type: Transactions
- Record Type: Invoice
Select the below import options.
- Data Handling: Update
- Check Overwrite Missing Fields
- Select Run Server Suitescript and Trigger Workflows
Select the below field mappings.
- PayPack Payment Link → Invoice : PayPack Payment Link
- Internal ID → Invoice : Internal ID