ISQL: DELETE FROM ExternalTrans
(130 entries)
Manually enter in the payments into Emerald that PC Authorize actually
processed (roughly 120 of the 130 transactions).
Josh
----- Original Message -----
From: Josh Hillman <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Sent: Thursday, January 06, 2000 5:11 PM
Subject: [Emerald] Batch-in errors in Emerald with PC Authorize
> In Emerald 2.5.322, I ran an auto-batch, then when it was finished,
clicked
> on Batch Out. After PC Authorize (version 1.1.3.0) ran the batch through
> the bank, I exported the batch to a text file. Then I ran "Batch In" from
> within Emerald. It "processed all 130 invoices" or whatever the message
> was, then an error window displayed:
> There were 130 errors, 0 duplicates, and 0 unknown transactions
> processed. Delete batch file anyway? OK/Cancel.
>
> Nothing was actually processed. Why?
> Running Emerald in debug mode didn't show anything other than a select
> statement that didn't change since I opened up the Batch window in the
first
> place.
> Emerald Admin has "PC Authorize" set in the Credit Card Batch setting;
> "none" is set for ACH (what does that stand for?). Limit=0 for both.
What
> is this? Batch-out and Batch-in file specifications are set correctly and
> work correctly.
>
> Here are the first two lines of the batch-out.txt and batch-in.txt files:
>
> batch-out.txt (as created by Emerald):
> "1",4321123412341234,"0601","Customer
Name","66125",32301,19.95,2491,24256,
> "2",5432543254325432,"0601","Some Name","4832",32312,19.95,2521,24257,
>
> batch-in.txt (as created by PC Authorize):
> 000620777400,,AA," ZIP MATCH ",,,,
> 000620777401,,ND," DECLINE ",,,,
>
> It looks to me like the reference number coming from PC Authorize is not
> correlated to the original information in any way.????? All 130
> transactions have "00062077" listed as the first part of the Reference
> Number in the batch-in.txt file (created by PC Authorize). The next
number
> is either a 7 or a 5. The next number is either a 1 or 4 and the last two
> numbers seem to be any number.
>
> Here's the import/export info I have for PC Authorize:
> Import:
> Reference Number
> Account Number
> Expiration Date
> *Filler*
> Address Ver Address
> Address Ver Zip
> Amount, Total
> Customer ID
> Invoice Number
>
> Export:
> Reference Number
> *Filer*
> Status, Transaction
> Response Text
> *Filer*
> *Filer*
> *Filer*
> *Filer*
>
> Josh
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart