Version 2.02.27

Bug Fixing

• updating customer's email fetching

 

Version 2.02.26

This update is strongly recommended for ALL customers using EP in version 2.02.25, resolving a critical issue regarding to NCS.

• Resolved the issue of not able to change the file upload status to "Pending Upload" for a NCS enabled EP bank account.

 

Version 2.02.25

This update is strongly recommended for ALL customers using EP.

• This is due to the technical changes announced by Oracle NetSuite, coming into effect as of July 30, 2024, deprecating internal calls method to Suitelet.
• No new feature is introduced in this release
• Customer is strongly advised to test the newest bundle in testing environment before putting to production environment, especially if the version is below 2.02.01

 

Version 2.02.24

Bug fixing

• fixing incorrect scriptContext property
• enabling script to only run in CREATE, EDIT, XEDIT, COPY trigger mode

 

Version 2.02.23

Bug fixing

• handle INLINE fields when record decrypted
• EP Preferences page SECRET ID field help updated
• clear EP related fields if error occurs

 

Version 2.02.21

Bulk Remittance added

This is the development to process large amount of Remittances.

At the moment there is no S/L sitting over the script therefore initiating the script, you will need to do it manually from the Script Deployment record (Customisation -> Scripting -> Scripts -> NC EP Send Remittance). This deployment can have multiple concurrencies set.

NC EP Send Remittance 2 MR - this is the second processing script. Maximum concurrencies can be 10. Although if you expect more than 900 remittances across 10 Vendors then the concurrency limit must be kept less. Email Sender is a parameter which is required.

 

Version 2.02.20

Fixing issue with Vendor record when the update triggers the U/E script in XEDIT mode.

 

Version 2.02.19

EP Preferences

• Adding script parameter, defined as Company one,
• Updating script to let Users with the selected Role to access the EP Preferences page,
• Error message is updated to give more information to Users about the new feature.

 

Version 2.02.18

BPA-EP enhancement to generate bank files after approval.

Note : To use the BPA enhancement to generate bank files after approval, ensure that the generate Bank File After Approval checkbox is checked on the BPA Configuration record, as well as the products listed below are in the stated version or higher.

 

Bill Payment Approvals
1.20.20  
Nolan Electronic Payments for NetSuite
2.02.18
Background Processing by Nolan's
1.00g

 

Version 2.02.17

Bug Fix :-

• Fixed issue on Missing BP lines on generated file

 

Highlights V2.2.17 (26/02/24)

Bug Fix:

• Fixed issue on Missing BP lines on generated file

 

Highlights V2.2.16 (05/02/24)

• Try-catch when setting the form to handle incorrect transaction type
• Fixing null-value error
• Order by default value is added
• Using dynamic mode to create payment in different currency than the vendor base currency
• Adding memo field update when bills paid seperately
• Fixing non-updating Vendor Credit address issue

 

Highlights V2.2.15 (10/01/24)

Bug Fix

• Fixed the issue with parsing and retrieving approval fields

 

Highlights V2.2.14 (30/11/23)

Hotfix

• Fixing payment voucher S/L for Non-Oneworld accounts

 

·       Highlights V2.2.13 (29/11/23)

Bug Fixing:

• A fix has been made to correct the sequence order of the created file
• EP Help buttons that did not work have been fixed 

 

·       Highlights V2.2.12 (10/11/23)

Fixing Multicurrency issue

Fixing Email Remittance Subsidiary issue

NOTE - EP Email Payment Voucher Loader - deployment needs to be updated during Bundle Update, this option is changed in the bundle

 

·       Highlights V2.2.11 (29/09/23)

Hoisting issue fixing

 

·       Highlights V2.2.10 (21/09/23)

** It's advised for users to perform update to 2.02.10 immediately if EP version is 2.02.09 **

Bug fixing

• fixing error in pay bills screen when user is paying bills using saved searches (Issue only happens in 2.02.09)

·       Highlights V2.2.09 (14/09/23)

Bug fixing

• fixing Bank Format Definition Export/Import issue when the Suppress column could not be imported

·       Highlights V2.2.08 (04/09/23)

·       Highlights V2.2.05 (18/08/23)

·       Highlights V2.2.04 (17/08/23)

·       Highlights V2.2.03 (11/08/23)

 

 

·       Highlights V2.2.02 (09/08/23)

Updated Email Remittance Slips:

• Added new checkbox to preferences 'Get subsidiary by role'
• Added a script to load relevant data, before forwarding to Email Remittance Slips

 

·       Highlights V2.2.01

