Configuring Nolan’s Advanced Bank Reconciliation (ABR) to automatically extract transactions when reconciling a bank account is not complicated, but I keep on forgetting where the option is located. That gets a little embarrassing when you tell a client, “yes, you can do that” and then have to spend five minutes looking for the option.
So by writing it down here, I am hoping to be able to commit it to memory.
this option is per bank account and is located on the Bank Account Setup window (
Click the Options menu and then select Extract options:
Continue reading “Setting Bank Account In ABR To Extract Automatically In Reconcile Bank Transactions”
this is a simple script, but I’ve written it about four times now so I figured I’d post it so I can find it easily next time I lose my local copy.
Perfect Image are resellers of the Advanced Bank Reconciliation module from Nolan Business Solutions (along with the other add-ons they’ve written for Dynamics GP) and I often need to demo this replacement for the standard Bank Rec module.
One item I typically show is the auto-Propose function which matches transactions against statement lines in the Reconcile Bank Transactions window ( ).
To do this I need to be able to import statement lines which match the transactions in Dynamics GP; the easiest way of doing this is to extract the transactions.
This can be done with a very simple SQL script:
Once the data has been extracted it can be imported during the demo using the standard ABR Import Statement routine.