This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

has anyone made an electronics payment file template thats dynamic based on transaction type? doesn't seem like you have the data to do it available

so they want to have a single payment template that behaves differently based on if its a vendor bill or expense report

theres no fields i can see that'll let me do this.. it tried some regular record stuff like .type on the entity to see if its an employee vs vendor but it fails

alternative is just 2 different payment templates and 2 different company bank details based on vendor bill or employee

Hi Creece, in the xml doc of a vendor bill, I see this tag &lt;type&gt;vendbill&lt;/type&gt;

also, under bill payment, there is this field : &lt;baserecordtype&gt;vendorpayment&lt;/baserecordtype&gt;

${payment.baserecordtype} and see what it outputs

I just tried it on email template freemarker and it outputs vendorpayment

so you can use this for your if/else logic

I tried those as well and no go it errors out. You can get a payment.type but they are all bill payments so it does no good.. prob gonna have to go the 2 payment template route

Just reviewed your goal again. If it's separating vendor vs. employee payments, have a look at the native ACH-CCD/PPD template

they have functions there to separate vendor (CCD) vs. employee (PPD) payments

yeah they wanna use this exact xml style payment template so that one won't work for them

ill take a look though just in case i can use it

&lt;#-- Divide Payments, Entities, and Entity Banks into two groups (CCD, PPD) --&gt;