Saved Search update, email fixing

• Saved Search is now available for all Customers
• email is sent if the 'AUTOMATICALLY SEND REMITTANCE EMAIL WHEN USIN GBILL PAYMENT APPROVAL' is set to TRUE (if Saved Search, the BILL PAYMENT APPROVAL not needed to be ENABLED)
• fixing the EMAIL REMITTANCE SLIP issue when the email field might be empty
• ability to customise the Remittance Email Subject and File Name 
• Enabling prepayment amount details to be shown in EP remittance record type. (Only supported when 'Cached Payment Information' is enabled)

·       Highlights V2.1.29

Allow remittance email subject and file name to be customizable

• 2 new fields added to EP Bank Account Setup record (see their help text for details about this feature)

·       Highlights V2.1.28

·       Highlights V2.1.27

·       Highlights V2.1.26

·       Highlights V2.1.25

Highlights V2.1.24

·       Highlights V2.1.23

 

·       Highlights V2.1.22

• Bug Fix - Corrected the Switch Case.

 

·       Highlights V2.1.21

• Updated the code(ncEP_BillPaymentsToProcess) with version which is updated on 03/11/2021 and corrected the condition

 

·       Highlights V2.1.20

• fixing missing addendum export/import issue adding SUPPRESS THIS COLUMN IF SELECTED COLUMN IS EMPTY

 

·       Highlights V2.1.19

• Bug Fix - SC45722 EP sequence number is not populating properly Nolan Business Solutions Inc (USA)

·       Highlights V2.1.18

• Fix issue when loading customer refund page
  Ref: SC45697 NSEP Customer Refund page changed Nolan Business Solutions Inc (USA)

·       Highlights V2.1.17

Issue arises when the field is encrypted.

• fixing issue to enable all the encrypted fields when the fields are decrypted.

·       Highlights V2.1.16

• Bug Fix - SC45407 & Previous - SC44800 Bank Details approval issue.
• SC45734 Vendor Credits and POs not auto populating EP Bank Details from vendor

Note :- While installing the updates, users must select preference as Update Deployments against the script EP Vendor Bill Client to override the existing deployment or else user have to manually deploy the script to vendor credit for enhancing the function of auto population of the EP Bank Details to Vendor Credit.

Edited

<https://teams.microsoft.com/l/message/19:3895075fcf1c45e28569e6ce202c3529@thread.tacv2/1675265254395?tenantId=677de11f-eaf8-45ce-9887-8e67b26ded5c&amp;groupId=0883fc2e-4d45-4d49-9a52-59fc359608d4&amp;parentMessageId=1675265254395&amp;teamName=Netsuite Bundle Release&amp;channelName=Nolan EP&amp;createdTime=1675265254395&amp;allowXTenantAccess=false>

 

·       Highlights V2.1.15

Process Restarter update

• handle cases when the process fails during execution - in any M/R script (apply credit, payment process, bank file generation), set the process state to FAILED
• Process Starter reschedule itself on error, setting the failing process state to FAILED

·       Highlights V2.1.14

Bank File Generation Bug

• Bug fixing, CSV fileType was set incorrectly to a number value instead of a string value

 

·       Highlights V2.1.13

Bank File Generation Bug

• fixing the issue when the File Type of the Bank file might remain undefined
• fixing issue when the Saved Search (custom S/S on the EP Payment Process screen) returns null or 0 as number for any transaction count

 

·       Highlights V2.1.12

EP Process Staring Issue

• the Saved Search used to find any instance of the apply credit or processing bill payment or bank file generation M/R script returns null when the bundle is updated, and these script has not run before.

 

·       Highlights V2.1.11

New EP Process Starter

• Scheduled Script (2.1) created to check if there is any instance in the queue
• bug fixing - custrecord_bgpfunctionname was set incorrectly to getInputData, changed to ncBGP_PayVendorBillsBG

 

·       Highlights V2.1.10

Pay Bills Screen

• Reinstated an accidentally removed search column, which in some case was preventing bills to pay from showing.

 

 

·       Highlights V2.1.9

Bank Details

• Publish previously missed fixes for Encryption Handling

 

·       Highlights V2.1.8

 

Field Encryption

• Correctly associate encrypted values with new records (CREATE operation), so it is no longer necessary to edit those records after creating.

 

·       Highlights V2.1.7

• Fixing the syntax error issue which was thrown when the returned value was null

 

·       Highlights V2.1.6

Encryption and Approvals

• Further resolution to conflict between encryption and approvals, for the specific case where no fields were selected in the EP System Preferences and the default approval field list was being used.

 

