We shall to start using the Electronic Bank Payments functionality in NetSuite, but we have one issue regarding Bill Credits.
I am using one of the Payment File Formats that creates a pain.002.001.03 format xml file, but I think the issue is the same for all formats.
We have a payment like this:
* Bill, GFG1, 170
* Bill Credit, GFG2, -50
* Bill Payment, GFG3, 120
A payment is created with the amount 120 (correct) and information regarding the Bill (GFG1) is part of the file, but no information regarding the Bill Credit (GFG2).
Since the information in the file is:
* Amount = 120
* Payment concerns Bill GFG1
The supplier doesn’t know that we have used the Bill Credit and the supplier need to find out them self that we have used the Bill Credit.
We want to add information regarding the Bill Credit in the xml file.
I found a this information https://blog.prolecto.com/2020/02/29/exposing-vendor-credit-information-on-netsuite-check-vouchers/, but is not working to use this FreeMarker code in the code for the File Format. I think this is due to that the “credit” Sublist is added to the Bill Payment form with SuiteScript, so you need to be on the Bill Payment form and make a Print, for the “credit” Sublist to be available.
Questions:
1) Is it true that “credit” Sublist is not available in the FreeMarker code for a Payment File Format?
2)My workaround is to add custom Transaction Body Fields to the Bill, that specify the Related Records (the Bill Credit). And in the FreeMaker cod of the Payment File Format I will be able to reference the new custom fields. Do you have a better solution to the problem?