Re: [Emerald] how do you recover a batch-out

Dale E. Reed Jr. ( (no email) )
Fri, 17 Sep 1999 08:47:48 -0700

Bernard Andrys wrote:
> Had a weird problem yesterday, I think it was user error but I've seen it
> happen before so I'm not sure.
> We're doing a large batch out. The batch-out limit is set to 300 and there
> are 1100 invoices to batch-out. Emerald batch's out and then batch's in the
> first 3 blocks of 300 credit cards but the final "batch-out.txt" is empty.
> It should have contained around 200 entries.
> So now I have 200 un-batched invoices and I'm not sure how to cleanly get
> Emerald to batch those out again. Can I just do an SQL update query to
> change those invoices to type "void"?

Emerald doesn't really matain a "batch" concept for the set of
that it wrote out. It just writes out x records and stops. You can go
into the ExternalTrans table and set the Type value for the records you
need to re-batch to 0, and then go into Emerald and click the batch out
button and it will re-write them. They are time stamped via the ReqDate
field, so you can probably do something like:

Update ExternalTrans
Set Type = 0
Where ReqDate > '9/16/99 10:23'

to get everything after a certain date/time.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: