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:
SELECT
ORPSTDDT
,ORDOCNUM
,TRXAMNT
,SOURCDOC
FROM
NCABR012
Once the data has been extracted it can be imported during the demo using the standard ABR Import Statement routine.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
1 thought on “Extract ABR Transactions For Import As Statement”