One of my first customers recently had their checks stolen out of mailboxes and names and amounts changed. They want to implement positive pay and do not have VI. I suggested using Excel with ODBC link to create a csv formatted positive pay file. They are on Sage 100 v2015 (5.20.2.0) and use the old payroll module (why they are on that version), so I assume they will need two files.
Before I recreate the wheel... my thought was to have a query with a parameter for the date (or date range) for the information for checks to be pulled for. Very simple file
| Account Number |
| Check Serial Number |
| Dollar Amount |
| Issue Date |
| Issue/Void Indicator |
| Payee |
Is there a single file in Bank Rec or do I need to pull from 2 files?
Am I going down the right path?
------------------------------
Gary Feldman
Cloud Evangelist
I-Business Network, LLC
------------------------------