·       Highlights V2.1.5

Encryption and Approvals

• Resolve conflict between encryption and approvals, where decrypting the values to review them would then prevent approval.

 

·       Highlights V2.1.4

Encryption

• Additional source file relocated to Encryption Scripts, for correct runtime path.

 

·       Highlights V2.1.3

Encryption

• Change so that encryption will be applied on CREATE of new details, rather than only on EDIT.
• Fix "reference error".

 

·       Highlights V2.1.1 & 2.1.2

Encryption

• Resolve MODULE_DOES_NOT_EXIST issue due to bad path for ncEncryptionLibrary.js

 

·       Highlights V2.1.0

Encryption

• New tab added to preferences with encryption settings. Use the options in this tab to encrypt EP file and field data. Ensure that you create an API secret with a length of 16 characters first.
• See the attached document for more information.

Pay Bills Screen

• New option added to preferences "Use Dynamic Discount". This means that the paybills screen will calculate discount amount from the amount remaining to pay on a bill.

 

·       Highlights V2.0.10

Print Remittance Voucher

• Fix for NS defect - Can now define a form ID to use when printing remittance vouchers. This is a workaround for NS defect 4725691.

 

·       Highlights V2.0.9

PayBills Status Screen - *specific customer* Only

• Reverted back to the status screen showing the number of created payment records instead of the total number of bills + credits processed

 

·       Highlights V2.0.8

Paybills - *specific customer* Only

• Remittance data now stored in a file when over the 1-million-character field value limit
• Numerous performance enhancements
• Data split into batches is now configurable
• Script parameter on payment processing script deployment allows users to set their own batch size to correspond with their system needs

 

·       Highlights V2.0.7

Customer Refunds

• Fixed issue where client script for customer refunds was throwing errors due to file not being available to bundle

 

·       Highlights V2.0.6

Electronic Payments PayBills

• Resolved issue with record count not working correctly in Saved Search bank file generation
• Small bug fix where individually paid bills with no credits caused an error due to uninitialised variable

Files Changed:

• ncEP_GenerateBankFileMR.js
• ncEP_PaymentProcessingMR.js

 

·       Highlights V2.0.4

Bundle Components Fix

• NetSuite Electronic Payments components were accidentally included in our bundle. These have now been removed. Any site which uses both NetSuite EP and Nolan EP should update BOTH bundles.

 

·       Highlights V2.0.3

Generate Bank File

• Bug Fix for Suppress Column functionality - was previously unable to suppress "new line" columns, as saw them as already empty. Now handles them correctly.

 

·       Highlights V2.0.2

Background Processing by Nolans

Updated to V1.00e

• Added a new field "Data File". This holds a link to a JSON file in the file cabinet which EP uses to process Bills

 

·       Highlights V2.0.1

EP Pay Bills

• Sort saved searches a-z. (*specific customer* Only)
• Minor fixes around date formatting in map/reduce (*specific customer* Only)

 

·       Highlights V2.0.0

Versioning

• Version numbering changed to numerical only. Versioning will now be in the following format: 1.2.3 with 3 being minor changes, 2 being major changes, and 1 being total overhalls or equivalently large changes. To make the transition simpler, a new overhall change has been added to the version number.

EP Pay Bills

• New functionality has been added in order to process over 1000 bills in a single run.
• A new field has been added called "Use Saved Search as Criteria". This field displays all of the accounts saved searches of type Transaction.
• Selecting this field will use the selected saved search as criteria when finding bills and credits to process. The saved search will have certain filters applied to it regardless such as "Pay by EP = true" and "File Format not empty".
• When processing, new map/reduce scripts will be called to generate payments and bank files.
• This functionality is so far locked to *specific customer*. To be rolled out generally upon successful testing

 

·       Highlights V1.65y/z?

Bank File Generation

• Fixed a bug which was causing Sort Codes to be read incorrectly if the column was set to "Summable".

Files Changed:

• ncEP_LibraryScripts.js

NS to NCS

 

·       Highlights V1.65x

*specific customer* Changes for EP Pay Bills Additional Filters

Please Note this functionality is currently only available to *specific customer*

 

·       Highlights V1.65w

• Fixed issue with rescheduling script attempting to pay the same bill twice causing errors

 

·       Highlights V1.65v

• Pay Bills
• Resolved an issue which was causing selected bill payments to be skipped when processing individually.

 

·       Highlights V1.65u

• Fix for intermittent issue with File Generation after Bill Payment Approval, where it would omit the file header.

 

