Re: Automatic Bank Reconciliation

Jim,

Thank you for responding. I found your original request for assistance dated 1/12/01 and saw that you were on the right track with the files that were used and the basic flow. We have populated a test file and have gotten some results but can not seem to get past the fact that the bank account is not being recognized. It looks to me like the physical fiel description might be wrong. It shows all fields as numeric with the exception of NARR1, NARR2, NARR3 and Date. CS482 (which reformats the file CSP51 to CSP50) show most the fields as alphanumeric. And believe it or not, we are trying to work with a service bureau from London, England. We did figure out that the date field had to be 0YYDDD. It converts this date to a Julian date to get the bank's clear date. The transaction Code is a special code that needs to be set up in Cash Manager and does not impact anything else, to our knowledge. I say that knowing the reports also tell us that we are using an invalid transaction
code. We wonder if someone could just verify the physical file structure for us. Once we were sure we were using the right fields, format and data, we could then verify the process.

Again, we appreciate your response and if there is anything we can do to assist in getting some more information, we would be happy to do so.

Thanks again,

Kent

-------------- Original message --------------
From: James.Hawkins@xxxxxxxxxx

Kent,

Where I used to work I was able to make this work, unfortunately that was
nearly 2 years ago in my history since I left there, so I have to work off
of my memory.

We took a flat file from the bank, imported into the /400. From there we
ran a program that stripped out unneeded records and formatted the data
into the csp file. I recall that there was some configuration that
needed to be done.

One of the reasons (I was told from support) that documentation is hard to
come by is that this particular feature was intended for British needs and
not anticipated that it would be used in the states. They didn't know if
it would even work in the states (it does because we used it).
Unfortunately, I don't have access to System 21 anymore so I have to work
off my memory. CSP 50 INP20 and CSP20 are files that come to mind as
being used in this application, but I think that there are a few more. I
would be happy to reply to specific questions you might have. I may have
a few old notes at home, but not sure where they might be.


Thank you,
- Jim

We are trying to utilize System 21 Cash Manager Option - Automatic Bank
Reconciliation. We have not been able to find any documentation and are
in the process of reverse engineering the source code. It looks as though
the physical file layout we have for Bankfile may be in error. If anyone
is using this option, or has advice regarding its set-up, we would
appreciate hearing from you.

Thanks,

Kent Winship
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.