ISQL: DELETE FROM ExternalTrans
Manually enter in the payments into Emerald that PC Authorize actually
processed (roughly 120 of the 130 transactions).
----- Original Message -----
From: Josh Hillman <email@example.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,
> on Batch Out. After PC Authorize (version 18.104.22.168) 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
> 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.
> 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):
> "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
> 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:
> Reference Number
> Account Number
> Expiration Date
> Address Ver Address
> Address Ver Zip
> Amount, Total
> Customer ID
> Invoice Number
> Reference Number
> Status, Transaction
> Response Text
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: