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
sandra
04/03/2023, 4:33 PM
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
Daria
04/03/2023, 8:14 PM
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
Marc
04/03/2023, 9:12 PM
To update by Csv
Import type : custom record
Record type : bank detail
Marc
04/03/2023, 9:12 PM
Or use a scheduled WF if you want
d
Daria
04/04/2023, 9:53 AM
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…((
Daria
04/04/2023, 10:03 AM
Changed the form to the Standard one on the advanced options and it worked! Genius!! Thank you again!