Automating BAI uploads in Workflow
Hello OneStream Community,
Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application.
1. BAI Parser &...
Forum Discussion
We are currently trying to configure the BAI Parser and running into some issues with it. We found that it is not pulling in any of the transaction data, and it is not adding the decimal, so all of our amounts are off. Did you have to do some configuration outside of what OneStream has in its guide?
As for transaction data, did you map the BAI fields (FH,GH,AH,TH,AT,GT,FT fields) to attribute fields on your BAI data source? I did get transaction data for 95% of my initial test file. There was a small percentage not loading transaction level BAI data, but my source system for BAI files is still working their file formatting, so I chalked it up to that for now. When my source system starts sending me finalized BAI files I was going to recheck. But since you seem to be having that same issue it might be an OS issue.
As for amounts and the decimal place, yes the decimal was missing for me as well. So that might be an OS issue. This is a first for me dealing with bank BAI files, so I was not sure if that was a normal BAI format. Like amount lines all coming in positive with DR/CR indicator.
Because I can't get finalized BAI files from my source system I have stopped my BAI Parser effort at this time, but I'd still like to hear how your effort goes. And happy to provide help if I can.
We mapped all the BAI fields that our business's use. It's parsing the data but appears to be missing some of the data. We can look at the BAI file and see the transactions detail that it should be pulling in but is not. We can also tell by the type codes in OneStream. The decimal place issue is just strange. I do have a ticket open with OneStream support to look into this and see if they can provide any more information about configuring the BAI Parser. I will reply back once I hear something from them.
I've been working on a BR to replicate the BAI Preview Upload/Import into Workflow delivered functionality. I've somewhat reverse engineered BAI Preview to see what it's doing and code it's calling. It's proving pretty difficult to replicate that same functionality in a custom BR.
Have you had any success with a custom BR to replicate BAI Preview?