Reprinting AR 5.3a Statements

[SeisaT]

Can anyone help me with regard to the issue of reprinting the statements in AR 5.3a.

I am running into a "Cannot open a CSV file" message sometimes or nothing at all when I try to reprint the statements. I once read somewhere ( have forgotten the source and have been scratching my head to remembr) where it mentioned editing the ARSTCUS table. I think it was mentioning editing the fields "DATELASTST"; "AMTLASTSTT"; "AMTLASTSTH"; "DTBEGBALFW"; "AMTBALFWDT" to replace the values with "0". Now I have tried this but does not seem to resolve my problem of being able to reprint this statements. Are there perhaps other tables that one has to edit also?

Regards,
SeisaT

 

[jayconverse]

If you're getting CSV errors, you're using the version 5.0 format reports. Check your TEMP permissions. Or, switch to the 5.3 format reports.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

Use ARSTMT10.RPT

 

[SeisaT]

Jay,

I thought it would use the 5.0 format reports only if you have checked the appropriate box - i.e "Use Version 5.0 Format" box.

Ettienne,
The Client is using ARSTMDOT.RPT because the printer is a Epson Dot Matrix type and is also using pre-printed stationery. The ARSTMT10.RPT prints lines which does not look good on the pre-printed forms.

Are you both suggesting that I am possibly "barking up the wrong tree" by editing the ARSTCUS table fields indicated in my original thread?

What should I do to reprint the statements because I believe they had responded "YES" to a "Were the Statements printed successfully?" prompt?

Regards,
SeisaT

 

[jayconverse]

Sorry, I've never edited those tables, reprinting has always worked for my clients.

Jay Converse
IT Director
Systemlink, Inc.

 

[SeisaT]

Some additional info that might help.

There are about 650 customers in the AR database and it starts processing right up to the 520th customer before the message "Error accessing CSV file" pops up.

After acknowledging that the 520 customers have been printed successfully, I attempted to reprint them and it starts processing only to come up against another message that reads "There are no records in the specified range". Closing this message only triggers or continues a run which appears to be printing the statement for only one customer repeatedly for about five or six times and then stops.

I am now lost and desparate for help.

Rgds,
SeisaT

 

[SeisaT]

As a matter of fact, I had had to do the Ctrl + Alt + Del > Task Manager > A4WContainer.exe > End Process thing to stop the process of printing. It looks like its reading the customers and will occassionally pop up the message "There are no records in the specified range" when it comes up against certain customers.

Any ideas?

Rgds,
SeisaT

 

[jayconverse]

Run RVSPY, you have dirty data.

Jay Converse
IT Director
Systemlink, Inc.

 

[SeisaT]

Jay,
I ran RVSPY as you suggested but the output is plain Greek to me. Below is an extract from the logfile in particular showing the "Error" message.

[dd0] AR0111: ARSTCUS [17:57:15.38].Fetch(view=0x04c7a5fc)
[dd0] 1 <==[17:57:15.38;t=0;ovh=0] {**ERROR**}
[dd0] 1 <==[17:57:15.40;t=200;ovh=170] {**ERROR**}

Can you perhaps explain what you see in the extract and what it possibly means?

I am now at my wits end.

Rgds,
SeisaT

 

[jayconverse]

Look in the lines prior to *ERROR*, you'll find the last customer number with the problem. Look in the data for embedded delimiters in strings, or nonsensical numerics or dates.

Jay Converse
IT Director
Systemlink, Inc.

 

[SeisaT]

Thank you, will check.

Regards,
SeisaT

 

[SeisaT]

Jay,

I managed to painstakingly single out the Customers who seems to return the message "There are no records in the specified range". I then picked one and ran the RVSPY before printing the statement. There is a "{**ERROR**} remark somewhere in the log message, however couldn't spot the problem.

These particular customers have transactions but all return the same error message.

Can I send you the log for this one customer on your private email and let me know where the problem lies - PLEASE?

Rgds,
SeisaT

 

[jayconverse]

As I said, you have to look inside the data for those customers. I don't have your data, so seeing the errors won't help. Look in ARCUS, AROBL, AROBP, and AROBS.

Jay Converse
IT Director
Systemlink, Inc.

 

[SeisaT]

Jay,

Does the logfile say anything other than the ERROR remark? I thought it might indicate a record or something that is not right with the particular data.

Rgds,
SeisaT

 

[jayconverse]

The log shows you approximately where the error is, you have to figure it out from there.

Jay Converse
IT Director
Systemlink, Inc.