·       Highlights V1.65t

• Updates to Customer Refunds:
  • Changing a value in the "Payment" column should now update the total as expected
  • Remittance lines should now be populated when generating a payment file
  • The "Payment Ref" field has been applied to Customer/Cash Refund records and should now populate correctly
  • The "Payment Apply Fields" field has been applied to Customer/Cash Refund records to enable the use of the "Cache Payment Information" EP setting
• Payment Approval: The list of transactions should now filter by account correctly

·       Highlights V1.65s

• Payment list: changed to filter by the subsidiary specified in PayBill screen instead of the current user’s subsidiary.
• Email Remittance Voucher: removed a bug disrupting Email Remittance process when the email is not specified.

·       Highlights V1.65r

• EP Preference: removed a bug disrupting its display under certain conditions. 
• Vendor Prepayment payment file: added support for header section.

·       Highlights V1.65q

• Pay Bills by EP:
  • New Feature: Vendor Prepayment(s) created by the user (manually) in NS could be included in the generated bank file.
  • You will no longer be able to see bills with an inactive Vendor. This is to prevent errors when attempting to create payments for inactive vendors.
• Pay Customer Refund by EP: Fixed issue where header was not being created for customer refund files

·       Highlights V1.65p

• Pay Bill and Pay Customer Refund: Removed a bug which could disrupt payment/refund processing under certain conditions.

·       Highlights V1.65o

• Added field to Customer Refund page - "Refund Method (Customer Refunds Only)".
  • This will populate the "Refund Method" field on the Customer Refund record.
  • This field is populated by Payment Methods with a type of "Cash" or "Offline".
  • This field is defaulted to "Cash".
• Bill Payments - Added a number of logs for investigation into governance issues.
• PayBill – Vendor PrePayment: Display Payee name correctly.

·       Highlights V1.65n

• Pay Customer Refund by EP – A new suitelet page has been created to enable users to pay refunds using EP. This functionality works like the existing “Pay Bills by EP” screen but is instead tailored towards paying refunds. Only transactions with “Pay by EP” checked which also have a “File Format” will be shown. You may pay the following transition types:
  • Credit Memo
    • Only Credit Memos with a status of “Open” will be shown.
    • This will create a Customer Refund record.
  • Return Auth
    • Returns Auths with a status of either “Pending Refund/Partially Received” or “Pending Refund” will be shown.
    • If the system has the “Refund in Advance of Return” accounting preference checked then Return Auths with a status of “Pending Receipt” and “Partially Received” will also be shown.
    • You can currently only refund the entire Return Auth. If you attempt to change the payment value for a Return Auth a warning will display, and the value changed back.
    • Only Return Auths which are eligible for a cash refund will be shown.
    • This will create a Cash Refund record.
  • The process status page has been changed to accommodate these refund changes. A link to this page can be found under "Electronic Payments" -> "Transactions" -> "Pay Customer Refund by EP"

 

• Delete Payments - The "Delete Payments" suitelet has been updated to take into account the new refund payments. Cash Refunds and Customer Refunds are available to delete.

 

• EP Customer Refund User Event - nbsEP_CustomerRefund_UE.js - will be applied to Sales Order, Invoice, Return Authorisation, Cash Refund, credit memo, and customer.

 

• New EP Fields
  • Tran Body Fields:
    • custbody_ncep_paybyep: applies to SALE.
    • custbody_ncep_fileformat: applies to SALE.
    • custbody_paymentmethod: applies to Customer Payment.
    • custbody_epauditref: applies to Customer Payment.
    • custbody_ncep_paybyep: apply to customer payment.
  • Add a new tab to Customer Record - Bank Payments, applies all entity fields in Vendor>Bank Payments tab to Customer, which include: 
    • custentity_nbsep_bank_city
    • custentity_nbsep_bank_country
    • custentity_nbsep_user_defined_1
    • custentity_nbsep_user_defined_2
    • custentity_vend_bank_bic
    • custentity_nbsep_vend_bic
    • custentity_vpaybyelectronicpayment
    • custentity_vpaymentdefinition
    • custentity_vbankrefcode
    • custentity_vbankaccountnum
    • custentity_vreference
    • custentity_vpiban
    • custentity_nbs_ep_nacha9
    • custentity_dfi_id
    • custentity_checkdigit
    • custentity_ncep_accountnum_nz
    • custentity_nbsep_remittance_email
    • custentity_nbsep_review_vendor_bankdets
      
      
  • EP Preference
    • New field: Support Customer Refund Payment: checkbox. Tick this checkbox to support Customer Refund Payment.
    • New field:  custrecord_ncep_customerrefund_approval, checkbox. Tick to indicate that Customer Refund Approval process is in place. 

