Re: 6.00.04 A/P Payments other than Checks

["Rouse, Steve" <Steve.Rouse@xxxxxxxxxx>]

Thanks Brian, 

Does this BPCS process for these ACH payments update the Invoices as being paid in the BPCS system like the normal AP checks?

Steve

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Brosch
Sent: Wednesday, June 08, 2011 5:16 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] 6.00.04 A/P Payments other than Checks

We are doing this on V2.1(Haha, I know) but for the most part it's done outside the system. A lot depends on which output your bank is willing to accept. The professional standard is a NACHA file format, though our bank also accepts .CSV, which is what we are using. 

What I do is have AP process the ACH payments, and then I run an excel query that downloads the data relative to those payments. A separate database contains all of the necessary banking info which I have linked to via excel query as well(We didn't want to pay to have the fields added to BPCS). This process takes about 20 seconds to run. A macro then creates a CSV file & saves to the network for backup. upload to bank and I'm done. This process is much faster than writing checks, gets outside employees expense reports paid 3-5 days faster than a check would, and saves them a trip to the bank.

As for the security issues, In a corporate setting these days, most banks are now requiring a pseudo random number generator called a Token in addition to login credentials to input a transaction, and then another individual has to login with their Token to authorize. It would be next to impossible for a cyber thief to reverse engineer the controls needed to input & authorize a transaction. If anyone gets burned by a fraudulent transaction with the tokens in place, they need to take a serious look at their internal controls, as a daily review of all pending debits to the account will show the fraudulent transactions in time enough for them to be stopped.

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Rouse, Steve
Sent: Wednesday, June 08, 2011 1:10 PM
To: BPCS ERP System
Subject: [BPCS-L] 6.00.04 A/P Payments other than Checks

We use are on BPCS Version 6.00.04. To date, we have only made our Vendor Payments using checks.

We would like to explore using ACH payments (we create a file to send to 3rd party ACH company) if the programming is already in BPCS.

I know we can set up a new vendor type in the Vendor Master such as E for EDI. We would need the payments to Post in BPCS the same as the current check run. Does anyone know if this easily attainable in BPCS?

Thanks
Steve