When I go to the Undo Facility the transaction is there.

John,

> When I go to the Undo Facility the transaction is there.

In the undo facility, what does it say that the balance of the transaction is there?

-- ---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Gift Card Processing - Now available in Atrex 13

Atrex Electronic Support Options:
Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  

The Balance in Undo is Correct.

John,

> The Balance in Undo is Correct.

Sorry about the delay on this.  I accidentally marked it as replied so it fell off my radar.

One last thing to check that will tell me how to resolve this for you. Run the following query in the "Reports - SQL Query" window and tell me if any rows are returned.

select * from ar where sequencenumber = 0

If there are no rows, I'll have you send me a backup as there is no clear indication as to why it's not showing up.  If there are rows with a sequence number of zero, I'll get you a SQL script that should resolve the issue for you.

-- ---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Gift Card Processing - Now available in Atrex 13

Atrex Electronic Support Options:
Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  

Returned 519 Rows
Be happy to send you a backup if needed.

JOhn ><>


<Terry Swiers - Millennium Software>; <Inc.> wrote in message news:411f5d68$7dcd4d34$26be@H-ATREX...
> John,
>
>> The Balance in Undo is Correct.
>
> Sorry about the delay on this.  I accidentally marked it as replied so it > fell off my radar.
>
> One last thing to check that will tell me how to resolve this for you. > Run the following query in the "Reports - SQL Query" window and tell me > if any rows are returned.
>
> select * from ar where sequencenumber = 0
>
> If there are no rows, I'll have you send me a backup as there is no clear > indication as to why it's not showing up.  If there are rows with a > sequence number of zero, I'll get you a SQL script that should resolve > the issue for you.
>
> -- > ---------------------------------------
> Terry Swiers
> Millennium Software, Inc.
> http://www.1000years.com
> http://www.atrex.com
>
> Gift Card Processing - Now available in Atrex 13
>
> Atrex Electronic Support Options:
> Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
> Email: support@atrex.com
> Newsgroup: news://news.1000years.com/millennium.atrex
> Fax: 1-925-829-1851
> Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
> --------------------------------------- >
>

Returned 519 Rows  Be happy to send you a backup if needed.

John,

> Returned 519 Rows  Be happy to send you a backup if needed.

Not needed.  That tells me what I need to know.

Download and install 13.20 from our web site, if you are not already running that version.  Make a backup, and then run the Batch Processing with the default  options.

I'll be sending you a email with further instructions on how to clean up the rows with a zero sequence number.

-- ---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Gift Card Processing - Now available in Atrex 13

Atrex Electronic Support Options:
Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  

We were at .14 so I backed up, upgraded and ran batch processing.  Still 519 rows.