·       Highlights V1.65m

• New feature added: NSEP Enhancement multiple email remittance:
  • You can now send a single remittance email to multiple email addresses. To do this you can put several email addresses in the “Remittance Email” field on either the “Vendor” or “EP Bank Details” record separated by a “;”, for example: “nolantest1@nbs.com;nolantest2@nbs.com”.
  • Script has been updated to take out white space in the value retrieved from the email field. 

·       Highlights V1.65l

• Paybill Screen – LOCK BY list: Filter employee list by users with NS access.

·       Highlights V1.65k

• Payment File Format:
  • Added screen variable - ep_tranlinecount, recording the number of transaction lines in the payment file.
  • Added support for transaction line sequence number.
  • Allows adding up to two summary fields.

·       Highlights V1.65j

• A new option added into EP Prefernce-Show Account Hierarchy to allow Bank Account dropdownlist to display either long name with hierarchy or short name, depending on preference settings.

·       Highlights V1.65h

• File generation: allow the script to yield gracefully when the execution time exceeds 3500 seconds.

·       Highlights V1.65g

• Changes made so that in generated file, the vendor payment information would appear in the credit line, previously this was not populating this correctly in the credit memos.

·       Highlights V1.65f

• New feature added to allow processing of vendor pre-payments.

·       Highlights V1.65e

• Removed a bug causing filename error when a digital number included in the file prefix. 
• Reinstate Registration Key Check.
• Add option in EP Preference: automatically send out remittance email when using bill payment approval.
• Add option in EP Preference: show bill credit in pay bill screen if multiple bank details=

·       Highlights V1.65c

• At the end of payment processing if the user chooses to use 'NetSuite Check Number', check whether check number starts with “/”, if it does, update the check number with NetSuite next transaction ID.

·       Highlights V1.65b

• New field created - nbs_ep_nexttranid_v1.
• Changes made to CheckNumber fields.

·       Highlights V1.65a

• Added a new record type – ‘EP Fields to be added to Paybill screen’ into the new bundle (Please note that this item of work is customer specific).
• New list type created – EP Types of Bills in Paybill.

·       Highlights V1.64z

• Ability to suppress a transaction column if selected field is empty.

·       Highlights V1.64x

• Fix to format so that footers no longer populate in the last remittance line.
• Fix to remove failure message when processing approvals using inline edit with a saved search.
• Fix made so that when re-approving the vendor, the Bank Details:Pay by EP to be marked as TRUE.

·       Highlights V1.64w

• Cheque (check) numbers now populate using numbers in correct sequence.

·       Highlights V1.64v

• Pop up warning created disallowing the batch if Bill Credits for any vendor are greater than bills.

·       Highlights V1.64u 

• Electronic Bill Payments Screen bug fix so that Bills totalling less than $1.00 can be paid.

·       Highlights V1.64t

• Multiple Vendor Bank Details: Currency does not default Vendor Bill currency to value from EP Bank details
• Multiple Vendor Bank Details: Bug Fix when editing an existing Vendor Bill and using Vendor Select to select a different value the associated EP Bank details do not now disappear.
• Fix to remove filter error that appears in the script logs.

·       Highlights V1.64s

• Fixed linecount bug caused when Bill Payment is saved before the Payment scheduled script yields.

·       Highlights V1.64r

• Three more numeric fields added into bank details.
• EP Account Locks feature made optional.

·       Highlights V1.64l

• After payments have been generated only unlock the relevant account for which they have been made.

·       Highlights V1.64k

• From the “Electronic Bill Payments” screen do not start the process payments process if no bills are selected.

·       Highlights V1.64j

• EP File Format: Suppress field separators around NEWLINE.
• Fix for EP NACHA File Format:  Block Count is incorrect when there 6 transactions in the file.
• From The Pay Bills screen the EP Bank Account will be locked by the current user so that only one user at a time can process bills for this EP Bank Account.

·       Highlights V1.64i

• EP File Format - Suppress field separators around NEWLINE.

·       Highlights V1.64h

• New System preference “FILE CABINET TEMPORARY FILES FOLDER INTERNALID”

Enter the interlaid of the file cabinet folder that you created for storing temporary payment data.

If no value is entered, the folder used to store temporary payment data will be as the previous release.

·       Highlights V1.64g

• Better caching of Apply information when prior payments have been voided and credits reapplied.

·       Highlights V1.64f

