Payment Type on A/R Receipts

Related to the A/R Receipts thread...

It was decided recently that the accountants wanted to know the type of
payment that was received.  The way they decided to mark this was to enter
special values in the Check No. & Deposit Number fields on AMR203 (Cash
Receipt Entry).  The special values and their meanings are:

Ck# 1111111, Dep# 1 ==> American Express
Ck# 2222222, Dep# 1 ==> Visa/MC
Ck# 3333333, Dep# 1 ==> Debit
Ck# 4444444, Dep# 1 ==> Wire

It was thought that the combination of the special values would make it
unlikely in our environment that these four check numbers and the deposit
number would be used for a bank check.  Unfortunately, the deposit number
does not carry over from OPENAR into ARHSTS.

In testing, I tried entering a negative check number.  Enter a '1111111'
followed by a Field-Minus gives '111111J' on the screen, but the value in
the OPENAR file loses the sign and becomes positive.

Does anyone else track receipts by type of payment (as described above)?

Mapics/DB Rel4

TIA, db