RE: A/P ACCOUNT RECONCILIATION

We are 6.0.02 c/s, Mar'98 cum on AS/400 running V4R4M0.

We receive all our cleared checks from the bank in an Access data base.  I
have written a process to upload this to the AS/400, reformat the data,
update the status code to 'R' in the AMH & ABR files, populate specific
fields in AMH, & print two reports - ie. checks cashed & checks outstanding.

The process on the P/C side involes a call to the bank to download the data,
export the Access data to a text file, & upload the text file to the AS/400.

Process takes all of 10 or so minutes once a month.  It works, it's manual
on the P/C side, & I have other higher priority projects to work on so
manual it stays.

Any questions, you an contact me directly.

Dennis Munro
Badger Mining Corporation
dmunro@badgerminingcorp.com
(920) 361-2388 

-----Original Message-----
From: Chick Doe [mailto:Cdoe@barton-instruments.com]
Sent: Tuesday, July 25, 2000 6:09 PM
To: BPCS-L@midrange.com
Subject: A/P ACCOUNT RECONCILIATION


WE ARE ON BPCS VERSION 6.04 MIXED MODE.

I KNOW HOW TO GO THROUGH THE ACP710 PROCESS TO MANUALLY ENTER A/P CHECKS
ONCE THEY CLEAR THE BANK. THIS REQUIRES THAT EACH CLEARED CHECK BE MANUALLY
KEYED INTO BPCS. WE WILL SOON BE GETTING OUR CLEARED CHECKS FROM THE BANK
VIA AN ELECTRONIC FILE. DOES ANYBODY HAVE ANY EXPERIENCE UPLOADING CLEARED
CHECKS AND AUTOMATICALLY UPDATING THE BPCS A/P FILES RATHER THAN MANUALLY
KEYING EACH CHECK?

CHICK DOE
BARTON INSTRUMENT SYSTEMS

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---