• Updated handling of EP Audit Ref (specifically when Bill Payment Approvals is not present)
• Option to use NetSuite or own Cheque (Check) Number sequence is now available per Bank Account Setup
• New “Email From” user selection on Bank Account Setup, used when sending Remittance Emails.

·       Highlights V1.64e

• Defer allocation of file number until actual file generation
• Provide smoother UI refreshes on Pay Bills screen

·       Highlights V1.64d

• Fix issue for potential gaps in the file number sequence when using Electronic Payments with Bill Payment Approval
• Updated layout for Pay Bills screen, with ability to select EP Bank Setup (useful when two with the same account and format)
• Added Currency and Vendor Name to the field sources available for Remittance details.

·       Highlights V1.64c

• New entity field named BIC to store the Bank Identifier Code. A BIC is sometimes called a SWIFT code.
• New option on System Preferences named Vendor Bank Payment Fields to enable users to select the fields to trigger approval on entry/update of vendor bank payment details.
• New option on System Preferences named Multiple Bank Payment Fields to enable users to select the fields to trigger approval on entry/update of multiple bank payment details.

·       Highlights V1.64b

• Bug fix for multiple output files created using same file name
• Bug fix for transaction date set on bill payments when 1^st day of the month is entered as Date on Pay Bills screen.

·       Highlights V1.64a

• New feature to export and import a bank file format (Administrators only)

·       Highlights V1.63z

• Bug fix for Remove Attached File from Completion Email
• Bug fix for background processing of Bill Payment Approval
• Bug fix for background processing of email remittances
• Bug fix for conflict with third party SuiteApp

·       Highlights V1.63y

• Bug fix for NetSuite returning user ID in scientific notation (3.0882979E7) rather than as a number (30882979).

·       Highlights V1.63x

• “TypeError log.error is not a function” error resolved
• EP Scheduling Role unlocked in bundle to allow NetSuite 2019.1 “Subsidiary Restrictions” on role to be modified by account holder to ALL to resolve permissions issue.

·       Highlights V1.63w

• Permission issues fixed for “Email Payment Vouchers”

·       Highlights V1.63v

• SC32720 Bug fix: Modification of vendor bill client script to only execute for customers using 'MULTIPLE BANK DETAILS'.
• SC32089: New EP preference (NOTIFICATION NOT REQUIRED AFTER APPROVAL OF VENDOR BANK PAYMENT DETAILS) to suppress email sent when approving vendor bank details
• EP Bank Payment Definition: Change in 'S' text formatting option to replace invalid chars with ' '. See below for updated Help Text for Format

 

Updated Help Text for 'S' Format

