And then you can have 2 fields: IBAN, SWIFT/BIC. if the bank it's an EU bank then it should work

Hi, do you have EMEA templates such as SEPA? Crossborder it's really similar to SEPA, just small modification such as: the currency (that can also be different than EUR): In this case I would set subsidiary base currency + subsidiary used bank account currencies (or create 1 template for each currency so that it will…

Hi, you can PERSIST the CSV if this task it's an on demand task. If you want to do this with a specific schedule then you need to build a small scheduled script that it's converting the saved search results into a CSV file and saving it into the file cabinet. I'm using this strategy each time that: A file to be created…

Hi, of course you can create cross border payments in Netsuite. Here in EMEA it's really typical. An example, could be SEPA. That said, the file created will be an XML since everyone in EU it's adopting an ISO standard. Also, potentially you could create a CSV file using formula to format fields as needed in the import…

Sorry NS Chabdrasekhar but I'm still not understanding what was the issue related to the original code. I'm more insterested in understanding the "unexpected error" reason than the code.

Ok thank you very much for your explanations. Probably the chart structure is saved in a session related record

The first 1 have no sense in a Netsuite perspective. Which error are you getting? Try dividing the issue. Start using only this: to_date({custbody_quote_complete_date}, 'YYYY-MM-DD hh24:mi') Then try the second part:to_date({trandate}, 'YYYY-MM-DD hh24:mi') then the difference and then the multiplication P.S: I also…

<span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">I think you copied and past from that article but the article was generic PL SQL<br/>Try this</span> <span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color:…

It's a native behavior when using sourced / filtered fields. You have To store the previous values and try to set it again.

We have a bundle which contains a configurable sched script which allow you to delete all results of a saved search, including files related saved search

Sorry, I didn't understand your answer. Was the problem related to the variable name called file?

Have you tried debugging the script and comparing the 2 Netsuite Object (when it works and when it not works). Which method did you use for diff the 2 records?

Use a formula: Please have a look here https://stackoverflow.com/questions/9488475/how-can-i-get-the-difference-in-hours-between-two-dates