We need to begin pulling data from AP for our bank to use in their check anti-fraud system. Is anyone doing that now? If so how?

We are doing this. I have a query set up in A/P that gives me an output of Bank account number, Check #, Check Date, and amount. My requirements are Check # and Check date which you can change each time checks are printed. The query is then exported to Excel and set up per the banks requirements. The bank should give you this information on how they require the file to be sent to them. We send our file each time actual checks are printed via the banks secured web site as a text file.

We are doing pretty much the same thing, except in my query I have a filter to NOT list checks that are voided. Been working pretty well so far.

We have been uploading this information to our bank for almost a year. The bank only pays checks that have been entered into their system. In AP 7, we use an export to put the data into the .csv format that our bank requires. (Query created duplicate information for checks that paid more than one invoice.) This works pretty well, but there is some formatting required. The one item that will not export from AP is the bank account number, it gives me the bank account name which I manually change to the number. (This is something BB may fix in a subsequent release.)

We will be implementing Positive Pay soon. I am setting up a query in A/P to export the check amount, date and number to a text file. Is there a way to remove the dollar signs and decimal points in the check amount and remove the slashes in the dates?

I did not find a way to get the system to export the information in exactly the format my bank needs, so I edit the .csv file in Excel before importing to the bank. You may find, as I did, that export works better than query for creating your file because if you paid, for example, two invoices with one check, query listed the check twice.

If you export it into a .csv file and read the file in Excel you can use the Text to Column feature in the Excel Data menu to convert the column with the dollar signs to numbers and then format it how you would like. For the dates if you need to separate the dates into separate fields and the cell is text you can use the left(text,n), mid(text,start position,n) and right(text,n)functions.

If you export it into a .csv file and read the file in Excel you can use the Text to Column feature in the Excel Data menu to convert the column with the dollar signs to numbers and then format it how you would like. For the dates if you need to separate the dates into separate fields and the cell is text you can use the left(text,n), mid(text,start position,n) and right(text,n)functions.

A company we work with a lot, PalmettoTech, sells a Positive Pay fraud solution that is plugin for FE. The website is: http://www.pos-pay.com