Hi All, I need to update a Payment File Format in ...
# general
d
Hi All, I need to update a Payment File Format in bulk (for vendors). I can’t find this option on the CSV. If I do it via mass update, does it require a script? Or can be done with the mass updates that are already existing in NS?
s
I have a lot of questions to be able to guide you properly. For a mass update it needs to be changing the data of a field for another, the fields available depends on how you have your field configured. What do you mean your payment file format?
d
Hi Sandra, thank you for your reply. The field I need to update is sitting under the custom record called bank payment information. The “Payment File Format” field needs to be updated from “Finnish Foreign Transfer” to “Danish Foreign Transfer” for all the vendors that have Finnish foreign transfer format under their bank payment information record. I hope this will clarify more but happy to get into more details if needed. Thank you!
m
To update by Csv Import type : custom record Record type : bank detail
Or use a scheduled WF if you want
d
Hi, thanks for your response. On the CSV with the suggested import and record type there is no “payment file format” option to map. Could it be because the field is hidden? And I am not able to change the display type to normal on the custom entity field, there is no EDIT button…((
Changed the form to the Standard one on the advanced options and it worked! Genius!! Thank you again!
🔥 1