Does anyone know how you can link a payment transa...
# suitetalkapim
Marc Reicher
10/05/2020, 10:47 PMDoes anyone know how you can link a payment transaction to an invoice transaction using the API? These records don’t seem to have references to each other in the data but clearly in the UI the payment record has a reference to the invoice that it relates to?
b
battk
10/05/2020, 10:59 PMsoap or rest
m
Marc Reicher
10/06/2020, 1:13 AMEither? I’ve been using SuiteQL via Rest but have used SOAP too
b
battk
10/06/2020, 1:21 AMfor soap, you want to initialize the Customer Payment so that all the available invoices are filled in for you
battk
10/06/2020, 1:23 AMfor rest, you do the same thing while transforming records, though its more important that you find out which field is the key when Working with Sublists
battk
10/06/2020, 1:28 AMmy guess for the customer payment will be the refNum or doc fields
m
Marc Reicher
10/06/2020, 1:57 AMI’m using the Analytics data source https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transaction.html
Marc Reicher
10/06/2020, 1:58 AMI don’t see anything on the transaction schema (used for payments and invoices) that I could use
Marc Reicher
10/06/2020, 1:58 AMIs there another data model I’m missing
b
battk
10/06/2020, 2:15 AMprimary source should be Working with Resource Metadata
battk
10/06/2020, 2:17 AMsecondary source the REST API Browser. Beware differences between it and the metadata in your account
2 Views