Updating Vendor Payment Methods Via CSV (BC365)

the plugin allows users to update their vendor payment information in bulk via csv without having to manually change each record keep in mind that information stored inside native bc365 cannot be updated in the plugin functionality this functionality has two parts export, to export all the current records, and import, to change all the vendors needing a change fispan strongly recommends exporting first before importing this will confirm that the csv is structured the proper way step 1 navigate to the payment methods page from anywhere in business central, you can navigate to the payment methods page click on j p morgan pay and then payment methods to begin the export and import process step 2 export click export csv to create a csv export file for all vendor records this csv file is structured in a specific way required by the importing process do not modify any of the column names, order sequence or structure the import from bc365 triggers a minimum of one row of data there are three different data types bank account each vendor with a bank account creates a row with a data type of bank account , allowing you to modify the vendor’s bank account address each vendor with an address record creates a row with a data type of address , allowing you to modify the vendor’s address email each vendorwith an address record creates a row with a data type of email , allowing you to modify the vendor’s email we suggest saving a copy of this file or your records and to provide an easy way to import back the original file if necessary! step 3 import once you have exported the existing vendor bank information, create the import file with your revised vendor bank information by editing the data and creating new rows if you are adding new vendors do not remove any of the column headers or add additional columns or the import will fail prepare the file for import each of the three data types require specific data fields use the existing records as a guide to which columns require data and be sure to follow the general rules to avoid errors preventing a successful import bank account to add a new bank account, add a row and enter bank account in the data type column do not fill in the email or address fields and fill in the other columns following the guidance from the table below address to add a new address, add a row and enter address in the data type column do not fill in the bank account or email fields and fill in the other columns following the guidance from the table below email to add a new email , add a row and enter email in the data type column do not fill in the bank account or address fields and fill in the other columns following the guidance from the table below only one line entry per vendor can have the is default account set to "y" enter the default payment method for the default account address record populating the csv table you need to use specific default payment method code values for each of the payment rail types since only one entry per vendor can be the default account with a default payment method, there any rules for which payment method is compatible with each data type here is a complete list showing which payment rail types are supported by each data type use only the payment rails supported by your bank plugin for this specific vendor navigate to plugin → payment methods and check in the table which payment methods are listed for a vendor data type compatible default payment method(s) for this data type other rules bank account ach ach next day cpa bacs sepa wire eft au wire au eft sg wire sg wire nz eft nz wire za eft za international wire international ach uk fps leave the email and address fields empty address check leave the bank account and email fields empty email vcc leave the bank account and address fields empty csv file table columns column name allowable values (case sensitive) notes data type one of bank account address email for bank account , leave the email and address fields empty for address , leave the bank account and email fields empty for email , leave the email and address fields empty id internal id leave empty if adding a new payment method do not modify value if modifying existing payment information erp vendor id bc365 vendor id do not modify this value, protects against duplicate records vendor name bc365 vendor name is default account y/n can only have one default (y) per vendor all other line entries must be n default payment method please confirm that they are in capital letter e g , ach, ach next day, check, international ach, international wire, sepa, vcc anything from the list of available payment methods to see what is enabled on the vendor, navigate to plugin → payment methods and check the table to see which payment methods are listed for that vendor if you would like to add some payment methods to the plugin, please contact your banker is editable y/n for any new lines, please enter as "y" do not modify an "n" and change it to a "y" for any existing records doing this may break the import email addresses any email addresses, up to 5 separate each email address with “,” country iso alpha 2 country codes https //www iban com/country codes this field accepts upper, lower, and mixed case values please enter in the iso alpha 2 country codes format the import will error if user enters full country name, i e new zealand currency currency codes https //www iban com/currency codes please enter currency following the currency code list this field accepts upper, lower, and mixed case values account type checking or savings this field accepts upper, lower, and mixed case values account number vendor's account number institution number vendor's institution number transit number vendor's transit number routing number vendor's routing number bank code iban two letter country code, followed by two check digits, and up to 35 alphanumeric characters bic vendor's bic or swift code for the country and bank bank name anything address line anything address line 2 anything address city anything address state province anything address postal code anything local branch code valid branch code for this bank use this field for bsb codes if country requires it payment purpose message anything payment purpose code valid purpose code payment payment iso code valid sender country code payment payment codeword valid receiving entity codeword payment payment party type p, t, g, n p = parent, t = subsidiary, g = group, n = non related payment residential status resident, nonresident sort code valid sort code for this bank importing the file once the file is ready, select import csv attach the file that is ready to import and enter one valid email address to receive a status update you are not able to modify this email address after clicking import , so be sure to add the correct one once the file has been uploaded, a checkmark confirmation message will appear wait a few minutes to get a status update via email once the import status changes, you will receive an email notification this email notification will let you know if the import has been successful there are 3 options 1 import is successful! 2 import is successful but there are line errors if there are errors, the notification email will have an attached csv file listing the errors correct the problems and resubmit the import file if a row has an error, none of the information present in that row will be updated if you use the attached csv file to resubmit the import data , you can leave the error column and make the required changes 3 import was not successful this may be caused by internet issues or if the file format is not respected please check your internet connection, review the line item data formats and refresh the page to try again contact support if the import still contains errors and the remedy is unclear example of import this file shows an example of what the import file can look like for one hypothetical vendor in bc365, when you select the vendor, it shows the new bank account has been added when you open up the bank account, you can see the values match the import potential errors errors explanation solutioning data type must be bank account or email or address data type was not filled in always include a data type, this is a mandatory field vendor id must be filled in vendor id was not filled in always include a vendor id, this is a mandatory field default payment method must be of a valid payment type default payment method was not correctly filled in ensure your account has this payment method enabled email addresses contains email(s) with an invalid email format email addresses format was not respected follow the following format something\@email com you would like to add multiple email addresses, confirm they are comma separated like so email1\@email com , email2\@email com both country and currency must be filled in country and currency both needs to be filled in country contains invalid country code country code is not valid select a valid country code from this list iso alpha 2 country codes https //www iban com/country codes currency contains an invalid currency code currency code is not valid select a valid currency code from this list currency codes https //www iban com/currency codes