posting here also: <https://netsuiteprofessionals....
# suitescriptj
jen
03/17/2022, 7:35 PMb
battk
03/17/2022, 7:41 PMthe absurd answer is that the customer payment template has access to the credits sublist
battk
03/17/2022, 7:42 PMso you can make a template that has the credits sublist, then print it as html
battk
03/17/2022, 7:42 PMwhich you can then programmatically access
j
jen
03/17/2022, 7:45 PMthe main issue is that I’m trying to write a bespoke “print payment as PDF/Excel/CSV” tool, because the built in template is crap and we cannot show what we need no matter how hard we try (and it cuts stuff off).
jen
03/17/2022, 7:45 PMNot sure if above would allow us to get custom fields etc.
jen
03/17/2022, 7:47 PMDo you happen to have an example of how to access the template via SuiteScript? Do you mean like generate the HTML using
renderjen
03/17/2022, 7:47 PMbasically scraping the HTML?
b
battk
03/17/2022, 7:47 PMi wasn't desperate enough to do it
j
jen
03/17/2022, 7:47 PModdly enough, that’s super hacky and appealing
jen
03/17/2022, 7:48 PMI’m getting pretty desperate, have been trying to solve this for like two years now
jen
03/17/2022, 7:49 PMI thought I could use nexttransactionlinelink and then compare timestamps and get the “additional” entries that way, but doesn’t work if you’ve applied a payment to an invoice from within another payment
jen
03/17/2022, 9:18 PM@battk
record.creditjen
03/17/2022, 9:18 PMapply list works fine
jen
03/17/2022, 9:19 PMmy xml:
jen
03/17/2022, 9:19 PM Copy code
<#if record.apply?has_content>
<apply>
<#list record.apply as apply>
<applied_to>
<due>${apply.due}</due>
<apply>${apply.apply}</apply>
<currency>${apply.currency}</currency>
<applydate>${apply.applydate}</applydate>
<discamt>${apply.discamt}</discamt>
<discdate>${apply.discdate}</discdate>
<disc>${apply.disc}</disc>
<internalid>${apply.internalid}</internalid>
<trantype>${apply.trantype}</trantype>
<total>${apply.total}</total>
<amount>${apply.amount}</amount>
<refnum>${apply.refnum}</refnum>
<type>${apply.type}</type>
</applied_to>
</#list>
</apply>
</#if>
Credit:
#{record.credit}
<#if record.credit?has_content>
<credits>
<#list record.credit as credit>
<credit_applied>
<due>${credit.due}</due>
<apply>${credit.apply}</apply>
<currency>${credit.currency}</currency>
<creditdate>${credit.creditdate}</creditdate>
<internalid>${credit.internalid}</internalid>
<trantype>${credit.trantype}</trantype>
<total>${credit.total}</total>
<amount>${credit.amount}</amount>
<refnum>${credit.refnum}</refnum>
<type>${credit.type}</type>
</credit_applied>
</#list>
</credits>
</#if>jen
03/17/2022, 9:20 PMCalling it as follows:
jen
03/17/2022, 9:20 PM Copy code
var xml_template = file.load({id: 17488240});
var renderer = render.create();
renderer.templateContent = xml_template.getContents();
renderer.addRecord('record', record.load({
type: record.Type.CUSTOMER_PAYMENT,
id: payment_id
}));
var xml = renderer.renderAsString();b
battk
03/17/2022, 11:22 PMyou need to use render.transaction
j
jen
03/18/2022, 5:10 PMahhh
jen
03/18/2022, 5:16 PMis there a way to do that with a specified template, or will it automatically use the default template for that transaction? I don’t really want to mess with the existing template.
b
battk
03/18/2022, 9:44 PMits a form thing
battk
03/18/2022, 9:44 PMyou select the form, which also chooses the template
j
jen
03/18/2022, 10:46 PMahhhh
jen
03/18/2022, 10:47 PMso I can make a dummy form with my weird template, pass formid to render.transaction
jen
03/18/2022, 10:47 PMcool
jen
03/18/2022, 11:28 PMOK I’m getting closer, only thing I think I am missing is what the payment/credit is being applied to in the credits applied list.
b
battk
03/19/2022, 5:55 AMits not there in the documentation but fair chance the data is just there and not documented
j
jen
03/21/2022, 3:27 PMproblem is guessing what it’s called
jen
03/21/2022, 3:36 PMomg
jen
03/21/2022, 3:36 PMit’s appliedto
jen
03/21/2022, 3:36 PMthis is gonna work
jen
03/21/2022, 3:37 PMthank you @battk!
16 Views