automate - 300+ customers need to be autopay a few days after the invoices go out.

I have a client that bills once per month.  I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 

300+ customers need to be autopay a few days after the invoices go out. 

I want to automate by creating a cash receipt import…I am wondering if this will work.  I realize that Paya runs the credit card at the time the invoice is created. 

Are there special steps needed to make this happen

How to automate this?

Parents
  • 0

    I assume you mean you have a UDF check box. You would need to export the Customer Master File and import into Invoice Data Entry.  All very simple steps.  Automating has many options.  I would create an Access database to pull the table, create the import file and then call the VI job and import.  You would put the Access database in a Windows Scheduler to run once a month and code the database to run the code when open and close when finished. 

  • 0 in reply to BigLouie

    I am sorry I did not get back to you sooner.  I am now back to this.  I will create the access data base and see how it goes.  Thank you for your help...may I reach out to you if I need additional guidance?

Reply Children