Specify a format. Possible values:

   'U' - convert to UPPER CASE

   'L' - convert to LOWER CASE

   'N' - extract NUMBERS

   'A' - replace most common illegal characters with space

            Characters: @ ~  !   {   }   [   ]   *   “   ?   \   |   ^   ;  &gt   &lt

   'S' - remove all characters other than:

          (0-9, A-Z ,a-z and space)

          multiple spaces are replaced with a single space.

   'X' - outputs a single * character.

   '*' - output remaining string

   'M' - substitute HTML entity references for > and < characters

           with actual characters

            Character replaced

            HTML entity(& gt;) - Greater than (>)

            HTML entity(& lt;) - Less than (<)

   '&' - xml encode

            Character replaced

            Ampersand (&) - HTML entity(& amp;)

            Apostrophe / single quote (') - HTML entity(& apos;)

            Double quote (") - HTML entity(& quote;)

            Greater than (>) - HTML entity(& gt;)

            Less than (<) - HTML entity(& lt;)

   '^' - remove spaces

·       Highlights V1.63u

• Enhancement to query Pay By EP at Bank Details level before including bill payments not created by the Pay Bills in the output file, if Multiple Bank Details is enabled.

·       Highlights V1.63t

• Bug fix for process that queries if NetSuite Electronic Payments module is also installed.
• Large output files now persisted to the file cabinet.
• Improved script logs associated with processes that update vendor bills

·       Highlights V1.63s

• Bug fix for error associated with preference Use File Cabinet Location on Bank Account Record. If no location is defined on the Bank Account Record, the default location from the EP Preference Record will be used to store the output file.
• Bug fix for import of Multiple Bank Details records by methods other than CSV import.
• Field help for Format on EP Bank Payment Column record type has been extended to show options for text fields

 

Format	Action
U	convert to UPPER case
L	convert to lower case
N	remove all non-numeric characters
A	replace most common illegal characters with space
S	remove all characters other than alphanumeric (0-9, A-Z and a-z)
X	outputs a single character
*	output remaining string
M	substitute HTML entity references for > and <  with actual characters
&	xml encode
^	remove spaces

 

Illegal Characters:

Character	Character
@	“
~	?
!	\
{	|
}	^
[	;
]	&gt
*	&lt

 

            HTML References:

Character	Replaced with
&gt	Greater than (>)
&lt	Less than (<)

 

XML Encode:

Character	Replaced with
Ampersand (&)	&
Apostrophe / single quote (')	'
Double quote (")	"
Greater than (>)	>
Less than (<)	&lt;

 

·       Highlights V1.63r

• New Option “Do Not Mark All”, which will cause the Pay Bills screen not to mark all bills by default.
• Retrieve EP Preferences via Suitelet, for situations where current user does not have permission to read the preferences directly.
• When using Multiple Vendor Bank Details and approving a set of details, do not attempt to run processing on open bills if there are none.

·       Highlights V1.63q

• Bug fix for updating check number on a bill payment if NetSuite Electronic Payments is also installed in the same account.

·       Highlights V1.63p

• Enhancement:

Approve Bank Payment Details Recorded Against a Vendor

For example, a user enters new payment details or amends existing payment details for a vendor. Open bills for this vendor cannot be paid via the Pay Bills screen until they have been approved. Approvers for payment details are identified by role.

• New field, Require Approvals on Vendor Payment Details, applied to EP Preference record
• New custom entity field, Require Approval, applied to vendor record
• Approver roles are entered under the Parameters subtab on the script deployment EP Payment Details Approval
• Vendor bank details currently supported include Account Number, NACHA 9-Digit Number, DFI Identification and Check Digit
• Fix for issue for accounts upgrading to One World.

·       Highlights V1.63o

• If Multiple Bank Details is enabled, populate Electronic Payment details on vendor bills created by CSV import.

·       Highlights V1.63n

• Bug fix, when using early payment discounts from vendors, to ensure any discount entered is applied to the transaction
• When System Preference CACHE PAYMENT INFORMATION is selected memo and discount from the transaction will be added to the cached payment information.

·       Highlights V1.63m

• Bug Fix for Delete Payment error: ‘The field custrecord_bgplogmsg contained more than the maximum number (300) of characters allowed’

·       Highlights V1.63l

• Updated display order for files when mailing remittances (SC29913)
• Fix to search criteria for Multiple Bank Details (SC30050)

·       Highlights V1.63k

• New format mask ‘S’ to remove all non-alphanumeric characters from a text field
  • ‘U’ – convert to UPPER CASE
  • ‘L’ – convert to LOWER CASE
  • ‘N’ – remove non-numeric characters
  • ‘A’ – replace most common illegal characters with space
  • ‘S’ – remove all characters other than alphanumeric (0-9, A-Z and a-z)
  • ‘X’ – outputs a single * character
  • ‘*’ – output remaining string
  • ‘M’ – substitute HTML entity references for > and < characters with actual characters
  • ‘&’ – xml encode
  • ‘^’ – remove spaces
• Bug fix for check/transaction number generated by NetSuite not being set on bill payment if Multiple Bank Details is enabled.

·       Highlights V1.63j

• Bank Details record type has been extended and includes the following free-form text fields which may be used as source data for constructing a bank file.
  • Intermediary BIC (inter_bic)
  • Intermediary Bank Code (inter_bank_code)
  • Intermediary Bank Name (inter_bank_name)
  • Intermediary Bank Country (inter_bank_country)
  • Intermediary Bank Account (inter_bank_account)
  • Intermediary Bank IBAN (inter_bank_iban)
  • Intermediary Bank Currency Code (inter_bank_currency_code)
  • User Defined 1 (userdefined1)
  • User Defined 2 (userdefined2)
• System Preferences: New checkbox named Payment Approval exposed if the module Bill Payment Approvals is installed.

·       Highlights V1.63i

• Bug fix for calculation of total payment amount on Pay Bills page.

·       Highlights V1.63h

• Generate remittance information from applied bills/credits for output to bank instruction file when making a payment for a single bill. Previously, this functionality was only supported when making an aggregated payment applied to multiple bills.

·       Highlights V1.63g

• Department, Class and Location fields may be made Mandatory in EP System Preferences, affecting the Pay Bill screen.
• Credit Card accounts may also be used as payment accounts (previously restricted to Bank accounts).
• Vendor Bank Details now support Approvals, enabled from the EP System Preferences (dependent upon the Multiple Bank Details feature).
• Note: if also using Bill Payment Approvals, this must be upgraded to version 1.0p.

·       Highlights V1.63f

• Fix for blank lines showing in bank instructions file that include remittance details.
• New filed added to EP Bank Account Setup record type, Child Of (only impacts accounts with Bill Payment Approval installed)

·       Highlights V1.63e

• Bank Payment Definition: New fields, Block Count and Block Filler Row, added to support NACHA formats that require implementation of Blocking Factor.
• Bug fix for issue encountered in accounts that also have NetSuite Electronic Payments installed.
• Bug fix for field sourcing issue when creating vendor bills.
• Bug fix for issue in accounts that do not have Multiple Currencies enabled.

·       Highlights V1.63d

• Script deployments previously running using Administrator role now use dedicated role, EP Scheduling Role, with the necessary permissions only.
• EP User Role added.
• Deprecated script "EP Email Payment Vouchers Pre-Load" removed from bundle.

·       Highlights V1.63c

• Multiple Bank Details – New feature to support multiple bank payment details for each vendor to whom you want to send electronic bank payments. Bank details specific to a vendor address are created and associated with a vendor.
• To enable this feature, navigate to Electronic Payments > System > Preferences and check Multiple Bank Details. If Multiple Bank Details is enabled, at least one Bank Details record must be created for each vendor.
• Please note, payment of expense reports and vendor credit allocation is not currently supported for Multiple Bank Details.

·       Highlights V1.63b

• Improved error handling when processing payments

·       Highlights V1.63a

• Removed JESSIONID references in the bundle

·       Highlights V1.63

• Bug fix for Script Execution Usage Limit Exceeded when creating a single payment applied to 1000 bills.

·       Highlights V1.62z

• When using cached applied payments add “new line” to output for remittances unless this is the last remittance line on the last Bill Payment

·       Highlights V1.62x

• Generate payment reference from the references for applied bills/credits when making a payment in NetSuite and store in custom payment reference field
• Generate applied information from applied bills and credits when making a payment in NetSuite and store in apply fields custom field

·       Highlights V1.62w

• Blank lines being printed when no addendum fields in bank payment definition.

·       Highlights V1.62v

• Fixed duplicate rows being created for credits in the remittance.

·       Highlights V1.62u

• Minor fix for error when additional payments processed

·       Highlights V1.62t

• Allow inclusion of addendum fields when the EP Preferences setting ‘CACHE PAYMENT INFORMATION FOR USE ON THE REMITTANCE’ is checked

·       Highlights V1.62s

• Values from cached apply fields used in the remittance can be transformed to another value using a lookup for the specific value

Example:

type field containing either vendorcredit or vendorbill

Add the following to the EP Field Source Defintion for this field in the expression field

{"vendorcredit":"CM","vendorbill":"IV"}

vendorcredit and vendorbill will be transformed to CM and IV respectively

 

Configuration for EP Field Source Definition

Field Source Type : NetSuite Data Field

Data Source : apply

Data Source Field: type

Expression ; {"vendorcredit":"CM","vendorbill":"IV"}

• The original date for the bill or credit transaction is now available on the remittance

trandate for a bill or credit will be be added to the 'apply' cached data

trandate can then be made available in an EP Field Source Definition

 

Field Source Type : NetSuite Data Field

Data Source : apply

Data Source Field: trandate

 

·       Highlights V1.62r

• New Preferences Setting to allow payment information to be stored so that it can be later made available on the remittance
• The following fields can be used on remittances when the ‘Cache payment information for use on the remittance’ settings preference is checked:
  • Date Due
  • Type
  • Ref No.
  • Amount
  • Amount Due
  • Payment
• Each of the above fields can be made available on the remittance by creating a new EP Field Source Definition
• The Field Source Type will be set to NetSuite Data Field and the Data Source to apply
• The values of the Data Source Field will be as follows:

 

Screen Name	Data Source Field Value
Date Due	duedate
Type	type
Ref No.	refnum
Orig. Amount	total
Amount Due	due
Payment	amount

 

·       Highlights V1.62q

• Change to use correct Host header value when making server calls to Suitelets.

·       Highlights V1.62p

• Modified saved search EP.Open.ExpRpt.INTERNAL and added criteria Billing Status = Open

·       Highlights V1.62o

• In the Remittance, Credit Notes applied to Bills will show the amount applied to the Bill as a negative amount.

·       Highlights V1.62n

• In the Remittance, Credit Notes applied to Bills will show the amount applied to the Bill and not the full amount of the Credit Note