Need additional files created during check printing process

We would like to create a process within Sage that will allow us to create a secondary run of the Check Printing process.  The result of running the process is to create PDF files of each check, and at the same time, generate a file containing the data of each check.  The data required is Company ID, Check Number, Check Date, Check Amount, Vendor ID, Vendor Name and check PDF file name (likely check #.pdf, i.e. 32465.pdf).  An example of the data file is as follows:

 

GLR,32465,5/15/2017,2585.34,TDSMET, TDS Metrocom,c:\checkimages\32645.pdf

 

We are looking for a single PDF per check and either a single comma delimited data file for all checks or a single comma delimited data file for each check. 

 

Sage Support suggested that I post this here for advice or assistance. 

 

  • 0
    For the file we created a .Net program which reads the tables and creates the positive pay type of file you are describing. Our user enters in the batch number and it creates the file. This is not particularly difficult and your reseller should be able to help you if you don't have someone on staff. I wrote ours from start to finish in a couple of hours. The PDF is a little trickier. You could try printing to a PDF printer then printing the PDFs on to your check stock. I'd recommend talking to your local printer dealer (Xerox, Ricoh, etc.). I'd bet they have a document system which would handle this. I'm guessing a simple system is 5kish.
  • 0 in reply to JohnHanrahan
    You might want to look at using either Vineyardsoft's KnowledgeSync (Sage Alerts & Workflow) or another Business Activity Montioring (BAM) tool like TaskCentre. The BAM application could create the individual PDFs and either create the Positive Pay file, or append to the native Postive Pay file that can be generated within the Process Invoices for Payment task in 500. You would need to modify the 500 spapPopulatePosPay stored procedure to modify the layout of the Positive Pay file.