Financial Connectivity Plugin Process

Hi all – This involves the new Financial Connectivity Plugin that was recently introduced in 20.1

Basically the plugin is used for automating banking statements from financial institutions to your NetSuite account. This is a major feature as this allows you to do this for banks that are outside the US and Canada. Unfortunately there’s not a lot of helpful documentation out there so I’m a bit stuck at the moment.

Here’s where I got to.

I’ve managed to get this working for one of our banks here in Australia. I’ve created the plugin script, connected to the sftp server of the bank, pull in BAI2 files, mapped the transaction accounts, and ran this successfully. This happens automatically daily.

The confusion I have here is how it will work if I have multiple BAI2 files. The getTransactionDate function has a context object that would call

context.addDataChunk({dataChunk: chunk});

The chunk just holds the value of the BAI2 file. My issue here is if I call it multiple times, since I have multiple BAI2 files against one format profile in a day, it only processes the first one.

So if BAI2-1, BAI2-2, BAI2-3 contents were all sent to the addDataChunk, it will only process the BAI2-1 on the import bank statement page (where users can use to match bank data). Not sure if I’m missing a step here but if anyone has any ideas, I’m all ears.

Rookie Asked on July 15, 2020 in SuiteScript.

Hi Katrina, I’ve got a couple of thoughts here:

  1. When you say “chunk just holds the value of the BAI2 file”, is that the string contents of the file? Could you share the code that is setting chunk?
  2. It may not get to the heart of the issue but I’m wondering whether you could group the data before you send it?

Thanks, Chris

on July 15, 2020.

Hi Chris,

 

  1. Correct it’s the string contents of the file. It’s literally pulling the values from a BAI2 file as a string and setting it there. the addDataChunk function is from NetSuite’s financial connectivity plugin
  2. Yes, I’ve tried that as well and it will just error everything out

I’ve been using NetSuite’s standard parser for BAI2 – I think that might be the issue. I’ve verified that the values of these 3 files are being sent to the parser but it seems to be able to only handle one. Unfortunately its locked and can’t be edited or viewed and I’d rather not have to go down the path of creating my own BAI2 parser.

on July 15, 2020.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor