Aged Payables

[Zak2009]

Hi,

When printing the aged payables report its hanging and not completing.

What could be the reason?

Ver 5.5
sp 2
msql database

Thanks,

 

[DjangMan]

Try running it for a single vendor who has open transactions.

 

[Zak2009]

Thanks.

For certain vendors it does but hangs on particular vendors

 

[ettienne]

What makes you think it hangs?

 

[Jay Converse]

Run RVSPY and SQL profiler. And don't bother cross posting over here, it's the same people with the same answers.

 

[ettienne]

You'll get a bunch of crap irrelevant replies at Toolbox, best to avoid it.

 

[DjangMan]

IIRC, there were problems in the past with the report if the vendor transaction had an apostrophe within a field value (either the document number, reference or description field). e.g. having a vendor invoice number like NUFFY'S.

 

[ettienne]

I think the older versions pre 5.5 suffered from the apostrophe, but it is still worth a check.
I fixed many tables where users entered JAN'14 etc in the document number field.