External Supplier check payment file auto Creation

Hi, 

May I ask, … What business requirement are you looking to solve?  I’ve worked countless of clients and have never attempted to do what you're trying to do?  We may have different proven methods to solve the business need. 

Best regards, 

Thomas

Hi Thomas,

Thank you so much for the response,

My client needs to generate a supplier check payment csv file as soon as a check is created through a supplier payment order. without executing the new external file template through external file assistant wizard.

Kind regards!
Niyo

Hi, 

What is the business requirement?  CSV is a way to solve a business requirement. 

I’m guessing the business requirement is either positive pay or outsourcing the supplier check. Both are very common requirements in NA. 

For positive pay, we create a file (often CSV) at check printing. The purpose of the file is to allow the client to create a positive pay file that is then sent to the bank. The bank then uses that file as a security / anti-fraud mechanism. 

The other common reason for a file is outsourcing the supplier check payment to a bank. In this we send the bank the entire check data including remittance data where the bank then uses that data to create and mail the checks to a supplier. Bank may also initiate an ACH payment to the supplier. 

Those are two very different business requirements. 

I suspect that your client may wish for positive pay.  To do positive pay you set up the positive pay process.  This is a positive pay file type (already in IFS) you then copy the template.  The positive pay file template is attached to the basic data pay document basic data for supplier check.  If doing positive pay, it’s highly recommended to start manually, then associate the template to the basic data for the payment document.  

It still would be nice to know the business requirement - reason for the CSV. 

Best regards, 

Thomas

Hi Thomas,

yes the option two is the one customer is looking for ,

“The other common reason for a file is outsourcing the supplier check payment to a bank. In this we send the bank the entire check data including remittance data where the bank then uses that data to create and mail the checks to a supplier. Bank may also initiate an ACH payment to the supplier.” 

The thing is my clients output temple data requirement is bit more different than what IFS provides, So I had to create a new custom view to accommodate those requirements 

Kind Regards!
Niyo

Kind Regards!
Niyo