Sage 100

Has anyone ever produced or seen an enhancement that creates a PIF from Sage 100?  U.S. Bank wants to take over A/P Payment processing for a Sage 100 account and is asking for Sage 100 to output a csv file with all of the payment details.

------------------------------
Steve Engmann, MBA, CMA
DSD Business Systems
Appleton, WI
o: 800-627-9032 x-126
m: 920-428-2806
------------------------------

@Doug Higgs??

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

We did one for Bank of the West (now BMO Harris).  The Sage 100 customer prints checks to a file.  They then run a Crystal report that reads the Sage 100 check history.  They export the report to a delimited file format that gets uploaded on the bank's portal.   

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 01-12-2024 18:16
From: Phil McIntosh
Subject: Payment Instruction File (PIF)

@Doug Higgs??

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------

Invoice Payment Selection Register Report Setting?

---------------------------------
Bob Pfahnl
Manager - Silicon Valley
DSD Business Systems
---------------------------------

We typically use an ODBC VBScript for this kind of thing, from posted payments.  (Prompt for bank code / check date, or source journal / ref #, then loop through results and output to text file).

If you can get a working Positive Pay export with all the required fields, your users will probably find that easier to work with.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------