Fellow users,

I asked the following question to System 21 support and was told that there
is no documentation available. So I turn to you, can you help.

We are in the process of automating check reconciliation. We have
determined that we need to get the data into the file BANKFILE. We will
then use option 81/CSR, 1/CSR and 3/CSR to complete the process. BANKFILE
will be cleared with each fresh upload. We have some questions about the
use of some of the fields in this file (BANKFILE) to make sure we properly
load the data. Below is a list of the fields in the file and our
understanding of the data that needs to be contained in field. Some we are
not clear on. Please advise on questions or incorrect understanding.

SORTCD -- No idea what this is looking for.  It apparently is used for the
key to chain to CSP60, however we have no data in this file
ACCNO -- The bank ID as found in CSP11
ACCTYP -- Not used
TRANCD -- No idea what this is looking for.  It apparently is used for a
key to file CSP61, which again, we have no data in this file.
OSORT -- not used
OACCNO -- not used
OREFNO -- not used
AMOUNT -- amount the check was cleared for
NARR1 -- Bank account no.  ????
NARR2 -- Check no. ????
NARR3 -- not used ????
DATE -- Date the check cleared the bank

If you can help us clarify these questions, we would appreciate it.  We are
particularly concerned with how to  populate the CSP60 and CSP61 files,
what values will we need to use?

Thanks for your help.


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.