Hi GPUG Community,
We are currently on GP2013 R2, and I have a question when using the Bank Transaction Entry window (Financials -> Transactions -> Bank Transactions). As part of the improved functionality of GP2013 R2, we are able to copy and paste from Excel into the General Transaction Entry window, however I do not see this functionality present with Bank Transaction entry window. I would like to understand if this functionality exists and whether I have just not located it or if there is another best practice for the entry of larger Bank Transaction entries?
You're not missing it, the copy from Excel feature is only available for the General Ledger. One possible workaround for a large Bank Transaction is to enter it as a General Ledger transaction and use a Suspense account instead of cash. Then enter a 2 line Bank Transaction that simply hits Cash and Suspense.
Thank you! I appreciate your confirmation of my question and suggestion for an alternate approach to help us with these transactions.
As part of our AIT (Advanced Intercompany Transactions) add-on we added the copy/paste from Excel to the PM Transaction Entry window (in addition to adding functionality to the GL copy/paste). We had not considered adding it to Bank Transaction Entry, but that is a good idea and we will put it on the list of feature updates for release some time in 2016.
We use integration manager to upload bank transactions. Once it's set up it's easy for the user to enter the trxs in excel and then copy/paste them into the template.
Do you have a template to share for the bank transaction integration?
Within Integration Manager there are sample integrations. Once you find the example for Bank Transactions you will see that it is made up of 2 files > A header and a detail file, with an Index number on each file that will be used to link the data from the 2 files together. I recommend creating a new integration that matches this one (I never change the original, lest I mess it up and then can't get back to how it was before I messed with it). Then, create the 2 files with the exact same column name headers and populate it with your data. NOTE: I always keep an excel version of my file first - as it is easier to work with, but then I save them down to a Text-Tab Delimited version and those are the ones that I have l linked to my integration.
I have attached samples of the 2 excel files that I use as a base for my integrations.